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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-406205CLMNicole Snyder1950-01-09UHC-92703-71——0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
CLM-402283CLMSteven Ruiz1971-06-18UHC-69104-20——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-405819CLMJustin T Hawkins1943-07-02—35949925702459 Sunset Blvd, Tucson, AZ, 857700.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-412682CLMLuis Lee1965-04-28—2645827180—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-405791CLMPamela Chen1955-10-09UHC-59611-1276573567422159 Maple Ave, Tucson, AZ, 857490.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-414330CLMBobby Evans1976-07-03UHC-75183-23—6622 Maple Ave, Sacramento, CA, 958760.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-423849CLMOmar Nunez1982-10-16UHC-16297-37—518 Baseline Rd, Mesa, AZ, 852270.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-409399CLMStephen M Fowler2001-09-27UHC-96013-136007978481—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-432370CLMBrandon Martin2003-01-17UHC-01660-568787811703—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-429613CLMMason Carlson1946-09-16——9434 Willow Ct, Orlando, FL, 328060.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-406680CLMDorothy Elliott1959-12-25—4055707594—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-419411CLMDebra Cox1993-06-22UHC-62132-15——0.80Name split from “Last, First”Member ID reformattedWhitespace trimmedPlaceholder values cleared
CLM-401963CLMAlbert Fields1969-03-03UHC-51978-3296621192793255 Union St, Minneapolis, MN, 554200.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-418675CLMCarl Burke1952-04-12UHC-45011-1121525808979767 Willow Ct, Minneapolis, MN, 554640.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
CLM-417608CLMAshley Montgomery1948-10-22—9675824786—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-415324CLMMargaret Burke1993-12-13——2687 Canyon Rd, Nashville, TN, 372220.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-416799CLMFrank Weber1956-03-02UHC-60254-75——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-429106CLMAnna Murphy1944-01-18—3474330116—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-411721CLMDenise H Ross1975-07-10UHC-51808-483056469510—0.80Name split from “Last, First”Date of birth reformattedMember ID reformattedPlaceholder values cleared
CLM-402566CLMJanice Rose1987-12-14——6492 Palm Dr, Denver, CO, 802900.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-413345CLMLawrence Anderson2001-08-07UHC-75461-1958435695676884 Meadow Ln, San Diego, CA, 921300.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-418648CLMBiilly Weaver1953-05-24UHC-92169-3565380225771760 Pine Dr, Sacramento, CA, 958740.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-404721CLMBenjamin Morgen1941-05-03—66261924308904 Main St, Fresno, CA, 937090.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-410692CLMLori Webb1991-07-01UHC-69037-61—2854 Maple Ave, Miami, FL, 331720.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
CLM-417427CLMJonathan Lopez1975-09-28UHC-56956-03——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-430197CLMJennifer Ross1956-10-05UHC-16794-057053257982—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-413836CLMTyler Gardner1995-06-13UHC-36316-346889289513—0.80Name split from “Last, First”Phone reformattedMember ID reformattedPlaceholder values cleared
CLM-403191CLMMary Daniels1969-09-15UHC-02753-643262426146—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-416242CLMMei Espinoza2003-05-05—37282465927842 Baseline Rd, Gilbert, AZ, 852590.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-417834CLMHannah Porter1991-06-15UHC-63800-643564612216—0.80Name split from “Last, First”Member ID reformattedWhitespace trimmedPlaceholder values cleared
CLM-431762CLMRebecca Espinoza1954-12-27UHC-91958-97——0.80Name split from “Last, First”Date of birth reformattedMember ID reformattedPlaceholder values cleared
CLM-405497CLMAhmed Bailey1978-05-10UHC-12383-43—5091 Broadway, Atlanta, GA, 303100.80Name split from “Last, First”Member ID reformattedAddress re-casedPlaceholder values cleared
CLM-431641CLMChristian Wells1946-07-26——3640 Indian School Rd, Los Angeles, CA, 900420.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-409647CLMOwens Elijah1989-06-04UHC-32230-666147492074428 Church St, Scottsdale, AZ, 852760.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-423964CLMMarilyn Perkins1981-04-09UHC-97616-01——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-417724CLMSophia Kelley1951-11-13—36688107636604 Park Pl, Charlotte, NC, 282800.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-408303CLMKayla G Webb1975-12-06——8894 Broadway, Gilbert, AZ, 852800.80Name split from “Last, First”Address re-casedCity re-casedPlaceholder values cleared
CLM-421038CLMEvelyn Gray1968-09-15——5902 Canyon Rd, Denver, CO, 802840.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-421037CLMEvelyn Gray1968-09-15——5902 Canyon Rd, Denver, CO, 802840.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-403230CLMRachel Washington1964-11-02——7169 Broadway, Glendale, AZ, 853820.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-420017CLMSantiago Jimenez1984-08-25—8444390603—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-411387CLMMateo Medina1950-03-15UHC-80796-72—5639 Willow Ct, Sacramento, CA, 958050.80Name split from “Last, First”Date of birth reformattedMember ID reformattedPlaceholder values cleared
CLM-414735CLMShirley R Alvarez1957-10-21———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-430163CLMRay Catsillo1944-12-19UHC-29214-49——0.80Name split from “Last, First”Member ID reformattedWhitespace trimmedPlaceholder values cleared
CLM-428961CLMYuki Vazquez1960-04-08UHC-48005-227367985899—0.80Name split from “Last, First”Plan code upper-casedWhitespace trimmedPlaceholder values cleared
CLM-432276CLMVirginia Armstrong1961-07-18UHC-99958-978458388168—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-421636CLMWillie Wang1997-12-05—7644344853—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-406449CLMBrian E Flores2001-06-10UHC-95145-33—438 Baseline Rd, Tucson, AZ, 857410.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-418573CLMKelly G Bishop1958-01-12UHC-23217-249615919930—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-403062CLMJulie Cox2008-04-06—4565150171—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
3,226 rows, page 52 of 65PreviousNext