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-62806TPAAmber Henderson1970-08-09——7298 Broadway, Sacramento, CA0.76Name re-casedAddress re-casedState code upper-casedZIP missing+2 more
TPA-53216TPAPatricia Sullivan1960-08-06——7284 Grand Ave, Plano, TX, 750220.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61363TPAJames Li2003-12-03——823 Bayshore Dr, Houston, TX, 770630.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56185TPAGlroia Sanchez1977-08-26——3874 Church St, Columbus, OH, 432880.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58636TPAPeter Franklin1976-07-04—83866459997052 Camelback Rd, Tempe, AZ, 852250.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56411TPAMaria Flores1998-02-23UHC-15319-51—7307 Oak St, Tempe, AZ, 852370.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58746TPASantiago Obrien1991-08-09——9425 Maple Ave, Scottsdale, AZ, 852370.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61344TPABetty Willis1958-07-17UHC-87716-71—2735 Cedar Ln, Houston, TX, 770860.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59501TPASara G Howard1967-04-09UHC-97726-24—4495 Union St, San Antonio, TX, 782440.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50276TPAGary Gutierrez1992-12-06—38134189682995 Market St, Eden Prairie, MN, 553250.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50277TPAGary Gutierrez1992-12-06—38134189682995 Market St, Eden Prairie, MN, 553250.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56971TPAVirginia Bennett2007-07-09——3368 Lincoln Way, San Antonio, TX, 782460.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57516TPAAngela Chapman1946-03-12——8366 Bayshore Dr, Denver, CO, 802470.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-57603TPALisa S Gardner1972-02-21UHC-73897-42—4855 Sunset Blvd, Las Vegas, NV, 891390.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62565TPACheryl Armstrong1967-04-06—72490733231762 Lake View Rd, San Diego, CA, 921360.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50588TPAZachary Rdoriguez1941-10-09UHC-03456-1157364904517339 Jefferson Ave # 523, Los Angeles, CA, 900910.76Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+2 more
TPA-60463TPAPatrick Ferguson1970-05-01——3806 Valley View Dr # 577, Orlando, FL, 328100.76Name re-casedDate of birth reformattedUnit split from streetCity re-cased+2 more
TPA-61164TPAEric Perry1951-06-01——9175 Elm St, Dallas, TX, 752080.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61560TPADonald Kennedy2005-08-27—52687561492438 Grand Ave, Austin, TX, 787580.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51397TPARachel Washington1965-11-02—56447456677169 Broadway, Glendale, AZ0.76Name re-casedDate of birth reformattedPhone reformattedZIP missing+2 more
TPA-50419TPACarl W Sandoval1998-04-01——1075 Elm St, Plano, TX, 750320.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57460TPAEmma Tucker1964-05-09——8985 Hillcrest Rd, Fresno, CA, 937740.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55556TPARebecca Andrews1990-08-03——4917 Jefferson Ave, Dallas, TX, 752320.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64184TPAMelissa Fox1979-10-28—33263637087882 Baseline Rd Apt 33, Atlanta, GA, 303930.76Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
TPA-50455TPARalph Vargas1969-06-27——5769 Cedar Ln, Tempe, AZ, 852790.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59958TPAEd Duncan1961-06-25—8545193167619 Market St, Denver, CO, 802800.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58201TPACharles Y Armstrong1998-09-13——5832 Grand Ave, Seattle, WA, 981040.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62408TPAKellly Morris1961-04-11—43571189105956 Willow Ct, Plano, TX, 750580.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60526TPAAlbert Garrett1983-08-01—95330205479517 Desert Sky Blvd, Eden Prairie, MN, 553800.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61218TPACarool Watkins1997-02-06—97783096187919 Broadway, San Antonio, TX, 782900.76Name split from “Last, First”Date of birth reformattedPhone reformattedAddress re-cased+2 more
TPA-58262TPASamuel Oliver1968-03-01—58092949183743 Church St, Houston, TX, 770890.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52597TPADeborah Baker1994-06-22———0.76Name re-casedDate of birth reformattedEmail lower-casedGender normalised+2 more
TPA-59846TPAJoan Simmons1939-09-06—9028903731896 Bayshore Dr, Tempe, AZ, 852980.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52762TPASharon Hanson2000-07-07——33 River Rd, Sacramento, CA, 958340.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50751TPASamantha N Hughes2003-06-15—60999897923646 Meadow Ln, Gilbert, AZ, 852930.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53579TPAChristian Taylor1940-05-07—60099927875386 Valley View Dr, Dallas, TX, 752640.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60599TPALaura Nunez1969-01-27—85847327553323 Harbor Blvd, Fresno, CA, 937040.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59562TPACharlotte P Hayes1991-10-15——7221 Bayshore Dr, Los Angeles, CA, 900970.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53940TPABetty Fields2006-08-24UHC-24111-9754787389852940 Cedar Ln, Scottsdale, AZ, 852730.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-53067TPAAmanda Simmons1964-04-10——9164 Camelback Rd, Mesa, AZ, 852070.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53201TPAPaul B Foster1983-02-05——4047 Washington St, San Antonio, TX, 782400.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52386TPAMaria Johnston1964-12-18——4950 Desert Sky Blvd, Eden Prairie, MN, 553690.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50992TPAGibson Gabriel1993-04-08——5197 Cedar Ln, Nashville, TN, 372950.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61977TPAJezse Russell1983-04-14——8446 Camelback Rd, Phoenix, AZ, 850880.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59515TPAHeather Duncan1946-05-05—79398818377012 Central Ave, Mesa, AZ, 852310.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-58976TPAJose Gibson1990-06-22—3799991748253 Oak St, San Diego, CA, 921940.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55641TPAWayne Z Roberts1945-06-20——9421 Oak St, Plano, TX, 750720.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50576TPAAndrew Fields1995-03-23—80357779423129 Main St, Jacksonville, FL, 322610.76Name re-casedPhone reformattedCity re-casedGender normalised+2 more
TPA-54849TPAScott Brown1993-02-07—83084214005537 Main St, Miami, FL, 331230.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59045TPAWei Stephens1953-07-07—4442442440—0.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
14,474 rows, page 116 of 290PreviousNext