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
CLM-400675CLMHannah Rice—UHC-84078-38——0.80Name re-casedDate of birth missingMember ID reformattedPlaceholder values cleared
PRV-22300PRVPriya I Price————0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-407190CLMKimberly Robinson——7686883529—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57956TPALinda Lucas—UHC-20791-8340027111366009 Bayshore Dr, Eden Prairie, MN, 553260.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-29336PRVRalph W Wood—UHC-68877-1129082996885440 Lake View Rd, Charlotte, NC, 282500.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
TPA-60204TPAGrace Montgomery—UHC-74716-175928770083592 Mountain View Dr, Fresno, CA, 937790.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
ENR-131911ENRJerry A Edwards—UHC-51204-168338180022922 Union St, Atlanta, GA, 303870.80Date of birth missingMember ID reformattedCity re-casedWhitespace trimmed
TPA-60350TPAEvelyn Hill——53998795743867 Desert Sky Blvd, San Antonio, TX, 782650.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-406425CLMElijah E Lawrence—UHC-97485-21——0.80Date of birth missingMember ID reformattedWhitespace trimmedPlaceholder values cleared
TPA-50335TPAAna Ward———5148 Broadway, Austin, TX, 787240.80Date of birth missingAddress re-casedWhitespace trimmedPlaceholder values cleared
CLM-401562CLMOmar Obrien———9372 Mountain View Dr, Tampa, FL, 336130.80Name re-casedDate of birth missingCity re-casedPlaceholder values cleared
ENR-106233ENRBrandon M Garrett—UHC-89215-0974037915328946 Pine Dr, Denver, CO, 802310.80Name re-casedDate of birth missingCity re-casedPlaceholder values cleared
CLM-429540CLMAhmed Senders———7646 Willow Ct, Atlanta, GA, 303100.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-404613CLMWei Y Schmidt—UHC-72575-7331894839401246 Apache Blvd, Houston, TX, 770220.80Date of birth missingCity re-casedWhitespace trimmedPlaceholder values cleared
CLM-405159CLMAlexis Fox—UHC-32649-3667545965657627 Indian School Rd, Gilbert, AZ, 852000.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
TPA-53752TPARay Helen——5923516637—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20005PRVSophia Ramirez——7196681436—0.80Date of birth missingEmail lower-casedWhitespace trimmedPlaceholder values cleared
CLM-406263CLMDylan P Reid—UHC-31001-11—6707 Meadow Ln, Atlanta, GA, 303450.80Date of birth missingCity re-casedEmail lower-casedPlaceholder values cleared
TPA-50451TPAGarrett I Jason——2837872669—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-430301CLMAndrea Martinez—UHC-02997-04——0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-402408CLMJustin J Brooks—UHC-41144-38——0.80Date of birth missingMember ID reformattedWhitespace trimmedPlaceholder values cleared
TPA-62855TPACynthia Ramirez————0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-403865CLMMegan Richardson—UHC-70659-16——0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
ENR-127543ENRCamila O Reies—UHC-66882-6554276016465782 Forest Ave, Tucson, AZ, 857620.80Name re-casedDate of birth missingPhone reformattedState code upper-cased
PRV-22254PRVLogan R Burton——35227313209374 Canyon Rd, Houston, TX, 770170.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22253PRVLogan R Burton——35227313209374 Canyon Rd, Houston, TX, 770170.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-426637CLMJesse P Moreno—UHC-10876-977536730803—0.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
CLM-410321CLMMark Evans—UHC-79386-51——0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
ENR-108747ENRJacqueline Nunez—UHC-70312-0645927463672269 Sage Ct, Glendale, AZ, 853420.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-426893CLMAmanda Santiiago————0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-402540CLMJames Delgado——2208398187—0.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
ENR-130733ENRVincent Perry—UHC-67325-8236274198567903 Ocean Ave, Mesa, AZ, 852170.82Date of birth missingPhone reformattedWhitespace trimmed
TPA-56179TPANancy Mills——47063893237380 Oak St, Charlotte, NC, 282440.82Date of birth missingPhone reformattedPlaceholder values cleared
ENR-127656ENRBrandon Gilbert—UHC-47987-5363938873585070 Highland Ave, Phoenix, AZ, 850930.82Name re-casedDate of birth missingPhone reformatted
TPA-62259TPAVasquez Shirley————0.82Name re-casedDate of birth missingPlaceholder values cleared
TPA-53641TPADeborah Alvarado———5707 Oak St, Nashville, TN, 372450.82Date of birth missingCity re-casedPlaceholder values cleared
TPA-61248TPAGregory Tuckr———5215 Mountain View Dr, Columbus, OH, 432940.82Name re-casedDate of birth missingPlaceholder values cleared
CLM-430474CLMHannah Morrison—UHC-56979-48—3111 Grand Ave, Austin, TX, 787280.82Date of birth missingCity re-casedPlaceholder values cleared
CLM-403460CLMMason Yang—UHC-23214-9353099657795607 Broadway, Seattle, WA, 981860.82Date of birth missingAddress re-casedPlaceholder values cleared
CLM-403461CLMMason Yang—UHC-23214-9353099657795607 Broadway, Seattle, WA, 981860.82Date of birth missingAddress re-casedPlaceholder values cleared
ENR-132622ENRVincent A Yang—UHC-62889-5259887527216664 Hillcrest Rd, Columbus, OH, 432610.82Date of birth missingPhone reformattedEmail lower-cased
CLM-421039CLMEvelyn X Gray—UHC-85134-327259017365—0.82Date of birth missingPhone reformattedPlaceholder values cleared
CLM-413309CLMDiana Perry—UHC-40741-22——0.82Name re-casedDate of birth missingPlaceholder values cleared
CLM-401521CLMGloria Perry——6383412876—0.82Date of birth missingPhone reformattedPlaceholder values cleared
CLM-427826CLMNatalie Morgan——77093570535647 Hillcrest Rd, Nashville, TN, 372930.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-427758CLMDenny Kelly—UHC-02487-955688398896—0.82Date of birth missingPhone reformattedMember ID reformatted
CLM-427422CLMPriya Collins—UHC-11691-57——0.82Name re-casedDate of birth missingPlaceholder values cleared
ENR-127016ENRJohn Hill—UHC-16787-1129956973054035 Ocean Ave, Denver, CO, 802380.82Name re-casedDate of birth missingWhitespace trimmed
CLM-420861CLMJoan Meyer————0.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-414332CLMLina Weaver—UHC-83189-3850027178063756 Meadow Ln, Plano, TX, 750570.82Date of birth missingPhone reformattedPlaceholder values cleared
990 rows, page 18 of 20PreviousNext