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-28059 | PRV | Ruth L Flores | 1999-02-18 | — | 4807777238 | 7256 Valley View Dr, Gilbert, AZ, 85292 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-27766 | PRV | Carl Q Porter | 1982-09-09 | — | 9712830586 | 7075 Willow Ct, Miami, FL, 33172 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-25797 | PRV | Sarah S Hawkins | 1991-12-19 | — | 8364227329 | 4993 Ocean Ave, Charlotte, NC, 28234 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-27878 | PRV | Virginia Green | 1963-10-26 | — | 2292047499 | 8700 Sunset Blvd, San Diego, CA, 92126 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-23457 | PRV | Jesse S Kim | 1974-05-20 | UHC-24310-96 | 4098056816 | 2579 Harbor Blvd, Denver, CO, 80213 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-26297 | PRV | Dyln L Bowman | 1983-06-22 | — | 4386976432 | 2383 Cedar Ln, Jacksonville, FL, 32237 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-28207 | PRV | Rachel Alexander | 2008-03-24 | — | 7002753367 | 7317 Apache Blvd # 596, Nashville, TN, 37288 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| PRV-21858 | PRV | Betty Ramos | 1944-01-17 | UHC-55325-32 | 8826606445 | 9450 Valley View Dr, Tucson, AZ, 85774 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| PRV-26974 | PRV | Dennis Morris | 1956-08-01 | UHC-52301-44 | 4529291801 | 1163 Willow Ct Apt 1, Minneapolis, MN, 55485 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| PRV-26927 | PRV | Tyler Taylor | 1957-10-27 | — | 4296298195 | 4037 Indian School Rd, Las Vegas, NV, 89163 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-29589 | PRV | Alan Mendez | 1979-10-25 | UHC-71838-76 | 5805988097 | 7393 Central Ave, Eden Prairie, MN | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-25103 | PRV | Arthur T Burke | 1969-01-09 | UHC-65754-38 | 3563516373 | 9271 Desert Sky Blvd, Dallas, TX, 75216 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-29202 | PRV | Nicole Rice | — | — | 9634760847 | 735 Mesa Dr, Denver, CO, 80260 | 0.60 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| PRV-22675 | PRV | Janice Marshall | 1952-09-07 | — | 6509203588 | 2157 Highland Ave, Scottsdale, AZ, 85251 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-20518 | PRV | Arthur N Mason | 1975-07-11 | UHC-95789-74 | 3373974367 | 5652 Jefferson Ave, San Antonio, TX, 78266 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-25541 | PRV | Heather Mitchell | 1979-10-22 | UHC-85304-14 | 3157239515 | 9293 Apache Blvd Apt 12, Chandler, AZ, 85240 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| PRV-20420 | PRV | Justin Rodriguez | 1953-06-15 | — | 8384529521 | 8205 Baseline Rd, Chandler, AZ, 85267 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| PRV-24061 | PRV | Nancy Millls | 1981-07-20 | UHC-00702-28 | 4706389323 | 7380 Oak St, Charlotte, NC, 28244 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-24060 | PRV | Nancy Millls | 1981-07-20 | UHC-00702-28 | 4706389323 | 7380 Oak St, Charlotte, NC, 28244 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-21592 | PRV | Valeentina B Duncan | 1952-02-08 | — | 3317667418 | 5220 Indian School Rd, Los Angeles, CA, 90089 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-23859 | PRV | Gary Miller | 1993-04-20 | — | 2112920633 | 6416 Harbor Blvd, Los Angeles, CA, 90038 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-23609 | PRV | Brandon Banks | 1955-04-16 | UHC-97066-54 | 5904177591 | 41 Central Ave, Houston, TX, 77073 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-27494 | PRV | Charles Rojas | 2001-12-27 | UHC-80561-02 | 3305238014 | 7847 Camelback Rd Apt 17, Los Angeles, CA, 90003 | 0.60 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| PRV-26246 | PRV | Alexis Payne | 1960-09-09 | UHC-05678-36 | 8432121327 | 309 Indian School Rd, Phoenix, AZ, 85062 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-25838 | PRV | Jen Guerrero | 1942-11-07 | UHC-50155-20 | 9665290172 | 8528 Washington St, Fresno, CA, 93701 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-26809 | PRV | Teresa Chavez | 1980-12-08 | — | 3717833852 | 2318 Harbor Blvd, Mesa, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-23786 | PRV | William X Rodriguez | 1968-09-04 | — | 2233375882 | 5466 Church St, Gilbert, AZ, 85239 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-24715 | PRV | Timothy Robertson | 1952-01-06 | UHC-04478-97 | 4249515029 | 2331 Valley View Dr, Orlando, FL, 32820 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-24822 | PRV | Edward K Cox | 1978-07-11 | — | 4298913946 | 8251 Sage Ct, Houston, TX, 77023 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-28345 | PRV | Martha E Estrada | 1990-04-12 | UHC-83322-47 | 5293748078 | 4612 Park Pl, Miami, FL, 33164 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-26038 | PRV | Sean Padilla | 1952-08-23 | UHC-71398-04 | 2802396017 | 1293 Harbor Blvd, Eden Prairie, MN, 55346 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-21973 | PRV | Madison Hamilton | 1990-02-09 | — | 2217902733 | 2720 Forest Ave, Scottsdale, AZ, 85288 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-20305 | PRV | Joan Singh | 1960-03-25 | — | 7248919613 | 5676 Palm Dr, Eden Prairie, MN, 55317 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-23166 | PRV | Willie V Dunn | 1967-09-07 | UHC-04570-88 | 2374412395 | 7513 Jefferson Ave, Minneapolis, MN, 55476 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-25276 | PRV | Jordan Mitchell | 1999-01-13 | UHC-41287-90 | 9138838022 | 882 Lake View Rd, Dallas, TX, 75281 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-22365 | PRV | Angela E Saazar | 2001-02-03 | UHC-20499-93 | 6846723646 | 9038 Lincoln Way, Atlanta, GA, 30362 | 0.60 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more |
| PRV-21090 | PRV | Donna Hughes | 1994-12-11 | UHC-61161-67 | 8208645508 | 5811 Desert Sky Blvd, Columbus, OH | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-28507 | PRV | Steven Cunningham | 1982-11-19 | UHC-73884-40 | 5426180439 | 9570 Palm Dr, Jacksonville, FL, 32217 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-25572 | PRV | Theresa Austin | 1996-09-22 | UHC-47101-37 | 8906088000 | 8576 Canyon Rd, Mesa, AZ, 85245 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-22765 | PRV | Bobby Perz | 2005-02-16 | — | 6677276081 | 669 Ridge Rd, Plano, TX | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-26241 | PRV | HelenJunk | 1991-05-18 | UHC-00390-60 | 6782075902 | 5356 Oak St, Dallas, TX, 75217 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-28501 | PRV | Susan Diaz | 1963-09-01 | UHC-72659-15 | 3115621473 | 9143 Desert Sky Blvd, Phoenix, AZ, 85009 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| PRV-25789 | PRV | Henry C Brooks | 1980-08-28 | UHC-09209-87 | 2086981397 | 9799 Pine Dr, Denver, CO, 80217 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-25262 | PRV | Wayne D Castro | 1950-09-06 | — | 8149912985 | 2524 Baseline Rd Apt 24, Sacramento, CA, 95862 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| PRV-23978 | PRV | Ethan Morgan | 1939-03-26 | — | 8378715781 | 6874 Baseline Rd, Fresno, CA, 93715 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| PRV-27496 | PRV | Ahmed V Montgomery | 1993-10-05 | UHC-74670-82 | 8973874035 | 6407 Grand Ave, Tempe, AZ | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| PRV-27934 | PRV | Jon Weber | 1998-03-17 | — | 8673342688 | 4212 Maple Ave, Gilbert, AZ, 85239 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-26393 | PRV | Thomas Rodriguez | 1948-09-10 | — | 8356459710 | 6430 Maple Ave, Minneapolis, MN, 55497 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-25332 | PRV | Dylan Watkins | 1957-02-07 | UHC-98153-10 | 6263297888 | 7577 Highland Ave, Glendale, AZ, 85378 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-28403 | PRV | Larry Bishop | 1967-05-20 | UHC-45766-39 | 5288871754 | 3231 Mountain View Dr # 403, Mesa, AZ, 85261 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |