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-56915TPAJanice Walsh1941-09-05——6935 Baseline Rd, Houston, TX, 770240.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-64393TPASara F Richardson1969-10-24——7411 Lake View Rd, Houston, TX, 770890.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-53639TPABenjamin Jensen1963-09-25——8817 Forest Ave, Glendale, AZ0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-53421TPABryan Lopez1952-11-09UHC-88128-54—7665 Elm St, Denver, CO, 802870.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-60313TPASantiago Fuller1950-08-15—73335479287215 Jefferson Ave, Scottsdale, AZ, 852210.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-55389TPAMelissa Mendez1974-11-24——7492 Desert Sky Blvd Apt 35, Atlanta, GA, 303450.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-61572TPAMatthew Sanchez———5256 Palm Dr, Scottsdale, AZ, 852420.66Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
TPA-64417TPAWei Phillips1941-03-09——4341 Broadway, Eden Prairie, MN0.66Name split from “Last, First”Address re-casedZIP missingWhitespace trimmed+1 more
TPA-63716TPAAnthony Gibson1963-06-08——2139 Forest Ave, Minneapolis, MN, 554280.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-53787TPABety Le1953-07-25——9800 Mesa Dr, Houston, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-62585TPATeresa Roberts1968-09-01UHC-57428-11—1856 Sage Ct, Sacramento, CA, 958770.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56801TPABill Wrighht1999-12-01——5224 Apache Blvd, Fresno, CA, 937320.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-62372TPALisa Hoffman1942-01-28——384 Mesa Dr, Jacksonville, FL, 322810.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-60425TPAAlbrt Santos1975-05-16——7865 Hillcrest Rd, Austin, TX, 787260.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-60846TPAAshleey Perry1968-03-26—2574365078697 Park Pl, Fresno, CA, 937350.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53467TPABrittany Graham1987-01-04——3057 Sunset Blvd, Tampa, FL, 336350.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-55037TPACharles Liittle1951-04-09——2376 Washington St, Fresno, CA, 937400.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-53465TPAYuki Luna1987-06-20——2639 Central Ave, Las Vegas, NV0.66Name re-casedCity re-casedState name converted to codeZIP missing+1 more
TPA-56494TPAJanet Munoz1941-09-07——4965 Mesa Dr, Gilbert, AZ, 852690.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52770TPAGrace Gonzalez1947-09-26——1884 Union St, Las Vegas, NV, 891540.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-50168TPAMark Stevens1988-08-18—74633699173343 Apache Blvd, Sacramento, CA0.66Phone reformattedZIP missingGender normalisedWhitespace trimmed+1 more
TPA-54280TPARoger Lewis1952-04-16—94484459649404 Highland Ave, Miami, FL, 331150.66Phone reformattedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
TPA-59433TPARalph Jimenez1989-07-12—4026440112—0.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-54262TPAJerry Nelson2005-05-26UHC-34021-91—4180 Apache Blvd, Charlotte, NC, 282500.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-57344TPAAmanda Fields2006-11-23——8596 Union St, Los Angeles, CA, 900150.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58760TPAJesse Li2002-04-07——9417 Desert Sky Blvd, San Diego, CA, 921920.66Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
TPA-55147TPAJoseph P Lee1974-05-25——5814 Sage Ct, Scottsdale, AZ, 852540.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-53791TPASusan Reynolds1966-09-20——2323 Camelback Rd, Las Vegas, NV, 891150.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-57708TPAShaw Brandon1960-11-07——7007 Oak St, Denver, CO, 802370.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
TPA-60835TPANatalye Harper1973-06-13——4968 Camelback Rd Apt 34, Atlanta, GA, 303070.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52798TPALucia Lynch1968-04-09—56048615468941 Forest Ave, Atlanta, GA, 303020.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
TPA-63679TPAKathryn Z Vasquez1960-12-12UHC-42036-52—9460 Sunset Blvd, San Antonio, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-52272TPAJeremy Garrett1996-11-08——2455 Pine Dr, Nashville, TN, 372790.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-56431TPAHenry Pierce2006-12-27——1170 Camelback Rd, Jacksonville, FL0.66Street suffix standardisedAddress re-casedState code upper-casedZIP missing+1 more
TPA-58458TPAJacqueline Nelson1956-08-17——9235 Jefferson Ave, Los Angeles, CA, 900260.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59931TPAJacqueilne Bell1997-04-19——9736 Ridge Rd, Denver, CO, 802410.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-54598TPANathan Hall1939-08-26——7748 Bayshore Dr, Austin, TX, 787350.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-50135TPAMarc Mendoza1995-05-19——9058 Maple Ave, Los Angeles, CA, 900370.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-50079TPAJean Torres1997-05-05——2059 Camelback Rd, Houston, TX, 770250.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51453TPAAna Santos1940-10-17——7064 Indian School Rd, Tucson, AZ, 857790.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58804TPAFrank D Simmons1950-01-23——1973 Harbor Blvd, Glendale, AZ, 853850.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-57807TPAGeorge Fernandez1972-09-21UHC-36073-65—7541 Park Pl, Columbus, OH, 432440.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61533TPAMateo Sims1959-11-11—95443726087841 Bayshore Dr, Phoenix, AZ, 850070.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-61264TPAScott Johnston1965-08-10UHC-34433-48—7864 Oak St, Nashville, TN, 372090.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56992TPAKelly Contreras1992-03-23UHC-65136-03—9844 Valley View Dr, Las Vegas, NV, 891200.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
TPA-62245TPAEmily Obrien1941-06-06——1389 Lincoln Way, Atlanta, GA, 303920.66Name re-casedDate of birth reformattedZIP+4 trimmedGender normalised+1 more
TPA-51947TPAShirley Alvarez1986-07-17——1833 Grand Ave, Gilbert, AZ, 852030.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-52523TPARoy Stephens2007-03-23——9170 Cedar Ln, Denver, CO, 802270.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51400TPADuncen Valentina1974-12-22—28491737605898 Sunset Blvd, San Antonio, TX, 782190.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58712TPANoah Greene1950-02-17—67644169811784 River Rd, Atlanta, GA, 303000.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
14,474 rows, page 75 of 290PreviousNext