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-122368 | ENR | Abigail H Gomez | 1954-05-20 | UHC-76184-54 | 2342380498 | 9733 Apache Blvd, Tempe, AZ, 85256 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135189 | ENR | Linda Mendez | 1987-05-08 | UHC-91612-22 | 9584414884 | 9362 Willow Ct, Tempe, AZ, 85226 | 0.50 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-103503 | ENR | Wayne Lawrence | — | UHC-78593-05 | 4959315140 | 6617 Hillcrest Rd, Chandler, AZ, 85228 | 0.50 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-114100 | ENR | Kevin U Cunningham | 1942-10-27 | UHC-96334-53 | 7536705354 | 4976 Cedar Ln # 439, Orlando, FL, 32813 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-130333 | ENR | Megan Delgado | — | UHC-77498-46 | 3783864819 | 8796 Bayshore Dr, San Diego, CA | 0.50 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-141870 | ENR | Isabella Rse | 1991-01-19 | UHC-86613-44 | 7732423168 | 23 Bayshore Dr, San Diego, CA | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-129812 | ENR | Kimberly U Armstrong | 1958-04-08 | — | 3578593661 | 1214 Palm Dr, Tucson, AZ, 85739 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121855 | ENR | Marcus Nguyen | 1981-01-17 | UHC-61216-08 | 6044211221 | 8499 Forest Ave, Houston, TX, 77037 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133296 | ENR | Jessica C Kennedy | 1986-12-27 | UHC-38650-31 | 3949144344 | 2987 Ridge Rd, Mesa, AZ, 85288 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-115527 | ENR | Luis H Munoz | 1963-10-07 | UHC-84496-65 | 5683113536 | 8503 Oak St, Atlanta, GA, 30354 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-136265 | ENR | Grace Wong | 2000-12-03 | UHC-13056-47 | 7356676010 | 3571 Spring St, Sacramento, CA | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110939 | ENR | Alex R Gutierrez | 1968-08-03 | UHC-03255-02 | 6562687280 | 3809 Oak St, Sacramento, CA, 95811 | 0.50 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-114793 | ENR | Santiago Mejia | 1961-06-28 | UHC-22049-75 | 3144804021 | 1907 Highland Ave # 446, Miami, FL, 33186 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more |
| ENR-139933 | ENR | Frank Powell | 1990-09-11 | UHC-17295-02 | 2645365520 | 8797 Camelback Rd # 514, Columbus, OH, 43231 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-113914 | ENR | Petrick Luna | 1983-10-03 | UHC-87231-07 | 9599188887 | 2497 Baseline Rd, Jacksonville, FL, 32287 | 0.50 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121963 | ENR | Amanda Woods | 1938-08-27 | UHC-77779-13 | 8554138089 | 1989 Sage Ct, Atlanta, GA, 30376 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-117124 | ENR | Santiago E Gray | 1951-10-02 | UHC-60144-43 | — | 2965 Camelback Rd, Atlanta, GA, 30382 | 0.50 | Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-119650 | ENR | Scott H Kim | 1962-07-02 | UHC-69089-17 | 9322842075 | 4664 Spring St, Chandler, AZ, 85221 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-113159 | ENR | Lisa U Hayes | 1997-11-16 | UHC-48433-58 | 6132327411 | 3266 Mountain View Dr, Plano, TX, 75053 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-115937 | ENR | Kevin Q Burke | — | UHC-90271-70 | 7363741120 | 7399 Church St, Denver, CO, 80246 | 0.50 | Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-124186 | ENR | Janice Weaver | 1973-10-17 | UHC-62096-42 | — | 1279 Oak St, Denver, CO, 80225 | 0.50 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-116661 | ENR | Lus Lee | 1965-04-28 | UHC-56887-73 | 2645827180 | 7876 Bayshore Dr, Phoenix, AZ | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121418 | ENR | Mike Walker | 1974-05-01 | UHC-97961-65 | 3547704933 | 5591 Harbor Blvd, Austin, TX | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-129209 | ENR | Maria Q Cunningham | 1959-10-20 | UHC-51601-85 | 8988085832 | 7075 Pine Dr, Los Angeles, CA, 90008 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110684 | ENR | Pamela Jackson | 1959-03-14 | UHC-56346-66 | — | 7679 Mesa Dr, Charlotte, NC | 0.50 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-135821 | ENR | Jordan J Boyd | 1962-06-03 | UHC-82021-98 | 5339654881 | 5668 Union St Apt 1, Minneapolis, MN, 55466 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-120119 | ENR | Edward Olliver | 2006-04-20 | UHC-36016-90 | 4294649556 | 2187 Sage Ct, Columbus, OH, 43206 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-136647 | ENR | Brittany Peterson | 1980-04-14 | UHC-26138-49 | 3098747741 | 4303 Elm St, Eden Prairie, MN, 55362 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-118824 | ENR | Heather V Palmer | 2005-05-09 | UHC-37730-21 | 4767789684 | 6747 Jefferson Ave, Los Angeles, CA | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123804 | ENR | Lawson R Kathleen | 1941-07-17 | UHC-48976-71 | 4285317493 | 2728 Valley View Dr Apt 10, Charlotte, NC, 28202 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-113826 | ENR | Ahmed Z Burke | 1958-06-22 | UHC-38144-72 | 3877647745 | 2720 Spring St Apt 19, Minneapolis, MN, 55435 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-113260 | ENR | Carolyn Moore | — | UHC-65072-52 | 2204956098 | 8841 Jefferson Ave, Nashville, TN, 37223 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-119166 | ENR | Ashley Alvarado | 1992-05-17 | UHC-25866-63 | 5858307848 | 5400 Washington St, Atlanta, GA, 30377 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more |
| ENR-123774 | ENR | Fields O Walter | 1938-08-18 | UHC-01743-64 | 6036930264 | 9344 Camelback Rd, Fresno, CA | 0.50 | Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-136539 | ENR | Lgan Q Tran | 1997-05-11 | UHC-26362-90 | 7296500155 | 4762 Canyon Rd, Plano, TX, 75057 | 0.50 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-123558 | ENR | Amanad Fisher | 1970-08-21 | UHC-11517-28 | 2534443613 | 5090 Willow Ct # 652, Phoenix, AZ, 85007 | 0.50 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-136039 | ENR | Lucia Gonzalez | 1978-07-05 | UHC-77260-89 | 7632052821 | 3897 Bayshore Dr, Sacramento, CA, 95873 | 0.50 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100158 | ENR | Bobby Hoffman | 1987-01-23 | UHC-04901-77 | 9108465800 | 3548 Camelback Rd Apt 34, Denver, CO, 80290 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more |
| ENR-139290 | ENR | Daniels Jeremy | — | UHC-69692-81 | 3699227925 | 4069 Oak St, Denver, CO, 80219 | 0.50 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-139952 | ENR | Marilyn Ramirez | 1970-06-01 | UHC-67599-81 | — | 8681 Spring St, Charlotte, NC | 0.50 | Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-124663 | ENR | Ronald Long | — | UHC-17595-06 | — | 3301 Oak St, Charlotte, NC, 28270 | 0.50 | Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more |
| ENR-100752 | ENR | Jose L Fower | 1999-10-17 | UHC-49377-67 | 3032304023 | 6354 Forest Ave, Minneapolis, MN | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-116486 | ENR | Mei Gant | 1950-02-14 | UHC-98407-62 | 7343191836 | 3793 Lake View Rd, San Diego, CA, 92168 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-108504 | ENR | Ryan Laura | 1993-01-22 | UHC-44301-74 | 3507482025 | 9430 Sunset Blvd, Charlotte, NC | 0.50 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-120091 | ENR | Bobby Torres | 1945-05-09 | UHC-38502-01 | 8656050788 | 6470 Lake View Rd, Glendale, AZ, 85357 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-108636 | ENR | Brenda Riley | 1954-12-20 | UHC-37821-16 | 9562203055 | 2264 Park Pl Apt 19, Scottsdale, AZ, 85275 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+3 more |
| ENR-112923 | ENR | Kimberly H Hernandez | — | UHC-45537-91 | 7288066834 | 1697 Desert Sky Blvd Apt 3, Chandler, AZ, 85254 | 0.50 | Date of birth reformattedDate of birth unreadablePhone reformattedUnit split from street+3 more |
| ENR-142960 | ENR | William Thomas | 1966-01-16 | UHC-30395-04 | 5535949350 | 6199 Cedar Ln, Seattle, WA, 98173 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133557 | ENR | Chritian BJunk | 2007-07-24 | UHC-28089-14 | — | 9378 Willow Ct, Scottsdale, AZ | 0.50 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-108830 | ENR | Kimberly Z Salazar | 1971-04-19 | UHC-10291-16 | 6567188969 | 2158 Palm Dr, Sacramento, CA, 95854 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |