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-141654 | ENR | Ann Contreras | 1970-02-27 | UHC-63950-59 | 2697234445 | 7875 Willow Ct, Atlanta, GA | 0.50 | Phone reformattedCity re-casedState name converted to codeZIP missing+3 more |
| ENR-102779 | ENR | Alexis Mejia | — | UHC-10534-16 | — | 530 Baseline Rd, Tucson, AZ | 0.50 | Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| ENR-101378 | ENR | Jack H Hudson | 1946-12-16 | UHC-98393-26 | 7088010615 | 5259 River Rd, Gilbert, AZ, 85265 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121181 | ENR | Jeremy Aguilar | 1979-11-21 | UHC-85770-80 | 9342961966 | 7625 Palm Dr, Jacksonville, FL, 32291 | 0.50 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-106851 | ENR | Catherine U Kelly | 1960-03-04 | UHC-17734-12 | — | 4121 Mesa Dr, Las Vegas, NV, 89111 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-118827 | ENR | Steve B Hayes | 1945-03-09 | UHC-96739-90 | 8712752032 | 5994 Willow Ct, Scottsdale, AZ, 85264 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-129652 | ENR | Debra C Rose | 1955-05-23 | UHC-38793-80 | 7968564591 | 7416 Baseline Rd Apt 36, Mesa, AZ, 85276 | 0.50 | Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-126984 | ENR | Carlos Romero | 1943-09-23 | UHC-75490-39 | 2945297620 | 5637 Market St, Tampa, FL, 33647 | 0.50 | Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-142492 | ENR | Rebecca E Morrison | 1959-09-24 | UHC-30681-21 | — | 4518 Forest Ave, Tucson, AZ, 85786 | 0.50 | Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-138234 | ENR | Alice I Hart | 1957-07-10 | UHC-33459-59 | 7732208712 | 1510 Valley View Dr, Nashville, TN, 37218 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more |
| ENR-141361 | ENR | Lucia Mendoza | 1965-02-03 | UHC-92600-02 | 3794803350 | 3079 Sunset Blvd Apt 13, Tucson, AZ, 85764 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-125631 | ENR | Bruce Gardner | 2004-09-23 | UHC-64895-23 | 3323250616 | 5610 Hillcrest Rd, Fresno, CA, 93761 | 0.50 | Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-128870 | ENR | Matthew V Singh | 1993-08-04 | UHC-24784-52 | 3115496451 | 1811 Indian School Rd, Charlotte, NC, 28257 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-121033 | ENR | Carl R Jones | 1962-07-01 | UHC-55397-66 | 5858323621 | 2044 Washington St, Dallas, TX, 75233 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-116175 | ENR | Jennifer C Ryan | — | UHC-62129-57 | 5835253371 | 4040 Sunset Blvd, San Antonio, TX, 78250 | 0.50 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135527 | ENR | Zachary M Watkins | 1994-12-18 | UHC-59413-90 | 6412762106 | 1963 Highland Ave, Austin, TX | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-105517 | ENR | Jonatan F Wells | 1997-04-19 | UHC-50263-53 | 6818072026 | 9341 Church St, Seattle, WA, 98160 | 0.50 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-138382 | ENR | Jennifer H Fisher | 2007-10-13 | UHC-19102-39 | — | 3860 Ocean Ave, Tempe, AZ | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-122210 | ENR | Christina P Johnston | 1963-07-26 | UHC-64381-56 | 6522430840 | 1967 Central Ave, Jacksonville, FL, 32245 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-132573 | ENR | Jon Q Dominguez | 1965-02-16 | UHC-49789-89 | 8805625569 | 1946 Valley View Dr, Las Vegas, NV, 89181 | 0.50 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-134567 | ENR | Carlos Clark | 1975-12-08 | UHC-35686-87 | 6917465857 | 3497 Church St, Miami, FL | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133709 | ENR | Doris Kelly | 1957-03-07 | UHC-00217-48 | 3952726980 | 9827 Highland Ave, Seattle, WA, 98162 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-127869 | ENR | Gary Peters | 1954-08-17 | — | 5129654132 | 355 Mesa Dr, Plano, TX, 75001 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-107133 | ENR | Elijah Q Cox | 1986-06-28 | UHC-15378-08 | 7087550164 | 5551 Main St # 267, Jacksonville, FL | 0.50 | Phone reformattedUnit split from streetCity re-casedZIP missing+3 more |
| ENR-105940 | ENR | Randy T Schultz | 1945-01-18 | UHC-67392-09 | — | 5172 Cedar Ln, Plano, TX, 75049 | 0.50 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100514 | ENR | Bobby C Gilbert | 2001-02-27 | UHC-67259-66 | 3642810070 | 6310 Grand Ave, Dallas, TX, 75253 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-101798 | ENR | Amy Graham | 1942-12-08 | UHC-93467-22 | 8128178278 | 3276 Oak St, Seattle, WA, 98148 | 0.50 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-106432 | ENR | Mei A Mendez | 1939-01-11 | UHC-90033-13 | 8557633406 | 612 Hillcrest Rd Apt 11, Charlotte, NC, 28248 | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-116957 | ENR | Amber E Reyes | — | UHC-63044-27 | 3525515883 | 6206 Ridge Rd, Minneapolis, MN, 55411 | 0.50 | Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-109278 | ENR | Pamela Mitchell | — | UHC-76970-81 | 7883541894 | 5418 River Rd, Phoenix, AZ, 85073 | 0.50 | Date of birth unreadablePhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-124656 | ENR | Hannah K Owens | 1946-10-28 | UHC-20754-86 | 4273007464 | 6773 Willow Ct Apt 38, Orlando, FL, 32804 | 0.50 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-125174 | ENR | Isabella K Aguiilar | — | — | — | 839 Mesa Dr Apt 12, Austin, TX, 78756 | 0.50 | Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more |
| ENR-128099 | ENR | Ralph A Jimenez | 1989-07-12 | UHC-36480-49 | 4026440112 | 5171 Desert Sky Blvd, Los Angeles, CA, 90063 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-105215 | ENR | Arjun Ray | 1963-03-12 | UHC-68947-52 | 7157705127 | 5602 Camelback Rd Apt 8, Atlanta, GA, 30305 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-102180 | ENR | Donald G Ross | 1997-12-09 | UHC-84152-83 | — | 223 Indian School Rd, Charlotte, NC, 28201 | 0.50 | Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more |
| ENR-116797 | ENR | Sophia K Robertson | 1942-08-12 | UHC-82419-72 | — | 5540 Hillcrest Rd, Austin, TX, 78703 | 0.50 | Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+3 more |
| ENR-110260 | ENR | Peter M Gonzalez | 1995-02-07 | UHC-67948-80 | — | 6218 Mesa Dr Apt 12, Scottsdale, AZ, 85246 | 0.50 | Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+3 more |
| ENR-102257 | ENR | Alex R Marquez | 1969-06-04 | UHC-60235-82 | 7552837449 | 5581 Lincoln Way, Minneapolis, MN, 55413 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-130510 | ENR | Ahmed I Hayes | 1998-05-03 | UHC-61342-46 | 4545116766 | 896 Bayshore Dr Apt 38, Plano, TX, 75056 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-107657 | ENR | Bryan V Carr | 1959-11-01 | UHC-84837-95 | 9384882231 | 7382 Pine Dr, Atlanta, GA, 30349 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-129663 | ENR | Deborah W Willis | 1975-02-17 | UHC-78282-13 | 2116727261 | 2399 Harbor Blvd, Miami, FL | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133627 | ENR | Roger E Ortiz | 1980-03-26 | UHC-11679-61 | 5107334364 | 3575 Baseline Rd, Austin, TX | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-120166 | ENR | Danielle Sims | 1961-10-28 | UHC-89107-01 | 2394757039 | 3165 Willow Ct Apt 40, Tampa, FL, 33607 | 0.50 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-128771 | ENR | Jeffrey W Harrison | 1942-09-28 | UHC-17502-07 | 5592909024 | 6635 Canyon Rd, Las Vegas, NV | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-141061 | ENR | Margaret T Watson | 2007-04-27 | UHC-53720-04 | 7522404124 | 5608 Elm St # 807, Orlando, FL, 32883 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-139380 | ENR | Olivia S Jackson | 1939-08-05 | UHC-00850-94 | 5626698509 | 8395 Highland Ave # 437, Dallas, TX, 75286 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-134762 | ENR | Nathan S Kennedy | 1971-07-24 | UHC-94717-31 | 9524210645 | 1676 Spring St, Mesa, AZ, 85244 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more |
| ENR-137919 | ENR | Hannah Valdez | 1969-03-27 | UHC-12876-94 | — | 4569 Baseline Rd, Glendale, AZ, 85357 | 0.50 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-107574 | ENR | Billy W King | 1968-10-17 | UHC-34428-44 | 7933475889 | 381 Sage Ct, Houston, TX, 77098 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-141175 | ENR | Elizabeth D Matthews | 1994-08-26 | UHC-83163-59 | 6257599798 | 8220 Bayshore Dr, Orlando, FL, 32855 | 0.50 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |