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-416349CLMArjun Anderson2006-04-21———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-403875CLMDenise Adams2001-05-06UHC-45015-9064197111574206 Lincoln Way, Columbus, OH, 432620.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-408848CLMLauren Morrison1978-08-20UHC-90176-41——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-429158CLMPeter Baker1945-12-21UHC-62009-75——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-412251CLMKaen Young2008-03-15UHC-48759-81——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-430610CLMAnn Robertson1968-08-11UHC-98509-15—2551 Willow Ct, Seattle, WA, 981540.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-413208CLMMatthew F Burke1982-01-07———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-408116CLMKymberly Cox1993-05-03———0.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
CLM-427754CLMRtuh Ortiz1990-11-22UHC-29847-48—8190 Grand Ave, Los Angeles, CA, 900680.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-422043CLMDougglas Q Perry1979-03-18UHC-12328-71—1326 Apache Blvd, Austin, TX, 787720.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-413324CLMGloria Bowman1993-07-05UHC-30916-26——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-401517CLMChristine Snyder1989-08-27UHC-44691-785494319437—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-417913CLMAmy Fernandez2005-10-02——8451 Willow Ct, Austin, TX, 787870.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-423067CLMPhilyp Fox1993-12-25———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-427215CLMAshley M Bowman1954-07-27—4277801336—0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-409132CLMStephen H Miller1998-05-04UHC-10946-99—8460 Baseline Rd, Jacksonville, FL, 322100.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-423024CLMKyle Smith1983-12-24UHC-64566-52——0.82Name split from “Last, First”Member ID reformattedPlaceholder values cleared
CLM-423321CLMHarold Ramirez1943-04-28UHC-18546-96——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-409786CLMCheryl Welh1938-01-06UHC-07157-28——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-416055CLMBrenda Harper1940-05-15———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-408655CLMJames Ramirez2000-11-27UHC-84711-77——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-407089CLMVincent G Watkins2000-11-26UHC-63848-42——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-428951CLMLori Miller1942-02-11UHC-11050-439055430691—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-408154CLMElijah Allen1943-12-01UHC-15522-206168902010—0.82Name split from “Last, First”Phone reformattedWhitespace trimmed
CLM-403096CLMAnn Adams1964-03-09UHC-49487-89—4774 Broadway, Scottsdale, AZ, 852440.82Name split from “Last, First”Address re-casedPlaceholder values cleared
CLM-406464CLMKathleen Moore1977-02-10—45556668964834 Forest Ave, Los Angeles, CA, 900380.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-406465CLMKathleen Moore1977-02-10—45556668964834 Forest Ave, Los Angeles, CA, 900380.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-422340CLMJack Dnun1944-06-26UHC-52947-29—5132 Oak St, Plano, TX, 750840.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-415149CLMMarcus Carr1942-10-28——2952 Jefferson Ave, Tampa, FL, 336180.82Name split from “Last, First”State code upper-casedPlaceholder values cleared
CLM-413625CLMEric Sullivan1963-09-08—4495005274—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-413624CLMEric Sullivan1963-09-08—4495005274—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-424038CLMAhmed C Cruz1986-04-22UHC-49614-51——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-420932CLMJessica Romero1959-11-02———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-420226CLMElliott R Raymond1956-04-25———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-422552CLMEthan Porter1969-01-18UHC-50566-98——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-422551CLMEthan Porter1969-01-18UHC-50566-98——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-420393CLMBrittany Nichols1984-08-18UHC-42580-56—4311 Sage Ct, Eden Prairie, MN, 553570.82Name split from “Last, First”City re-casedPlaceholder values cleared
CLM-405611CLMMariana L Lane1972-09-10——3982 Cedar Ln, Denver, CO, 802540.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-416369CLMRice Lisa1975-07-12UHC-13130-092534550759—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-410519CLMDiego Martin2007-10-15UHC-39798-526817532472—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-429840CLMLauren Ramos1955-07-01——5403 Maple Ave, Miami, FL, 331330.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-411268CLMDaniel Austin1967-05-16———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-407446CLMJoseph King1982-12-04UHC-46651-1170383629469130 Broadway, Jacksonville, FL, 322900.82Name split from “Last, First”Phone reformattedWhitespace trimmed
CLM-427692CLMAmy Fernandez1948-03-16UHC-54769-51——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-425935CLMBrenda Robinson1998-02-20—2639247657—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-408638CLMLori F Dominguez2000-09-04——730 Sage Ct, Miami, FL, 331430.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-425869CLMKathleen Jacobs1999-02-07—56522880692475 Harbor Blvd, Houston, TX, 770740.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-418788CLMLarry Green1958-08-24—9053069190—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-432490CLMRoger G Martinez1990-03-15UHC-40330-54——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-418358CLMNicholas Adams1947-10-04UHC-35449-2656559758799388 Park Pl, Nashville, TN, 372020.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
3,226 rows, page 60 of 65PreviousNext