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-413965CLMDavid Nguyen1945-01-25UHC-96172-78—7133 Camelback Rd, Austin, TX, 787400.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-428523CLMJoshua Morris1997-07-01UHC-52115-69—5767 Sunset Blvd, Houston, TX, 770500.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-427067CLMSan A Gordon1948-09-19—62695403929787 Canyon Rd, Mesa, AZ, 852720.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-420949CLMHenry Fernandez1963-09-11UHC-34820-26——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-415104CLMRalph Oliver1995-03-26—9882029621—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-426926CLMChristina Washington1966-11-22UHC-41326-428389215536317 Broadway, Seattle, WA, 981870.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-418707CLMMichelle J Carpenter2004-12-26UHC-19794-404466247822—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-405451CLMJacob U McDonald1938-03-26—7167501791—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-422734CLMHeather Hart1960-06-27UHC-02743-926385063717—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-407210CLMChris Webb1988-01-17UHC-62698-47——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-404090CLMRussell F Holmes1943-10-14UHC-47288-776575017298—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-431240CLMMariana Cook1996-12-14—72594506777666 Sunset Blvd, Atlanta, GA, 303390.80Name split from “Last, First”Phone reformattedState code upper-casedWhitespace trimmed
CLM-402723CLMGerald Jones1951-11-21——5976 Harbor Blvd, Atlanta, GA, 303370.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
CLM-430064CLMKyle G Meyer1976-10-28UHC-64032-367879715728—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-420038CLMEvelyn Delgado1961-10-05UHC-46372-43—495 Church St, Plano, TX, 750740.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-416212CLMTim Freemman1992-07-09UHC-34025-6093169663895657 Market St, Seattle, WA, 981030.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-407247CLMGrace Hayes1964-09-27——4935 Apache Blvd, Orlando, FL, 328040.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-409638CLMPeter Herrera1941-07-16UHC-90166-986327226920—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-430814CLMMark Phillisp1983-11-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-427210CLMRachel C Flores2006-02-05—86435665995831 Sunset Blvd, Plano, TX, 750800.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-407681CLMMegan Carr1962-08-16—8856608089—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-415952CLMMadison D Bryant2006-08-09UHC-66554-95——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-432777CLMNicole Robertson1982-10-04UHC-44037-37556998175070 Lake View Rd, Nashville, TN, 372760.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-417369CLMGary Hunt1959-05-19UHC-01749-02——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-408694CLMJerry Lee2002-06-25——8472 Main St, Mesa, AZ, 852020.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-408403CLMPatricia Castillo1997-02-10UHC-69535-076466022448—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-423600CLMAmy I Myers1950-09-21UHC-78281-86——0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
CLM-414388CLMCarl Vasquez2000-10-08UHC-28618-983964821958—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-417585CLMDanielle Ferguson1985-10-12UHC-82532-023176692769—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-415137CLMAndrea Murphy1945-01-11UHC-49868-205366654368—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-416844CLMNicholas Castillo1963-08-07UHC-57647-096615182096—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-417443CLMCarolyn H Guzman1967-06-08UHC-42076-734613107599—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-411204CLMHelen Robinson1996-03-10UHC-80098-326532054941—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-418530CLMSusan H Waang2008-01-18UHC-69643-70—8465 Pine Dr, Austin, TX, 787270.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-404725CLMRobert Brooks1945-01-05UHC-21063-19——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-414537CLMJoyce Tran1939-04-24———0.80Name split from “Last, First”Date of birth reformattedEmail lower-casedPlaceholder values cleared
CLM-412580CLMShirley Sanchez1948-12-12—25745942795839 Apache Blvd, Fresno, CA, 937400.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-431569CLMJuna Obriien2008-07-20UHC-63527-62—1923 Elm St, Los Angeles, CA, 900450.80Name split from “Last, First”Name re-casedCity re-casedPlaceholder values cleared
CLM-421111CLMDouglas U Warren1944-09-25UHC-53814-57—9292 Broadway, Orlando, FL, 328080.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-413929CLMHarold Rmos1978-08-26UHC-42336-852087905762—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-401504CLMKimberly Miller2002-12-17UHC-03074-285977327599—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-407120CLMFrank K Bowman1976-05-12UHC-05898-408403412160520 Lake View Rd, San Diego, CA, 921060.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-411981CLMDouglas Gonzales1954-12-17UHC-31335-663778778088—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-430342CLMRaymond Carlson1975-09-18UHC-58887-83—2186 Baseline Rd, Atlanta, GA, 303420.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-407286CLMSamuel Rojas1980-08-07UHC-84537-44——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-417313CLMJason A Wheeler1954-08-10UHC-04921-587058205106—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-432819CLMVirginia Guerrero1939-07-02—65274883667836 Ocean Ave, Miami, FL, 331460.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-401448CLMMelissa Cruz1996-09-15UHC-43441-53—8804 Mesa Dr, Gilbert, AZ, 852490.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-405239CLMGuerrero W Anthony1993-12-01—6177725230—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-427325CLMLisa D Obrien2004-10-24UHC-77989-41—3140 Lake View Rd, Tucson, AZ, 857300.80Name split from “Last, First”Name re-casedState code upper-casedPlaceholder values cleared
3,226 rows, page 54 of 65PreviousNext