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
ENR-133561ENRJack Kennedy—UHC-82804-5781198035531930 Valley View Dr, Orlando, FL, 328800.82Date of birth unreadablePhone reformattedEmail lower-cased
ENR-127352ENRDanielle Murray—UHC-55126-7446830169097790 Meadow Ln, Eden Prairie, MN, 553300.82Date of birth unreadablePhone reformattedWhitespace trimmed
TPA-55735TPABrandon Kim————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-413511CLMWilliam Fowler—UHC-89221-28—9182 Bayshore Dr, San Diego, CA, 921860.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-132253ENRJulia F Dean—UHC-21980-7164083027525101 Central Ave, Gilbert, AZ, 852210.82Date of birth unreadablePhone reformattedPlaceholder values cleared
ENR-120910ENRJudy Williams—UHC-14307-7543225956261930 Apache Blvd, Tampa, FL, 336830.82Date of birth unreadablePhone reformattedPlaceholder values cleared
ENR-135268ENRKimberly Fox—UHC-78140-7987589288323661 Bayshore Dr, Houston, TX, 770870.82Name re-casedDate of birth unreadableWhitespace trimmed
CLM-408507CLMEvelyn Valdez—UHC-12756-192987547342—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-408964CLMGerald Sanders—UHC-66151-997664726420—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-61302TPASchultz Bryan————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-58774TPAJacob Brooks————0.82Date of birth unreadableEmail lower-casedPlaceholder values cleared
PRV-25952PRVChristina Hunter—UHC-22457-2964964492488080 Palm Dr, Atlanta, GA, 303310.82Date of birth unreadableMember ID reformattedPlaceholder values cleared
CLM-430080CLMAndrea Lee——5646999730—0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-61258TPAChristina Campbell———6439 Apache Blvd, Miami, FL, 331410.84Date of birth unreadablePlaceholder values cleared
TPA-58522TPAAustin Cunningham————0.84Date of birth unreadablePlaceholder values cleared
ENR-139957ENRKathy S Moore—UHC-75963-29—6354 Sage Ct, San Diego, CA, 921090.84Date of birth unreadablePlaceholder values cleared
ENR-115569ENRGabriel Woods—UHC-32492-2528894876791388 Broadway, Las Vegas, NV, 891880.84Date of birth unreadableCity re-cased
CLM-425087CLMJoan Z Bennett——66477836686070 Union St, San Diego, CA, 921460.84Date of birth unreadablePlaceholder values cleared
CLM-412115CLMJean Hamilton—UHC-77149-18——0.84Date of birth unreadablePlaceholder values cleared
ENR-127960ENRKatherine V Willis—UHC-08939-7224075266087286 Market St, Tampa, FL, 336750.84Date of birth unreadablePhone reformatted
CLM-403744CLMJennifer Perez————0.84Date of birth unreadablePlaceholder values cleared
CLM-425555CLMKelly Wallace——56994688559436 Oak St, Scottsdale, AZ, 852870.84Date of birth unreadablePlaceholder values cleared
ENR-122067ENRJanet I Cruz—UHC-94131-8079955422916842 Oak St, Chandler, AZ, 852440.84Date of birth unreadablePhone reformatted
CLM-404114CLMMarcus Espinoza——5416345250—0.84Date of birth unreadablePlaceholder values cleared
CLM-416195CLMAustin Nelson—UHC-36547-42—9020 Maple Ave, Seattle, WA, 981270.84Date of birth unreadablePlaceholder values cleared
ENR-108356ENRBetty W Howell—UHC-02016-9646196836079513 Apache Blvd, Columbus, OH, 432640.84Name re-casedDate of birth unreadable
ENR-107527ENRDonna Robertson—UHC-66274-6892759339637904 Washington St, Fresno, CA, 937300.84Date of birth unreadablePhone reformatted
TPA-62779TPAMark Wang—UHC-57825-02——0.84Date of birth unreadablePlaceholder values cleared
TPA-58795TPADoris Jordan———7210 Canyon Rd, Charlotte, NC, 282750.84Date of birth unreadablePlaceholder values cleared
ENR-111933ENRNicole R Gonzalez—UHC-66531-64—2729 Lincoln Way, San Antonio, TX, 782530.84Date of birth unreadableWhitespace trimmed
CLM-422856CLMJeffrey Fields————0.84Date of birth unreadablePlaceholder values cleared
ENR-121782ENRDebra Wagner—UHC-54439-28—4557 Canyon Rd, San Antonio, TX, 782400.84Date of birth unreadablePlaceholder values cleared
CLM-402367CLMAbigail Ellis—UHC-68582-42—4371 Camelback Rd, Austin, TX, 787660.84Date of birth unreadablePlaceholder values cleared
CLM-432315CLMGregory Hart—UHC-92794-69—859 Palm Dr, Chandler, AZ, 852860.84Date of birth unreadablePlaceholder values cleared
ENR-134832ENROlivia Howard—UHC-07176-5835851072724243 Oak St, Jacksonville, FL, 322410.84Date of birth unreadablePhone reformatted
CLM-422580CLMKayla Contreras————0.84Date of birth unreadablePlaceholder values cleared
CLM-426894CLMAlexis Henry—UHC-60956-74—9695 Harbor Blvd, Tucson, AZ, 857790.84Date of birth unreadablePlaceholder values cleared
ENR-102523ENRAlbert H Fields—UHC-51978-3296621192793255 Union St, Minneapolis, MN, 554200.84Date of birth unreadablePhone reformatted
CLM-409102CLMGloria Hoffman—UHC-25518-91—9333 Hillcrest Rd, Minneapolis, MN, 554930.84Date of birth unreadablePlaceholder values cleared
TPA-53237TPABrian Vazquez———4314 Washington St, Sacramento, CA, 958310.84Date of birth unreadablePlaceholder values cleared
PRV-24120PRVWayne Richardson——8955215588—0.84Date of birth unreadablePlaceholder values cleared
CLM-429925CLMStephen Freeman————0.84Date of birth unreadablePlaceholder values cleared
CLM-400091CLMPeer Jordan———9501 Spring St, Fresno, CA, 937440.84Date of birth unreadablePlaceholder values cleared
ENR-112550ENRRussell F Carlson—UHC-77117-1395267543421243 Main St, Miami, FL, 331760.84Date of birth unreadableWhitespace trimmed
ENR-137220ENRBeverly Andrews—UHC-46632-0493026786603754 Market St, Las Vegas, NV, 891900.84Date of birth unreadablePhone reformatted
ENR-136707ENRMatthew I Howell—UHC-86672-413443060500609 Apache Blvd, Gilbert, AZ, 852430.84Date of birth unreadableEmail lower-cased
TPA-53053TPABrian Contreras——7293588512—0.84Date of birth unreadablePlaceholder values cleared
TPA-60803TPAMelissa White———7238 Canyon Rd, Nashville, TN, 372340.84Date of birth unreadablePlaceholder values cleared
TPA-60804TPAMelissa White———7238 Canyon Rd, Nashville, TN, 372340.84Date of birth unreadablePlaceholder values cleared
TPA-53095TPABenjamin Yang————0.84Date of birth unreadablePlaceholder values cleared
2,274 rows, page 45 of 46PreviousNext