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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-410630CLMSandra Murphy1964-09-11UHC-12223-14—6365 Highland Ave, San Antonio, TX0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-409256CLMArjun Elliott1997-06-07UHC-67426-37—6148 Grand Ave Apt 14, Tampa, FL, 336540.68Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased
CLM-402827CLMRuth Wells——82277081837402 Sage Ct # 791, Tempe, AZ, 852640.68Date of birth unreadableUnit split from streetWhitespace trimmedPlaceholder values cleared
CLM-409266CLMEdward Bishop1986-11-16UHC-10043-1230998436148152 Lincoln Way, Chandler, AZ, 852310.68Phone reformattedSSN last four extractedGender normalisedWhitespace trimmed
CLM-403805CLMAustin H Mendoza1939-04-11UHC-24980-1394079877794656 Baseline Rd, Chandler, AZ, 852450.68Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed
CLM-420911CLMChrisopher L Castro2005-02-27UHC-53454-4030143251481841 Maple Ave, Las Vegas, NV0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-417791CLMFatima Gaza1972-11-26——1370 Lincoln Way, Scottsdale, AZ, 852850.68Date of birth reformattedSSN last four extractedZIP+4 trimmedPlaceholder values cleared
CLM-431170CLMPaul Valdez1957-11-17———0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-421065CLMPatricia Porter1986-09-25UHC-40405-05—8080 Forest Ave, Denver, CO, 802990.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-409532CLMNency Salazar1981-03-05UHC-90313-6583466638054822 Sunset Blvd # 686, Columbus, OH, 432200.68Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased
CLM-405786CLMAmanda Larson1946-09-26—23847664901439 Desert Sky Blvd, Tempe, AZ, 852580.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-401039CLMWillie Austin1998-09-20—4789072706—0.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
CLM-410222CLMElijah Gutierrez1994-08-15UHC-33290-15—2882 Spring St # 194, Los Angeles, CA, 900520.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-416803CLMGloria Taylor1976-08-26UHC-31049-53—5571 Union St, Scottsdale, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-428486CLMTerry Hughes2002-02-18——3241 Valley View Dr, Phoenix, AZ, 850180.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-425525CLMScott Estrada1963-12-10UHC-21355-47—2065 Bayshore Dr, Austin, TX, 787700.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-429285CLMSamantha Watkins1991-09-24—2036662020935 Cedar Ln Apt 39, Columbus, OH, 432760.68Name re-casedUnit split from streetGender normalisedPlaceholder values cleared
CLM-427306CLMMichelle Hart1972-04-06UHC-85075-2954899117082271 Lake View Rd, Houston, TX, 770960.68Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed
CLM-420359CLMJean Martin1980-08-25UHC-24078-9925327069392678 Cedar Ln, Columbus, OH, 432760.68Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code
CLM-413420CLMDoris U Hamilton1949-03-21——8807 Indian School Rd Apt 7, Los Angeles, CA, 900630.68Name split from “Last, First”Date of birth reformattedUnit split from streetPlaceholder values cleared
CLM-419606CLMAmy Flores1947-08-22——8713 Willow Ct, Houston, TX0.68Two-digit birth yearZIP missingWhitespace trimmedPlaceholder values cleared
CLM-410674CLMAmanda Hunt—UHC-44646-26—88 Broadway, Jacksonville, FL0.68Date of birth unreadableCity re-casedZIP missingPlaceholder values cleared
CLM-411158CLMKeenneth E Fuller1968-10-21UHC-48254-4851275623637076 Lake View Rd Apt 33, Seattle, WA, 981760.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-421382CLMBecky F Murray2002-09-21UHC-42228-1450555456876746 Lake View Rd, San Antonio, TX0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-423693CLMDeborah Henderson2008-03-10UHC-53868-2782825169612283 Grand Ave, Scottsdale, AZ, 852380.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-414385CLMJanet Z Adams1969-08-27UHC-23374-717675949447161 Park Pl, Atlanta, GA, 303990.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-421821CLMVincent Padilla1986-01-12UHC-44861-15—1843 Central Ave, San Diego, CA, 921800.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-411408CLMNancy V Castillo1967-03-21—52232312288927 Pine Dr Apt 40, Tucson, AZ, 857230.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
CLM-432716CLMRandy Riley1975-07-01—32551058082611 Jefferson Ave, Plano, TX, 750540.68Name split from “Last, First”Phone reformattedState name converted to codePlaceholder values cleared
CLM-419814CLMAdam T Dixon1974-07-03UHC-43173-48——0.68Two-digit birth yearPhone missing area codeWhitespace trimmedPlaceholder values cleared
CLM-417247CLMRussell Guerrero1975-09-04——675 Mountain View Dr, Tucson, AZ, 857020.68SSN last four extractedState code upper-casedGender normalisedPlaceholder values cleared
CLM-430258CLMJean Knight1960-04-01UHC-93730-3998029237099744 Jefferson Ave, Fresno, CA, 937440.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-402365CLMAndrew Wagn1968-03-11UHC-05635-36—2103 Willow Ct, Nashville, TN, 372710.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-432160CLMLindda Reid1941-09-26UHC-59494-8930650053393931 Harbor Blvd, San Diego, CA, 921040.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
CLM-432801CLMEugene Graham1950-06-16UHC-67388-37—7226 Oak St, Atlanta, GA, 303430.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-412363CLMRoy Stephens1982-03-13UHC-38481-78861421108454 Jefferson Ave, Charlotte, NC, 282770.68Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed
CLM-413556CLMJohnny Watkins—UHC-85271-08—7718 River Rd, Nashville, TN, 372760.68Name re-casedDate of birth unreadableGender normalisedPlaceholder values cleared
CLM-405188CLMVirginia Ortiz2008-03-22UHC-29964-53——0.68Date of birth reformattedSSN last four extractedGender normalisedPlaceholder values cleared
CLM-407848CLMAmanda Peters1967-11-03UHC-92760-81—2524 Spring St, Minneapolis, MN0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-400930CLMLisa Campbell1982-04-21———0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-431615CLMDaniel Holmes1953-11-18UHC-72010-71—4543 Indian School Rd, Plano, TX0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-400630CLMAlex Thompson1999-03-02UHC-81966-47—8452 Central Ave, Eden Prairie, MN, 553170.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-432252CLMCatherine Y Romero1952-02-09——9615 Camelback Rd, Tempe, AZ, 852630.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-413049CLMPaul Mejia1994-10-14—3976107895—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-422054CLMSarra Williams1983-11-20—30342589295208 Sunset Blvd, Chandler, AZ, 852520.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-409406CLMOlivia Campbell——6424320170—0.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
CLM-430816CLMDiego Montgomery1950-06-08——2865 Main St, Columbus, OH, 432110.68Name split from “Last, First”Date of birth reformattedState name converted to codePlaceholder values cleared
CLM-415073CLMCheryl Henderson1993-07-27UHC-31875-96—7765 Baseline Rd, Columbus, OH, 432310.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412209CLMKatherine Howell2006-04-08UHC-24751-04—6115 Indian School Rd, Los Angeles, CA, 900040.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-401104CLMKathryn Li2001-05-09——5526 Central Ave, Los Angeles, CA, 900720.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
32,829 rows, page 210 of 657PreviousNext