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
All sources, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| TPA-58311 | TPA | Jake Mdina | 1968-08-23 | — | 6954615616 | 8514 Park Pl, Tempe, AZ, 85243 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-133819 | ENR | Michelle Brooks | 2000-08-08 | UHC-54189-80 | 2373108361 | 3193 Bayshore Dr Apt 27, Tempe, AZ, 85225 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-102682 | ENR | Charlotte B Smith | 1992-12-17 | UHC-45559-79 | 5667796574 | 2953 Cedar Ln, Tampa, FL, 33699 | 0.46 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-128578 | ENR | Carolyn M Santiago | 2007-03-10 | UHC-51828-36 | 2826262585 | 4033 Hillcrest Rd, Phoenix, AZ, 85083 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-126742 | ENR | Mason P Foster | 1975-03-14 | UHC-91690-75 | 4662759937 | 3701 Harbor Blvd # 266, Nashville, TN | 0.46 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more |
| ENR-104898 | ENR | Mason Kelley | 1984-11-26 | UHC-62790-81 | 6316006027 | 7795 Harbor Blvd, Austin, TX, 78768 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-125661 | ENR | Elizabeth M Maldonado | 1986-04-01 | UHC-49167-25 | 5893508348 | 3871 Park Pl Apt 40, Charlotte, NC, 28277 | 0.46 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-121954 | ENR | Elijah J Torres | 1968-03-21 | UHC-90396-64 | 9883370211 | 7315 Church St, Eden Prairie, MN | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| CLM-405667 | CLM | Jacqueline V Fowler | 1999-12-16 | — | 2752865146 | 1885 Central Ave, Jacksonville, FL, 32221 | 0.46 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| TPA-50222 | TPA | Isabella Harrison | 1987-09-12 | — | 9333412719 | 4153 Ridge Rd, Sacramento, CA, 95883 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-114976 | ENR | Mateo Medina | 1950-03-15 | UHC-80796-72 | 7749530209 | 5639 Willow Ct, Sacramento, CA, 95805 | 0.46 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-114975 | ENR | Mateo Medina | 1950-03-15 | UHC-80796-72 | 7749530209 | 5639 Willow Ct, Sacramento, CA, 95805 | 0.46 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-101153 | ENR | Timothy Kelly | 1989-07-01 | UHC-36460-96 | 4893100129 | 2193 Mountain View Dr, Seattle, WA | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-101814 | ENR | Benjamin Harris | 1978-11-02 | UHC-55813-93 | 7414289056 | 1764 Mountain View Dr, Las Vegas, NV | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-407637 | CLM | Ana T Mason | 2002-01-10 | UHC-43455-67 | 3122246069 | 8872 Highland Ave, Charlotte, NC, 28224 | 0.46 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more |
| TPA-57313 | TPA | Butler Dylan | 1971-06-18 | — | 2456384148 | 5807 Church St, Houston, TX, 77095 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-424073 | CLM | Justin Williams | 1980-03-09 | UHC-22721-48 | 9532641547 | 6948 Mesa Dr, Plano, TX, 75006 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-132785 | ENR | Elijah X Williams | 1959-10-23 | UHC-93427-23 | 5933260049 | 6333 Harbor Blvd, Seattle, WA | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-120228 | ENR | Sofia Wilson | 2004-06-18 | UHC-06608-41 | 5902998121 | 3482 River Rd, San Diego, CA, 92138 | 0.46 | Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+5 more |
| CLM-426550 | CLM | Amanda R Hill | 2001-08-08 | UHC-75623-64 | 9328061406 | 6405 Desert Sky Blvd # 144, Charlotte, NC, 28299 | 0.46 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-111999 | ENR | Omar Carter | 1940-09-08 | UHC-59754-70 | 8698924762 | 6152 Camelback Rd, Seattle, WA, 98188 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| TPA-64299 | TPA | Michelle Z Alvarez | 2007-03-11 | — | 9882735027 | 9370 Hillcrest Rd, Tempe, AZ, 85235 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-120956 | ENR | Judith Lucas | — | UHC-82017-35 | 4284050195 | 5675 Bayshore Dr # 815, Orlando, FL, 32894 | 0.46 | Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more |
| ENR-102408 | ENR | Cynthia I Wagner | 1967-01-07 | UHC-51467-91 | 3445432646 | 5775 Park Pl, Orlando, FL | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-116284 | ENR | Lauren Ford | 1955-06-13 | UHC-21692-03 | 8807802695 | 51 Union St, Minneapolis, MN, 55402 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-127875 | ENR | Mike Simmons | 1978-04-13 | UHC-43803-76 | 7855554793 | 7323 Park Pl, Dallas, TX, 75206 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| PRV-22637 | PRV | Brandon G Jacobs | 1955-08-05 | UHC-10592-72 | 8519738549 | 9500 Grand Ave Apt 1, Orlando, FL, 32825 | 0.46 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+5 more |
| TPA-61959 | TPA | Kim Hernandez | 1945-12-13 | UHC-62431-46 | — | 4884 Pine Dr # 316, Phoenix, AZ, 85023 | 0.46 | Name split from “Last, First”Date of birth reformattedMember ID reformattedUnit split from street+5 more |
| CLM-405836 | CLM | Vincent N Diaz | 1982-11-18 | — | — | 8142 Oak St # 687, Fresno, CA, 93735 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| PRV-21944 | PRV | Amy Daniels | 2007-04-08 | — | 7568022992 | 1993 Main St, San Antonio, TX | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-117210 | ENR | Kenneth S Perkins | 2003-07-24 | UHC-16787-95 | 3046370785 | 4677 Valley View Dr, Scottsdale, AZ, 85266 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more |
| ENR-116715 | ENR | Cheryl Carr | 1953-08-27 | — | 2346211532 | 1857 Valley View Dr, Scottsdale, AZ | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-420137 | CLM | Alexander Patterson | 1965-06-14 | — | — | 5599 Desert Sky Blvd, Glendale, AZ, 85346 | 0.46 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more |
| ENR-118126 | ENR | Gloria Tran | 1999-12-15 | UHC-60806-43 | — | 5239 River Rd, Sacramento, CA, 95844 | 0.46 | Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+5 more |
| PRV-21538 | PRV | Scott AJunk | 1991-10-09 | UHC-85790-90 | — | 3667 River Rd, Gilbert, AZ, 85216 | 0.46 | Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+5 more |
| CLM-420464 | CLM | Patrick Valdez | 1950-04-27 | UHC-71408-63 | — | 5078 Canyon Rd Apt 38, Minneapolis, MN, 55432 | 0.46 | Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+5 more |
| ENR-115512 | ENR | Arjun Davis | 1957-09-09 | UHC-79014-99 | 5769585063 | 6398 Union St, Denver, CO, 80281 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-137533 | ENR | Diego Ford | — | UHC-42855-52 | 7705262408 | 3131 Apache Blvd, Tempe, AZ, 85271 | 0.46 | Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more |
| CLM-412436 | CLM | Bobby Wetson | 1997-02-10 | UHC-36535-02 | — | 9708 Palm Dr, Tampa, FL, 33656 | 0.46 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more |
| CLM-406828 | CLM | Vincent Hudson | 1943-07-18 | UHC-97933-52 | 3625237674 | 8952 Market St # 836, Fresno, CA, 93702 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-140551 | ENR | Scott V Turner | 1951-05-21 | UHC-29656-32 | 4345839565 | 3002 Lake View Rd Apt 35, Tampa, FL, 33668 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |
| TPA-60760 | TPA | Bruce Smith | 1994-02-20 | — | 9353156705 | 959 Baseline Rd, Eden Prairie, MN | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-130169 | ENR | Janice Welch | 1945-03-17 | UHC-30440-03 | 8869319768 | 4837 Union St # 134, Houston, TX | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| TPA-57905 | TPA | Bradley Herrera | 2006-02-10 | — | 7925801384 | 3645 Mountain View Dr, Scottsdale, AZ, 85286 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| PRV-25727 | PRV | Maria J Oliver | 1982-04-02 | UHC-92965-78 | 9488159669 | 8314 Willow Ct # 843, Miami, FL | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-126072 | ENR | Ahmed W Perez | 2004-09-18 | UHC-29273-05 | 9522031486 | 3808 Elm St Apt 33, Scottsdale, AZ, 85286 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| PRV-23446 | PRV | Janet Sullivan | 1964-11-13 | — | 3934903035 | 1756 Lake View Rd, Phoenix, AZ, 85039 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-131978 | ENR | Rachel C Lawson | 1942-03-23 | UHC-27077-99 | 2048265282 | 8742 Pine Dr, Houston, TX, 77087 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-133326 | ENR | Ralph K Medina | 1953-12-04 | UHC-86664-23 | 6277254859 | 7492 Palm Dr, Tucson, AZ | 0.46 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-121990 | ENR | Santiago Patterson | 1960-06-28 | UHC-88650-70 | 5913420133 | 9129 Ocean Ave, Tampa, FL | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |