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-414761CLMBrenda H Singh1973-12-05UHC-47269-6826843786001625 Lake View Rd, Seattle, WA, 981230.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-432735CLMBrenda X Graham1982-08-16UHC-82376-5342129484318593 Sunset Blvd, Eden Prairie, MN, 553730.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-430290CLMJoe Anderson1955-07-18UHC-19479-048315039221862 Valley View Dr Apt 20, Chandler, AZ, 852160.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-402634CLMEmma Nguyen1975-02-21UHC-41432-6731030376395278 Indian School Rd, Minneapolis, MN, 554490.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423765CLMMargaret Stevens1981-12-12—50662628647419 Baseline Rd, Atlanta, GA0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-427773CLMChristine Valdez1969-03-12UHC-20572-11—8031 Union St, Houston, TX, 770120.60Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-410141CLMKayla Jenkins1941-11-12—96635851538645 Hillcrest Rd, Fresno, CA0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-427279CLMRandy Pierce1976-09-16UHC-30239-3693674133385408 Bayshore Dr, Mesa, AZ, 852290.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-408212CLMBlily Olson1974-06-21—70644639248096 River Rd, Mesa, AZ, 852590.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-403910CLMSofia Jones2001-11-04—90173507494940 Canyon Rd, Jacksonville, FL, 322210.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-429697CLMGabriel Howell1943-02-05UHC-87332-4458666766792866 Harbor Blvd, Seattle, WA, 981570.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-419335CLMGregory F James1971-03-22UHC-64701-9020627419078867 Hillcrest Rd, Charlotte, NC, 282490.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-426807CLMJessica Williamson1963-09-19UHC-41493-304429338171832 Canyon Rd, Jacksonville, FL, 322550.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-419385CLMAlbert Black1944-11-07UHC-18721-1195660361935999 Palm Dr, Sacramento, CA, 958430.60Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-422912CLMSteve McDonald2000-11-28—35194822631739 Canyon Rd, San Diego, CA, 921880.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405884CLMEthan Robertson1965-10-29UHC-07705-1153633028244600 Canyon Rd, Seattle, WA, 981060.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-417890CLMRyan Wright1953-03-20UHC-72160-9779028013732436 Maple Ave, San Diego, CA, 921200.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-418112CLMArthur Oliver1995-04-22—50621026128600 Union St, Houston, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-418113CLMArthur Oliver1995-04-22—50621026128600 Union St, Houston, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-430736CLMBrenda Grant1974-07-20——6156 Washington St, Chandler, AZ, 852110.60Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-412125CLMJanice Davis1974-01-24UHC-78960-8896328769016350 Grand Ave, Gilbert, AZ, 852930.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-414906CLMJose Edwards1994-08-22—93149413986240 Elm St, Mesa, AZ, 852490.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407480CLMWilliam Harrison1956-07-19UHC-32299-787804022643586 River Rd, Glendale, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-424702CLMDiane Morales1958-05-02—32763201766994 Jefferson Ave, Seattle, WA, 981220.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-406877CLMEugene Fisher1969-09-25UHC-45550-4240971579538143 Baseline Rd, Chandler, AZ, 852580.60Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-417637CLMAnthony Elliott1957-04-07UHC-53370-86—9767 Willow Ct, Glendale, AZ, 853810.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-429627CLMRuth H Carpenter1944-07-27—90155452207473 Meadow Ln, Dallas, TX0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-428279CLMEmily Montgomery2004-03-03UHC-51886-829779553021233 Oak St, Denver, CO, 802920.60Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-432529CLMRobert N Lewis1938-06-12UHC-97618-20—1524 Oak St, Sacramento, CA, 958580.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402452CLMSandra Smith1967-08-12UHC-43199-8084938451232812 Maple Ave, Denver, CO, 802800.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-407529CLMRoger Q White1948-08-05UHC-38078-4533745702521094 Baseline Rd, Seattle, WA, 981050.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-400716CLMLori Meyer1959-11-17UHC-13791-2936237583669738 Canyon Rd, Charlotte, NC0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-429837CLMTeresa James1987-06-15UHC-36227-8962084588185550 Jefferson Ave, Plano, TX, 750840.60Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more
CLM-413559CLMBryan Jimenez1961-03-08UHC-52341-8293745038501671 Bayshore Dr, Phoenix, AZ, 850540.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-413465CLMIsabella Nelson1992-04-21—52033351882964 Grand Ave # 765, Austin, TX, 787970.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-417773CLMKathleen Gardner1997-09-05—43079576273869 Jefferson Ave, Chandler, AZ, 852270.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-424667CLMAlice Mejia1942-06-13UHC-60560-812824471224649 Apache Blvd, Denver, CO, 802540.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-415024CLMJanice Hererra1986-09-18UHC-91917-4633936021762585 Grand Ave, Austin, TX, 787600.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-429432CLMMason Taylor2001-07-19—27674084251473 Bayshore Dr, Phoenix, AZ, 850930.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-421319CLMMichelle Clark1987-06-28UHC-76779-1271862752434196 Union St, Miami, FL, 331160.60Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-421320CLMMichelle Clark1987-06-28UHC-76779-1271862752434196 Union St, Miami, FL, 331160.60Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-426129CLMJames Ortiz1940-06-28—55758742427211 Desert Sky Blvd, Phoenix, AZ0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431498CLMDylan Carlson1946-10-01UHC-36771-6998859227651363 Baseline Rd, Atlanta, GA, 303780.60Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-412369CLMSharon Thomas1942-09-22UHC-96128-1387668020373073 Lincoln Way, San Antonio, TX, 782430.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-430238CLMJoan P Meyer1992-11-20UHC-56059-704962008110483 Desert Sky Blvd, Charlotte, NC, 282110.60Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
CLM-412236CLMYuki Boyd1993-05-18UHC-66893-4864360266118451 Oak St # 297, Scottsdale, AZ, 852620.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-408689CLMEugene Watkins1997-10-17UHC-86450-2670182934439178 Park Pl, Scottsdale, AZ, 852940.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-412036CLMJulie J Wilson1990-10-20UHC-76381-4128594761319127 Pine Dr, Columbus, OH, 432490.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405753CLMJanet Tran2006-01-12UHC-47381-7144120584276574 Pine Dr, Chandler, AZ, 852680.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431014CLMOmar James2006-12-05—7424698015902 Highland Ave # 810, Sacramento, CA, 958750.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
32,829 rows, page 70 of 657PreviousNext