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-411533CLMLogan Collins1944-12-21—51140081049814 Pine Dr, Las Vegas, NV, 891370.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-428299CLMMychael N Carpenter1995-07-11UHC-99707-6578642435328019 Market St, Plano, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-422238CLMJoseph M Daniels1995-07-13—81679900882516 Hillcrest Rd, Nashville, TN0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-424443CLMRalph A Riz1950-05-14UHC-42464-0581796059795738 Valley View Dr, Mesa, AZ, 852980.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-432813CLMValentina Jacobs1974-08-06—89570166167801 Spring St, Las Vegas, NV, 891330.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407281CLMValentina Patterson2008-06-26UHC-12015-8228922306202334 Baseline Rd, Chandler, AZ, 852080.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-404691CLMAhmed Vega2002-10-16UHC-10206-0539322067533061 Maple Ave, Tucson, AZ, 857390.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431690CLMJacqueline Richards2004-09-10——2754 Main St, Dallas, TX, 752980.60Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-429645CLMJoshua Q Campbell1939-03-16UHC-12728-3065998375362377 Harbor Blvd # 561, Fresno, CA, 937450.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-409121CLMJulie Alvarez1976-09-24UHC-08988-7250421201438968 Oak St, Tucson, AZ, 857620.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-418410CLMMelissa Tran1978-08-11UHC-46772-18—2670 Bayshore Dr, Atlanta, GA, 303480.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-410022CLMTyler Carter1997-10-16UHC-34633-9424676958677468 Lake View Rd, Los Angeles, CA, 900550.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-422469CLMEmma McDonald1986-06-13UHC-14703-7742629665867127 Meadow Ln, Tempe, AZ, 852850.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-422468CLMEmma McDonald1986-06-13UHC-14703-7742629665867127 Meadow Ln, Tempe, AZ, 852850.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-425603CLMLauren Wang1963-08-19—88962516986246 Park Pl, Nashville, TN, 372520.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-431026CLMRonald Castro1958-12-04UHC-33034-68—2663 Meadow Ln, Seattle, WA, 981560.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400012CLMRaymond Walsh1951-11-03UHC-09175-906463199468764 Baseline Rd, Seattle, WA, 981980.62Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-400011CLMRaymond Walsh1951-11-03UHC-09175-906463199468764 Baseline Rd, Seattle, WA, 981980.62Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-431958CLMHenry Ward1939-03-06UHC-63253-17—2753 Sunset Blvd, San Diego, CA, 921600.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401778CLMAngela Reid1943-08-06—54963726492793 Indian School Rd # 435, San Antonio, TX, 782390.62Name re-casedPhone reformattedUnit split from streetCity re-cased+3 more
CLM-415597CLMRuth Hall1968-09-24—2722957547470 Apache Blvd, Columbus, OH0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400301CLMLauren S Davis1997-11-20—53430283544206 Baseline Rd, Scottsdale, AZ, 852640.62Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
CLM-408721CLMJerry Scott2004-10-26UHC-49219-1830529593678838 Baseline Rd, Nashville, TN0.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-419729CLMCarlso Franklin1956-02-16—42580704287808 Meadow Ln, Gilbert, AZ, 852160.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-414036CLMChristine O Bryant1964-01-02—31391130308446 Union St, Jacksonville, FL, 322340.62Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
CLM-430728CLMAustin Santos2004-09-16—30527684559199 Church St, Dallas, TX, 752070.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422608CLMJacqueline Flores1974-06-19—66768412678905 Washington St, San Diego, CA, 921730.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423086CLMGabriel Park1948-03-19UHC-80454-2178352900791820 Broadway, Houston, TX, 770600.62Name re-casedTwo-digit birth yearPhone reformattedAddress re-cased+3 more
CLM-418697CLMGeorge E Shaw1984-10-02—79965395686572 Bayshore Dr, Tucson, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418055CLMKaren Anderson1974-08-20—31750194233300 Mountain View Dr, Los Angeles, CA, 900490.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-416208CLMMaria Meyer1957-11-25UHC-73025-5278994103887272 Mesa Dr, Dallas, TX, 752470.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417848CLMSean Castro1973-07-25—97563569929846 Bayshore Dr, Tampa, FL0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-401483CLMBryan C McDonald1943-01-28UHC-55577-5747586290585985 Grand Ave, Atlanta, GA, 303480.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-412536CLMCharlotte F Brynt2002-04-24UHC-22651-59—1933 Grand Ave, Dallas, TX, 752550.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430068CLMLawrence Hoffman1971-02-10UHC-12016-6595394320235415 River Rd Apt 22, Minneapolis, MN, 554160.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-400701CLMCheryl Parker1988-06-09—74626169928286 Bayshore Dr, Tampa, FL, 336490.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-432229CLMLisa Graham1951-12-26UHC-27955-9421766527164093 Ridge Rd, Tampa, FL, 336710.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409147CLMZachary O Nichols1973-09-11UHC-39053-23—7771 Harbor Blvd Apt 37, Atlanta, GA, 303780.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-403716CLMMei Y Mendoza1963-08-04UHC-90746-4763640974418355 Pine Dr, Gilbert, AZ, 852990.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430060CLMRussell Gordon1956-08-13—93785231954073 Apache Blvd, Atlanta, GA, 303190.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-408695CLMAisha A Allen1979-02-22—74860117686345 Meadow Ln, Scottsdale, AZ, 852620.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-400734CLMEmma Henry1980-04-13UHC-50050-99—9496 Cedar Ln, Plano, TX, 750320.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404017CLMBetty Olson1985-04-28——3868 Camelback Rd, Phoenix, AZ, 850370.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404805CLMEmma A Simpson1966-03-13UHC-49747-10—2298 Lake View Rd # 746, Charlotte, NC, 282320.62Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-419243CLMChristina Foster1940-05-04UHC-20894-6369030746331579 Church St, Plano, TX, 750520.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404675CLMSophia Hill1960-12-15—66929550193946 Elm St, Minneapolis, MN, 554010.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432617CLMAisha Burke1960-12-03UHC-42201-91—8632 Oak St, Plano, TX, 750130.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422724CLMCatherine Watkins1940-09-07——2262 Canyon Rd, Gilbert, AZ, 852210.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403760CLMJonathan Valdez1938-07-06UHC-09612-40—1279 Bayshore Dr, Nashville, TN, 372860.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-423372CLMClark Deb1985-04-10UHC-43310-10—1310 River Rd, Fresno, CA, 937500.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
32,829 rows, page 74 of 657PreviousNext