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-422509CLMRobert Marquez1950-08-05UHC-09983-434509933499590 Palm Dr, Scottsdale, AZ, 852000.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-408551CLMMariana D Anderson2000-10-14——340 Ocean Ave, Columbus, OH, 432740.80Name split from “Last, First”Date of birth reformattedCity re-casedPlaceholder values cleared
CLM-413697CLMKelly Z Perez1991-08-15UHC-12316-2922770781621759 Mountain View Dr, Los Angeles, CA, 900000.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-422485CLMSam Brown2001-05-09UHC-22101-799465149159—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-401493CLMBruce Morris1948-12-27—21686548031843 Market St, San Antonio, TX, 782610.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-424000CLMDonna Guzman1947-11-14UHC-71147-44——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-400019CLMAustin Z Henry2008-03-02UHC-53911-827104069848—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-414531CLMMaria Flores1998-02-23UHC-15319-5169062922957307 Oak St, Tempe, AZ, 852370.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-425731CLMMichlle Lynch1984-08-17UHC-87332-24—7870 Forest Ave, Houston, TX, 770480.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-410924CLMRonald Lawson1991-08-03UHC-93268-33——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-419341CLMRichard Boyd1957-09-01——7982 Central Ave, Glendale, AZ, 853370.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-415773CLMPamela P Lucas1941-05-22UHC-69961-095538783842—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-407171CLMJose Fuller1988-04-27UHC-59366-38——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-423927CLMEthan Wood1961-04-06UHC-73564-9138192289015108 Lincoln Way, Nashville, TN, 372580.80Name split from “Last, First”Phone reformattedMember ID reformattedPlaceholder values cleared
CLM-427960CLMCharlotte Wells1985-06-05UHC-61324-562758885833—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-415998CLMLarry I Mendoza1972-11-08UHC-94891-6759434357273521 Maple Ave, Charlotte, NC, 282030.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-418421CLMJoseph Vargas1967-03-08UHC-78519-237969068393—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-415896CLMVirginia W Bennett2007-07-09UHC-85901-18—3368 Lincoln Way, San Antonio, TX, 782460.80Name split from “Last, First”Date of birth reformattedMember ID reformattedPlaceholder values cleared
CLM-407337CLMElijah D Sandoval1995-08-03——4630 Market St, Miami, FL, 331450.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-430173CLMMegan Reyes1978-11-12UHC-34680-22——0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
CLM-402290CLMAnna G Young1988-03-28—2089919527—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-417508CLMHiroshi Meyer1988-10-03UHC-79807-84—3492 Willow Ct, Austin, TX, 787230.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-424693CLMJulia Dean1987-06-17UHC-21980-71——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-408335CLMMateo Gonzalees1978-04-10UHC-83490-214712284517—0.80Name split from “Last, First”Phone reformattedMember ID reformattedPlaceholder values cleared
CLM-401015CLMStephen U Bradley1960-07-28UHC-51253-792119164469—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-424877CLMElizabeth Washington1959-09-22UHC-87962-7435197982167320 Maple Ave, Columbus, OH, 432390.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-410315CLMDonna Hoffman1998-08-07—4402656997—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-414083CLMJoseph Porter1960-06-27UHC-81468-8623755107736037 Sage Ct, Gilbert, AZ, 852380.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-413360CLMRonald Padilla2001-08-28—47098678416044 Broadway, Eden Prairie, MN, 553700.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-412398CLMScott Gilbert1940-05-12—24826285481979 Pine Dr, Houston, TX, 770780.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-412399CLMScott Gilbert1940-05-12—24826285481979 Pine Dr, Houston, TX, 770780.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-432713CLMHarold Hanson1959-12-11UHC-26394-1973740360958336 Hillcrest Rd, Plano, TX, 750750.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-409015CLMBradley Bell1989-10-15UHC-18863-186273622857—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-409700CLMWilliam Walsh1983-03-25UHC-07070-34—8684 Spring St, Mesa, AZ, 852960.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-428728CLMHeather Gardner1996-07-12——3937 Elm St, Denver, CO, 802120.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-413294CLMAndrew H Montgomery1944-07-27UHC-31571-5544099799384498 Sunset Blvd, Columbus, OH, 432960.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-417171CLMJoe Graham1951-01-08———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-404045CLMRobert Wang1951-08-03—2386650626—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-403009CLMGeorge J Fernandez1951-05-09—34964697839283 Main St, Phoenix, AZ, 850140.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-413245CLMYuki Sullivan1941-10-26UHC-25113-7384897502962742 Camelback Rd, Las Vegas, NV, 891250.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-429505CLMJudith Sanchez1953-05-23UHC-37863-857573912801—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-428519CLMCarolyn Long1953-09-13—7446688772—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-406155CLMJanet Turner1938-12-18UHC-84100-905975361492856 Central Ave, Sacramento, CA, 958790.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-413702CLMCarol Owens1976-05-19UHC-59852-07——0.80Name split from “Last, First”Plan code upper-casedWhitespace trimmedPlaceholder values cleared
CLM-424678CLMAnn Berry2003-05-28UHC-79552-37—7288 Broadway, Eden Prairie, MN, 553640.80Name split from “Last, First”Member ID reformattedWhitespace trimmedPlaceholder values cleared
CLM-420738CLMCarol Rogers1973-06-14UHC-29452-5664376766426820 Hillcrest Rd, Minneapolis, MN, 554270.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-423598CLMAmy Myers1950-09-21UHC-78281-86—5533 Valley View Dr, Charlotte, NC, 282230.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-421866CLMNancy T Wong2006-05-23—8725633120—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-415359CLMBobby Gilbert1980-02-07——8460 Indian School Rd, San Diego, CA, 921600.82Name split from “Last, First”City re-casedPlaceholder values cleared
CLM-416324CLMJoan Carr2004-03-05UHC-03224-303346212733—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
3,226 rows, page 55 of 65PreviousNext