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-406698CLMDonald Castillo1942-07-26UHC-10489-7351834242882970 Market St, Phoenix, AZ, 850950.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429593CLMAustin Parker1952-07-03UHC-47167-07—3166 Spring St # 887, Miami, FL, 331230.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-424856CLMJoshua DJunk1994-08-01—71354028249767 Sunset Blvd, Phoenix, AZ, 850040.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421644CLMSantiago T Gonzales1989-11-03—61690542402699 Ocean Ave, Miami, FL, 331780.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428372CLMTimmothy J Guzman1956-04-14UHC-86387-31—1038 Mesa Dr, Seattle, WA, 981680.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424472CLMGerald Olson2002-01-08UHC-86329-5631046446295297 Pine Dr, Jacksonville, FL, 322460.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409957CLMPhilip Montgomery1947-11-16UHC-95197-1397245507472672 Spring St, San Antonio, TX, 782110.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428982CLMAnna J Palmer1961-01-03UHC-08520-2737668466633351 River Rd, Denver, CO, 802390.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430400CLMKenneth R Nguyen1982-03-28UHC-63340-98—1478 Ridge Rd, Eden Prairie, MN, 553610.62Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402238CLMStephen Mason1949-01-20UHC-11372-1072674423555037 Ocean Ave, Columbus, OH, 432240.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429654CLMDylan Gomez1963-08-12UHC-44561-3863328862875409 Union St, Los Angeles, CA0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-412587CLMDenise Y Prce——45895938798071 Desert Sky Blvd, Seattle, WA, 981190.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-420595CLMEvelyn Morrison1986-09-13——1846 Maple Ave, Tampa, FL, 336350.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417260CLMPatrick Ellis1975-04-06UHC-52459-13—1833 Ridge Rd, Eden Prairie, MN, 553260.62Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
CLM-427427CLMBrian Thomas1956-12-02UHC-07672-9180938373947042 Mountain View Dr, Dallas, TX, 752910.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-413762CLMAisha Bradley1973-12-24—35485362558630 River Rd, Denver, CO, 802110.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-425446CLMSarah Bailey1971-09-27UHC-07917-53—5551 Washington St, Dallas, TX, 752280.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406602CLMDouglas Garza1946-09-15——1168 Cedar Ln, Phoenix, AZ, 850690.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-403177CLMJoe Stephens1975-03-11UHC-09651-873118285793302 Church St, Columbus, OH, 432370.62Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
CLM-419419CLMEvelyn Varrgas1969-01-18UHC-34654-1154849433329477 Forest Ave, Plano, TX, 750850.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-427814CLMWilliam L Walsh1952-05-27UHC-61186-88—9058 Mesa Dr, Seattle, WA, 981430.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424749CLMRebecca L Palmer1961-01-18UHC-84842-0758439504475599 Market St, Las Vegas, NV, 891430.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-419279CLMCunningham Austin2005-12-11UHC-71262-5663928367844366 Forest Ave, Phoenix, AZ, 850020.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411969CLMMaria A Woods1969-06-16UHC-43006-384297798137198 Church St, Los Angeles, CA, 900610.62Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+3 more
CLM-429201CLMRaymond Wood1981-03-24UHC-27241-9935482677782266 Sage Ct, Atlanta, GA0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419822CLMRyan Castro1963-08-28UHC-23084-6364859552504342 Apache Blvd, Minneapolis, MN, 554810.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-406242CLMCmaila Jimenez1975-10-02UHC-71123-92—9655 Meadow Ln # 315, Plano, TX, 750280.62Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+3 more
CLM-406241CLMCmaila Jimenez1975-10-02UHC-71123-92—9655 Meadow Ln # 315, Plano, TX, 750280.62Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+3 more
CLM-403083CLMTyler Kelley1962-11-01UHC-71559-70—636 Spring St, Austin, TX0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-412951CLMJennifer Watson———9725 Harbor Blvd, Tucson, AZ, 857830.62Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-427319CLMCharles Gonzalez1974-07-20UHC-02909-702667982251559 Desert Sky Blvd, Mesa, AZ, 852950.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-419682CLMDorothy T Lawrence1966-04-11UHC-04711-5944421158141167 Canyon Rd Apt 3, Los Angeles, CA, 900870.62Middle initial moved out of first nameName re-casedDate of birth reformattedUnit split from street+3 more
CLM-417226CLMEvelin Kim1985-05-03UHC-34692-99—1704 Jefferson Ave, Mesa, AZ, 852340.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427698CLMSharon Rojas1965-08-23——9578 Mesa Dr, Denver, CO, 802790.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-402220CLMNoah Willis1998-08-17UHC-64010-597638263661916 Baseline Rd, Charlotte, NC, 282250.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-417106CLMAnthony B Estrada1972-01-23UHC-76323-91—7313 Union St, San Antonio, TX, 782370.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416353CLMBruce Phillips1989-05-28UHC-32256-98—5407 Hillcrest Rd, Las Vegas, NV, 891100.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-430786CLMBrittany Henderson1992-12-05UHC-13878-53—8332 Union St, Dallas, TX0.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412982CLMKatherine Dixon1989-07-28—50071032469088 Union St, San Diego, CA0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-421683CLMSmith Omar1999-06-10——6226 Indian School Rd, Charlotte, NC, 282350.62Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-416450CLMPriya Castro1941-10-01UHC-73873-85—1086 Oak St, Seattle, WA0.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403168CLMAnn Gilbert2004-10-07UHC-20636-0656770119702196 Sage Ct, Chandler, AZ, 852740.62Name re-casedDate of birth reformattedCity re-casedState name converted to code+3 more
CLM-402548CLMDiana A Hernandez1968-11-02—92986752622531 Indian School Rd, Tucson, AZ, 857070.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-402549CLMDiana A Hernandez1968-11-02—92986752622531 Indian School Rd, Tucson, AZ, 857070.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-422278CLMJudith Palmer1997-02-02UHC-25874-3558927228074983 Pine Dr, Orlando, FL, 328910.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-428749CLMCharles Baker2003-11-22UHC-54348-51—1343 Main St, Los Angeles, CA, 900250.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427932CLMJack Taylor1971-03-07——3243 Main St Apt 32, Tampa, FL, 336500.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-425508CLMBeverly Sandoval1987-01-04UHC-71693-15—2141 Meadow Ln, Glendale, AZ, 853120.62Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-426007CLMLawrence Aguilar1951-02-28UHC-15412-7824027826296601 Ridge Rd, Chandler, AZ, 852250.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-432302CLMAnthony Morrison1987-09-13UHC-63513-43—2366 Lake View Rd Apt 23, Tucson, AZ, 857240.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
32,829 rows, page 98 of 657PreviousNext