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

All sources, flag “Date of birth unreadable”, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagDate of birth unreadableClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-416762CLMBrnadon Morrris—UHC-64581-7458296311753009 Maple Ave, Tampa, FL, 336260.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-115096ENRCynthia Elliott—UHC-89870-5795762594008525 Sage Ct, Eden Prairie, MN, 553860.82Name re-casedDate of birth unreadablePhone reformatted
CLM-407009CLMEmily Silva—UHC-43687-7172294205144265 Union St, Los Angeles, CA, 900670.82Date of birth unreadableCity re-casedEmail lower-cased
PRV-25000PRVJulia Carpenter—UHC-53528-158972660610997 Baseline Rd, Mesa, AZ, 852620.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-61275TPADenise Adams——8638571973—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-60952TPAElizabeth Meyre————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-108584ENRHannah V Wright—UHC-63052-14—9518 Lincoln Way, Las Vegas, NV, 891160.82Name re-casedDate of birth unreadablePlaceholder values cleared
ENR-106844ENRThomas Boyd—UHC-64494-3447892654967546 Sunset Blvd, Sacramento, CA, 958830.82Date of birth reformattedDate of birth unreadablePhone reformatted
ENR-125662ENRJulia I Foster—UHC-10308-90—7149 Jefferson Ave, Tucson, AZ, 857230.82Name re-casedDate of birth unreadablePlan code upper-cased
CLM-424455CLMWalter Estrada———1013 Lincoln Way, Chandler, AZ, 852770.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-140034ENROmar Espinoza—UHC-74422-8856982435959085 Baseline Rd, Chandler, AZ, 852530.82Date of birth unreadablePhone reformattedWhitespace trimmed
ENR-140035ENROmar Espinoza—UHC-74422-8856982435959085 Baseline Rd, Chandler, AZ, 852530.82Date of birth unreadablePhone reformattedWhitespace trimmed
TPA-50804TPABetty T Peters———7521 Camelback Rd, Sacramento, CA, 958810.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
TPA-51021TPADiana A Hudson————0.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
ENR-137452ENRVictoria P Ramos—UHC-08939-3476940386826219 Lincoln Way, Fresno, CA, 937830.82Date of birth unreadablePhone reformattedWhitespace trimmed
ENR-113514ENRMartha S Price—UHC-69123-3183690543539418 Broadway, Glendale, AZ, 853670.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-404472CLMDon Daniels—UHC-31510-08——0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-22775PRVBecky Campbell—UHC-35903-7276239642855109 Indian School Rd, Dallas, TX, 752530.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-50195TPANicole Chen————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-430184CLMMichael George—UHC-92579-34——0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-53078TPAJesse Hudson——80069282387065 Lincoln Way, Los Angeles, CA, 900250.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-417345CLMAna Mason——31488981554563 Lincoln Way, Eden Prairie, MN, 553810.82Date of birth unreadablePhone reformattedPlaceholder values cleared
ENR-129988ENRCarlos P Weber—UHC-85560-15—5935 Broadway, Dallas, TX, 752440.82Name re-casedDate of birth unreadableWhitespace trimmed
TPA-58766TPARonald Burton———8308 Washington St, Denver, CO, 802430.82Date of birth reformattedDate of birth unreadablePlaceholder 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
ENR-103568ENRDorothy T Ward—UHC-42279-5689630149261415 Camelback Rd, Chandler, AZ, 852760.82Name re-casedDate of birth unreadablePhone reformatted
ENR-113690ENRKayla J Diaz—UHC-50759-5221992318563694 Meadow Ln, Jacksonville, FL, 322840.82Name re-casedDate of birth unreadableWhitespace trimmed
ENR-140554ENRPhilip E Jnesen—UHC-52547-0955772186969751 River Rd, Columbus, OH, 432380.82Name re-casedDate of birth unreadableWhitespace trimmed
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
ENR-120762ENRSara Estrada—UHC-50584-318857278051785 Palm Dr, Jacksonville, FL, 322200.82Name re-casedDate of birth unreadableWhitespace trimmed
TPA-63242TPAJack Pierce————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-60951TPAAndrew Hunt————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-414758CLMAlice Marquez—UHC-69942-61—664 Oak St, Jacksonville, FL, 322290.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-401764CLMWalter Wang—UHC-97777-83——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-432693CLMKimberly Lynch—UHC-86014-86—8359 Mountain View Dr, Jacksonville, FL, 322140.82Date of birth unreadableCity re-casedPlaceholder values cleared
ENR-142167ENRMateo C Harris—UHC-00465-515333285612—0.82Name re-casedDate of birth unreadablePhone reformatted
CLM-428987CLMAlan Nunez—UHC-39174-6680238235751713 Sage Ct, Columbus, OH, 432200.82Date of birth unreadablePhone reformattedWhitespace trimmed
ENR-107789ENRLinda B Bowman—UHC-62137-1531984105927825 Desert Sky Blvd, San Antonio, TX, 782040.82Date of birth unreadablePhone reformattedWhitespace trimmed
CLM-413637CLMTeresa Walsh————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
2,274 rows, page 43 of 46PreviousNext