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-126999 | ENR | Jake M Foster | 1988-11-23 | UHC-38844-77 | 9465108237 | 3819 Lake View Rd, Tucson, AZ, 85725 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-140647 | ENR | Eric K Flores | 1962-10-19 | — | 4509388794 | 3873 Indian School Rd, Seattle, WA | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-118113 | ENR | Deennis E Elliott | 1975-04-06 | UHC-09901-47 | 4146987519 | 3313 Maple Ave Apt 40, Gilbert, AZ, 85265 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-123898 | ENR | John W Thoams | 1960-05-14 | UHC-00769-29 | 5769066203 | 8931 Baseline Rd, Scottsdale, AZ, 85282 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-107881 | ENR | Alexander Aguilar | 1999-03-21 | — | 3798604515 | 2890 Jefferson Ave, Columbus, OH, 43238 | 0.62 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-106832 | ENR | Barbara G Howard | 2002-07-14 | UHC-62387-23 | 2102620539 | 6324 Mountain View Dr, Jacksonville, FL, 32235 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-106644 | ENR | Stephen Q Ortiz | 1988-12-03 | UHC-98013-72 | 7395713430 | 4836 Lake View Rd, Las Vegas, NV, 89160 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-104009 | ENR | George F Fields | 1964-08-07 | UHC-41024-19 | 8092568073 | 6238 Desert Sky Blvd, Seattle, WA, 98175 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-120237 | ENR | Patricia Spencer | 1947-04-21 | UHC-85753-71 | 9207712357 | 450 Apache Blvd, Plano, TX, 75064 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-130234 | ENR | Megan Rios | 1951-04-03 | UHC-47867-27 | — | 9068 Central Ave, Atlanta, GA, 30361 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+3 more |
| ENR-135814 | ENR | Emily R Reynolds | 1962-04-06 | — | 8903392682 | 5254 Mountain View Dr # 199, Austin, TX, 78712 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-135815 | ENR | Emily R Reynolds | 1962-04-06 | — | 8903392682 | 5254 Mountain View Dr # 199, Austin, TX, 78712 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-127203 | ENR | Anthony Marttinez | 1979-08-19 | UHC-21138-28 | 3895403934 | 5560 Forest Ave, Denver, CO, 80259 | 0.62 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-128407 | ENR | Albert K Gonzalez | 1968-09-15 | UHC-36932-95 | 4519368884 | 9216 Indian School Rd Apt 38, Mesa, AZ, 85200 | 0.62 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-128406 | ENR | Albert K Gonzalez | 1968-09-15 | UHC-36932-95 | 4519368884 | 9216 Indian School Rd Apt 38, Mesa, AZ, 85200 | 0.62 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-131961 | ENR | Olivia O Wheeler | 1965-10-28 | UHC-30003-90 | 3785066639 | 3824 Union St, Dallas, TX, 75246 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-105415 | ENR | Julie Contreras | 1939-10-28 | UHC-05984-76 | 2788724238 | 7644 Hillcrest Rd, Phoenix, AZ, 85039 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112589 | ENR | Brandon Jacobs | 1962-07-15 | UHC-72775-55 | 7329392553 | 6182 Lincoln Way, Houston, TX, 77019 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-111439 | ENR | Douglas Boyd | 2008-01-05 | UHC-31244-35 | 2359283386 | 4939 Grand Ave, Tempe, AZ, 85228 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-128055 | ENR | Betty Wnag | 1999-02-05 | UHC-35789-18 | 5588161366 | 5018 Elm St, Jacksonville, FL, 32277 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-117341 | ENR | Matthew S Medina | 1961-09-14 | UHC-54702-19 | 6442752167 | 9132 Spring St, Houston, TX, 77061 | 0.62 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128526 | ENR | Christine E Ortega | 1942-02-14 | UHC-20181-23 | 8234727392 | 2376 Jefferson Ave # 672, Tampa, FL, 33697 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-107753 | ENR | Patricia Hanson | 2006-01-25 | UHC-26195-41 | 4478472521 | 142 Mesa Dr, Seattle, WA, 98179 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-121127 | ENR | Raymond O Morales | 1963-01-08 | UHC-83339-38 | 8602309791 | 8567 Highland Ave, Gilbert, AZ, 85255 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-141288 | ENR | Amanda Ramirez | 1977-06-27 | UHC-56022-98 | 4645621660 | 9257 River Rd, Houston, TX | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-129798 | ENR | Omar F Freeman | 1968-07-21 | UHC-21072-58 | 7112739404 | 6603 Highland Ave, Seattle, WA, 98178 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-124660 | ENR | Amy Torres | 1995-01-01 | UHC-25276-49 | 6413517923 | 5717 Desert Sky Blvd, San Antonio, TX, 78240 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-136779 | ENR | Susan Braadley | 1982-11-11 | UHC-96595-29 | 9597875567 | 3310 Camelback Rd, Denver, CO, 80201 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-106489 | ENR | Bryan Elliott | 1966-07-01 | UHC-17957-06 | 6223581893 | 8813 Grand Ave, San Antonio, TX, 78260 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-123529 | ENR | Elizabeth O Wells | 1985-09-11 | UHC-74329-89 | 4477961760 | 8340 Baseline Rd, Dallas, TX, 75282 | 0.62 | Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-139545 | ENR | Diane Carter | 1974-06-22 | UHC-52209-86 | 3799179824 | 663 Main St, San Diego, CA, 92173 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121985 | ENR | Charles J Watson | 1952-06-16 | UHC-58095-79 | 7102090425 | 2196 Spring St Apt 37, Tempe, AZ, 85221 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-131218 | ENR | Heather Fuller | 1938-09-04 | UHC-97671-82 | 9303423348 | 5849 Mesa Dr, Minneapolis, MN, 55478 | 0.62 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-111692 | ENR | Mariana Mason | 1965-12-17 | UHC-25369-28 | 4572467847 | 7478 Mountain View Dr, Jacksonville, FL, 32270 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-111693 | ENR | Mariana Mason | 1965-12-17 | UHC-25369-28 | 4572467847 | 7478 Mountain View Dr, Jacksonville, FL, 32270 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-134482 | ENR | Ruuth U Garcia | 1950-03-07 | UHC-31706-77 | 2347775141 | 7453 Forest Ave # 135, Mesa, AZ, 85280 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-110552 | ENR | Steven Bradley | 1945-04-08 | UHC-73547-55 | 5435971253 | 3819 Canyon Rd, Denver, CO, 80271 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-118564 | ENR | Gabriel D Cloe | 2007-05-03 | UHC-91900-15 | — | 373 Cedar Ln, Houston, TX, 77062 | 0.62 | Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more |
| ENR-131652 | ENR | Anna Hamilton | 1982-06-21 | UHC-04826-75 | 4307866289 | 6670 Apache Blvd, Atlanta, GA, 30326 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-119908 | ENR | Roy Ramos | 1976-03-09 | UHC-72382-35 | 4423644182 | 8873 Willow Ct, Austin, TX, 78767 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-116406 | ENR | Brandon Bans | 1955-04-16 | UHC-97066-54 | 5904177591 | 9580 Mesa Dr, San Antonio, TX, 78214 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-138531 | ENR | Melissa Palmer | 1968-09-20 | UHC-45257-07 | 6479739874 | 4242 Camelback Rd, Columbus, OH, 43206 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-132612 | ENR | Lawrence T Aguilar | 1978-05-28 | UHC-26192-03 | 6512957001 | 2892 Jefferson Ave Apt 35, Los Angeles, CA, 90054 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-138470 | ENR | Frank N Duncan | 1992-10-19 | UHC-13504-43 | 9028585600 | 8825 Baseline Rd, Jacksonville, FL, 32264 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-111372 | ENR | Isabella S Shaw | 1993-05-27 | UHC-87611-44 | 4386905050 | 4412 Palm Dr, Atlanta, GA, 30369 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-123034 | ENR | Alice W Bryant | 1967-08-03 | UHC-87888-26 | 3116580398 | 7231 Palm Dr, Chandler, AZ, 85265 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-134692 | ENR | Dennis Warren | 1969-11-23 | UHC-83107-26 | 8718928053 | 3986 Mountain View Dr, Miami, FL, 33178 | 0.62 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-125824 | ENR | Robert Rees | — | UHC-55341-74 | 3663152536 | 100 Canyon Rd, Seattle, WA, 98100 | 0.62 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more |
| ENR-139389 | ENR | Wei R Ramirez | 1956-12-24 | UHC-24389-28 | 2663056008 | 9644 Willow Ct, Las Vegas, NV | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109440 | ENR | Amy Matthews | 1977-12-25 | UHC-25580-78 | 7395686519 | 4188 Hillcrest Rd, Mesa, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |