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-421123CLMMaria Tran—UHC-91217-9977039364096940 Forest Ave, Sacramento, CA, 958260.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-407277CLMHeather Arnold—UHC-93459-975368191123—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-423579CLMPaul Lawson—UHC-77158-4383380779783409 Elm St, Tempe, AZ, 852330.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-431739CLMArthur Valdez——42966740008255 Ocean Ave, Columbus, OH, 432010.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-400855CLMCrol Porter——50383483503041 Market St, Glendale, AZ, 853020.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-429523CLMOmar Santiago—UHC-90592-106168801419—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-428149CLMJoseph Jimenez———9058 Camelback Rd, Tempe, AZ, 852440.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-418535CLMRussell Bown—UHC-59359-98—654 Forest Ave, Orlando, FL, 328040.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-412165CLMNancy N Burton——73577377783984 Lake View Rd, Scottsdale, AZ, 852210.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-400459CLMJanice C Santiago———210 Highland Ave, Tucson, AZ, 857890.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-408785CLMSantiago Moore——50661405557197 Indian School Rd, Glendale, AZ, 853710.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-431129CLMSarah J Hamilton—UHC-22904-1993036418984998 Sage Ct, Scottsdale, AZ, 852520.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-413558CLMRachel Lee—UHC-20804-03——0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-410125CLMBruce Watson—UHC-58660-37—8285 Ocean Ave, Mesa, AZ, 852890.80Date of birth unreadableCity re-casedWhitespace trimmedPlaceholder values cleared
CLM-430880CLMSophia Williamson—UHC-77075-886927316891—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-421451CLMArjun Williams—UHC-60834-4494044456988526 Bayshore Dr, Miami, FL, 331730.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-424935CLMJeffrey Jenkins—UHC-38887-298399898724413 Baseline Rd, Houston, TX, 770840.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-422250CLMDaniel Schmidt——6736488875—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-426609CLMRussell T Tran—UHC-05870-93——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-426579CLMRalph Kelley——8395879904—0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-407492CLMDoris Murphy—UHC-18676-02——0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-424930CLMHenry Fisher————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-420554CLMMary Howard—UHC-25750-60——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-414823CLMJohn Salazar—UHC-24125-505549680666—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-414822CLMJohn Salazar—UHC-24125-505549680666—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-423706CLMJoyce Montgomery————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-410479CLMMarilyn Hill—UHC-35136-12——0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-420031CLMWalter Vazquez————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-418001CLMDeborah Elliott—UHC-46677-3639657522719691 Cedar Ln, Minneapolis, MN, 554000.82Date of birth unreadableCity re-casedPlaceholder values cleared
CLM-404581CLMJacob Simpson—UHC-02926-18——0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-409030CLMPatricia Andrews——4696792661—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-416762CLMBrnadon Morrris—UHC-64581-7458296311753009 Maple Ave, Tampa, FL, 336260.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-407009CLMEmily Silva—UHC-43687-7172294205144265 Union St, Los Angeles, CA, 900670.82Date of birth unreadableCity re-casedEmail lower-cased
CLM-424455CLMWalter Estrada———1013 Lincoln Way, Chandler, AZ, 852770.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-427571CLMDonald Adams—UHC-26650-542669549914—0.82Name re-casedDate of birth unreadablePhone reformatted
CLM-406921CLMBobby Ward———2392 Washington St, Tucson, AZ, 857540.82Date of birth unreadableCity re-casedWhitespace trimmed
CLM-416084CLMChristine T Edwards—UHC-19900-6542947948972240 Desert Sky Blvd, Columbus, OH, 432620.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-418493CLMAlexander Porter——23228034885975 Pine Dr, Chandler, AZ, 852740.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-410208CLMMaria Myers—UHC-25623-45——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-415559CLMRyan Pena—UHC-20316-03—4274 Washington St, Los Angeles, CA, 900570.82Date of birth unreadableCity re-casedWhitespace trimmed
CLM-415384CLMSantiago Q Taylor—UHC-97677-88—3821 Elm St, Scottsdale, AZ, 852730.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-416333CLMAlbert Perk—UHC-34842-6122090144792447 Palm Dr, Tempe, AZ, 852730.82Date of birth reformattedDate of birth unreadablePlaceholder values cleared
CLM-404472CLMDon Daniels—UHC-31510-08——0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-430184CLMMichael George—UHC-92579-34——0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-417345CLMAna Mason——31488981554563 Lincoln Way, Eden Prairie, MN, 553810.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-430122CLMNoah Bowman————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-405831CLMBarb Wallace—UHC-80497-35——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-404706CLMAisha Robinson—UHC-54963-89—9227 Canyon Rd, Chandler, AZ, 852510.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-430485CLMSarah Sanchez————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-417436CLMAngela Sullivan—UHC-92117-158249232096173 Indian School Rd, Minneapolis, MN, 554020.82Date of birth unreadablePhone reformattedPlaceholder values cleared
753 rows, page 14 of 16PreviousNext