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-400214CLMLori Parker1949-09-28UHC-06551-0529277355265635 Elm St Apt 2, Chandler, AZ, 852380.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-407479CLMTyler Fernandez1978-08-14UHC-64576-9266723768264638 Mountain View Dr, Los Angeles, CA, 900250.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-409017CLMMichelle Kennedy1967-01-05UHC-59953-5323856319114335 Sunset Blvd, Miami, FL0.62Name re-casedDate of birth reformattedCity re-casedZIP missing+3 more
CLM-417224CLMBarbara Garza1988-06-23UHC-50918-3966153096693720 Mesa Dr, Dallas, TX, 752680.62Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-429452CLMMelissa Burns1981-06-05UHC-05550-71—5052 Willow Ct Apt 30, Gilbert, AZ, 852180.62Name re-casedDate of birth reformattedUnit split from streetCity re-cased+3 more
CLM-423943CLMMichelle Martin1980-04-09UHC-00811-86—4748 Central Ave, Jacksonville, FL, 322630.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424053CLMKimberly Gisbon2004-07-23UHC-59029-58—3019 Mesa Dr, Houston, TX0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-413490CLMCynthia Sandoval2002-04-06UHC-40936-8285227174829753 Lake View Rd, Austin, TX, 787870.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-405099CLMMarilyn Romero1954-08-02UHC-22595-40—2973 Main St # 195, Eden Prairie, MN, 553380.62Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-405098CLMMarilyn Romero1954-08-02UHC-22595-40—2973 Main St # 195, Eden Prairie, MN, 553380.62Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-418073CLMZachary Maldonado1987-02-22UHC-14103-5648998774273999 Union St, Houston, TX, 770830.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403349CLMAna O Santos1940-10-17UHC-93279-7359099737367064 Indian School Rd, Tucson, AZ, 857790.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420559CLMNancy Ferguson1971-04-10—9894813491664 Grand Ave, Atlanta, GA, 303190.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-404541CLMSusan Rojas1992-10-15UHC-20787-07—8780 Central Ave, Tampa, FL0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-431413CLMJack Washington1976-04-18UHC-15231-0679133362076824 Park Pl, Austin, TX, 787720.62Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-421103CLMCarol Li1982-07-11——8392 Elm St, Jacksonville, FL0.62Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-403665CLMMichelle Perkins1962-12-16UHC-72207-33—7224 Lake View Rd, Tampa, FL, 336720.62Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-409839CLMVictoria P Mitchell1982-05-08UHC-89946-94—4460 Mountain View Dr, Nashville, TN, 372070.62Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-404632CLMVictoria Howell1975-03-19UHC-24098-48—6828 Spring St, Las Vegas, NV, 891120.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408563CLMCarol Espinoza1980-12-21——6314 Hillcrest Rd, Mesa, AZ, 852860.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-406350CLMJoe Bishop2006-09-16UHC-31239-0521153423994760 Canyon Rd, Phoenix, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410582CLMWalter S Griffin1960-02-26——6093 Hillcrest Rd, Columbus, OH, 432950.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425465CLMAndrew Soto1961-11-26—60058355657349 River Rd, Los Angeles, CA, 900430.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-418244CLMKayla C Reiid1950-11-06UHC-05355-8795274513991181 Sage Ct, Plano, TX, 750140.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425104CLMMrak Jimenez1974-06-08—53657346553333 Valley View Dr, Denver, CO0.62Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-408217CLMMaria A Valdez1942-10-01——7473 Central Ave, Gilbert, AZ, 852360.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421634CLMJustin Nguyen1975-03-19—92678971249384 Park Pl, San Antonio, TX, 782740.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-419565CLMAndrea Russell1944-08-16UHC-54510-32—8847 Apache Blvd # 841, Plano, TX, 750590.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-417233CLMCharles Butler1971-12-12UHC-81045-6982951460674407 Harbor Blvd, Tucson, AZ, 857180.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431039CLMOrtega N Madison2006-08-14—6087088136689 Lincoln Way, San Antonio, TX, 782320.62Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+3 more
CLM-426140CLMShaaron Burns1951-01-25UHC-89486-516054189476695 Oak St, Scottsdale, AZ, 852910.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-426139CLMShaaron Burns1951-01-25UHC-89486-516054189476695 Oak St, Scottsdale, AZ, 852910.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-415187CLMGabriel H Taylor1973-05-24UHC-69788-782072861977916 Apache Blvd, Eden Prairie, MN, 553450.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-415010CLMSofia Rice1966-12-03UHC-06230-5737431162837745 Meadow Ln, Charlotte, NC, 282500.62Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-426500CLMGregory Alvraez1982-03-27—25659089251067 Oak St Apt 2, Tempe, AZ, 852290.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-410267CLMMichael B Evans2006-09-04—91458374148354 Maple Ave, Orlando, FL, 328560.62Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419777CLMMarcus Stone1945-07-21UHC-59211-18—7056 Pine Dr, Tucson, AZ0.62Member ID reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-410403CLMMichael Willis1983-03-07—91131242296056 Lake View Rd # 511, Las Vegas, NV, 891570.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-423633CLMRyan Hill1997-08-08UHC-00515-59—196 Highland Ave, Tucson, AZ, 857600.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-407682CLMMegan Z Carr1926-08-16UHC-74416-4188566080892579 Meadow Ln, Los Angeles, CA0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411709CLMAnthony Carr——58146297058920 Sage Ct, Mesa, AZ, 852730.62Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407122CLMSamantha Freeman1977-05-08UHC-78622-78—1512 Camelback Rd, Scottsdale, AZ, 852430.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429317CLMJose Day2004-10-04UHC-65678-01—3940 Desert Sky Blvd, Plano, TX, 750350.62Name re-casedDate of birth reformattedCity re-casedZIP+4 trimmed+3 more
CLM-429316CLMJose Day2004-10-04UHC-65678-01—3940 Desert Sky Blvd, Plano, TX, 750350.62Name re-casedDate of birth reformattedCity re-casedZIP+4 trimmed+3 more
CLM-408214CLMJean Z Ford1987-02-01——4871 Pine Dr, San Antonio, TX, 782460.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-414450CLMAshley Valdez1999-02-10—2358623232483 Hillcrest Rd, Glendale, AZ, 853880.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416433CLMDouglas Burns1994-09-24UHC-49808-0173222221903300 Mesa Dr, San Antonio, TX, 782760.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429708CLMStephen Harris1981-05-01UHC-18032-11—9649 River Rd # 128, Chandler, AZ, 852460.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-415960CLMMarilyn Walker1999-12-09—5236517965721 River Rd, Minneapolis, MN, 554430.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-405311CLMLogan Williams1942-05-11UHC-25542-3092335159019681 Jefferson Ave, Fresno, CA, 937230.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
32,829 rows, page 95 of 657PreviousNext