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-129428 | ENR | Brittany Vasquez | — | UHC-60118-16 | 5602418709 | 8014 Baseline Rd, Tampa, FL, 33684 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-120136 | ENR | Danielle L Banks | 1942-10-19 | UHC-15373-58 | 7158864057 | 38 Forest Ave, Los Angeles, CA | 0.60 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-127979 | ENR | Eugene T Spencer | 1980-09-06 | UHC-72821-85 | 7877832098 | 480 Bayshore Dr, San Antonio, TX, 78214 | 0.60 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-136244 | ENR | Zachary Fuller | 1969-07-13 | UHC-64893-75 | — | 3951 Market St, Eden Prairie, MN, 55323 | 0.60 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-103320 | ENR | Bryan B Estrada | 1939-02-12 | UHC-28517-49 | 4176645671 | 2929 Valley View Dr, Columbus, OH, 43238 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-122488 | ENR | Emily N Johnston | 1949-03-25 | UHC-39586-22 | 7746166825 | 6047 River Rd, Tempe, AZ, 85212 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-121212 | ENR | Nancy B Jones | 1950-05-18 | UHC-53125-95 | 9827185668 | 6297 Hillcrest Rd # 320, Las Vegas, NV, 89198 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-102393 | ENR | Hyroshi I Reynolds | 1965-06-21 | UHC-14204-71 | 3935296025 | 2054 Sunset Blvd Apt 28, Sacramento, CA, 95897 | 0.60 | Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-122734 | ENR | Judy H Kennedy | 1943-04-08 | UHC-53297-06 | 5222167917 | 4863 Park Pl Apt 39, Miami, FL, 33166 | 0.60 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-111057 | ENR | Denise Olson | 1951-05-11 | UHC-65886-44 | 2374533779 | 9865 Maple Ave, Phoenix, AZ, 85064 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-139482 | ENR | Valenttina Williams | 1982-09-21 | UHC-42568-28 | 9286512546 | 8185 Mesa Dr, Columbus, OH, 43287 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-138044 | ENR | Nancy Martin | 1947-07-28 | UHC-66350-74 | 8185449260 | 7326 Highland Ave, Tempe, AZ, 85243 | 0.60 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-135744 | ENR | Doris Ryan | 1981-08-24 | UHC-04166-33 | 3596909950 | 2666 Sage Ct, Minneapolis, MN | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-117329 | ENR | Susan Matthews | 1979-01-19 | UHC-95229-19 | 2013210863 | 9469 Ocean Ave, Charlotte, NC, 28232 | 0.60 | Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-115720 | ENR | Sofia Z Castillo | 1951-06-19 | UHC-61745-59 | 3193791070 | 2371 Willow Ct, Jacksonville, FL, 32241 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-106225 | ENR | Joshua V Brown | 1993-10-09 | UHC-57400-21 | 3207121797 | 509 Sunset Blvd, Tucson, AZ, 85751 | 0.60 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-139864 | ENR | Vincent J Simpson | 1982-02-19 | — | 7294211676 | 2192 Meadow Ln, Charlotte, NC, 28219 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-142499 | ENR | Amanda Yang | 1941-10-25 | UHC-99907-18 | 2575223460 | 1855 Baseline Rd, Mesa, AZ, 85237 | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-118785 | ENR | Valentina B Coleman | 1984-04-09 | — | 6408611472 | 5143 Market St, Nashville, TN, 37207 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-139298 | ENR | Jacob M Jordan | 1958-09-08 | UHC-33868-33 | 4216759993 | 5985 Lake View Rd, Miami, FL, 33131 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-109683 | ENR | Bobby Alexander | 2003-03-28 | UHC-39102-26 | 8218710887 | 711 Mountain View Dr, Tempe, AZ, 85242 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-140978 | ENR | Nicole Rojas | 1952-11-08 | UHC-59108-22 | 2383635206 | 5691 Market St, Jacksonville, FL, 32267 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-122107 | ENR | Kate Walsh | 1950-09-28 | UHC-91901-69 | 7788921266 | 356 River Rd, Charlotte, NC, 28254 | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-131912 | ENR | Jrery A Edwards | 1990-05-14 | UHC-51204-16 | 8338180022 | 922 Union St # 854, Atlanta, GA, 30387 | 0.60 | Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+4 more |
| ENR-112592 | ENR | Kelly Q Lucas | 1946-08-21 | UHC-43173-63 | — | 8042 Main St, Mesa, AZ, 85261 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-100973 | ENR | Edward V George | 1982-05-08 | UHC-76499-75 | 7873153198 | 9125 Apache Blvd # 424, Houston, TX, 77090 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-142313 | ENR | Priya U Burke | 1975-02-15 | UHC-37641-26 | 9566659500 | 1398 Ridge Rd, Chandler, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-142136 | ENR | Rachel O Vazuez | 1983-01-11 | UHC-21397-33 | 3859729498 | 7668 Central Ave, Atlanta, GA, 30327 | 0.60 | Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-102638 | ENR | Kimberly Vazquez | 1971-03-08 | UHC-88315-80 | 2569427753 | 866 Maple Ave, Nashville, TN, 37263 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-114578 | ENR | Gary Fisher | 1962-11-10 | UHC-83061-20 | — | 3740 Forest Ave, Dallas, TX, 75244 | 0.60 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-138686 | ENR | Gloria Lopez | 1942-12-10 | UHC-27080-04 | 6634113864 | 1893 Central Ave, Tempe, AZ, 85223 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-102121 | ENR | Pamela Gonzales | 1975-11-08 | UHC-32319-29 | 4529523413 | 9831 Main St, Mesa, AZ, 85280 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-141037 | ENR | Justin Porter | 2007-06-14 | UHC-18677-39 | 3287597952 | 8304 Jefferson Ave, Los Angeles, CA, 90014 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-102192 | ENR | Joe U Lynch | 1939-05-17 | UHC-56172-67 | 5612283948 | 3000 Lake View Rd, Fresno, CA, 93719 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-102291 | ENR | Omar Z Cruz | 1940-12-22 | UHC-43088-14 | — | 6656 Desert Sky Blvd, Fresno, CA, 93740 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-140271 | ENR | Mary Griffin | 1952-03-24 | UHC-26289-73 | 6288710948 | 3078 Grand Ave, Minneapolis, MN | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-135239 | ENR | Alexander H Stone | 2007-09-16 | UHC-33700-39 | 3637346496 | 6478 Sunset Blvd, San Diego, CA, 92119 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-119277 | ENR | Denise B Sanchez | 1994-11-02 | UHC-02390-99 | 3769388256 | 8771 Market St, Scottsdale, AZ, 85293 | 0.60 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-118102 | ENR | Valentina Green | 1972-08-04 | UHC-03315-16 | — | 7031 Jefferson Ave, Tucson, AZ, 85777 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-129664 | ENR | Timothy Rios | 1947-03-18 | UHC-68272-84 | 4115988712 | 8728 Sage Ct Apt 36, Miami, FL, 33123 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-114059 | ENR | Diana Reynolds | 1970-07-19 | UHC-32272-44 | 9379063652 | 6536 Lake View Rd, Fresno, CA, 93700 | 0.60 | Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-124411 | ENR | Evelyn Weber | 1997-01-23 | UHC-07516-18 | 4799553598 | 603 Mesa Dr, Los Angeles, CA, 90068 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-138855 | ENR | Dylan Davis | 2006-03-05 | UHC-30152-47 | 4057894702 | 6903 Forest Ave, Tampa, FL | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-115363 | ENR | Ralph U Arnold | 1951-08-10 | UHC-50091-38 | 7419684318 | 1384 Canyon Rd, Plano, TX, 75089 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-137435 | ENR | Nancy Miller | 1980-01-18 | UHC-71193-39 | 7974238421 | 1408 Central Ave, Charlotte, NC, 28268 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-132429 | ENR | Daniel Larson | 1993-07-09 | UHC-49984-06 | 6389552147 | 2456 Market St, Charlotte, NC, 28277 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-101367 | ENR | Deborah C Riso | 1949-06-20 | UHC-57911-73 | 2059064529 | 8210 Mountain View Dr, Las Vegas, NV, 89164 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-118700 | ENR | Henry Wells | 1994-05-08 | UHC-34465-23 | — | 7167 Highland Ave, Scottsdale, AZ, 85216 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-135923 | ENR | Russell E Murray | 1946-06-02 | UHC-60882-05 | — | 2644 Ridge Rd, Phoenix, AZ, 85034 | 0.60 | Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+4 more |
| ENR-137594 | ENR | Mason Arnold | 1955-06-19 | UHC-61970-31 | 6517860078 | 5848 Sage Ct, Fresno, CA, 93716 | 0.60 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |