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-113499 | ENR | Watkins Maria | 1943-09-15 | UHC-30542-27 | 9796542026 | 7679 Central Ave, Tampa, FL, 33666 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-128139 | ENR | Noah S Torres | 1979-09-16 | UHC-06965-04 | 7199117989 | 2460 Grand Ave, Eden Prairie, MN, 55325 | 0.52 | Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedMember ID reformatted+2 more |
| ENR-111534 | ENR | Carol James | 1950-05-14 | UHC-38761-26 | — | 34 Sage Ct Apt 39, Scottsdale, AZ, 85209 | 0.52 | Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-125606 | ENR | Margaret Bishop | 1983-09-08 | UHC-24206-49 | — | 9864 Maple Ave, Eden Prairie, MN, 55300 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone missing area codeSSN last four extracted+2 more |
| ENR-103974 | ENR | Jean Santiago | 1943-08-12 | UHC-49960-87 | 5786613242 | 3517 Highland Ave, Los Angeles, CA, 90038 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-130254 | ENR | Samantha Dean | 2004-11-26 | UHC-17723-18 | 7555663797 | 8064 Indian School Rd, Dallas, TX, 75280 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-120827 | ENR | Diane Snyder | — | UHC-68765-36 | 6082870496 | 3890 Cedar Ln, Plano, TX, 75081 | 0.52 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-133295 | ENR | Karen Q Clark | 2007-12-06 | UHC-47593-45 | 5647392600 | 1136 Baseline Rd, Los Angeles, CA, 90084 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-142498 | ENR | Terry Q Hill | — | UHC-63505-05 | 7094435864 | 212 Washington St, Seattle, WA, 98145 | 0.52 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-107661 | ENR | Sara Carr | 1982-05-24 | UHC-76869-45 | 4134100117 | 3915 Washington St, Nashville, TN, 37293 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-111687 | ENR | Mratha B Soto | 1957-12-05 | UHC-45087-63 | 5014708672 | 2000 Harbor Blvd, Austin, TX, 78700 | 0.52 | SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-137038 | ENR | Gaary Herrera | 1983-11-17 | UHC-69117-24 | 5483689686 | 589 Mountain View Dr, Plano, TX, 75017 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-122979 | ENR | Diane L Armstrong | 2004-04-20 | UHC-42308-24 | 2015399999 | 3013 Forest Ave # 864, Charlotte, NC, 28246 | 0.52 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-125738 | ENR | Justin Q Murphy | — | UHC-52723-74 | 3747576957 | 8829 Pine Dr, Dallas, TX, 75279 | 0.52 | Date of birth reformattedDate of birth unreadablePhone reformattedSSN last four extracted+2 more |
| ENR-105592 | ENR | Santiago Herrera | 1965-05-20 | UHC-36829-74 | 2975336713 | 9406 Washington St, Mesa, AZ, 85267 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-116179 | ENR | Jacob L Evans | 1966-12-02 | UHC-47768-24 | 9006880173 | 7447 Baseline Rd, Fresno, CA, 93759 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+2 more |
| ENR-142058 | ENR | Timothy G Bennett | 1940-11-17 | UHC-58565-83 | 3744460647 | 1538 Harbor Blvd # 855, Tempe, AZ, 85234 | 0.52 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-127425 | ENR | Donna Cook | 1978-02-12 | UHC-07640-06 | 8798708298 | 6772 Desert Sky Blvd, Nashville, TN, 37276 | 0.52 | Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-101139 | ENR | Brandoon J Munoz | 1965-08-06 | UHC-24440-97 | 4199034858 | 466 Desert Sky Blvd, Jacksonville, FL, 32253 | 0.52 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-138758 | ENR | Dorothy Y Banks | 1968-02-22 | UHC-45975-38 | 7796758829 | 2711 Baseline Rd, Orlando, FL, 32854 | 0.52 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-104227 | ENR | Adam H Buurke | 1940-09-04 | UHC-31213-74 | 5924843277 | 1835 Hillcrest Rd, Nashville, TN, 37249 | 0.52 | Name split from “Last, First”Phone reformattedState name converted to codeGender normalised+2 more |
| ENR-125825 | ENR | Aaron V Berry | 1972-03-04 | UHC-34568-51 | 6329208521 | 3935 Market St, Chandler, AZ, 85286 | 0.52 | Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-132095 | ENR | Jacob Peterson | 1947-11-04 | UHC-66053-39 | 2757434217 | 1241 Washington St Apt 40, Tucson, AZ, 85764 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-118202 | ENR | Grace I Ramos | 1991-08-09 | UHC-74116-69 | 7933245860 | 683 Hillcrest Rd, Charlotte, NC, 28231 | 0.52 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more |
| ENR-134581 | ENR | Linda L Washington | — | UHC-77668-48 | 2757623820 | 5949 Sage Ct, Houston, TX, 77073 | 0.52 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-122172 | ENR | Noah C Oliver | 2008-12-05 | UHC-30408-58 | 2635553375 | 6736 Grand Ave, Dallas, TX | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedZIP missing+2 more |
| ENR-121713 | ENR | Nicholas W Armstronng | 1968-08-14 | UHC-86103-03 | 3006182934 | 3483 Willow Ct Apt 19, Tucson, AZ, 85719 | 0.52 | Middle initial moved out of first nameDate of birth reformattedSSN last four extractedUnit split from street+2 more |
| ENR-120486 | ENR | Jack Wallae | 1988-04-23 | UHC-64103-89 | 5952203699 | 3117 River Rd, Plano, TX | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-131774 | ENR | Mendoza Frank | 1981-10-06 | UHC-46190-14 | 9387076634 | 9694 Oak St, Charlotte, NC, 28225 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-108112 | ENR | Nick Harrison | 1986-01-22 | UHC-96747-20 | 5779084010 | 8587 Maple Ave, Dallas, TX, 75262 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-117056 | ENR | Sen Holmes | 2003-08-13 | UHC-34874-09 | 3073845941 | 7645 Apache Blvd, Dallas, TX, 75210 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-140940 | ENR | Maria Graham | 1961-02-20 | UHC-40957-36 | 7806038887 | 28 Mountain View Dr # 653, Mesa, AZ, 85261 | 0.52 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-120370 | ENR | Mark Hunter | 1941-09-01 | UHC-16438-98 | — | 1443 Elm St, San Diego, CA, 92170 | 0.52 | Phone missing area codeSSN last four extractedCity re-casedGender normalised+2 more |
| ENR-100772 | ENR | Stephanie Campbell | 1960-03-15 | UHC-45143-38 | 3997886790 | 8660 Central Ave, Atlanta, GA, 30368 | 0.52 | Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more |
| ENR-140264 | ENR | Betty T Griffin | 1956-02-08 | UHC-23779-75 | 3918274461 | 4989 Central Ave, Las Vegas, NV | 0.52 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-122642 | ENR | Robert K Sandoval | 1983-10-28 | UHC-65139-83 | 2917441160 | 1782 Mountain View Dr, Fresno, CA, 93776 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-122328 | ENR | Victoria U Padilla | 1959-10-24 | UHC-11852-45 | 7215731861 | 3519 Willow Ct, Seattle, WA, 98135 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+2 more |
| ENR-122378 | ENR | Juan George | 1969-10-12 | UHC-51548-97 | 6812589562 | 416 Hillcrest Rd, Austin, TX, 78790 | 0.52 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-125892 | ENR | Edward S Bradley | 1966-09-03 | UHC-46461-64 | 2709348793 | 5113 Main St, San Antonio, TX, 78243 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-115636 | ENR | Theresa W Cruz | 1962-06-06 | UHC-36360-26 | — | 8152 Camelback Rd # 212, Jacksonville, FL, 32280 | 0.52 | Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-139492 | ENR | Samuel Castro | 1979-01-22 | UHC-38821-19 | 3734718208 | 9315 Mountain View Dr, Tempe, AZ, 85241 | 0.52 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-129306 | ENR | Aron E Vazquez | 1969-01-16 | UHC-12265-62 | 3916780884 | 3443 River Rd, Sacramento, CA, 95803 | 0.52 | Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-129393 | ENR | Judy A Carroll | 2006-05-24 | UHC-24401-98 | 9048292620 | 2492 Mountain View Dr, San Diego, CA, 92157 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-129392 | ENR | Judy A Carroll | 2006-05-24 | UHC-24401-98 | 9048292620 | 2492 Mountain View Dr, San Diego, CA, 92157 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-130188 | ENR | Beverly X Valdez | 1989-10-24 | UHC-20571-96 | 2017033754 | 9115 Canyon Rd, Charlotte, NC, 28227 | 0.52 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-109603 | ENR | Maria I Estrada | 1953-05-25 | UHC-10803-92 | 6723712656 | 5526 Valley View Dr, Jacksonville, FL | 0.52 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-109602 | ENR | Maria I Estrada | 1953-05-25 | UHC-10803-92 | 6723712656 | 5526 Valley View Dr, Jacksonville, FL | 0.52 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-120838 | ENR | Jacob V George | 1957-06-02 | UHC-55194-69 | 4223889938 | 1133 Lincoln Way # 436, Eden Prairie, MN, 55383 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+2 more |
| ENR-111678 | ENR | Ahmed Vasquez | 1956-06-02 | UHC-88338-81 | 7462383231 | 6948 Camelback Rd, Gilbert, AZ, 85282 | 0.52 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-108355 | ENR | Alice F Freeman | 1970-09-12 | UHC-21999-44 | 5815901758 | 9795 Sunset Blvd, Eden Prairie, MN, 55311 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |