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.
- Placeholder values cleared71,257Placeholder tokens such as NULL, N/A, UNKNOWN or "-" treated as empty
- Whitespace trimmed57,061Leading or trailing whitespace removed from one or more fields
- Address re-cased56,490Street line re-cased and punctuation removed
- Street suffix standardised55,824Street suffix standardised to USPS abbreviation (Street to St, Avenue to Ave, and so on)
- Phone reformatted50,244Phone reduced to ten digits, punctuation and leading country code removed
- Name re-cased39,996Name letter-case rewritten to Title Case and stray characters removed
- Date of birth reformatted32,400Date of birth rewritten to ISO 8601 from a source format (MM/DD/YYYY, YYYYMMDD, Mon D, YYYY)
- City re-cased17,850City re-cased to Title Case
- Gender normalised16,828Gender mapped to F or M from a longer or variant value
- Email lower-cased11,635Email lower-cased
- Name split from “Last, First”9,980First-name field held "LAST, FIRST"; the two parts were split into their own fields
- State name converted to code9,084Full state name replaced by its two-letter USPS code
- ZIP+4 trimmed8,263ZIP+4 trimmed to the five-digit ZIP
- Member ID reformatted7,723Member ID re-hyphenated and upper-cased to the UHC-#####-## pattern
- ZIP missing7,146Street address present but no ZIP supplied
- Unit split from street6,994Apartment, suite or unit designator split from street line and re-appended in standard form
- Two-digit birth year6,661Date of birth carried a two-digit year; century inferred by pivot
- State code upper-cased4,010Two-letter state code upper-cased
- Plan code upper-cased3,278Plan code upper-cased
- SSN last four extracted2,817Last four digits of SSN extracted from a longer or punctuated value
- Date of birth unreadable2,274Date of birth did not match any known format or was out of range; cleared
- Phone missing area code2,021Phone had only seven digits (no area code); cleared
- Middle initial moved out of first name1,125A single middle initial was embedded in the first-name field and moved to middle name
- Date of birth missing990Date of birth absent or a null token; left empty
- No usable name (quarantined)505No usable last name; record quarantined as junk and excluded from matching
Normalised records
Enrollment, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| ENR-134734 | ENR | Bryan Matthews | 1988-07-28 | UHC-23750-61 | — | 8907 Harbor Blvd, Plano, TX, 75085 | 0.50 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-121735 | ENR | Valentina Cooper | 1984-09-18 | UHC-46542-88 | 2965939912 | 1898 Elm St, Mesa, AZ | 0.50 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-139266 | ENR | Danielle K Weaver | — | UHC-98676-06 | 6926129401 | 724 Palm Dr, Atlanta, GA | 0.50 | Name re-casedDate of birth missingCity re-casedZIP missing+3 more |
| ENR-114388 | ENR | Hiroshi B Harrison | 1948-04-27 | UHC-09174-09 | 5389243959 | 1277 Spring St, Fresno, CA, 93797 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-114040 | ENR | Brandon Q Armstrong | 1959-11-13 | UHC-84467-90 | — | 2641 Apache Blvd # 334, Denver, CO, 80281 | 0.50 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-115513 | ENR | Jeffrey Vazquez | 2007-06-12 | UHC-94739-65 | 5369495497 | 2458 Lincoln Way Apt 23, Houston, TX, 77061 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-127876 | ENR | Amber G Moreno | — | UHC-25618-80 | 3094850791 | 4874 Camelback Rd, Atlanta, GA, 30317 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-134056 | ENR | Jusitn I Rojas | 1950-01-27 | UHC-93944-47 | 4103007271 | 5377 Cedar Ln, Mesa, AZ, 85260 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-107350 | ENR | Jose B Lawrence | 1967-12-22 | UHC-16741-15 | 2338899604 | 9696 Valley View Dr, Atlanta, GA, 30300 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-104102 | ENR | Diego Daniels | 1953-10-13 | UHC-77752-86 | 2393579243 | 3198 Highland Ave, Eden Prairie, MN, 55357 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-117142 | ENR | Diana V Lane | 1940-04-01 | UHC-50137-28 | 7683704962 | 3196 Sunset Blvd, Eden Prairie, MN, 55378 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-118302 | ENR | Samuel V Padilla | 1955-10-19 | UHC-58277-73 | 3052714392 | 6345 Jefferson Ave, Minneapolis, MN, 55470 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-117757 | ENR | Keith Woods | 1954-03-22 | UHC-83597-46 | 2623073328 | 8189 River Rd # 524, Denver, CO, 80224 | 0.50 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-101385 | ENR | Anthony Sanchez | 1983-04-09 | UHC-43379-66 | 8755378938 | 8793 River Rd, Chandler, AZ, 85294 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-124775 | ENR | Ahmed Kim | 2004-08-23 | — | 7537218219 | 4911 Forest Ave # 468, Nashville, TN, 37298 | 0.50 | Name re-casedPhone reformattedUnit split from streetState name converted to code+3 more |
| ENR-118987 | ENR | Mei B Bradley | — | UHC-98883-33 | 9696536131 | 3322 Palm Dr, Denver, CO | 0.50 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-131939 | ENR | Julia Maldonado | 1985-02-06 | UHC-81622-15 | — | 2094 Bayshore Dr, Nashville, TN, 37212 | 0.50 | Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+3 more |
| ENR-122718 | ENR | Joyce Santiago | 2000-08-25 | UHC-78000-99 | 2348295751 | 832 Highland Ave # 934, Los Angeles, CA, 90008 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-137332 | ENR | Martha Henderson | 1970-11-08 | UHC-50518-63 | 2108341055 | 4102 Forest Ave, Chandler, AZ | 0.50 | Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more |
| ENR-139174 | ENR | Luis Y Stevens | 2002-07-18 | UHC-41015-83 | — | 7599 Grand Ave, Sacramento, CA, 95850 | 0.50 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100180 | ENR | Gabriel U Olson | 1967-05-06 | UHC-29339-51 | 2349179907 | 2526 Ridge Rd, Eden Prairie, MN | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-136804 | ENR | Janice Hamilton | 1977-02-23 | UHC-98453-76 | 3966720156 | 6541 Cedar Ln, Las Vegas, NV, 89137 | 0.50 | Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-129708 | ENR | Hannah White | 1953-06-08 | UHC-97230-82 | 8913079627 | 4277 Palm Dr, Eden Prairie, MN, 55368 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-117590 | ENR | Evelyn Y Reyes | 1999-09-05 | UHC-54787-27 | 6927560326 | 48 Mountain View Dr, Los Angeles, CA, 90035 | 0.50 | Middle initial moved out of first nameName re-casedDate of birth reformattedSSN last four extracted+3 more |
| ENR-137045 | ENR | Alice Cruz | 1939-01-08 | UHC-28830-68 | 4732383423 | 4350 Meadow Ln, Houston, TX, 77029 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-129239 | ENR | John F Espinoza | 1999-03-28 | UHC-35989-44 | 9273232632 | 2404 Elm St, Denver, CO, 80280 | 0.50 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-111958 | ENR | Larry V Smith | 1953-11-11 | UHC-68077-82 | 6647007187 | 1043 Park Pl Apt 30, Las Vegas, NV, 89107 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-108201 | ENR | Mariana B Luna | 1950-08-20 | UHC-89166-28 | — | 8589 Sage Ct Apt 14, Austin, TX, 78723 | 0.50 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-113228 | ENR | Amber Hamilton | 1974-09-16 | UHC-67162-01 | 8722277065 | 6618 Maple Ave, San Diego, CA, 92172 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-124193 | ENR | Ruth Harrison | 2005-09-04 | UHC-44564-95 | 3593136335 | 7712 Lake View Rd # 642, Orlando, FL, 32849 | 0.50 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-134772 | ENR | Zachary G Delgado | 1993-04-17 | UHC-61679-39 | 9088226788 | 305 Elm St, Las Vegas, NV, 89168 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+3 more |
| ENR-129739 | ENR | Brandon V Park | 1974-03-06 | UHC-98562-48 | 9232995936 | 6348 Ocean Ave, Houston, TX, 77034 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more |
| ENR-104355 | ENR | Shirley M Hanson | 2007-03-04 | — | 9573103311 | 1453 Camelback Rd, Tucson, AZ, 85781 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-119348 | ENR | Mason U Pierce | 1970-10-14 | UHC-14486-45 | 7584183726 | 5979 Maple Ave, San Antonio, TX, 78271 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100773 | ENR | Don H Morris | 1942-04-15 | UHC-50338-69 | — | 8022 Elm St, San Antonio, TX | 0.50 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-123494 | ENR | Beverly Romero | 1963-02-22 | UHC-08319-07 | 6784132451 | 7088 Ocean Ave, Miami, FL, 33182 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-134303 | ENR | Abigaail Nguyen | 1983-08-14 | UHC-73153-32 | 8667394037 | 293 Harbor Blvd, Phoenix, AZ, 85090 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-133929 | ENR | Tyler E Warren | 1998-12-20 | UHC-28073-33 | 7445982860 | 1338 Grand Ave, Chandler, AZ, 85241 | 0.50 | Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+3 more |
| ENR-141405 | ENR | Melissa Dominguez | 1955-10-15 | UHC-07165-11 | 9855304738 | 953 Baseline Rd, Sacramento, CA, 95839 | 0.50 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-106093 | ENR | Yuki Burns | 1954-07-12 | UHC-79691-46 | 2648057026 | 1160 Jefferson Ave # 442, Austin, TX, 78703 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-134372 | ENR | Stephanie Singh | 1974-07-10 | UHC-26939-03 | 5383449865 | 3553 Ocean Ave, San Diego, CA, 92157 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-129724 | ENR | Robert Q Torres | 1954-09-05 | UHC-04834-05 | 5023469011 | 5873 Lake View Rd # 793, Chandler, AZ, 85254 | 0.50 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-139195 | ENR | Edward E Davis | 1969-12-02 | UHC-71730-05 | 2215709716 | 3287 River Rd # 623, Sacramento, CA | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-105665 | ENR | George V Crewford | 1976-11-08 | UHC-99216-35 | 7729035825 | 5515 Park Pl Apt 30, Los Angeles, CA, 90050 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-130309 | ENR | Carolyn Butler | 1996-09-24 | UHC-60274-91 | 3125361293 | 116 Meadow Ln Apt 3, Denver, CO, 80250 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-129456 | ENR | Dorothy Wood | 1950-05-01 | UHC-31545-27 | — | 7288 Mesa Dr, Jacksonville, FL, 32293 | 0.50 | Member ID reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-142717 | ENR | Doris McDonald | 1977-06-19 | UHC-00910-81 | 5318250759 | 566 Church St, Chandler, AZ, 85203 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-105013 | ENR | Kathryn Z Edwards | 1960-06-06 | UHC-87671-76 | 5299504613 | 4681 Ocean Ave, Atlanta, GA, 30382 | 0.50 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-107926 | ENR | Priya Harvey | 1989-08-15 | UHC-41050-47 | 5982611718 | 3080 Apache Blvd Apt 31, Dallas, TX | 0.50 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-137577 | ENR | Gabriel G Riley | 1973-07-26 | UHC-30685-65 | 7886189483 | 7975 Washington St, Miami, FL, 33140 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |