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-64317TPAJennifer Hoffman1972-11-17——6889 Elm St, Minneapolis, MN, 554750.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-52366TPAAndrew Burke1989-01-28—37189418537038 Bayshore Dr, Austin, TX, 787080.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59393TPARobert Martinez1988-09-05—28734507913358 Cedar Ln, Houston, TX, 770530.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54817TPARichard Vasquez1944-10-03——8197 Lake View Rd, Plano, TX, 750230.76Name re-casedDate of birth reformattedCity re-casedGender normalised+2 more
TPA-59553TPAAlan Bradley1971-09-10—44951704825458 Oak St, Tampa, FL, 336330.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50014TPAMaria S Herrera1985-06-09—74495104457559 Pine Dr, Tampa, FL, 336150.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52501TPATerry Snyder1989-08-09—7997296005—0.76Name re-casedPhone reformattedEmail lower-casedGender normalised+2 more
TPA-60901TPAMara Robinson1938-05-19—42074103297834 Apache Blvd, Plano, TX0.76Date of birth reformattedPhone reformattedCity re-casedZIP missing+2 more
TPA-53080TPAJerry Fields2007-01-11——8454 Bayshore Dr, Nashville, TN, 372250.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55444TPACharles Soto1980-10-08——833 Jefferson Ave, Eden Prairie, MN, 553520.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51515TPAWillie Torres1979-07-09——3439 Valley View Dr, Tampa, FL, 336030.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55801TPARoy Smith1945-01-07——5453 Market St, Scottsdale, AZ, 852830.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53874TPAGloria V King1974-01-14—51229208119840 Spring St, Houston, TX, 770550.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61313TPAPriya Dean1945-05-26—68236893979490 Central Ave, Tempe, AZ, 852200.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55688TPAGloria Vega1985-09-07UHC-96575-0446673807368522 Union St, Plano, TX, 750140.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56566TPARebecca Bailey1986-12-20——1884 Willow Ct, Jacksonville, FL, 322140.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-61056TPARussell Rogers1989-10-26——2184 Grand Ave, Nashville, TN, 372480.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50181TPAHeather Hunt2001-05-18——4288 Baseline Rd, Sacramento, CA, 958900.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56255TPAJohn J Lawson1986-10-27UHC-24203-26—3416 Washington St, Tempe, AZ, 852890.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62652TPADiana Mills1972-11-19—85176418267835 Broadway Apt 25, Atlanta, GA, 303420.76Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+2 more
TPA-52784TPAJanice Ellis1972-04-17——8233 Valley View Dr, Seattle, WA, 981530.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-58333TPAHeather Williamson1954-09-11—90935923633052 Valley View Dr, Chandler, AZ, 852410.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-50435TPAChristian Knight1939-09-07—28848292345667 Broadway, San Antonio, TX, 782040.76Name re-casedDate of birth reformattedPhone reformattedAddress re-cased+2 more
TPA-57767TPAMateo Willis2002-03-22——9421 Mesa Dr, Atlanta, GA, 303000.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-56296TPAJose Lopez2001-01-13UHC-63472-9741028475681260 Elm St, Plano, TX, 750120.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-52644TPADouglas Walker1961-03-24——4492 Meadow Ln, Sacramento, CA, 958240.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61849TPADeborah Martin1956-07-01UHC-52139-04—8438 Ridge Rd, Houston, TX, 770770.76Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51267TPAChirstine Weaver1986-04-05—23745260839496 Lincoln Way, Chandler, AZ, 852690.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58273TPAPaul White1995-03-22——3950 Elm St, Seattle, WA, 981320.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-50512TPAJerry West2005-09-21——5719 Willow Ct, Chandler, AZ, 852780.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56759TPAValdez Mariana1983-11-22—91426667281961 Apache Blvd, Dallas, TX, 752670.76Phone reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
TPA-57370TPAMichael Simmoons1994-02-27—39483789153978 Broadway, Houston, TX, 770780.76Name re-casedTwo-digit birth yearPhone reformattedAddress re-cased+2 more
TPA-53445TPAAaron Richardson2005-03-08UHC-17201-1769532556267110 Indian School Rd, Houston, TX, 770770.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-55473TPABevelry Padilla1988-12-19—6967591907404 Park Pl, Denver, CO, 802560.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57009TPAJordan Bailey1963-06-28UHC-61063-87—7325 Harbor Blvd, Eden Prairie, MN, 553130.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58809TPAMaria Holmes1944-06-28——3447 Desert Sky Blvd, Tempe, AZ, 852900.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61567TPABarbara Dunn2007-01-04—42539544878620 Cedar Ln, Miami, FL, 331980.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56240TPARalph Cole1964-06-11—25187141109782 Valley View Dr, Tucson, AZ, 857780.76Date of birth reformattedPhone reformattedCity re-casedGender normalised+2 more
TPA-54339TPAJose Carter1996-09-11——9314 Jefferson Ave, Jacksonville, FL, 322810.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51115TPARussell U Lee1958-12-22—51382341613177 Grand Ave, Columbus, OH, 432440.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59898TPAMark Perez1962-05-13——8922 Canyon Rd, Los Angeles, CA, 900890.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56325TPALuis Miller1998-03-25—37648624656417 Apache Blvd, Fresno, CA, 937950.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61348TPAGerald Mendez1963-01-11—42852496394300 Mountain View Dr, Nashville, TN, 372100.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58977TPAVictoria Campbell1950-12-06—44568980501779 Cedar Ln, San Antonio, TX, 782690.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58666TPALisa Y Young1964-10-21——2499 Elm St, Fresno, CA, 937770.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-51753TPASophia Dixon2005-06-24—80458519536679 Main St, Glendale, AZ, 853490.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62277TPASean Kelly2003-08-08——4766 Grand Ave, Eden Prairie, MN, 553070.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57589TPARussell Lucas1973-06-11——8307 Indian School Rd, Seattle, WA, 981740.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60949TPACarolyn Adams2007-05-26—92933211326899 Church St, Columbus, OH, 432970.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56057TPADyylan Andrews1961-11-08—80689064667202 Washington St, Sacramento, CA, 958790.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 118 of 290PreviousNext