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-137351 | ENR | Harold B Sanders | 2006-04-26 | UHC-57938-52 | 6742296498 | 498 Park Pl # 337, Sacramento, CA, 95813 | 0.52 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-122916 | ENR | Helen Wallace | 2006-03-25 | UHC-46407-62 | — | 8344 Mountain View Dr, Phoenix, AZ, 85029 | 0.52 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-126755 | ENR | Evelyn Ramos | — | UHC-70497-07 | 6395603325 | 8644 Elm St, Plano, TX | 0.52 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-109888 | ENR | Juan Tran | 2007-06-20 | UHC-08444-39 | 4312024556 | 354 Central Ave # 791, Plano, TX, 75047 | 0.52 | Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-101149 | ENR | Kayla M Chavez | — | UHC-09981-99 | 3549727209 | 8478 Oak St Apt 10, Las Vegas, NV, 89198 | 0.52 | Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-101975 | ENR | Amy R Hawkins | 1994-05-13 | UHC-63576-09 | 8703173142 | 6772 Hillcrest Rd Apt 11, Charlotte, NC, 28267 | 0.52 | Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-130316 | ENR | Katherine H Rose | — | UHC-31860-41 | — | 2876 Oak St, Denver, CO, 80221 | 0.52 | Name re-casedDate of birth missingPhone missing area codeStreet suffix standardised+2 more |
| ENR-114962 | ENR | Heather Garza | 1983-04-15 | UHC-85505-93 | 6279480819 | 7382 Baseline Rd, Phoenix, AZ, 85013 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-130367 | ENR | Grace Montgomery | 1984-02-21 | UHC-74716-17 | 5928770083 | 592 Mountain View Dr, Fresno, CA, 93779 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-101874 | ENR | Keelly Williamson | 2002-09-08 | UHC-46667-30 | 7472615600 | 9407 Union St, Chandler, AZ | 0.52 | Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-125082 | ENR | Barbara Espinoza | 1953-03-07 | UHC-74131-02 | 9274297274 | 1702 Lincoln Way, Jacksonville, FL, 32214 | 0.52 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-111330 | ENR | George Patterson | 1983-02-09 | UHC-34242-48 | 6085125623 | 5376 Central Ave # 493, San Antonio, TX, 78205 | 0.52 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-114606 | ENR | Eric T Bowman | 1950-05-23 | UHC-56333-05 | 4509303605 | 8419 Central Ave # 287, Nashville, TN, 37296 | 0.52 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-129562 | ENR | Theresa U Hicks | 1969-02-09 | UHC-01574-14 | — | 1799 Highland Ave, Jacksonville, FL, 32208 | 0.52 | Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+2 more |
| ENR-106103 | ENR | Ethan I Wright | 1967-03-17 | UHC-95641-05 | 4084110063 | 8968 Main St, Mesa, AZ, 85298 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-130684 | ENR | Kevin X Guerrero | 1985-05-16 | UHC-46668-36 | 3487841390 | 2840 Apache Blvd, Dallas, TX | 0.52 | Two-digit birth yearPhone reformattedZIP missingGender normalised+2 more |
| ENR-113108 | ENR | Lori T Ward | 1965-06-23 | UHC-57208-30 | — | 5185 Maple Ave, Denver, CO, 80271 | 0.52 | Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more |
| ENR-127855 | ENR | Betsy Parker | 1941-06-22 | UHC-00177-45 | — | 1852 Cedar Ln, Seattle, WA, 98141 | 0.52 | Member ID reformattedState name converted to codeZIP+4 trimmedGender normalised+2 more |
| ENR-108749 | ENR | Gabriel P Carter | — | UHC-25374-66 | 4296636011 | 7602 Spring St, Scottsdale, AZ, 85282 | 0.52 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more |
| ENR-127310 | ENR | Bryan Graham | 1999-09-04 | UHC-39222-66 | 7656448229 | 6502 Market St # 568, Charlotte, NC, 28239 | 0.52 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-126441 | ENR | Keith I Bailey | 1986-02-12 | UHC-91055-84 | 4839432401 | 1902 Park Pl, Seattle, WA | 0.52 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-128823 | ENR | Elijah N Payne | 2000-07-03 | UHC-20841-62 | — | 7940 Hillcrest Rd, Gilbert, AZ | 0.52 | Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more |
| ENR-113922 | ENR | Austin Pena | — | UHC-44306-49 | 5692406719 | 5302 Mountain View Dr, Glendale, AZ | 0.52 | Name re-casedDate of birth unreadablePhone reformattedZIP missing+2 more |
| ENR-126621 | ENR | Amber T Wellls | 1939-12-20 | UHC-53150-30 | 6122633391 | 7373 Jefferson Ave, Chandler, AZ, 85215 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-112534 | ENR | Jakke K Harvey | 1986-07-03 | UHC-64879-34 | 3143335770 | 5435 Highland Ave, Miami, FL | 0.52 | Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more |
| ENR-102426 | ENR | Isabella Bowman | 1953-10-22 | UHC-75417-10 | — | 1711 Union St, Chandler, AZ | 0.52 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-130397 | ENR | Klye Harper | 1997-08-03 | UHC-68942-57 | 2679801331 | 1435 Jefferson Ave Apt 25, Gilbert, AZ, 85294 | 0.52 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-108724 | ENR | Gabriel R Ross | 1982-07-27 | UHC-82385-43 | 4123747243 | 5064 Mesa Dr, Sacramento, CA, 95875 | 0.52 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-108725 | ENR | Gabriel R Ross | 1982-07-27 | UHC-82385-43 | 4123747243 | 5064 Mesa Dr, Sacramento, CA, 95875 | 0.52 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-136737 | ENR | Shirley Spencer | 1968-09-14 | UHC-49565-98 | 5578512458 | 4384 Lincoln Way Apt 22, Fresno, CA, 93780 | 0.52 | Phone reformattedUnit split from streetCity re-casedState name converted to code+2 more |
| ENR-112438 | ENR | Sandra Spencer | 1981-03-07 | UHC-91154-11 | 6327231292 | 2833 Willow Ct Apt 16, Chandler, AZ, 85292 | 0.52 | Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-117265 | ENR | Ronald D Daniels | 1943-03-18 | UHC-95529-06 | — | 2498 Oak St Apt 33, Plano, TX, 75033 | 0.52 | Name re-casedMember ID reformattedUnit split from streetZIP+4 trimmed+2 more |
| ENR-112667 | ENR | William V Vega | 1954-01-12 | UHC-29188-45 | 3369658563 | 6214 Main St, Chandler, AZ | 0.52 | Phone reformattedState name converted to codeZIP missingGender normalised+2 more |
| ENR-122295 | ENR | Frances R Bryant | 1955-04-02 | UHC-39441-14 | 5137105418 | 3296 Lake View Rd, Minneapolis, MN, 55446 | 0.52 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-139557 | ENR | Jesse D Wang | 1951-05-04 | UHC-64399-80 | 5627903791 | 4970 Grand Ave # 581, Chandler, AZ, 85245 | 0.52 | Middle initial moved out of first namePhone reformattedSSN last four extractedUnit split from street+2 more |
| ENR-130437 | ENR | Jennifer G Aguilar | 1942-11-23 | — | — | 3751 Forest Ave, Los Angeles, CA, 90061 | 0.52 | Phone missing area codeState name converted to codeZIP+4 trimmedEmail lower-cased+2 more |
| ENR-105409 | ENR | Anna D Moore | — | UHC-72564-32 | 9482750419 | 4022 Sage Ct, Plano, TX, 75007 | 0.52 | Name re-casedDate of birth missingPhone reformattedZIP+4 trimmed+2 more |
| ENR-104037 | ENR | Andrew Little | 1958-05-10 | UHC-87409-19 | 5946673145 | 7294 Spring St, Chandler, AZ | 0.52 | Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more |
| ENR-109526 | ENR | Heather K Arnold | 1939-10-06 | UHC-93459-97 | 5368191123 | 6480 Lincoln Way # 698, San Diego, CA, 92195 | 0.52 | Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased+2 more |
| ENR-113707 | ENR | YJunk | 1945-01-20 | UHC-61792-31 | — | 9312 Indian School Rd, Orlando, FL | 0.52 | Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+2 more |
| ENR-118282 | ENR | Mason G Young | 1971-01-20 | UHC-08186-30 | — | 1217 Oak St, Tempe, AZ, 85262 | 0.52 | Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more |
| ENR-113864 | ENR | Philip Butler | 1980-02-07 | UHC-93273-26 | 4819963678 | 6519 Baseline Rd, Jacksonville, FL | 0.52 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-121090 | ENR | Ethan Warren | 1983-03-11 | UHC-72208-50 | 5218903019 | 3131 Elm St, Sacramento, CA, 95803 | 0.52 | Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+2 more |
| ENR-119437 | ENR | Scott D Bryant | 1972-08-07 | UHC-95355-13 | 3943588150 | 2176 Broadway, San Antonio, TX, 78200 | 0.52 | Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+2 more |
| ENR-124921 | ENR | Lauren Washington | 1965-10-28 | UHC-74755-05 | — | 6518 Harbor Blvd, Scottsdale, AZ, 85232 | 0.52 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-108517 | ENR | John K Price | 1938-06-23 | UHC-15883-40 | 6757316404 | 8990 Canyon Rd, Tucson, AZ, 85781 | 0.52 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-135374 | ENR | Thomas M Anderson | 1965-04-13 | UHC-56943-80 | 5392978987 | 4269 Oak St, Tucson, AZ | 0.52 | Name re-casedPhone reformattedSSN last four extractedState name converted to code+2 more |
| ENR-124140 | ENR | Rachel Fields | — | UHC-87438-08 | — | 3746 Valley View Dr, Gilbert, AZ, 85210 | 0.52 | Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more |
| ENR-107274 | ENR | Nathan Tucker | 1982-07-18 | UHC-69609-12 | 5058955843 | 573 Union St, Houston, TX, 77009 | 0.52 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more |
| ENR-106259 | ENR | Megan Andrews | 1962-05-13 | UHC-94788-82 | — | 8147 Mesa Dr Apt 13, Jacksonville, FL, 32233 | 0.52 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |