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-415962CLMKelly L Contreras1992-03-23UHC-65136-0367974631009844 Valley View Dr, Las Vegas, NV0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-401498CLMJudith Arnold1968-02-05UHC-64428-9822585222955198 Church St, Dallas, TX, 752620.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-424780CLMGabriel C Patterson1980-06-05—96422521232762 Elm St, Glendale, AZ, 853930.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401510CLMAndrea Payne1981-11-17UHC-53890-5235974063266213 Ridge Rd, Columbus, OH, 432830.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427273CLMWalter Murray1990-02-28——2846 Ridge Rd, San Diego, CA, 921500.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-405902CLMAlexander Reed1960-08-02UHC-32257-08—7671 Church St, Austin, TX, 787170.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-431827CLMJordan Vasquez1957-10-19UHC-99564-15—6169 Elm St # 887, Chandler, AZ, 852240.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408780CLMRandy Hernandez1980-10-19—84685466485165 Grand Ave, Denver, CO, 802430.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410011CLMCynthia O Contreras——78677743874353 Washington St, Phoenix, AZ, 850430.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-420021CLMHiroshi Guerrero1959-10-27—92143363203471 Baseline Rd, Atlanta, GA, 303520.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-412855CLMDanielle Z Phillips1992-06-04UHC-60897-9473682548688140 Canyon Rd, Scottsdale, AZ, 852560.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-405583CLMGeorge Sanchez1978-02-18UHC-41321-44—2945 Elm St, Miami, FL, 331820.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403388CLMJoseph Martin1948-01-18UHC-05158-8551155726164130 Washington St, Gilbert, AZ, 852850.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427384CLMLori Armstrong1939-08-17UHC-85173-782402251345319 River Rd, Charlotte, NC, 282250.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403764CLMAlice Robinson1955-12-26UHC-97366-44—8625 Spring St, Eden Prairie, MN, 553650.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423606CLMBrandon Delgado——71155109422505 Hillcrest Rd, Tempe, AZ, 852670.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-417797CLMJustin Gordon1958-09-10—34378284648913 Mountain View Dr, Phoenix, AZ, 850690.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-404226CLMMarcus Little2001-03-28——9687 Ridge Rd # 951, Gilbert, AZ, 852660.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-407452CLMAnn Sullivan1992-08-26UHC-58187-5794228491004276 Desert Sky Blvd, Glendale, AZ, 853910.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402251CLMNancy Bennett1940-03-16——7655 Bayshore Dr, Denver, CO0.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-424036CLMJerry Martin1994-11-16UHC-95865-44—9420 Baseline Rd Apt 19, Houston, TX, 770250.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-416395CLMJesse George1973-07-25UHC-45885-2650733952192028 River Rd, Tempe, AZ, 852700.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405741CLMBobby Mason2003-05-20—70657160922306 Mesa Dr # 785, Charlotte, NC, 282030.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-406572CLMJean Ward1942-05-13—79024415022434 River Rd, San Diego, CA0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408771CLMJoyce Gibson—UHC-76784-7969187992879321 Mesa Dr, Atlanta, GA, 303810.62Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420834CLMJonathan Vega1952-03-24UHC-70582-6859869304206552 Jefferson Ave, San Diego, CA0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404513CLMBryan Freeman1951-11-21—78668627707670 Valley View Dr Apt 6, Plano, TX, 750790.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-420947CLMJason Murray1983-04-12UHC-52531-4473474119554758 Market St, Dallas, TX, 752780.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422810CLMRussell Lee1966-02-19UHC-71483-825723182318336 Forest Ave, Denver, CO, 802790.62Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
CLM-426684CLMKelly Mason1950-04-08UHC-40432-406127365124527 Jefferson Ave, Eden Prairie, MN, 553740.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-401002CLMMaria Harrison1998-01-02UHC-00391-32—2840 Oak St, Columbus, OH, 432970.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-400298CLMWayne Anderson1962-01-16UHC-02479-04—3004 Main St, Denver, CO, 802620.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432122CLMChristopher Hawkins1939-10-19—24551721443342 Harbor Blvd Apt 35, Sacramento, CA, 958760.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-405032CLMChristopher X Cunningham1946-04-04——3285 River Rd, Charlotte, NC, 282530.62Name re-casedDate of birth reformattedCity re-casedState name converted to code+3 more
CLM-429497CLMMaria L Moreno2007-11-28UHC-61343-6230678810419319 Apache Blvd, Tampa, FL0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428345CLMYuki Willis1985-12-25UHC-15526-71—5308 Meadow Ln, Miami, FL, 331770.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-428346CLMYuki Willis1985-12-25UHC-15526-71—5308 Meadow Ln, Miami, FL, 331770.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-426291CLMRonald Li———7230 Lake View Rd, Houston, TX, 770310.62Name re-casedDate of birth reformattedDate of birth unreadableCity re-cased+3 more
CLM-405086CLMMargaret R McCoy1969-07-09UHC-88924-6358423019034305 Meadow Ln, Denver, CO, 802350.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429993CLMTerry Henderson1940-10-05—44331820876152 Meadow Ln, Minneapolis, MN0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428776CLMJacob W Grant1969-10-22UHC-57440-2230843461853053 Harbor Blvd, Tucson, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429961CLMLuis Duncan1998-10-12UHC-50248-1157768538658373 Harbor Blvd, Gilbert, AZ0.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409134CLMDon Taylor2000-01-13——1401 Hillcrest Rd, Miami, FL0.62Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-426182CLMKevn L Tcker1951-06-09——1128 Harbor Blvd, Columbus, OH, 432420.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430795CLMBrittany E Wells2001-01-14UHC-87523-64—1690 Jefferson Ave, Austin, TX, 787370.62Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416495CLMRyan Lee1954-10-11UHC-63291-287399597825990 Sage Ct, Glendale, AZ, 853970.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405999CLMWayne Santos1967-08-04——9077 Lake View Rd, Nashville, TN, 372340.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-410666CLMLawrence D Cunningham1998-07-17—2386081454—0.62Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
CLM-410665CLMLawrence D Cunningham1998-07-17—2386081454—0.62Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
CLM-432679CLMThomas Harper1974-08-03——973 Market St, Tucson, AZ, 857660.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 87 of 657PreviousNext