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-54723TPARachel Guzman1992-09-27—86527527492817 Sunset Blvd # 161, Houston, TX, 770350.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-60891TPAPatrick Z Simpson1962-09-21——5005 Bayshore Dr Apt 35, Denver, CO, 802650.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-63092TPAAnna Olson1977-11-10——4540 Elm St, Las Vegas, NV, 891810.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-62032TPAChristine W Ortega1969-09-22——3529 Market St, San Diego, CA, 921770.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63329TPAKyle Kennedy1994-02-14—5887905978357 Canyon Rd, Eden Prairie, MN, 553870.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-64266TPAOlivia Richards1954-07-12——303 Ocean Ave, Tempe, AZ, 852560.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-60627TPAGerald Ellis1997-07-28——3286 Washington St, Phoenix, AZ, 850330.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63203TPAKathryn P Padilla1991-02-26UHC-78549-2368225664055993 River Rd, Gilbert, AZ, 852240.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52087TPAMei Jordaan——41929147818617 Desert Sky Blvd, Glendale, AZ, 853330.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
TPA-52173TPADebra Moore1957-05-26——3078 Jefferson Ave, Plano, TX0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
TPA-58726TPASean Vargas1948-02-26—52240600652813 Church St Apt 2, Phoenix, AZ, 850820.50Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-62388TPAJimmy Reed1945-03-19——4459 Washington St Apt 22, Tempe, AZ, 852200.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54207TPAVincent O Willis1996-09-12——7913 Sunset Blvd # 945, Las Vegas, NV, 891100.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-59308TPAGabriel Castro1994-09-24——6936 Spring St, Atlanta, GA, 303220.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-57099TPAGerald Yang1963-07-07—2459276170533 Baseline Rd, Columbus, OH, 432610.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-55566TPAGeorge P Vasquez2008-11-14——7870 River Rd Apt 36, Plano, TX, 750850.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-55567TPAGeorge P Vasquez2008-11-14——7870 River Rd Apt 36, Plano, TX, 750850.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-50171TPARalph Ellioott1993-06-26——3733 Lake View Rd, Eden Prairie, MN, 553720.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51296TPAJuan Reyes1941-04-23——7663 Forest Ave, Dallas, TX0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-58181TPAAshley Thompsson1999-11-22——8765 Central Ave, Eden Prairie, MN, 553200.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-62471TPAKenneth Medina1967-10-03UHC-58954-978256422353817 Hillcrest Rd, Houston, TX, 770900.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-53497TPAJeremy Daniels1961-02-21UHC-81515-12—6850 Sage Ct, Las Vegas, NV0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-60597TPAChristopher Willis1980-03-14—7679142678788 Willow Ct, Las Vegas, NV, 891530.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-60447TPABrenda Munoz1979-05-11—39989853806309 Park Pl, San Antonio, TX0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61057TPARogers Ruszell1989-10-26—42276112202184 Grand Ave # 413, Nashville, TN, 372480.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
TPA-53404TPARonald Moore1995-01-08——2050 Palm Dr, Fresno, CA, 937990.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-50427TPAAnn Campbell2008-12-18——223 Indian School Rd, Denver, CO, 802500.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-59848TPAJudy Carroll—UHC-24401-9890482926202492 Mountain View Dr, San Diego, CA, 921570.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
TPA-62298TPAMariana Perez1994-09-22——4020 Meadow Ln, San Diego, CA, 921210.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59347TPASteve Alvarez2007-02-25—77997605166594 Spring St, San Antonio, TX0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62778TPAEmma M Rodriguez1977-10-28——8610 Church St, Tempe, AZ, 852210.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-51600TPAIsabella N Harris1996-01-27—49056381043768 Mesa Dr, Eden Prairie, MN, 553460.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59374TPAValentina QJunk1949-10-14——3256 Market St, Tucson, AZ, 857100.50Name re-casedStreet suffix standardisedAddress re-casedGender normalised+3 more
TPA-60605TPAKaren D Johnson1984-11-09——5052 Sunset Blvd, Tampa, FL, 336620.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-53541TPADeborah Freeman1943-02-20——1889 Market St, Orlando, FL, 328320.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-56030TPAArthur Richards1984-05-11——4040 Baseline Rd, Los Angeles, CA0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
TPA-55985TPANatalie Bell2005-03-27——7886 Mountain View Dr, Charlotte, NC, 282640.50Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-50932TPASantiago Aguilar1946-01-13——7366 Sunset Blvd, Charlotte, NC, 282190.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62375TPAKenneth Hamilton1985-10-18——4095 Lake View Rd, Sacramento, CA, 958830.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55605TPAAustin Simpson1993-02-27——3090 Ocean Ave, Los Angeles, CA0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-60041TPACharlotte U Armstrong1953-11-03—75192887932974 Washington St, Sacramento, CA, 958710.50Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51591TPAMariana Schultz1987-05-13—59041759858300 Highland Ave, Houston, TX0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-61945TPAIsabella Singh1949-11-14—91625092208764 Baseline Rd, Columbus, OH, 432960.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-60403TPABradley Williis1999-01-08——5874 Cedar Ln, Miami, FL, 331650.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59499TPAMark Silva1987-12-04——7641 Ocean Ave, Chandler, AZ, 852510.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-51806TPAJose Carpenter1971-02-23—55898619345511 Elm St, Phoenix, AZ, 850660.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62800TPAHarold Olson1982-04-21——2989 Baseline Rd Apt 30, Tucson, AZ, 857640.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-59117TPAChristina Nichols———749 Forest Ave, Fresno, CA, 937490.50Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-55642TPATheresa Campbell1986-01-26—96696686957253 Ocean Ave # 451, Seattle, WA, 981950.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-54783TPAChristian Le1971-11-18—75892277887506 Mountain View Dr, San Diego, CA0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
14,474 rows, page 14 of 290PreviousNext