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-104820 | ENR | Ana Stewart | 1954-07-21 | UHC-76709-04 | 6204024044 | 2654 Sunset Blvd, Fresno, CA, 93776 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111621 | ENR | Jack C Pierce | 1958-12-15 | — | 4954680794 | 4710 Jefferson Ave, Miami, FL, 33123 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-127227 | ENR | Sandra W Owens | 1972-03-03 | UHC-34059-29 | 4885278152 | 7000 Harbor Blvd, Chandler, AZ | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-120645 | ENR | Brandon P Mason | 1940-02-11 | UHC-72913-09 | 2296444365 | 617 Elm St, Tucson, AZ, 85701 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-102554 | ENR | Jessica Jimenez | 1972-08-26 | UHC-85188-23 | 6716536150 | 2680 Sunset Blvd, Jacksonville, FL, 32254 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-139886 | ENR | Beverly U Vazquez | 2008-07-09 | UHC-36185-91 | 3547462014 | 815 Sage Ct, Mesa, AZ, 85283 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-118701 | ENR | Henry Wells | 1994-05-08 | UHC-34465-23 | 2483558215 | 7167 Highland Ave, Scottsdale, AZ, 85216 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-141198 | ENR | Bradley Dunn | 1950-02-10 | UHC-63013-82 | 4057801523 | 4893 Mountain View Dr, Minneapolis, MN, 55480 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-138125 | ENR | Lawrence Y Andrews | 1972-09-22 | UHC-44841-77 | 4253777826 | 5488 Spring St, Eden Prairie, MN, 55320 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+4 more |
| ENR-118439 | ENR | Loggan I Robinson | 1960-07-13 | UHC-41049-44 | 9173299270 | 9414 Church St, Las Vegas, NV, 89118 | 0.60 | Middle initial moved out of first nameName re-casedPhone reformattedMember ID reformatted+4 more |
| ENR-117037 | ENR | David Jones | 1953-05-15 | UHC-24557-62 | 5678440660 | 3492 Elm St # 220, Glendale, AZ, 85326 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-136678 | ENR | Elijah Padilla | 2006-09-07 | UHC-90343-90 | 4285014942 | 5747 Willow Ct, Glendale, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-117137 | ENR | Amy Bryant | 1950-02-10 | UHC-84464-07 | 4235164157 | 2882 Oak St, Fresno, CA, 93709 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-128199 | ENR | Kelly Griffin | 1977-04-10 | UHC-20670-78 | 2832347520 | 172 Hillcrest Rd, Glendale, AZ, 85334 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-101576 | ENR | Julie P Romero | 1940-12-17 | UHC-28284-55 | 7752013906 | 5302 Apache Blvd, Denver, CO, 80229 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-134120 | ENR | Sophia X Garrett | 1955-05-14 | UHC-00711-30 | 6917660824 | 6424 Oak St, Scottsdale, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-114289 | ENR | Chuck Dunn | 1993-10-24 | UHC-26801-85 | 9608153372 | 4956 Meadow Ln, Columbus, OH, 43288 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-138328 | ENR | Saar K Williams | 1973-12-22 | UHC-98807-33 | 6887004716 | 5037 Washington St, Seattle, WA, 98101 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-121372 | ENR | Andrew Y Dominguez | 2008-06-06 | UHC-74762-12 | 2778317507 | 2936 Broadway, Columbus, OH | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-106420 | ENR | Roger Gomez | 1993-01-02 | UHC-24168-21 | 4029881854 | 5333 Harbor Blvd, Los Angeles, CA | 0.60 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-119072 | ENR | Diego Boyd | 2002-09-23 | UHC-90958-04 | 7437540518 | 6612 Washington St, Columbus, OH, 43294 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-102848 | ENR | Denise O Harrison | 2008-01-27 | UHC-68862-97 | 3634355973 | 5514 Camelback Rd, Chandler, AZ, 85289 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-128887 | ENR | Yuki D Crawford | 1979-04-14 | UHC-20394-21 | 8359915469 | 5540 River Rd, Austin, TX, 78716 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-101319 | ENR | Justin U Weber | 1948-06-28 | UHC-21843-63 | — | 9726 Palm Dr, Miami, FL, 33131 | 0.60 | Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+4 more |
| ENR-131121 | ENR | Sam G Reid | 1977-02-22 | UHC-39955-17 | 6452977729 | 2709 Harbor Blvd, Orlando, FL | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-128785 | ENR | Christine W Singh | 1971-02-03 | UHC-80809-93 | 2526413605 | 835 Main St, Tempe, AZ, 85255 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+4 more |
| ENR-141981 | ENR | Brandon Cox | 1969-02-23 | UHC-48544-40 | 7149979450 | 9247 Mountain View Dr, Austin, TX, 78796 | 0.60 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-101823 | ENR | Joe F Stone | 1959-03-07 | UHC-38116-29 | 7834344858 | 7450 Bayshore Dr, Austin, TX, 78720 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-113466 | ENR | Russell W Wong | 1985-05-08 | UHC-32502-69 | 7819103370 | 6766 Desert Sky Blvd Apt 4, Houston, TX, 77022 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-138475 | ENR | Hiroshi Z Pierce | 1953-06-21 | UHC-28665-10 | 4506160415 | 8169 Canyon Rd Apt 21, San Diego, CA, 92188 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-129151 | ENR | Marilyn T West | 1980-07-28 | UHC-27302-30 | 4703844596 | 4394 Apache Blvd Apt 38, Glendale, AZ, 85329 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-141346 | ENR | Ahmed J Kelly | 1965-02-21 | UHC-98117-22 | 9242477298 | 4968 Willow Ct Apt 16, Tucson, AZ, 85776 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-104588 | ENR | Brittany A Watson | 1974-05-08 | UHC-29744-32 | 8545621093 | 2080 Union St, Scottsdale, AZ, 85239 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111326 | ENR | Joshua Gordon | 1983-11-03 | UHC-19807-30 | 5787622808 | 7170 Willow Ct, Sacramento, CA | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-140799 | ENR | Carl Lynch | 2003-02-23 | UHC-43141-12 | 5152979945 | 9073 River Rd, Tempe, AZ | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-129573 | ENR | Jon H Reyes | 1952-07-07 | UHC-89739-72 | 6804201368 | 7319 Pine Dr, Austin, TX, 78703 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-125283 | ENR | Melissa Shew | 1946-10-22 | UHC-60357-99 | 3534831194 | 4310 Valley View Dr # 392, Tampa, FL, 33684 | 0.60 | Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-136649 | ENR | Christine I Youung | 1978-10-04 | UHC-29927-75 | 6963905112 | 6594 Sunset Blvd, Orlando, FL, 32870 | 0.60 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-126182 | ENR | Mason B Stewart | 1961-06-25 | UHC-38574-16 | 3233545682 | 6930 Sunset Blvd, Sacramento, CA, 95875 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| ENR-116155 | ENR | Catherine Simpson | 1979-08-26 | UHC-22875-45 | 5538124807 | 2256 Oak St, Tempe, AZ | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-136924 | ENR | Keevin Z Stevens | 1953-01-05 | UHC-86764-72 | 6217767714 | 7911 Baseline Rd, Glendale, AZ, 85373 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-126707 | ENR | Lawrence B Webb | 1942-04-02 | UHC-93961-29 | 8544171833 | 5227 Main St, Phoenix, AZ, 85029 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-141899 | ENR | Michelle P Gutierrez | 1964-12-17 | UHC-90571-23 | 8915690539 | 118 River Rd # 526, Mesa, AZ, 85254 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-105698 | ENR | Christina Moralles | 1966-05-24 | UHC-42901-64 | 4814710861 | 7966 Camelback Rd, Gilbert, AZ, 85236 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-111988 | ENR | Anthony G Fields | 1966-06-08 | UHC-92391-87 | 6026645562 | 7579 Central Ave, Austin, TX, 78712 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-142807 | ENR | Jacob Espinoza | 1943-03-01 | UHC-09081-77 | 2186631113 | 9827 Lake View Rd Apt 40, San Diego, CA, 92130 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-106545 | ENR | Sam Miller | 1940-11-09 | UHC-50684-94 | 3718044039 | 5308 Grand Ave # 408, Tucson, AZ, 85778 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-132249 | ENR | William W Rivera | 1971-03-13 | UHC-47674-88 | 5122810729 | 3566 Willow Ct, San Diego, CA, 92191 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-100084 | ENR | Lawrence H Kelly | 2008-02-22 | UHC-78966-48 | 9817852571 | 7196 Oak St Apt 29, Columbus, OH, 43276 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-140464 | ENR | Cynthia Z Sullivan | 1999-07-27 | UHC-08546-06 | 8348382068 | 4119 Cedar Ln # 893, Scottsdale, AZ, 85218 | 0.60 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more |