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
PRV-25724PRVLisa Hudson—UHC-49171-42719276323619 Broadway, Phoenix, AZ, 850680.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
CLM-407509CLMAndrea Kennedy—UHC-99655-87—7806 Market St, Phoenix, AZ, 850200.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
ENR-142363ENRDbera Duncan—UHC-31605-5448272168425984 Canyon Rd, Atlanta, GA, 303680.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
ENR-128315ENROilvia M Gonzales—UHC-00411-1896829946438846 Apache Blvd, Seattle, WA, 981510.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
CLM-432292CLMNathan Hernandez—UHC-99827-06—7224 Cedar Ln # 282, Columbus, OH, 432270.68Date of birth unreadableUnit split from streetWhitespace trimmedPlaceholder values cleared
ENR-115362ENRMargaret Gilbert—UHC-60344-2339557055726590 Canyon Rd, Minneapolis, MN, 554860.68Name split from “Last, First”Date of birth unreadablePhone reformattedWhitespace trimmed
CLM-405805CLMSmuel Wilson—UHC-53403-90——0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-111037ENRAisha E Austin—UHC-24449-236565757573871 Mesa Dr, San Diego, CA, 921920.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
CLM-414821CLMJack Salazar—UHC-24125-50——0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-123381ENRSusan X Burns—UHC-68235-49—4393 Ridge Rd, Denver, CO, 802530.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-403888CLMHenry Tran—UHC-54488-12—4058 Palm Dr, Miami, FL, 331240.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-422122CLMFieds Mark———3207 Sunset Blvd, Jacksonville, FL, 322240.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
ENR-121388ENRKeith Henry—UHC-86871-50——0.68Name re-casedDate of birth unreadableGender normalisedPlaceholder values cleared
TPA-58577TPATheersa Hill———5396 Church St, San Diego, CA, 921180.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
ENR-137711ENRElizabeth Chapman—UHC-53911-66—3446 Elm St, Gilbert, AZ0.68Name re-casedDate of birth unreadableZIP missingPlaceholder values cleared
ENR-110012ENRBruce Q Sanchez—UHC-82303-654242703589990 Palm Dr, San Diego, CA, 921790.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
CLM-403512CLMRonald Alvarado——5806000138—0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-406620CLMBrenda T Porter——4488079590—0.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
TPA-52788TPARyan Rios———4656 Maple Ave, Miami, FL, 331730.68Date of birth unreadableState code upper-casedGender normalisedPlaceholder values cleared
TPA-59858TPAAmanda Alexander———879 Sunset Blvd, Houston, TX0.68Name re-casedDate of birth unreadableZIP missingPlaceholder values cleared
ENR-118833ENRGloria L Williamson—UHC-69885-7180679204821445 Broadway, Austin, TX, 787270.68Middle initial moved out of first nameDate of birth unreadablePhone reformattedPlaceholder values cleared
TPA-52393TPACynthia Tucker——9889590428—0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
ENR-107222ENRAshley J Roberts—UHC-42068-496529182634—0.68Name split from “Last, First”Date of birth unreadableEmail lower-casedPlaceholder values cleared
TPA-52365TPATimothy Rice———7784 Canyon Rd, Fresno, CA, 937140.68Date of birth unreadablePhone missing area codeWhitespace trimmedPlaceholder values cleared
ENR-142003ENRVirginia T Gordon—UHC-62470-62—3974 Willow Ct, Gilbert, AZ, 852450.68Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased
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
ENR-138118ENRMaria Duncan—UHC-64325-0350563645489791 Canyon Rd, Las Vegas, NV, 891860.68Name re-casedDate of birth unreadableEmail lower-casedGender normalised
PRV-20118PRVWilliam G Burton——39086480157872 Main St, Nashville, TN, 372240.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410850CLMCharlotte Kenneedy—UHC-67859-40—1168 Apache Blvd, San Diego, CA, 921460.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412851CLMAna Fuller—UHC-81544-39—3985 Desert Sky Blvd, Mesa, AZ0.68Date of birth unreadableZIP missingWhitespace trimmedPlaceholder values cleared
ENR-109463ENRDeborah Jackson—UHC-89997-70—8786 Jefferson Ave, Las Vegas, NV, 891080.68Name re-casedDate of birth unreadableState code upper-casedZIP+4 trimmed
CLM-407384CLMGeorge Holmes—UHC-85048-47——0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60940TPABenjamin Henry———6289 Desert Sky Blvd, Plano, TX, 750930.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
ENR-108684ENRJoyce V Robertson—UHC-29622-207529408338561 Ocean Ave, San Antonio, TX, 782280.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
CLM-423550CLMLauren Reynolds———7932 Willow Ct, Columbus, OH0.68Date of birth unreadableCity re-casedZIP missingPlaceholder values cleared
ENR-103286ENRDiana Bennett—UHC-02217-1664898802257866 Sunset Blvd, Minneapolis, MN, 554870.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
ENR-136821ENRArthur Kelley—UHC-28863-8143782134114444 Spring St, Tempe, AZ, 852160.68Date of birth unreadableState code upper-casedZIP+4 trimmedWhitespace trimmed
CLM-405571CLMLawrence Sullivan—UHC-85120-50——0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-419240CLMDanielle Brooks—UHC-25272-645736317541533 Maple Ave, Scottsdale, AZ, 852530.68Name re-casedDate of birth unreadablePhone reformattedGender normalised
TPA-59293TPAAmber Larson—UHC-72250-8237072041269158 Washington St, Atlanta, GA, 303790.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20145PRVLawrence Sanchez—UHC-61874-0722370782936912 Baseline Rd, Tucson, AZ, 857160.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
ENR-140141ENRKelly K Miller—UHC-14354-7458848518344486 Palm Dr, Gilbert, AZ, 852050.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
ENR-124041ENRRoger Wright—UHC-73325-1036560151483969 Desert Sky Blvd, Columbus, OH, 432580.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
PRV-22943PRVRonald A Scott—UHC-68475-54—9242 Grand Ave, Phoenix, AZ, 850100.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21323PRVKenneth Jordan————0.68Date of birth unreadablePhone missing area codeWhitespace trimmedPlaceholder values cleared
ENR-118043ENRSarah I Oliver—UHC-32902-3122851364464779 Union St, Minneapolis, MN, 554050.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
ENR-129071ENREvelyn X Graham—UHC-18366-775897556703551 Washington St, Sacramento, CA, 958070.68Name re-casedDate of birth unreadableZIP+4 trimmedWhitespace trimmed
CLM-425211CLMAndrea Q Hudon—UHC-74064-92—2166 Lake View Rd, Los Angeles, CA, 900670.68Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased
2,274 rows, page 32 of 46PreviousNext