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-137784 | ENR | Ryan Washington | 1986-04-02 | UHC-71334-44 | 4432045515 | 7264 Lincoln Way, Glendale, AZ, 85361 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-110795 | ENR | Gregory Wang | 1960-03-23 | UHC-40108-70 | 7148345056 | 934 Ocean Ave # 558, Columbus, OH, 43248 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-105560 | ENR | Terry N Gray | 1939-08-14 | UHC-40056-35 | 6637867528 | 1181 Apache Blvd, Plano, TX, 75083 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-113073 | ENR | Gary Y Stewart | 1986-08-02 | UHC-91173-07 | 7799408466 | 4298 Main St Apt 27, Columbus, OH, 43209 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-131544 | ENR | Ana Harper | 1978-05-11 | UHC-01916-90 | 3689181999 | 3484 Ocean Ave, San Diego, CA, 92194 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-113754 | ENR | Cheryl Collins | 1992-04-14 | UHC-48515-83 | 4783251355 | 7644 Washington St, Phoenix, AZ, 85021 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-140230 | ENR | Julie S Miller | 1955-10-16 | UHC-57553-35 | 3925727898 | 2515 Elm St, Tucson, AZ, 85770 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123641 | ENR | Bradley Carroll | 1955-08-16 | UHC-36238-02 | 6414835406 | 3597 Union St, San Antonio, TX, 78288 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123495 | ENR | Bradley George | 1962-07-12 | UHC-69200-97 | 2703995001 | 7412 Maple Ave, Houston, TX, 77099 | 0.62 | Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+3 more |
| ENR-105094 | ENR | Janice Thompsn | 1946-04-25 | UHC-84391-77 | 9724900698 | 5739 Camelback Rd, Los Angeles, CA | 0.62 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-133058 | ENR | Bruce U Evans | — | UHC-11065-29 | 4119456514 | 2759 Spring St, Charlotte, NC, 28204 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-107495 | ENR | Michael Owens | 1940-08-19 | UHC-07421-16 | 4108483787 | 3292 Valley View Dr, Austin, TX, 78773 | 0.62 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-105566 | ENR | Austin Williamson | 1994-05-28 | UHC-58117-31 | 3649752513 | 6313 Bayshore Dr, Tempe, AZ, 85292 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-115414 | ENR | Wei R Robinson | — | UHC-00977-64 | 2025315396 | 5506 Desert Sky Blvd, Los Angeles, CA, 90005 | 0.62 | Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+3 more |
| ENR-122343 | ENR | Doris Garrett | 2002-02-22 | UHC-97274-60 | 7949669473 | 6241 Central Ave, Las Vegas, NV, 89119 | 0.62 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-134071 | ENR | Jonathan W Kim | 1958-06-08 | UHC-82911-62 | 4723140887 | 791 Maple Ave, Plano, TX, 75077 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-120992 | ENR | Billy M Fuller | 1961-03-05 | UHC-50232-64 | 2473987039 | 4442 Ocean Ave, Eden Prairie, MN, 55326 | 0.62 | Name split from “Last, First”Phone reformattedMember ID reformattedCity re-cased+3 more |
| ENR-103905 | ENR | Nancy S Vazquez | 1967-08-27 | UHC-61543-39 | 6555146171 | 4030 Maple Ave # 773, Scottsdale, AZ, 85207 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-117431 | ENR | Gabriel Garcia | 1949-10-24 | UHC-95145-59 | 3817068853 | 6830 Jefferson Ave, Glendale, AZ, 85388 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-115210 | ENR | Samantha Simmons | 1997-02-10 | UHC-59590-89 | 6204684948 | 1931 Mesa Dr, Glendale, AZ, 85369 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-134433 | ENR | Jose X Rodriguez | 1959-02-22 | UHC-57817-31 | 5067899538 | 5762 River Rd, Atlanta, GA, 30346 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-104081 | ENR | Andrea K Jimenez | 1972-03-10 | UHC-34741-89 | 5235113994 | 6052 Jefferson Ave, Seattle, WA | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-128556 | ENR | Daniel Brooks | 1987-01-01 | UHC-14086-28 | 7997001733 | 5261 Ridge Rd, Fresno, CA, 93749 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121734 | ENR | Noah K Mills | 1984-02-01 | UHC-03923-92 | — | 9545 River Rd, Nashville, TN | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-129780 | ENR | Theresa T Maldonado | — | UHC-45767-75 | 8065319468 | 6139 Elm St, Dallas, TX, 75293 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-114309 | ENR | Teresa R Payne | 1959-09-23 | UHC-81632-20 | 7242527163 | 6952 Grand Ave, Dallas, TX, 75229 | 0.62 | Name split from “Last, First”Phone reformattedState code upper-casedZIP+4 trimmed+3 more |
| ENR-139834 | ENR | Wayne Bryant | 1973-10-07 | UHC-92838-08 | 2753238938 | 3838 Hillcrest Rd, Mesa, AZ, 85255 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-136400 | ENR | Raymond D Black | 1939-11-09 | UHC-39408-66 | 8799405782 | 1444 Sage Ct, Chandler, AZ | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-115236 | ENR | Diane K Gomez | 1967-12-20 | UHC-59811-53 | 2844914092 | 86 Mountain View Dr Apt 6, Glendale, AZ, 85379 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-137268 | ENR | Joyce Q Murray | — | UHC-53509-33 | 4663273964 | 3758 Jefferson Ave, Tempe, AZ, 85206 | 0.62 | Name re-casedDate of birth unreadableMember ID reformattedStreet suffix standardised+3 more |
| ENR-132951 | ENR | Stephanie K Ramos | 1977-02-18 | UHC-12597-01 | — | 282 Highland Ave, Tampa, FL, 33605 | 0.62 | Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+3 more |
| ENR-130812 | ENR | Vincent McDonald | 1961-05-17 | UHC-27362-76 | 6439926131 | 620 Market St, Jacksonville, FL, 32215 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-108123 | ENR | Christian Hduson | 1982-04-04 | UHC-25514-58 | 4258402247 | 3963 Jefferson Ave, Denver, CO, 80255 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-112453 | ENR | Jess J Brooks | 1968-01-08 | UHC-63784-90 | 5462337236 | 5621 Elm St, Glendale, AZ, 85362 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135007 | ENR | Olivia S Jordan | 1940-11-13 | UHC-93774-50 | 6196589373 | 8570 Baseline Rd, Austin, TX, 78784 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-118762 | ENR | Ahmed I Jackson | 1980-07-21 | UHC-85837-40 | 9165798865 | 6354 Lincoln Way Apt 4, Eden Prairie, MN, 55395 | 0.62 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-107537 | ENR | Anthony X Fox | 1958-07-09 | UHC-20928-76 | 9792049229 | 3622 Desert Sky Blvd, Eden Prairie, MN, 55305 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedCity re-cased+3 more |
| ENR-134587 | ENR | Jessica Sims | 2004-08-08 | UHC-47302-21 | 8963773056 | 5344 Pine Dr, Los Angeles, CA, 90026 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-124116 | ENR | Ashley M Nelson | 1996-12-25 | UHC-79695-84 | 9554781769 | 417 Willow Ct, Seattle, WA, 98129 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121374 | ENR | Steven Young | 1950-05-13 | UHC-86416-81 | 6475189735 | 6301 Ocean Ave, Las Vegas, NV, 89102 | 0.62 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-140762 | ENR | Anthony N Kelly | 1984-03-20 | UHC-82253-79 | — | 1849 Hillcrest Rd Apt 40, Gilbert, AZ, 85208 | 0.62 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-125896 | ENR | Alan Z James | 1987-11-20 | UHC-59406-67 | 2489401140 | 6963 Ocean Ave, Plano, TX, 75042 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-115359 | ENR | Alexander L Cruz | 1960-08-28 | UHC-39381-75 | 5889121293 | 2134 Union St, Tampa, FL, 33639 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-107640 | ENR | Justin T Hawkins | 1943-07-02 | UHC-02231-81 | 3594992570 | 2459 Sunset Blvd # 482, Tucson, AZ, 85770 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-101461 | ENR | Jordan Welch | 2001-11-13 | UHC-43144-83 | 2712167241 | 2704 Maple Ave, Denver, CO, 80226 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-101460 | ENR | Jordan Welch | 2001-11-13 | UHC-43144-83 | 2712167241 | 2704 Maple Ave, Denver, CO, 80226 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-106642 | ENR | Rachel S Edwards | 1988-12-15 | UHC-16184-77 | 8277023194 | 9657 Union St, Minneapolis, MN, 55431 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100633 | ENR | Debra W Davis | 1986-02-13 | UHC-91305-53 | 8346478281 | 1252 Church St, Orlando, FL, 32862 | 0.62 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-138557 | ENR | Michelle Lynch | 1944-05-17 | UHC-79929-16 | 8346145726 | 7066 Central Ave, Jacksonville, FL, 32227 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-122536 | ENR | Jordan J Carr | 1977-09-07 | UHC-85213-42 | 2726532454 | 9856 Highland Ave, Chandler, AZ, 85219 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more |