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-404634CLMDeborah Day1955-06-07UHC-19228-66—4202 Washington St, Tucson, AZ, 857180.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429133CLMMurray Juan1960-12-26UHC-76789-10—9062 Park Pl, Gilbert, AZ, 852630.50Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-412188CLMEd H Myers2004-08-09—42388475304250 Grand Ave, Tempe, AZ, 852030.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-419384CLMCatheryne Hart1963-09-20UHC-18151-19—7998 Desert Sky Blvd, Atlanta, GA, 303170.50Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-410367CLMEdward O Peterson1969-01-12UHC-42460-1297527017164454 Harbor Blvd, Houston, TX, 770720.50Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-431584CLMAshley N Carpenter1967-01-15UHC-08657-9490560090293832 Ocean Ave, Denver, CO0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-420262CLMMarha Nichols1989-04-27UHC-63051-7246476088881787 Jefferson Ave, Mesa, AZ0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-415834CLMAustin Simmons1962-05-06UHC-84270-5930227418324773 Palm Dr, Denver, CO0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418753CLMJanice Holmes1962-11-07UHC-79640-77—8847 Mesa Dr # 370, Tucson, AZ, 857620.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-416969CLMSara C Burton1941-10-24——9018 Bayshore Dr, Gilbert, AZ, 852850.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
CLM-423969CLMRalph Hoffman1984-12-26UHC-55886-66—2087 Indian School Rd, Los Angeles, CA, 900770.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-427788CLMEmilly Lane2002-08-21UHC-37845-55—6688 Washington St # 687, Glendale, AZ, 853250.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-401089CLMAmy Vargas1949-09-27—78971778988448 Mesa Dr, Chandler, AZ, 852950.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414501CLMBrandon Torres1955-11-27UHC-26652-2028688748404878 Canyon Rd # 700, Chandler, AZ0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-409757CLMAaron Lee1997-12-14—59965993039253 Spring St, Tucson, AZ, 857480.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400636CLMMatthew Vgea1998-08-17UHC-91944-194834304551789 River Rd, Dallas, TX, 752350.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-405952CLMCarlos Salazar1992-08-07UHC-04052-2140797028872954 Canyon Rd # 744, Phoenix, AZ0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-427006CLMJon Weber1998-03-17UHC-45344-39—4212 Maple Ave, Gilbert, AZ, 852390.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-415956CLMRyan Hill1966-09-13UHC-71857-4035939730072450 Ridge Rd, Tempe, AZ, 852860.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-431250CLMBarbara Cox1962-01-13——1468 Hillcrest Rd, Columbus, OH0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-404520CLMKathryn A Perez1986-11-13UHC-05255-47—1011 Indian School Rd, Seattle, WA, 981170.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405175CLMCharles Jenkins—UHC-72962-24—7771 Forest Ave, Fresno, CA, 937820.50Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
CLM-422584CLMJohn Hughes1947-09-08UHC-46207-33—1769 Mesa Dr, Tempe, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-411209CLMEric Rios1966-11-03—35028393643440 Willow Ct, Atlanta, GA, 303820.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417414CLMAngela Martin2006-02-23——3353 Ridge Rd, Tucson, AZ, 857950.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407558CLMBobby Clark1949-08-03UHC-74673-9483248352969785 Indian School Rd, Seattle, WA0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-421888CLMSara K Kelley2008-09-20UHC-40791-6398690060891277 Willow Ct, Tucson, AZ, 857860.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-432468CLMDonald Simpson1976-07-23—56438163262920 Central Ave, Denver, CO, 802530.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-432213CLMDennis Rojas1945-11-25UHC-65284-1374055362725077 Church St, Orlando, FL, 328970.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-411146CLMMaria Nichols1984-12-26UHC-63435-6593790062221856 Willow Ct Apt 35, Minneapolis, MN, 554640.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-415679CLMShirley Chavez1956-05-14—74262237822044 Mesa Dr # 600, Chandler, AZ0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-408910CLMBradnon G Jacobs1955-08-05UHC-10592-7285197385499500 Grand Ave # 352, Orlando, FL, 328250.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-428879CLMJonathan Parker1985-01-21UHC-64109-25—6409 Lake View Rd, Gilbert, AZ, 852330.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-407040CLMDenny J Baker1967-07-16UHC-24430-47—4332 Jefferson Ave, Orlando, FL, 328820.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416248CLMFatima Garrett2003-04-16—62427580786743 Park Pl Apt 36, Chandler, AZ, 852190.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-412567CLMKathleen Lane2001-01-26UHC-31114-8049497250277643 Highland Ave, Miami, FL0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403972CLMTyler Wagner1951-07-18——8381 Main St, Gilbert, AZ, 852700.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-410468CLMSean Daniels1986-05-18——6525 Sunset Blvd, Los Angeles, CA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427166CLMBrandon Martin1952-12-02——962 Harbor Blvd, Glendale, AZ, 853900.50Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-407096CLMJoe Young2002-03-24UHC-30717-32—4851 Mountain View Dr, Mesa, AZ, 852600.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-400970CLMGary J Sullivan1965-11-03UHC-11966-4377096324324564 Baseline Rd, Atlanta, GA, 303340.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-421331CLMJean Davis1963-10-01——4532 Cedar Ln, Dallas, TX, 752540.50Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+3 more
CLM-404538CLMLisa Silva2002-04-16——6174 Willow Ct # 947, Columbus, OH, 432350.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-418107CLMKathleen R Lawson1941-07-17UHC-48976-7142853174932728 Valley View Dr, Charlotte, NC, 282020.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424979CLMJulia Snyder—UHC-13287-8755193308809086 Canyon Rd, Los Angeles, CA, 900030.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404609CLMJudy V Long2001-05-20UHC-14892-64—4143 Apache Blvd, Gilbert, AZ, 852720.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-428739CLMCarl Li———2696 Sage Ct, Jacksonville, FL, 322770.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-418318CLMEmily Boyd1998-06-24UHC-29831-34—547 Willow Ct, Tucson, AZ, 857990.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416151CLMNancy Q Washington2007-05-05——2444 Lincoln Way Apt 20, Plano, TX, 750370.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-422131CLMSamuel Martinez1993-04-08UHC-56424-34—8593 Jefferson Ave, Eden Prairie, MN, 553380.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
32,829 rows, page 24 of 657PreviousNext