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-108281 | ENR | Judith Jacobs | 1941-10-18 | UHC-48697-92 | 5493781961 | 5550 Lake View Rd, Gilbert, AZ, 85225 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-131472 | ENR | Peter F Chavez | 1986-01-16 | UHC-11335-20 | 3335878654 | 3309 Baseline Rd, Columbus, OH | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-109652 | ENR | Santiago Elliott | 1989-06-01 | UHC-52585-76 | — | 5848 Elm St Apt 22, Orlando, FL, 32832 | 0.60 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-110609 | ENR | Joyce C Andrews | 1954-12-28 | UHC-46410-68 | 8002668415 | 1441 Park Pl, Tucson, AZ, 85797 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-101169 | ENR | Randy G Sanchez | 1958-11-11 | UHC-33973-66 | 9557342487 | 1774 Willow Ct, Orlando, FL | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-125796 | ENR | Janet N Mdeina | 1946-07-22 | UHC-79714-34 | 4147760228 | 4997 Main St, Seattle, WA, 98104 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-116201 | ENR | Alice L Alvarez | 2007-10-06 | UHC-16932-07 | 8704290398 | 1521 Harbor Blvd, Eden Prairie, MN, 55373 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-110943 | ENR | Alex Gilbert | 1959-12-23 | UHC-21575-56 | 8366844875 | 4963 Mesa Dr Apt 15, Las Vegas, NV, 89136 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-137552 | ENR | Stephen Gordon | 1988-03-22 | UHC-82600-06 | 7244221938 | 5705 Meadow Ln, Seattle, WA, 98145 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-123420 | ENR | Virginia Wagner | 1996-02-14 | UHC-84809-43 | 3396212520 | 992 Cedar Ln, Tucson, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-101429 | ENR | Grace N Young | 1959-12-03 | UHC-64513-41 | 3739765223 | 3752 Mesa Dr, Tempe, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-131054 | ENR | Jorddan Rice | 1965-09-13 | UHC-17038-94 | 8926828107 | 8671 Forest Ave, Sacramento, CA, 95866 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-135869 | ENR | Keith Wheeler | 1952-02-22 | UHC-48227-16 | — | 1930 Park Pl, Scottsdale, AZ, 85289 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-134964 | ENR | Mason A Reid | 1994-02-25 | UHC-94678-82 | 8328805841 | 4264 Palm Dr # 906, Seattle, WA, 98165 | 0.60 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-117526 | ENR | Brandon X Rojas | 1940-05-16 | UHC-05735-97 | 3353194071 | 5141 Union St, Seattle, WA, 98127 | 0.60 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-100459 | ENR | Ben K Flores | 1965-12-08 | UHC-64309-29 | 3015918723 | 735 Central Ave, Gilbert, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-121647 | ENR | Olivia Maldonado | 1959-04-02 | UHC-73748-47 | 8716659768 | 3376 Washington St, Gilbert, AZ, 85285 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-133194 | ENR | Linda H Willis | 1997-05-06 | UHC-42566-34 | 8094645504 | 4422 Union St, Denver, CO, 80260 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-117447 | ENR | Steven Carter | 1959-02-25 | UHC-12003-54 | 7832495872 | 4229 Apache Blvd # 743, Columbus, OH, 43211 | 0.60 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-110634 | ENR | Mary Hunter | 1948-03-07 | UHC-79113-04 | 7572556514 | 9548 Palm Dr, Plano, TX, 75001 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111516 | ENR | Kathy X Harris | 1996-05-02 | UHC-29359-29 | 5332526689 | 7651 Ocean Ave, Charlotte, NC | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-137237 | ENR | Victoria T Evans | 1962-08-16 | UHC-91282-09 | 4574529704 | 5865 Palm Dr, Tempe, AZ, 85230 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-118547 | ENR | Ethan E Mills | 1938-07-25 | UHC-93643-96 | 4245738596 | 6811 Park Pl, Plano, TX, 75081 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-103621 | ENR | Brandon Y Obrrien | 1985-10-23 | UHC-52239-76 | 8319827605 | 2492 Forest Ave, Las Vegas, NV, 89131 | 0.60 | Name split from “Last, First”Name re-casedDate of birth reformattedPhone reformatted+4 more |
| ENR-112448 | ENR | Jerry Anderson | 2006-12-25 | UHC-02296-66 | 7557009346 | 5218 Lake View Rd, San Antonio, TX, 78227 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-128675 | ENR | Brittany P Fuller | 1939-10-04 | UHC-65472-14 | 7165006523 | 8574 Market St, San Antonio, TX, 78246 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-132753 | ENR | Jennifer Sanchez | 1947-03-13 | UHC-17356-59 | 7176815041 | 3948 Canyon Rd, Mesa, AZ, 85254 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-107160 | ENR | Emma S Lopez | 1940-08-10 | UHC-18654-27 | 2364020917 | 9378 Union St, Nashville, TN | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-138090 | ENR | Joe B Welch | 2003-03-10 | UHC-01942-36 | 4473401088 | 8568 Ocean Ave, Phoenix, AZ, 85071 | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more |
| ENR-104064 | ENR | Stevens Amber | 1992-09-18 | UHC-79182-12 | 7656264037 | 3816 Mesa Dr, Charlotte, NC, 28233 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-113265 | ENR | Cheryl Y Carroll | 1967-02-19 | UHC-80042-98 | 6004780411 | 6440 Union St, San Antonio, TX, 78213 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-105039 | ENR | Wayne M Lawrence | 1938-02-18 | UHC-40777-26 | 4917798003 | 6921 Sage Ct, Jacksonville, FL, 32200 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-127610 | ENR | Shirley F Graham | 2005-11-13 | UHC-24244-75 | 4215322700 | 9296 Maple Ave, Sacramento, CA, 95851 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| ENR-107752 | ENR | Nicole Perry | 1988-11-01 | UHC-68070-74 | 4757105879 | 2531 Sunset Blvd, Glendale, AZ, 85305 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-142416 | ENR | Jerry Y Watson | 1983-04-17 | UHC-82208-73 | 6833821024 | 7251 Grand Ave, Sacramento, CA, 95840 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-119958 | ENR | Amber R Burke | 1994-03-09 | UHC-16041-55 | — | 8073 Sunset Blvd, Austin, TX, 78758 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-133517 | ENR | Peter G Fox | 2000-02-11 | UHC-43855-32 | 3789476021 | 5462 Forest Ave, Houston, TX, 77083 | 0.60 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-102300 | ENR | Joan O Larson | 1998-08-21 | UHC-90608-23 | 2823842901 | 605 Oak St, Tampa, FL, 33666 | 0.60 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-135270 | ENR | Melissa N Bennett | 1966-01-21 | UHC-74500-76 | — | 9773 Indian School Rd, Los Angeles, CA | 0.60 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-111896 | ENR | Kathleen V Clark | 1999-06-28 | UHC-53597-08 | 6642513912 | 7249 Spring St, Las Vegas, NV | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-106189 | ENR | Amy Fuller | 1982-08-24 | UHC-70500-62 | 7492760762 | 6125 Pine Dr, Tucson, AZ, 85746 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-116384 | ENR | Kevin P Lewis | 1972-06-28 | UHC-47662-48 | 2736147265 | 772 Willow Ct, Los Angeles, CA, 90065 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-139648 | ENR | Jonathan Y Singh | 1983-09-11 | UHC-90837-11 | 5358152918 | 8741 Baseline Rd, Charlotte, NC, 28259 | 0.60 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-123377 | ENR | Steve M Guerrero | 1966-09-27 | UHC-23579-55 | 6562849300 | 1690 Union St # 111, San Diego, CA, 92192 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-138462 | ENR | Carolyn R Ortega | 1998-06-15 | UHC-89704-73 | 2495826222 | 8513 Sage Ct, Charlotte, NC, 28218 | 0.60 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-112331 | ENR | Douglas G Cooper | 1977-09-17 | UHC-28409-19 | 8447769461 | 7523 Oak St, Nashville, TN | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-131277 | ENR | Ryan E Myerrs | 1952-06-28 | UHC-22890-68 | 5225174293 | 3563 River Rd # 355, Plano, TX, 75031 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-115738 | ENR | Elijah M Ortega | 1950-01-09 | UHC-94724-95 | 4765924986 | 4503 Oak St, Phoenix, AZ, 85045 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-103212 | ENR | Stephen Perkins | 1944-11-02 | UHC-79590-67 | 2148262899 | 6701 Valley View Dr, San Antonio, TX, 78241 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-116836 | ENR | Robert B Dixon | 2000-10-05 | UHC-69644-63 | 5745804447 | 7749 Meadow Ln, Denver, CO, 80234 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |