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-53004TPANick Freeman1983-04-22—39093052563594 Baseline Rd # 651, Scottsdale, AZ, 852940.38Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+3 more
TPA-62619TPANathan Bryant1962-12-05——6883 Main St, Jacksonville, FL, 322160.38Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-54255TPAChristian Weber2008-09-04——9393 Cedar Ln # 333, Plano, TX0.38Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-56748TPAPamela Wilson1942-07-21UHC-01249-689678349119175 Camelback Rd, San Antonio, TX0.38Name split from “Last, First”Date of birth reformattedState name converted to codeZIP missing+3 more
TPA-55834TPAWillie Hicks1962-04-17UHC-95705-04—5869 Lincoln Way, Los Angeles, CA, 900310.38Name re-casedTwo-digit birth yearState name converted to codeZIP+4 trimmed+3 more
TPA-57994TPAVictoria I Peterson2004-03-17——3004 Valley View Dr, Dallas, TX, 752290.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63461TPASantiago Hansen———8566 Central Ave, San Antonio, TX, 782960.38Name re-casedDate of birth missingState name converted to codeZIP+4 trimmed+3 more
TPA-62742TPAGrace Rios1940-12-04UHC-55558-64—2070 Ridge Rd, Seattle, WA0.38Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-51116TPAMateo Day1993-12-23UHC-73777-46—9132 Main St Apt 24, Las Vegas, NV0.38Name re-casedTwo-digit birth yearUnit split from streetZIP missing+3 more
TPA-53407TPAGabriel Washington1964-10-07——7013 Spring St Apt 7, Mesa, AZ, 852520.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-62863TPADonna Carpenter1983-09-12—58032387757395 Cedar Ln, Chandler, AZ, 852250.38Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-51073TPABruce Myers1997-07-10——162 Ridge Rd Apt 4, San Antonio, TX, 782020.38Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-58741TPAJordan Siims1955-01-18——9287 Main St Apt 25, Austin, TX0.38Name split from “Last, First”Date of birth reformattedUnit split from streetZIP missing+3 more
TPA-50224TPAEvelyn Rodriguez1946-12-04——3046 Spring St, Nashville, TN, 372580.38Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-58985TPAJerry XJunk1939-03-08——8116 Ridge Rd, Nashville, TN0.38Street suffix standardisedAddress re-casedZIP missingGender normalised+3 more
TPA-52545TPAMateo Ryan1944-05-21——5949 Meadow Ln, Dallas, TX, 752010.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-59194TPAJanice Sandoval—UHC-66768-58—8538 Highland Ave # 767, Orlando, FL, 328520.38Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-61497TPADorothy Fisher1990-08-05——9204 Apache Blvd # 379, Los Angeles, CA0.38Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-52519TPAAbigali Welch1998-11-24UHC-47178-19—1621 Union St, Nashville, TN, 372070.38Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-53198TPAScott Simmons1976-01-09—87689321582254 Lake View Rd, Mesa, AZ, 852260.38Two-digit birth yearPhone reformattedSSN last four extractedZIP+4 trimmed+3 more
TPA-64031TPALinda Munoz——22780879605984 Harbor Blvd Apt 19, Columbus, OH, 432610.38Name split from “Last, First”Date of birth unreadableUnit split from streetStreet suffix standardised+3 more
TPA-63649TPAGabriel K Ross1980-11-08UHC-60294-05—2470 Hillcrest Rd, Jacksonville, FL, 322960.38Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-52960TPAGloria Stnoe1965-04-03——2107 Park Pl, Charlotte, NC, 282020.38Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-51239TPARandy Tucker1975-05-03——8420 Central Ave, Jacksonville, FL, 322480.38Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-60092TPACarol Pierce—UHC-80359-24—7677 Baseline Rd Apt 33, Fresno, CA, 937730.38Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
TPA-51470TPAMargaret Daniels———6083 Canyon Rd Apt 32, Tucson, AZ, 857250.38Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-62063TPAIsabella George—UHC-68744-67—9793 Lake View Rd Apt 23, Austin, TX0.38Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-52279TPAJoseph Kennedy1956-12-21——2817 Harbor Blvd, Tucson, AZ, 857630.38Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-62980TPAAnna Miller1948-02-12——5134 Spring St Apt 10, Glendale, AZ, 853660.38Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-54618TPAFrankJunk1983-04-08——8890 Lincoln Way, Chandler, AZ, 852230.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-51757TPAHarold West1994-04-02—40557959794445 Sage Ct, Seattle, WA, 981620.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-55954TPABenjamin Peters2006-10-23——8029 Mesa Dr Apt 28, Houston, TX, 770140.38Date of birth reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
TPA-61098TPAAhmed Rose1972-11-01UHC-11855-20—4535 Camelback Rd, Seattle, WA0.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
TPA-58755TPAKelly Vasquez——83682681362110 Church St Apt 30, Mesa, AZ, 852740.38Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-53033TPAJesse Brooks1959-09-04——7865 Meadow Ln Apt 17, Eden Prairie, MN, 553650.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-54742TPADJunk1958-05-15UHC-96374-1552996987034017 Main St, Las Vegas, NV, 891610.38Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-51745TPASam Estrada1976-06-12—21281895821665 Palm Dr Apt 10, Dallas, TX, 752660.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-57049TPANathan Burns1951-06-09——9807 Mesa Dr # 200, Austin, TX, 787790.38SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-63037TPASteve King1969-01-20——5493 Meadow Ln, Los Angeles, CA, 900190.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
TPA-56725TPAAmy Lawrence2003-09-23——2012 Mountain View Dr Apt 20, Denver, CO, 802470.38Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-63933TPAMary Freeman1989-10-16——2156 Highland Ave Apt 8, Sacramento, CA, 958920.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-54888TPAKenneth Fuller———7076 Lake View Rd, Seattle, WA, 981760.38Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+3 more
TPA-53079TPADavid Henry——45930830734431 Harbor Blvd, Charlotte, NC0.38Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-56774TPAHiroshi Gilbert1958-01-09——1631 Sunset Blvd Apt 3, San Antonio, TX, 782070.38Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-50464TPAJanet Gibson1966-08-04——8053 Mesa Dr, Jacksonville, FL0.38Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-60865TPAJose Ford———7094 Jefferson Ave, Mesa, AZ, 852120.38Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-63000TPATeerry Fernandez1991-06-18——2920 Pine Dr, Atlanta, GA, 303300.38Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-51181TPAPatrcik T Grant1963-01-08——592 Apache Blvd, Atlanta, GA, 303720.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-57027TPAJudith Mills1943-05-28—39481505867674 Pine Dr, Denver, CO, 802050.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
TPA-61249TPATheresa Gonzales2007-09-28——3488 Lake View Rd Apt 33, Nashville, TN, 372220.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
14,474 rows, page 4 of 290PreviousNext