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-61303TPARaymond B Castro1983-01-07——6579 Palm Dr, Charlotte, NC, 282750.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-63945TPAAna B Soto1940-01-25—7794951800234 Spring St, Tempe, AZ, 852350.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59583TPALarry Morales1941-06-09—60546191663047 Main St, Nashville, TN, 372220.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57828TPAGrace Romero1978-08-24UHC-31170-7663282091866656 Lincoln Way, Nashville, TN, 372370.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
TPA-53142TPADiane Alvarez1998-06-11——7578 Central Ave, Plano, TX, 750550.92Date of birth reformattedCity re-casedEmail lower-casedPlaceholder values cleared
TPA-53202TPAPaul Foster1983-02-05—81631030324047 Washington St, San Antonio, TX, 782400.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
TPA-55062TPAJoe Adms2008-05-04——2370 Canyon Rd, Atlanta, GA, 303260.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-63626TPARonald Wheeler2001-02-14——1587 Park Pl, Plano, TX, 750760.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-57843TPAJordna Mitchell1999-01-13——882 Lake View Rd, Dallas, TX, 752810.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-55398TPAJoseph Singh1961-03-14——5235 Maple Ave, Glendale, AZ, 853070.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50842TPAJanet Williams2005-10-27—41574827448624 Bayshore Dr, Sacramento, CA, 958570.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-57414TPAMatthew Watkins2009-03-02——3179 Baseline Rd, Jacksonville, FL, 322310.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-54818TPADenise Harper1985-08-11———0.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-56582TPAAndrew S Banks1956-07-22——4132 Willow Ct, Eden Prairie, MN, 553350.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50791TPACarlos Wood2002-12-16—3508565529—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60860TPALarry Bure1966-03-05—53035258831576 Broadway, Orlando, FL, 328530.92Date of birth reformattedPhone reformattedAddress re-casedPlaceholder values cleared
TPA-59759TPADiana A Spencer1942-08-19—6903792927—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-59807TPALauren Chen1973-07-26———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55921TPAIsabella Nelson1992-04-21—52033351882964 Grand Ave, Austin, TX, 787970.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-55488TPAAlexis D Rose1955-08-02UHC-40584-2669469818596299 Hillcrest Rd, Atlanta, GA, 303930.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63859TPAArjun Burton1938-05-13—4486057871—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57037TPALori S George1947-08-05UHC-37487-2754371239506812 Broadway, Tempe, AZ, 852390.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54761TPAJacqueline Flores1939-12-16UHC-03070-5342852780698553 Spring St, Tampa, FL, 336680.92Name re-casedMember ID reformattedWhitespace trimmedPlaceholder values cleared
TPA-56600TPALaura Watkins1961-02-15UHC-86062-54—2762 Willow Ct, Mesa, AZ, 852310.92Name re-casedCity re-casedState code upper-casedPlaceholder values cleared
TPA-53429TPAVicky Fox1985-02-11—7174387510—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51420TPAHarrold Cox1990-07-21—89663290137364 Lincoln Way, Las Vegas, NV, 891370.92Date of birth reformattedPhone reformattedCity re-casedPlaceholder values cleared
TPA-51838TPANathan Padilla1945-12-21—2873502135—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53958TPACatherine Butler1956-04-27—42395492249460 Meadow Ln, Phoenix, AZ, 850240.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60002TPAMichelle Burns1938-06-03——4095 Park Pl, Dallas, TX, 752050.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-64193TPAIsabella K Mendoza1939-09-25UHC-57834-936077213717—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53618TPABradley Kim1945-07-19—4887616975—0.92Phone reformattedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-56355TPACarl Vasquez2000-10-08—39648219582528 Union St, Eden Prairie, MN, 553100.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60872TPAEliah Webb1981-09-03—30256308041767 Washington St, Miami, FL, 331050.92Date of birth reformattedPhone reformattedCity re-casedWhitespace trimmed
TPA-53499TPAShirley Sandoval2007-07-17———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56751TPABobby Gilbert1980-02-07———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58321TPABobby W Rodriguez1940-03-22——9029 Main St, Austin, TX, 787430.92Name re-casedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-60685TPAKatherine I Hart1992-03-19—8145279302—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52618TPAJose Elliott2004-11-26—64335397651677 Oak St, San Diego, CA, 921720.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54916TPAMadison I Bowman1951-08-24UHC-02625-9783385913096821 Camelback Rd, Scottsdale, AZ, 852510.92Name re-casedDate of birth reformattedMember ID reformattedPlaceholder values cleared
TPA-63736TPABeverly Brown1993-03-23—7905314712—0.92Date of birth reformattedPhone reformattedEmail lower-casedPlaceholder values cleared
TPA-62932TPAGrace Perry1939-10-05—44171745475055 Washington St, Dallas, TX, 752150.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51816TPAElijah M Delgado1982-04-20—2645003478—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62637TPADylan Jensen1967-11-24——9643 Mountain View Dr, Glendale, AZ, 853110.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51218TPASophia Thompson2005-07-09UHC-80003-554615186988—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62928TPAArjun Meyer2006-05-24——3470 Jefferson Ave, Phoenix, AZ, 850090.92Date of birth reformattedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-59403TPAPaul Stone1957-11-03—2473927138—0.92Date of birth reformattedPhone reformattedPlan code upper-casedWhitespace trimmed
TPA-58071TPAEmma X Berry1961-12-16——5470 Jefferson Ave, Austin, TX, 787630.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-61908TPABilly Mills1946-11-11—9603095488—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61746TPABradley B Padilla1961-04-03UHC-12439-31—2055 Mesa Dr, Tempe, AZ, 852060.92Name re-casedMember ID reformattedWhitespace trimmedPlaceholder values cleared
TPA-61328TPALarry Scott1959-05-02———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 236 of 290PreviousNext