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
TPA-63749TPAJoe Vargas————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
ENR-120703ENRBenjamin Z Harper—UHC-31896-428068666322493 Spring St, Mesa, AZ, 852240.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-430880CLMSophia Williamson—UHC-77075-886927316891—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
ENR-127389ENREmily Harper—UHC-67702-49—4685 Desert Sky Blvd, Nashville, TN, 372390.82Date of birth unreadableEmail lower-casedPlaceholder values cleared
ENR-107164ENRJason S Mills—UHC-87174-7428124752911493 Sage Ct, Columbus, OH, 432030.82Date of birth unreadablePhone reformattedWhitespace trimmed
CLM-421451CLMArjun Williams—UHC-60834-4494044456988526 Bayshore Dr, Miami, FL, 331730.82Date of birth unreadablePhone reformattedPlaceholder values cleared
ENR-130271ENRSandra S Banks—UHC-77872-4858443525337841 Park Pl, Tucson, AZ, 857360.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-130583ENRJanice Lucas—UHC-20193-9948674592389737 Meadow Ln, Jacksonville, FL, 322040.82Date of birth unreadableEmail lower-casedWhitespace trimmed
ENR-110587ENRSophia Peters—UHC-41273-98—1565 Bayshore Dr, Scottsdale, AZ, 852830.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-62284TPATony Myers———4764 Sunset Blvd, Eden Prairie, MN, 553340.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-56693TPAHannah Carroll——9098181731—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-56604TPAKelly Tucker————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-424935CLMJeffrey Jenkins—UHC-38887-298399898724413 Baseline Rd, Houston, TX, 770840.82Date of birth unreadablePhone reformattedPlaceholder values cleared
PRV-21967PRVLori Lewis———6077 Highland Ave, Atlanta, GA, 303310.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-422250CLMDaniel Schmidt——6736488875—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
ENR-120170ENRLawrence Nichols—UHC-23434-16—2895 Canyon Rd, Las Vegas, NV, 891830.82Date of birth unreadableWhitespace trimmedPlaceholder 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
ENR-105413ENRDylan Webb—UHC-32490-35—2218 Harbor Blvd, Eden Prairie, MN, 553240.82Date of birth unreadableMember ID reformattedCity re-cased
ENR-117856ENREmily P Wallace—UHC-48730-8485582198144775 Camelback Rd, Denver, CO, 802110.82Date of birth unreadablePhone reformattedWhitespace trimmed
CLM-407492CLMDoris Murphy—UHC-18676-02——0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-101137ENRAaron Payne—UHC-50453-4890895431129763 Indian School Rd, Glendale, AZ, 853750.82Date of birth unreadablePhone reformattedPlaceholder 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
ENR-102539ENRIsabella Y Price—UHC-41557-4947344955027692 Meadow Ln, San Antonio, TX, 782350.82Date of birth unreadablePhone reformattedPlaceholder values cleared
PRV-27387PRVSteven L Gibson——4738530410—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-423706CLMJoyce Montgomery————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-59493TPAAustin Bishop———3168 Central Ave, Phoenix, AZ, 850140.82Date of birth unreadableWhitespace trimmedPlaceholder 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
TPA-55522TPACharlotte F Bryent—UHC-22651-59——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
ENR-129155ENRMaria Schultz—UHC-53299-278525186227—0.82Date of birth unreadableEmail lower-casedPlaceholder values cleared
CLM-418001CLMDeborah Elliott—UHC-46677-3639657522719691 Cedar Ln, Minneapolis, MN, 554000.82Date of birth unreadableCity re-casedPlaceholder values cleared
ENR-123368ENRGerald T Sandoval—UHC-41043-5646056884171877 Mesa Dr, Mesa, AZ, 852120.82Date of birth unreadablePlan code upper-casedWhitespace trimmed
CLM-404581CLMJacob Simpson—UHC-02926-18——0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-118634ENRFrank Patel—UHC-94541-335214958016—0.82Date of birth unreadablePhone reformattedWhitespace trimmed
ENR-122496ENRAlice B Graham—UHC-35055-31—1877 Forest Ave, Seattle, WA, 981290.82Name re-casedDate of birth unreadableWhitespace trimmed
ENR-111304ENRCharlotte Owens—UHC-49048-5527477820871858 Jefferson Ave, Orlando, FL, 328670.82Date of birth unreadableEmail lower-casedWhitespace trimmed
ENR-129108ENRYuki Ramirez—UHC-45942-1077756519375770 Apache Blvd, Fresno, CA, 937980.82Date of birth unreadablePhone reformattedWhitespace trimmed
TPA-63062TPAJeffrey Phillips——2955335291—0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-102094ENRGregory M Williamson—UHC-62492-1929180863499673 Ocean Ave, Houston, TX, 770030.82Name re-casedDate of birth unreadablePhone reformatted
PRV-20033PRVDiana Y Ramos—UHC-92145-596418418084—0.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-60525TPAMaria Jenkins———2486 Mountain View Dr, Jacksonville, FL, 322320.82Name re-casedDate of birth unreadablePlaceholder values cleared
ENR-114154ENRBarbara Wong—UHC-80734-8158767053061106 Bayshore Dr, Orlando, FL, 328050.82Name re-casedDate of birth unreadablePhone reformatted
CLM-409030CLMPatricia Andrews——4696792661—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
ENR-129104ENRHenry N Salazar—UHC-44361-6380678578293077 Park Pl, Las Vegas, NV, 891630.82Date of birth unreadablePhone reformattedPlaceholder values cleared
ENR-117683ENRWright U Joshua—UHC-71174-3138022150707265 Desert Sky Blvd, Chandler, AZ, 852730.82Name re-casedDate of birth unreadablePlaceholder values cleared
ENR-117684ENRWright U Joshua—UHC-71174-3138022150707265 Desert Sky Blvd, Chandler, AZ, 852730.82Name re-casedDate of birth unreadablePlaceholder values cleared
2,274 rows, page 42 of 46PreviousNext