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-50631TPASamantha Bailey1999-03-21—96544442162283 Lincoln Way, Plano, TX, 750960.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-64011TPAPeter Green1992-07-18——8788 Grand Ave, Las Vegas, NV, 891050.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-64012TPAPeter Green1992-07-18——8788 Grand Ave, Las Vegas, NV, 891050.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55630TPAAlice Perkins1993-01-28———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-61061TPAJoseph Day1967-04-14—55837991988532 Palm Dr, Los Angeles, CA, 900760.94Name re-casedPhone reformattedPlaceholder values cleared
TPA-63761TPAPatrick Rios1957-01-19———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-55637TPAScott Davis1967-05-22——1816 Ocean Ave, Orlando, FL, 328630.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-58044TPAEmily M Murphy2004-08-02———0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51929TPACarol Rodriguez1990-10-28———0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60241TPAMaria B Clark1949-12-07UHC-75430-55—8006 Apache Blvd, Columbus, OH, 432890.94City re-casedWhitespace trimmedPlaceholder values cleared
TPA-64418TPAGregory F Pea1992-01-05——8095 Willow Ct, Charlotte, NC, 282690.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54418TPAAisha Chen1944-10-03UHC-11222-74—8555 Main St, Plano, TX, 750760.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-50030TPAGeorge Ellis1977-04-27UHC-39266-3233458223538317 Elm St, Miami, FL, 331810.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50161TPAKatherine L Payne1945-07-05——352 Meadow Ln, Miami, FL, 331910.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-60504TPAAshley Nunez1990-04-28———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-56720TPARyan L White1997-06-15—5548943833—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52534TPAObrien M Jacob1949-07-03UHC-92455-51—9669 Mountain View Dr, Jacksonville, FL, 322810.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-61862TPAOlivia Cole2008-08-16—7183224869—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-64083TPARalph W Wood1959-08-19——5440 Lake View Rd, Charlotte, NC, 282500.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-55261TPAJose Oliver1951-03-24—3738456078—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51575TPABetty Johnson1991-01-24—4397933926—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-56346TPALarry Banks2007-01-04—3904874762152 Lincoln Way, Atlanta, GA, 303670.94Name re-casedPhone reformattedPlaceholder values cleared
TPA-52286TPADorothy Gry1945-08-20———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-56602TPAEugene Kennedy1955-02-04UHC-35358-92—4602 Grand Ave, Fresno, CA, 937270.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-51124TPADonna Torres1981-10-11———0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59700TPAKeith Hudson1997-11-14——9739 Central Ave, Tucson, AZ, 857060.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-54299TPAEric Fisher1942-10-10——799 Lake View Rd, Chandler, AZ, 852440.94Name re-casedCity re-casedPlaceholder values cleared
TPA-55876TPALogan Y Gonzales1986-07-13———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-61680TPALogan Owens1974-08-18—7546910824—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62724TPAKayla Reyes1995-02-08—4183318017—0.94Name re-casedPhone reformattedPlaceholder values cleared
TPA-62281TPACatherine K Junes2003-04-07—7004956362—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50845TPAJames Montgomery1987-04-13——2804 Central Ave, Charlotte, NC, 282980.94City re-casedWhitespace trimmedPlaceholder values cleared
TPA-54690TPAZachary Franklin1940-06-23———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-58944TPADavid R Yang1947-05-10—3884721360—0.94Name re-casedPhone reformattedPlaceholder values cleared
TPA-51622TPAKaren Williamson1989-01-28—6128106648—0.94Name re-casedPhone reformattedPlaceholder values cleared
TPA-54918TPADorothy Spencer1945-06-17—45873632978053 Meadow Ln, Atlanta, GA, 303330.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63217TPATerry Cunningham2007-03-21——7889 Lake View Rd, Jacksonville, FL, 322790.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-56418TPAOmar Le1980-03-23——9880 Canyon Rd, Charlotte, NC, 282060.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-63146TPAJonathan Stone1972-10-13—3329001655—0.94Name re-casedPhone reformattedPlaceholder values cleared
TPA-52577TPAYuki Matthews2007-01-17——9387 Sage Ct, Houston, TX, 770670.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57035TPALauren Pena1974-01-10———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-54063TPAElizabeth P Diaz1942-03-04———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-63143TPAAhmed W Campbell1939-09-19———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-57606TPAJacqueline James1991-03-25——4971 Desert Sky Blvd, Plano, TX, 750870.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-59539TPALarry Simpson1973-01-25UHC-81950-28—406 Lincoln Way, Charlotte, NC, 282350.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62251TPARuth S Ortiz1990-11-22UHC-29847-48——0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-50407TPAKayla Shaw1986-11-15UHC-04156-50——0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-50862TPAElizabeth Hamilton1950-12-01——4500 Maple Ave, Seattle, WA, 981960.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54106TPAJerry Anderson2006-12-25——5218 Lake View Rd, San Antonio, TX, 782270.94Date of birth reformattedPlan code upper-casedPlaceholder values cleared
TPA-57945TPAAustin Tohmas2004-05-28UHC-15598-86—315 Valley View Dr, Sacramento, CA, 958210.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 242 of 290PreviousNext