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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-22747PRVSophia Morris2002-02-22—77445687191447 Broadway # 331, Jacksonville, FL, 322330.38Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-102171ENRMartha Harrison1980-03-26UHC-15211-78—7138 Lincoln Way, Denver, CO, 802880.38Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+3 more
CLM-404937CLMSara Berry1946-03-16——2208 Park Pl, Dallas, TX, 752710.38Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-107939ENRDorothy X Hanson—UHC-22734-2476143929277142 Sage Ct, Eden Prairie, MN, 553130.38Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+3 more
CLM-400167CLMCharlotte Wheeler1964-03-13UHC-02876-57—8961 Park Pl # 800, Sacramento, CA, 958440.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-407950CLMJuan Weaver1948-10-15——9101 Harbor Blvd, Houston, TX, 770210.38Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-130337ENRJese Armstrong1941-04-03UHC-52920-63—2778 Elm St, Miami, FL0.38Two-digit birth yearPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
CLM-410177CLMHenry McDonald——70077951852866 Grand Ave, Orlando, FL0.38Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
ENR-131077ENRRaymond Washington1968-08-17UHC-78812-89—4238 Broadway, Mesa, AZ0.38Name split from “Last, First”Date of birth reformattedAddress re-casedState name converted to code+3 more
CLM-412229CLMYuki O King———3840 Canyon Rd, Miami, FL, 331790.38Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-407535CLMLawrence Anderson1993-11-13UHC-05595-0692158244675201 Valley View Dr # 920, Denver, CO0.38Name re-casedTwo-digit birth yearUnit split from streetZIP missing+3 more
CLM-429130CLMMary H Maldonado1962-05-10UHC-19356-2778154798342125 Willow Ct, Nashville, TN, 372070.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427987CLMGeorge Myers1939-07-26—39954385905516 Market St, San Antonio, TX, 782870.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-422404CLMMei Nuenz1994-04-25UHC-80915-35—1620 Jefferson Ave, Glendale, AZ, 853210.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-127156ENRCarl J Ross1984-10-05UHC-17816-3825479420749633 Pine Dr, Los Angeles, CA, 900830.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-409548CLMCatherine Patterson1959-07-24UHC-34815-1641645362587410 Spring St, Scottsdale, AZ0.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103993ENRGregory Chavez1968-05-15UHC-38992-2762752080197768 Elm St, Columbus, OH, 432580.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29046PRVJose Alexander1974-01-13UHC-74261-4150965831893114 Highland Ave, Nashville, TN, 372770.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+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
CLM-409596CLMAlbert G Payne1943-07-04—54526849311534 Highland Ave Apt 3, Charlotte, NC0.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-138480ENRRoger Henry1957-05-03—70651225469587 Harbor Blvd, Eden Prairie, MN0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410904CLMCharles Dunn1993-10-24UHC-26801-85—4956 Meadow Ln, Columbus, OH, 432880.38Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+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
ENR-103507ENRMarcus Y Marshall1992-01-02UHC-36910-73—9121 Baseline Rd Apt 18, Mesa, AZ, 852260.38Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
ENR-110514ENRJoshua R Hayes1956-04-13UHC-85275-2259185841283922 Hillcrest Rd, Eden Prairie, MN, 553030.38Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424845CLMKeelly Andrews1945-12-17UHC-58244-95—6786 Washington St Apt 8, Scottsdale, AZ, 852720.38Phone missing area codeUnit split from streetStreet 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
ENR-138481ENRMason B Hill—UHC-48547-9459397789674209 Elm St, San Diego, CA, 921410.38Name split from “Last, First”Date of birth reformattedDate of birth unreadablePhone reformatted+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
CLM-421870CLMBrenda Grant1962-10-21UHC-92926-8674891825439067 Baseline Rd, Sacramento, CA, 958820.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-416337CLMAlbert Daniels1954-05-11UHC-88907-2869964477485558 Oak St # 833, Tampa, FL, 336810.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+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
CLM-413900CLMJudith P Cooper1987-11-05UHC-87105-36—117 Apache Blvd, Charlotte, NC, 282190.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-23908PRVAlice Black1995-09-01—48874272558121 Ocean Ave, Los Angeles, CA, 900400.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418699CLMGeorge E Shaw1948-10-02——6572 Bayshore Dr Apt 8, Tucson, AZ, 857800.38Name re-casedUnit 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
ENR-132049ENRKen Reynolds1948-05-04UHC-87659-0167835980881528 Jefferson Ave # 136, Gilbert, AZ, 852110.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-22217PRVLawrence Maldonado1994-07-20—81329809197498 Main St, Glendale, AZ0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420167CLMSusan Borwn1984-06-20——817 Maple Ave, Jacksonville, FL, 322840.38Name split from “Last, First”SSN 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
ENR-136686ENRChristina Rose1999-01-02UHC-21461-7589488642441652 Indian School Rd Apt 5, Scottsdale, AZ, 852700.38Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+3 more
PRV-28650PRVChristopher Davis1986-04-14——6306 Jefferson Ave, Atlanta, GA, 303010.38Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-22293PRVLuis Carlson—UHC-63765-77—8906 Meadow Ln, Tempe, AZ0.38Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-423147CLMBobby Admas—UHC-70130-54—8522 Spring St, Plano, TX0.38Name split from “Last, First”Date of birth unreadableStreet 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
CLM-406468CLMShirley Collins1960-07-07UHC-48765-8320999895942678 Pine Dr # 987, Tucson, AZ, 857900.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-103570ENRMaria T Nelson1995-08-18UHC-81446-6097484009413563 Highland Ave, Atlanta, GA, 303240.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20182PRVKenneth Dunn1950-03-15UHC-30577-22—345 Harbor Blvd, Atlanta, GA, 303900.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-132395ENRKatherine O Silva1939-05-20UHC-05146-6858943211187888 Valley View Dr # 573, Las Vegas, NV, 891620.38Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-123824ENRHelen Marshall1965-06-04UHC-81480-6193848685526645 Washington St, Austin, TX, 787620.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
100,000 rows, page 30 of 2,000PreviousNext