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-53460TPAJose Perry1967-07-03—91569355617548 Mountain View Dr, Fresno, CA, 937490.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57490TPAPamela Hill1982-04-20——6733 Hillcrest Rd, Charlotte, NC, 282810.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57128TPAJoyce Hanson1944-01-14——2684 Grand Ave, Plano, TX, 750620.76Name re-casedDate of birth reformattedCity re-casedState name converted to code+2 more
TPA-53539TPAAngela Salazar1979-06-05—69964129685809 Mountain View Dr, Minneapolis, MN, 554060.76Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+2 more
TPA-53251TPAMadison Moreno1969-01-04——3424 Jefferson Ave, Fresno, CA, 937030.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-59727TPAGloria Obrien1970-10-23—3227351204—0.76Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more
TPA-50106TPAElijjah Pena1997-07-20—63742860057649 Union St, Tucson, AZ, 857940.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-57922TPAJohnny Hicks1965-03-05——5013 Sage Ct, Miami, FL, 331760.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52608TPAVictoria Webb1951-07-08UHC-59648-0151868709441681 Desert Sky Blvd, Miami, FL, 331230.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56808TPAKatherine Hawkins2002-12-12——7014 Valley View Dr, Austin, TX, 787880.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57121TPAGreen Charlotte1946-08-06—95022104144490 Valley View Dr, Minneapolis, MN, 554490.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54203TPAAnthony Graham1963-10-09—97875318108414 Highland Ave, Las Vegas, NV, 891650.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-54778TPACharles Dunn1993-10-24UHC-26801-8596081533724956 Meadow Ln, Columbus, OH, 432880.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63658TPAOmar Miller1974-07-20—56341262566937 Main St, Phoenix, AZ, 850020.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58431TPAJoyce Reid1965-10-13UHC-05392-1034672669793296 Sunset Blvd, Scottsdale, AZ, 852410.76Street suffix standardisedAddress re-casedState code upper-casedEmail lower-cased+2 more
TPA-50009TPAMartha V Stone1952-05-13UHC-83497-59—776 Oak St, Eden Prairie, MN, 553320.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56079TPARoger Stewart1968-02-21—92179887356205 Sage Ct, Scottsdale, AZ0.76Name re-casedDate of birth reformattedZIP missingEmail lower-cased+2 more
TPA-54443TPAIsabella Le1954-04-14—92981766397791 Desert Sky Blvd, Orlando, FL, 328460.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59797TPAValentina Ramos2004-07-21—31226965158972 Oak St, Fresno, CA, 937500.76Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-64028TPAChristine Cooper1963-04-27—83667672364649 Camelback Rd, Tampa, FL, 336460.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58355TPAAdam W Ortega1967-06-08——8102 Mountain View Dr, Orlando, FL, 328550.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-50434TPAHeather Lopez1941-12-08—54063161832352 Ridge Rd, Seattle, WA, 981220.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60237TPABrittany Sandoval1970-02-25UHC-22787-33—9784 Jefferson Ave, Charlotte, NC, 282530.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52722TPAJacob Kim1988-11-28—6176643822—0.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-58427TPAJoan Taylor1970-01-11—8259749480320 Apache Blvd, Scottsdale, AZ, 852940.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61870TPAKatherine Silva1966-01-18—38474630143394 Palm Dr, Tucson, AZ, 857920.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55901TPAElizabeth S Tucker1945-01-16—69263991355669 Meadow Ln, Minneapolis, MN, 554960.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52504TPAHelen V Lynch1940-04-19—7927927574465 Highland Ave, Fresno, CA, 937210.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63372TPAJeffrey A George1955-06-26—78245735995231 Apache Blvd, Austin, TX, 787240.76Date of birth reformattedPhone reformattedCity re-casedZIP+4 trimmed+2 more
TPA-59917TPAGabriel Cox1994-08-17——3550 Willow Ct, Scottsdale, AZ, 852170.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51456TPAJohn Palmer1951-07-24—91978984042782 Park Pl, Orlando, FL, 328820.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64038TPARyan Butler2000-07-04UHC-03130-9338756058628043 River Rd, Tucson, AZ, 857650.76Phone reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
TPA-50376TPABobby Ryan1985-01-27—51496773398076 Pine Dr, Tucson, AZ, 857530.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53081TPAJudith Hamilton1971-03-26—86096810243677 Washington St, Tempe, AZ, 852810.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62217TPARoy Burns1996-01-06——1170 Church St, Denver, CO, 802960.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51595TPASarah Alvarado1963-04-16—2095581648—0.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-52497TPAJackie Fowler1999-12-16UHC-41947-43—1885 Central Ave, Jacksonville, FL0.76Date of birth reformattedCity re-casedZIP missingPlan code upper-cased+2 more
TPA-61501TPAKayla Cole2008-02-27——2740 Highland Ave, Nashville, TN, 372760.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61267TPACharlotte Nichols1970-05-19—81482440593495 Market St, Columbus, OH, 432090.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62426TPASophia Rojas1999-11-18—34672499674947 Mesa Dr, Nashville, TN, 372990.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62111TPAKaren Foler1990-05-23——1888 Forest Ave, Tampa, FL, 336460.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55891TPANicholas Gibson2005-05-25UHC-22877-52—8407 Ocean Ave, Austin, TX, 787180.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50840TPACarl Young1960-02-05—88975552206285 Valley View Dr, San Diego, CA, 921150.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-61939TPAKyle Cook1963-06-20—94721634958422 Hillcrest Rd, Tampa, FL, 336710.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51356TPAAmanda Fox1992-11-01—8467912571324 Highland Ave, Eden Prairie, MN, 553320.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60813TPAKenneth Reynolds1947-05-04——1528 Jefferson Ave, Gilbert, AZ, 852110.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-64259TPAAtrhur Guerrero1959-07-27——1737 Highland Ave, Austin, TX, 787490.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56719TPATeresa Alvarado1974-07-25—31566994365002 Union St, Eden Prairie, MN, 553390.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56316TPACheryl Jacobs1974-07-10—83525380818057 Harbor Blvd, Minneapolis, MN, 554390.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60471TPAEvelyn Hansen1971-05-08——3438 Lake View Rd, Las Vegas, NV, 891150.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 126 of 290PreviousNext