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-123435ENRStephanie B Hunt—UHC-45656-20—4313 Canyon Rd, Plano, TX, 750230.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
ENR-140663ENRKayla Talor—UHC-97205-6346764057914019 Grand Ave, Los Angeles, CA, 900980.68Name split from “Last, First”Date of birth unreadableEmail lower-casedWhitespace trimmed
CLM-421914CLMHelen Mills—UHC-72226-5669193391848254 Cedar Ln Apt 27, San Diego, CA, 921270.68Date of birth unreadablePhone reformattedUnit split from streetWhitespace trimmed
CLM-426311CLMCynthia Robinson—UHC-25770-44—1360 Meadow Ln, Houston, TX, 770370.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
ENR-110826ENRBilly Olson—UHC-87272-66—8096 River Rd, Mesa, AZ, 852590.68Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased
CLM-404815CLMBobby Rivera—UHC-50386-34—6527 Washington St, Scottsdale, AZ, 852360.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
ENR-142882ENRBenjamin Olson—UHC-43567-80—3921 Lincoln Way, Jacksonville, FL, 322780.68Name re-casedDate of birth unreadablePhone missing area codeWhitespace trimmed
CLM-400774CLMMark Freeman—UHC-14472-19—8601 Jefferson Ave, Scottsdale, AZ, 852770.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
ENR-135788ENRDouglas Edwards—UHC-70622-6340899104901861 Bayshore Dr, Sacramento, CA, 958880.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-430659CLMJudith Schultz—UHC-26690-1627456626701867 Pine Dr, Houston, TX, 770770.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
CLM-431184CLMJean Nunez———1238 Central Ave, Nashville, TN0.68Date of birth unreadableZIP missingWhitespace trimmedPlaceholder values cleared
ENR-132895ENRAmber Lawson—UHC-33070-4332051548966226 Indian School Rd, Orlando, FL, 328720.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
CLM-410822CLMTeresa Hudson———7336 Mountain View Dr, Nashville, TN, 372590.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-64370TPADorothy Gomeez———4929 Elm St, Los Angeles, CA, 900300.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
ENR-105926ENRHenry Y Little—UHC-90229-5447777834286925 Hillcrest Rd, Plano, TX, 750170.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
ENR-122348ENRKen Henry—UHC-27427-7352455426234427 Forest Ave, Dallas, TX, 752080.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
CLM-410771CLMAbigail Johnston—UHC-13519-75——0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52910TPADenise T Henderson————0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-131593ENRGregory X Price—UHC-11694-5867528182213676 Harbor Blvd, Tampa, FL, 336990.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
ENR-117518ENRWayne Torres—UHC-04022-43—5701 Willow Ct, Jacksonville, FL, 322360.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-29366PRVBrittany D Shaw——50761705626327 Ridge Rd, Denver, CO, 802990.68Date of birth unreadableGender normalisedWhitespace 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
CLM-407178CLMAhmed Wallace—UHC-37460-16—4100 Cedar Ln, Scottsdale, AZ, 852200.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
ENR-142554ENRJessica Butler—UHC-65037-6184850216711637 Sage Ct, Plano, TX, 750500.70Date of birth unreadableGender normalisedWhitespace trimmed
CLM-430217CLMVirginia Hansen—UHC-14278-08—3692 Sunset Blvd, Jacksonville, FL0.70Date of birth unreadableZIP missingPlaceholder values cleared
ENR-108451ENRLinda R Russell—UHC-28519-5938439665849542 Camelback Rd, Miami, FL0.70Name re-casedDate of birth unreadableZIP missing
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
ENR-106898ENRJeff Oliver—UHC-68483-4859796213315314 Camelback Rd, Mesa, AZ, 852640.70Name split from “Last, First”Date of birth unreadablePlaceholder 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
ENR-109973ENRLori Washington—UHC-14542-7883630528135031 Hillcrest Rd, Nashville, TN, 372690.70Date of birth unreadablePhone reformattedZIP+4 trimmed
ENR-113505ENRMelissa M Gilbert—UHC-21771-5531944823454068 Main St, San Diego, CA, 921610.70Date of birth unreadablePhone reformattedState name converted to code
CLM-408301CLMMichelle Jensen———311 Park Pl, Nashville, TN, 372170.70Date of birth unreadableGender normalisedPlaceholder values cleared
TPA-55274TPAJulia Vega———8225 Highland Ave, Scottsdale, AZ, 852290.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
CLM-429501CLMAbigail Tunrer—UHC-81001-64—1536 Lake View Rd, Nashville, TN, 372720.70Date of birth unreadableState name converted to codePlaceholder values cleared
CLM-416849CLMDebra Elliott—UHC-39687-17—2215 Valley View Dr, Orlando, FL, 328580.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
CLM-401558CLMRoger R George—UHC-68033-85—6203 Maple Ave, Minneapolis, MN, 554270.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
ENR-133504ENRRachel Griffin—UHC-00904-3871282653863033 Camelback Rd, Tampa, FL, 336430.70Name re-casedDate of birth unreadableGender normalised
ENR-119538ENREvelyn Alvarado—UHC-71311-5123845761759250 Lincoln Way, Plano, TX, 750770.70Name split from “Last, First”Date of birth unreadableWhitespace trimmed
ENR-105309ENRAbbby J Andrews—UHC-48013-488794888751499 Lincoln Way, Minneapolis, MN0.70Date of birth unreadableZIP missingWhitespace trimmed
ENR-106148ENRPamela E Romero—UHC-33943-256897955953647 Lincoln Way, Chandler, AZ, 852520.70Name split from “Last, First”Date of birth unreadablePhone reformatted
ENR-137549ENRMarcus Black—UHC-60758-2550461574702200 Apache Blvd, Fresno, CA, 937430.70Date of birth unreadableStreet suffix standardisedAddress re-cased
PRV-28991PRVJudith Morgan—UHC-85227-494493674179112 Meadow Ln # 869, Chandler, AZ, 852230.70Date of birth unreadableUnit split from streetPlaceholder values cleared
CLM-416325CLMDeborah W Maldonado—UHC-25667-87—904 Canyon Rd, Fresno, CA, 937860.70Date of birth unreadableStreet suffix standardisedAddress re-cased
CLM-424039CLMMazon Schultz—UHC-06517-82—773 Church St, Seattle, WA, 981580.70Date of birth unreadablePhone missing area codePlaceholder values cleared
TPA-55449TPAHeather Berry————0.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
ENR-122033ENRSarah Chapman—UHC-93677-085957811650263 Ridge Rd, Austin, TX, 787790.70Date of birth unreadablePhone reformattedState name converted to code
2,274 rows, page 35 of 46PreviousNext