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-407554CLMJack I Ray1943-10-02UHC-32122-3588634002984554 Meadow Ln, Phoenix, AZ0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-416331CLMEllis Gerald1985-06-11—4103588512589 Mountain View Dr # 525, Tempe, AZ, 852520.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-417154CLMRachelJunk1959-08-26UHC-31823-84—7580 Maple Ave, Eden Prairie, MN, 553540.46Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+5 more
CLM-424978CLMDenise Anderson1987-05-16—29361298933970 Market St # 834, Las Vegas, NV, 891890.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-402098CLMBrittany Taylor1982-05-25UHC-75127-0968581179456710 Valley View Dr, Mesa, AZ, 852990.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-420193CLMWei Miller1949-03-27UHC-77831-8769777705103062 Camelback Rd, Phoenix, AZ0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-420533CLMMertha Q Salazar1982-06-10UHC-04503-8561340084128402 Pine Dr, Plano, TX, 750410.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-417786CLMWalter Chavez1994-05-07—34168095907980 Maple Ave, Austin, TX, 787610.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-426200CLMCheryl Padilla1978-04-06UHC-20056-0464466863729498 Forest Ave, Tempe, AZ, 852600.46Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-401362CLMCheryl Chen1997-10-27UHC-19223-3432133107973073 Park Pl, Plano, TX, 750930.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-403949CLMJohn W Perkins1943-11-03UHC-89638-3724637316249781 Harbor Blvd Apt 1, Houston, TX0.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-420194CLMBenjamin W Wood1948-01-20—59855889539764 Pine Dr, Charlotte, NC, 282930.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-422936CLMSusan X Webb1952-10-06——2347 Lincoln Way # 613, Eden Prairie, MN, 553900.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-415050CLMVincent Gutierrez1979-05-28—68075365394765 Hillcrest Rd, Sacramento, CA, 958990.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-432158CLMAmber A Greene1989-06-27—2667403546239 Oak St, Scottsdale, AZ, 852900.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-429611CLMGary Graham1991-05-19UHC-98479-75—6136 Willow Ct, Los Angeles, CA, 900380.46Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-400401CLMPayne Diego1962-04-18UHC-65200-0375780671669440 Mountain View Dr # 763, Scottsdale, AZ, 852130.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-407419CLMRachel O Mnoz2004-03-17UHC-15937-0489850846667646 Bayshore Dr, Eden Prairie, MN, 553070.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-430138CLMRonald Butler—UHC-23449-9283947081746971 Lake View Rd, Las Vegas, NV, 891620.46Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
CLM-416622CLMWayne Bailey2007-07-10—70772900548816 Forest Ave Apt 19, Phoenix, AZ0.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-405667CLMJacqueline V Fowler1999-12-16—27528651461885 Central Ave, Jacksonville, FL, 322210.46Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-407637CLMAna T Mason2002-01-10UHC-43455-6731222460698872 Highland Ave, Charlotte, NC, 282240.46Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-424073CLMJustin Williams1980-03-09UHC-22721-4895326415476948 Mesa Dr, Plano, TX, 750060.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-426550CLMAmanda R Hill2001-08-08UHC-75623-6493280614066405 Desert Sky Blvd # 144, Charlotte, NC, 282990.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-405836CLMVincent N Diaz1982-11-18——8142 Oak St # 687, Fresno, CA, 937350.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-420137CLMAlexander Patterson1965-06-14——5599 Desert Sky Blvd, Glendale, AZ, 853460.46Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more
CLM-420464CLMPatrick Valdez1950-04-27UHC-71408-63—5078 Canyon Rd Apt 38, Minneapolis, MN, 554320.46Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+5 more
CLM-412436CLMBobby Wetson1997-02-10UHC-36535-02—9708 Palm Dr, Tampa, FL, 336560.46Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-406828CLMVincent Hudson1943-07-18UHC-97933-5236252376748952 Market St # 836, Fresno, CA, 937020.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-418748CLMTony Taylor2004-02-11UHC-75125-2248451186481177 Sage Ct, San Antonio, TX, 782080.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-410961CLMScott Henderson1958-01-24UHC-32283-14—3879 Ridge Rd, Charlotte, NC, 282030.46Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+5 more
CLM-430113CLMWilliam Ray1943-10-22UHC-70885-4746293973233317 Indian School Rd # 876, Glendale, AZ, 853720.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-422939CLMTyler A Williamson1964-09-15UHC-85579-5151441502358609 Harbor Blvd, Tampa, FL0.46Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-426580CLMVincent Moore1979-05-25UHC-97868-67—7776 Market St, Miami, FL, 331450.46Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-420907CLMNoah Mendez1984-04-12UHC-58028-49—7772 Ridge Rd, Glendale, AZ, 853820.46Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+5 more
CLM-418240CLMAbigail Q Lawrence1988-07-20—4909450445708 Oak St, Denver, CO, 802180.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-412560CLMEmily Elliott—UHC-77462-2485697014238875 Lake View Rd, Nashville, TN, 372140.46Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+5 more
CLM-424206CLMJack Hart2002-11-04UHC-64143-0149546776713096 Lake View Rd Apt 7, Tempe, AZ, 852710.46Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
CLM-431068CLMAelxander C Reed2007-01-17——3769 Meadow Ln, Columbus, OH, 432210.46Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+5 more
CLM-402709CLMMarcus Richards2008-01-28UHC-72468-4974759560228720 Market St Apt 34, Atlanta, GA, 303820.46Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
CLM-431246CLMGregory Dean1986-04-16UHC-13315-6531590145107680 Lake View Rd, Columbus, OH, 432000.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-402286CLMOlivia Grant1994-07-23UHC-50903-76—631 Camelback Rd, Charlotte, NC, 282530.46Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-414996CLMLauren H Moreno1998-10-13UHC-40660-9824624158417155 Ocean Ave, Plano, TX0.46Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-406638CLMAmy Daniels2007-04-08UHC-31366-3675680229921993 Main St, San Antonio, TX0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-400252CLMJeremy Adams1971-07-04UHC-96734-6239879072244817 Oak St, Austin, TX, 787750.46Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-405980CLMLuis Reynolds1946-04-03UHC-81820-6540526450215142 Baseline Rd, Tucson, AZ0.46Name re-casedDate of birth reformattedPhone reformattedCity re-cased+5 more
CLM-402256CLMDebra Hoffman1989-03-03UHC-99555-5984271034129110 Grand Ave, Scottsdale, AZ0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-429371CLMLogan P Sanders1963-11-27—69949506985114 Forest Ave, Fresno, CA, 937690.46Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+5 more
CLM-410181CLMSandra Tucker1962-06-06—74951522514843 Grand Ave Apt 34, San Diego, CA, 921760.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-403010CLMDennis Nguyen2000-08-27UHC-55252-8894556563772025 Willow Ct, Nashville, TN, 372240.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
32,829 rows, page 13 of 657PreviousNext