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-50472TPAKenneth Parker————0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-403511CLMRonald Alvarado—UHC-24064-83—431 Lake View Rd, Mesa, AZ, 852940.80Date of birth unreadableCity re-casedWhitespace trimmedPlaceholder values cleared
CLM-408367CLMAisha Austin———871 Mesa Dr, San Diego, CA, 921920.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-117090ENRKayla L Gardner—UHC-87728-37—9879 Elm St, Jacksonville, FL, 322780.80Name re-casedDate of birth unreadableCity re-casedPlaceholder values cleared
ENR-124983ENRGerald W Garrett—UHC-05394-1566536876681125 Lincoln Way, Los Angeles, CA, 900360.80Date of birth unreadablePhone reformattedPlan code upper-casedWhitespace trimmed
TPA-62095TPAPaul Hudson————0.80Date of birth unreadableEmail lower-casedWhitespace trimmedPlaceholder values cleared
CLM-407974CLMDanielle Reynolds—UHC-46263-10——0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-403078CLMRoy Howell—UHC-50013-23—8604 Lake View Rd, San Diego, CA, 921940.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-414790CLMBrenda Crawford——4626064389—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-26769PRVBetty Gardner—UHC-30425-6728230985237139 Lake View Rd, Fresno, CA, 937630.80Date of birth unreadablePhone reformattedEmail lower-casedPlaceholder values cleared
CLM-430846CLMMateo Grant————0.80Name re-casedDate of birth reformattedDate of birth unreadablePlaceholder values cleared
PRV-22578PRVNathan W Bennett——9715566125—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-409653CLMAdam Ortega—UHC-52099-828329974087—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-418638CLMNatalie O Hoffman—UHC-91848-90—4436 Highland Ave, Mesa, AZ, 852170.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-115757ENRAlbert Butler—UHC-78321-6687169099984427 Jefferson Ave, Tempe, AZ, 852380.80Date of birth unreadableCity re-casedPlan code upper-casedPlaceholder values cleared
CLM-410280CLMAngela J Foster——6136855579—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
ENR-117418ENRJoe Peters—UHC-86752-6222358465594227 Market St, Miami, FL, 331800.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-133623ENREmily S Knight—UHC-61707-5148776761887278 Harbor Blvd, Jacksonville, FL, 322510.80Date of birth unreadableCity re-casedState code upper-casedEmail lower-cased
TPA-63696TPAAmanda Andrews—UHC-57948-95—7758 Central Ave, Chandler, AZ, 852750.80Date of birth unreadableCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-20712PRVAustin Z Palmer—UHC-12179-4295467476948866 Hillcrest Rd, Minneapolis, MN, 554980.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-134384ENRHeather Rios—UHC-67463-23—6475 Desert Sky Blvd, Sacramento, CA, 958270.80Date of birth reformattedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-423212CLMCamila Kelly—UHC-20025-628273197244—0.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
ENR-136544ENRMaria Z Palmer—UHC-45838-6988287888379185 Highland Ave, Las Vegas, NV, 891660.80Date of birth unreadableState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-52253TPAMartha Jones———4291 Market St, San Diego, CA, 921870.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-54517TPAAgela Moreno——91358591515944 Park Pl, Houston, TX, 770010.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-414408CLMOlivia Berry—UHC-49255-57—6516 Spring St, Jacksonville, FL, 322180.80Name re-casedDate of birth unreadableCity re-casedPlaceholder values cleared
CLM-414750CLMJuan Lopez——2795763102—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
ENR-136014ENRTimothy Y Robinson—UHC-66634-5569948159719153 Broadway, Fresno, CA, 937690.80Date of birth unreadablePhone reformattedAddress re-casedPlaceholder values cleared
ENR-106237ENREdward Carlson—UHC-13968-9794849512548906 Maple Ave, Tucson, AZ, 857170.80Name re-casedDate of birth unreadableEmail lower-casedPlaceholder values cleared
ENR-118312ENRPatricia Fox—UHC-26905-49474621972863 Broadway, Denver, CO, 802590.80Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed
CLM-402374CLMRalph Armstrong—UHC-84017-34—7925 Broadway, Tampa, FL, 336120.80Date of birth unreadableCity re-casedWhitespace trimmedPlaceholder values cleared
CLM-427280CLMGeorge Boyd——43180583049125 River Rd, Denver, CO, 802880.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-428440CLMOlivia Porter———5149 Highland Ave, Minneapolis, MN, 554950.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-432048CLMNathan Hernandez—UHC-51466-5366268107997291 Union St, Fresno, CA, 937560.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
ENR-142041ENRHenry King—UHC-09665-72—7813 Park Pl, Scottsdale, AZ, 852890.80Name re-casedDate of birth unreadableEmail lower-casedWhitespace trimmed
ENR-110234ENRKaren Jones—UHC-56622-3876783039749265 River Rd, Houston, TX, 770340.80Date of birth reformattedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-137939ENRHeather Hayes—UHC-31874-1991488783858947 Sage Ct, Denver, CO, 802950.80Date of birth unreadablePhone reformattedCity re-casedEmail lower-cased
ENR-134454ENRShirley U Crawford—UHC-23349-8490893527109043 Jefferson Ave, Denver, CO, 802070.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-415582CLMSofia Carpenter—UHC-23990-07—204 Ocean Ave, Dallas, TX, 752710.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-123383ENRJackie G Montgomery—UHC-67452-0824973620008867 Oak St, Scottsdale, AZ, 852580.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-410203CLMJennifer Nunez—UHC-84002-2040290786412821 Grand Ave, Eden Prairie, MN, 553470.80Date of birth unreadablePhone reformattedState code upper-casedPlaceholder values cleared
PRV-22165PRVJoyce Thompson——78289465262819 Pine Dr, Fresno, CA, 937210.80Date of birth reformattedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-404871CLMNancy W Estrada—UHC-01826-5479163656127743 Oak St, Phoenix, AZ, 850920.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-426677CLMBetty Pena——6775151078—0.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
ENR-102139ENRCharlie Marquez—UHC-90696-285675652015—0.80Date of birth unreadablePhone reformattedEmail lower-casedPlaceholder values cleared
TPA-62823TPAPeter Garrett———1338 Bayshore Dr, Scottsdale, AZ, 852290.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-130788ENRAlexander Montgomery—UHC-78966-6753167629016536 Washington St, Charlotte, NC, 282300.80Date of birth unreadableMember ID reformattedEmail lower-casedWhitespace trimmed
ENR-143046ENRKatherine D Simpson—UHC-20087-8666249211599808 Cedar Ln, Phoenix, AZ, 850790.80Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed
ENR-126443ENRMadison Flores—UHC-58663-0840692539124481 Mountain View Dr, Gilbert, AZ, 852520.80Date of birth unreadablePhone reformattedEmail lower-casedWhitespace trimmed
ENR-109576ENRAnn O Jordan—UHC-47140-1826937775728195 Indian School Rd, Dallas, TX, 752830.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
2,274 rows, page 39 of 46PreviousNext