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-125851 | ENR | Nicole D Carlson | 1941-10-20 | UHC-64211-07 | 3498869262 | 8802 Pine Dr, Tampa, FL | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-131233 | ENR | Jose Nelon | 1986-01-14 | UHC-60100-97 | 9797179244 | 2966 Grand Ave, Nashville, TN, 37272 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-113895 | ENR | Randy Daniels | 1944-06-11 | UHC-90910-84 | 3882163376 | 4653 Highland Ave, Austin, TX | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+4 more |
| ENR-105438 | ENR | Kenneth I Obrien | 1948-04-17 | UHC-17109-44 | — | 8106 Cedar Ln, Charlotte, NC, 28212 | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-122906 | ENR | Danielle D Ramirez | 1949-12-02 | UHC-85416-89 | 8719596553 | 8096 Harbor Blvd, Tampa, FL, 33638 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-135401 | ENR | Ruth Young | 2000-10-28 | UHC-70377-81 | 6558933083 | 335 Desert Sky Blvd, Gilbert, AZ, 85226 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-138893 | ENR | Frank T Kelly | 1989-04-25 | UHC-92048-52 | 6578094632 | 7013 Cedar Ln, Glendale, AZ, 85370 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-123639 | ENR | Sofia Ramirez | 1976-11-13 | UHC-92206-23 | 4826615372 | 8190 Camelback Rd Apt 37, Jacksonville, FL, 32240 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-141526 | ENR | Sharon I Ferguson | 1959-06-22 | UHC-64402-07 | 8356886134 | 4479 Ocean Ave, Columbus, OH, 43204 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-125501 | ENR | Marilyn Ray | 1980-11-13 | UHC-54757-66 | 9055771398 | 6694 Sage Ct, Charlotte, NC, 28294 | 0.48 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more |
| ENR-124290 | ENR | Patricia P Bennett | 1940-07-21 | UHC-77422-61 | 4983143138 | 8570 Valley View Dr, San Diego, CA, 92131 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-115786 | ENR | Angela A Greene | 1952-05-01 | UHC-77777-60 | — | 3078 Sage Ct Apt 17, San Antonio, TX, 78265 | 0.48 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-137819 | ENR | Nathan Simmons | 2006-11-07 | UHC-16405-99 | 2585976713 | 1715 Union St # 215, Tucson, AZ, 85759 | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-135838 | ENR | Jeffrey Obrien | 1967-04-14 | UHC-07591-74 | 3839097191 | 2023 Washington St, Miami, FL, 33174 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-138449 | ENR | Dorothy H Fowler | 2003-08-04 | UHC-66322-93 | 4797761106 | 1971 Ridge Rd, Los Angeles, CA, 90002 | 0.48 | Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+4 more |
| ENR-138450 | ENR | Dorothy H Fowler | 2003-08-04 | UHC-66322-93 | 4797761106 | 1971 Ridge Rd, Los Angeles, CA, 90002 | 0.48 | Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+4 more |
| ENR-128799 | ENR | Carol X Webb | 1993-12-23 | UHC-87566-86 | 4518603749 | 2396 Washington St # 929, Chandler, AZ, 85235 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-137803 | ENR | Jonathan Z Ramirez | 1962-03-14 | UHC-25636-58 | 2168636861 | 995 Spring St, Columbus, OH, 43276 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-136665 | ENR | Nancy James | 1956-09-17 | UHC-08079-42 | 3142689346 | 8005 River Rd, Orlando, FL, 32828 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-116613 | ENR | Omar Bakr | 1982-12-17 | UHC-82232-61 | 7946955898 | 5030 Desert Sky Blvd, Orlando, FL | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-115506 | ENR | Teresa Knight | 1969-10-26 | — | 6985405208 | 9898 Apache Blvd, Mesa, AZ, 85208 | 0.48 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111922 | ENR | Sophia Harris | 1939-08-24 | UHC-07069-71 | 6179012513 | 8447 Camelback Rd, Tampa, FL, 33665 | 0.48 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-106033 | ENR | Elizabeth W Reed | 1994-09-12 | UHC-75188-50 | 8916442972 | 9403 Cedar Ln Apt 28, Seattle, WA, 98112 | 0.48 | Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-128703 | ENR | Ryan Burke | 2000-08-12 | UHC-76409-12 | 3333786791 | 6464 Camelback Rd, San Diego, CA, 92169 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-103950 | ENR | Peter Ryan | 1976-02-24 | UHC-07246-05 | 5517228705 | 5547 River Rd # 281, Tampa, FL, 33696 | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-138091 | ENR | Isabella A Walsh | 2006-04-16 | UHC-62689-44 | 3472483522 | 656 Cedar Ln, Seattle, WA, 98178 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-107327 | ENR | Wayne Payne | 1944-02-02 | UHC-86755-25 | 2794497156 | 8680 Elm St, Seattle, WA, 98118 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111234 | ENR | Tyler Thomas | 1948-08-01 | UHC-19916-14 | 7237238977 | 6416 Pine Dr, San Antonio, TX | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-125587 | ENR | Donna Luna | 1994-02-02 | — | 9639893508 | 4405 Willow Ct Apt 19, Eden Prairie, MN, 55333 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-116126 | ENR | Ralph Bowman | 1941-08-25 | UHC-50182-69 | 5895560311 | 8891 Camelback Rd, Dallas, TX | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-116476 | ENR | Arthur V Santiago | 1957-01-17 | UHC-93303-99 | 4239085680 | 8326 Main St, Tempe, AZ, 85260 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-108165 | ENR | Kathryn Ramirez | — | UHC-00624-02 | 8616212548 | 9294 Park Pl, Gilbert, AZ, 85281 | 0.48 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-139588 | ENR | Catherine Riley | 1999-11-09 | UHC-20404-24 | 5239039881 | 7227 Canyon Rd, Mesa, AZ | 0.48 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111577 | ENR | Karen F Jackson | 1947-05-22 | UHC-05379-68 | 8543379329 | 1428 Jefferson Ave, Los Angeles, CA, 90023 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-114138 | ENR | Lauren Perry | — | UHC-79257-94 | 9664326969 | 1166 Camelback Rd, Eden Prairie, MN, 55300 | 0.48 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| ENR-128852 | ENR | Douglas Q Perry | 1979-03-18 | UHC-12328-71 | 3826546399 | 1326 Apache Blvd Apt 37, Austin, TX, 78772 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-113751 | ENR | Olivia Riz | 1980-03-08 | UHC-33228-23 | 2839755211 | 4821 Market St, Austin, TX, 78765 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-124461 | ENR | Debra Y Ortega | 1998-11-09 | UHC-53202-94 | 2993726462 | 3452 Meadow Ln, Orlando, FL | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-104311 | ENR | Scott Barnes | 1999-01-19 | UHC-33275-94 | 6877396692 | 8037 Forest Ave, Chandler, AZ, 85280 | 0.48 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-106646 | ENR | Diana O Harrison | 1966-08-06 | UHC-09874-03 | 4013185529 | 7744 Central Ave, Gilbert, AZ | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-123936 | ENR | Dylan C Reed | 2005-08-19 | UHC-39800-75 | 3157449919 | 4465 Desert Sky Blvd # 550, Austin, TX, 78735 | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-126954 | ENR | Dot Hall | — | UHC-15763-54 | 8307841334 | 6357 Highland Ave, Las Vegas, NV | 0.48 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-114204 | ENR | Benjamin Turner | 1949-04-08 | UHC-47719-18 | 3579393116 | 3818 Canyon Rd # 799, Tempe, AZ, 85282 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more |
| ENR-107721 | ENR | Ralph R Williamson | 1987-07-26 | — | 4805300172 | 1667 Palm Dr # 816, Scottsdale, AZ, 85254 | 0.48 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-105038 | ENR | Timothy P Reed | 1952-01-06 | UHC-12264-39 | — | 6718 Lincoln Way, Miami, FL, 33103 | 0.48 | Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+4 more |
| ENR-103739 | ENR | Elizabeth Mendez | 1941-01-06 | UHC-68235-58 | 8786261987 | 6053 Church St, Tampa, FL | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-107203 | ENR | Emily R Lopez | 1943-12-14 | UHC-00216-34 | 6468353919 | 6843 Camelback Rd Apt 4, Chandler, AZ | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-141053 | ENR | Thomas M Luna | 1997-10-20 | UHC-95083-87 | 8886275690 | 4011 Main St, Orlando, FL, 32803 | 0.48 | Middle initial moved out of first nameName re-casedPhone reformattedCity re-cased+4 more |
| ENR-102759 | ENR | Cynthia L George | 1997-10-13 | UHC-88626-78 | — | 8035 Lincoln Way, Los Angeles, CA, 90033 | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-130538 | ENR | Jon Petersun | 1958-09-11 | UHC-98787-15 | 3702107906 | 8169 Sunset Blvd, Houston, TX, 77071 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |