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-431148CLMMary V Torres1943-05-26UHC-04025-132715109300—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-417799CLMKyle Olson1998-06-26UHC-89184-734578211779—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-420634CLMCamila Hart1953-08-18—25861352704743 Camelback Rd, Fresno, CA, 937340.82Name split from “Last, First”Plan code upper-casedPlaceholder values cleared
CLM-421160CLMDorothy Riley1986-06-13—8559264082—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-400229CLMWei Murphy1978-02-06———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-412406CLMOlivia Pena1962-11-01UHC-64907-394994022698—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-415287CLMAlbert Knight1994-08-07UHC-52355-5845676337376424 Mesa Dr, Tempe, AZ, 852290.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-424753CLMHarold M Rios1982-09-28———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-428535CLMMadison Butler1975-06-07UHC-99817-46——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-400253CLMHenry Brown1998-08-21UHC-21741-37——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-415375CLMJoshua Bishop1944-01-16UHC-15066-21—9490 Desert Sky Blvd, Chandler, AZ, 852020.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-424051CLMNicole Mason1947-10-14———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-419069CLMChristine Banks1957-10-20———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-424498CLMKyle Li1941-01-02—88547222411629 River Rd, Tucson, AZ, 857240.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-409089CLMJose Espinoza1996-08-14UHC-99113-0275142000568225 Market St, Seattle, WA, 981290.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-408589CLMAisha Garza2000-11-19——6081 Sunset Blvd, Gilbert, AZ, 852550.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-412491CLMHenry Nguyen1975-07-18UHC-89598-34——0.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
CLM-411432CLMHarold Nguyen1994-06-13——8987 Central Ave, Los Angeles, CA, 900500.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-416610CLMEthan Owens1951-01-21UHC-45302-3334195865995590 Broadway, Houston, TX, 770810.82Name split from “Last, First”State code upper-casedPlaceholder values cleared
CLM-411329CLMDylan F Dean1940-04-18UHC-33903-053722813844—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-422020CLMMegan Burton1960-11-09UHC-99195-77—6057 Jefferson Ave, Los Angeles, CA, 900690.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-422309CLMSamantha X Gibson1977-09-18UHC-78095-116908579553—0.82Name split from “Last, First”Phone reformattedWhitespace trimmed
CLM-401238CLMDot Richards1944-08-27UHC-27953-85——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-424369CLMPeter F Alvarez1972-06-19UHC-28455-248599520983—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-414393CLMJacqueline Spencer1958-06-24UHC-18603-59——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-417761CLMSteve Guerrero1966-09-27UHC-23579-55——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-430303CLMDeborah Perez1964-05-16UHC-48065-64——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-402984CLMCarolyn Ward2004-03-16UHC-59025-32—9472 Desert Sky Blvd, Chandler, AZ, 852980.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-402985CLMCarolyn Ward2004-03-16UHC-59025-32—9472 Desert Sky Blvd, Chandler, AZ, 852980.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-400937CLMBrenda Weaver1950-07-25UHC-49595-38—5530 Grand Ave, Tampa, FL, 336170.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-430973CLMChristian Colleman2001-06-07UHC-66406-19——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-416158CLMMegan Diaz1959-07-04———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-417956CLMRoger Arnold2005-06-25—29257539392065 Lake View Rd, Denver, CO, 802130.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-415430CLMElizabeth Brown1971-10-24UHC-66461-69829594044330 Maple Ave, Austin, TX, 787400.82Name split from “Last, First”Phone reformattedCity re-cased
CLM-422806CLMTerry W Banks1941-08-25UHC-16965-8693489450149173 Lake View Rd, Plano, TX, 750640.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-404146CLMHelen Hicks1962-07-12UHC-81077-42—6150 Cedar Ln, Dallas, TX, 752800.82Name split from “Last, First”City re-casedWhitespace trimmed
CLM-401253CLMCarlos Scott1943-08-20—37668146396908 Harbor Blvd, Los Angeles, CA, 900930.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-431206CLMGary Montgomery1958-03-17—2532302813—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-427831CLMKelyl Vazquez1940-03-23UHC-86573-18——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-432060CLMMaariana P Heerrera1945-03-28—9125499324—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-416465CLMJoyce Hunt1951-05-13UHC-05477-22——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-419094CLMHelne Estrada1944-12-08—2865999236—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-410816CLMStephen Graham1938-09-27———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-407455CLMJose Reyes1982-09-22—2755605024—0.82Name split from “Last, First”Plan code upper-casedPlaceholder values cleared
CLM-423093CLMOlivia Cooper1981-09-05—6877811662—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-408797CLMJohn Estrada1998-09-14———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-422225CLMPatrick Ortega2001-07-20UHC-45462-688212622405348 Cedar Ln, Atlanta, GA, 303050.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-406769CLMMarcus Romero1990-03-08UHC-49692-40—7791 Indian School Rd, Denver, CO, 802320.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-408002CLMThomas I Sullivan1982-02-28——8589 Indian School Rd, Denver, CO, 802850.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-424469CLMTyler Wagner1977-08-17UHC-29723-33—8116 Willow Ct, San Antonio, TX, 782390.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
3,226 rows, page 59 of 65PreviousNext