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-125176ENRJulia W Alexander1993-08-02UHC-68877-9996763406165257 Elm St, Gilbert, AZ, 852250.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-119642ENRAlice Dunn1951-08-31UHC-54642-5866248429811060 Ocean Ave, Tucson, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137644ENRBrian G Lawson1971-05-27UHC-35027-6132471137265362 Central Ave # 719, Seattle, WA, 981580.62Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+3 more
ENR-130342ENRJoose T Arnold1973-03-20UHC-02380-9477357593859748 Lake View Rd, Nashville, TN, 372470.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-112096ENRJuan M Murphy1973-10-03UHC-80089-586846278951147 Canyon Rd, Tampa, FL, 336680.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-137596ENRDoris I Miller1998-09-08UHC-16373-92—940 Hillcrest Rd, Glendale, AZ0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-123150ENRTim O Lewis1971-11-25UHC-64916-9292720537779046 Pine Dr, Tucson, AZ0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-120898ENRRobart Fox1996-04-01UHC-32636-1456273679572975 Willow Ct, Plano, TX, 750490.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114519ENRAna H Delgado1953-02-25UHC-67015-1258763382781797 Oak St, Las Vegas, NV, 891670.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-123846ENRAshley YJunk1953-01-27UHC-59839-2627760988524201 Broadway Apt 25, Dallas, TX, 752020.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-123748ENRAlan Taylor1989-01-21UHC-11805-2926472815868147 Forest Ave, Columbus, OH0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104504ENRJoyce W Freeman1965-06-18UHC-73473-38—5091 Park Pl, Plano, TX, 750480.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-105203ENRAndrea D Alvarado2001-04-04UHC-47319-3483965747285259 Pine Dr, Mesa, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140677ENROmmar Chen1995-12-06UHC-49844-0264467854033734 River Rd, Las Vegas, NV0.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-123686ENRSophia U Butler1987-10-25UHC-99861-2236644858818857 Washington St Apt 18, Orlando, FL, 328470.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-112107ENRDonna G Porter1942-05-20UHC-49476-5487041627776116 Union St, Eden Prairie, MN, 553380.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107483ENRRuth Z Hanson1985-06-06UHC-73022-0382653455533317 Church St # 997, Tempe, AZ, 852360.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-123045ENRDaniel Q Mendez1958-11-04UHC-21332-78—1144 Main St, Columbus, OH, 432250.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-126011ENRDouglas Rice1968-09-12UHC-71875-9882422254796348 Pine Dr, Chandler, AZ, 852740.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123003ENRChristopher E Guerrero1990-08-04UHC-94197-0558638397007502 Forest Ave, Scottsdale, AZ, 852260.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126540ENRScott P Hughes1958-01-10UHC-53716-2682174851575069 Lincoln Way # 614, Orlando, FL, 328540.62Name re-casedPhone reformattedUnit split from streetZIP+4 trimmed+3 more
ENR-139407ENRMichael P Kelly1947-10-06UHC-06332-538253696341882 Bayshore Dr, Gilbert, AZ, 852480.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-135391ENRLisa D Day1967-05-26UHC-41010-933842790938263 Lake View Rd, Las Vegas, NV, 891820.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-127018ENRMarcus Burton1943-08-27UHC-55090-5254033311172437 Maple Ave # 190, Atlanta, GA, 303710.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-141984ENRAmber Garrett1965-02-08UHC-76042-0738241906027536 Park Pl, Atlanta, GA, 303440.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100906ENRMelissa H Espinoza1953-11-24—65830657447482 Mesa Dr, Glendale, AZ, 853070.62Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
ENR-104646ENRDennis H Larson1965-09-05UHC-54035-725948665211290 Camelback Rd, Charlotte, NC, 282720.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129591ENRGeorge Z Flores1959-01-16——8251 Pine Dr, Jacksonville, FL, 322800.62Name re-casedDate of birth reformattedPhone missing area codeEmail lower-cased+3 more
ENR-124389ENRVirginia Hudson—UHC-37938-1420865778295068 Ocean Ave, Dallas, TX, 752180.62Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118638ENRDanielle V Adrews2006-04-02UHC-00916-155888328982621 Lincoln Way, Scottsdale, AZ, 852650.62Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-118637ENRDanielle V Adrews2006-04-02UHC-00916-155888328982621 Lincoln Way, Scottsdale, AZ, 852650.62Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-122565ENRDouglas M Warren1991-06-26UHC-26450-16—3878 Ridge Rd, Fresno, CA, 937630.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-134595ENRAlebrt Davis1967-03-19UHC-04648-4641188164718504 Hillcrest Rd, Denver, CO, 802650.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-119392ENRBadley P Romero1985-08-13UHC-50584-6849676715284722 Harbor Blvd, Minneapolis, MN, 554950.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109869ENRCarlos James1965-03-09UHC-97252-40—9833 Sunset Blvd, Charlotte, NC0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-137077ENRHarold Wood1991-04-19UHC-31679-4344920357149393 Oak St, San Diego, CA, 921670.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-117343ENRNoah L Hawkins1975-10-12UHC-16115-52—3221 Union St, San Antonio, TX, 782860.62Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-123816ENRZachary Allen1976-03-16UHC-86497-6039859515996378 Willow Ct, Eden Prairie, MN, 553860.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-101389ENRAaron Hawkins1970-07-25UHC-72312-4224928506076354 Harbor Blvd, Miami, FL, 331290.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-100491ENRPatrycia X Mitchell2008-09-01UHC-58066-278837566993513 Hillcrest Rd, Gilbert, AZ, 852980.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108177ENRFrank Armstrong1977-11-07UHC-73728-1447972285568373 Mesa Dr, Seattle, WA, 981000.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130084ENRBobby T Powell1941-09-10UHC-35845-0957864881154683 Camelback Rd, Sacramento, CA0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129886ENRYuki F Butler1940-05-28UHC-90674-9940895363018684 Jefferson Ave, San Diego, CA, 921330.62Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-113946ENRAdam Gonzales1951-10-22UHC-93372-2232288151709870 Forest Ave, San Diego, CA, 921350.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133579ENRAlexis Vasquez1968-08-12UHC-44563-4377192505886026 Ocean Ave, Chandler, AZ, 852410.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120702ENRBradley Guerrero1986-06-12UHC-50760-8995159491567868 Park Pl, Denver, CO, 802730.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118525ENRChristine D Santiago1966-11-12UHC-68644-8082869399323894 Highland Ave, Orlando, FL, 328990.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103752ENRAbigail Delgado1982-01-21UHC-12714-2970066750493553 Willow Ct, Gilbert, AZ, 852000.62Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-124797ENRWalter Robertson1981-06-24UHC-87465-3541467380527128 Lake View Rd, Austin, TX, 787800.62Name re-casedPhone reformattedCity re-casedState name converted to code+3 more
ENR-135667ENRKevin Wilson1960-09-02UHC-38865-8633827693282872 Willow Ct, Phoenix, AZ0.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
43,101 rows, page 144 of 863PreviousNext