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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-107906ENRLogan Q Carpenter1977-02-13UHC-39590-29—8727 Lincoln Way, Columbus, OH0.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-134053ENRLawrence A Aguilar2007-10-12UHC-50675-3466427266981029 Lake View Rd, Fresno, CA, 937640.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-127477ENRAndrea V Peters1962-05-26UHC-05108-5292542790595022 Lake View Rd, Tampa, FL0.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-126963ENRAbby U Peters2003-10-20UHC-38914-38—8838 Elm St, Atlanta, GA0.52Two-digit birth yearState code upper-casedZIP missingGender normalised+2 more
ENR-141500ENRMaria Chavez1990-06-03UHC-13335-7056495863678628 Camelback Rd, Miami, FL, 331460.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-133897ENRKile P Fields1951-05-23UHC-45606-1522977338887188 Broadway, Plano, TX, 750980.52Date of birth reformattedSSN last four extractedZIP+4 trimmedGender normalised+2 more
ENR-100468ENRPhilip N Le1980-02-05UHC-73994-3140162381176056 Union St, San Diego, CA, 921120.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-134835ENRRuth B Spencer2002-07-12UHC-50944-6347884323341966 Main St, Tempe, AZ, 852410.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-126877ENRKeith Martiinez2000-09-23UHC-16946-7755548972935721 Spring St, Glendale, AZ, 853850.52Name split from “Last, First”Phone reformattedState name converted to codeEmail lower-cased+2 more
ENR-113999ENRKenneth Hernandez1978-11-12UHC-86070-6553089974454079 Valley View Dr, Glendale, AZ, 853870.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-122760ENRWillie Hawkins1985-04-09UHC-80056-207353611040655 Indian School Rd # 286, San Antonio, TX, 782090.52Phone reformattedUnit split from streetCity re-casedZIP+4 trimmed+2 more
ENR-125597ENRVincent Taylor1947-07-13UHC-79415-0744398953878637 Grand Ave, Tucson, AZ, 857220.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142812ENRAisha Burke1960-12-03UHC-42201-9195748805808632 Oak St, Plano, TX0.52Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more
ENR-131843ENRJoshua V Perry1990-06-24UHC-65921-8085657037867612 Valley View Dr, Jacksonville, FL0.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+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
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
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
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
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
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
ENR-108958ENRLaura Fuller1966-01-21UHC-11283-3292741012927731 Central Ave, Dallas, TX0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+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
ENR-120055ENRGerald C Bennett1957-03-26UHC-99151-1396699532109437 Washington St # 446, Jacksonville, FL0.52Unit split from streetZIP missingGender normalisedPlan code upper-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
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
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
ENR-142033ENRSara Spencer1992-08-11UHC-86653-96—4028 Oak St # 476, Nashville, TN, 372900.52Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+2 more
ENR-142034ENRSara Spencer1992-08-11UHC-86653-96—4028 Oak St # 476, Nashville, TN, 372900.52Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+2 more
ENR-118169ENRMaeo Berry1954-09-13UHC-37284-1543888171333004 Hillcrest Rd, Las Vegas, NV, 891590.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-138150ENRSaa Y Greene—UHC-27441-3331948601368734 Willow Ct, Los Angeles, CA0.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-123559ENRTricia V Bradley2000-08-04UHC-03687-10—5690 Forest Ave Apt 34, Houston, TX, 770230.52Name split from “Last, First”Date of birth reformattedPhone missing area codeUnit split from street+2 more
ENR-133111ENRPatricia Patel1989-12-23UHC-55189-29—7904 Sage Ct Apt 31, Minneapolis, MN, 554650.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
43,101 rows, page 79 of 863PreviousNext