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-59181TPABeth Schultz1967-12-24——9384 Pine Dr, Fresno, CA, 937580.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-61189TPABetty Watkins1994-07-17——6891 Palm Dr, Tempe, AZ, 852860.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-59683TPAJudy A Edwards1992-08-01——501 Palm Dr, Gilbert, AZ, 852230.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60730TPAHenry Ruiz1992-02-13UHC-11129-89918848734286 Bayshore Dr, San Antonio, TX, 782960.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62263TPAJason Harris2004-06-27——8576 Lake View Rd, San Diego, CA, 921160.66Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-61842TPARebecca Stevens1940-08-09—2343656742—0.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
TPA-55117TPASamuel Williamson1960-08-28——1245 Sage Ct, Orlando, FL, 328370.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-54729TPAKathryn Little1995-03-05——7695 Park Pl, Miami, FL, 331290.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-50533TPAJennifer Brown1944-11-06UHC-69247-3356437064625728 Lake View Rd, Chandler, AZ, 852580.66Phone reformattedSSN last four extractedGender normalisedWhitespace trimmed+1 more
TPA-61331TPAJesse Ramos2008-04-13——7233 Park Pl, Fresno, CA, 937580.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-61009TPABarbara Ruiz1977-06-24——695 Willow Ct, Tempe, AZ, 852280.66Name re-casedPhone missing area codeGender normalisedWhitespace trimmed+1 more
TPA-56543TPADebbie Gonzalez1945-11-14——3485 Desert Sky Blvd Apt 21, Seattle, WA, 981530.66Name split from “Last, First”Date of birth reformattedUnit split from streetCity re-cased+1 more
TPA-55576TPAJanet Carpenter1987-05-09——9345 Sunset Blvd, Atlanta, GA, 303900.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-56130TPAKathryn Sims1967-11-06——9716 River Rd, Minneapolis, MN, 554780.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-55329TPAKayla Bradley1953-02-12——3936 Jefferson Ave, Charlotte, NC0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-55328TPAKayla Bradley1953-02-12——3936 Jefferson Ave, Charlotte, NC0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-54801TPASofia Li2003-01-08——303 Palm Dr, Sacramento, CA, 958500.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-64207TPALaura Pierce2005-04-09—7043091944—0.66Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+1 more
TPA-57658TPAElizabeth Gibson1955-05-15—3338331944833 Sage Ct, Tampa, FL, 336610.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50248TPALinda Payne———3257 Desert Sky Blvd, San Antonio, TX, 782720.66Date of birth unreadableStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-63352TPAHannah Arnld1989-06-16—36995623704860 Desert Sky Blvd, Charlotte, NC0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-55140TPAMason Murphy1956-11-11——3805 Pine Dr, Eden Prairie, MN, 553000.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-51739TPAJudy Gomez1977-08-18UHC-18172-29—8411 Canyon Rd, Orlando, FL, 328400.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57153TPAJerry Watkins1957-07-07——2207 Washington St Apt 39, Los Angeles, CA, 900980.66Name re-casedDate of birth reformattedUnit split from streetZIP+4 trimmed+1 more
TPA-55696TPACheryl Gonzales1958-02-01——7206 Market St, Mesa, AZ, 852740.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-54387TPALori Aguilar1983-07-12——1976 Spring St, Charlotte, NC, 282040.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50146TPADiana H Fields1967-06-06——8127 Spring St, Miami, FL, 331790.66Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+1 more
TPA-63087TPAHelen Diaz2000-05-28——5905 Camelback Rd, Columbus, OH0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-54532TPARalph Jimenez1998-04-11—57074586919714 Church St, Sacramento, CA, 958750.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51020TPAPatrick Carter1986-11-22——9383 Washington St, San Diego, CA, 921010.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-63719TPAWang Sophia1950-01-28——6636 Spring St, Jacksonville, FL, 322770.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61824TPAPamela Shaw1999-12-17—24951462706583 Indian School Rd, Tampa, FL, 336900.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
TPA-51741TPAKate Dean1958-12-09—50454126942022 Canyon Rd, Denver, CO, 802790.66Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+1 more
TPA-60250TPAAdam Wood1941-01-05UHC-86873-43—8490 Highland Ave, Charlotte, NC, 282510.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-53419TPABrian Wang———2019 Valley View Dr, Eden Prairie, MN, 553560.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59267TPALori Johnston1998-12-05—66036419779855 Valley View Dr, Sacramento, CA, 958660.66Date of birth reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-57608TPABarbara Garza———3720 Mesa Dr, Dallas, TX, 752680.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52933TPAWilliam Vasquez1939-01-24—45552692053942 Union St # 112, Minneapolis, MN, 554110.66Name split from “Last, First”Phone reformattedUnit split from streetWhitespace trimmed+1 more
TPA-63327TPABrian Evnas1955-01-05—39742200957147 Cedar Ln, Nashville, TN0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-64109TPAJeffrey Q Richardson1974-03-06——3760 Highland Ave, Eden Prairie, MN, 553430.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63906TPAJames Le1952-02-20——6689 Main St, Tucson, AZ, 857580.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-58243TPAMaria Gonzales1946-04-21UHC-62081-0248333816086725 Bayshore Dr, Glendale, AZ, 853300.66Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+1 more
TPA-59521TPAEmma Barnes1960-10-15——3633 Desert Sky Blvd, Tucson, AZ, 857240.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-52604TPAEmily Singh1991-07-23UHC-65155-15—4040 Jefferson Ave, Columbus, OH, 432300.66Name split from “Last, First”Street suffix standardisedAddress re-casedPlan code upper-cased+1 more
TPA-58750TPAEric Snyder1971-01-27—66768038964671 Union St, Scottsdale, AZ, 852830.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
TPA-53518TPARyan Howell1982-04-25—67254808554377 Forest Ave # 571, Miami, FL, 331760.66Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+1 more
TPA-55036TPAJean Ramos1962-04-03——2365 Jefferson Ave, Seattle, WA, 981570.66Name split from “Last, First”Date of birth reformattedState name converted to codeWhitespace trimmed+1 more
TPA-54614TPAMelissa P Patterson1964-03-08——64 Elm St, Sacramento, CA, 958450.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-64054TPADonna Mason2002-04-14——1781 Forest Ave Apt 23, San Antonio, TX, 782450.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-63961TPABradley Carpenter1948-08-08——9271 Mountain View Dr, Fresno, CA, 937390.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
14,474 rows, page 82 of 290PreviousNext