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-408816CLMVicoria Franklin———5345 Valley View Dr, Denver, CO0.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-431476CLMWalter Schmidt1969-06-01UHC-99198-9189424875298499 Elm St, Charlotte, NC0.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-430907CLMEugne Edwards1968-07-25——6041 Ridge Rd, Mesa, AZ, 852180.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-410745CLMVega P Joan1975-02-05—74599712912744 Market St, Glendale, AZ, 853310.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412861CLMMarc Burke2008-04-17UHC-79080-92—4628 River Rd Apt 26, San Antonio, TX, 782780.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-412466CLMAlexis Watkins1946-10-08UHC-25813-0162346315353596 Elm St, Orlando, FL, 328610.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405638CLMBrandon Snyder—UHC-55662-93—8063 Pine Dr, Nashville, TN, 372480.50Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-400495CLMJudith Gonzales1995-04-21UHC-65932-60—144 Canyon Rd, Seattle, WA, 981950.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-400496CLMJudith Gonzales1995-04-21UHC-65932-60—144 Canyon Rd, Seattle, WA, 981950.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-419924CLMWayne Davis1956-05-25UHC-67278-9624484152144681 Oak St, Eden Prairie, MN, 553090.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-426723CLMGeorgeJunk1944-02-26UHC-26152-27—4249 Union St, Scottsdale, AZ, 852130.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428923CLMGrace Y Palmer2008-06-23UHC-85177-5983774571006124 Hillcrest Rd, Tempe, AZ, 852530.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-402427CLMJames Chen1961-02-13UHC-30142-5285940095012201 River Rd, Tucson, AZ, 857040.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414181CLMMason Russell——95121859923902 Apache Blvd, Miami, FL, 331460.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-418393CLMMaria Reid1943-06-02UHC-95329-63—8664 Mountain View Dr, Las Vegas, NV, 891980.50Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-422422CLMThomas U Baker1955-02-04——9431 Desert Sky Blvd Apt 39, Eden Prairie, MN, 553920.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408402CLMPatricia Chavez1998-04-09UHC-71200-9335150978043111 Desert Sky Blvd Apt 39, Denver, CO, 802370.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-412024CLMDieggo X Kennedy1961-05-03UHC-16765-65—9183 Apache Blvd, Austin, TX0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-420862CLMJaon R Meyer1967-01-24UHC-84985-1673832959704967 Hillcrest Rd, Gilbert, AZ, 852090.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402772CLMJoseph Alexander1951-07-26—21961230306930 Washington St, Austin, TX, 787520.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416758CLMWalter Black—UHC-18775-66—5693 Palm Dr, Glendale, AZ, 853360.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-420671CLMRussell Hart1977-05-15——6357 Cedar Ln, Dallas, TX, 752180.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-432748CLMMaria Fields1944-03-23——7659 Hillcrest Rd, Minneapolis, MN, 554890.50Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
CLM-429323CLMJordan Robertson1979-09-13——1875 Ocean Ave, Tempe, AZ, 852160.50Name re-casedDate of birth reformattedSSN last four extractedZIP+4 trimmed+3 more
CLM-427517CLMCatherine Chen1941-03-06UHC-58328-78—3233 Sunset Blvd, Plano, TX0.50Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-410765CLMBrittany Fowler1948-04-11—77383111154303 Lake View Rd Apt 28, San Antonio, TX, 782740.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-400698CLMMarcuus Collins1946-03-20UHC-00187-2837725247343486 Harbor Blvd, Fresno, CA0.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-407227CLMVincent Lee1979-01-01UHC-40504-2568977459664326 Sunset Blvd, Houston, TX, 770680.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412718CLMJanice K Patel1993-06-11UHC-60883-6556586490432290 Central Ave, Phoenix, AZ0.50Date of birth reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-401292CLMChristopher Coleeman1950-04-12——1911 Ocean Ave, Miami, FL, 331720.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-427401CLMAmy X Gonzalez1984-04-03—45625959126841 River Rd Apt 35, San Diego, CA, 921190.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-430580CLMMatthew K Long1990-05-18UHC-59379-93—5571 Meadow Ln, Glendale, AZ0.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-418234CLMEguene Soto1991-01-02——9360 Lake View Rd, Eden Prairie, MN0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-410229CLMRussell Hicks1974-03-05UHC-25635-113292866762294 Central Ave, Charlotte, NC, 282840.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
CLM-415304CLMAmy Lawrence2003-09-23——2012 Mountain View Dr, Denver, CO, 802470.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-421445CLMJulie Vasquez1944-08-01UHC-85680-4898323857564713 Jefferson Ave, Tampa, FL, 336130.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-421446CLMJulie Vasquez1944-08-01UHC-85680-4898323857564713 Jefferson Ave, Tampa, FL, 336130.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-400216CLMHarold Pena1997-05-15—41587012421236 Union St, Charlotte, NC, 282390.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400215CLMHarold Pena1997-05-15—41587012421236 Union St, Charlotte, NC, 282390.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408945CLMPat Lawis1979-06-05UHC-15634-1261842346634359 Forest Ave, Nashville, TN, 372770.50Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400010CLMRay Walsh1951-11-03UHC-09175-90—764 Baseline Rd, Seattle, WA, 981980.50Phone missing area codeStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-418782CLMWei Ramos1994-12-25UHC-46923-4044158810855493 Elm St, Gilbert, AZ, 852050.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426745CLMBrenda Butler1947-12-28——3051 Church St, Los Angeles, CA, 900270.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-407356CLMMarilyn West1965-09-17UHC-51771-8590533293455435 Apache Blvd, San Diego, CA, 921560.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400504CLMDorothy Reyes1994-07-24UHC-45582-8668867679728886 Lake View Rd, Orlando, FL0.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-417140CLMValentina Wood1989-02-20——464 Oak St, Gilbert, AZ, 852970.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-427971CLMHannnah Bell1960-01-21—91928588759030 Market St, Plano, TX, 750190.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402158CLMRichard Barnes1980-12-12—74230956377756 Highland Ave, Houston, TX, 770210.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418235CLMDebra Hill1986-04-19——8220 Forest Ave Apt 15, Mesa, AZ, 852210.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-426227CLMSamantha Morris2004-09-22—84753549943973 Baseline Rd, Houston, TX0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 34 of 657PreviousNext