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, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-417947CLMKevin Cunningham1962-09-09UHC-16646-6526089730939629 Cedar Ln, Gilbert, AZ, 852640.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-125542ENRDris Silva1994-06-24UHC-22212-5240283994175123 Main St, Mesa, AZ, 852800.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-126734ENRDiana M Park1996-05-28UHC-17088-1998170428826071 River Rd, Fresno, CA, 937460.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-128189ENRHelen M Reid2005-11-28UHC-88997-727597401091463 Cedar Ln, Mesa, AZ, 852540.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-140323ENRAlice T Chapman1984-10-10UHC-31500-76—101 Palm Dr, Tucson, AZ, 857510.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-115231ENRJrry B Day1959-07-17UHC-84674-7322332702045139 Palm Dr, Miami, FL, 331560.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-115232ENRJrry B Day1959-07-17UHC-84674-7322332702045139 Palm Dr, Miami, FL, 331560.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-113997ENRSandra K Wallace1967-04-23UHC-09961-74—204 Sage Ct, Los Angeles, CA, 900090.52Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+2 more
ENR-109564ENRJudith Mills1952-01-10UHC-91879-8938234719716622 Oak St # 375, Jacksonville, FL0.52Name re-casedPhone reformattedUnit split from streetZIP missing+2 more
PRV-28113PRVGrace Wong2000-12-03——3571 Spring St, Sacramento, CA, 958340.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-407965CLMCharlotte I Welch1957-01-17UHC-68577-0240467509212334 Lake View Rd, Houston, TX, 770110.52SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-432005CLMVirginia Gordon1975-11-08UHC-62470-62—3974 Willow Ct, Gilbert, AZ, 852450.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-139984ENRBenjamin J Ferguson1948-02-20UHC-50436-7552823235656269 Willow Ct, Eden Prairie, MN, 553250.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-113319ENRAbigail F Reynolds1976-04-27UHC-56842-6532693716058152 Ocean Ave, Seattle, WA, 981490.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-426477CLMGregory Day1959-02-20—5348763142195 Meadow Ln, Charlotte, NC, 282660.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
ENR-136514ENRMei Watkins2004-04-13UHC-66207-1539148531627539 Elm St, San Diego, CA, 921830.52Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-116265ENRAmy Pierce—UHC-70925-4854464368683002 Main St, Denver, CO, 802070.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
TPA-61598TPAAdam Carlson1990-04-20——2767 Lake View Rd, Denver, CO, 802810.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428242CLMAlice Cruz1939-01-08UHC-28830-68—4350 Meadow Ln Apt 20, Houston, TX, 770290.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430980CLMKaren Thomas2005-11-05UHC-47494-97—6718 Mesa Dr, Houston, TX, 770820.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-108559ENRAdam Q Lynch1978-04-18UHC-18611-1042595273709340 Maple Ave Apt 37, Fresno, CA, 937320.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-402281CLMHiroshi N Kelley1977-12-16UHC-89921-68—1459 Jefferson Ave, Miami, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-415201CLMEmily X Contreras1984-11-12——1247 Baseline Rd, San Antonio, TX, 782200.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-416497CLMAisha Gibson1941-12-19—87736347953743 Church St Apt 19, Atlanta, GA, 303590.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-400082CLMFatima Lynch2001-08-22UHC-78829-5935186822317675 Harbor Blvd, Columbus, OH0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-106534ENRKimberly J Willis1954-04-24UHC-79191-2922743402845805 Park Pl, San Diego, CA, 921060.52Name split from “Last, First”Two-digit birth yearPhone reformattedEmail lower-cased+2 more
CLM-402691CLMLarry Myes1944-11-25UHC-51103-97—4345 Maple Ave, Houston, TX, 770100.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-126024ENREthan W Kelley2005-07-03UHC-61301-422883581409180 Meadow Ln, Seattle, WA, 981100.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142808ENRSamantha U Martin1986-12-18UHC-06474-1982771229839519 Jefferson Ave, Eden Prairie, MN, 553320.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-116020ENRBeverly Harrison1962-03-11UHC-76087-4443364076088994 Cedar Ln, Sacramento, CA0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-132413ENRIJunk2007-02-06UHC-55057-0567651843527501 Apache Blvd, Seattle, WA, 981630.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425106CLMMartha Dixon2007-02-09UHC-86777-89—8595 Desert Sky Blvd, Houston, TX, 770740.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-108958ENRLaura Fuller1966-01-21UHC-11283-3292741012927731 Central Ave, Dallas, TX0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63938TPALarry Wong2001-10-02——5452 Ridge Rd, Orlando, FL, 328860.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-120739ENRAlexis F Phillips1958-08-10UHC-25166-1149344343783344 Ridge Rd Apt 2, Sacramento, CA, 958060.52Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+2 more
ENR-108648ENRAlexander Gomez1961-07-04UHC-93177-7734065611489313 Mountain View Dr # 550, San Diego, CA, 921510.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-134750ENRSamantha X Reynolds1955-08-26UHC-48745-5626270156549042 Canyon Rd, Scottsdale, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-413431CLMGabriel Gray1962-05-03UHC-31656-924787614161868 Sage Ct, Columbus, OH, 432660.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-120055ENRGerald C Bennett1957-03-26UHC-99151-1396699532109437 Washington St # 446, Jacksonville, FL0.52Unit split from streetZIP missingGender normalisedPlan code upper-cased+2 more
CLM-403424CLMGrace I Robertson1940-03-22UHC-83130-165547331813101 Sunset Blvd, Las Vegas, NV, 891580.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-109274ENRRussell A Maria1960-01-15UHC-52329-6030850012217975 Spring St, Atlanta, GA, 303400.52Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+2 more
TPA-58375TPAEthan T Mitchell1954-08-17——4533 Valley View Dr Apt 13, Atlanta, GA, 303720.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-142880ENRZachary Allen1997-01-10UHC-52129-9883678945932122 Union St, Plano, TX, 750210.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-132827ENRHiroshi L Webb1978-05-02UHC-42260-19—8151 Church St, Denver, CO, 802960.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-136122ENRJoe H Hicks1963-10-13UHC-33142-3927158769513667 Meadow Ln Apt 22, Phoenix, AZ, 850030.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-129368ENRKyala Coleman1950-08-25UHC-25788-1646841513219747 Main St, Scottsdale, AZ, 852130.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408687CLMEvelyn Ramos1970-12-02UHC-77500-44—330 Baseline Rd, Orlando, FL, 328320.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-122704ENRDouglas I Rivera—UHC-47071-9055798845732311 Park Pl, Los Angeles, CA, 900120.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-106186ENROlivia Parker2005-01-06UHC-01303-0259380967492862 Sage Ct, Houston, TX, 770170.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431278CLMNicholas Marshall1955-12-11UHC-05205-986498532301779 Elm St, Atlanta, GA, 303360.52Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
100,000 rows, page 160 of 2,000PreviousNext