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-58938TPADiana Park1996-05-28UHC-17088-1998170428826071 River Rd, Fresno, CA, 937460.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
TPA-53657TPAJessica Vgea1967-09-05—76887603698510 Ridge Rd, Dallas, TX, 752250.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55192TPAAndy Evans1988-10-25——4471 Desert Sky Blvd, Nashville, TN, 372430.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-64020TPAKyle Oliver1974-12-19——16 Mesa Dr, Minneapolis, MN, 554280.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-63802TPABruce Garrett1962-07-12—8223304412—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58748TPAAlbert Jacobs1994-07-04——1538 Lake View Rd, Seattle, WA, 981750.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-63074TPAAlexis Armstrong2004-09-05—45660339239668 Lincoln Way, Scottsdale, AZ, 852120.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54010TPAEmma Robertson1974-03-04———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-55199TPAAnn Hayes1987-03-12———0.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-58003TPAShirley Le2002-03-28—91480775557260 Market St, Mesa, AZ, 852200.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56377TPAMatt X Kelly1941-12-05—3675691046—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63145TPAEric A Burke1976-06-20——5360 Valley View Dr, San Diego, CA, 921940.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-52661TPALinda Fernandez1982-04-06———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-54185TPAAlbert Hayes1944-07-03———0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56638TPAGabriel Howell1946-12-15—8199638881—0.94Name re-casedEmail lower-casedPlaceholder values cleared
TPA-54316TPACharlotte Mills1978-05-22——352 Ridge Rd, Tempe, AZ, 852510.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-55759TPASean Berry1969-09-12—4473950926—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62244TPABeverly Padilla1940-02-20———0.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-52555TPAAisha Griffin2005-09-04——5361 Elm St, Chandler, AZ, 852290.94City re-casedWhitespace trimmedPlaceholder values cleared
TPA-51740TPAJudy Gomez1977-08-18UHC-18172-2994025049718411 Canyon Rd, Orlando, FL, 328400.94Phone reformattedCity re-casedEmail lower-cased
TPA-55758TPASofia Lewis1938-03-27——3032 Valley View Dr, Mesa, AZ, 852610.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-57390TPAAdam Li1945-01-18———0.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-60169TPAOlivia Tucker1946-05-01—5856017147—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61790TPAAnthony S Jordan1979-03-14—70969746306601 Willow Ct, Mesa, AZ, 852840.94Name re-casedPhone reformattedPlaceholder values cleared
TPA-61071TPACynthia McDonald1972-05-10——1243 Bayshore Dr, Denver, CO, 802650.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-61207TPAJason Hansen1991-12-27———0.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-57728TPAWillie Castillo2001-08-10——1942 Washington St, Las Vegas, NV, 891640.94City re-casedWhitespace trimmedPlaceholder values cleared
TPA-61095TPAElizabeth Richardson1994-01-12——7983 Park Pl, Sacramento, CA, 958580.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-51647TPATimothy Burke1988-05-14—7362722708—0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-50349TPAMichael Butler2004-03-21——3099 Mesa Dr, San Diego, CA, 921450.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-50182TPABarbara Lynch1997-05-10———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-52955TPAJean Hansen1939-04-20——8068 Spring St, Denver, CO, 802010.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-57369TPAJsoeph G Stephens1976-06-10———0.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-64359TPAHenry Cole2008-09-27——1503 Baseline Rd, Chandler, AZ, 852570.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-55193TPAMary Guerrero1980-09-18—5667613381—0.94Name re-casedPhone reformattedPlaceholder values cleared
TPA-60836TPAKimberly Austin1982-01-28——1515 Maple Ave, Nashville, TN, 372910.94City re-casedWhitespace trimmedPlaceholder values cleared
TPA-53673TPAJoe Robison1941-10-27UHC-20007-69—5475 Lake View Rd, Jacksonville, FL, 322900.94Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-64313TPAPaul Nguyen1989-02-24——5530 Indian School Rd, Phoenix, AZ, 850280.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-52143TPAGerrald Cox1971-10-05——5111 Canyon Rd, Plano, TX, 750440.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-53552TPAVirginia Lynch1950-12-07———0.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-52486TPABrandon Snyder1968-12-04—5819701183—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54334TPARussell Marquez1962-03-11—2913710345—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54335TPARussell Marquez1962-03-11—2913710345—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62506TPAAshley Jimenez1971-12-23—9584953788—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51627TPAGerald Cunningham1983-06-15—53921547187237 Camelback Rd, Nashville, TN, 372950.94Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-60569TPADiane Hoffman1958-05-26—83754986092939 Lincoln Way, Mesa, AZ, 852200.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57126TPARonald Brown1964-02-24—2945384752—0.94Name re-casedPhone reformattedPlaceholder values cleared
TPA-52203TPATimothy Lopez1946-01-15—5136726619—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59256TPAJordan Murphy1986-12-16—9374587240621 Indian School Rd, Gilbert, AZ, 852300.94Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-51695TPAJessica Carter1950-09-14——4008 Indian School Rd, Jacksonville, FL, 322390.94Name re-casedDate of birth reformattedPlaceholder values cleared
14,474 rows, page 241 of 290PreviousNext