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-56674TPAMarcus Carr1942-10-28——2952 Jefferson Ave, Tampa, FL0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-59299TPAMatthew Marquez1984-02-09—80573329896565 Maple Ave, Glendale, AZ, 853220.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53849TPAAndrea Bell2007-01-24——4106 Baseline Rd, Austin, TX, 787130.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-56594TPAGeorge Hernandez1955-03-23——6868 Ridge Rd, Mesa, AZ, 852970.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-57144TPAJacob Jensen1944-06-02——3352 Mountain View Dr, Las Vegas, NV0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59904TPAMaria Lopez1945-04-08——3303 Forest Ave, Jacksonville, FL, 322430.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-60777TPAAngela Wheeler1952-02-15——1829 Grand Ave, Jacksonville, FL, 322660.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-60915TPABilly Lawrence1942-02-09UHC-31776-14—187 Cedar Ln, Seattle, WA, 981910.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-53457TPAKevin Chapman1967-09-13——3206 Meadow Ln, Scottsdale, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-53715TPABrenda Garrett1985-09-28UHC-01984-2425473331683668 Ridge Rd, Phoenix, AZ, 850180.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51493TPAAnthony N Salazar2004-01-25——3940 Hillcrest Rd, Plano, TX, 750070.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-63381TPAHannah Bowman1997-02-18——3657 Central Ave, Charlotte, NC, 282270.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-59103TPAAshley W Walker1952-12-07——524 Indian School Rd, Atlanta, GA, 303100.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59872TPATeresa Fox1981-12-23——4557 Palm Dr, Orlando, FL, 328650.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59290TPADenise Riley1990-08-11——4126 Bayshore Dr, Minneapolis, MN, 554350.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-62763TPAAlexander Reid—UHC-22695-59—5107 Lake View Rd # 452, Plano, TX, 750270.52Name re-casedDate of birth unreadableUnit split from streetGender normalised+2 more
TPA-64218TPACarl McCoy1966-04-05—60982980216685 Sunset Blvd, Austin, TX, 787840.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52622TPASteven Salazar1950-05-26——694 Bayshore Dr Apt 21, Fresno, CA, 937980.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-62453TPASamantha Riely1965-12-27——5302 Hillcrest Rd, Orlando, FL, 328280.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-52470TPALarry Jackson1943-03-16UHC-86916-4191789403019602 Church St, Seattle, WA, 981240.52Phone reformattedSSN last four extractedZIP+4 trimmedGender normalised+2 more
TPA-59046TPABeverly Chapman1975-07-20——2771 Lake View Rd, Las Vegas, NV, 891800.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
TPA-55673TPAAmy Dominguez1976-03-19UHC-21901-22—2826 Union St, Sacramento, CA, 958850.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-51865TPAGary Welch1940-12-20——1042 Church St, Tampa, FL, 336210.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57913TPAAnn Ford1943-01-09——3659 Ridge Rd, Houston, TX, 770810.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-51145TPACharlotte Shaw1941-11-28——9013 Canyon Rd, Chandler, AZ, 852110.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55996TPATimothy Dixon1951-11-17—44563109711368 Ridge Rd, Plano, TX0.52Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more
TPA-56336TPABobby Stone1954-07-02—73995305082672 Grand Ave, Scottsdale, AZ, 852410.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59517TPAKimberly Wright1983-10-10——6957 Bayshore Dr, Los Angeles, CA0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-54681TPALawrence Cunningham1998-07-17——9321 Mesa Dr # 239, Mesa, AZ0.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57340TPADorothy Wagner———1607 Forest Ave, Tucson, AZ, 857330.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
TPA-53472TPATyler Long1981-04-15—41751778215731 Main St, Sacramento, CA, 958880.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58191TPALauren Castillo1950-01-17——8106 Willow Ct Apt 25, Tempe, AZ, 852660.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-63699TPADouglas Smith1939-02-21—35545012256704 Valley View Dr, Seattle, WA, 981660.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
TPA-53571TPASofia Y Romero1978-10-13——8981 Willow Ct, Glendale, AZ, 853490.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-58633TPADylan Robinson2007-07-15——3396 Maple Ave, Orlando, FL, 328190.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-63587TPARuth B Price1965-03-04—73050573931483 Maple Ave, Minneapolis, MN, 554980.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-61964TPAOlivia Grant2003-08-15UHC-01709-43—4874 Willow Ct, San Diego, CA, 921650.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-61140TPACatherine Day1943-07-04——5538 Grand Ave, Plano, TX0.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-61173TPAGloria Clark1976-08-27UHC-28114-30—5774 Indian School Rd, Sacramento, CA0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
TPA-59999TPAJoe Obrrien———832 Oak St, Jacksonville, FL, 322880.52Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+2 more
TPA-63847TPARaymond V McDonald——34923466309897 Canyon Rd, Atlanta, GA, 303620.52Name split from “Last, First”Date of birth missingPhone reformattedState name converted to code+2 more
TPA-55264TPADonald Park1972-01-09——1942 Forest Ave # 852, Gilbert, AZ0.52Date of birth reformattedUnit split from streetState name converted to codeZIP missing+2 more
TPA-61320TPAMadison Rose1966-11-16UHC-58752-22—3811 Bayshore Dr, Scottsdale, AZ, 852910.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-62194TPARussell Duncan1988-08-26——9339 Apache Blvd, Scottsdale, AZ, 852450.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-55937TPACharles Austin1979-02-16——787 Grand Ave, Mesa, AZ, 852710.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-55840TPAAnthony Aguilar1989-11-06—76280888847499 Jefferson Ave, Phoenix, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-63482TPARachel Turner1990-04-03—21265272122262 Apache Blvd, Phoenix, AZ, 850450.52Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
TPA-53105TPAGerald Y Wagner1982-02-05—62794681729744 River Rd # 478, Charlotte, NC, 282690.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-62213TPATyler Z Sanders1994-01-19—64972440731664 Forest Ave, Minneapolis, MN, 554560.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-54357TPAPeter Wong1965-05-19—37986576891640 Ocean Ave, Seattle, WA0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
14,474 rows, page 19 of 290PreviousNext