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-120097ENRJanice L Griffin1987-03-13UHC-99964-10—3300 Desert Sky Blvd, Glendale, AZ, 853930.56Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased
ENR-120056ENRRandy Q Johnston1978-02-22UHC-32459-34—5415 Pine Dr, Tempe, AZ, 852970.56Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised
ENR-134331ENRJacqueline F Stewart1963-11-10UHC-38204-1322748087057018 Meadow Ln, Glendale, AZ, 853610.56Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code
ENR-128233ENRJames Murphy—UHC-37455-375333176302259 Lake View Rd, Minneapolis, MN, 554490.56Name split from “Last, First”Date of birth unreadableState name converted to codeWhitespace trimmed
ENR-108411ENRAngela J Marquez1950-05-12UHC-98892-4276148258354396 Maple Ave, Mesa, AZ, 852510.56Date of birth reformattedState name converted to codeZIP+4 trimmedGender normalised
ENR-128499ENRHenry Allen1971-08-01UHC-76663-03—8503 Pine Dr, Columbus, OH0.56Name split from “Last, First”Phone missing area codeZIP missingEmail lower-cased
ENR-114112ENRGloria A Lnua2000-10-22UHC-66011-868468266485104 Ocean Ave, San Antonio, TX, 782210.56Middle initial moved out of first nameState name converted to codeGender normalisedWhitespace trimmed
ENR-114111ENRGloria A Lnua2000-10-22UHC-66011-868468266485104 Ocean Ave, San Antonio, TX, 782210.56Middle initial moved out of first nameState name converted to codeGender normalisedWhitespace trimmed
ENR-122408ENRFJunk1958-08-17UHC-62486-6221140883978094 Market St, Chandler, AZ, 852370.56Street suffix standardisedAddress re-casedGender normalisedNo usable name (quarantined)
ENR-103486ENRAna King1986-08-02UHC-99079-6497343706925769 Lincoln Way, Dallas, TX, 752570.56Two-digit birth yearState name converted to codeGender normalisedWhitespace trimmed
ENR-114387ENRCarl U Ortega2004-02-20UHC-44602-19—6941 Ocean Ave, Houston, TX, 770950.56Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised
ENR-133378ENR—Junk1981-06-26UHC-89323-18—1295 Broadway, Minneapolis, MN, 554920.56Phone missing area codeAddress re-casedGender normalisedNo usable name (quarantined)
ENR-126472ENRLuis Cooper2003-08-19UHC-43368-7954073561183847 Maple Ave, San Diego, CA, 921390.56Name split from “Last, First”Two-digit birth yearState name converted to codeWhitespace trimmed
ENR-103259ENRLarry Powell1947-08-03UHC-73284-3823795848712276 Church St, Las Vegas, NV, 891060.56SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code
ENR-133070ENRPatrick O Reid—UHC-68801-8388136302985818 Lincoln Way, Phoenix, AZ, 850390.56Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased
ENR-122680ENRGeorge A Webb1956-10-25UHC-92154-9740896732818325 Park Pl, Dallas, TX, 752000.56Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-111849ENRSarah M Reynolds1992-08-21UHC-42163-6045285103526944 Washington St # 614, Los Angeles, CA, 900170.56Name split from “Last, First”Two-digit birth yearUnit split from streetWhitespace trimmed
ENR-120133ENRRalph K Thompson1943-08-18UHC-33872-4084624600017416 Elm St, Sacramento, CA, 958610.56Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased
ENR-111129ENRLarry Willis1967-01-25UHC-23228-9062692098779590 Oak St, Las Vegas, NV, 891050.56Name split from “Last, First”Two-digit birth yearPhone reformattedZIP+4 trimmed
ENR-104548ENRVincent Bell1981-05-27UHC-76478-5795320519866419 Lake View Rd, Seattle, WA, 981630.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-109954ENRJoe G Cole1985-08-07UHC-46172-6649891247737865 Maple Ave Apt 35, Gilbert, AZ, 852940.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-137579ENRCarlos Henry1980-07-13UHC-01106-0777039733821706 Jefferson Ave, Minneapolis, MN, 554190.56Phone reformattedState name converted to codeZIP+4 trimmedGender normalised
ENR-109296ENRMartha E Walker1970-07-15UHC-37027-9993682876118272 Washington St, Houston, TX, 770800.56Name split from “Last, First”Date of birth reformattedState name converted to codeZIP+4 trimmed
ENR-142986ENRJeremy W Fuller—UHC-03594-9997468924581341 Market St, Miami, FL, 331760.56Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised
ENR-115780ENRMegan N Griffin2002-12-19UHC-61856-7492425326444173 Canyon Rd Apt 13, Gilbert, AZ, 852230.56Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased
ENR-108035ENRLogan Y Thompson1942-05-19UHC-52807-7458929281236607 Park Pl, Las Vegas, NV0.56Two-digit birth yearPhone reformattedZIP missingGender normalised
ENR-101995ENRGlorai I Perry1954-11-27UHC-93729-3463834128764828 Apache Blvd, Tampa, FL, 336030.56Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more
ENR-121741ENRPatrick Pena2005-10-25UHC-91383-465034340464364 Oak St, Sacramento, CA, 958670.56SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised
ENR-129586ENRSara Garrett1938-10-03UHC-34288-69—114 Desert Sky Blvd, Los Angeles, CA, 900420.56Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised
ENR-139714ENRAlbert I Lynch—UHC-43210-65—3732 Sage Ct, Denver, CO, 802750.56Date of birth unreadableState name converted to codeZIP+4 trimmedPlaceholder values cleared
ENR-119783ENRBenjamin R Hunter—UHC-32263-4471191276187826 Willow Ct, Minneapolis, MN0.56Date of birth unreadablePhone reformattedZIP missingGender normalised
ENR-140764ENREmily Ford1977-10-26UHC-15465-6885070242661597 Meadow Ln, Chandler, AZ, 852230.56Street suffix standardisedAddress re-casedState name converted to codeGender normalised
ENR-131223ENRMartha M Dominguez1976-10-06UHC-73212-3132226328477973 Apache Blvd, Atlanta, GA0.56Member ID reformattedState name converted to codeZIP missingGender normalised
ENR-118460ENRJoseph V Porter1960-06-27UHC-81468-86—6037 Sage Ct, Gilbert, AZ0.56State name converted to codeZIP missingGender normalisedWhitespace trimmed
ENR-116390ENRDenise Daniels1958-09-09UHC-62235-28—6821 Meadow Ln, Dallas, TX, 752350.56Phone missing area codeSSN last four extractedGender normalisedPlaceholder values cleared
ENR-116154ENRJames E Watkins—UHC-32087-1957929202574317 Union St, Tucson, AZ0.56Date of birth missingState name converted to codeZIP missingPlaceholder values cleared
ENR-117331ENRAnan S Walsh1957-03-01UHC-93358-69—1738 Sunset Blvd # 498, Jacksonville, FL0.56Phone missing area codeUnit split from streetZIP missingWhitespace trimmed
ENR-127342ENROliviia Boyd1990-02-22UHC-64956-7349535558362665 Canyon Rd, Nashville, TN0.56Name split from “Last, First”Two-digit birth yearZIP missingWhitespace trimmed
ENR-112600ENRAndrew L Bennett1959-07-03UHC-25240-0834120373167139 Grand Ave, Denver, CO0.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-140660ENRDennis Mendez1934-04-26UHC-45203-64—1631 Canyon Rd, Phoenix, AZ, 850930.56Name re-casedPhone missing area codeState name converted to codeZIP+4 trimmed
ENR-131041ENREmily Y Hill2004-10-21UHC-56455-83—7166 Hillcrest Rd # 498, Denver, CO, 802130.56Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed
ENR-115792ENRMariaan G Riley1995-06-25UHC-27492-5327870189585620 Valley View Dr # 390, Gilbert, AZ, 852630.56Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code
ENR-109937ENRAlice I Murphy1967-09-28UHC-19582-4635188544516768 Baseline Rd, Tampa, FL, 336400.56Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-109938ENRAlice I Murphy1967-09-28UHC-19582-4635188544516768 Baseline Rd, Tampa, FL, 336400.56Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-125647ENROlivia B Dunn1956-09-23UHC-37209-7625051112447987 Central Ave, Columbus, OH, 432350.56Name split from “Last, First”Phone reformattedZIP+4 trimmedGender normalised
ENR-138873ENRJordan H Washingon1964-12-26UHC-77857-53—6428 Washington St, Atlanta, GA, 303360.56Phone missing area codeZIP+4 trimmedGender normalisedWhitespace trimmed
ENR-127284ENRCheryl A Owens1976-10-12UHC-97448-6346791410759579 Lincoln Way, Phoenix, AZ, 850220.56Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised
ENR-129149ENRHioshi U Schultz1978-07-23UHC-49624-39—2330 Palm Dr, Phoenix, AZ, 850790.56Phone missing area codeSSN last four extractedStreet suffix standardisedAddress re-cased
ENR-102131ENRTyler Adams1975-12-13UHC-88134-073333950487396 Baseline Rd, Chandler, AZ, 852970.56Street suffix standardisedAddress re-casedState name converted to codeGender normalised
ENR-141954ENREthan Stephens1980-08-04UHC-27099-2237095105339299 Forest Ave, Fresno, CA0.56Street suffix standardisedAddress re-casedZIP missingGender normalised
43,101 rows, page 111 of 863PreviousNext