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-62428TPAYuki M Richardson1994-01-22—7038504062—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52399TPAKeih Sanchez1959-08-17—60133694004800 Ocean Ave, Houston, TX, 770770.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
TPA-58777TPAJacob Rios2001-09-28———0.92Name re-casedDate of birth reformattedEmail lower-casedPlaceholder values cleared
TPA-64129TPADiego Ellis1977-03-18—2232599124—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56630TPADennis Mendoza1983-03-10—97485074832596 Ocean Ave, Phoenix, AZ, 850160.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
TPA-57577TPAFrances A Hill1966-07-26—57363574297104 Jefferson Ave, Scottsdale, AZ, 852370.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58681TPAChristine Morgan2007-09-01——469 Pine Dr, Austin, TX, 787590.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-50077TPATeresa Franklin2006-09-27UHC-79947-4649650560804892 Broadway, Orlando, FL, 328960.92Date of birth reformattedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57975TPARichard Harrison1987-09-11——3041 Broadway, Atlanta, GA, 303640.92Name re-casedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-62882TPALauren Brown2002-02-20UHC-26064-4854442213284201 Lincoln Way, Glendale, AZ, 853150.92Phone reformattedCity re-casedState code upper-casedPlaceholder values cleared
TPA-52592TPARoy Harrison1975-08-21—79998028114717 Camelback Rd, Minneapolis, MN, 554680.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-53333TPAWillie Robinson1992-04-01—5023689952—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61008TPALuis N Cole1976-05-18—51274296011216 Grand Ave, Charlotte, NC, 282790.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54875TPATimothy Jones1952-03-04——4271 Harbor Blvd, Phoenix, AZ, 850490.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-58261TPASam J Oliver1968-03-01—58092949183743 Church St, Houston, TX, 770890.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57574TPACarlos I Berry1980-07-27—90232425322017 Palm Dr, Mesa, AZ, 852950.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52198TPAChristopher Cunningham1946-04-04UHC-92637-642956630065—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52197TPAChristopher Cunningham1946-04-04UHC-92637-642956630065—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51374TPASamantha Sandoval2000-06-18———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52803TPABrian Torres1986-09-09—33982992879749 Lincoln Way, Columbus, OH, 432050.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63124TPABob Brooks1999-02-24—5805595575—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55870TPABruce Murray1994-10-11UHC-95825-792893072986—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-56475TPAWei Dunn1946-05-02—37561217026309 Lincoln Way, Plano, TX, 750410.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-64138TPANicloe Arnold1953-06-26—9375571813—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54707TPACarl Gilbert1966-08-23—57832260692361 Camelback Rd, San Diego, CA, 921860.92Date of birth reformattedPhone reformattedState code upper-casedPlaceholder values cleared
TPA-59704TPAJulie Watkyns2000-07-10—64682862323982 Sunset Blvd, Mesa, AZ, 852960.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56968TPAJudith Sullivan2008-10-22—38077466073145 Willow Ct, Tampa, FL, 336740.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51337TPARalph Shaw1955-09-18—8135007335—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57034TPAPat Robertson1950-12-23———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59591TPAOlivia Howard1976-06-04———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54502TPAAngela Diaz1982-06-06——87 Park Pl, Sacramento, CA, 958580.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-56256TPAEmma Hudson1975-12-12——5153 Sunset Blvd, Phoenix, AZ, 850850.92Name re-casedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-62563TPAKathleen Myers1952-10-16—55441036261268 Main St, Houston, TX, 770790.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-57096TPAGloria Miller1988-09-11UHC-04119-6831536755777263 Cedar Ln, Columbus, OH, 432880.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53880TPALawrence Gutierrez1943-12-13——3482 Jefferson Ave, Columbus, OH, 432680.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50121TPALauren Castro1964-01-22—66750559982191 Pine Dr, Sacramento, CA, 958120.92Date of birth reformattedPhone reformattedEmail lower-casedWhitespace trimmed
TPA-61877TPAPhilip Johnston1966-07-26UHC-61230-276842415710—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62864TPANathan Greene1999-07-11—7433653209—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51712TPAAmanda Hanson1940-10-01—35583538744271 Park Pl, Denver, CO, 802880.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53484TPAAlexis Burton1975-10-05———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57784TPAJoshua V Snyder1948-08-02———0.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-56658TPACharles Burke1955-11-08——5211 Sunset Blvd, Atlanta, GA, 303540.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57098TPAJeremy Z Williamson2001-05-09———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58343TPAKayla Garrett1993-01-02—59527114003765 Desert Sky Blvd, Fresno, CA, 937730.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-59096TPAAndrew Bradley1951-04-22———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52505TPAHelen Lynch1940-04-19—79279275744496 Meadow Ln, Miami, FL, 331470.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61693TPALisa Cook1967-04-15——8671 Pine Dr, Austin, TX, 787980.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55519TPAJason E Gutierrez1971-06-19UHC-26533-02—4563 Mesa Dr, Glendale, AZ, 853020.92Name re-casedMember ID reformattedCity re-casedPlaceholder values cleared
TPA-59428TPANatalie Morgan1984-06-10—8957775802597 Washington St, Miami, FL, 331110.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54573TPASofia Porter1971-07-26—5948765195—0.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 237 of 290PreviousNext