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

Claims, flag “Date of birth missing”, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagDate of birth missingClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-400610CLMRoger P Tran—UHC-00583-1876165715742965 Camelback Rd, San Antonio, TX, 782380.68Name re-casedDate of birth missingGender normalisedPlaceholder values cleared
CLM-413584CLMChristian Gonzalez————0.68Name re-casedDate of birth missingGender normalisedPlaceholder values cleared
CLM-432216CLMPatrick G Lawrence—UHC-40638-05—3024 Canyon Rd, Minneapolis, MN, 554450.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-431140CLMRoger Franklin————0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-405671CLMDiego E Johnston————0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-423447CLMMadison Hawkins—UHC-18827-8063654324043643 Forest Ave, Gilbert, AZ, 852310.68Date of birth missingPhone reformattedGender normalisedPlaceholder values cleared
CLM-420913CLMRichard Franklin————0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-414738CLMYuki Foster—UHC-89406-61—3566 Lake View Rd, Sacramento, CA, 958470.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-430302CLMDebbie Perez———2625 Highland Ave, Chandler, AZ, 852460.68Name re-casedDate of birth missingZIP+4 trimmedPlaceholder values cleared
CLM-410326CLMBrian W Roberts—UHC-10708-73—4456 River Rd, Tucson, AZ0.68Date of birth missingZIP missingWhitespace trimmedPlaceholder values cleared
CLM-404888CLMLinda Murraay—UHC-87160-20—9085 Washington St Apt 7, Mesa, AZ, 852500.68Date of birth missingUnit split from streetWhitespace trimmedPlaceholder values cleared
CLM-421685CLMJustin Maldonado—UHC-51965-78—199 Washington St, Miami, FL, 331530.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-419588CLMKaren R Stewart——3985202442—0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-402763CLMJacob Evans—UHC-30782-04—2290 Spring St, Jacksonville, FL, 322440.68Date of birth missingGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-402680CLMCharlotte Shaw—UHC-98731-47——0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-426966CLMKeith Collins———2439 Mesa Dr, Los Angeles, CA, 900530.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412094CLMNoah O Coleman—UHC-80842-13—3319 Maple Ave, Charlotte, NC, 282690.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410537CLMAdam Bailey———6587 Jefferson Ave Apt 36, Scottsdale, AZ, 852220.70Date of birth missingUnit split from streetPlaceholder values cleared
CLM-406599CLMEmma X Meyer—UHC-13185-09—5206 Sunset Blvd, Columbus, OH, 432250.70Date of birth missingGender normalisedPlaceholder values cleared
CLM-412122CLMShirley Gibson—UHC-25275-60——0.70Name split from “Last, First”Date of birth missingPlaceholder values cleared
CLM-416028CLMBrenda Nguyen—UHC-96686-3973996649395028 Harbor Blvd, San Diego, CA0.70Date of birth missingZIP missingPlaceholder values cleared
CLM-416165CLMRalph Simmons——3536288229—0.70Name split from “Last, First”Date of birth missingPlaceholder values cleared
CLM-420803CLMJulia Z Garza—UHC-69609-77——0.70Date of birth missingGender normalisedPlaceholder values cleared
CLM-430858CLMDanielle A Welh—UHC-57613-3977824530612220 Willow Ct, Tempe, AZ, 852150.76Name re-casedDate of birth missingPhone reformattedCity re-cased+2 more
CLM-415769CLMTyler Moore——76224278162614 Market St, Seattle, WA, 981580.76Name re-casedDate of birth missingPhone reformattedCity re-cased+2 more
CLM-406641CLMLaura X Gonzales—UHC-04399-76—6818 Camelback Rd, Las Vegas, NV, 891130.78Name re-casedDate of birth missingEmail lower-casedWhitespace trimmed+1 more
CLM-422320CLMDeborah Robinson—UHC-84327-143847063063—0.78Date of birth missingPhone reformattedMember ID reformattedWhitespace trimmed+1 more
CLM-418106CLMMelissa Padilla——2992239486—0.78Name re-casedDate of birth missingPhone reformattedWhitespace trimmed+1 more
CLM-412101CLMRalph Y Pryce——41790207671502 Lake View Rd, Minneapolis, MN, 554240.78Name re-casedDate of birth missingPhone reformattedCity re-cased+1 more
CLM-406261CLMTyler A Gutierrez——76190197462641 Lincoln Way, San Antonio, TX, 782990.78Name re-casedDate of birth missingPhone reformattedCity re-cased+1 more
CLM-406190CLMAlan Sims—UHC-89095-0420443821422292 Market St, Phoenix, AZ, 850190.78Date of birth missingPhone reformattedCity re-casedWhitespace trimmed+1 more
CLM-410273CLMMark Owens—UHC-97198-6786275782836488 Cedar Ln, Fresno, CA, 937800.78Date of birth missingPhone reformattedState code upper-casedWhitespace trimmed+1 more
CLM-424110CLMDoris Y Thomas—UHC-73006-675944511673—0.78Name re-casedDate of birth missingPhone reformattedWhitespace trimmed+1 more
CLM-404948CLMNicole X Rice——27896317478696 Canyon Rd, Fresno, CA, 937850.78Name re-casedDate of birth missingPhone reformattedWhitespace trimmed+1 more
CLM-427889CLMAaron R West—UHC-59920-6037367608928485 Hillcrest Rd, Charlotte, NC, 282230.78Name re-casedDate of birth missingPhone reformattedWhitespace trimmed+1 more
CLM-410621CLMFatima McDonald——73340395344487 Washington St, Los Angeles, CA, 900560.78Date of birth missingPhone reformattedCity re-casedWhitespace trimmed+1 more
CLM-427374CLMLaura Simpson—UHC-59203-2985327447907788 Sunset Blvd, Chandler, AZ, 852710.78Name re-casedDate of birth missingPhone reformattedMember ID reformatted+1 more
CLM-400743CLMAnna Fisher—UHC-66514-159384466330—0.78Name re-casedDate of birth missingPhone reformattedWhitespace trimmed+1 more
CLM-400744CLMAnna Fisher—UHC-66514-159384466330—0.78Name re-casedDate of birth missingPhone reformattedWhitespace trimmed+1 more
CLM-412287CLMSsan Hansen———8129 Palm Dr, Los Angeles, CA, 900100.78Name re-casedDate of birth missingEmail lower-casedWhitespace trimmed+1 more
CLM-406286CLMJanice Ellis—UHC-61445-162313540359—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-426343CLMOmar N Weaver—UHC-71491-857039799708—0.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
CLM-411691CLMEmily Guzman—UHC-12345-16——0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-418309CLMEmma Berry——2518961167—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-405307CLMJesse Tucker—UHC-78551-2097770031728484 Lincoln Way, Mesa, AZ, 852080.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-429000CLMDebra Steveens—UHC-48417-883135944344—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-424679CLMJean F Pena—UHC-63144-446825226386—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-427360CLMEvelyn Walsh—UHC-54568-432208860022472 Apache Blvd, San Antonio, TX, 782240.80Date of birth missingPhone reformattedMember ID reformattedWhitespace trimmed
CLM-418259CLMMariana Fowler—UHC-92162-533238211928—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-413413CLMChristine Q Ray—UHC-79756-168399892244—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
320 rows, page 5 of 7PreviousNext