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-115685 | ENR | Adams Julia | 1962-04-13 | UHC-29398-05 | 6208274753 | 4202 Cedar Ln, Atlanta, GA, 30386 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-133289 | ENR | Judy K Snyder | 2001-04-21 | UHC-49523-70 | 9553458882 | 4775 Baseline Rd, Austin, TX, 78741 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-113659 | ENR | Jacqueline V Olson | 1977-12-11 | UHC-32704-29 | 6016536648 | 908 Forest Ave, Denver, CO | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-131429 | ENR | Virginia J Alvarado | 1940-03-20 | UHC-84785-86 | 4643659626 | 6123 Desert Sky Blvd, Los Angeles, CA, 90081 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-130002 | ENR | Anthony Hunter | 2003-02-28 | UHC-08886-47 | 4328052034 | 7734 Desert Sky Blvd, Atlanta, GA, 30338 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-103871 | ENR | Gregory Lee | 1972-11-13 | UHC-72345-25 | 7274827948 | 3487 Ocean Ave, Atlanta, GA | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128660 | ENR | Joshua Phillips | 1955-12-12 | UHC-93601-34 | 9405027434 | 7125 Church St, Tempe, AZ, 85288 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-114889 | ENR | Noah Rice | 1947-02-23 | UHC-93860-84 | 4424630031 | 9386 Oak St, Denver, CO | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-114864 | ENR | James Contreras | 1986-01-04 | UHC-81579-21 | 5537684103 | 8536 Grand Ave, Denver, CO, 80283 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-109195 | ENR | Charles E Cunningham | 1960-01-21 | UHC-96805-50 | 4812390161 | 6946 Maple Ave, Scottsdale, AZ, 85248 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-139817 | ENR | Ashley Hunter | 1962-01-15 | UHC-27397-79 | — | 4675 Mesa Dr, Columbus, OH, 43203 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-139782 | ENR | Laura G Warren | 2001-07-17 | UHC-80409-15 | 2382379361 | 3061 Cedar Ln, Chandler, AZ, 85214 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-136986 | ENR | Tim L Walkar | — | UHC-34814-20 | 5833028834 | 5513 Baseline Rd, Denver, CO, 80252 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-142919 | ENR | Masno Ward | 1993-02-17 | UHC-71648-92 | 3827208216 | 2679 Camelback Rd, Jacksonville, FL, 32212 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-118128 | ENR | Vincent N Berry | 1966-04-10 | UHC-61036-70 | 3575393670 | 8119 Market St, Miami, FL, 33187 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-110175 | ENR | Kelly P Soctt | 1976-02-12 | UHC-34031-04 | — | 3517 River Rd, Columbus, OH, 43232 | 0.62 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-136307 | ENR | Mei O Simmons | 1958-08-08 | UHC-04938-96 | — | 3325 River Rd, Minneapolis, MN, 55419 | 0.62 | Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more |
| ENR-137461 | ENR | Yuki Robinson | 2000-03-09 | UHC-42724-58 | — | 5021 River Rd # 716, Fresno, CA, 93707 | 0.62 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-106523 | ENR | Keith D Ruiz | 1948-05-02 | UHC-75807-16 | 6564962285 | 5718 Mesa Dr # 484, Charlotte, NC, 28202 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-142735 | ENR | Robert W Ramos | 1946-11-20 | UHC-34491-97 | 2394537175 | 5876 Indian School Rd, San Antonio, TX, 78239 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-112777 | ENR | Jonathan M Patel | 1961-12-21 | UHC-08496-08 | 2478348380 | 4336 Desert Sky Blvd, Glendale, AZ, 85381 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-119983 | ENR | Ana Y Gutierrez | 1962-01-24 | UHC-95156-71 | 8076725741 | 4154 Valley View Dr, Columbus, OH, 43243 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-134958 | ENR | Laura Q Cllins | 1953-05-24 | UHC-74766-94 | 2935447716 | 9697 Ridge Rd, Scottsdale, AZ, 85292 | 0.62 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-131268 | ENR | Karen V Dominguez | 1973-11-12 | UHC-46479-04 | 4584982118 | 6164 Baseline Rd, Denver, CO, 80253 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-121132 | ENR | Lauren Simpson | 1988-04-10 | UHC-91816-32 | 2107913260 | 961 Baseline Rd, Tampa, FL, 33675 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-108422 | ENR | Randy Parker | 1965-08-23 | UHC-85362-22 | 4883071610 | 129 Meadow Ln # 701, Chandler, AZ, 85208 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-101526 | ENR | Daniel Banks | 1991-12-24 | UHC-92105-05 | 2725177889 | 8012 Palm Dr, Houston, TX, 77061 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-119506 | ENR | Jean T Hawkins | 1951-01-23 | UHC-05195-82 | 4764284509 | 4375 Ocean Ave, Tampa, FL, 33689 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110221 | ENR | Maria Z Burton | 1960-02-10 | — | — | 3568 Market St, Tampa, FL, 33685 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-110918 | ENR | Susan D Tran | 1973-09-27 | UHC-98859-82 | 4749544586 | 5965 Church St, Gilbert, AZ, 85272 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-126412 | ENR | Alan O Pierce | 1970-01-22 | UHC-35222-28 | 6773866375 | 4710 Camelback Rd, Charlotte, NC, 28235 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedEmail lower-cased+3 more |
| ENR-119092 | ENR | Victoria A Vasquez | 1971-07-24 | UHC-80479-60 | 4763186950 | 2460 Spring St, Minneapolis, MN, 55480 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-105267 | ENR | Jeffrey F Padilla | — | UHC-92939-82 | 8442770009 | 7220 Main St, Tampa, FL, 33639 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-137912 | ENR | Kimberly T Bell | 2003-09-01 | UHC-86763-22 | 5979033704 | 3424 Central Ave, Tempe, AZ, 85277 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-132561 | ENR | Walter Hoffman | 1983-11-01 | UHC-14510-58 | 9073910871 | 1576 Elm St, Orlando, FL, 32865 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-132534 | ENR | Jacqueline Z Garza | 2006-06-15 | UHC-87521-71 | 8207707369 | 5168 Mountain View Dr, Denver, CO, 80237 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-117093 | ENR | Kayla L Reid | 2003-09-12 | UHC-98078-99 | 9277256579 | 2115 Market St Apt 14, Sacramento, CA, 95845 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-114562 | ENR | Kelly Y Miller | 2002-02-21 | UHC-07876-34 | 9116778377 | 5278 Valley View Dr, Houston, TX, 77003 | 0.62 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-107635 | ENR | Nancy Delgado | 1953-06-14 | UHC-60245-45 | 4248420120 | 452 Harbor Blvd # 564, Nashville, TN, 37208 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-132183 | ENR | Stephen E Soto | 1957-10-24 | UHC-38096-98 | 3472630417 | 422 Indian School Rd, Austin, TX, 78749 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-126560 | ENR | Mary Hanson | 1998-04-23 | UHC-91491-66 | 8015075381 | 5348 Willow Ct, Gilbert, AZ, 85245 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-128902 | ENR | Elizabeth A Garza | 2006-09-21 | UHC-52036-07 | 2866960785 | 8630 Grand Ave, Sacramento, CA, 95848 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-142929 | ENR | Wayne G Watkins | 1940-04-26 | UHC-07200-64 | 6297601417 | 1841 Sunset Blvd, Fresno, CA, 93780 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-107075 | ENR | Madison S Alexander | 1945-12-15 | UHC-17993-59 | 8626521869 | 5595 Maple Ave, Nashville, TN | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-115069 | ENR | Theresa Jimenez | 1971-10-04 | UHC-78147-56 | 6714102997 | 3652 River Rd, Fresno, CA | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120756 | ENR | Pamela Lucas | 1941-05-22 | UHC-69961-09 | 5538783842 | 4795 Willow Ct, Chandler, AZ, 85281 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-134035 | ENR | Carl Clark | 1964-10-03 | UHC-07708-62 | 8978020594 | 8835 Apache Blvd, Glendale, AZ, 85355 | 0.62 | Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-134715 | ENR | Bobby N Dean | 1941-05-26 | UHC-81117-27 | 4083330786 | 717 Valley View Dr, Jacksonville, FL | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-115364 | ENR | Julia Y Weber | — | UHC-09690-48 | 2484848500 | 8937 Palm Dr, Seattle, WA, 98139 | 0.62 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more |
| ENR-132423 | ENR | Janet Day | 1946-07-04 | UHC-28021-59 | 2916485558 | 3042 Jefferson Ave Apt 21, Plano, TX, 75032 | 0.62 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more |