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-123356 | ENR | Theresa L Garza | 1942-10-28 | UHC-29869-56 | — | 877 Cedar Ln, Atlanta, GA, 30319 | 0.50 | Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| ENR-103455 | ENR | Ronald G Vazzquez | 1988-04-12 | UHC-64583-35 | — | 8925 Meadow Ln, Los Angeles, CA, 90001 | 0.50 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-124044 | ENR | Raymond X Ray | 1945-12-26 | UHC-65599-35 | 4395608021 | 1736 Desert Sky Blvd, Charlotte, NC | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-118131 | ENR | Kimberly Q Jordan | — | UHC-39395-07 | 5847385899 | 6477 Palm Dr, Charlotte, NC, 28207 | 0.50 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-132317 | ENR | Mei Miller | 1991-09-01 | UHC-81458-82 | 6059998900 | 7675 Central Ave, Atlanta, GA, 30331 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-125785 | ENR | Hannah Morales | 2008-03-17 | UHC-26431-55 | 6363160943 | 3620 Main St, Atlanta, GA, 30316 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112374 | ENR | Isabella Berry | 1945-04-01 | UHC-10949-47 | 6863928550 | 8659 Sage Ct, Tucson, AZ, 85722 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109709 | ENR | Barbara C Gibson | 2001-09-07 | UHC-31992-36 | 2492470431 | 2335 Willow Ct, Gilbert, AZ, 85288 | 0.50 | Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more |
| ENR-101628 | ENR | Kimberly Harris | 1959-04-24 | UHC-10041-73 | 8328681033 | 4215 Cedar Ln, Columbus, OH, 43229 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-101629 | ENR | Kimberly Harris | 1959-04-24 | UHC-10041-73 | 8328681033 | 4215 Cedar Ln, Columbus, OH, 43229 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123188 | ENR | David Andrews | 1950-09-02 | UHC-01919-18 | 6954009348 | 3567 Sunset Blvd, Jacksonville, FL | 0.50 | Name re-casedPhone reformattedCity re-casedState name converted to code+3 more |
| ENR-114781 | ENR | Kathy Q West | 1968-04-18 | UHC-48148-99 | 6683475901 | 3928 Camelback Rd # 253, Glendale, AZ, 85339 | 0.50 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-134293 | ENR | Helen G Simmons | 1950-06-12 | UHC-26724-97 | — | 8767 Grand Ave, Charlotte, NC, 28297 | 0.50 | Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-136553 | ENR | Cheryl Wagner | 1962-03-27 | UHC-60739-16 | 3533484978 | 7207 Spring St, Dallas, TX | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-134525 | ENR | Nicole U Lopez | 1973-08-28 | UHC-36882-50 | 4587507035 | 4900 Mountain View Dr, Eden Prairie, MN, 55366 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-129517 | ENR | Daniel Morales | 2006-06-28 | UHC-50469-96 | — | 5695 Willow Ct, Fresno, CA | 0.50 | Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-108433 | ENR | Yuki B Stephens | 1996-12-08 | UHC-92550-71 | 7389308406 | 5123 Baseline Rd, Las Vegas, NV, 89163 | 0.50 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-112559 | ENR | Randy Kennedy | 1954-11-01 | UHC-29773-41 | 9732274314 | 5003 Union St, Las Vegas, NV, 89159 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-109318 | ENR | Laaura S Stone | 1984-10-19 | UHC-63188-72 | — | 7846 Willow Ct, Seattle, WA, 98190 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-120723 | ENR | Gloria M Thompson | 1946-03-06 | UHC-34983-11 | 5739634179 | 9524 Apache Blvd # 938, Phoenix, AZ, 85080 | 0.50 | Middle initial moved out of first nameName re-casedPhone reformattedMember ID reformatted+3 more |
| ENR-137158 | ENR | Marcus Davis | 1951-01-24 | UHC-27003-57 | 5598648628 | 889 Elm St, Columbus, OH | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-112195 | ENR | Vincent Griffin | 1956-01-01 | UHC-47620-31 | 7414986730 | 2128 River Rd # 430, Scottsdale, AZ, 85204 | 0.50 | Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-129041 | ENR | Paul F Romero | 1971-11-27 | UHC-28842-64 | 3842538140 | 8261 Harbor Blvd, Miami, FL | 0.50 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-130180 | ENR | Randy J Brooks | 1989-12-06 | UHC-99573-50 | 5112069004 | 1030 Mountain View Dr, Miami, FL, 33110 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-141929 | ENR | Angela Kelly | 2003-11-26 | UHC-38102-92 | 9774250532 | 2483 Willow Ct, Nashville, TN, 37297 | 0.50 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-132929 | ENR | Jerry Morales | 1965-11-19 | — | 3575506338 | 4882 Union St, Mesa, AZ, 85264 | 0.50 | Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-141298 | ENR | Terry Z Aguilar | 1967-10-18 | UHC-05876-64 | 5812783833 | 5644 Camelback Rd Apt 37, Tucson, AZ, 85723 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-142787 | ENR | Michelle Watkins | 1978-01-23 | UHC-31728-55 | 3268177544 | 9395 Willow Ct, Chandler, AZ, 85268 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128644 | ENR | Austin Y Porter | 1973-04-05 | UHC-87313-40 | 6196484977 | 690 Valley View Dr, Orlando, FL, 32894 | 0.50 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-132757 | ENR | Debra N Schmidt | 1941-08-21 | UHC-39182-52 | 6785129037 | 1984 Jefferson Ave, Tempe, AZ, 85232 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-108906 | ENR | Sara F Aguilar | 1949-01-09 | UHC-97394-26 | 3194025434 | 8640 Forest Ave, Las Vegas, NV, 89192 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-125274 | ENR | Judy Gutierrez | 1944-10-11 | UHC-68949-79 | 7269228240 | 893 Market St, Houston, TX, 77041 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-139301 | ENR | Katherine Q Stephens | 1973-12-22 | UHC-65510-30 | 3757578067 | 7018 Valley View Dr, Mesa, AZ, 85269 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-106172 | ENR | Ashley Bowman | 1978-06-17 | UHC-45993-85 | 5493713290 | 6982 Mountain View Dr Apt 25, Glendale, AZ, 85371 | 0.50 | Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more |
| ENR-129314 | ENR | Paul U Arnold | 2008-11-11 | UHC-58490-28 | 3664719205 | 4396 Jefferson Ave, Miami, FL, 33145 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-122461 | ENR | Matthew C Alexander | 1988-05-08 | UHC-16478-31 | — | 9294 Highland Ave, Miami, FL | 0.50 | Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135818 | ENR | Sara L Frreeman | 1986-06-22 | UHC-04806-77 | 8309973647 | 2306 Cedar Ln, Dallas, TX, 75256 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-120329 | ENR | Daniel O Myers | 1991-01-22 | UHC-26791-70 | 3248792863 | 2242 Camelback Rd, Gilbert, AZ, 85258 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-111331 | ENR | Steven Holmes | 1938-02-13 | UHC-19554-84 | — | 6670 Washington St, Tempe, AZ, 85245 | 0.50 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-140931 | ENR | Theresa Bradley | 1954-11-05 | UHC-33427-48 | 2894178886 | 8604 Forest Ave, Sacramento, CA, 95810 | 0.50 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100961 | ENR | Mark G Hicks | 1942-08-10 | UHC-78075-81 | 7555104467 | 9003 Grand Ave, Nashville, TN, 37240 | 0.50 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-113834 | ENR | Jozeph S Petters | 1983-04-21 | UHC-59958-44 | 7539151072 | 5660 Mountain View Dr, Glendale, AZ, 85384 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-103316 | ENR | Eric W Wright | 1939-06-11 | UHC-72315-78 | 9046175509 | 5338 Main St Apt 14, Mesa, AZ, 85239 | 0.50 | Unit split from streetCity re-casedState name converted to codeEmail lower-cased+3 more |
| ENR-137547 | ENR | David P Simmons | 1980-07-07 | UHC-57111-04 | 3589680219 | 741 Lincoln Way, Sacramento, CA, 95884 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-140659 | ENR | Amber Diaz | 1955-11-26 | UHC-29467-25 | 9489264444 | 5873 Central Ave, Dallas, TX, 75273 | 0.50 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-113134 | ENR | Philip U Montogmery | 1947-11-16 | UHC-95197-13 | 9724550747 | 2672 Spring St, San Antonio, TX | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more |
| ENR-141049 | ENR | Steven Medina | 1945-08-08 | UHC-03024-42 | — | 4508 Pine Dr, San Diego, CA, 92110 | 0.50 | Two-digit birth yearPhone missing area codeMember ID reformattedStreet suffix standardised+3 more |
| ENR-109786 | ENR | Angela Baker | 1956-07-15 | UHC-46469-11 | 4438980166 | 3469 Grand Ave, Miami, FL, 33104 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121102 | ENR | Melissa Rodriguez | 1943-03-11 | UHC-87826-91 | 6044501001 | 1384 Meadow Ln # 293, Scottsdale, AZ, 85293 | 0.50 | Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-108494 | ENR | Elizabeth Fox | 2005-12-07 | UHC-85549-30 | 2096109660 | 9575 Ocean Ave, Los Angeles, CA, 90057 | 0.50 | Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+3 more |