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

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-58620TPANick Bailey1999-12-18———0.82Phone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-61487TPAAaron Morales1966-04-21—7386813351840 Main St # 946, Atlanta, GA, 303150.82Phone reformattedUnit split from streetPlaceholder values cleared
TPA-58078TPASean Stephens1979-08-26——9699 Indian School Rd, Mesa, AZ, 852580.82Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-53290TPAMichelle Anderson1945-08-13——3733 Ocean Ave, Los Angeles, CA, 900280.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63122TPARobert Brooks1999-02-24——5314 Palm Dr, Fresno, CA0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-52578TPAMary Fields1988-03-05UHC-83147-55——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-60926TPAKeith Silva1987-02-11———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-57458TPACamila Daniels1945-06-13—54260172942438 Sage Ct, Phoenix, AZ0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-62715TPAJacqueline Schultz1979-10-11——2368 River Rd, Columbus, OH, 432560.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62337TPAChristian Bradley1978-08-23UHC-55052-609834298798—0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-55491TPALarry Johnson1959-06-10UHC-47867-04—440 Desert Sky Blvd, Charlotte, NC0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-61610TPAGJunk1978-02-04——3675 Sage Ct, Tucson, AZ, 857800.82Date of birth reformattedPlaceholder values clearedNo usable name (quarantined)
TPA-57479TPASantiago Lynch1998-06-15——2281 River Rd, Las Vegas, NV, 891170.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58511TPAChristopher Perkins1980-12-20UHC-86844-01—262 Ridge Rd, Atlanta, GA, 303920.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-61091TPACamila Hanson2008-01-09—91339896639600 Lincoln Way, Nashville, TN, 372560.82Phone reformattedState name converted to codePlaceholder values cleared
TPA-52418TPAGrace Ramos1989-10-27——8508 Maple Ave, Minneapolis, MN0.82State code upper-casedZIP missingPlaceholder values cleared
TPA-58623TPAOmar Sims1975-08-14—92958620612190 Grand Ave, Denver, CO, 802320.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
TPA-62390TPARachel Yang1945-11-12—38173674962921 Palm Dr, Denver, CO, 802430.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-62868TPAOmar Gonzales1974-03-09———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-50374TPALori Q Warren1976-12-09——4758 Highland Ave, Los Angeles, CA, 900650.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60719TPADiane Dominguez1946-08-06—97898589849605 Union St, Sacramento, CA, 958620.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-62064TPAIsabella George1988-11-27——9793 Lake View Rd, Austin, TX, 787660.82Date of birth reformattedPhone missing area codePlaceholder values cleared
TPA-61354TPAWillie Richardson1974-11-11——1339 Cedar Ln, Austin, TX, 787030.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57456TPAMichelle Andrews1993-08-24—23778711996315 Highland Ave, Orlando, FL, 328740.82Phone reformattedState name converted to codePlaceholder values cleared
TPA-64227TPALisa Graham1951-12-26——4093 Ridge Rd, Tampa, FL, 336710.82Name split from “Last, First”City re-casedPlaceholder values cleared
TPA-63766TPALarry Carter1981-10-14—38978840611439 Maple Ave, Scottsdale, AZ, 852560.82Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-53952TPAArjun Flores1978-12-09—43640895082271 Elm St, Chandler, AZ, 852150.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-57897TPAKeith U Myers1973-09-21———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-60161TPAAmanda Cole2005-10-28UHC-20244-98——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-59075TPAAnna Santos1975-12-04UHC-15152-91—6959 Desert Sky Blvd, Gilbert, AZ, 852340.82Member ID reformattedZIP+4 trimmedPlaceholder values cleared
TPA-64336TPAJoe Stevens1952-07-16——6977 Apache Blvd, Seattle, WA, 981740.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-61472TPAIsabella R Ferguson1995-12-16——2535 Park Pl, Gilbert, AZ, 852790.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58949TPAJean G Martin1980-08-25———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-51632TPAJustin Hansen1988-07-23——7600 Cedar Ln, Phoenix, AZ0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-54331TPAKathleen O Williaamson1964-11-04UHC-41645-1494180566807680 Indian School Rd, Charlotte, NC, 282440.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-59493TPAAustin Bishop———3168 Central Ave, Phoenix, AZ, 850140.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-50707TPACynthia Perkins1964-04-13———0.82Phone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-52056TPAAisah Robinson1990-08-11—54239571559227 Canyon Rd, Chandler, AZ, 852510.82Name re-casedStreet suffix standardisedAddress re-cased
TPA-52899TPAMateo B Castro1969-09-04—61025965819205 Apache Blvd, Phoenix, AZ, 850690.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-55522TPACharlotte F Bryent—UHC-22651-59——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-50155TPABobby Gilbert2001-02-27——6310 Grand Ave # 240, Dallas, TX, 752530.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-52100TPAAlbert Espinoza1962-06-23——2343 Central Ave, Plano, TX, 750500.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52516TPAElizabeth Williamosn1965-10-08——2551 Sunset Blvd, San Antonio, TX, 782930.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57303TPAFrnk Kelley1942-02-28UHC-40168-9242241298734477 Sunset Blvd, Jacksonville, FL, 322040.82City re-casedState name converted to codeWhitespace trimmed
TPA-54156TPARoy Crawford1991-07-27——6673 Oak St, Seattle, WA, 981750.82Name re-casedState name converted to codePlaceholder values cleared
TPA-57865TPAAmy Ferguson1944-01-22UHC-39422-02—3896 Camelback Rd, Tucson, AZ, 857570.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-56673TPAWei Carr1977-01-10——174 Mesa Dr, Jacksonville, FL, 322690.82Street suffix standardisedAddress re-casedWhitespace trimmed
TPA-52190TPARachel Wheeler1970-12-18———0.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-55429TPAWarren Priya1987-11-26———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-52502TPAGrace A Kennedy1952-02-07——3820 Indian School Rd, Fresno, CA, 937540.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 200 of 290PreviousNext