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-412905CLMAmanda Cook1976-05-04UHC-27610-61——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-406798CLMDoris Y Cooper1969-06-21UHC-46929-193228304402—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-406904CLMJoshua White1984-09-10UHC-58233-88——0.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
CLM-422127CLMMary Walker1979-11-20———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-420225CLMRaymond R Elliott1956-04-25UHC-34636-62—8816 Forest Ave, Denver, CO, 802840.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-403167CLMAnn Gilbert2004-10-07UHC-20636-06—2196 Sage Ct, Chandler, AZ, 852740.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-421579CLMMichael Hanson1983-07-01——3342 Sage Ct, Fresno, CA, 937380.82Name split from “Last, First”Plan code upper-casedPlaceholder values cleared
CLM-426110CLMMarcus D Gilbert1994-03-03UHC-89377-66—6817 Forest Ave, Glendale, AZ, 853580.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
CLM-410261CLMMaria Watkins1943-09-15——7679 Central Ave, Tampa, FL, 336660.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-415183CLMKathryn I Price1987-02-12———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-414778CLMAlexis Moore1995-12-09UHC-10333-27——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-411801CLMDonald Soto1959-11-02UHC-45288-97——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-410358CLMAhmmed Riley2007-03-13UHC-08481-83——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-417651CLMJacob P Walker1999-02-27UHC-50958-9648695017942767 Highland Ave, Scottsdale, AZ, 852500.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-430248CLMRussell Matthews2002-06-26——288 Desert Sky Blvd, San Antonio, TX, 782820.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-407463CLMAna Hunter2008-10-04———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-409824CLMJoe Thomas1980-08-27UHC-66607-084176737554—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-422968CLMBarbara Brooks1996-11-13UHC-35893-48——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-423590CLMKevin O Siingh1994-08-20UHC-44191-8465939864448045 Broadway, Mesa, AZ, 852520.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-432194CLMJoe Herrera1993-11-14—38245289649242 Willow Ct, Fresno, CA, 937110.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-421069CLMBilly Morris2002-09-27UHC-18091-668985323762—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-430777CLMCarol A Jordan1996-07-15UHC-04959-0924361620085834 Broadway, Glendale, AZ, 853800.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-414848CLMPamela Hughes1962-02-24UHC-75410-20——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-404807CLMPhilip Cruz1950-04-31UHC-16685-1981133383517326 Broadway, Atlanta, GA, 303130.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-416777CLMKaren Mitchell1996-06-04UHC-88403-779339211041—0.82Name split from “Last, First”Phone reformattedWhitespace trimmed
CLM-410219CLMDavid Yang2008-01-27———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-420873CLMDonna Cook1978-02-12UHC-07640-06——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-417597CLMAlan Jimenez2004-10-07UHC-80729-256612795760—0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-417002CLMDylan Clark1998-10-11UHC-69372-0565536927113398 Apache Blvd, Eden Prairie, MN, 553670.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-403908CLMCheryl Thompson1959-10-20UHC-88060-986019512107—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-429886CLMSandra Rios2006-03-11UHC-43703-75——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-428396CLMZachary Willsi2006-07-10UHC-45359-25—1522 Desert Sky Blvd, Miami, FL, 331130.82Name split from “Last, First”Plan code upper-casedPlaceholder values cleared
CLM-414994CLMCheryl Catro1950-02-04UHC-39022-48—570 Broadway, Phoenix, AZ, 850020.82Name split from “Last, First”City re-casedPlaceholder values cleared
CLM-415973CLMChristina Bishop1975-04-27——2857 Bayshore Dr, Phoenix, AZ, 850090.82Name split from “Last, First”City re-casedPlaceholder values cleared
CLM-425693CLMMei Maldonado1945-11-02—6324522021—0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-418775CLMAndrew V Payne1954-12-26UHC-47940-21—1487 Apache Blvd, Glendale, AZ, 853780.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-409447CLMSara Ramos1998-09-02UHC-90845-0265681511764731 Sage Ct, San Diego, CA, 921680.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-410482CLMSean Bishop1972-02-13———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-401153CLMBobby D Stone1965-09-17UHC-68829-83—3821 Mesa Dr, Gilbert, AZ, 852070.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-421199CLMMadison Guzman2008-05-25UHC-78690-13—9638 Park Pl, Glendale, AZ, 853110.82Name split from “Last, First”City re-casedPlaceholder values cleared
CLM-421200CLMMadison Guzman2008-05-25UHC-78690-13—9638 Park Pl, Glendale, AZ, 853110.82Name split from “Last, First”City re-casedPlaceholder values cleared
CLM-415525CLMPhilip Garrett1960-12-03——5689 Cedar Ln, Tucson, AZ, 857920.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-404177CLMWilllie Price1946-06-09UHC-51717-166119984074—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-411847CLMBeverly O Sanchez1952-02-05——8609 Forest Ave, Chandler, AZ, 852950.82Name split from “Last, First”City re-casedPlaceholder values cleared
CLM-422262CLMRandy Sullivan1986-02-21UHC-42995-565488104445841 Grand Ave, Miami, FL, 331940.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-402529CLMArthur Munoz2006-05-28UHC-53883-63——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-419227CLMZachary Cen1970-03-25UHC-33334-72—5217 Indian School Rd, San Diego, CA, 921290.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-415229CLMCalos Henderson1938-09-10UHC-04658-83——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-425430CLMDenise Wilson1987-11-14UHC-05747-60——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-422361CLMChris Perry1950-03-15UHC-27995-454727972299—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
3,226 rows, page 61 of 65PreviousNext