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 “Date of birth unreadable”, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagDate of birth unreadableClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-414790CLMBrenda Crawford——4626064389—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-430846CLMMateo Grant————0.80Name re-casedDate of birth reformattedDate of birth unreadablePlaceholder values cleared
CLM-409653CLMAdam Ortega—UHC-52099-828329974087—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-418638CLMNatalie O Hoffman—UHC-91848-90—4436 Highland Ave, Mesa, AZ, 852170.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-410280CLMAngela J Foster——6136855579—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-423212CLMCamila Kelly—UHC-20025-628273197244—0.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-414408CLMOlivia Berry—UHC-49255-57—6516 Spring St, Jacksonville, FL, 322180.80Name re-casedDate of birth unreadableCity re-casedPlaceholder values cleared
CLM-414750CLMJuan Lopez——2795763102—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-402374CLMRalph Armstrong—UHC-84017-34—7925 Broadway, Tampa, FL, 336120.80Date of birth unreadableCity re-casedWhitespace trimmedPlaceholder values cleared
CLM-427280CLMGeorge Boyd——43180583049125 River Rd, Denver, CO, 802880.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-428440CLMOlivia Porter———5149 Highland Ave, Minneapolis, MN, 554950.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-432048CLMNathan Hernandez—UHC-51466-5366268107997291 Union St, Fresno, CA, 937560.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-415582CLMSofia Carpenter—UHC-23990-07—204 Ocean Ave, Dallas, TX, 752710.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-410203CLMJennifer Nunez—UHC-84002-2040290786412821 Grand Ave, Eden Prairie, MN, 553470.80Date of birth unreadablePhone reformattedState code upper-casedPlaceholder values cleared
CLM-404871CLMNancy W Estrada—UHC-01826-5479163656127743 Oak St, Phoenix, AZ, 850920.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-426677CLMBetty Pena——6775151078—0.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-405358CLMAlbert Li—UHC-19977-98——0.80Name re-casedDate of birth unreadableMember ID reformattedPlaceholder values cleared
CLM-419791CLMRonald Q Fowler—UHC-11532-4086080267606612 Park Pl, San Diego, CA, 921100.80Name re-casedDate of birth unreadableState code upper-casedPlaceholder values cleared
CLM-430380CLMKyle Ray———1541 Broadway, Seattle, WA, 981210.80Name re-casedDate of birth unreadableAddress re-casedPlaceholder values cleared
CLM-411747CLMArjun Herrera—UHC-43441-499526841399—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-416230CLMLarry Richardson——9896256904—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-425654CLMJacck Kennedy—UHC-82804-57—1930 Valley View Dr, Orlando, FL, 328800.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-407526CLMDeborah X Harvey—UHC-95099-559614248710—0.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-405519CLMMichael Fox—UHC-12651-4137782926017268 Highland Ave, Orlando, FL, 328930.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-410350CLMWayne McDonald—UHC-20834-44—1644 Mesa Dr, Sacramento, CA, 958760.80Name re-casedDate of birth unreadableCity re-casedPlaceholder values cleared
CLM-402187CLMTheresa West—UHC-07177-154497337976—0.80Date of birth unreadablePhone reformattedMember ID reformattedPlaceholder values cleared
CLM-410339CLMRebecca Harris——40571227167103 Market St, Atlanta, GA, 303880.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-405530CLMDenise Dunn——37971970485263 Sunset Blvd, Tempe, AZ, 852390.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-405529CLMDenise Dunn——37971970485263 Sunset Blvd, Tempe, AZ, 852390.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-421631CLMEmily Wagner—UHC-20500-138417400837956 Pine Dr, Glendale, AZ, 853070.80Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted
CLM-431937CLMNatalie Nguyen———391 Willow Ct, Nashville, TN, 372670.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-410297CLMWillie Mejia—UHC-65942-132302938681—0.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-430715CLMAmanda Q Guerrero————0.80Date of birth reformattedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-424879CLMMasno Price———2697 Hillcrest Rd, Charlotte, NC, 282310.80Date of birth unreadableCity re-casedWhitespace trimmedPlaceholder values cleared
CLM-419786CLMValentina Estraada—UHC-41804-64——0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-422344CLMMartha I Dixon——73928257476794 Park Pl, Atlanta, GA, 303770.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-424045CLMAlexander Robertson—UHC-20832-0855668650457728 Lincoln Way, Chandler, AZ, 852220.80Name re-casedDate of birth unreadablePhone reformattedCity re-cased
CLM-419700CLMRoy Fowler—UHC-48092-75—9436 Indian School Rd, Charlotte, NC, 282020.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-419052CLMBrandon V Kennedy——5704183417—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-416614CLMNoah Turner—UHC-74114-62——0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-408017CLMBeverly Rios——82286196275655 Park Pl, Columbus, OH, 432100.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-424889CLMAisha Moore——7848269253—0.80Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed
CLM-426382CLMShirley Soto—UHC-96595-3132742110756577 Baseline Rd, Nashville, TN, 372170.80Date of birth reformattedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-426383CLMShirley Soto—UHC-96595-3132742110756577 Baseline Rd, Nashville, TN, 372170.80Date of birth reformattedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-422319CLMRyan D Reed—UHC-08268-31—7022 Elm St, Charlotte, NC, 282890.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-407512CLMLarry Walker——82920671264859 Cedar Ln, Austin, TX, 787900.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-420701CLMLauren Gutierrez—UHC-72049-97—5474 Indian School Rd, Chandler, AZ, 852200.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-423515CLMBrandon Williamson—UHC-93009-324479734660—0.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-406254CLMLinda Wood—UHC-88685-49—4941 Highland Ave, Columbus, OH, 432310.80Name re-casedDate of birth unreadableMember ID reformattedPlaceholder values cleared
CLM-428373CLMRonald Cole——38237679271549 Union St, Miami, FL, 331080.80Date of birth unreadablePhone reformattedCity re-casedPlaceholder values cleared
753 rows, page 13 of 16PreviousNext