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-424090CLMJack L Franklin1968-02-01UHC-20855-6222243802553069 Mountain View Dr Apt 9, Tampa, FL, 336400.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-425649CLMChristian Singh2007-07-24UHC-28089-14—9378 Willow Ct # 338, Scottsdale, AZ, 852900.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-420992CLMDoris Gilbert1945-07-11—29798546328676 Canyon Rd, Las Vegas, NV, 891900.60Name re-casedDate of birth reformattedPhone reformattedCity re-cased+4 more
CLM-418958CLMNicole Carr1961-06-14UHC-85502-9140238027927331 Pine Dr, Phoenix, AZ, 850530.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421575CLMMadison E Moore2001-01-14UHC-36940-6343683441886393 Grand Ave, Tempe, AZ, 852600.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-403636CLMAmy Q Caarlson1948-11-09UHC-63262-9292747649914691 River Rd, Fresno, CA, 937800.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-423461CLMEdward U Maldonado2006-01-10UHC-96749-77—2333 Forest Ave, Austin, TX, 787340.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-408952CLMSarah Reynolds1992-08-21UHC-42163-6045285103526944 Washington St, Los Angeles, CA, 900170.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-419415CLMCharlotte Weber1964-03-02UHC-81561-0674453283436065 Sage Ct, Scottsdale, AZ, 852650.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-426054CLMFrank Robertson1982-05-16UHC-20010-8680275831772074 Hillcrest Rd, Tampa, FL, 336580.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423149CLMMeagn Thompson2007-01-06UHC-08534-9774537774629786 Union St, Orlando, FL, 328960.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-404828CLMFrank Hunter1955-09-25UHC-53273-91—3716 Lake View Rd, Sacramento, CA, 958160.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421137CLMJanice Yang1995-11-06UHC-21909-1035227724061511 Valley View Dr, Austin, TX, 787510.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-429353CLM—Junk1999-03-05—80851227485971 Camelback Rd, San Diego, CA, 921560.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-430840CLMJerry T Banks1945-09-20UHC-69891-94—249 Oak St, Columbus, OH, 432020.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421790CLMStephen Mills2006-12-22UHC-24932-16—2771 Willow Ct, Nashville, TN, 372450.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417622CLMAustin Matthews1990-10-24——7181 River Rd # 440, San Diego, CA, 921800.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-428984CLMMichelle Perry1948-10-24UHC-36131-7358742780914869 Hillcrest Rd, Chandler, AZ, 852860.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-401211CLMDeb Castro1946-08-12UHC-70408-6488393125412479 Baseline Rd, Chandler, AZ, 852380.60Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-427311CLMDouglas Edwards1996-09-28UHC-70622-6340899104903670 Desert Sky Blvd, Mesa, AZ, 852330.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-400867CLMZachary Geoge1999-07-23UHC-99695-6693899991126658 Central Ave, Fresno, CA, 937630.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431687CLMAndrew Q Marshall1982-04-17UHC-95340-4374430869126828 Meadow Ln, San Diego, CA, 921200.60Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-430674CLMWayne Reed1949-07-04——4643 Hillcrest Rd, Tempe, AZ, 852000.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-412914CLMMargaret Duncan1950-08-15——569 Market St, Tampa, FL, 336430.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-426965CLMKeith Collins1972-06-21UHC-22597-6467656314192439 Mesa Dr, Los Angeles, CA, 900530.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-426320CLMAbby O Price1964-04-17UHC-79699-27—2730 Desert Sky Blvd, Tempe, AZ, 852450.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416121CLMHenry Kennedy1990-11-13UHC-66605-3991496780159248 Palm Dr, Sacramento, CA, 958600.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-410919CLMAshleey F Espinoza1996-03-07—59788855044517 Ocean Ave, Glendale, AZ, 853080.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-412483CLMWayne A Sankhez1962-10-15UHC-45559-5423939875268639 Cedar Ln Apt 19, Las Vegas, NV, 891260.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-428751CLMDanielle Chen1977-06-02UHC-81652-6376951965511213 Hillcrest Rd, Minneapolis, MN, 554250.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418308CLMEthan Kennedy1960-09-08—67475204783654 Washington St Apt 26, Tampa, FL, 336090.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-431855CLMMateo Ortiz1968-01-20—71040537849079 Grand Ave, Austin, TX, 787910.60Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419980CLMJeremy Roberts1994-12-02UHC-19875-43—9863 Sage Ct, Columbus, OH, 432600.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421368CLMJeffrey U Baker1984-07-10UHC-91386-44—1091 Harbor Blvd, Tucson, AZ, 857270.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-408828CLMGrace Jacksson1997-02-25UHC-37567-28—6072 Meadow Ln, Houston, TX0.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-430625CLMMark Simpson1942-03-02UHC-13339-4952899677603103 Park Pl, Fresno, CA, 937170.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418465CLMBrittany Rios1946-01-13UHC-10619-9224961241455474 Hillcrest Rd, Dallas, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-418466CLMBrittany Rios1946-01-13UHC-10619-9224961241455474 Hillcrest Rd, Dallas, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-425747CLMHannah Gilbert1939-08-14——1246 Ocean Ave, Dallas, TX, 752170.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403376CLMCheryl Q Henry1955-08-19UHC-97793-4459873241084304 Canyon Rd, Tucson, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-429125CLMLauren Wagner1959-01-09UHC-76656-6981061617866697 Highland Ave, Seattle, WA, 981720.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-403507CLMRuth Carr2006-04-27—9594544279692 Bayshore Dr, Dallas, TX0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408983CLMSteve Carlson1953-05-09UHC-58376-55—655 Central Ave, Austin, TX, 787030.60Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-415698CLMJudy Burns1980-12-09UHC-13174-9828991482053367 Maple Ave, Seattle, WA, 981090.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-429736CLMChristina Jimenez1958-04-19—38629763354263 Ocean Ave, Chandler, AZ, 852000.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-412557CLMRoy Sanders1941-06-11UHC-81923-3353374538221470 Willow Ct, Orlando, FL, 328180.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-420098CLMJesse Nelson1989-12-14UHC-18838-51—8592 Palm Dr, Plano, TX, 750700.60Name re-casedDate of birth reformattedMember ID reformattedZIP+4 trimmed+4 more
CLM-421019CLMAlice D Webb1998-06-27——2190 Oak St, Charlotte, NC, 282560.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-400852CLMNicholas P Coleman1945-09-10UHC-80494-3155455684205342 Elm St, Dallas, TX, 752720.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-407641CLMEdward Brooks1938-02-01—79589753483916 Apache Blvd, Eden Prairie, MN, 553770.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
32,829 rows, page 67 of 657PreviousNext