Normalised records

Normalised records (silver)

Each raw row is parsed into consistently formatted fields. Every change from the raw value is recorded as a data-quality flag.

Normalised rows
99,495
usable in matching
Flagged rows
99,881
99.9% carry at least one flag
Junk quarantined
505
no usable last name
Average quality score
0.75
1.00 = no corrections needed

Quality flags

What normalisation had to do, and how often. Select a flag to filter the table.

Normalised records

Third-party administrator, lowest dq score first

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-56795TPAWei Andrews1953-01-16—82793719329640 Baseline Rd, Glendale, AZ, 853570.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52093TPABradley Schmidt1954-04-16——7492 Camelback Rd, Eden Prairie, MN, 553950.80Name split from “Last, First”Date of birth reformattedState code upper-casedPlaceholder values cleared
TPA-63598TPALisa F Rogers1955-05-21——6526 Park Pl, Los Angeles, CA, 900480.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53570TPAJessica Patel2005-06-16—2145901087—0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51025TPAGloria Bradley2003-07-17——2984 Indian School Rd Apt 10, Scottsdale, AZ, 852960.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-55066TPARuth Hicks1985-02-22—36465437655034 Grand Ave, Houston, TX, 770900.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53922TPAAndrews John1960-09-20——8168 Lincoln Way # 782, Dallas, TX, 752340.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-55549TPARoy Hrat1938-02-10—3053863640241 Forest Ave, San Antonio, TX, 782020.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54517TPAAgela Moreno——91358591515944 Park Pl, Houston, TX, 770010.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58254TPANancy Le1972-11-14UHC-48550-71—6437 Ocean Ave, Fresno, CA, 937300.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58499TPAVincent Reyes2006-10-23UHC-96719-08—8555 Park Pl, Plano, TX, 750160.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-64318TPAMaria Montgomery1955-02-08—6348465003—0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-64377TPAEvelyn Hughes1999-02-26—59726177961327 Sage Ct, Las Vegas, NV, 891540.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58437TPAJudith Gray1951-09-12——5837 Hillcrest Rd, Eden Prairie, MN, 553600.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-54060TPAAaron Campbell1975-11-03——9770 Park Pl, Austin, TX, 787080.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60033TPAKathleen Alvarado2006-09-04—91079865331905 Sage Ct, Columbus, OH, 432260.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-61353TPAKathryn Jordan1963-06-15——5080 Sunset Blvd, Charlotte, NC, 282150.80City re-casedState name converted to codeEmail lower-casedWhitespace trimmed
TPA-58489TPATim Henry1955-01-07—3277416921—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-62105TPAJason Scott1950-04-03———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61325TPAThomas Marshall1967-10-28——9589 Desert Sky Blvd, Eden Prairie, MN, 553970.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53224TPAPauul Hamilton1979-04-27——3908 Maple Ave, Los Angeles, CA, 900640.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-53225TPAPauul Hamilton1979-04-27——3908 Maple Ave, Los Angeles, CA, 900640.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-51625TPAKathryn Wang2007-01-19—32757166847432 Mountain View Dr, Chandler, AZ, 852160.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62657TPAJeffrey Sandoval1978-12-01——1622 Lincoln Way, Columbus, OH, 432260.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55657TPAJezse Lopez1970-12-28—94276979901244 Oak St, Tempe, AZ, 852150.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63873TPAGary Matthews1945-11-13——3179 Indian School Rd, Los Angeles, CA0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-60756TPAJacob N Gonzales2003-01-01———0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-60757TPAJacob N Gonzales2003-01-01———0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-50541TPAMaria Washington1968-08-24——1478 Bayshore Dr, Sacramento, CA, 958590.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61569TPABarbara E Dun2007-01-04——8620 Cedar Ln, Miami, FL, 331980.80Email lower-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61458TPANathan Turner1976-03-05——8594 Palm Dr, Mesa, AZ, 852850.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63464TPAEric Harris1989-03-15—90377205712516 Ridge Rd, Los Angeles, CA, 900640.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51155TPANoah Lawrence1965-07-20—2895613596169 Baseline Rd, Minneapolis, MN, 554430.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-63964TPALauren Medina1962-06-02—74584147132179 Bayshore Dr, Phoenix, AZ, 850860.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62225TPARalph N Larson1978-06-24——4382 Sage Ct, Atlanta, GA0.80Name re-casedDate of birth reformattedZIP missingPlaceholder values cleared
TPA-61047TPAAaron Lopez2003-04-10——2613 Palm Dr, Fresno, CA, 937850.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-52982TPABradley Taylor1977-02-24——4774 Meadow Ln, Plano, TX, 750450.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58532TPAIzabella Walsh1979-06-04——8165 Camelback Rd, Orlando, FL, 328270.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-52105TPALauren James1965-04-05—38975902179798 Main St, Tucson, AZ, 857320.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-51836TPAJanet Ross2007-08-11——4119 Bayshore Dr, Charlotte, NC, 282510.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59677TPARaymond Ford1987-12-19—9214215096—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60655TPAValentina Harvey1943-03-28—27088633457433 Broadway, Scottsdale, AZ, 852610.80Name re-casedPhone reformattedAddress re-casedGender normalised
TPA-64194TPADiane Gordon1974-08-21—24234524349110 Camelback Rd, Dallas, TX, 752110.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-62483TPABrucce G Evans1965-11-07——6479 River Rd, Denver, CO, 802500.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-53801TPARalph Gonzalez1942-03-16——6584 Bayshore Dr, Dallas, TX, 752180.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-56056TPAAlice Baker1952-04-16——2666 Church St, Gilbert, AZ, 852110.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63697TPASofia S Web1960-12-02——265 Ridge Rd, Tampa, FL, 336450.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-63819TPATeresa Munoz1949-05-17UHC-73954-80—4514 Broadway, Orlando, FL, 328680.80Name split from “Last, First”Member ID reformattedAddress re-casedPlaceholder values cleared
TPA-64444TPAJoyce W Henry1995-02-16UHC-60364-7777357582457448 Cedar Ln, Chandler, AZ, 852700.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-52640TPAJack Andrews1957-02-02UHC-93954-8834380885163279 Forest Ave, Plano, TX, 750440.80Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
14,474 rows, page 171 of 290PreviousNext