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-402163CLMCynthia George1997-10-13UHC-88626-78—8035 Lincoln Way, Los Angeles, CA0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414362CLMBarbara Oliver—UHC-71536-77—2343 Sunset Blvd, Austin, TX, 787780.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-408767CLMAmy Young1955-08-07—58537530721598 Pine Dr Apt 23, Tucson, AZ, 857840.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-404560CLMDavid Daniels2001-05-25UHC-45682-55—9352 Maple Ave, Houston, TX, 770430.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405626CLMTimothy Howell1953-09-28UHC-30686-19—5103 Oak St, Plano, TX, 750620.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-432146CLMDunna Lawson1938-12-06——789 Mesa Dr, Dallas, TX, 752040.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422096CLMHiroshi Nunaz1967-05-09UHC-58279-9824069326401799 Palm Dr, Nashville, TN, 372190.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-419892CLMLucia D Thompson1985-12-14UHC-83698-89243416666019 Pine Dr, San Antonio, TX, 782230.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407525CLMKelly Nunez1969-07-08—69342794392972 Washington St, Phoenix, AZ, 850250.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-426758CLMAngela O Alvarado1959-12-04UHC-73919-1894352864788517 Valley View Dr, Jacksonville, FL, 322480.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429440CLMTimothy Jacobs1971-04-01UHC-40832-18—507 Bayshore Dr, Sacramento, CA0.64Member ID reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-414702CLMCynthhia Green1979-06-21——1316 Jefferson Ave, Orlando, FL, 328830.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-430920CLMMegan Montgomery1958-12-25UHC-67886-41—3088 Ocean Ave, Tempe, AZ, 852640.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429235CLMNatalie Bennett1981-07-06UHC-11118-6734645965152327 Palm Dr, Nashville, TN, 372580.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429385CLMMadison Graham1948-02-25UHC-92091-04—1690 Forest Ave, Glendale, AZ, 853690.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402152CLMIsabella Padilla1985-11-09UHC-80057-92—9572 Forest Ave, Jacksonville, FL, 322070.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-430552CLMJulie Wilson1948-09-17UHC-32209-8533434210546180 Canyon Rd, Orlando, FL, 328390.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405268CLMRussell F Gibson1954-06-12UHC-03948-1279562158068245 Ocean Ave, San Antonio, TX, 782080.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-414527CLMNancy Cole2002-04-25UHC-89188-42—8672 Bayshore Dr, Atlanta, GA, 303240.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-408750CLMPatricia Gomez1940-10-24UHC-71807-5229284186743964 Highland Ave, Scottsdale, AZ, 852990.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428602CLMAisha Rojas1956-12-18——6374 Ocean Ave, Dallas, TX, 752080.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-406922CLMBrenda Coleman1993-09-06UHC-19276-60—8164 Oak St, Tucson, AZ, 857510.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-419337CLMFatima Espinoza1987-11-15——27 Central Ave Apt 1, Miami, FL, 331800.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-431362CLMNicole Gonzales1941-02-13UHC-80545-64—4175 Forest Ave # 860, Orlando, FL0.64Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+2 more
CLM-406230CLMMkie Murphy1979-09-25UHC-74131-37—4048 Broadway, Chandler, AZ, 852510.64Date of birth reformattedMember ID reformattedSSN last four extractedZIP+4 trimmed+2 more
CLM-420670CLMNathan Murray1947-07-27—43197475921602 Forest Ave, Minneapolis, MN, 554690.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408601CLMArthur Lucas1983-09-11UHC-03901-28—2547 Ocean Ave, Nashville, TN, 372280.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-427568CLMFatima Warren1943-01-18UHC-57298-39—9247 Oak St, Minneapolis, MN, 554530.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416461CLMJonathan H Mason1958-03-06—25573870098561 Mesa Dr Apt 29, Minneapolis, MN, 554670.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-431056CLMJudith Hernandez1964-01-21UHC-86313-1720459592601817 Oak St, Chandler, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-411881CLMKelly Alvarado1995-09-15UHC-05605-02—2379 Canyon Rd, Jacksonville, FL0.64Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-405046CLMPaul Garza1981-06-15UHC-77971-56—1297 Central Ave, San Antonio, TX0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-417315CLMLori U Obrien1982-05-16——232 Indian School Rd, San Diego, CA, 921910.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422837CLMJoshua Dominguez1988-11-04UHC-51478-26—9333 Park Pl, Houston, TX, 770030.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416508CLMAndrew Griffin1956-09-07UHC-72617-994723649707644 Palm Dr Apt 35, Atlanta, GA, 303880.64Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
CLM-416507CLMAndrew Griffin1956-09-07UHC-72617-994723649707644 Palm Dr Apt 35, Atlanta, GA, 303880.64Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
CLM-417176CLMRussell Herrera1968-07-06—26624008158097 Central Ave, Gilbert, AZ, 852220.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-400490CLMFrances Bailey1977-09-15UHC-79037-98—4314 Mountain View Dr, Jacksonville, FL, 322930.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-428208CLMAbby Murray1972-02-02——3973 Union St, Jacksonville, FL, 322000.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-401555CLMEd Baker———5237 Jefferson Ave, Denver, CO, 802530.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-414797CLMJulia Weber1984-11-10UHC-99785-7084124126787153 Lake View Rd, Las Vegas, NV, 891240.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-430025CLMNatalie I Long1945-08-09—92655183967118 Pine Dr, Gilbert, AZ, 852910.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407133CLMSofia C Thomas2001-05-06——4069 River Rd, Mesa, AZ, 852540.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-427793CLMAlice Austin1992-08-28UHC-95346-51—8627 Harbor Blvd, Phoenix, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-409542CLMMark Knight1979-12-25——7891 Apache Blvd # 767, Eden Prairie, MN, 553910.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-408955CLMHeather J Porter2004-08-24UHC-28711-83—4648 Baseline Rd, Charlotte, NC0.64Name re-casedDate of birth reformattedCity re-casedState name converted to code+2 more
CLM-429668CLMChristine Snyder1993-04-25UHC-52575-45—5818 River Rd Apt 20, Gilbert, AZ, 852990.64Unit split from streetStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-405276CLMAlexander Crawfodr1994-02-06UHC-69787-09—1954 Ocean Ave, Los Angeles, CA, 900870.64Name re-casedDate of birth reformattedSSN last four extractedGender normalised+2 more
CLM-407959CLMBeverly Gonzales1944-03-03UHC-28012-85—7684 Harbor Blvd, Columbus, OH, 432470.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-432595CLMEmily Hamilton1958-04-24UHC-45306-2979277847351869 Apache Blvd # 528, San Antonio, TX, 782780.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
32,829 rows, page 117 of 657PreviousNext