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-124338 | ENR | Debra Z Black | 2004-05-25 | UHC-02549-25 | 4757230223 | 2045 Valley View Dr # 897, San Diego, CA, 92108 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-127108 | ENR | Beth Kennedy | 1946-03-05 | UHC-31956-48 | 9322850128 | 2428 Valley View Dr Apt 36, Jacksonville, FL, 32287 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-115774 | ENR | Hiroshi Lawrece | 1943-01-16 | UHC-54967-01 | 2835169672 | 7093 Grand Ave, Scottsdale, AZ, 85275 | 0.50 | Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-124765 | ENR | Kayla A Garrett | 1993-01-02 | UHC-84412-04 | 5952711400 | 3765 Desert Sky Blvd, Fresno, CA, 93773 | 0.50 | Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more |
| ENR-124764 | ENR | Kayla A Garrett | 1993-01-02 | UHC-84412-04 | 5952711400 | 3765 Desert Sky Blvd, Fresno, CA, 93773 | 0.50 | Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more |
| ENR-107830 | ENR | Crlos Salazar | 1992-08-07 | UHC-04052-21 | 4079702887 | 2954 Canyon Rd, Phoenix, AZ | 0.50 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-125130 | ENR | Sam Johnstton | 1951-06-13 | UHC-73743-62 | 9364229242 | 3367 Desert Sky Blvd, Seattle, WA, 98113 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-105311 | ENR | Eugene W Yang | 1964-02-15 | UHC-43655-69 | 4672258196 | 1127 Palm Dr # 815, Denver, CO, 80204 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-109323 | ENR | Nathan Schultz | 1968-02-18 | UHC-02679-13 | 4438045596 | 4204 Highland Ave # 683, Miami, FL | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-142918 | ENR | Mason M Ward | 1993-02-17 | UHC-71648-92 | 3827208216 | 2679 Camelback Rd, Jacksonville, FL, 32212 | 0.50 | Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-103117 | ENR | Kevin R Wright | 1974-10-25 | UHC-22698-63 | 9197348135 | 4413 Canyon Rd, Tucson, AZ | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-107625 | ENR | JuliaJunk | 1999-01-04 | — | 9039003988 | 9310 Washington St Apt 23, Houston, TX, 77028 | 0.50 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-113853 | ENR | Thomas D Walker | 1999-03-19 | UHC-98355-06 | — | 5048 Market St, Glendale, AZ, 85398 | 0.50 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121138 | ENR | Linda Robinson | 2002-05-22 | UHC-09691-48 | — | 6595 Union St, Nashville, TN, 37283 | 0.50 | Name re-casedPhone missing area codeMember ID reformattedState name converted to code+3 more |
| ENR-104462 | ENR | Julia O Montgomery | 1953-03-18 | UHC-08245-41 | 3424773408 | 8871 Harbor Blvd, Scottsdale, AZ, 85265 | 0.50 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-106152 | ENR | Adam L Freeman | 1954-12-10 | UHC-15081-88 | 8559862182 | 2392 Oak St, San Antonio, TX, 78223 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120507 | ENR | Theresa G Gordon | 1944-01-11 | UHC-51004-21 | — | 5855 Grand Ave, Chandler, AZ, 85295 | 0.50 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| ENR-122768 | ENR | Wayne J Matthews | 1953-07-06 | UHC-13783-22 | 6537451332 | 8347 Market St # 903, Scottsdale, AZ, 85295 | 0.50 | Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-117193 | ENR | Sarah Tucker | 1943-09-21 | UHC-46506-60 | — | 8369 Mountain View Dr, Sacramento, CA, 95819 | 0.50 | Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-109184 | ENR | Eugene Porter | 1966-07-22 | UHC-60023-22 | 8226291602 | 4072 Maple Ave, Nashville, TN, 37291 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-126955 | ENR | Christina Armstrong | 1977-06-05 | UHC-85233-33 | 6675606643 | 7060 Park Pl # 181, Las Vegas, NV, 89113 | 0.50 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-111284 | ENR | Susan L Ross | 1982-07-18 | UHC-33226-10 | 5604832539 | 4013 Oak St, Sacramento, CA, 95894 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123439 | ENR | Jim J Santiago | 1946-12-26 | UHC-83965-28 | 8983719168 | 1506 Mountain View Dr, Glendale, AZ, 85361 | 0.50 | Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+3 more |
| ENR-103766 | ENR | Bettty I Edwards | 1968-05-11 | UHC-46319-99 | 4423840908 | 7053 Main St, Seattle, WA, 98147 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-129707 | ENR | Philip B Edwards | 1989-09-11 | UHC-82853-55 | 8292918985 | 8327 Baseline Rd Apt 10, Columbus, OH | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-124799 | ENR | Cheryl U Hudson | — | UHC-35698-66 | 6883864303 | 3694 Market St, Miami, FL, 33164 | 0.50 | Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-132768 | ENR | Danielle D Henry | 1950-11-16 | UHC-92098-20 | 3755439260 | 863 Ocean Ave Apt 21, Tempe, AZ, 85292 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-135621 | ENR | Beth Z Stephens | 1940-06-08 | UHC-57401-20 | 8467206570 | 1884 Highland Ave, San Antonio, TX | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-128229 | ENR | Valentina Q Patel | 1943-04-05 | UHC-58567-46 | 5195039657 | 9493 Canyon Rd, Seattle, WA, 98115 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109477 | ENR | Bobby W Garrett | 1963-04-16 | UHC-52614-08 | 7056980880 | 6221 Canyon Rd, Mesa, AZ, 85219 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-119000 | ENR | Aisha S Ryan | 2006-03-11 | UHC-58675-91 | 9812238695 | 7550 Spring St, Gilbert, AZ, 85220 | 0.50 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-104065 | ENR | Judith Pena | 1939-08-25 | UHC-47584-45 | 5615105268 | 1931 Baseline Rd, Denver, CO, 80265 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more |
| ENR-133564 | ENR | Mason Baker | 1942-12-28 | UHC-52066-68 | 9625822416 | 7065 Harbor Blvd Apt 34, Columbus, OH, 43262 | 0.50 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-124174 | ENR | Philip Larson | 1953-11-19 | UHC-32280-28 | 4609465524 | 5533 Market St, Tucson, AZ, 85703 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-108709 | ENR | RJunk | 2002-05-24 | UHC-45296-24 | 8658298611 | 3205 Union St, Tucson, AZ, 85789 | 0.50 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-106080 | ENR | Karen M Campbell | 1967-07-12 | UHC-50459-14 | 3704473086 | 3013 Market St, San Antonio, TX, 78271 | 0.50 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-138308 | ENR | Betty Ray | 1991-11-01 | UHC-11103-39 | — | 9637 Cedar Ln, Orlando, FL | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-113241 | ENR | Karen E Murphy | 1960-01-28 | UHC-64792-24 | 3754695202 | 8224 Willow Ct, Seattle, WA, 98116 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133708 | ENR | Isabella Vasquez | 2002-12-07 | UHC-33559-05 | 4809850659 | 6491 Washington St Apt 19, Tempe, AZ, 85245 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-118436 | ENR | Maria I Jordan | 1956-08-02 | UHC-38848-23 | 5245193419 | 9605 Cedar Ln, Austin, TX, 78745 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-118354 | ENR | Mariana R Santiago | 2007-11-22 | UHC-36282-56 | — | 4386 Jefferson Ave, Tucson, AZ, 85737 | 0.50 | Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more |
| ENR-118353 | ENR | Mariana R Santiago | 2007-11-22 | UHC-36282-56 | — | 4386 Jefferson Ave, Tucson, AZ, 85737 | 0.50 | Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more |
| ENR-105549 | ENR | Priya Rodriguez | 1950-11-12 | UHC-48070-64 | 6889821901 | 3100 Apache Blvd, Seattle, WA | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more |
| ENR-108512 | ENR | Keith G Lewis | 1961-10-07 | UHC-47050-31 | 2325599778 | 4875 Market St Apt 22, Scottsdale, AZ, 85214 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-127376 | ENR | Elizabeth I Wallace | 1976-06-08 | UHC-00524-84 | 8558049065 | 6933 Oak St, Houston, TX, 77028 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-114727 | ENR | Sharon E Meyer | — | UHC-78085-87 | 9742487576 | 3676 Maple Ave, Los Angeles, CA | 0.50 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more |
| ENR-104791 | ENR | Raymond N Armstrong | 1984-08-09 | UHC-54364-17 | 8808589858 | 2275 Forest Ave, Sacramento, CA, 95851 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-105238 | ENR | Diana J Russell | 1999-01-05 | UHC-52397-34 | 8807150014 | 3778 Apache Blvd, Tempe, AZ, 85228 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-103208 | ENR | Brandon N Jenkins | 1994-08-01 | UHC-34796-81 | 6559348279 | 1660 Palm Dr, Scottsdale, AZ, 85209 | 0.50 | Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-108656 | ENR | Jose O Roberts | 1942-07-12 | UHC-90725-16 | 9253512221 | 1301 Elm St # 711, Jacksonville, FL | 0.50 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |