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-414350CLMWei Castillo1960-11-18—90624394682397 Willow Ct, Eden Prairie, MN, 553920.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-431418CLMJoan Elliott1983-05-03——8888 Central Ave Apt 27, Miami, FL, 331580.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-431419CLMJoan Elliott1983-05-03——8888 Central Ave Apt 27, Miami, FL, 331580.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-401705CLMSean Nunez1997-10-03UHC-98948-59—4431 Forest Ave # 376, Fresno, CA, 937040.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-410287CLMAnddrea P Schmidt2002-05-19UHC-90377-4847479233545670 Grand Ave, Eden Prairie, MN0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-401127CLMJordan Welch2001-11-13UHC-43144-8327121672412704 Maple Ave, Denver, CO0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415267CLMAlbert Richards1994-01-03—34650883913265 Church St, Chandler, AZ, 852460.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432532CLMDonald Wallace1966-05-22UHC-15888-67—3382 Main St, Austin, TX, 787630.62Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-402436CLMDenise Perkins1971-11-25UHC-55403-36—5125 Oak St, Glendale, AZ, 853090.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412622CLMVincent George1996-04-01UHC-05005-65—1886 Market St, Miami, FL, 331470.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400738CLMShirley Bell1971-11-04—76858917338891 Washington St, Houston, TX0.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-416198CLMJustin Jenkins1957-12-15UHC-35967-43—9632 Palm Dr, Scottsdale, AZ, 852500.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425894CLMSamantha Murphy1977-09-03——2756 Hillcrest Rd, Las Vegas, NV, 891950.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-427170CLMBryan Black1940-01-26——985 Apache Blvd, Minneapolis, MN, 554120.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425802CLMRob Guerrero1947-06-24UHC-60022-4546194743508843 Ocean Ave, Seattle, WA, 981840.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421534CLMKelly Griffin1977-04-10—2832347520172 Hillcrest Rd, Glendale, AZ, 853340.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404174CLMSteevn Little1956-12-22UHC-14266-65—5404 Market St, Houston, TX, 770690.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-406096CLMAlan Tran1970-06-06UHC-55420-11—7475 Valley View Dr Apt 21, Nashville, TN, 372920.62Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-403016CLMNancy Vazquez1967-08-27UHC-61543-39—1015 Meadow Ln, Seattle, WA, 981150.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421538CLMCharles Payne1954-10-06UHC-44575-4726468737844594 Ocean Ave Apt 3, Atlanta, GA, 303680.62Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more
CLM-424442CLMLawrence Ortiz1977-03-25—37085352803355 Highland Ave, Dallas, TX, 752490.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-417394CLMAaorn M Flores—UHC-86224-7855631332626857 Valley View Dr, Glendale, AZ, 853650.62Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-419714CLMSean Morgan2005-10-24UHC-75819-9264363728802936 Canyon Rd, Las Vegas, NV, 891330.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-400261CLMLarry Wilson1953-11-08UHC-26116-5076942058019437 Valley View Dr, Denver, CO, 802800.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405390CLMTimothy D Rice1984-10-08UHC-04382-4430375883553691 Grand Ave, Eden Prairie, MN, 553840.62Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-402982CLMKevin Henderson1962-05-24—50444397573850 Ocean Ave, Los Angeles, CA, 900570.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419959CLMDoris W Gilbert1969-12-25UHC-87880-2374431701465809 Forest Ave, Columbus, OH, 432630.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412772CLMHenry U Alexander1942-11-02—89623003346897 Indian School Rd, Gilbert, AZ, 852630.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-416033CLMMarcus J Tukker2000-11-21—60691592666343 Palm Dr, Austin, TX, 787990.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-401511CLMAnna M Sanchez1964-01-06UHC-55023-31—879 Palm Dr, Austin, TX0.62Name re-casedDate of birth reformattedCity re-casedState name converted to code+3 more
CLM-428479CLMLinda Boyd1993-03-26—92131916423073 Highland Ave, Jacksonville, FL, 322820.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-410560CLMThomas Walker1999-03-19UHC-98355-06—5048 Market St, Glendale, AZ, 853980.62Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+3 more
CLM-409109CLMDonald Wlaker2002-06-26UHC-23250-4829696529316076 Palm Dr, Tempe, AZ0.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425158CLMVictoria Patel1938-09-08UHC-56400-5321863745784249 Maple Ave, Orlando, FL, 328190.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-417391CLMMatt Anderson1982-11-25UHC-67789-26—3229 Pine Dr, Scottsdale, AZ, 852150.62Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-406404CLMMarcus Munoz1972-08-23—73089652191896 Baseline Rd, Orlando, FL, 328880.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-405526CLMDanielle Walsh1984-02-04—94599869669278 River Rd, Columbus, OH, 432500.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-405012CLMEugene Romero1966-01-01—76299135114701 Oak St # 253, Jacksonville, FL0.62Name re-casedPhone reformattedUnit split from streetCity re-cased+3 more
CLM-403297CLMSamuel Santiago1981-08-01UHC-16102-1038549592649460 Hillcrest Rd, Los Angeles, CA, 900430.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427228CLMChristine Ortega1969-09-22UHC-41954-7183821865983529 Market St, San Diego, CA, 921770.62Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-421498CLMWilliam Kim2003-05-19—45887297959073 Cedar Ln, Mesa, AZ, 852270.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417807CLMGregory Smith1980-08-27UHC-84719-8528432010629597 Sage Ct # 467, Charlotte, NC, 282670.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-423830CLMElijah Day1964-05-06UHC-27074-9396228664866639 Union St # 625, San Antonio, TX, 782550.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-409071CLMSantiago McDonald1991-02-20—55965074919803 Canyon Rd, Denver, CO, 802070.62Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
CLM-428693CLMLucia Rios1938-04-02UHC-92720-51—5436 Camelback Rd # 958, Denver, CO, 802480.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-405366CLMCarolyn Green1963-05-12UHC-12560-6669363803942761 Main St, Sacramento, CA0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400153CLMJoseh Ward1982-07-04—36363411878400 Baseline Rd, Nashville, TN, 372020.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405389CLMAndrew Gutierrez1981-04-13UHC-30348-83—7873 Cedar Ln Apt 28, Los Angeles, CA, 900610.62Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-426817CLMStephanie G Ward1961-08-16—3893373742765 Jefferson Ave, Orlando, FL, 328350.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419152CLMLisa Guerrero1971-02-11UHC-93978-3157133360088703 Sunset Blvd, Phoenix, AZ, 850670.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 93 of 657PreviousNext