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-129356ENRIsabella K Romero2004-05-20UHC-15177-6740736699819224 Apache Blvd, Minneapolis, MN, 554810.54Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+1 more
ENR-135495ENRAmenda G Singh1947-10-03UHC-34285-9439878673582132 Baseline Rd, Dallas, TX0.54Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-134605ENRElizabeth Turner1995-08-17UHC-28525-3449239849185112 Ridge Rd # 265, Minneapolis, MN, 554610.54Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+1 more
ENR-127020ENRCarolyn Porter1995-04-15UHC-44477-87—5268 Church St, Seattle, WA, 981880.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-122440ENRCharlotte M Parker1975-03-14—42256685896182 Desert Sky Blvd, Scottsdale, AZ, 852100.54Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+1 more
ENR-129321ENRTimothy U Harris1961-04-21UHC-78926-706314706432533 Apache Blvd, Dallas, TX, 752900.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-137386ENRJoyce M Morgan1996-04-09UHC-80074-1426729829629043 Sunset Blvd, San Diego, CA, 921550.54Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+1 more
ENR-137430ENRAna Adams1981-09-15UHC-14475-86—3358 Palm Dr, Miami, FL, 331290.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-115981ENRSantiago W Kelley1984-08-10UHC-71672-3158543945567157 Grand Ave, Denver, CO, 802050.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-129633ENRNancy Myers1979-02-15UHC-89328-398819443602667 Sunset Blvd, Nashville, TN, 372850.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-120020ENRAustin M Rogers2006-12-27UHC-78760-24—7879 Valley View Dr, Mesa, AZ, 852450.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-106214ENRAshley F Black1941-07-20UHC-62159-8220455105774377 Camelback Rd, Eden Prairie, MN, 553860.54Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
ENR-115931ENRMichael T Mills—UHC-22066-2063693585095025 Highland Ave, Las Vegas, NV, 891910.54Date of birth missingStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-142389ENRChristian Q Wheeler1976-08-08UHC-84072-9925522169636628 Lincoln Way Apt 22, Tampa, FL, 336200.54Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+1 more
ENR-113990ENRDenise L Jensen1954-11-24UHC-41763-2959469619204637 Spring St, Eden Prairie, MN, 553610.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-107618ENRAisha Austin1967-10-16UHC-45784-2620758444978211 Willow Ct, Charlotte, NC, 282950.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-140606ENRJose Pena—UHC-68169-2136737809611513 Indian School Rd, Los Angeles, CA0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-100439ENRChristine V Salazar1973-11-05UHC-75118-4794478047857127 Sunset Blvd, Plano, TX, 750200.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-117935ENRSamantha Diaz1998-08-23UHC-92123-72—5983 Cedar Ln, Nashville, TN, 372060.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-117176ENRJoyce K Fsiher1974-05-01UHC-71280-2364248294566729 Washington St, Chandler, AZ, 852050.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-120284ENRChristian Wbeb1951-06-16UHC-95905-4235221579282035 Sunset Blvd, Houston, TX, 770440.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-130442ENRJose X Gordun1994-04-13UHC-27613-6087595690912402 Willow Ct, Tempe, AZ, 852680.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-117565ENRSarah V Brown1976-04-18UHC-04155-27—9173 Apache Blvd, Minneapolis, MN, 554960.54Phone missing area codeStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
ENR-141275ENRJeremy Roberts2002-08-08UHC-15499-5329228861801986 Church St, Atlanta, GA, 303190.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-125877ENRSara F Carpenter1954-05-13UHC-93904-2224263273965892 Willow Ct, Orlando, FL, 328340.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-131423ENRMray L Bishop1971-12-21UHC-15059-18—4398 Sage Ct, Glendale, AZ, 853010.54Middle initial moved out of first nameName re-casedZIP+4 trimmedGender normalised+1 more
ENR-131144ENRCynthia B Castro—UHC-01960-8686857558144822 Baseline Rd, Denver, CO, 802480.54Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+1 more
ENR-116135ENRWayne Castro2004-05-01UHC-11215-9562383803567173 Baseline Rd, Los Angeles, CA, 900260.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-100833ENRDiane Hart2008-02-04UHC-90073-9625981669207848 Ridge Rd, Miami, FL0.54Name split from “Last, First”Phone reformattedZIP missingGender normalised+1 more
ENR-113202ENRPJunk1985-01-23UHC-31708-6494133724762064 Pine Dr, Tempe, AZ, 852180.54Phone reformattedSSN last four extractedGender normalisedWhitespace trimmed+1 more
ENR-111772ENRMegan P Wheeler1971-03-12UHC-61260-06—8380 Sunset Blvd, Houston, TX, 770600.54Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-106072ENRKathy M Guzman2004-11-07UHC-40091-8450152253653914 Market St, Fresno, CA0.54Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
ENR-102248ENRJan Hill1973-11-18UHC-37787-3376571842085687 Washington St, Phoenix, AZ, 850040.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-135368ENRBarbara T Carr2000-03-19UHC-71429-3559538870544270 Jefferson Ave, Orlando, FL, 328450.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-120206ENRBruce V Brown1946-05-18UHC-63047-4824791542892426 Cedar Ln # 982, Minneapolis, MN, 554830.54Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-116512ENRChristine Maldonado1999-01-18UHC-29569-2395369807969770 Meadow Ln, Houston, TX0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-132419ENRBenjamin Henry2008-01-09UHC-63829-0734695011066289 Desert Sky Blvd # 957, Plano, TX, 750930.54Name split from “Last, First”Phone reformattedUnit split from streetZIP+4 trimmed+1 more
ENR-111660ENRJuan Ellis1996-07-02—67931892753402 River Rd, Eden Prairie, MN, 553620.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-110529ENRDiane N Perez1968-05-22UHC-33040-3987389540544520 Spring St # 384, Plano, TX, 750970.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-111007ENRAlexander Perez1993-06-05UHC-58073-3375665441011775 Lincoln Way, Phoenix, AZ0.54Phone reformattedMember ID reformattedState name converted to codeZIP missing+1 more
ENR-107173ENRKathryn Allen1967-10-10UHC-03261-39—1368 Main St, Austin, TX, 787470.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-125221ENRJesse Fisher1982-08-26UHC-84739-4849458501635232 Elm St Apt 37, Houston, TX, 770410.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-137405ENRHannah B Mitchell1942-01-23UHC-69310-9774283875367772 Willow Ct, Phoenix, AZ, 850810.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-123493ENRRaymond L Palmer1983-06-22UHC-07780-397574499563728 Apache Blvd, Austin, TX, 787420.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-137598ENRRalph Arnold1998-08-26UHC-79978-65—1334 Jefferson Ave, San Antonio, TX, 782540.54Phone missing area codeStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
ENR-124227ENROmar Y Evans1971-06-08UHC-04207-1377055045233145 Jefferson Ave, Charlotte, NC, 282420.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-120304ENRKeith Williamson1976-03-27UHC-70723-03—1299 Valley View Dr, Phoenix, AZ0.54Name split from “Last, First”Date of birth reformattedZIP missingGender normalised+1 more
ENR-116806ENRLogan S Evans1999-03-16UHC-46383-5045342773997167 Valley View Dr Apt 16, Fresno, CA, 937660.54Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+1 more
ENR-105987ENRWilliam X Vargas1983-02-24UHC-98408-0695920225355685 Baseline Rd, Atlanta, GA, 303040.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-117574ENRPriya Hamilton1971-06-27UHC-51752-3841774906375118 Apache Blvd, Atlanta, GA, 303810.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
43,101 rows, page 102 of 863PreviousNext