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-111713 | ENR | Michelle Bowman | 1947-11-06 | UHC-20763-80 | 3252942988 | 8737 Ridge Rd, Austin, TX, 78747 | 0.46 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-132289 | ENR | Tyler Broosk | 1994-09-10 | UHC-33688-95 | 6848392067 | 8696 Grand Ave, Charlotte, NC, 28262 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-124097 | ENR | Emily Boyd | 1998-06-24 | UHC-29831-34 | — | 547 Willow Ct, Tucson, AZ | 0.46 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more |
| ENR-142920 | ENR | Pamela Gibson | 1970-11-19 | UHC-30740-55 | 3713686572 | 4351 Hillcrest Rd, Glendale, AZ | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-126744 | ENR | Melissa Ramos | 2002-06-10 | UHC-99031-01 | 8763769108 | 7751 Bayshore Dr, Chandler, AZ, 85233 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-101232 | ENR | John Z Taylor | 1971-08-28 | UHC-19378-10 | 4673857651 | 8613 Washington St, Atlanta, GA, 30374 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-117366 | ENR | Martin Philip | 1959-12-27 | UHC-41017-34 | 2937186556 | 8416 Jefferson Ave, Jacksonville, FL, 32266 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more |
| ENR-125200 | ENR | Jason B Garrett | 1947-05-05 | UHC-10837-58 | 8519954500 | 3428 Highland Ave, Austin, TX, 78767 | 0.46 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-129857 | ENR | Emily E Obrien | 2007-07-06 | UHC-25966-27 | 3733177257 | 3702 Elm St, Los Angeles, CA, 90067 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-117239 | ENR | Sarah S Hansen | 1960-08-17 | UHC-44827-08 | — | 4346 Cedar Ln, Las Vegas, NV, 89184 | 0.46 | Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+5 more |
| ENR-141812 | ENR | Arthur I Simpson | 1989-03-06 | UHC-42939-64 | 9104017402 | 7971 Indian School Rd, Dallas, TX, 75222 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-108541 | ENR | Jordan L Cole | 1979-11-01 | UHC-83214-78 | 5794394335 | 4226 Spring St, Minneapolis, MN, 55459 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-129620 | ENR | Patrick Castro | 2008-08-26 | UHC-51479-94 | 6542298143 | 1268 Washington St # 711, Fresno, CA, 93735 | 0.46 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-101300 | ENR | Diane I Washington | 1971-08-01 | UHC-22655-79 | 2037679231 | 6998 Bayshore Dr Apt 12, Plano, TX, 75068 | 0.46 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+5 more |
| ENR-142291 | ENR | Carl Q McCoy | — | UHC-91013-94 | 6098298021 | 6685 Sunset Blvd, Austin, TX, 78784 | 0.46 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more |
| ENR-103053 | ENR | Aisha O Hanson | 1946-05-24 | UHC-09335-84 | 7092804776 | 573 Bayshore Dr, Las Vegas, NV, 89119 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-102644 | ENR | Benjamin T Johnston | 1948-02-17 | UHC-90631-95 | 4976145415 | 5939 Cedar Ln, Orlando, FL | 0.46 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more |
| ENR-111388 | ENR | Lori F Dominguez | 2000-09-04 | UHC-82440-56 | 9458088602 | 730 Sage Ct, Miami, FL | 0.46 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+5 more |
| ENR-127101 | ENR | Nicholas Clark | 1963-11-09 | UHC-59054-98 | 5335782541 | 7847 Highland Ave, San Diego, CA | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-119007 | ENR | Donna Jacobs | 1980-04-28 | UHC-93706-58 | 2157237645 | 1474 Hillcrest Rd Apt 37, Gilbert, AZ, 85224 | 0.46 | Name re-casedPhone reformattedSSN last four extractedUnit split from street+5 more |
| ENR-133600 | ENR | Daniel A Ortiz | 2005-03-05 | UHC-04338-14 | 8989372565 | 6892 Mesa Dr, Gilbert, AZ, 85208 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-132828 | ENR | Joshua Gray | 1994-04-12 | UHC-40679-05 | 8249883339 | 1373 Lincoln Way # 696, Sacramento, CA, 95872 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more |
| ENR-130831 | ENR | Mary L Reed | 1962-05-05 | UHC-27530-28 | 2619382756 | 1552 Jefferson Ave Apt 28, San Diego, CA, 92185 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-103847 | ENR | Kimberly A Butler | 1938-02-21 | UHC-78911-70 | 5695767545 | 8151 Mesa Dr Apt 15, Seattle, WA, 98180 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-131212 | ENR | Samantha Y Delgado | 1956-05-27 | UHC-63618-43 | 5457180927 | 2868 Apache Blvd, Scottsdale, AZ | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-119280 | ENR | Brittany N Harveey | 1969-03-05 | UHC-61789-32 | 4628849703 | 862 Willow Ct, Tempe, AZ | 0.46 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+5 more |
| ENR-133819 | ENR | Michelle Brooks | 2000-08-08 | UHC-54189-80 | 2373108361 | 3193 Bayshore Dr Apt 27, Tempe, AZ, 85225 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-102682 | ENR | Charlotte B Smith | 1992-12-17 | UHC-45559-79 | 5667796574 | 2953 Cedar Ln, Tampa, FL, 33699 | 0.46 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-128578 | ENR | Carolyn M Santiago | 2007-03-10 | UHC-51828-36 | 2826262585 | 4033 Hillcrest Rd, Phoenix, AZ, 85083 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-126742 | ENR | Mason P Foster | 1975-03-14 | UHC-91690-75 | 4662759937 | 3701 Harbor Blvd # 266, Nashville, TN | 0.46 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more |
| ENR-104898 | ENR | Mason Kelley | 1984-11-26 | UHC-62790-81 | 6316006027 | 7795 Harbor Blvd, Austin, TX, 78768 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-125661 | ENR | Elizabeth M Maldonado | 1986-04-01 | UHC-49167-25 | 5893508348 | 3871 Park Pl Apt 40, Charlotte, NC, 28277 | 0.46 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-121954 | ENR | Elijah J Torres | 1968-03-21 | UHC-90396-64 | 9883370211 | 7315 Church St, Eden Prairie, MN | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-114976 | ENR | Mateo Medina | 1950-03-15 | UHC-80796-72 | 7749530209 | 5639 Willow Ct, Sacramento, CA, 95805 | 0.46 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-114975 | ENR | Mateo Medina | 1950-03-15 | UHC-80796-72 | 7749530209 | 5639 Willow Ct, Sacramento, CA, 95805 | 0.46 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-101153 | ENR | Timothy Kelly | 1989-07-01 | UHC-36460-96 | 4893100129 | 2193 Mountain View Dr, Seattle, WA | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-101814 | ENR | Benjamin Harris | 1978-11-02 | UHC-55813-93 | 7414289056 | 1764 Mountain View Dr, Las Vegas, NV | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-132785 | ENR | Elijah X Williams | 1959-10-23 | UHC-93427-23 | 5933260049 | 6333 Harbor Blvd, Seattle, WA | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-120228 | ENR | Sofia Wilson | 2004-06-18 | UHC-06608-41 | 5902998121 | 3482 River Rd, San Diego, CA, 92138 | 0.46 | Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+5 more |
| ENR-111999 | ENR | Omar Carter | 1940-09-08 | UHC-59754-70 | 8698924762 | 6152 Camelback Rd, Seattle, WA, 98188 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-120956 | ENR | Judith Lucas | — | UHC-82017-35 | 4284050195 | 5675 Bayshore Dr # 815, Orlando, FL, 32894 | 0.46 | Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more |
| ENR-102408 | ENR | Cynthia I Wagner | 1967-01-07 | UHC-51467-91 | 3445432646 | 5775 Park Pl, Orlando, FL | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-116284 | ENR | Lauren Ford | 1955-06-13 | UHC-21692-03 | 8807802695 | 51 Union St, Minneapolis, MN, 55402 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-127875 | ENR | Mike Simmons | 1978-04-13 | UHC-43803-76 | 7855554793 | 7323 Park Pl, Dallas, TX, 75206 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-117210 | ENR | Kenneth S Perkins | 2003-07-24 | UHC-16787-95 | 3046370785 | 4677 Valley View Dr, Scottsdale, AZ, 85266 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more |
| ENR-116715 | ENR | Cheryl Carr | 1953-08-27 | — | 2346211532 | 1857 Valley View Dr, Scottsdale, AZ | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-118126 | ENR | Gloria Tran | 1999-12-15 | UHC-60806-43 | — | 5239 River Rd, Sacramento, CA, 95844 | 0.46 | Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-115512 | ENR | Arjun Davis | 1957-09-09 | UHC-79014-99 | 5769585063 | 6398 Union St, Denver, CO, 80281 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-137533 | ENR | Diego Ford | — | UHC-42855-52 | 7705262408 | 3131 Apache Blvd, Tempe, AZ, 85271 | 0.46 | Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more |
| ENR-140551 | ENR | Scott V Turner | 1951-05-21 | UHC-29656-32 | 4345839565 | 3002 Lake View Rd Apt 35, Tampa, FL, 33668 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |