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-53304TPARoger White1948-08-05——1413 Meadow Ln, Miami, FL, 331350.78Name re-casedDate of birth reformattedCity re-casedGender normalised+1 more
TPA-55634TPASantiago Dominguez1998-11-18—31239357972418 Sunset Blvd, Seattle, WA, 981770.78Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-60552TPAChristine Phillips2005-12-25———0.78Date of birth reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more
TPA-53272TPAAmy Vasquez1951-04-14——5795 Maple Ave, Glendale, AZ, 853350.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-63867TPAJarry Roberts2005-11-21UHC-19892-5951988628698059 Valley View Dr, Scottsdale, AZ, 852720.78Name re-casedPhone reformattedMember ID reformattedGender normalised+1 more
TPA-52009TPAAndrew Arnold1988-09-26——3704 Spring St, Tampa, FL, 336060.78Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-58740TPALawrence U Smith1964-03-19UHC-22685-398889655008259 Central Ave, Orlando, FL, 328770.78Phone reformattedMember ID reformattedState name converted to codeEmail lower-cased+1 more
TPA-56993TPARyan Carlson1942-06-11—54634019844516 Harbor Blvd, Eden Prairie, MN, 553260.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60146TPAMichelle Gordon1948-04-16UHC-80137-396884293271470 Valley View Dr, Houston, TX, 770490.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55050TPAAnthony Guerrero1972-11-10—26229204006030 Main St, Austin, TX, 787330.78Two-digit birth yearPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-55348TPAEugene B Ortiz1992-06-02UHC-22443-9775178799838364 Broadway, Tucson, AZ0.78Phone reformattedCity re-casedZIP missingWhitespace trimmed+1 more
TPA-54996TPASandra Clark1967-09-06—26235031559762 Apache Blvd, Gilbert, AZ, 852600.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55949TPANoah Padilla1984-09-20——5201 Highland Ave, Austin, TX, 787740.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-50995TPAJoyce O Carlson1979-11-25——9366 Indian School Rd, Glendale, AZ, 853000.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55715TPABenjamin Chen1976-09-15—65676460351923 River Rd, Seattle, WA, 981420.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63723TPAJudith Hernandez1964-01-21——1992 Church St, Columbus, OH, 432370.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58639TPAJesse Harrison1973-10-28UHC-23309-57—8794 Meadow Ln, Nashville, TN, 372490.78Name re-casedTwo-digit birth yearPlan code upper-casedWhitespace trimmed+1 more
TPA-53071TPAArthr Hernandez2003-08-06——9506 Washington St, Mesa, AZ, 852980.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-59556TPALori K Soto1956-09-26——9248 Harbor Blvd, Tampa, FL, 336690.78Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-62611TPAEdward Shaw1980-02-19—5336805777—0.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-57742TPADennis Parker1972-05-03———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-60682TPARandy Hall1982-01-27—32698365378707 Valley View Dr, Phoenix, AZ, 850040.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53289TPADonna Ward1967-03-16—3195752966924 Lincoln Way, Las Vegas, NV, 891330.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62749TPAJeremy Maldonado1966-10-02——629 Oak St, Los Angeles, CA, 900260.78Date of birth reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-57105TPAAlan Maldonado1940-09-18—96486407403947 Willow Ct, Fresno, CA, 937600.78Name re-casedPhone reformattedCity re-casedState name converted to code+1 more
TPA-62915TPAMarcus Turner1939-12-12—78846049738916 Palm Dr, San Antonio, TX, 782570.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52541TPAMelissa D Campbell1984-05-03—40793190799465 Sage Ct, Tucson, AZ, 857390.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61263TPALauren Simmons1991-10-26UHC-04808-71—2970 Willow Ct, Chandler, AZ, 852830.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-58034TPABrandon Reid1968-11-07———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-51103TPAWei Clark2007-07-01—73520678631609 Jefferson Ave, Chandler, AZ, 852280.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-60735TPAPeter Alvarez1972-06-19UHC-28455-24—1142 Church St, Tempe, AZ, 852630.78Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-59018TPABruuce Perkins1973-10-17UHC-27600-51—8366 Lake View Rd, Los Angeles, CA, 900480.78Name re-casedCity re-casedState name converted to codeEmail lower-cased+1 more
TPA-64473TPAEugene Daniels1994-02-05UHC-59501-35—9891 Oak St, Mesa, AZ, 852320.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52285TPADorothy Gray1945-08-20—79766347769607 Meadow Ln, Las Vegas, NV, 891550.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55203TPATyler Ward1972-08-16——421 Church St, Miami, FL, 331530.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52797TPAYuki Perry1986-12-26——2416 Indian School Rd, San Antonio, TX, 782990.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60087TPALogan Simmons1959-06-11UHC-67698-2892479511548239 Forest Ave, Fresno, CA, 937860.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58978TPAHelen Dominguez2000-05-20——320 Pine Dr Apt 2, Eden Prairie, MN, 553690.78Name re-casedUnit split from streetState code upper-casedWhitespace trimmed+1 more
TPA-61447TPAMarcus Foter1961-09-23——4649 Park Pl, Denver, CO, 802770.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-60583TPAYuki Evans1984-12-08UHC-57726-0381133632078031 Broadway, San Antonio, TX, 782270.78Phone reformattedMember ID reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-59779TPALuis Tucker1953-09-13UHC-25918-1731535569754409 Hillcrest Rd, Atlanta, GA, 303070.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60394TPAMei Carter1992-06-24——635 Highland Ave, Houston, TX, 770550.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59726TPAAisha Mejia1962-08-28——3732 Hillcrest Rd, Jacksonville, FL, 322560.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59971TPAAna J Rice1967-05-27—30361134992102 Grand Ave, Chandler, AZ, 852320.78Date of birth reformattedPhone reformattedCity re-casedGender normalised+1 more
TPA-59817TPAJoyce Mendez1966-04-10——1468 Sage Ct, Phoenix, AZ, 850780.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61888TPAAlan Gibson1988-02-12—80952232358041 Mesa Dr, Los Angeles, CA, 900510.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57259TPAValentina Aguilar1943-05-19—23860953224653 River Rd, Glendale, AZ, 853760.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53679TPAAshly Olson1946-05-10——5864 Willow Ct, Gilbert, AZ, 852390.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55632TPACamila Baker1946-03-09—9009578885815 Ocean Ave, Las Vegas, NV, 891950.78Name split from “Last, First”Phone reformattedState code upper-casedWhitespace trimmed+1 more
TPA-53779TPAHarold Bailey1980-08-05——2892 Maple Ave, Tucson, AZ, 857560.78Name re-casedDate of birth reformattedCity re-casedGender normalised+1 more
14,474 rows, page 140 of 290PreviousNext