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-400143CLMKatherine Young1985-06-08UHC-45033-96——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-412415CLMVirginia Smith1963-08-07———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-408690CLMEugeen Watkins1997-10-17UHC-86450-267018293443—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-415628CLMMartha R Campbell2007-12-27——2352 Broadway, Mesa, AZ, 852870.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-401953CLMJustin Cooper1943-04-08———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-422206CLMJonathan B Alvarado1956-01-03UHC-88343-03——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-421281CLMTerry Hall1988-07-22UHC-83199-447614796806—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-413652CLMSharon Jacobs1947-12-18UHC-99106-8027620821669453 Desert Sky Blvd, Los Angeles, CA, 900910.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-431630CLMSamantha Meyer1994-09-03———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-400658CLMLawrence Garret1982-07-27UHC-83755-5986067746956007 Broadway, Tampa, FL, 336870.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-403842CLMKimberly Cruz1967-03-18UHC-50312-755488227857—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-401305CLMCraol Andrews2006-08-27—4817026382—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-400873CLMFatima Nguyen1984-03-14UHC-77642-95——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-403606CLMEmma C Watson1991-08-15UHC-67915-0956998166031108 Elm St, Sacramento, CA, 958540.82Name split from “Last, First”City re-casedPlaceholder values cleared
CLM-423138CLMDylan Martin1946-03-15UHC-41516-3593344092593591 Lake View Rd, Tampa, FL, 336220.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-427835CLMRoger Robertson2002-05-06———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-426951CLMKaren Powell1988-04-09—9648633370—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-422815CLMNatalie Ferguson1942-05-16UHC-75951-23——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-427260CLMMary N Coleman1995-06-14——312 Mountain View Dr, Denver, CO, 802260.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-414915CLMJeremy T Fernandez1942-06-17UHC-82545-81——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-430799CLMMatthew Harper2001-06-03UHC-43987-44—3125 Union St, Los Angeles, CA, 900670.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-419684CLMGregory Aguilar1961-08-18UHC-47637-38——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-432539CLMRuth Jordan2005-02-16UHC-16459-44——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-426866CLMJordan Ferguson1942-06-09—3254919247—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-426290CLMLaura Castillo1962-04-24UHC-96050-092313801821—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-404654CLMJesse Fowler1998-12-11UHC-13704-8751346058294715 Sage Ct, Miami, FL, 331990.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-430882CLMAustin S Espinoza2003-02-23——2063 Valley View Dr, Minneapolis, MN, 554830.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-401695CLMVictoria Phillips1938-03-11UHC-89176-515098536150—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-426038CLMEvelyn Yang1985-12-24———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-410445CLMKathy Burton1947-07-15UHC-48446-12—3808 Harbor Blvd, Scottsdale, AZ, 852920.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-418779CLMLuis Nichols1947-03-14UHC-85196-7863547562155706 Lincoln Way, Atlanta, GA, 303160.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-419044CLMDonald Reyes1991-06-19——2262 Highland Ave, San Antonio, TX, 782110.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-420592CLMKim Green1987-03-15—9086782047784 Harbor Blvd, Glendale, AZ, 853680.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-400890CLMLaura Tucker1994-01-10UHC-80382-94—8125 Indian School Rd, Tampa, FL, 336150.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-410727CLMJose Weber1957-04-10UHC-75597-59——0.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
CLM-420145CLMMarcus X Bishop2007-09-13UHC-31910-58——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-427199CLMLaura Silva1989-04-13UHC-50366-197122348745—0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-409355CLMDanielle I Andersno1985-08-09———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-424159CLMDanielle Herrera1948-03-21UHC-14995-824577387148—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-426567CLMPeter Olson1976-02-17UHC-64174-06—1042 Sunset Blvd, Chandler, AZ, 852070.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-429713CLMShirley Cunningham1973-12-10——3784 Central Ave, Seattle, WA, 981670.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-429623CLMRonald Valdez2002-06-14———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-418218CLMMaria J Nichols2008-12-19UHC-08241-198145231111—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-426711CLMCharles Morrison1953-01-11——5824 Lincoln Way, Phoenix, AZ, 850170.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-406119CLMJudith H Rivera1953-09-08UHC-82345-54——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-408151CLMChristian N Taylor1940-05-07UHC-16429-286009992787—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-410389CLMJeremy Cook1948-08-19UHC-20902-9850557156909672 Baseline Rd, Gilbert, AZ, 852070.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-402132CLMDiane U Stone2000-02-21—9333401447—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-417749CLMJose Scott1979-05-02UHC-23800-23—1716 Ridge Rd, Nashville, TN, 372830.82Name split from “Last, First”City re-casedWhitespace trimmed
CLM-402416CLMKayla Hart1950-06-27UHC-56881-4983851265917021 Highland Ave, Mesa, AZ, 852110.82Name split from “Last, First”Phone reformattedMember ID reformatted
3,226 rows, page 57 of 65PreviousNext