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-109516 | ENR | Richard Q Santos | 1947-06-15 | UHC-94580-92 | 6904955430 | 7248 Main St, Mesa, AZ, 85217 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-137126 | ENR | Jonathan Z Kennedy | 1961-12-02 | UHC-96291-49 | — | 2767 Grand Ave, Tampa, FL, 33605 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-103869 | ENR | Jennifer Wood | 1995-03-05 | UHC-28217-72 | 3409560955 | 84 Union St, San Antonio, TX, 78269 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-140835 | ENR | Julia M Roberts | 1944-04-19 | UHC-00443-94 | 8448149697 | 5684 Mesa Dr, San Antonio, TX | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-129198 | ENR | Abigail F Gilbert | 1989-04-04 | UHC-55949-97 | — | 937 Canyon Rd, Orlando, FL, 32841 | 0.60 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more |
| ENR-119965 | ENR | Eugene Dean | 1980-11-04 | UHC-92457-43 | 7034043731 | 1663 Forest Ave, Sacramento, CA, 95876 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-120412 | ENR | Rebecca U Hart | 1962-03-15 | UHC-48738-18 | 4442893304 | 2012 Jefferson Ave, Dallas, TX, 75284 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-118327 | ENR | Cheryl Wells | 1996-05-23 | UHC-85133-15 | 7367526763 | 8038 Ocean Ave, Minneapolis, MN, 55460 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-118297 | ENR | Stephanie Holmes | 1987-09-26 | UHC-67717-30 | 5467464510 | 3877 Harbor Blvd, Scottsdale, AZ, 85212 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-102586 | ENR | Vincent Jimenez | — | UHC-80139-49 | 8059850483 | 6632 Sage Ct, Mesa, AZ, 85202 | 0.60 | Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more |
| ENR-139357 | ENR | Mateo Y Gardner | 1991-11-03 | UHC-88333-70 | 2283716017 | 2185 Market St, Minneapolis, MN, 55468 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-128776 | ENR | Linda I Thompson | 1987-09-14 | UHC-07643-47 | 4706434879 | 7853 Indian School Rd, Chandler, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-128147 | ENR | Ralph U Amrstrong | 1981-07-21 | UHC-24998-70 | 6455889547 | 8223 Pine Dr, Los Angeles, CA, 90077 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-120268 | ENR | Ann Perkins | 2005-06-21 | UHC-55959-65 | 7693610046 | 3947 Willow Ct, Nashville, TN | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-138615 | ENR | Mason Taylor | 2001-07-19 | UHC-83381-43 | 2767408425 | 1473 Bayshore Dr, Phoenix, AZ, 85093 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-124213 | ENR | Omar Park | 1975-11-13 | UHC-01183-85 | 4828045607 | 4331 Palm Dr, Gilbert, AZ, 85291 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-127777 | ENR | Andrew Bryant | 1951-01-06 | UHC-48874-47 | 3472467726 | 5644 Mountain View Dr, Scottsdale, AZ, 85262 | 0.60 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-122930 | ENR | Herny Wang | 1956-10-11 | UHC-73333-83 | 5465842721 | 9589 Forest Ave, Denver, CO | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-101032 | ENR | Hiroshi G Fullre | — | UHC-10742-92 | 8024769878 | 9186 Church St, Tampa, FL, 33680 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more |
| ENR-131209 | ENR | Nicole King | 1969-03-10 | UHC-75840-72 | 8848891767 | 6954 Pine Dr, Phoenix, AZ, 85091 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-138669 | ENR | Carol W Turner | 1988-06-04 | UHC-66102-25 | 8674376699 | 834 Highland Ave, Eden Prairie, MN, 55325 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-122767 | ENR | Christina D Sanchez | 2006-06-01 | UHC-05882-67 | 4455399844 | 28 Sunset Blvd, Houston, TX, 77052 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-129223 | ENR | Andrea L Wells | 1974-04-08 | UHC-09143-66 | 2962636283 | 1442 Highland Ave, Atlanta, GA, 30301 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-134239 | ENR | Dorothy Cook | 1982-07-23 | UHC-19060-90 | 8492320783 | 5326 Union St Apt 37, Minneapolis, MN, 55408 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-135215 | ENR | Ethan Wood | 1996-02-07 | UHC-49596-34 | 5045775803 | 7948 Main St, Charlotte, NC, 28249 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-120529 | ENR | Janet T Hoffman | 1977-04-21 | UHC-00217-94 | — | 9782 Valley View Dr, Dallas, TX, 75231 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+4 more |
| ENR-112008 | ENR | Maeo Armstrong | 1979-02-15 | UHC-54870-93 | 8868558811 | 1841 Bayshore Dr, Los Angeles, CA, 90069 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-116918 | ENR | Patty A Nguyen | 2005-03-23 | UHC-22321-64 | 7243578348 | 6015 Elm St, Fresno, CA, 93770 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-141833 | ENR | Lauren Jackson | 2004-04-04 | UHC-07467-12 | 8903456751 | 7895 Harbor Blvd, Houston, TX, 77066 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-132433 | ENR | Randy R Wallace | 1987-05-26 | UHC-72706-79 | 9032230751 | 415 Indian School Rd # 782, Mesa, AZ, 85296 | 0.60 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-142460 | ENR | Deborah N Chapman | 1938-10-27 | UHC-03542-11 | 2535724174 | 6636 Canyon Rd, Houston, TX, 77028 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-108706 | ENR | Randy I Lawrence | 1981-01-02 | UHC-90741-18 | 9258489130 | 8287 Highland Ave, Glendale, AZ | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-127968 | ENR | Lysa Z Pena | 1956-11-01 | — | 5952517329 | 4869 Elm St, Nashville, TN, 37288 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-136664 | ENR | Nancy Jaes | 1956-09-17 | UHC-08079-42 | 3142689346 | 6858 Sage Ct, Denver, CO, 80228 | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-130000 | ENR | Benjamin H Rozs | 1945-12-11 | UHC-24918-60 | 3618549079 | 8110 Spring St Apt 38, Denver, CO, 80295 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-142564 | ENR | Lawrence Porter | 1986-05-26 | UHC-43623-95 | 9002071179 | 4902 Camelback Rd, Miami, FL, 33145 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-104028 | ENR | Nicholas Mejia | 2003-02-11 | UHC-04504-31 | 8783376786 | 1116 Sage Ct, Miami, FL | 0.60 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+4 more |
| ENR-116091 | ENR | Ana K Gutierrez | 1950-06-21 | UHC-96937-07 | 7933649446 | 6563 Elm St, Los Angeles, CA | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-121528 | ENR | Timothy Y Aguilar | 1996-11-08 | UHC-28975-92 | 5002713314 | 1629 River Rd, Las Vegas, NV, 89123 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-127299 | ENR | Debra Cruz | 1962-01-28 | UHC-87928-93 | 3065357595 | 607 Palm Dr, Tucson, AZ, 85769 | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-112299 | ENR | Cynthia I Diaz | 2002-12-02 | UHC-72241-56 | 8586064607 | 4342 Baseline Rd, Denver, CO, 80274 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-128640 | ENR | Catherine Ford | 1977-12-27 | UHC-81203-91 | 9728980314 | 1919 Harbor Blvd, Sacramento, CA, 95809 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-132214 | ENR | Sharon Cunningham | 2003-10-05 | UHC-87424-59 | 9002823968 | 8900 Mountain View Dr, Minneapolis, MN | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-124275 | ENR | Judith Knight | 2002-06-07 | UHC-03688-34 | 9118876910 | 9778 Baseline Rd, San Antonio, TX, 78256 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-113989 | ENR | Gregory N Jenkins | 1983-02-07 | UHC-71141-97 | 6982512343 | 7418 Mountain View Dr, Columbus, OH, 43221 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-143009 | ENR | Nathan G Phillips | 1964-12-27 | UHC-35983-06 | 3976039810 | 3692 River Rd # 385, Jacksonville, FL, 32218 | 0.60 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-106927 | ENR | Sandra A Weber | 1963-07-13 | UHC-22732-27 | 7909447106 | 525 Canyon Rd, Mesa, AZ, 85278 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-122312 | ENR | Christopher Dixon | 1953-03-19 | UHC-08912-57 | 9877276689 | 2285 Highland Ave, Charlotte, NC, 28298 | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-109648 | ENR | Waye Jensen | — | UHC-95377-97 | 5025069613 | 7350 Bayshore Dr, Tampa, FL, 33600 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-115048 | ENR | Arthur George | 2000-07-02 | UHC-37062-38 | 4044005556 | 3309 Sunset Blvd, Las Vegas, NV, 89177 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |