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-54410TPAHenry Harper1952-10-15—54935344473110 Desert Sky Blvd, Charlotte, NC, 282060.92Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased
TPA-61789TPABilly Lopez1940-09-21UHC-11120-8849170943086638 Highland Ave, Columbus, OH, 432200.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51009TPAKelley Terry1963-01-07—82960457085057 Camelback Rd, Fresno, CA, 937760.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54571TPAMargaret L Owens1976-07-02——549 Oak St, Tampa, FL, 336380.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56919TPACamila Dunn2007-12-05—4307541468—0.92Date of birth reformattedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-60635TPALaura Patterson2006-10-22—9648179466—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-50197TPADebra Davis1986-02-13UHC-91305-53—1252 Church St, Orlando, FL, 328620.92Date of birth reformattedMember ID reformattedWhitespace trimmedPlaceholder values cleared
TPA-54127TPAEric Freeman1962-05-09—3566904311—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56113TPAKathleen Stevens1979-02-01UHC-16813-285597005041—0.92Name re-casedPhone reformattedPlan code upper-casedPlaceholder values cleared
TPA-50848TPACarol Richardson2010-02-20—3386124631—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55979TPASteven G Carr1967-12-04——3232 Willow Ct, Houston, TX, 770570.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50784TPAWalter Harris1955-10-03———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56758TPADouglas Mattheews1946-05-26——3945 Broadway, Plano, TX, 750660.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-54794TPAAnnna Wallace2008-07-17—83876754179684 Camelback Rd, Scottsdale, AZ, 852540.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51143TPAKathleen Taylor1948-04-18—52854129952546 Camelback Rd, Mesa, AZ, 852520.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52240TPASophia Wilson1958-10-14——962 Palm Dr, Jacksonville, FL, 322430.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-61611TPAShirley Crawford1962-08-09———0.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-63541TPABetty Hansen1955-09-13—3798603313—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61336TPAMoreno Scott1943-03-17——2645 Park Pl, Sacramento, CA, 958410.92Date of birth reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-50211TPASofia Wheeler1982-11-09—6262228452—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61327TPARyan Barnes1957-09-02—85737908664816 Desert Sky Blvd, Gilbert, AZ, 852480.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58632TPAHannah Morales2008-03-17———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52782TPAJason Z Morales1947-11-11—70299789603993 Desert Sky Blvd, Charlotte, NC, 282460.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58419TPASophia Rogers1999-04-17—31480136667483 Broadway, Las Vegas, NV, 891910.92Name re-casedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59639TPADenny Gardner1974-04-10——2179 Broadway, Columbus, OH, 432790.92Name re-casedDate of birth reformattedAddress re-casedPlaceholder values cleared
TPA-50852TPAWalter Palmer1979-12-15—7997496707—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-52159TPAAisha Berry1976-03-07——2814 Oak St, Columbus, OH, 432260.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56252TPARalph Wang1957-12-03—9104336575—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-62177TPAIsabella Rede1987-08-24—7686605539—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50214TPAGary Reynolds1964-07-28———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50807TPAMadison Greene1958-03-25—27658433456827 Ridge Rd, Jacksonville, FL, 322170.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51655TPAStephen Cook2001-11-05UHC-38054-36—433 Main St, San Antonio, TX, 782020.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-58640TPAKaren R Stewart2000-02-02——6295 Lincoln Way, Tempe, AZ, 852280.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55845TPAMaria Dean2007-10-07———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50506TPAAlexander R Castro1957-10-01——1906 Broadway, Los Angeles, CA, 900970.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-51051TPAJoyce Carr1976-08-01UHC-88883-3380940627385711 Broadway, Nashville, TN, 372000.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53535TPASharon Ramos1953-01-12UHC-77208-14—6173 Meadow Ln, Phoenix, AZ, 850630.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-63235TPAHannah Miller1957-10-12———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51085TPASarra Riley1968-11-24—5604707904—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54200TPAAisha Stephens1996-04-17—70650440942778 Valley View Dr, Minneapolis, MN, 554350.92Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed
TPA-54233TPAYuki Lynch1963-06-01—9205577136—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55571TPABrenda Henry2004-01-05——2034 Cedar Ln, Chandler, AZ, 852320.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-53569TPAShirley Welch1944-11-10——5380 Washington St, Miami, FL, 331470.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-61735TPARussell Jenkins1965-02-11—31442868767939 Park Pl, Tempe, AZ, 852570.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54000TPAEugene I Jones1966-02-20——1907 Broadway, Chandler, AZ, 852950.92Date of birth reformattedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57468TPAWillie Harper2000-09-13—4348505661750 Central Ave, Gilbert, AZ, 852110.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57469TPAWillie Harper2000-09-13—4348505661750 Central Ave, Gilbert, AZ, 852110.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59881TPABilly Parry1982-09-19—51144179581501 Lincoln Way, Los Angeles, CA, 900670.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
TPA-56038TPAHarold Obrien1984-03-24—6383919662259 Market St, Sacramento, CA, 958180.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
TPA-54605TPAShaw Sean1971-12-01———0.92Name re-casedDate of birth reformattedEmail lower-casedPlaceholder values cleared
14,474 rows, page 234 of 290PreviousNext