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-61323TPAJennifer Castro1950-04-02——1633 Sage Ct Apt 35, Jacksonville, FL, 322870.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57662TPAAustin C Richards1989-08-07——9292 Forest Ave, Seattle, WA, 981680.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
TPA-59929TPACharlotte Welch2005-01-19——3149 Cedar Ln, Plano, TX, 750390.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-56601TPALaura Watkins1961-02-15——2762 Willow Ct, Mesa, AZ, 852310.52Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+2 more
TPA-60669TPAPeter Wells1946-05-19——2917 Mesa Dr, Miami, FL, 331280.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-60745TPADanialle Pattersoon1947-08-04—74659635105328 Elm St Apt 33, Fresno, CA, 937680.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-58542TPAWei Fisher2004-10-11—88769848013607 Meadow Ln, Houston, TX, 770740.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61291TPAMichael Baker2003-07-12——3497 Oak St Apt 25, Eden Prairie, MN, 553040.52Name split from “Last, First”Unit split from streetCity re-casedGender normalised+2 more
TPA-50386TPACharlotte Stevens1957-02-02——4201 Spring St, Gilbert, AZ, 852260.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-53372TPANatalie Burton1967-05-28——523 Main St Apt 11, Tucson, AZ0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-60905TPADylan F Parker1988-11-15——539 Harbor Blvd, San Diego, CA, 921600.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-55987TPACarlos P Le1944-10-15UHC-07359-80—7655 Lake View Rd, Charlotte, NC0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63004TPAMartha Carpenter2001-04-23——8661 Valley View Dr, Seattle, WA, 981220.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59947TPAJuan Banks1967-11-12——9425 Mesa Dr, Fresno, CA, 937620.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-51350TPADiana Reid2000-02-01——9358 Desert Sky Blvd, Sacramento, CA, 958440.52Name re-casedTwo-digit birth yearState name converted to codeZIP+4 trimmed+2 more
TPA-55698TPARuth W Payne1977-11-16—69680556886794 Church St, Jacksonville, FL, 322900.52SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54908TPAKeith Jones1956-01-16——4325 Church St, Gilbert, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-62361TPAJose Williams1949-06-05UHC-68499-83—4096 Oak St, Las Vegas, NV, 891250.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-63491TPAJulie Wilson1948-09-17——6180 Canyon Rd Apt 16, Orlando, FL, 328390.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-60063TPALaura Weber1941-09-14——3697 Highland Ave, Orlando, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-60151TPATarry D Stone1976-06-03——7619 Ridge Rd # 100, Charlotte, NC, 282600.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-61443TPADiana Casttro1971-09-25——2883 Market St, Tampa, FL, 336280.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-55660TPARobert Hall1946-03-22UHC-74797-86—1833 Oak St, Sacramento, CA, 958930.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55608TPAJerry E Porter1980-01-22——8480 Forest Ave, Tempe, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-54787TPAJesse Warren2008-11-17—46383016877100 Hillcrest Rd, Gilbert, AZ, 852430.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-62765TPAJean Johsnon1947-06-09——6754 Canyon Rd, Nashville, TN, 372770.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-55372TPAStephanie Ruiz———1752 Main St, Eden Prairie, MN, 553290.52Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60240TPADenise Young1969-11-18——2167 Desert Sky Blvd, Tempe, AZ0.52Date of birth reformattedState name converted to codeZIP missingGender normalised+2 more
TPA-62830TPASharon Ruiz1996-02-26—66688562602788 Washington St, Tampa, FL, 336090.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55592TPARussell Burke1959-01-18——6780 Mountain View Dr, Los Angeles, CA, 900800.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-50876TPAMartha M Dean1989-02-17——5105 Spring St, Tempe, AZ0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
TPA-59555TPAGrace Bishop1983-12-15——3120 Cedar Ln, Minneapolis, MN, 554500.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-57585TPAMak Hawkins1973-02-22——1648 Main St, Tempe, AZ, 852890.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-61401TPARaymond Carlson—UHC-95664-26—9151 Church St, Houston, TX, 770590.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-55376TPAThomas Boyd1996-11-05—8104388722204 Indian School Rd, Glendale, AZ, 853680.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55896TPALori Singh1973-06-04——2288 Canyon Rd, Denver, CO, 802500.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
TPA-61037TPAMark Johnson1989-09-14——3957 Willow Ct, Scottsdale, AZ, 852650.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-58244TPAMaia B Gonzales——48333816086725 Bayshore Dr, Glendale, AZ, 853300.52Date of birth unreadablePhone reformattedSSN last four extractedStreet suffix standardised+2 more
TPA-50457TPABeverly Dominguez1963-06-01—92335001042507 Cedar Ln, San Diego, CA0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-61502TPACarl Gibson2005-10-02——8206 Willow Ct, Dallas, TX, 752180.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56736TPABobby J Daniels1959-10-15UHC-88164-3784198430812303 Desert Sky Blvd, Chandler, AZ, 852560.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
TPA-51512TPASamuel Evans2003-06-19——4995 Maple Ave, Phoenix, AZ, 850210.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-51185TPAMaria Kim1998-12-22——322 Mountain View Dr, Columbus, OH, 432020.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54378TPARoy Carlson1981-10-05——1263 Harbor Blvd, Gilbert, AZ, 852770.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-52084TPAHelen Cruz1988-11-02——756 Central Ave, Orlando, FL, 328890.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-57906TPAEmily Luna1939-09-28—80892123404489 Market St Apt 36, Denver, CO, 802990.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-50554TPAJoe Reid1960-07-03——8020 Sunset Blvd Apt 22, Seattle, WA, 981180.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
TPA-56544TPASara Jimenez1986-08-07——7674 Spring St, Nashville, TN, 372520.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54980TPADylan Deaan1940-04-18—37228138443307 Apache Blvd, Atlanta, GA0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56509TPAJacob K Carr1995-12-25——473 Grand Ave Apt 3, San Antonio, TX, 782030.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 24 of 290PreviousNext