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-426507CLMJordan Walker1988-02-19—25245092373465 Union St, Columbus, OH0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403326CLMHelen C Snyder1982-06-03—6307396842455 Grand Ave, Jacksonville, FL, 322760.62Date of birth reformattedPhone reformattedCity re-casedZIP+4 trimmed+3 more
CLM-400752CLMJulie Larson1947-06-08UHC-11789-96—8499 Meadow Ln, Columbus, OH, 432190.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405197CLMVictoria McCoy1998-05-22UHC-62971-3370184550618234 Oak St, Seattle, WA, 981000.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408434CLMRyan Diaz1991-04-01——1621 Willow Ct, Columbus, OH, 432950.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416017CLMFatima Butler1972-06-01UHC-49073-83—5607 Church St, Charlotte, NC, 282030.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418586CLMRaymond Powell1994-09-10UHC-91897-10—9283 Washington St, San Antonio, TX, 782340.62Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
CLM-412945CLMKyle Phillips1999-01-04—23574946462516 Harbor Blvd, Austin, TX, 787350.62Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-424682CLMWilliam Rivera1971-03-13UHC-47674-88—3566 Willow Ct, San Diego, CA0.62Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-403811CLMWillie Lawrence1981-01-26——2641 Forest Ave, Gilbert, AZ, 852900.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432084CLMWilliam U Wells1996-06-27UHC-43805-7293758783214905 Lake View Rd, Phoenix, AZ, 850850.62Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
CLM-402557CLMIsabella Cox1988-06-13UHC-02263-65—2062 Lake View Rd Apt 21, Fresno, CA, 937980.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-431956CLMDanielle P Cruz1946-12-22—81495986808974 River Rd, Seattle, WA, 981760.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-416142CLMKaren X Cook1983-02-04—60469586937461 Mountain View Dr, Fresno, CA, 937570.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425723CLMKathryn Jordan1963-06-15UHC-11277-4883134522805080 Sunset Blvd, Charlotte, NC, 282150.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-404988CLMChristina Kennedy1985-08-03UHC-24928-3521283471881803 Central Ave, Tucson, AZ, 857060.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409523CLMHarold Burns1998-04-20UHC-89167-11—6484 Central Ave # 508, Denver, CO, 802970.62Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+3 more
CLM-423506CLMJudith Romero—UHC-06958-0890238920815716 Indian School Rd, Charlotte, NC, 282210.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-414896CLMYuki Rusesll1992-02-03——365 Lincoln Way, Los Angeles, CA, 900040.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422312CLMHiroshi Morgan1994-04-16UHC-20795-47—1282 Sunset Blvd, Atlanta, GA, 303610.62Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-426295CLMArthur Cooper1999-02-02UHC-27455-4196975364602750 Ridge Rd, Fresno, CA, 937110.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-406878CLMEugene Fisher1969-09-25UHC-45550-4240971579538143 Baseline Rd # 879, Chandler, AZ, 852580.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-401140CLMLogan Sims1982-02-26UHC-95454-322538180435539 Meadow Ln # 390, Houston, TX, 770060.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-405654CLMNicole Hall1980-02-28UHC-51352-2574130685417074 Desert Sky Blvd, Seattle, WA, 981200.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412788CLMVincent Mitchell——33158010809713 Spring St, San Diego, CA, 921520.62Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-411790CLMSam V Romerro1976-08-07UHC-70881-28—909 Lincoln Way # 740, Minneapolis, MN, 554470.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-409958CLMAlice Armstrong1999-11-04——5394 River Rd, Charlotte, NC, 282280.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-420144CLMChristian Medina1940-01-01UHC-21221-4590445980033666 Park Pl, Eden Prairie, MN, 553470.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410333CLMRyan Howard1982-12-13UHC-83733-3369144183736856 Oak St # 707, Jacksonville, FL, 322620.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-413980CLMSam Padilla1955-10-19—30527143926345 Jefferson Ave, Minneapolis, MN, 554700.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-419133CLMAshley Nugyen1974-03-23UHC-35779-0686625981907992 Meadow Ln, Miami, FL, 331840.62Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+3 more
CLM-431204CLMBradley Jones1962-03-17—74757212606499 Bayshore Dr, Houston, TX, 770640.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411095CLMBrittany Stephens1945-01-14UHC-39290-8297957778653384 Oak St, Columbus, OH, 432010.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414725CLMBenjamin Hansen1939-12-09UHC-98600-374323077747723 Lincoln Way, Scottsdale, AZ, 852760.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431296CLMVasquez S David1976-04-28UHC-87418-32—414 Sage Ct, Scottsdale, AZ, 852310.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428107CLMBruce Harvey2004-03-21UHC-68683-37—9486 Indian School Rd, Orlando, FL, 328760.62Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-408651CLMKatherine Williamson1999-08-27—29087761616785 Sunset Blvd, Tucson, AZ, 857600.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421193CLMAlice Gonzalez1968-02-14UHC-10661-4591082485468376 Ridge Rd, Seattle, WA, 981320.62Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more
CLM-400334CLMTerry Edwards—UHC-82887-9791463554921429 Desert Sky Blvd, Miami, FL, 331690.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-430271CLMAarn Murphy1990-05-14UHC-37198-4989261962948259 Pine Dr, Phoenix, AZ, 850420.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-421578CLMMichael Hanson1983-07-01UHC-75772-33—3342 Sage Ct, Fresno, CA, 937380.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-412241CLMVictoria O Ross1978-06-16—38068059128429 Camelback Rd, Dallas, TX, 752510.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419092CLMVincent Gilbert2005-03-11UHC-99716-09—5120 Cedar Ln, San Diego, CA, 921580.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-416514CLMEugene Crawford1979-05-03UHC-32157-94—7165 Park Pl, Jacksonville, FL, 322790.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-408584CLMMei N Hicks1988-06-05—24829482918342 Lake View Rd, Chandler, AZ, 852840.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408786CLMJean Burton2005-12-17UHC-63224-7797767380278348 Bayshore Dr, Orlando, FL0.62Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
CLM-430232CLMCarol N Olzon1943-01-24—4044328857541 Willow Ct Apt 38, Charlotte, NC, 282130.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-410189CLMGloria M Fisher1976-08-13UHC-34739-0639361378083183 Mesa Dr, Tampa, FL, 336440.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-400150CLMKatherine James1979-08-09UHC-89876-4085555803028854 Highland Ave, Tempe, AZ, 852510.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400430CLMBradley Carroll2004-12-02—69476208971790 Highland Ave Apt 26, Columbus, OH, 432330.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
32,829 rows, page 79 of 657PreviousNext