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

Claims, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-415388CLMBrian D Hamilton1988-11-07UHC-98413-48—6554 Mesa Dr, San Antonio, TX, 782680.38Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+3 more
CLM-411068CLMBeverly Ryan1961-02-18——7221 Apache Blvd, Fresno, CA, 937340.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-430456CLMRalph Grcia—UHC-55034-74—2592 Forest Ave, Miami, FL, 331150.38Name re-casedDate of birth unreadableSSN last four extractedStreet suffix standardised+3 more
CLM-412520CLMJack E Fowler1955-03-01UHC-96462-49—4237 Central Ave, Scottsdale, AZ0.38Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-412540CLMSean Freeman1966-03-08UHC-70386-67—6878 Ocean Ave, Houston, TX0.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-415716CLMCharlotte Lopez1943-04-20UHC-02280-0265345224221647 Spring St, Tempe, AZ, 852360.38Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432345CLMMichael Weber1950-11-17UHC-80019-73—3529 Washington St, Columbus, OH0.38Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-425179CLMAmyJunk1968-11-16UHC-55275-97—9165 Maple Ave, Chandler, AZ, 852670.38Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-428911CLMBilly Q Lewis1942-04-19UHC-32201-16—1864 Main St, Eden Prairie, MN, 553690.38Name split from “Last, First”Phone missing area codeMember ID reformattedStreet suffix standardised+3 more
CLM-425630CLMNathan Reynolds1964-03-05UHC-87757-3369061417435436 Park Pl, Sacramento, CA, 958270.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411028CLMCarollyn Chen—UHC-46103-72—2822 Sunset Blvd # 837, Glendale, AZ, 853140.38Name split from “Last, First”Date of birth unreadableUnit split from streetStreet suffix standardised+3 more
CLM-428730CLMJoan Weber1956-02-06—83959746121837 Sunset Blvd # 641, Atlanta, GA0.38Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
CLM-422003CLMEllijah Payne2001-07-03UHC-20841-6292971230037940 Hillcrest Rd, Gilbert, AZ, 852730.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-432465CLMMichael Stewart—UHC-09021-3829634234906202 Washington St Apt 34, San Diego, CA, 921630.38Name split from “Last, First”Date of birth unreadablePhone reformattedUnit split from street+3 more
CLM-432464CLMMichael Stewart—UHC-09021-3829634234906202 Washington St Apt 34, San Diego, CA, 921630.38Name split from “Last, First”Date of birth unreadablePhone reformattedUnit split from street+3 more
CLM-410929CLMAlice Armstrong—UHC-01835-54—7640 Forest Ave Apt 18, Columbus, OH, 432610.38Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+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
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
CLM-410177CLMHenry McDonald——70077951852866 Grand Ave, Orlando, FL0.38Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+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
CLM-409548CLMCatherine Patterson1959-07-24UHC-34815-1641645362587410 Spring St, Scottsdale, AZ0.38Two-digit birth yearPhone reformattedStreet 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
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
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
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
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
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
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
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
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
CLM-400323CLMPeter Garrett1981-03-11—33278542448443 Oak St, Fresno, CA, 937830.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-405208CLMCharlotte Delgado1981-08-19—94370561728620 Baseline Rd # 835, Atlanta, GA, 303170.38Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-409296CLMStephanie B Hamilton—UHC-40363-22—6214 Baseline Rd, Columbus, OH, 432440.38Name split from “Last, First”Date of birth missingMember ID reformattedSSN last four extracted+3 more
CLM-427950CLMElijah Gilbert1998-08-12UHC-00785-53—7681 Canyon Rd Apt 30, Charlotte, NC, 282070.38Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-412515CLMCamila D James1946-05-03UHC-19721-31—6031 Oak St # 857, Eden Prairie, MN, 553540.38Middle initial moved out of first nameUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-432206CLMRussell Andrews———672 Bayshore Dr # 481, Los Angeles, CA, 900380.38Date of birth unreadablePhone missing area codeUnit split from streetStreet suffix standardised+3 more
CLM-420997CLMNicole Snyder1988-07-06UHC-47909-54—6336 Spring St, San Antonio, TX0.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-427876CLMMaria Palmer—UHC-45838-69—9185 Highland Ave, Las Vegas, NV0.38Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+3 more
CLM-409136CLMMariana Williamson—UHC-03230-89—1598 Desert Sky Blvd # 365, Phoenix, AZ, 850480.38Name split from “Last, First”Date of birth missingUnit split from streetCity re-cased+3 more
CLM-430426CLMJacqueline Mendoza1990-02-14UHC-51173-49—6121 Cedar Ln, Las Vegas, NV, 891100.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-414839CLMElijah Y Ferguson1965-08-27UHC-23904-16—1718 River Rd, Fresno, CA, 937920.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-416350CLMJesse W Greene1958-03-12UHC-31276-72—9216 Hillcrest Rd, Los Angeles, CA0.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-408699CLMShirley D Hunt1958-09-01UHC-53979-1050924605011390 Indian School Rd, Fresno, CA, 937890.38Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-431975CLMSamuel Ray1998-10-01UHC-71219-6732195835279124 Spring St, Charlotte, NC, 282990.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 8 of 657PreviousNext