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 missing”, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagDate of birth missingClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-122938ENRKaren W Howell—UHC-45285-0575043023142893 Pine Dr, Austin, TX, 787200.78Name re-casedDate of birth missingPhone reformattedWhitespace trimmed+1 more
ENR-139395ENRGary O Harris—UHC-62653-0335657913191821 Park Pl, Gilbert, AZ, 852950.78Name re-casedDate of birth missingPhone reformattedCity re-cased+1 more
ENR-125529ENRAlbert Ellis—UHC-85432-069452836060860 Ocean Ave, Houston, TX, 770500.78Date of birth missingCity re-casedEmail lower-casedPlan code upper-cased+1 more
ENR-125975ENRDonna Wong—UHC-05699-8873866146297147 Mountain View Dr, Glendale, AZ, 853960.78Name re-casedDate of birth missingPhone reformattedState code upper-cased+1 more
CLM-410621CLMFatima McDonald——73340395344487 Washington St, Los Angeles, CA, 900560.78Date of birth missingPhone reformattedCity re-casedWhitespace trimmed+1 more
ENR-101881ENRMary Z Sandoval—UHC-46216-6661436724106116 Pine Dr, Minneapolis, MN, 554000.78Name re-casedDate of birth missingPhone reformattedWhitespace trimmed+1 more
PRV-28087PRVBruce Vaqzuez—UHC-72856-878319669136—0.78Name re-casedDate of birth missingPhone reformattedWhitespace trimmed+1 more
ENR-131021ENRSarah T Cooper—UHC-49792-05—9543 Hillcrest Rd, Eden Prairie, MN, 553770.78Name re-casedDate of birth missingEmail lower-casedWhitespace trimmed+1 more
PRV-22781PRVAshley Scott—UHC-15919-7744444320415892 Highland Ave, Houston, TX, 770160.78Date of birth missingPhone reformattedCity re-casedWhitespace trimmed+1 more
CLM-427374CLMLaura Simpson—UHC-59203-2985327447907788 Sunset Blvd, Chandler, AZ, 852710.78Name re-casedDate of birth missingPhone reformattedMember ID reformatted+1 more
PRV-24860PRVAisha Z Chapman——22546979444462 Cedar Ln, Miami, FL, 331910.78Date of birth missingPhone reformattedCity re-casedWhitespace trimmed+1 more
CLM-400743CLMAnna Fisher—UHC-66514-159384466330—0.78Name re-casedDate of birth missingPhone reformattedWhitespace trimmed+1 more
CLM-400744CLMAnna Fisher—UHC-66514-159384466330—0.78Name re-casedDate of birth missingPhone reformattedWhitespace trimmed+1 more
PRV-25913PRVOmar Bell——7913942176—0.78Date of birth missingPhone reformattedPlan code upper-casedWhitespace trimmed+1 more
ENR-108956ENRDieo H Gonzales—UHC-87150-9842360215253904 Market St, Minneapolis, MN, 554080.78Name re-casedDate of birth missingPhone reformattedCity re-cased+1 more
CLM-412287CLMSsan Hansen———8129 Palm Dr, Los Angeles, CA, 900100.78Name re-casedDate of birth missingEmail lower-casedWhitespace trimmed+1 more
PRV-26401PRVJoyce Evans—UHC-63977-819738624698—0.78Name re-casedDate of birth missingEmail lower-casedWhitespace trimmed+1 more
TPA-51149TPAAlan Jacbs——3645787610—0.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
CLM-406286CLMJanice Ellis—UHC-61445-162313540359—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
ENR-110216ENRKatherine Ellis—UHC-68175-77—8308 Meadow Ln, Chandler, AZ, 852460.80Name re-casedDate of birth missingMember ID reformattedPlaceholder values cleared
CLM-426343CLMOmar N Weaver—UHC-71491-857039799708—0.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
TPA-55393TPADoris Mills——8485147047—0.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
ENR-100010ENRCarolyn O Burns—UHC-64387-2286471439247945 Forest Ave, Jacksonville, FL, 322880.80Name re-casedDate of birth missingPhone reformattedMember ID reformatted
CLM-411691CLMEmily Guzman—UHC-12345-16——0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-418309CLMEmma Berry——2518961167—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
ENR-104457ENRBruce G Cooper—UHC-60040-6989245443973870 Broadway, Columbus, OH, 432910.80Name re-casedDate of birth missingMember ID reformattedPlaceholder values cleared
TPA-54496TPAMartha Price——8369054353—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24603PRVJesse Torres—UHC-40675-7721044662606930 Lincoln Way, Atlanta, GA, 303770.80Date of birth missingPhone reformattedCity re-casedPlaceholder values cleared
CLM-405307CLMJesse Tucker—UHC-78551-2097770031728484 Lincoln Way, Mesa, AZ, 852080.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55046TPATerry Arnold————0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-429000CLMDebra Steveens—UHC-48417-883135944344—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
ENR-137868ENRTeresa P Ramos—UHC-65278-6276279838615696 Sunset Blvd, Las Vegas, NV, 891860.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
CLM-424679CLMJean F Pena—UHC-63144-446825226386—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
ENR-123914ENRMargaret Q Bishop—UHC-17308-488076132892153 Main St, Mesa, AZ, 852350.80Date of birth missingMember ID reformattedWhitespace trimmedPlaceholder values cleared
CLM-427360CLMEvelyn Walsh—UHC-54568-432208860022472 Apache Blvd, San Antonio, TX, 782240.80Date of birth missingPhone reformattedMember ID reformattedWhitespace trimmed
PRV-26905PRVCarolyn J Martin——42827904625919 Church St, Plano, TX, 750080.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
ENR-106217ENRFrnces Richardson—UHC-93602-7744738307489785 Elm St, Orlando, FL, 328770.80Name re-casedDate of birth missingPlan code upper-casedWhitespace trimmed
CLM-418259CLMMariana Fowler—UHC-92162-533238211928—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-413413CLMChristine Q Ray—UHC-79756-168399892244—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
ENR-113509ENRJudith E Park—UHC-26411-532079862157—0.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
ENR-142532ENRJeremy Z Murphy—UHC-74188-9761272067492694 Ocean Ave, Miami, FL, 331480.80Date of birth missingCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-61626TPAAbigail Price—UHC-79699-27—2730 Desert Sky Blvd, Tempe, AZ, 852450.80Date of birth missingCity re-casedWhitespace trimmedPlaceholder values cleared
CLM-430682CLMDennis Delgado—UHC-37047-8437889847257235 Bayshore Dr, Fresno, CA, 937250.80Date of birth missingPhone reformattedMember ID reformattedPlaceholder values cleared
CLM-430681CLMDennis Delgado—UHC-37047-8437889847257235 Bayshore Dr, Fresno, CA, 937250.80Date of birth missingPhone reformattedMember ID reformattedPlaceholder values cleared
CLM-430933CLMJason Bennett—UHC-05560-6430748507989140 Lake View Rd, Tempe, AZ, 852960.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
ENR-123875ENRKatherine A Rodriguez—UHC-60482-1747081674499607 Camelback Rd, Eden Prairie, MN, 553940.80Name re-casedDate of birth missingCity re-casedWhitespace trimmed
TPA-61983TPAFatima Y Fisher——57630133318668 Oak St, San Diego, CA, 921210.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-426972CLMTimothy Floores——58642316329101 Baseline Rd, San Antonio, TX, 782600.80Date of birth missingPhone reformattedCity re-casedPlaceholder values cleared
CLM-406422CLMStephanie X Burns———2406 Indian School Rd, Charlotte, NC, 282310.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
ENR-134419ENRBryan Y Bradley—UHC-56034-7121260932095040 Oak St, Miami, FL, 331610.80Name re-casedDate of birth missingMember ID reformattedWhitespace trimmed
990 rows, page 17 of 20PreviousNext