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
ENR-115488ENRPriya G Tucker—UHC-26060-453497194168619 Ocean Ave, Jacksonville, FL, 322480.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
ENR-137721ENRDebra D Hanson—UHC-53346-45—9897 Bayshore Dr, Dallas, TX, 752690.80Date of birth unreadableMember ID reformattedEmail lower-casedWhitespace trimmed
ENR-101115ENRSara D Daniels—UHC-86981-7496453002908035 Jefferson Ave, Charlotte, NC, 282670.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
ENR-103972ENRElijah Vasquz—UHC-70709-5226621531253325 Church St, Sacramento, CA, 958830.80Date of birth unreadableEmail lower-casedWhitespace trimmedPlaceholder values cleared
ENR-118574ENRAnn V Jacobs—UHC-42385-6998182019437551 Oak St, Nashville, TN, 372830.80Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed
TPA-60066TPAJoe Rivera———8364 Camelback Rd, Gilbert, AZ, 852590.80Date of birth unreadableCity re-casedWhitespace trimmedPlaceholder values cleared
CLM-405358CLMAlbert Li—UHC-19977-98——0.80Name re-casedDate of birth unreadableMember ID reformattedPlaceholder values cleared
TPA-50095TPAAlice Le———4656 Hillcrest Rd, Glendale, AZ, 853820.80Date of birth unreadableState code upper-casedWhitespace trimmedPlaceholder values cleared
ENR-115823ENRTim Z Young—UHC-63709-8380067147482331 Jefferson Ave, Tampa, FL, 336560.80Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed
ENR-118888ENRAnna D Park—UHC-82241-54290626719568 Broadway, San Diego, CA, 921040.80Date of birth unreadablePhone reformattedMember ID reformattedCity re-cased
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
ENR-136942ENRMegan I Perez—UHC-14015-2844848116641460 Bayshore Dr, Miami, FL, 331610.80Name re-casedDate of birth unreadableCity re-casedPlaceholder values cleared
CLM-411747CLMArjun Herrera—UHC-43441-499526841399—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-128995ENRDiego A Hill—UHC-96030-1368581930776895 Willow Ct, Nashville, TN, 372010.80Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed
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
TPA-63698TPAJudy Oliver——60755648459763 Harbor Blvd, Plano, TX, 750890.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-405519CLMMichael Fox—UHC-12651-4137782926017268 Highland Ave, Orlando, FL, 328930.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-118184ENRWayne Ryan—UHC-34825-0362041953051114 Sage Ct, Orlando, FL, 328580.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55835TPAKatherine Gomez————0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-104664ENRCamila O Hart—UHC-21071-7895061323585353 Valley View Dr, Jacksonville, FL, 322280.80Date of birth unreadablePhone reformattedState code upper-casedWhitespace trimmed
ENR-132701ENRAnna Young—UHC-28393-3522834084465941 Cedar Ln, Los Angeles, CA, 900030.80Date of birth unreadablePhone reformattedState code upper-casedWhitespace trimmed
PRV-27760PRVMariana Hamilton——8583358665—0.80Date of birth unreadablePhone reformattedEmail lower-casedPlaceholder values cleared
ENR-122733ENRMaria E Salazar—UHC-89268-42840961077074 Valley View Dr, Jacksonville, FL, 322880.80Name re-casedDate of birth unreadablePhone reformattedState code upper-cased
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
TPA-59636TPABevrely Vasquez—UHC-14586-30——0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-410339CLMRebecca Harris——40571227167103 Market St, Atlanta, GA, 303880.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
ENR-110270ENRLawrence Q Knnight—UHC-57169-8455192458068614 Canyon Rd, Tampa, FL, 336110.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51285TPAYuki White————0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-115422ENRSharon D White—UHC-18935-085928440081618 Desert Sky Blvd, Austin, TX, 787140.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
ENR-135650ENRCarol Murray—UHC-75188-27875568366291 Spring St, Eden Prairie, MN, 553270.80Name re-casedDate of birth unreadableCity re-casedWhitespace trimmed
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
ENR-133409ENRBeverly K Cunningham—UHC-32494-1343171462115678 Meadow Ln, Miami, FL, 331730.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-421631CLMEmily Wagner—UHC-20500-138417400837956 Pine Dr, Glendale, AZ, 853070.80Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted
PRV-28748PRVKevin Guzman——2788808571—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
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
TPA-63009TPAAustin Rogers———7743 Sage Ct, San Antonio, TX, 782730.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-138537ENRKenneth S Ray—UHC-87282-2567748135269330 Cedar Ln, Orlando, FL, 328260.80Date of birth unreadablePhone reformattedCity re-casedPlaceholder values cleared
CLM-424879CLMMasno Price———2697 Hillcrest Rd, Charlotte, NC, 282310.80Date of birth unreadableCity re-casedWhitespace trimmedPlaceholder values cleared
ENR-116229ENREdward Coleman—UHC-77392-6163297004547471 Washington St, Denver, CO, 802220.80Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed
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
ENR-123678ENRDeborah M Elliott—UHC-46677-363965752271—0.80Name re-casedDate of birth unreadablePhone reformattedEmail lower-cased
2,274 rows, page 40 of 46PreviousNext