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-125176 | ENR | Julia W Alexander | 1993-08-02 | UHC-68877-99 | 9676340616 | 5257 Elm St, Gilbert, AZ, 85225 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-119642 | ENR | Alice Dunn | 1951-08-31 | UHC-54642-58 | 6624842981 | 1060 Ocean Ave, Tucson, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-137644 | ENR | Brian G Lawson | 1971-05-27 | UHC-35027-61 | 3247113726 | 5362 Central Ave # 719, Seattle, WA, 98158 | 0.62 | Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+3 more |
| ENR-130342 | ENR | Joose T Arnold | 1973-03-20 | UHC-02380-94 | 7735759385 | 9748 Lake View Rd, Nashville, TN, 37247 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-112096 | ENR | Juan M Murphy | 1973-10-03 | UHC-80089-58 | 6846278951 | 147 Canyon Rd, Tampa, FL, 33668 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-137596 | ENR | Doris I Miller | 1998-09-08 | UHC-16373-92 | — | 940 Hillcrest Rd, Glendale, AZ | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-123150 | ENR | Tim O Lewis | 1971-11-25 | UHC-64916-92 | 9272053777 | 9046 Pine Dr, Tucson, AZ | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-120898 | ENR | Robart Fox | 1996-04-01 | UHC-32636-14 | 5627367957 | 2975 Willow Ct, Plano, TX, 75049 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-114519 | ENR | Ana H Delgado | 1953-02-25 | UHC-67015-12 | 5876338278 | 1797 Oak St, Las Vegas, NV, 89167 | 0.62 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-123846 | ENR | Ashley YJunk | 1953-01-27 | UHC-59839-26 | 2776098852 | 4201 Broadway Apt 25, Dallas, TX, 75202 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-123748 | ENR | Alan Taylor | 1989-01-21 | UHC-11805-29 | 2647281586 | 8147 Forest Ave, Columbus, OH | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-104504 | ENR | Joyce W Freeman | 1965-06-18 | UHC-73473-38 | — | 5091 Park Pl, Plano, TX, 75048 | 0.62 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-105203 | ENR | Andrea D Alvarado | 2001-04-04 | UHC-47319-34 | 8396574728 | 5259 Pine Dr, Mesa, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-140677 | ENR | Ommar Chen | 1995-12-06 | UHC-49844-02 | 6446785403 | 3734 River Rd, Las Vegas, NV | 0.62 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-123686 | ENR | Sophia U Butler | 1987-10-25 | UHC-99861-22 | 3664485881 | 8857 Washington St Apt 18, Orlando, FL, 32847 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-112107 | ENR | Donna G Porter | 1942-05-20 | UHC-49476-54 | 8704162777 | 6116 Union St, Eden Prairie, MN, 55338 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-107483 | ENR | Ruth Z Hanson | 1985-06-06 | UHC-73022-03 | 8265345553 | 3317 Church St # 997, Tempe, AZ, 85236 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-123045 | ENR | Daniel Q Mendez | 1958-11-04 | UHC-21332-78 | — | 1144 Main St, Columbus, OH, 43225 | 0.62 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-126011 | ENR | Douglas Rice | 1968-09-12 | UHC-71875-98 | 8242225479 | 6348 Pine Dr, Chandler, AZ, 85274 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123003 | ENR | Christopher E Guerrero | 1990-08-04 | UHC-94197-05 | 5863839700 | 7502 Forest Ave, Scottsdale, AZ, 85226 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-126540 | ENR | Scott P Hughes | 1958-01-10 | UHC-53716-26 | 8217485157 | 5069 Lincoln Way # 614, Orlando, FL, 32854 | 0.62 | Name re-casedPhone reformattedUnit split from streetZIP+4 trimmed+3 more |
| ENR-139407 | ENR | Michael P Kelly | 1947-10-06 | UHC-06332-53 | 8253696341 | 882 Bayshore Dr, Gilbert, AZ, 85248 | 0.62 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-135391 | ENR | Lisa D Day | 1967-05-26 | UHC-41010-93 | 3842790938 | 263 Lake View Rd, Las Vegas, NV, 89182 | 0.62 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-127018 | ENR | Marcus Burton | 1943-08-27 | UHC-55090-52 | 5403331117 | 2437 Maple Ave # 190, Atlanta, GA, 30371 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-141984 | ENR | Amber Garrett | 1965-02-08 | UHC-76042-07 | 3824190602 | 7536 Park Pl, Atlanta, GA, 30344 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100906 | ENR | Melissa H Espinoza | 1953-11-24 | — | 6583065744 | 7482 Mesa Dr, Glendale, AZ, 85307 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more |
| ENR-104646 | ENR | Dennis H Larson | 1965-09-05 | UHC-54035-72 | 5948665211 | 290 Camelback Rd, Charlotte, NC, 28272 | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-129591 | ENR | George Z Flores | 1959-01-16 | — | — | 8251 Pine Dr, Jacksonville, FL, 32280 | 0.62 | Name re-casedDate of birth reformattedPhone missing area codeEmail lower-cased+3 more |
| ENR-124389 | ENR | Virginia Hudson | — | UHC-37938-14 | 2086577829 | 5068 Ocean Ave, Dallas, TX, 75218 | 0.62 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-118638 | ENR | Danielle V Adrews | 2006-04-02 | UHC-00916-15 | 5888328982 | 621 Lincoln Way, Scottsdale, AZ, 85265 | 0.62 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-118637 | ENR | Danielle V Adrews | 2006-04-02 | UHC-00916-15 | 5888328982 | 621 Lincoln Way, Scottsdale, AZ, 85265 | 0.62 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-122565 | ENR | Douglas M Warren | 1991-06-26 | UHC-26450-16 | — | 3878 Ridge Rd, Fresno, CA, 93763 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-134595 | ENR | Alebrt Davis | 1967-03-19 | UHC-04648-46 | 4118816471 | 8504 Hillcrest Rd, Denver, CO, 80265 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-119392 | ENR | Badley P Romero | 1985-08-13 | UHC-50584-68 | 4967671528 | 4722 Harbor Blvd, Minneapolis, MN, 55495 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109869 | ENR | Carlos James | 1965-03-09 | UHC-97252-40 | — | 9833 Sunset Blvd, Charlotte, NC | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-137077 | ENR | Harold Wood | 1991-04-19 | UHC-31679-43 | 4492035714 | 9393 Oak St, San Diego, CA, 92167 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-117343 | ENR | Noah L Hawkins | 1975-10-12 | UHC-16115-52 | — | 3221 Union St, San Antonio, TX, 78286 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-123816 | ENR | Zachary Allen | 1976-03-16 | UHC-86497-60 | 3985951599 | 6378 Willow Ct, Eden Prairie, MN, 55386 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-101389 | ENR | Aaron Hawkins | 1970-07-25 | UHC-72312-42 | 2492850607 | 6354 Harbor Blvd, Miami, FL, 33129 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-100491 | ENR | Patrycia X Mitchell | 2008-09-01 | UHC-58066-27 | 8837566993 | 513 Hillcrest Rd, Gilbert, AZ, 85298 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-108177 | ENR | Frank Armstrong | 1977-11-07 | UHC-73728-14 | 4797228556 | 8373 Mesa Dr, Seattle, WA, 98100 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-130084 | ENR | Bobby T Powell | 1941-09-10 | UHC-35845-09 | 5786488115 | 4683 Camelback Rd, Sacramento, CA | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-129886 | ENR | Yuki F Butler | 1940-05-28 | UHC-90674-99 | 4089536301 | 8684 Jefferson Ave, San Diego, CA, 92133 | 0.62 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-113946 | ENR | Adam Gonzales | 1951-10-22 | UHC-93372-22 | 3228815170 | 9870 Forest Ave, San Diego, CA, 92135 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133579 | ENR | Alexis Vasquez | 1968-08-12 | UHC-44563-43 | 7719250588 | 6026 Ocean Ave, Chandler, AZ, 85241 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120702 | ENR | Bradley Guerrero | 1986-06-12 | UHC-50760-89 | 9515949156 | 7868 Park Pl, Denver, CO, 80273 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-118525 | ENR | Christine D Santiago | 1966-11-12 | UHC-68644-80 | 8286939932 | 3894 Highland Ave, Orlando, FL, 32899 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-103752 | ENR | Abigail Delgado | 1982-01-21 | UHC-12714-29 | 7006675049 | 3553 Willow Ct, Gilbert, AZ, 85200 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-124797 | ENR | Walter Robertson | 1981-06-24 | UHC-87465-35 | 4146738052 | 7128 Lake View Rd, Austin, TX, 78780 | 0.62 | Name re-casedPhone reformattedCity re-casedState name converted to code+3 more |
| ENR-135667 | ENR | Kevin Wilson | 1960-09-02 | UHC-38865-86 | 3382769328 | 2872 Willow Ct, Phoenix, AZ | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |