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-109645 | ENR | Charlotte E Saanchez | 1994-04-17 | UHC-17804-04 | 7458645091 | 7218 Washington St # 498, Orlando, FL, 32845 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-136366 | ENR | Albert B Chavez | 1998-08-22 | UHC-44798-07 | 5733804728 | 1017 Central Ave, San Antonio, TX, 78233 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-119568 | ENR | Doris N Laswon | 1997-10-27 | UHC-56459-08 | 5672968175 | 7664 Cedar Ln, San Antonio, TX, 78262 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-102561 | ENR | Elizabeth C Hamilton | 1950-12-01 | UHC-48977-86 | 7854742364 | 4500 Maple Ave # 816, Seattle, WA, 98196 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-132570 | ENR | Eric E Lopez | 2005-06-03 | UHC-22440-94 | 6334298860 | 4847 Market St, Scottsdale, AZ, 85203 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedGender normalised+3 more |
| ENR-120634 | ENR | Sharon L Hanson | 1981-04-25 | UHC-31736-86 | 6408796522 | 8200 Oak St, Tampa, FL, 33685 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-128999 | ENR | Bruce Little | 1939-07-09 | UHC-57607-93 | 7795054597 | 5733 Baseline Rd, Los Angeles, CA | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120695 | ENR | Patricia Y Oliver | 1956-09-08 | UHC-10035-02 | 2417575054 | 3500 Cedar Ln, Mesa, AZ, 85280 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-122388 | ENR | Cooer Joan | 1991-01-05 | UHC-11316-57 | 2995173552 | 2610 Sage Ct, Jacksonville, FL, 32272 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-123551 | ENR | George Silva | 1972-09-06 | UHC-43784-68 | — | 9064 Camelback Rd, Glendale, AZ | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133364 | ENR | Ashley N Woods | 1974-05-27 | UHC-73202-29 | 5276781597 | 8709 Oak St, Eden Prairie, MN, 55383 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133365 | ENR | Ashley N Woods | 1974-05-27 | UHC-73202-29 | 5276781597 | 8709 Oak St, Eden Prairie, MN, 55383 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-125446 | ENR | Grace C Henry | 1966-01-23 | UHC-49759-88 | 4484013445 | 1034 Cedar Ln, Mesa, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-125223 | ENR | Yuki Perkins | 1967-05-28 | UHC-55774-23 | 8818518156 | 5842 Jefferson Ave, Gilbert, AZ, 85263 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-119969 | ENR | Edward E Garcia | 1942-12-09 | UHC-82255-21 | 4818602544 | 5691 Lincoln Way, Austin, TX, 78786 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110492 | ENR | Ethan N Fields | 1982-11-04 | UHC-38617-49 | 5795865654 | 8099 Ridge Rd, Gilbert, AZ, 85254 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-127661 | ENR | Katherine W Adams | 1942-07-08 | UHC-28383-12 | 6486388366 | 554 Park Pl, Los Angeles, CA | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-138363 | ENR | Alan McDonald | 1978-06-07 | UHC-93299-85 | 7688792119 | 775 Jefferson Ave, Orlando, FL, 32814 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-117359 | ENR | Albert Fisher | 1971-06-06 | UHC-40609-82 | 5619761914 | 8806 Park Pl, San Antonio, TX, 78212 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-119551 | ENR | Gregory U Ramos | 1984-08-11 | UHC-69287-98 | 3377004135 | 843 Harbor Blvd, Nashville, TN, 37202 | 0.62 | Date of birth reformattedPhone reformattedCity re-casedState name converted to code+3 more |
| ENR-132129 | ENR | Beverly Soto | 1948-01-21 | UHC-14300-46 | 6436909399 | 3256 Elm St, Orlando, FL, 32869 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112252 | ENR | Pat O Webb | 1991-07-23 | UHC-74916-65 | 9387519014 | 31 Palm Dr, Jacksonville, FL, 32266 | 0.62 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-140498 | ENR | Noah Black | 1994-02-07 | UHC-57024-95 | 8732861223 | 1296 Willow Ct # 287, Chandler, AZ, 85228 | 0.62 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-102369 | ENR | Patrick U Franklin | 1976-12-05 | UHC-08591-47 | — | 8100 Camelback Rd # 181, Tempe, AZ, 85249 | 0.62 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-121469 | ENR | Lucia J Fuller | 1976-05-01 | UHC-16929-82 | 2572383298 | 8952 Park Pl, Fresno, CA, 93730 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110986 | ENR | Justin Q Wright | 1963-11-15 | UHC-25235-54 | — | 4940 Elm St, Plano, TX, 75057 | 0.62 | Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-135802 | ENR | Fatima F Freeman | 1986-09-04 | UHC-38123-26 | 5438216398 | 6623 Church St, Glendale, AZ, 85378 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-124926 | ENR | Carol B Gibson | 1941-01-10 | UHC-92939-34 | 3465222203 | 6007 Oak St, Tempe, AZ, 85235 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more |
| ENR-136009 | ENR | Ahmed N Grant | 1988-04-16 | UHC-81442-49 | 2307558400 | 8056 Sage Ct Apt 20, Nashville, TN, 37279 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-100801 | ENR | Lerry S Richardson | — | UHC-30947-57 | — | 8965 Palm Dr, Phoenix, AZ, 85094 | 0.62 | Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more |
| ENR-108685 | ENR | Jean Young | 1984-04-15 | UHC-65180-97 | — | 9692 Canyon Rd, Dallas, TX, 75221 | 0.62 | Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-125985 | ENR | Christina W Lewis | 1955-08-23 | UHC-10969-44 | 5348596742 | 8303 Indian School Rd, Chandler, AZ | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-139830 | ENR | Tomas Robinson | 1986-01-11 | UHC-59732-27 | 3229527203 | 8098 Sunset Blvd, Miami, FL, 33169 | 0.62 | Date of birth reformattedPhone reformattedSSN last four extractedCity re-cased+3 more |
| ENR-109408 | ENR | Henry E Miller | 1963-04-22 | UHC-82425-52 | 3947673552 | 5024 Valley View Dr, Los Angeles, CA, 90043 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-142832 | ENR | Sandra C Simpson | 1957-03-28 | UHC-38213-65 | 7935757379 | 6764 Apache Blvd, San Antonio, TX, 78226 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-127900 | ENR | Janet E Brown | 1939-08-23 | UHC-78003-20 | 6197299720 | 1614 Washington St, Dallas, TX, 75288 | 0.62 | Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+3 more |
| ENR-114241 | ENR | Alexis W Freeman | 1939-02-06 | UHC-84619-94 | 7013294433 | 199 Bayshore Dr, Charlotte, NC, 28290 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-102876 | ENR | Roger I Kennedy | 2008-08-26 | UHC-64119-90 | 8468393656 | 3119 Desert Sky Blvd, Tampa, FL, 33615 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-134426 | ENR | Alan O Greene | 1944-11-23 | UHC-55208-95 | 5397331749 | 9748 Oak St, Columbus, OH, 43243 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-104484 | ENR | Baker F Roy | 1990-07-17 | UHC-57070-14 | 2556490367 | 3701 Washington St, Tampa, FL, 33607 | 0.62 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more |
| ENR-113520 | ENR | Amber T Wong | 1996-09-06 | UHC-10320-64 | 5239431836 | 2507 Harbor Blvd, Scottsdale, AZ, 85284 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-108713 | ENR | Donald Torres | 1963-09-18 | UHC-28843-56 | 7587485754 | 4999 Jefferson Ave, Charlotte, NC, 28240 | 0.62 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-116259 | ENR | Janice T Hanson | 1966-12-14 | UHC-80875-48 | 8507143700 | 5303 Willow Ct, Tempe, AZ, 85271 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-122814 | ENR | George Mejia | 1981-02-28 | UHC-53320-70 | 3863246406 | 6007 Lake View Rd, Dallas, TX, 75257 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-125879 | ENR | Jack Byrant | 1943-03-28 | UHC-24204-39 | 3223282768 | 5800 Willow Ct, Sacramento, CA, 95828 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more |
| ENR-105712 | ENR | Catherine A Richardson | 1988-01-10 | UHC-00641-21 | 4248223146 | 4471 Elm St, Seattle, WA, 98189 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110168 | ENR | Ronald Harrison | 2004-05-22 | UHC-33242-35 | 6353281212 | 8077 Maple Ave, Denver, CO, 80267 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-142316 | ENR | George U Sims | 1980-09-19 | UHC-72547-69 | 5022844476 | 6943 Lincoln Way, Jacksonville, FL, 32266 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-125960 | ENR | Amber P Bradley | 1985-11-09 | UHC-76447-81 | 3997199626 | 61 Market St, Houston, TX, 77043 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-102239 | ENR | Jacob V Diaz | 1951-10-15 | UHC-98946-09 | 2629357695 | 37 Camelback Rd, Glendale, AZ, 85327 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more |