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-101508 | ENR | Karan Baker | 1951-06-10 | UHC-03116-01 | 4784193990 | 3263 Hillcrest Rd, Jacksonville, FL, 32238 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-101509 | ENR | Karan Baker | 1951-06-10 | UHC-03116-01 | 4784193990 | 3263 Hillcrest Rd, Jacksonville, FL, 32238 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-107362 | ENR | Eugene Jimenez | 1984-02-04 | UHC-93297-60 | 9254385844 | 1999 Willow Ct, Eden Prairie, MN, 55397 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-109237 | ENR | Reed Kelly | 1981-06-21 | UHC-12779-47 | 3486418768 | 640 Washington St, Phoenix, AZ, 85050 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-140067 | ENR | Raymond A Meyer | 1983-01-04 | UHC-99901-92 | 3335114863 | 5905 Mountain View Dr, Gilbert, AZ | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-119950 | ENR | Aaron F Evans | 1944-06-16 | UHC-51560-75 | 6935365422 | 2320 Central Ave, Austin, TX, 78753 | 0.52 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-114895 | ENR | Michelle Hernandez | 1989-02-27 | UHC-91392-48 | 3247764936 | 7088 Mesa Dr, Glendale, AZ, 85307 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-100928 | ENR | Charlotte Bryant | 1993-09-22 | UHC-51096-97 | 8588200512 | 4266 Union St, Denver, CO, 80230 | 0.52 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-121897 | ENR | Catherine Lee | 1967-03-15 | UHC-31793-24 | — | 1926 Union St, Chandler, AZ, 85249 | 0.52 | Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-135982 | ENR | James Johnston | 1960-06-27 | UHC-80069-17 | — | 3248 Mesa Dr, Nashville, TN | 0.52 | Phone missing area codeMember ID reformattedCity re-casedZIP missing+2 more |
| ENR-127173 | ENR | Emma S Griffin | 1961-04-16 | UHC-91839-84 | 9888686331 | 6820 Hillcrest Rd, Los Angeles, CA, 90022 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-119193 | ENR | Santiago M Woods | 1999-07-20 | UHC-32440-04 | 6578935566 | 8090 Lake View Rd, Chandler, AZ, 85278 | 0.52 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-107474 | ENR | Olivia U Chavez | 1973-01-15 | UHC-71126-91 | 6156628928 | 5964 Meadow Ln Apt 17, Atlanta, GA, 30371 | 0.52 | Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-109162 | ENR | Daniel N Ryan | 1950-03-06 | UHC-22573-16 | — | 8467 Cedar Ln, Jacksonville, FL, 32204 | 0.52 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-136558 | ENR | Maria Cole | 1946-12-12 | UHC-57827-95 | 6113525955 | 7219 Apache Blvd, Phoenix, AZ, 85014 | 0.52 | Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more |
| ENR-139071 | ENR | Grace Garza | 2002-11-10 | UHC-70601-88 | 9006582811 | 7828 Maple Ave Apt 40, Chandler, AZ, 85281 | 0.52 | Name split from “Last, First”Date of birth reformattedUnit split from streetGender normalised+2 more |
| ENR-103687 | ENR | Sandra L Wang | 1992-07-25 | UHC-11750-72 | — | 4488 Cedar Ln Apt 2, Seattle, WA, 98127 | 0.52 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-142963 | ENR | Adam M Delgado | 1971-09-05 | UHC-51736-88 | 8003563708 | 3565 Grand Ave, Houston, TX, 77003 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-109801 | ENR | Tyler C Fernandez | 1978-08-14 | UHC-64576-92 | 6672376826 | 4638 Mountain View Dr, Los Angeles, CA, 90025 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-108897 | ENR | Nicholas Z Reyes | 1975-02-18 | UHC-88476-59 | 2558078897 | 6595 Meadow Ln Apt 17, San Antonio, TX, 78221 | 0.52 | Date of birth reformattedMember ID reformattedUnit split from streetZIP+4 trimmed+2 more |
| ENR-124385 | ENR | Brandon Gibson | — | UHC-73891-30 | 9418385882 | 3199 Desert Sky Blvd, Houston, TX, 77023 | 0.52 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-105743 | ENR | Maria H Wilson | — | UHC-91464-24 | 7552530689 | 8988 Main St, Miami, FL, 33122 | 0.52 | Middle initial moved out of first nameDate of birth missingStreet suffix standardisedAddress re-cased+2 more |
| ENR-131601 | ENR | Harold K Nguyen | 2001-08-19 | UHC-44441-80 | 2844345446 | 6451 Hillcrest Rd, Phoenix, AZ, 85081 | 0.52 | Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-123207 | ENR | Doris E Arnold | 1945-04-23 | UHC-53358-12 | — | 6876 Jefferson Ave, Austin, TX, 78739 | 0.52 | Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+2 more |
| ENR-137777 | ENR | Hiroshi J Shaw | 1972-05-08 | UHC-17958-15 | 8947945234 | 119 Camelback Rd # 933, Miami, FL, 33183 | 0.52 | Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-100186 | ENR | Christina Russell | 1960-05-17 | UHC-19733-52 | — | 662 Ridge Rd # 957, Gilbert, AZ | 0.52 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-117155 | ENR | Michelle G Jimenez | 1944-09-20 | UHC-07901-84 | 2467090634 | 148 Forest Ave, Atlanta, GA, 30385 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-100991 | ENR | Anna S Fisher | 1990-09-28 | UHC-66514-15 | — | 6576 Camelback Rd, Los Angeles, CA | 0.52 | Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-125798 | ENR | Alice Carter | 1963-12-03 | UHC-42043-27 | 6529860076 | 5321 Ocean Ave, Sacramento, CA, 95804 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-110261 | ENR | Henry Yang | 1979-06-01 | UHC-51973-52 | 7017275417 | 6477 Valley View Dr, Scottsdale, AZ, 85277 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-124488 | ENR | Virginia Cooper | 1942-04-16 | UHC-28150-15 | 4854742524 | 3201 Mesa Dr, Gilbert, AZ, 85253 | 0.52 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-132912 | ENR | Emma Jackson | 1905-11-25 | UHC-14402-88 | 6897179127 | 1433 Jefferson Ave, Nashville, TN, 37238 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-100994 | ENR | Stephanie Gardner | 1953-12-28 | UHC-33192-03 | — | 1154 Lincoln Way, Seattle, WA, 98159 | 0.52 | Name split from “Last, First”Date of birth reformattedZIP+4 trimmedGender normalised+2 more |
| ENR-142674 | ENR | Bobby Butler | 1974-09-27 | UHC-92800-68 | — | 9720 Central Ave # 524, Columbus, OH | 0.52 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-131355 | ENR | Roger Fox | 1990-07-18 | UHC-96985-70 | 6404148100 | 5466 Maple Ave, Tampa, FL, 33680 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-124705 | ENR | Michael F Aguilar | — | UHC-84748-08 | — | 9087 Apache Blvd, Las Vegas, NV, 89144 | 0.52 | Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more |
| ENR-108034 | ENR | Judith H Rivara | 1954-09-08 | UHC-82345-54 | 7208860022 | 7771 Lake View Rd, Nashville, TN | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-111579 | ENR | Bryan S Smith | 2003-10-02 | UHC-11693-40 | 7415637435 | 8664 Ridge Rd, Nashville, TN, 37207 | 0.52 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-130950 | ENR | Bobby Luna | 1980-04-14 | UHC-58068-44 | 9664425131 | 6309 Jefferson Ave, Miami, FL, 33162 | 0.52 | Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+2 more |
| ENR-111629 | ENR | Justin N Carr | 1979-02-16 | UHC-13351-15 | — | 7691 Forest Ave, Gilbert, AZ, 85275 | 0.52 | Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-118853 | ENR | Angela E Woods | 1977-08-26 | UHC-24555-87 | 7374163663 | 3702 Central Ave, Los Angeles, CA, 90047 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-129055 | ENR | Harold E Casillo | 1949-05-28 | UHC-59339-91 | — | 1101 Church St, Dallas, TX, 75244 | 0.52 | Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-128800 | ENR | Elijah X Greene | 1988-08-10 | UHC-82662-56 | — | 8413 Church St, Phoenix, AZ, 85050 | 0.52 | Name split from “Last, First”Two-digit birth yearCity re-casedGender normalised+2 more |
| ENR-115281 | ENR | Alexis M Hunt | 1978-10-09 | UHC-21311-85 | 3026347580 | 6601 Maple Ave, Tempe, AZ, 85245 | 0.52 | Date of birth reformattedPhone reformattedSSN last four extractedZIP+4 trimmed+2 more |
| ENR-135307 | ENR | Sofia Gonzalez | 1989-06-16 | UHC-28733-52 | — | 2628 Washington St, Nashville, TN | 0.52 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-130331 | ENR | Frances A Wong | 1997-11-20 | UHC-71214-60 | 7178921720 | 6245 Broadway, Denver, CO, 80235 | 0.52 | Name split from “Last, First”Phone reformattedState name converted to codeEmail lower-cased+2 more |
| ENR-132268 | ENR | Hannah Cooper | 1945-03-20 | UHC-05330-12 | 8547649675 | 6186 Ocean Ave, Denver, CO, 80205 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-137394 | ENR | Sarrah Obrien | 1979-03-22 | UHC-18352-69 | 2833381593 | 5148 Maple Ave, Minneapolis, MN, 55474 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-104352 | ENR | Jamas M Espinoza | 1998-01-19 | UHC-93856-60 | — | 5887 Central Ave, San Antonio, TX, 78268 | 0.52 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| ENR-122084 | ENR | Sara Ramos | 2008-11-19 | UHC-62520-52 | — | 2967 Highland Ave, San Diego, CA, 92123 | 0.52 | Name re-casedPhone missing area codeState name converted to codeGender normalised+2 more |