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

Third-party administrator, flag “Date of birth unreadable”, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagDate of birth unreadableClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-52393TPACynthia Tucker——9889590428—0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52365TPATimothy Rice———7784 Canyon Rd, Fresno, CA, 937140.68Date of birth unreadablePhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-51737TPAElijah Reynolds——38029254212737 Baseline Rd, Chandler, AZ, 852850.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
TPA-60488TPAAnna Wong————0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-63347TPALauren Barnes———9543 Union St, Denver, CO, 802060.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60940TPABenjamin Henry———6289 Desert Sky Blvd, Plano, TX, 750930.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59293TPAAmber Larson—UHC-72250-8237072041269158 Washington St, Atlanta, GA, 303790.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61918TPAChristine Hunter——43345378507386 Forest Ave, Jacksonville, FL, 322280.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-59668TPAOlivia Reed———9635 Forest Ave, San Antonio, TX, 782760.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51520TPAMichael Kelly———9662 Willow Ct, Dallas, TX, 752000.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61481TPADorothy Salazar————0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-55076TPAJudith Castillo——43165286245562 Pine Dr, Tucson, AZ, 857930.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53158TPAChristine Munoz——2215303664—0.68Name split from “Last, First”Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-52002TPAScott Richardson———5331 Highland Ave, Gilbert, AZ, 852970.68Date of birth unreadablePhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-59369TPASean Le———465 Willow Ct, Austin, TX, 787430.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57463TPABill Wallace————0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51727TPACharlotteJunk———8125 Canyon Rd, Austin, TX, 787650.68Date of birth unreadableState code upper-casedPlaceholder values clearedNo usable name (quarantined)
TPA-51511TPASharon Boyd———4822 Camelback Rd, Minneapolis, MN, 554710.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54756TPAAlbert Santos——66597909402953 Union St, Chandler, AZ, 852210.68Date of birth unreadableZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-57538TPARussell Matthews——9684397875—0.68Name split from “Last, First”Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-57218TPACastro Priya——84832562711086 Oak St, Seattle, WA, 981560.68Date of birth unreadableZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-53269TPAJoseph C King——70383629469130 Broadway, Jacksonville, FL, 322900.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
TPA-59850TPASara Matthews————0.68Name re-casedDate of birth unreadableSSN last four extractedPlaceholder values cleared
TPA-55700TPAJanice Hunt——85690034045192 Lincoln Way, Charlotte, NC, 282680.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
TPA-50389TPAMarcus Wallace———7455 Palm Dr, Plano, TX, 750300.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56904TPAGeorge F Salazar———1928 Palm Dr, San Antonio, TX, 782720.68Name re-casedDate of birth unreadableGender normalisedPlaceholder values cleared
TPA-59354TPARandy L Lawrence———9077 Oak St, Las Vegas, NV, 891310.68Name re-casedDate of birth unreadableZIP+4 trimmedPlaceholder values cleared
TPA-64370TPADorothy Gomeez———4929 Elm St, Los Angeles, CA, 900300.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52910TPADenise T Henderson————0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-58157TPAGerald Ortega———8711 Cedar Ln Apt 29, Columbus, OH, 432910.68Name re-casedDate of birth unreadableUnit split from streetPlaceholder values cleared
TPA-58156TPAGerald Ortega———8711 Cedar Ln Apt 29, Columbus, OH, 432910.68Name re-casedDate of birth unreadableUnit split from streetPlaceholder values cleared
TPA-62600TPAAbigail Morris————0.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
TPA-50785TPASarah Lawson———3210 Market St, Nashville, TN0.70Date of birth unreadableZIP missingPlaceholder values cleared
TPA-53386TPAPaul Little———7967 Sage Ct, Tampa, FL, 336670.70Date of birth unreadableGender normalisedPlaceholder values cleared
TPA-52579TPAJanet Ryan——34592330617220 Market St, Orlando, FL0.70Date of birth unreadableZIP missingPlaceholder values cleared
TPA-55274TPAJulia Vega———8225 Highland Ave, Scottsdale, AZ, 852290.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
TPA-62711TPAJoan Coleman———6592 Willow Ct Apt 11, Tampa, FL, 336360.70Date of birth unreadableUnit split from streetPlaceholder values cleared
TPA-55449TPAHeather Berry————0.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
TPA-61367TPASara Webar——67561632244638 Lincoln Way, San Antonio, TX, 782060.76Name re-casedDate of birth unreadablePhone reformattedState code upper-cased+2 more
TPA-56181TPAMariana G Dixon—UHC-58745-5160626081059177 Main St, Scottsdale, AZ, 852890.78Date of birth reformattedDate of birth unreadablePhone reformattedCity re-cased+1 more
TPA-54484TPAMtaeo Harris————0.78Name re-casedDate of birth reformattedDate of birth unreadableWhitespace trimmed+1 more
TPA-62188TPALogan Spencer—UHC-89476-4892667593826116 Meadow Ln, Las Vegas, NV, 891910.78Date of birth unreadablePhone reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-56762TPAArjun Brooks—UHC-10874-587465254212—0.78Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more
TPA-54675TPAGloria Ray—UHC-03742-0781371014952459 Oak St, Columbus, OH, 432040.78Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more
TPA-61714TPATyler Reyes——47890388544440 Maple Ave, Orlando, FL, 328490.78Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-50941TPAAlice F Singh—UHC-74636-7765251469124384 Main St, San Antonio, TX, 782330.78Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-55747TPAArthur Sinngh—UHC-71237-80——0.78Name re-casedDate of birth unreadableMember ID reformattedWhitespace trimmed+1 more
TPA-63683TPADaniel Oliver—UHC-84619-895885867122—0.78Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more
TPA-62649TPAValentina Scott—UHC-56762-01——0.78Name re-casedDate of birth unreadableEmail lower-casedWhitespace trimmed+1 more
TPA-62650TPAValentina Scott—UHC-56762-01——0.78Name re-casedDate of birth unreadableEmail lower-casedWhitespace trimmed+1 more
317 rows, page 5 of 7PreviousNext