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-51233TPASantiago Schmidt——46747561855291 Forest Ave, Jacksonville, FL, 322710.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-419700CLMRoy Fowler—UHC-48092-75—9436 Indian School Rd, Charlotte, NC, 282020.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-139921ENRLori Cruz—UHC-84305-3543050602781354 Harbor Blvd, Atlanta, GA, 303880.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-419052CLMBrandon V Kennedy——5704183417—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-416614CLMNoah Turner—UHC-74114-62——0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-408017CLMBeverly Rios——82286196275655 Park Pl, Columbus, OH, 432100.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
ENR-118890ENRAna P Wong—UHC-13625-763955959376—0.80Date of birth unreadablePhone reformattedEmail lower-casedPlaceholder values cleared
CLM-424889CLMAisha Moore——7848269253—0.80Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed
PRV-28935PRVDaniel Turner—UHC-52643-654509372554—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-28535PRVJocye Baker——6037111101—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-426382CLMShirley Soto—UHC-96595-3132742110756577 Baseline Rd, Nashville, TN, 372170.80Date of birth reformattedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-426383CLMShirley Soto—UHC-96595-3132742110756577 Baseline Rd, Nashville, TN, 372170.80Date of birth reformattedDate of birth unreadablePhone reformattedPlaceholder values cleared
TPA-56852TPAMartha Campbell———2352 Broadway, Mesa, AZ, 852870.80Date of birth unreadableAddress re-casedWhitespace trimmedPlaceholder values cleared
CLM-422319CLMRyan D Reed—UHC-08268-31—7022 Elm St, Charlotte, NC, 282890.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-24768PRVSandra O Campbell——57264508168853 Hillcrest Rd, Tampa, FL, 336780.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-407512CLMLarry Walker——82920671264859 Cedar Ln, Austin, TX, 787900.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-420701CLMLauren Gutierrez—UHC-72049-97—5474 Indian School Rd, Chandler, AZ, 852200.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-113303ENRRoy F Gray—UHC-24777-3872966647247049 Cedar Ln, Orlando, FL, 328800.80Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed
CLM-423515CLMBrandon Williamson—UHC-93009-324479734660—0.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-406254CLMLinda Wood—UHC-88685-49—4941 Highland Ave, Columbus, OH, 432310.80Name re-casedDate of birth unreadableMember ID reformattedPlaceholder values cleared
ENR-106830ENRAna D Contreras—UHC-79284-7261876248489416 Ridge Rd, Atlanta, GA, 303590.80Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed
CLM-428373CLMRonald Cole——38237679271549 Union St, Miami, FL, 331080.80Date of birth unreadablePhone reformattedCity re-casedPlaceholder values cleared
CLM-421123CLMMaria Tran—UHC-91217-9977039364096940 Forest Ave, Sacramento, CA, 958260.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-57836TPAGerald T Sandoval—UHC-41043-56—1877 Mesa Dr, Mesa, AZ, 852120.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-407277CLMHeather Arnold—UHC-93459-975368191123—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-423579CLMPaul Lawson—UHC-77158-4383380779783409 Elm St, Tempe, AZ, 852330.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-431739CLMArthur Valdez——42966740008255 Ocean Ave, Columbus, OH, 432010.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
ENR-102800ENRAlexxander W Parker—UHC-39613-6164750916471372 Broadway, Columbus, OH, 432560.80Name re-casedDate of birth unreadablePhone reformattedAddress re-cased
ENR-123522ENRGreg Taylor—UHC-40403-198789534201—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21383PRVAngela Kennedy———890 Forest Ave, Dallas, TX, 752390.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-400855CLMCrol Porter——50383483503041 Market St, Glendale, AZ, 853020.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-429523CLMOmar Santiago—UHC-90592-106168801419—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
ENR-111717ENRMaria Ortiz—UHC-34340-2728696116241527 Park Pl, Nashville, TN, 372220.80Name re-casedDate of birth unreadableCity re-casedWhitespace trimmed
CLM-428149CLMJoseph Jimenez———9058 Camelback Rd, Tempe, AZ, 852440.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-418535CLMRussell Bown—UHC-59359-98—654 Forest Ave, Orlando, FL, 328040.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-26244PRVRalph Wang—UHC-12292-288379041449—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-412165CLMNancy N Burton——73577377783984 Lake View Rd, Scottsdale, AZ, 852210.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-400459CLMJanice C Santiago———210 Highland Ave, Tucson, AZ, 857890.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-130364ENRCarolyn Evans—UHC-34615-3745223938192666 Broadway, Scottsdale, AZ, 852030.80Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed
CLM-408785CLMSantiago Moore——50661405557197 Indian School Rd, Glendale, AZ, 853710.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-431129CLMSarah J Hamilton—UHC-22904-1993036418984998 Sage Ct, Scottsdale, AZ, 852520.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
CLM-413558CLMRachel Lee—UHC-20804-03——0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-112462ENREmily T Little—UHC-13577-7924255111626250 Willow Ct, Las Vegas, NV, 891380.80Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed
CLM-410125CLMBruce Watson—UHC-58660-37—8285 Ocean Ave, Mesa, AZ, 852890.80Date of birth unreadableCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-56040TPAKayla Perkins——89536547519256 Sunset Blvd, Seattle, WA, 981680.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
ENR-120441ENRSharon Z Simmons—UHC-71089-33—3873 Hillcrest Rd, Miami, FL, 331260.80Date of birth unreadableMember ID reformattedWhitespace trimmedPlaceholder values cleared
ENR-120154ENRKenneth J Shaw—UHC-78163-4425282677699058 Broadway, Columbus, OH, 432450.82Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-64074TPAMariana M Little———4453 Market St, Chandler, AZ, 852860.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-59882TPAGrace Carter——25227855721028 Church St, Denver, CO, 802360.82Date of birth unreadablePhone reformattedPlaceholder values cleared
PRV-23790PRVPatrick E Schultz——4855623762—0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
2,274 rows, page 41 of 46PreviousNext