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-20496 | PRV | Sandra K Boyd | 1973-03-18 | UHC-29823-55 | 7297898421 | 1044 Spring St, Tucson, AZ, 85737 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-29490 | PRV | Diego Lawrence | 1978-11-27 | UHC-74911-24 | 8476469423 | 4864 River Rd, Denver, CO, 80200 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-20716 | PRV | Keith M Price | 1986-07-18 | UHC-04874-92 | 4895728598 | 9495 Palm Dr, Austin, TX, 78749 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-27379 | PRV | Christine V White | 1945-10-20 | — | 6519930768 | 9707 Bayshore Dr, Gilbert, AZ, 85269 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-22756 | PRV | Brandon P Mejia | 1994-12-12 | — | 3879324177 | 3682 Cedar Ln, Minneapolis, MN, 55463 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-20697 | PRV | Jacob Black | 1992-12-02 | — | 3687801602 | 8159 Canyon Rd, Sacramento, CA, 95831 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-20698 | PRV | Jacob Black | 1992-12-02 | — | 3687801602 | 8159 Canyon Rd, Sacramento, CA, 95831 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-22180 | PRV | Daniel M Garcia | 1961-06-10 | — | 4136142747 | 7755 Washington St, Mesa, AZ, 85270 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-22748 | PRV | Elizabeth Carr | 1986-10-18 | — | 7794334987 | 4100 Ocean Ave, Charlotte, NC, 28226 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-21434 | PRV | Mariana C Hawkins | 1960-03-08 | UHC-87456-54 | 2203509097 | 9230 Mountain View Dr, Gilbert, AZ, 85264 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| PRV-29272 | PRV | Kevin Washington | 2008-09-28 | — | 4967725739 | 7626 Ridge Rd Apt 10, Plano, TX, 75046 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| PRV-28485 | PRV | Arthur R Johnson | 1954-04-15 | — | 8954334474 | 8934 Forest Ave, Los Angeles, CA, 90099 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| PRV-25010 | PRV | Amber T Hudson | 1941-01-09 | — | 5118964922 | 1218 Willow Ct, San Diego, CA, 92119 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-26790 | PRV | Jordan Oliver | 1981-11-21 | — | 3197505190 | 4263 Spring St Apt 35, Las Vegas, NV, 89178 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| PRV-25763 | PRV | Cheryl F Rivera | 1943-05-15 | UHC-22669-61 | 5642154559 | 2517 Baseline Rd, Tempe, AZ, 85257 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-22715 | PRV | Rachel W Elliott | 1995-11-25 | — | 9612852033 | 9231 River Rd, San Antonio, TX | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-20921 | PRV | Fatima Schmidt | 1943-10-08 | — | 3442240097 | 3998 Palm Dr, Denver, CO | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-22969 | PRV | Sarh Wright | 2007-07-09 | UHC-88130-96 | — | 3671 Sunset Blvd, Nashville, TN, 37271 | 0.60 | Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| PRV-24359 | PRV | Randy Meyer | 1984-07-26 | UHC-39293-88 | 7072619905 | 2773 Mountain View Dr, Tucson, AZ, 85753 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-29197 | PRV | Denise Pena | 2001-09-06 | — | 6838444648 | 5007 Pine Dr, Miami, FL, 33107 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-27802 | PRV | Weaver F Margaret | — | — | 3792112495 | 3370 Mountain View Dr, Phoenix, AZ, 85092 | 0.60 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| PRV-20814 | PRV | Omar Vazquz | 1953-09-15 | UHC-33790-46 | — | 753 Camelback Rd Apt 21, Tucson, AZ, 85752 | 0.60 | Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+4 more |
| PRV-24840 | PRV | Deborah Maldonado | 1958-04-28 | — | 8394392191 | 904 Canyon Rd, Fresno, CA | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-28248 | PRV | SarahJunk | 1953-06-09 | UHC-91177-68 | 6255821797 | 6005 Cedar Ln, Phoenix, AZ, 85018 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| PRV-27209 | PRV | Kelly Munoz | 1971-07-06 | — | 6109535292 | 997 Bayshore Dr, Tempe, AZ, 85247 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-27455 | PRV | Arthur P Carter | 1953-09-20 | — | 5048582651 | 7582 Washington St, Chandler, AZ, 85272 | 0.60 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more |
| PRV-25681 | PRV | Timothy Clark | 1959-09-22 | UHC-35369-94 | 3883590899 | 1801 Mountain View Dr, Orlando, FL, 32874 | 0.60 | Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| PRV-26833 | PRV | Dylan Martin | 1946-03-15 | UHC-41516-35 | 9334409259 | 3591 Lake View Rd # 279, Tampa, FL, 33622 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more |
| PRV-28161 | PRV | Walter Willis | 1941-06-12 | UHC-67611-72 | 8569997249 | 9245 Ocean Ave, Las Vegas, NV, 89150 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-23788 | PRV | Anthony Lawson | 1994-06-11 | — | 7758864925 | 4179 Sunset Blvd, Jacksonville, FL, 32288 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-26259 | PRV | Brittany Mendez | 1946-05-27 | UHC-75234-10 | 9825017689 | 5701 Baseline Rd, Columbus, OH, 43234 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-26234 | PRV | Francas Diaz | 1972-11-19 | UHC-60722-75 | 6888686172 | 5477 Hillcrest Rd, Houston, TX | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-22565 | PRV | Willie Webb | 2006-09-24 | — | 3536897247 | 7251 Willow Ct, Miami, FL, 33199 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-27735 | PRV | Ahmed B Lewis | 1971-06-27 | UHC-60945-08 | 9306282183 | 6845 Indian School Rd, Columbus, OH, 43216 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-25366 | PRV | Brian Price | 1958-10-20 | UHC-78316-88 | 7703849318 | 2834 Broadway, Las Vegas, NV, 89171 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+4 more |
| PRV-20440 | PRV | Larry Ortega | 1970-10-10 | UHC-13292-28 | 3102216691 | 6320 Baseline Rd, Eden Prairie, MN, 55358 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-28048 | PRV | Martha Campbell | 1970-12-14 | UHC-78455-90 | 4176077919 | 3970 Harbor Blvd, Gilbert, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-24114 | PRV | Jon I Estrada | 2004-11-27 | — | — | 1699 Hillcrest Rd, Miami, FL, 33123 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-22161 | PRV | Hiroshi R Harper | 2008-03-06 | — | 7746266530 | 6123 Baseline Rd, Nashville, TN | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-28519 | PRV | Carol Henry | 1999-11-03 | UHC-64577-07 | 4805727690 | 2837 Broadway, Orlando, FL, 32847 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| PRV-29378 | PRV | Jack Yang | 1992-01-27 | — | 4359854255 | 1847 Central Ave, Gilbert, AZ | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-26236 | PRV | Carolyn Walker | 1997-04-28 | — | 6283121431 | 911 Mountain View Dr, Minneapolis, MN, 55471 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| PRV-20296 | PRV | Peter U Carter | 1999-02-24 | UHC-21483-29 | 5982547530 | 8215 Market St, Fresno, CA, 93755 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-20004 | PRV | James K Hunter | 1960-03-14 | UHC-68519-05 | 9746357738 | 6535 Bayshore Dr, Orlando, FL | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-20717 | PRV | Christian Gomez | 1984-11-27 | — | 4393874184 | 7865 Bayshore Dr, Austin, TX, 78733 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-20786 | PRV | Lucia Gonzales | 1955-04-17 | UHC-58807-87 | 3995271271 | 2783 Sage Ct, San Antonio, TX, 78241 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| PRV-20049 | PRV | Janet Reynolds | 2006-01-25 | — | 4838155220 | 2291 Central Ave, Dallas, TX, 75275 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-29098 | PRV | Ahmed O Coleman | 1975-03-03 | — | 5126065971 | 4581 Forest Ave, Columbus, OH, 43255 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-20412 | PRV | Chris P Espinoza | 1994-09-18 | UHC-74983-53 | 8208831326 | 5093 Lake View Rd, Eden Prairie, MN, 55378 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-28131 | PRV | Melissa Simmons | 1993-10-05 | UHC-31521-24 | 3114715238 | 3474 Sage Ct # 627, Atlanta, GA, 30381 | 0.60 | Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+4 more |