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-115274 | ENR | Andrea A Espinoza | 1995-10-20 | UHC-38500-61 | 8248033190 | 4990 Church St Apt 14, Eden Prairie, MN, 55312 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-142613 | ENR | Douglas L Lucas | 1944-09-12 | UHC-56127-37 | 7837058963 | 2791 Forest Ave Apt 37, Las Vegas, NV, 89177 | 0.50 | Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-126444 | ENR | Donna Z Mitchell | 1966-06-07 | UHC-43058-43 | 2985896706 | 723 Camelback Rd, Chandler, AZ | 0.50 | Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-139273 | ENR | Lawrence D Rojas | 1948-07-10 | UHC-94431-48 | 4986509324 | 856 Church St, Orlando, FL, 32849 | 0.50 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-111394 | ENR | Anthony OJunk | 1950-11-25 | UHC-06142-47 | 5693413886 | 7510 Camelback Rd, Dallas, TX | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-130226 | ENR | Mychelle Gordon | 1948-04-16 | UHC-80137-39 | — | 470 Valley View Dr, Houston, TX, 77049 | 0.50 | Name split from “Last, First”Phone missing area codeMember ID reformattedStreet suffix standardised+3 more |
| ENR-135944 | ENR | Christian Holmes | 1951-08-01 | UHC-55279-98 | 5494875285 | 4067 Highland Ave Apt 4, Minneapolis, MN, 55474 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-128320 | ENR | Emily A Wagner | 1940-01-05 | UHC-20500-13 | 8417400837 | 956 Pine Dr, Glendale, AZ, 85307 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-138354 | ENR | Julie N Gray | 1940-07-17 | — | — | 9882 Hillcrest Rd, Miami, FL, 33143 | 0.50 | Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more |
| ENR-114254 | ENR | Amy Soto | 1985-05-18 | UHC-23381-51 | 8316648487 | 4411 Sunset Blvd, Minneapolis, MN, 55473 | 0.50 | Two-digit birth yearPhone reformattedMember ID reformattedSSN last four extracted+3 more |
| ENR-142567 | ENR | Christina P Williamson | 1977-02-26 | UHC-18331-38 | 3272371218 | 2552 Apache Blvd, Minneapolis, MN, 55422 | 0.50 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-118158 | ENR | Amber R Delgado | 2007-09-14 | UHC-82226-03 | 8828146582 | 4846 Market St # 531, Chandler, AZ, 85241 | 0.50 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-125561 | ENR | —Junk | 1969-12-14 | UHC-90454-50 | 4217133568 | 6083 Sage Ct, Glendale, AZ, 85320 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-100625 | ENR | Jason Rios | 1953-06-27 | UHC-49359-36 | 3934390535 | 5658 Pine Dr # 434, Jacksonville, FL, 32263 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-134744 | ENR | Kathleen M Miller | 1944-10-03 | UHC-61179-15 | 6466973331 | 6044 Sage Ct Apt 14, Sacramento, CA, 95834 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-117793 | ENR | Ahmed Hayees | 1995-10-01 | UHC-59600-25 | 2407723846 | 1557 Baseline Rd, Fresno, CA, 93702 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123129 | ENR | Barbara Roberts | 1972-10-05 | UHC-93612-27 | — | 9857 Oak St Apt 25, Denver, CO, 80215 | 0.50 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-115741 | ENR | Sophia S Vasquez | 1947-12-15 | UHC-21463-60 | — | 5478 Canyon Rd Apt 20, Tucson, AZ, 85761 | 0.50 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-142067 | ENR | Timothy Nguyne | 1947-08-09 | UHC-94509-48 | 3913894004 | 4564 Park Pl Apt 28, Charlotte, NC, 28213 | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-115556 | ENR | Andrew Fernandez | 1948-06-26 | UHC-04193-01 | 9685099716 | 9020 Valley View Dr, Seattle, WA, 98169 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-132696 | ENR | Kelly F Burton | 1980-10-12 | UHC-06398-61 | — | 9072 Park Pl, Dallas, TX, 75217 | 0.50 | Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+3 more |
| ENR-109749 | ENR | Patricia J Kelly | 1949-02-05 | UHC-46633-41 | 8254182993 | 3338 Ocean Ave, Sacramento, CA, 95804 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112218 | ENR | Stephanie Nelson | — | UHC-79058-71 | — | 3566 Canyon Rd, Las Vegas, NV, 89191 | 0.50 | Name re-casedDate of birth reformattedDate of birth unreadablePhone missing area code+3 more |
| ENR-100753 | ENR | Frances R Wilson | — | UHC-38544-97 | 3555813364 | 9472 Willow Ct, Mesa, AZ | 0.50 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-124105 | ENR | Camila R Mendoza | 1965-10-05 | UHC-35550-94 | 8897657384 | 7918 Oak St, Seattle, WA, 98146 | 0.50 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-103188 | ENR | Mary Allen | 1974-10-02 | UHC-94733-16 | 9436077668 | 4111 Grand Ave # 837, Eden Prairie, MN, 55368 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-137061 | ENR | Henry N Peters | 1977-01-18 | UHC-77157-46 | 2056791812 | 9756 Desert Sky Blvd, Eden Prairie, MN, 55387 | 0.50 | Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-102713 | ENR | Isabella CJunk | 2002-03-04 | UHC-51969-60 | 5953278160 | 5677 Sunset Blvd Apt 38, Los Angeles, CA, 90082 | 0.50 | Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-123733 | ENR | Jess Morris | 1978-02-12 | UHC-05205-94 | 7479409565 | 9584 Apache Blvd, Charlotte, NC, 28233 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-103585 | ENR | Angela O Li | 1983-11-13 | UHC-73845-11 | 8304998351 | 210 Cedar Ln Apt 9, Denver, CO, 80294 | 0.50 | Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-136032 | ENR | Matthew H Burns | 1976-12-19 | UHC-41296-63 | 9458261763 | 6941 Pine Dr # 520, Tucson, AZ, 85753 | 0.50 | Name split from “Last, First”Middle initial moved out of first namePhone reformattedUnit split from street+3 more |
| ENR-110624 | ENR | Kimberly K Murphy | — | UHC-02279-39 | 7844893230 | 973 Canyon Rd, Glendale, AZ, 85300 | 0.50 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135416 | ENR | Samantha Z Burke | 2000-08-27 | UHC-94001-94 | 7822754763 | 8709 Lincoln Way # 146, Minneapolis, MN, 55404 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-118782 | ENR | Amy Castro | 1983-12-12 | UHC-26944-46 | 2542522709 | 4080 Canyon Rd, Mesa, AZ | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110683 | ENR | Zachary Harvey | 2004-08-10 | UHC-58981-28 | 8426107239 | 8928 Apache Blvd, Tempe, AZ, 85239 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-127564 | ENR | Deborah Barnes | 1995-03-09 | UHC-31108-31 | 5534112107 | 8022 Hillcrest Rd, Minneapolis, MN, 55460 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-137139 | ENR | James Johnson | 1955-03-03 | UHC-45826-69 | — | 4782 Main St, San Antonio, TX, 78236 | 0.50 | Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| ENR-113564 | ENR | Carl K Payne | 1955-10-25 | UHC-04139-14 | — | 3575 Willow Ct, Los Angeles, CA, 90052 | 0.50 | Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| ENR-103376 | ENR | Bryan Yang | 1961-08-06 | UHC-24123-48 | 3359830323 | 8243 Market St Apt 9, Sacramento, CA, 95850 | 0.50 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-130924 | ENR | Doris X Torres | 1988-08-17 | UHC-69907-96 | 5243911523 | 7807 Sunset Blvd, Phoenix, AZ | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-143091 | ENR | Jacob V Murray | 1995-11-28 | UHC-20446-37 | 2334764546 | 1235 Highland Ave # 328, Tucson, AZ, 85747 | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-136498 | ENR | Anthony Myers | 1978-05-08 | UHC-74006-37 | 3422405515 | 4764 Sunset Blvd # 930, Eden Prairie, MN, 55334 | 0.50 | Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more |
| ENR-106744 | ENR | Robert K Boyd | 2003-05-28 | UHC-91770-26 | 5149606448 | 9733 Highland Ave # 625, Miami, FL, 33168 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-115948 | ENR | Hannah Lawrence | 1956-04-21 | UHC-97630-84 | 4479370295 | 1116 Desert Sky Blvd, Mesa, AZ, 85294 | 0.50 | Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-130422 | ENR | Michelle Mendez | 1967-12-20 | UHC-48161-41 | — | 1553 Hillcrest Rd, Sacramento, CA, 95820 | 0.50 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-125696 | ENR | Nicole P Luna | 2006-03-22 | UHC-74735-63 | 4303691195 | 9760 Washington St, Tempe, AZ, 85256 | 0.50 | Middle initial moved out of first namePhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-123745 | ENR | Dorothy Austin | 1949-11-11 | UHC-48631-14 | 4625337469 | 8657 Oak St, Los Angeles, CA, 90068 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-140898 | ENR | Raymond C Lee | — | UHC-27065-55 | 3746831024 | 2487 River Rd, Las Vegas, NV, 89171 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedCity re-cased+3 more |
| ENR-140899 | ENR | Raymond C Lee | — | UHC-27065-55 | 3746831024 | 2487 River Rd, Las Vegas, NV, 89171 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedCity re-cased+3 more |
| ENR-114172 | ENR | Jacob Lucas | 1981-01-16 | UHC-13277-60 | — | 4313 Desert Sky Blvd, Columbus, OH, 43211 | 0.50 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |