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-57793TPABrittany Romero1966-01-05——1928 Maple Ave, Austin, TX, 787090.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59603TPARalph Pierce1959-07-23——313 Meadow Ln, Charlotte, NC, 282260.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-61113TPAMary Smith——56926567921344 Apache Blvd, Austin, TX, 787040.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
TPA-51384TPAVincent Brooks1946-11-09——1195 Ridge Rd, Eden Prairie, MN, 553000.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-55606TPAAustin Simpson1993-02-27——3090 Ocean Ave, Los Angeles, CA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56503TPAMichael Simmons2001-03-10—77286299634812 Canyon Rd, Las Vegas, NV, 891940.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-55169TPAMelissa Stephens2004-04-03——2913 Sunset Blvd, Jacksonville, FL, 322800.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-60814TPATheresa K Knight1975-05-06——7122 Mountain View Dr, Tampa, FL0.64Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more
TPA-53446TPAWayne Johnston1957-08-18——4906 Central Ave, Denver, CO, 802760.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-63910TPAMartha Harvey1988-01-08——6664 Union St, Denver, CO, 802820.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-51175TPAChristopher Fox1950-04-28——3691 Hillcrest Rd, Atlanta, GA0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51176TPAChristopher Fox1950-04-28——3691 Hillcrest Rd, Atlanta, GA0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51731TPAJustin Knight1998-02-03—71349183148250 Willow Ct, Fresno, CA0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57885TPACatherine Guzman1981-08-04——7276 Elm St # 947, Tempe, AZ, 852950.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-54824TPAJoshua Brown1974-08-18——6299 Meadow Ln Apt 27, Glendale, AZ, 853110.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-55818TPAFrances Fields1952-11-04—4146613290565 Main St, Tempe, AZ, 852390.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56574TPAJeremy Fernandeez1942-06-17—4697208333842 Church St, Charlotte, NC, 282650.64Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more
TPA-53097TPASara Richards1948-06-18——5719 Ocean Ave, Los Angeles, CA, 900570.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-56689TPARuth Salazar1940-11-24——2527 Central Ave, Houston, TX, 770110.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51693TPAVicky Ford1988-05-02——1293 Mountain View Dr, Miami, FL0.64Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more
TPA-55496TPAJanice Gutierrez1975-09-18——666 Lincoln Way, Phoenix, AZ0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61523TPAKeith J Fields———9699 Sunset Blvd, San Antonio, TX, 782500.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-56005TPAAnn Rogers2003-02-18—30329812859630 Spring St, Eden Prairie, MN, 553100.64Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
TPA-55913TPAAlan Sanchez1966-11-25——5421 Hillcrest Rd, Phoenix, AZ, 850640.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54670TPAJulie Spencer2005-02-08—51658506401749 Main St, Sacramento, CA, 958970.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60328TPAAna Thomas1983-07-19——8738 Camelback Rd Apt 36, Scottsdale, AZ, 852280.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-51273TPAKayla G Romero1997-06-11——18 Central Ave, Glendale, AZ, 853090.64Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+2 more
TPA-61922TPAEvelyn P Bakker1944-08-11——2191 Desert Sky Blvd # 394, Eden Prairie, MN, 553020.64Unit split from streetStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-53493TPABryan Ryan1983-06-11——1607 Desert Sky Blvd, Sacramento, CA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-59264TPAJerry R Garrett1970-04-05—40650408954320 Valley View Dr # 252, Orlando, FL, 328610.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-58065TPATimothy Wagner1985-04-05—68257239609724 Bayshore Dr, Columbus, OH, 432830.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55827TPALisa Mendez1953-09-05—50056426119253 Jefferson Ave Apt 12, San Diego, CA, 921860.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50296TPADavid Medina2006-04-26——1177 Sage Ct, Dallas, TX, 752710.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-51409TPAEugene Henderson1938-01-23UHC-97281-64—3955 Church St, Sacramento, CA, 958610.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-59115TPAGary Jenkins———5509 Palm Dr Apt 32, Jacksonville, FL, 322730.64Name re-casedDate of birth reformattedDate of birth unreadableUnit split from street+2 more
TPA-59114TPAGary Jenkins———5509 Palm Dr Apt 32, Jacksonville, FL, 322730.64Name re-casedDate of birth reformattedDate of birth unreadableUnit split from street+2 more
TPA-64097TPAMichael C Kim1981-08-12—9009701989351 Union St, Austin, TX, 787870.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-53161TPAGloria Rogers1984-03-18UHC-45329-4743335014805350 Desert Sky Blvd, Atlanta, GA, 303470.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50835TPAChristopher Thompson1978-06-23UHC-09795-33—3057 Bayshore Dr, Columbus, OH0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-59761TPAStephen Johnston1997-06-11—88172209801012 Mesa Dr, Chandler, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-50325TPAStephen C Murphy1955-10-14UHC-00291-4368372026019309 Ridge Rd, Nashville, TN, 372020.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-54412TPAJulie Sims1980-02-25——4819 Valley View Dr, San Antonio, TX, 782200.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-55421TPALawrence Watson1995-10-04——9551 Camelback Rd # 710, Minneapolis, MN, 554830.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63774TPAVirginia Fernandez1973-06-03——3072 Ocean Ave, Jacksonville, FL, 322150.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-57499TPACharles Porter2004-04-09——9313 Forest Ave Apt 22, Sacramento, CA, 958290.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56023TPAJacqueline Wagner1938-01-24UHC-77881-56—4420 Sage Ct Apt 33, Miami, FL0.64Date of birth reformattedUnit split from streetCity re-casedState code upper-cased+2 more
TPA-60532TPACynthia N Elliott2006-11-12——9783 Grand Ave, Scottsdale, AZ, 852990.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-52959TPAWillie L Martin1951-09-19—33298740668414 Willow Ct, Nashville, TN, 372620.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55777TPAAnn P Dunn1947-09-05—95580077518837 Harbor Blvd, Eden Prairie, MN, 553800.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51815TPAJeffrey Allen1962-11-20——1697 Main St, Charlotte, NC, 282170.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
14,474 rows, page 58 of 290PreviousNext