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-427724CLMMark Reid2001-09-25UHC-02756-65—4841 Union St, Eden Prairie, MN, 553170.80Name split from “Last, First”Date of birth reformattedState code upper-casedPlaceholder values cleared
CLM-429298CLMArthur Smith1975-09-02UHC-18016-818772636178—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-408133CLMAndrea C Coleman1998-03-17—50596861507471 Washington St, Tempe, AZ, 852320.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-420875CLMSandra Carlson1941-04-05——990 Ocean Ave, Charlotte, NC, 282130.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-420876CLMSandra Carlson1941-04-05——990 Ocean Ave, Charlotte, NC, 282130.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-404698CLMBrenda L Stephens2000-03-02—8762196814—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-404697CLMBrenda L Stephens2000-03-02—8762196814—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-424042CLMRuth Fox1997-01-01UHC-51091-444542466460339 Baseline Rd, Austin, TX, 787650.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-412328CLMJuan Harris1964-11-17UHC-78189-727794991234—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-412327CLMJuan Harris1964-11-17UHC-78189-727794991234—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-423420CLMJoyce F Jensen1953-09-21———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-404629CLMJacqueline Bailey1939-06-16UHC-30577-17——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-411523CLMKimberly Berry1983-04-14UHC-52540-5267798486318813 Apache Blvd, Mesa, AZ, 852260.80Name split from “Last, First”Date of birth reformattedEmail lower-casedPlaceholder values cleared
CLM-412330CLMAmber S Adams1973-09-14UHC-14192-295052656345—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-425583CLMMark Hernandez2000-11-13UHC-59408-499227518837—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-417630CLMCarolyn Campbell1950-02-15UHC-91732-23—7292 Broadway, Denver, CO, 802440.80Name split from “Last, First”Member ID reformattedAddress re-casedPlaceholder values cleared
CLM-414486CLMSandra M Guzman1941-03-22———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-409440CLMCynthia Castro1981-10-06UHC-71182-79—1248 Sunset Blvd, Seattle, WA, 981890.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-404309CLMJacqueline T Jimenez1950-09-07UHC-16993-83——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-400306CLMJohn Brooks1995-06-08UHC-96259-4087228827232490 Broadway, Mesa, AZ, 852750.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-427947CLMJames Owens1966-02-24UHC-52508-5122753310399781 Harbor Blvd, Phoenix, AZ, 850160.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-406237CLMSharon Hanson2000-07-07UHC-65180-552427033344—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-422587CLMBruce Clark1990-05-02UHC-63878-37——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-425547CLMDouglas Welch2003-09-27UHC-49873-667764236423—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-426671CLMSean Blaack2000-04-23UHC-29465-84——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-410573CLMHarold P Rojas1972-04-17—4998740265—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-404997CLMBruce Bowman1939-02-28UHC-63573-1375949299493068 Pine Dr, Gilbert, AZ, 852400.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-405240CLMDorothy Moreno1944-06-07UHC-95806-458033658210—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-424189CLMTeresa Murphy1967-10-09UHC-72939-6731822362184268 Broadway, Mesa, AZ, 852690.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-410000CLMPriya McDonald2007-08-25UHC-04817-13—5470 Market St, Tucson, AZ, 857080.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-428046CLMRoger R Arnold1998-06-21———0.80Name split from “Last, First”Plan code upper-casedWhitespace trimmedPlaceholder values cleared
CLM-403575CLMJames Gomez2000-10-26UHC-35346-4350352579995032 Broadway, Tempe, AZ, 852180.80Name split from “Last, First”Address re-casedWhitespace trimmedPlaceholder values cleared
CLM-409809CLMAlbert Williams1960-08-14—6602675424—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-404332CLMSharon Miller1960-03-24UHC-41797-448019652436—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-423464CLMAmber Willis1990-08-08UHC-07211-06——0.80Name split from “Last, First”Plan code upper-casedWhitespace trimmedPlaceholder values cleared
CLM-403765CLMAlice Robinson1955-12-26UHC-97366-44—8625 Spring St, Eden Prairie, MN, 553650.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-423038CLMKelly Silva1965-06-28———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-430660CLMJudith C Schultz1988-10-24——1867 Pine Dr, Houston, TX, 770770.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-415848CLMCamila Marshall1956-12-09—3347020523—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-427643CLMGary Ross1970-06-13—80153407476125 Sunset Blvd, Columbus, OH, 432680.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-404215CLMJanice Clark1988-06-25UHC-78491-2351899049772719 River Rd, Orlando, FL, 328170.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-416521CLMGrace V Fisher1971-03-01UHC-44389-913313736736—0.80Name split from “Last, First”Phone reformattedMember ID reformattedPlaceholder values cleared
CLM-415005CLMLaura Watkins1961-02-15—29472844132762 Willow Ct, Mesa, AZ, 852310.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-427559CLMWillie Valdez1988-02-17UHC-39473-3568488128975816 Washington St, Charlotte, NC, 282540.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-409148CLMZachary Nichos1973-09-11—63449420607771 Harbor Blvd, Atlanta, GA, 303780.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-408704CLMAmanda Larson1948-12-20—6463650878—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-406787CLMEdward Delgado1986-01-16UHC-98565-10——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-409709CLMDonna Coleman1942-10-15—62450652447430 Palm Dr, Sacramento, CA, 958480.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-431087CLMNatalie Thompson1999-02-26UHC-21601-34——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-420034CLMAbigail F Adams1940-04-10UHC-47242-41—9028 Spring St, Glendale, AZ, 853700.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
3,226 rows, page 50 of 65PreviousNext