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-136696ENRCaroln QJunk1976-01-16UHC-52262-4454374059572854 River Rd, Dallas, TX, 752350.54Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-111244ENRSusan Z Sims1958-07-18UHC-18790-4369227621342297 Elm St, Austin, TX, 787420.54Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised+1 more
ENR-137147ENRDoris Brooks1945-09-21UHC-60379-2975494803797254 Spring St, Dallas, TX, 752630.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-142723ENRRuth Jordan2005-02-16UHC-16459-44—6914 Sage Ct Apt 30, Sacramento, CA, 958940.54Name re-casedTwo-digit birth yearUnit split from streetGender normalised+1 more
ENR-126806ENRRonald P Espinoza1971-03-13UHC-53546-06—1715 Highland Ave, Gilbert, AZ, 852700.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-112892ENRJoseph Hernandez1973-03-03UHC-40659-34—4451 Canyon Rd, San Diego, CA, 921690.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-112891ENRJoseph Hernandez1973-03-03UHC-40659-34—4451 Canyon Rd, San Diego, CA, 921690.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-106838ENRDorothy A Gray1945-08-20UHC-28039-8779766347769607 Meadow Ln, Las Vegas, NV0.54Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-136140ENRBrian Patel1955-12-13UHC-11526-6984031116002765 Lincoln Way Apt 17, Charlotte, NC, 282000.54Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+1 more
ENR-103734ENRRandy Tucker1974-05-03UHC-77271-97—8420 Central Ave, Jacksonville, FL0.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-118759ENRAdam H Harper1995-09-18UHC-83331-37—2959 Mountain View Dr, Tempe, AZ, 852210.54Middle initial moved out of first nameTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-131551ENRKathryn Ross1957-08-13UHC-29384-1476756144676403 Mesa Dr Apt 4, Dallas, TX, 752580.54Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+1 more
ENR-116937ENRBenjamin Burns1986-12-06UHC-58662-4257549804617578 Harbor Blvd, Phoenix, AZ, 850700.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-133501ENRCharles Z Morales1996-07-06UHC-79311-87—1061 Mesa Dr, Charlotte, NC, 282440.54Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-128284ENRJerry F Chen1976-06-01UHC-02228-38—5860 Forest Ave, Denver, CO, 802250.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-138747ENRPamela J Welch1946-05-25UHC-09702-11—6696 Lake View Rd # 376, Tempe, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-141959ENRCheryl M Romero1981-03-12UHC-34011-4930460889106536 Highland Ave, Glendale, AZ, 853340.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
ENR-129819ENRAna Park1994-01-06UHC-18093-4355729070746822 Highland Ave, Scottsdale, AZ, 852310.54Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+1 more
ENR-108329ENRVirginia G Carter—UHC-07463-3384189849419246 Lake View Rd, Minneapolis, MN, 554850.54Date of birth unreadablePhone reformattedState name converted to codeZIP+4 trimmed+1 more
ENR-121057ENRTeresa Reyes1999-06-10UHC-34995-4031763481271268 Hillcrest Rd, Las Vegas, NV, 891010.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-112332ENRAlexis Z Armstrong1959-01-26UHC-76727-59—8444 Ridge Rd # 344, Fresno, CA, 937230.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-104554ENRAngela H Cooper1989-03-23UHC-93181-5924969751631514 Valley View Dr # 369, Houston, TX, 770570.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-111150ENRZachary Z Anderson1946-11-23UHC-40167-325077621452650 Mountain View Dr Apt 30, Los Angeles, CA, 900690.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-124012ENRMariana V Fowler1986-11-05UHC-92162-5332382119286958 Mountain View Dr, Scottsdale, AZ, 852920.54Name re-casedTwo-digit birth yearState name converted to codeEmail lower-cased+1 more
ENR-124790ENRAlbert Park1980-06-22UHC-07083-8364147149665831 Central Ave, Gilbert, AZ, 852200.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
ENR-116574ENRMary X Vega1986-12-03UHC-73241-9427735384697441 Jefferson Ave, Los Angeles, CA, 900590.54Name split from “Last, First”Phone reformattedSSN last four extractedCity re-cased+1 more
ENR-106236ENRJack Robertzon1995-07-17—65252592355819 Park Pl, Orlando, FL, 328650.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-118667ENRKelly Wells—UHC-80354-4883597040708309 Lake View Rd, Scottsdale, AZ0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-133062ENRBrittany X Carpenter1991-07-08UHC-31654-02—5440 Pine Dr, Austin, TX, 787710.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-119425ENRAhmed E Olson1964-06-22UHC-42356-9487966696962114 Bayshore Dr, San Diego, CA0.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-119972ENRFrances Lawsno1962-03-15UHC-98896-1131199752462728 Camelback Rd, Mesa, AZ, 852360.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-121657ENRBruce J Gray1977-11-28UHC-09823-6224621989272080 River Rd, Nashville, TN0.54Name split from “Last, First”ZIP missingEmail lower-casedGender normalised+1 more
ENR-103063ENRCarl O Morles1979-12-15UHC-86655-7960954665235098 Market St # 847, Orlando, FL, 328000.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-129764ENRArnold Gerald1960-12-28UHC-27129-1550262100582439 Oak St, Minneapolis, MN, 554470.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-101428ENRMartha T Padilla1940-01-26UHC-51567-5339022552983228 River Rd # 710, Tempe, AZ, 852020.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-119558ENRKenneth Fernandez1973-10-01UHC-00016-4791248944324810 Ridge Rd # 491, Mesa, AZ, 852860.54Two-digit birth yearPhone reformattedUnit split from streetZIP+4 trimmed+1 more
ENR-113688ENRBarbara H Peters1945-08-28UHC-20482-39—5311 Union St, Fresno, CA, 937690.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-138187ENRRalph Howard1940-12-26UHC-26532-6121545239179125 Apache Blvd Apt 31, Gilbert, AZ, 852500.54Name re-casedTwo-digit birth yearSSN last four extractedUnit split from street+1 more
ENR-139309ENRRyan Willis1951-07-07UHC-67623-0422025785445630 Maple Ave, Jacksonville, FL, 322490.54Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-104057ENRHannah M Aguilar1973-09-23UHC-74882-4176379767945872 Harbor Blvd, Minneapolis, MN, 554020.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-103966ENRDennis Clark1959-08-01UHC-72319-7880897422951277 Indian School Rd, Fresno, CA, 937310.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-113996ENRJoan J Simpson—UHC-14290-0947233572611841 Palm Dr, Glendale, AZ, 853450.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-114455ENRNancy J Day—UHC-45854-2121248885707061 Jefferson Ave, Columbus, OH, 432950.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-118468ENRCarol I Gardner—UHC-82456-8750890130892681 Washington St, Tampa, FL, 336670.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-140703ENRAmanda Andrews1971-10-25UHC-57948-9573750281487758 Central Ave, Chandler, AZ0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-140702ENRAmanda Andrews1971-10-25UHC-57948-9573750281487758 Central Ave, Chandler, AZ0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-142465ENRAmy M Powell1969-10-25UHC-60786-0677753883364435 Apache Blvd, Houston, TX, 770200.54Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-119487ENRIsabella Burton1980-11-25UHC-09055-5079385881033009 Apache Blvd, Tempe, AZ, 852380.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-126571ENRSharon Woods2002-07-05UHC-33271-3678424775706811 Lake View Rd, Plano, TX0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-135668ENRKein X Wilson1960-09-02UHC-38865-86—2872 Willow Ct, Phoenix, AZ, 850950.54Middle initial moved out of first nameStreet suffix standardisedAddress re-casedGender normalised+1 more
43,101 rows, page 106 of 863PreviousNext