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-101279 | ENR | Sean Hunter | 1944-01-18 | UHC-33259-01 | 6185124174 | 5604 Pine Dr, Austin, TX, 78795 | 0.52 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| ENR-113802 | ENR | Laura Fox | 1975-10-04 | UHC-14380-64 | — | 6335 Church St, San Antonio, TX, 78270 | 0.52 | Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more |
| ENR-140704 | ENR | Amanda Anndrews | 1971-10-25 | UHC-57948-95 | 7375028148 | 7758 Central Ave, Chandler, AZ, 85275 | 0.52 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-103902 | ENR | Elizabeth G Carr | 1950-05-12 | UHC-31609-62 | 6666447286 | 8111 Bayshore Dr Apt 22, San Antonio, TX, 78246 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-110065 | ENR | Kathy Bowman | 1973-10-03 | UHC-43848-68 | 9483084611 | 3619 Elm St, Eden Prairie, MN | 0.52 | SSN last four extractedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-107376 | ENR | Larry F Jackson | 1943-03-16 | UHC-86916-41 | 9178940301 | 9602 Church St # 525, Seattle, WA, 98124 | 0.52 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-129424 | ENR | Larry D Riley | 1938-04-13 | UHC-29158-66 | 3113969988 | 4797 Mountain View Dr, Orlando, FL, 32834 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-104558 | ENR | Amber J Alexander | 1972-12-15 | UHC-39257-43 | 3264648987 | 3079 Oak St, Fresno, CA | 0.52 | Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more |
| ENR-101422 | ENR | Sean Carter | 1989-03-09 | UHC-33480-82 | 6943474294 | 8727 Union St, Phoenix, AZ, 85067 | 0.52 | Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-114151 | ENR | Philip Sanders | 1957-06-07 | UHC-05781-06 | 5837134357 | 4585 Camelback Rd Apt 3, Charlotte, NC, 28202 | 0.52 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-128049 | ENR | Stephen K Jimenez | 2006-09-27 | UHC-39923-61 | — | 3249 Bayshore Dr, Denver, CO, 80254 | 0.52 | Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-105513 | ENR | Martha Willis | 1949-05-10 | UHC-02418-70 | — | 1641 Sage Ct Apt 2, Eden Prairie, MN, 55351 | 0.52 | Phone missing area codeUnit split from streetState code upper-casedGender normalised+2 more |
| ENR-128575 | ENR | Sandra G Franklin | — | UHC-25678-83 | — | 8987 Palm Dr, Jacksonville, FL, 32257 | 0.52 | Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+2 more |
| ENR-127463 | ENR | Ana Ortiz | 1959-05-28 | UHC-28766-26 | 6247425118 | 1779 Central Ave, Atlanta, GA, 30336 | 0.52 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more |
| ENR-138825 | ENR | Kathleen Scott | 1963-06-18 | UHC-56889-17 | 4963245531 | 5214 Meadow Ln Apt 13, Jacksonville, FL, 32240 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-113729 | ENR | Mariana Y Hoffman | 1965-05-16 | UHC-96797-91 | 6843072189 | 7221 Desert Sky Blvd, Sacramento, CA | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more |
| ENR-103020 | ENR | Philip O Morgan | — | UHC-74681-79 | 2909733861 | 5281 River Rd, Minneapolis, MN | 0.52 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-116653 | ENR | Greg Sanders | 1978-01-20 | UHC-11903-39 | 7708126755 | 2084 Sage Ct, Sacramento, CA, 95826 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-106037 | ENR | Bryn P Kelly | 1978-10-05 | UHC-84004-38 | 4427756296 | 4508 Ocean Ave, Glendale, AZ, 85375 | 0.52 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-126093 | ENR | Vicky Harper | 1955-09-05 | UHC-33397-25 | 6304272018 | 3308 Baseline Rd, Phoenix, AZ, 85089 | 0.52 | Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+2 more |
| ENR-124077 | ENR | Julie B Riley | 1941-02-10 | UHC-35425-25 | 7318609988 | 6520 Central Ave, Gilbert, AZ | 0.52 | Name re-casedPhone reformattedState name converted to codeZIP missing+2 more |
| ENR-128064 | ENR | Katherine Hughes | 1964-08-18 | UHC-58411-53 | 9573748697 | 3745 Maple Ave # 391, San Diego, CA, 92114 | 0.52 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-114208 | ENR | Dorothy D Garcia | 1949-05-15 | UHC-92624-48 | 8249323499 | 4613 Bayshore Dr, San Antonio, TX, 78280 | 0.54 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more |
| ENR-111544 | ENR | Omar T Freeman | 1939-09-04 | UHC-55803-50 | 3478349199 | 7187 Desert Sky Blvd Apt 7, Denver, CO | 0.54 | Date of birth reformattedPhone reformattedUnit split from streetZIP missing+1 more |
| ENR-116053 | ENR | Stephanie Y Ruiz | 1999-01-26 | UHC-28633-53 | — | 1752 Main St, Eden Prairie, MN, 55329 | 0.54 | Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more |
| ENR-109808 | ENR | Ronald V Sandoval | 1996-04-08 | UHC-16953-93 | — | 6996 Mountain View Dr, Chandler, AZ, 85299 | 0.54 | Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more |
| ENR-108000 | ENR | Brandon Hill | 1984-07-26 | UHC-22856-42 | 2154126435 | 9744 Maple Ave, Scottsdale, AZ | 0.54 | Name re-casedTwo-digit birth yearPhone reformattedZIP missing+1 more |
| ENR-109628 | ENR | Dorothy V Holmes | 1970-11-14 | UHC-54912-35 | 8295569564 | 8960 Spring St, Nashville, TN, 37225 | 0.54 | Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more |
| ENR-109627 | ENR | Dorothy V Holmes | 1970-11-14 | UHC-54912-35 | 8295569564 | 8960 Spring St, Nashville, TN, 37225 | 0.54 | Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more |
| ENR-133197 | ENR | Philip Tucker | 1982-02-21 | UHC-65487-82 | 7326363269 | 9361 Jefferson Ave, Orlando, FL, 32873 | 0.54 | Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more |
| ENR-122631 | ENR | Sofia G Peters | 2004-01-06 | UHC-10758-59 | 5549560638 | 4510 Pine Dr Apt 8, Houston, TX, 77094 | 0.54 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more |
| ENR-115904 | ENR | Rusesll Williamson | 1947-11-06 | UHC-57475-82 | 8947451321 | 1151 Maple Ave Apt 16, Miami, FL | 0.54 | Name re-casedPhone reformattedSSN last four extractedUnit split from street+1 more |
| ENR-106400 | ENR | Russell M Elliott | 2003-09-13 | UHC-96694-14 | 4856780673 | 1646 Grand Ave, Atlanta, GA, 30330 | 0.54 | Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+1 more |
| ENR-105721 | ENR | Judy B Rose | 1960-02-14 | UHC-80661-85 | 6613165160 | 1226 Highland Ave # 942, Sacramento, CA, 95865 | 0.54 | SSN last four extractedUnit split from streetCity re-casedGender normalised+1 more |
| ENR-116784 | ENR | James Jordan | 1997-05-17 | UHC-70442-50 | — | 9233 Valley View Dr, Columbus, OH | 0.54 | Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+1 more |
| ENR-116030 | ENR | Maria Matthews | 1967-12-24 | UHC-24311-20 | 9173203898 | 380 Oak St, Minneapolis, MN, 55459 | 0.54 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more |
| ENR-106429 | ENR | Mateo K Romero | 1974-12-01 | UHC-51186-24 | 5362128275 | 1501 Bayshore Dr # 237, Scottsdale, AZ | 0.54 | Name split from “Last, First”Phone reformattedUnit split from streetZIP missing+1 more |
| ENR-123411 | ENR | Donald E Burns | 1976-06-18 | UHC-07422-52 | 5682396235 | 887 Mesa Dr Apt 27, Fresno, CA, 93780 | 0.54 | Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more |
| ENR-131085 | ENR | Isabella D Cen | 1952-04-22 | UHC-16836-61 | 2087295520 | 577 Willow Ct, Tempe, AZ, 85260 | 0.54 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| ENR-127675 | ENR | Lori W Johnston | 1998-12-05 | UHC-64408-29 | 6603641977 | 9855 Valley View Dr, Sacramento, CA, 95866 | 0.54 | Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more |
| ENR-139623 | ENR | Sophia Lynch | 1950-05-02 | UHC-90674-61 | — | 8743 Baseline Rd, Eden Prairie, MN, 55315 | 0.54 | Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more |
| ENR-126489 | ENR | Julia O Rice | 1993-04-10 | UHC-46090-42 | 2637214551 | 2155 Valley View Dr Apt 28, Fresno, CA, 93782 | 0.54 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+1 more |
| ENR-128241 | ENR | Bruce Gerza | 1983-07-07 | UHC-57480-49 | 6598322932 | 5857 Spring St, Houston, TX, 77056 | 0.54 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+7 more |
| ENR-125536 | ENR | Noah Ellis | 1958-05-02 | UHC-84589-07 | 6472567487 | 7018 Maple Ave, Denver, CO, 80271 | 0.54 | Date of birth reformattedState name converted to codeZIP+4 trimmedGender normalised+1 more |
| ENR-102722 | ENR | Evelyn A Fields | 1942-02-14 | UHC-07087-25 | 2473025562 | 7549 Indian School Rd, Phoenix, AZ | 0.54 | Name re-casedDate of birth reformattedSSN last four extractedState name converted to code+1 more |
| ENR-107146 | ENR | Nicole Cunningham | 2005-01-02 | UHC-10640-05 | — | 7972 Meadow Ln, Phoenix, AZ, 85087 | 0.54 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more |
| ENR-125701 | ENR | Angela Flores | 1985-04-07 | UHC-81159-03 | — | 9795 Washington St Apt 26, Los Angeles, CA, 90021 | 0.54 | Date of birth reformattedSSN last four extractedUnit split from streetEmail lower-cased+1 more |
| ENR-110081 | ENR | Peter Kelly | 1981-07-09 | UHC-28833-25 | 5439815708 | 8295 Mountain View Dr, Las Vegas, NV, 89106 | 0.54 | Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+1 more |
| ENR-103292 | ENR | Raymond V Gardner | 1993-02-28 | UHC-88401-12 | 6157979686 | 1901 Baseline Rd, Denver, CO, 80242 | 0.54 | Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more |
| ENR-127485 | ENR | Michelle R Carpenter | 1960-07-18 | UHC-05548-92 | 6545111132 | 8637 Ocean Ave Apt 21, Chandler, AZ, 85278 | 0.54 | Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more |