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-136203 | ENR | Kyle D Berry | 1974-03-04 | UHC-50009-25 | 7483400614 | 8080 Jefferson Ave, Chandler, AZ, 85226 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-100149 | ENR | Ahmed W Stevens | — | UHC-43336-16 | 5772757750 | 7085 Union St, Denver, CO, 80231 | 0.60 | Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-122711 | ENR | Alice Z Lwson | 1982-03-08 | UHC-22496-68 | 4876929965 | 530 Apache Blvd, San Diego, CA, 92114 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-106559 | ENR | Mateo Snyder | 1989-11-28 | UHC-54482-18 | 4754001025 | 7631 Apache Blvd, Las Vegas, NV, 89157 | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-133260 | ENR | Dennis Daniels | 1972-02-10 | UHC-93018-85 | 8644685863 | 3114 Elm St, Houston, TX, 77041 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-129765 | ENR | Roger Bennett | 2000-03-02 | UHC-51537-03 | 2312656060 | 6308 Spring St, Austin, TX, 78757 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-141924 | ENR | Bardley F Padilla | 1942-06-09 | UHC-70138-17 | 5128902942 | 1085 Mountain View Dr, Fresno, CA, 93758 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-129053 | ENR | Emily Fuller | 1986-02-02 | UHC-95211-89 | 3443081489 | 5531 Baseline Rd, Tampa, FL, 33671 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-104597 | ENR | Gabriel D Lee | 1950-08-03 | UHC-80814-15 | 3437463422 | 6013 Camelback Rd, Denver, CO, 80248 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-104796 | ENR | Hiroshi Rliey | 1962-01-23 | UHC-80208-09 | 5592561161 | 8986 Washington St, Atlanta, GA, 30354 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-138856 | ENR | Dylan Ford | 1972-06-04 | UHC-15943-69 | 6816045407 | 5936 Union St, Dallas, TX, 75255 | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-138466 | ENR | Betty Wright | 1996-05-07 | UHC-97501-96 | 6076640120 | 6345 Desert Sky Blvd, Miami, FL | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-121029 | ENR | Wayne X Robertson | 1965-06-04 | UHC-05398-93 | 2534558038 | 7060 Hillcrest Rd, Nashville, TN, 37202 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-120883 | ENR | Doris Y Meyer | 1961-05-19 | UHC-49829-23 | 7512437439 | 1523 Lincoln Way, Columbus, OH, 43292 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-126978 | ENR | Bruce P Perkins | — | UHC-27600-51 | 3244923641 | 8366 Lake View Rd, Los Angeles, CA, 90048 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-140209 | ENR | Willie Soto | 2006-09-19 | UHC-53600-87 | 9745816681 | 8204 Central Ave, Scottsdale, AZ, 85249 | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-108383 | ENR | Wei Mejia | 1960-05-08 | UHC-25353-07 | — | 5907 Canyon Rd, Eden Prairie, MN, 55330 | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-104568 | ENR | Sam Z Bowman | 1945-07-09 | UHC-16338-08 | 6874062557 | 6349 Spring St, Gilbert, AZ, 85276 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-139761 | ENR | Jeremy Hunt | 1955-08-12 | UHC-59297-43 | 6122857965 | 4716 Sunset Blvd, Jacksonville, FL | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-125749 | ENR | Brittany Gardner | 2008-08-03 | UHC-64858-19 | 7005355219 | 7746 Grand Ave, Mesa, AZ, 85279 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-127621 | ENR | Evelyn X Gray | 1968-09-15 | UHC-85134-32 | 7259017365 | 5902 Canyon Rd, Denver, CO, 80284 | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-131436 | ENR | Ruth Z Fox | 1997-01-01 | UHC-51091-44 | 4542466460 | 339 Baseline Rd, Austin, TX, 78765 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-110218 | ENR | Sandra P Yang | 1961-10-20 | UHC-18320-22 | 3794997151 | 4320 Ridge Rd, Tampa, FL | 0.60 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-123231 | ENR | Carolyn E Campbell | 1950-02-15 | UHC-91732-23 | 8255973022 | 7292 Broadway, Denver, CO | 0.60 | Phone reformattedMember ID reformattedAddress re-casedCity re-cased+4 more |
| ENR-137024 | ENR | Jerry Dun | 1993-02-22 | UHC-45079-43 | 6789921657 | 5397 River Rd, Charlotte, NC, 28296 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-140758 | ENR | Janice Z Marshall | 1985-02-22 | UHC-38497-73 | 9058664819 | 5578 Bayshore Dr, Sacramento, CA, 95824 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-112238 | ENR | Kelly C West | — | UHC-89347-77 | 9192004346 | 7793 Main St, San Diego, CA, 92187 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-120538 | ENR | Martha Chen | 2005-12-04 | UHC-27434-02 | 2026775133 | 4460 Desert Sky Blvd, Eden Prairie, MN | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-127107 | ENR | Melissa Raed | 1984-05-20 | UHC-64718-84 | 3694919865 | 3282 Church St, Los Angeles, CA, 90047 | 0.60 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-133086 | ENR | Deborah X Owens | 1969-09-28 | UHC-36207-21 | 8542928872 | 7234 Highland Ave, Fresno, CA | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-104506 | ENR | Roger P Simmons | 1941-10-03 | UHC-17204-03 | 7784083784 | 2486 Highland Ave, Tempe, AZ, 85251 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-131308 | ENR | Bradley Mason | 1974-06-15 | UHC-79120-53 | 9364010738 | 1000 Ridge Rd Apt 28, San Diego, CA, 92152 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-140668 | ENR | Jonathan Simmons | 1988-05-11 | UHC-03464-95 | 7915150208 | 8022 Jefferson Ave # 194, Las Vegas, NV, 89194 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-142872 | ENR | Mei W McCoy | — | UHC-65566-67 | 7369226577 | 599 Lincoln Way, Gilbert, AZ, 85262 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-142330 | ENR | Danielle X Simpson | 1995-03-09 | UHC-91877-58 | — | 5969 Church St, Chandler, AZ, 85217 | 0.60 | Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+4 more |
| ENR-125875 | ENR | Natalie G Day | 1948-08-27 | UHC-79226-35 | 6486068126 | 6862 Sage Ct, Tempe, AZ, 85248 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-109909 | ENR | Bell Melissa | 1952-08-08 | UHC-91197-58 | 5804404043 | 4418 Canyon Rd # 223, Las Vegas, NV, 89170 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-113813 | ENR | Ann W Hudson | 1944-06-11 | UHC-45319-60 | 4872690160 | 1546 Highland Ave, Nashville, TN | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-110761 | ENR | Joan Ferguson | 2003-08-28 | UHC-48591-61 | 5585428466 | 7655 Union St, Glendale, AZ, 85392 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-128967 | ENR | Julie T Wilson | 1948-03-27 | UHC-63663-31 | 7046450516 | 9556 Ocean Ave, Minneapolis, MN, 55416 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-132844 | ENR | Diane W Wells | 1941-11-24 | UHC-04452-60 | 6145750929 | 754 Apache Blvd, San Diego, CA, 92119 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-132099 | ENR | Kimberly Austin | 1982-01-28 | UHC-04038-37 | 5946732869 | 1515 Maple Ave, Nashville, TN, 37291 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-113342 | ENR | Bruce Wason | 1956-10-01 | UHC-58660-37 | — | 8285 Ocean Ave, Mesa, AZ, 85289 | 0.60 | Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+4 more |
| ENR-109946 | ENR | Mike V Daniels | 1961-10-14 | UHC-40201-87 | 7277697198 | 4583 Valley View Dr, San Antonio, TX, 78222 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-119139 | ENR | Isabella A Sanchez | 1952-07-26 | UHC-07904-91 | 9575266463 | 3413 Valley View Dr, San Antonio, TX, 78284 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-129682 | ENR | Marcus Kleley | 1976-06-02 | UHC-47572-35 | 8613337771 | 6515 Elm St, Eden Prairie, MN, 55306 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-117593 | ENR | Kathleen Gutierrez | 2005-02-19 | UHC-47968-83 | 9312004744 | 8177 Palm Dr, Atlanta, GA, 30319 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-129039 | ENR | Santiago P Johnston | 1951-11-11 | UHC-65660-37 | 3096497686 | 2725 Washington St Apt 16, Chandler, AZ, 85284 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-129038 | ENR | Santiago P Johnston | 1951-11-11 | UHC-65660-37 | 3096497686 | 2725 Washington St Apt 16, Chandler, AZ, 85284 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-102374 | ENR | Jonathan O Rivera | 1992-08-01 | UHC-64480-79 | — | 728 Central Ave, Chandler, AZ, 85268 | 0.60 | Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more |