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-431882CLMSingh Victoria1941-04-18UHC-82237-08—3955 Grand Ave Apt 8, Chandler, AZ, 852550.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-421967CLMJeffrey Harrison1942-09-28UHC-17502-0755929090246635 Canyon Rd, Las Vegas, NV, 891890.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406920CLMRobert Romero1986-11-18UHC-84309-9128924369154570 Baseline Rd, Tucson, AZ, 857800.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427183CLMJacob J Pattersun1994-09-20—43790984063426 Maple Ave, Dallas, TX, 752780.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-411439CLMBrenda Tran1994-10-17—39527917099506 Lake View Rd, Tucson, AZ0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409009CLMJacqueline V Williams1947-08-08UHC-10689-0388728109147124 Camelback Rd, Tucson, AZ0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414704CLMCynthia Green1979-06-21UHC-66762-67—1316 Jefferson Ave, Orlando, FL, 328830.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-414703CLMCynthia Green1979-06-21UHC-66762-67—1316 Jefferson Ave, Orlando, FL, 328830.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-407544CLMEvelyn O Woods1980-12-02UHC-04940-6381953896867917 Central Ave # 702, Tampa, FL, 336530.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-414873CLMNicole Banks1949-11-11UHC-40533-3939844188212501 Apache Blvd, Tampa, FL, 336640.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-409186CLMJack Delgado1978-12-01—6297836156928 Harbor Blvd, Tucson, AZ, 857100.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424948CLMDeborah Luna—UHC-71000-2393279124605251 Camelback Rd, Gilbert, AZ, 852330.64Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417361CLMEmily Harris—UHC-11654-1898547687655568 Apache Blvd, Orlando, FL, 328600.64Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401020CLMFrances Williamson1987-05-23UHC-65634-96—128 Desert Sky Blvd, Miami, FL0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-429019CLMJustin Sims1938-10-22UHC-97386-84—5124 Highland Ave, Fresno, CA, 937870.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429018CLMJustin Sims1938-10-22UHC-97386-84—5124 Highland Ave, Fresno, CA, 937870.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429055CLMJoeJunk2003-03-10UHC-01942-36—8568 Ocean Ave, Phoenix, AZ, 850710.64Date of birth reformattedMember ID reformattedZIP+4 trimmedWhitespace trimmed+2 more
CLM-431772CLMBetty Garrett1995-10-13UHC-03172-6259239506642804 Spring St, Austin, TX, 787880.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400442CLMSean Evans1958-08-01UHC-66436-57—5226 Oak St, Los Angeles, CA, 900090.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-414298CLMMargaret Rice2001-03-12UHC-28781-31—1283 Church St, Eden Prairie, MN, 553870.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-402459CLMChristian Gomez1984-11-27——7865 Bayshore Dr, Austin, TX0.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-432489CLMDaniel J Sanders1954-08-15—95242034039364 Washington St, Mesa, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-428950CLMPriya Rioos1981-02-14UHC-31247-21—1393 Canyon Rd, Chandler, AZ, 852930.64Date of birth reformattedState name converted to codeGender normalisedPlan code upper-cased+2 more
CLM-425293CLMRachel F Griffin2005-03-12UHC-76041-4631186189545971 Baseline Rd, Houston, TX, 770680.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410118CLMMei Fisher2004-09-05UHC-50798-1456639072344419 Highland Ave, Nashville, TN, 372530.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427912CLMAaron Reid1968-04-25UHC-10885-7676457959131642 Apache Blvd, Miami, FL, 331460.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-401123CLMAlexsi Haarper1954-04-02UHC-57014-8790497312261582 Sage Ct, Eden Prairie, MN, 553100.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428153CLMGloria Yang1940-02-03——9382 Indian School Rd, Orlando, FL0.64Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-429481CLMDenise Obrien1947-05-13UHC-16406-79—9137 Indian School Rd, Nashville, TN0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-421098CLMDennis Holmes1981-01-15UHC-23663-3490442373688792 Elm St, Miami, FL, 331530.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413912CLMRoger H Daen1940-02-17UHC-54712-1079043410363984 Cedar Ln, Glendale, AZ, 853560.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410640CLMEugene Peterson1942-11-20UHC-76324-6186797252282480 Ocean Ave, Minneapolis, MN, 554890.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
CLM-400341CLMDanielle Turner2001-03-28UHC-41679-2242164913329206 Pine Dr Apt 21, Columbus, OH, 432260.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-401149CLMAlbert Woods1954-07-09UHC-81873-9190565575201380 Harbor Blvd, Denver, CO, 802130.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-414504CLMJulia Vasquez1956-12-05UHC-90179-25—7887 Indian School Rd, Minneapolis, MN, 554360.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-411149CLMNoah Burns2000-03-03—50358003677504 Broadway, Tampa, FL0.64Name split from “Last, First”Phone reformattedAddress re-casedZIP missing+2 more
CLM-400211CLMBrandon D Bennett1976-10-06—6375998649625 Spring St, Tampa, FL, 336200.64Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more
CLM-413898CLMMason Vasquez1967-05-27——3053 Central Ave, Los Angeles, CA, 900660.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-412651CLMEvelyn Stewart1997-03-04——8320 Union St, Atlanta, GA, 303320.64Name split from “Last, First”Date of birth reformattedCity re-casedZIP+4 trimmed+2 more
CLM-401873CLMPatrick P Olson1966-04-06——6165 Main St, San Diego, CA, 921670.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-418443CLMCarol Cook1973-12-02UHC-47697-12—9188 Central Ave, Nashville, TN, 372180.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-432396CLMLucia Jimenez1971-07-28UHC-43120-8664639490964939 Grand Ave, Phoenix, AZ, 850830.64Phone reformattedCity re-casedState name converted to codeGender normalised+2 more
CLM-415012CLMWalter Soto1956-03-07UHC-24718-519048148344—0.64Name split from “Last, First”Phone reformattedMember ID reformattedGender normalised+2 more
CLM-418378CLMRebecca Fuller1939-08-19UHC-58010-4963273493783291 Valley View Dr, Las Vegas, NV, 891430.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-424925CLMDoris T Ford1958-02-28—91626600201242 Lake View Rd, Scottsdale, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-427429CLMMariana Rios1939-03-01—47664929818891 Pine Dr, Tampa, FL, 336240.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-404636CLMSophia Howell1997-04-28UHC-51733-01—2377 Apache Blvd, San Diego, CA, 921440.64Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429254CLMMei Miller1981-04-16——8901 Indian School Rd, Austin, TX, 787660.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-414751CLMJuan E Lopez1968-10-05——8639 Highland Ave Apt 33, Columbus, OH, 432440.64Name re-casedUnit split from streetCity re-casedZIP+4 trimmed+2 more
CLM-415042CLMYuki Russell1942-02-14——4736 Ridge Rd, Mesa, AZ, 852230.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
32,829 rows, page 110 of 657PreviousNext