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-103833 | ENR | Lauren Q Padilla | 1997-12-27 | UHC-93920-37 | 2656214212 | 1287 Sage Ct, Austin, TX, 78704 | 0.32 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-119853 | ENR | Mariaana Robertson | 2004-08-20 | UHC-59750-05 | — | 5340 Desert Sky Blvd, Denver, CO, 80211 | 0.32 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+6 more |
| ENR-103227 | ENR | Catherne P Nelson | 1954-10-12 | UHC-61771-81 | 4817875132 | 7047 Oak St, Los Angeles, CA, 90001 | 0.32 | Date of birth reformattedPhone reformattedMember ID reformattedSSN last four extracted+6 more |
| ENR-103498 | ENR | ElizabethJunk | 1949-02-13 | UHC-51524-84 | 9452067176 | 3180 River Rd, Gilbert, AZ, 85221 | 0.32 | Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+6 more |
| ENR-133065 | ENR | Roger Myers | 2003-10-14 | UHC-73410-29 | 4393178958 | 4575 Cedar Ln, Charlotte, NC | 0.32 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+6 more |
| ENR-100589 | ENR | Bradley U Carroll | 2004-12-02 | UHC-60033-71 | — | 1790 Highland Ave, Columbus, OH, 43233 | 0.32 | Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+6 more |
| ENR-101116 | ENR | Joan Lee | 1953-12-07 | UHC-09101-25 | 4428955182 | 7927 Market St Apt 10, Plano, TX, 75051 | 0.32 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more |
| ENR-134955 | ENR | Gloria H Austin | 1954-08-22 | UHC-94923-09 | 8006598478 | 5801 Harbor Blvd, Fresno, CA, 93702 | 0.32 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-114974 | ENR | Charles C Bryant | 1969-02-06 | UHC-01319-03 | 4216140249 | 5690 Lincoln Way Apt 26, Sacramento, CA | 0.32 | Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+6 more |
| ENR-110181 | ENR | Katherine Aguilar | 1992-01-03 | UHC-37873-89 | 8919065340 | 7851 Jefferson Ave Apt 10, San Antonio, TX, 78236 | 0.32 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+6 more |
| ENR-126189 | ENR | Judith Rodriguez | — | — | 2368689933 | 3081 Sage Ct, Scottsdale, AZ, 85279 | 0.32 | Name split from “Last, First”Date of birth reformattedDate of birth unreadablePhone reformatted+6 more |
| ENR-138528 | ENR | Isabella Shaw | 1942-11-09 | UHC-35404-84 | 3122976770 | 1072 Maple Ave Apt 3, Tampa, FL | 0.32 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more |
| ENR-134639 | ENR | Kevin N Rios | 1985-03-20 | UHC-15324-69 | 2482016127 | 6283 Desert Sky Blvd Apt 38, Houston, TX | 0.32 | Middle initial moved out of first nameName re-casedPhone reformattedMember ID reformatted+6 more |
| ENR-108829 | ENR | Zachary H Palmer | 1947-02-28 | UHC-29115-60 | 9367893997 | 5230 Apache Blvd, Dallas, TX, 75225 | 0.32 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more |
| ENR-104859 | ENR | Gerald T Cunningham | 1983-06-15 | UHC-15167-50 | 5392154718 | 7237 Camelback Rd Apt 27, Nashville, TN, 37295 | 0.32 | Name re-casedTwo-digit birth yearMember ID reformattedUnit split from street+6 more |
| ENR-112597 | ENR | Priya Weest | — | UHC-77568-76 | 2489756166 | 1090 Broadway # 683, Eden Prairie, MN, 55382 | 0.32 | Date of birth reformattedDate of birth unreadablePhone reformattedUnit split from street+6 more |
| ENR-132275 | ENR | Diane P Moraales | 1958-05-02 | UHC-58169-52 | 3276320176 | 6994 Jefferson Ave # 475, Seattle, WA | 0.32 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+6 more |
| ENR-110433 | ENR | Turnr V Debra | 1994-08-06 | UHC-81707-43 | 9608570465 | 906 Church St, Nashville, TN | 0.32 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-109942 | ENR | Lori I Duncan | 1951-07-06 | UHC-68266-89 | 9274527067 | 7113 Harbor Blvd Apt 4, Eden Prairie, MN | 0.32 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+6 more |
| ENR-131493 | ENR | Brian Oliver | 1950-01-27 | UHC-86629-37 | 4297986364 | 6033 Bayshore Dr, Glendale, AZ | 0.32 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+6 more |
| ENR-131667 | ENR | Margaret L Jacobs | 1946-05-10 | UHC-32530-76 | 8499700999 | 1750 Market St, Los Angeles, CA, 90036 | 0.32 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+6 more |
| ENR-141058 | ENR | Priya Fernandez | 2007-10-11 | UHC-89349-54 | 9449883064 | 2234 Ocean Ave Apt 31, Nashville, TN, 37285 | 0.32 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+6 more |
| ENR-139254 | ENR | Patrick Sanders | 2005-09-06 | UHC-58486-46 | 3583540598 | 4835 Apache Blvd, San Diego, CA | 0.32 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+6 more |
| ENR-122309 | ENR | Walter C Robinson | 1960-09-03 | UHC-90085-12 | 9549888327 | 9442 Jefferson Ave Apt 28, Tampa, FL, 33652 | 0.32 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+6 more |
| ENR-141512 | ENR | Danieel Holmes | 1953-11-18 | UHC-72010-71 | 5688750535 | 4543 Indian School Rd, Plano, TX, 75046 | 0.32 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-113724 | ENR | Nathan S Sanchez | 1949-11-13 | UHC-34921-74 | 9796243503 | 4029 Pine Dr Apt 11, Houston, TX, 77093 | 0.32 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more |
| ENR-119540 | ENR | Shirley Z Russell | 1975-04-25 | UHC-17459-89 | 7229581430 | 6139 Spring St # 518, Miami, FL, 33191 | 0.32 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+6 more |
| ENR-113215 | ENR | Wei P Park | 1944-05-28 | UHC-43011-33 | 7484422529 | 1301 Main St # 261, Plano, TX, 75091 | 0.32 | Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+6 more |
| ENR-132033 | ENR | Douglas Shaw | 2003-06-09 | UHC-63265-53 | 7303602095 | 7808 Union St, San Diego, CA, 92129 | 0.32 | Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+6 more |
| ENR-100543 | ENR | Douglas E Reyes | 1968-09-09 | UHC-89598-42 | 2962106401 | 7814 Central Ave, Scottsdale, AZ, 85284 | 0.32 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-124296 | ENR | Wei W Garrett | 1986-11-10 | UHC-19525-85 | — | 2747 Harbor Blvd, Seattle, WA | 0.32 | Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+6 more |
| ENR-119894 | ENR | Laura R Stevens | 1994-12-28 | UHC-21915-73 | 4183368944 | 4388 Jefferson Ave, Chandler, AZ | 0.32 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+6 more |
| ENR-106071 | ENR | Priya M Vasquez | 2002-08-06 | UHC-73382-09 | 5723685538 | 9473 Maple Ave, Plano, TX | 0.32 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+6 more |
| ENR-128034 | ENR | Santiago Green | 1998-04-02 | UHC-12115-24 | 8138824526 | 6800 Canyon Rd # 512, Columbus, OH | 0.32 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+6 more |
| ENR-113591 | ENR | Virginia P Hall | 1987-05-17 | UHC-97106-27 | 2193728797 | 1081 Oak St, Tempe, AZ, 85236 | 0.32 | Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+6 more |
| ENR-115013 | ENR | Ashley O Ryan | 1968-11-18 | UHC-36732-55 | 5507050464 | 9051 Spring St Apt 19, San Antonio, TX, 78270 | 0.32 | Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+6 more |
| ENR-115014 | ENR | Ashley O Ryan | 1968-11-18 | UHC-36732-55 | 5507050464 | 9051 Spring St Apt 19, San Antonio, TX, 78270 | 0.32 | Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+6 more |
| ENR-117025 | ENR | David L Herrera | 1981-04-04 | UHC-41384-51 | 4899325794 | 3549 Palm Dr Apt 2, Las Vegas, NV | 0.34 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more |
| ENR-117394 | ENR | Frank Q Bailey | 1949-06-25 | UHC-20314-33 | 4125996955 | 7687 Indian School Rd, Las Vegas, NV, 89150 | 0.34 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-119644 | ENR | Marcus Carlson | 1952-10-07 | UHC-22047-61 | 5296521919 | 4973 Spring St # 808, Orlando, FL, 32876 | 0.34 | Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+5 more |
| ENR-122845 | ENR | Ruth E Patterson | 1998-03-24 | UHC-86334-25 | 8253290339 | 8110 Oak St, Mesa, AZ | 0.34 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-129164 | ENR | Gabriel H Bradley | 1946-03-05 | UHC-00034-62 | 4684386833 | 1795 Church St, Fresno, CA, 93742 | 0.34 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedMember ID reformatted+5 more |
| ENR-103015 | ENR | Angela Williams | 1995-05-28 | UHC-24589-90 | 4398150372 | 7312 Meadow Ln Apt 38, Jacksonville, FL | 0.34 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+5 more |
| ENR-139968 | ENR | Bradley Padilla | 1960-11-01 | UHC-20978-25 | 9146679296 | 863 Indian School Rd, Tampa, FL, 33610 | 0.34 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-138491 | ENR | Carl Yang | 1971-09-16 | UHC-09711-54 | 5732709126 | 7828 Central Ave, Plano, TX, 75017 | 0.34 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-115626 | ENR | Natalie Z Garza | — | UHC-86293-53 | 5126987446 | 6728 Elm St, Austin, TX, 78794 | 0.34 | Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more |
| ENR-107309 | ENR | Jun R Simpson | 1953-03-05 | UHC-71857-24 | 7093397427 | 4156 Sunset Blvd, Jacksonville, FL, 32211 | 0.34 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-134009 | ENR | George H Le | 2006-05-06 | UHC-06211-11 | 5269622393 | 9213 Central Ave, Tucson, AZ, 85754 | 0.34 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-141072 | ENR | Kelly Foowler | — | UHC-70294-56 | 8219749261 | 4775 Washington St # 735, Mesa, AZ, 85242 | 0.34 | Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+5 more |
| ENR-122897 | ENR | Melissa K Edwards | 1984-06-22 | UHC-63985-13 | 3935653967 | 8770 River Rd, Jacksonville, FL | 0.34 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |