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
Provider network, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| PRV-27151 | PRV | Charles P Murray | 1952-01-15 | — | — | 8544 Apache Blvd, Nashville, TN, 37208 | 0.98 | Placeholder values cleared |
| PRV-27150 | PRV | Charles P Murray | 1952-01-15 | — | — | 8544 Apache Blvd, Nashville, TN, 37208 | 0.98 | Placeholder values cleared |
| PRV-24165 | PRV | Carlos Lucas | 1965-04-04 | UHC-26021-69 | — | — | 0.98 | Placeholder values cleared |
| PRV-20588 | PRV | Mari James | 2001-11-10 | — | — | — | 0.98 | Placeholder values cleared |
| PRV-23326 | PRV | Douglas Harvey | 1967-01-02 | UHC-07499-94 | — | 5111 Broadway, Nashville, TN, 37248 | 0.98 | Placeholder values cleared |
| PRV-21682 | PRV | Eugene Weber | 1996-02-13 | UHC-24096-95 | — | — | 0.98 | Placeholder values cleared |
| PRV-29374 | PRV | Diego Cook | 1992-07-26 | — | 8229578548 | 1513 Sunset Blvd, Sacramento, CA, 95891 | 0.98 | Placeholder values cleared |
| PRV-25874 | PRV | Virgina Santos | 1963-04-24 | UHC-04585-66 | 7167838598 | — | 0.98 | Placeholder values cleared |
| PRV-24550 | PRV | Ahmed V Hernandez | 1942-04-15 | UHC-21736-01 | — | 3347 Jefferson Ave, Sacramento, CA, 95805 | 0.98 | Placeholder values cleared |
| PRV-27963 | PRV | Margaret Foster | 1950-06-28 | — | — | 9550 Highland Ave, Phoenix, AZ, 85045 | 0.98 | Placeholder values cleared |
| PRV-29116 | PRV | John Austin | 1939-07-15 | UHC-44139-94 | 4877941078 | 6587 Bayshore Dr, Eden Prairie, MN, 55331 | 0.98 | Placeholder values cleared |
| PRV-22170 | PRV | Ethan E Dominguez | 1948-08-01 | — | 5195181446 | 8430 Central Ave, Los Angeles, CA, 90003 | 0.98 | Placeholder values cleared |
| PRV-28551 | PRV | Anna Perkins | 1942-07-14 | UHC-23998-35 | 3692099308 | 824 Indian School Rd, Chandler, AZ, 85275 | 0.98 | Whitespace trimmed |
| PRV-25644 | PRV | Peter Harris | 1953-02-27 | UHC-36327-95 | — | 6807 Hillcrest Rd, Eden Prairie, MN, 55308 | 0.98 | Placeholder values cleared |
| PRV-26257 | PRV | Nathan Carpenter | 1954-06-10 | — | — | — | 0.98 | Placeholder values cleared |
| PRV-21238 | PRV | Stephen Vargas | 1991-11-11 | UHC-56822-75 | — | — | 0.98 | Placeholder values cleared |
| PRV-20121 | PRV | Fatima Kim | 1966-06-26 | UHC-47643-05 | 9889443477 | 8544 Camelback Rd, Sacramento, CA, 95882 | 0.98 | Placeholder values cleared |
| PRV-26921 | PRV | Yuki Harris | 1950-10-26 | — | — | — | 0.98 | Placeholder values cleared |
| PRV-24933 | PRV | Emily I Diaz | 1962-04-24 | — | 7184874460 | 9476 Forest Ave, Tucson, AZ, 85779 | 0.98 | Placeholder values cleared |
| PRV-24760 | PRV | Chirstian Edwards | 1977-03-19 | UHC-82513-35 | — | — | 0.98 | Placeholder values cleared |
| PRV-26723 | PRV | Terry Turner | 1971-11-01 | — | 2737798336 | 1967 Valley View Dr, Houston, TX, 77002 | 0.98 | Placeholder values cleared |
| PRV-21771 | PRV | Eugene Henderson | 1985-03-10 | — | 4875833046 | 6761 Ridge Rd, Tucson, AZ, 85770 | 0.98 | Phone reformatted |
| PRV-23889 | PRV | Tyler Elliott | 1954-01-14 | — | 6192587292 | 6868 Hillcrest Rd, Plano, TX, 75038 | 0.98 | Placeholder values cleared |
| PRV-26985 | PRV | Jerry U Young | 1989-07-01 | UHC-52799-01 | 2719414876 | 2539 Lincoln Way, Chandler, AZ, 85294 | 0.98 | Placeholder values cleared |
| PRV-21217 | PRV | Suan Sanchez | 1984-01-12 | UHC-49183-97 | — | — | 0.98 | Placeholder values cleared |
| PRV-27164 | PRV | Marcus E Myers | 1989-08-13 | — | — | 95 Lake View Rd, Tucson, AZ, 85700 | 0.98 | Placeholder values cleared |
| PRV-28980 | PRV | George Williamson | 1953-03-23 | UHC-20277-01 | 3152509653 | — | 0.98 | Placeholder values cleared |
| PRV-20730 | PRV | Heather Howaard | 1954-04-18 | — | — | 784 Forest Ave, Houston, TX, 77048 | 0.98 | Placeholder values cleared |
| PRV-28481 | PRV | Danielle Diaz | 1947-03-24 | UHC-42957-15 | — | 2992 Jefferson Ave, Miami, FL, 33121 | 0.98 | Placeholder values cleared |
| PRV-22930 | PRV | Emily Nguyen | 2005-12-28 | — | 9036446652 | 2586 Indian School Rd, Sacramento, CA, 95836 | 0.98 | Placeholder values cleared |
| PRV-25155 | PRV | Andrew Ross | 2003-02-09 | — | 8252584957 | — | 0.98 | Placeholder values cleared |
| PRV-24554 | PRV | Daniel Myers | 1991-01-22 | — | 3248792863 | 2242 Camelback Rd, Gilbert, AZ, 85258 | 0.98 | Placeholder values cleared |
| PRV-21220 | PRV | Nathan R Greene | 1974-10-10 | UHC-57579-63 | 8039060134 | 277 Cedar Ln, Columbus, OH, 43236 | 0.98 | Placeholder values cleared |
| PRV-24023 | PRV | Patricia Patel | 1958-07-09 | UHC-33252-46 | 7033724602 | 3400 Central Ave, Nashville, TN, 37256 | 0.98 | Placeholder values cleared |
| PRV-28528 | PRV | Frances Wood | 1962-08-02 | — | 4173919073 | — | 0.98 | Placeholder values cleared |
| PRV-28369 | PRV | Joyce D Cooper | 2000-04-03 | UHC-90049-06 | 8408126761 | 459 Cedar Ln, Columbus, OH, 43270 | 0.98 | Placeholder values cleared |
| PRV-24409 | PRV | Janet Jones | 1955-05-14 | — | 3788306660 | 2586 River Rd, Eden Prairie, MN, 55337 | 0.98 | Placeholder values cleared |
| PRV-24410 | PRV | Janet Jones | 1955-05-14 | UHC-82508-98 | 3788306660 | 2586 River Rd, Eden Prairie, MN, 55337 | 0.98 | Placeholder values cleared |
| PRV-22030 | PRV | Gregory Willis | 1955-05-27 | UHC-33667-24 | 8742720651 | — | 0.98 | Placeholder values cleared |
| PRV-28069 | PRV | Virgginia E Wheeler | 1965-06-02 | — | 9404923172 | 3426 Main St, Denver, CO, 80277 | 0.98 | Placeholder values cleared |
| PRV-24247 | PRV | Donna Welch | 1976-06-06 | UHC-78754-72 | — | — | 0.98 | Placeholder values cleared |
| PRV-24448 | PRV | Scott Marshall | 2006-04-02 | — | 5498864722 | 728 Grand Ave, Chandler, AZ, 85223 | 1.00 | Clean |
| PRV-24720 | PRV | Hiroshi Hendersn | 1954-09-17 | — | 5593648863 | 3888 Church St, Phoenix, AZ, 85049 | 1.00 | Clean |
| PRV-24046 | PRV | Omar Jones | 1945-07-03 | UHC-47663-26 | 5794713525 | 8618 Bayshore Dr, Tucson, AZ, 85700 | 1.00 | Clean |
| PRV-20362 | PRV | Theresa Alvaraado | 2002-04-28 | — | 6038637157 | 4091 Ridge Rd, Atlanta, GA, 30371 | 1.00 | Clean |
| PRV-28801 | PRV | Rebecca Chavez | 1970-11-09 | UHC-48366-81 | — | — | 1.00 | Clean |