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-23006 | PRV | Lucia Q Owens | 1974-12-12 | UHC-52968-42 | 9672899100 | — | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-29193 | PRV | Walter Munoz | 2002-05-12 | UHC-46892-79 | 5025352140 | 6152 Sage Ct, Seattle, WA, 98156 | 0.94 | Phone reformattedEmail lower-casedPlaceholder values cleared |
| PRV-27644 | PRV | Brittany Wang | 1995-11-14 | — | — | 3355 River Rd, Miami, FL, 33185 | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-20599 | PRV | Arthur Garrett | 1965-11-27 | UHC-35004-63 | 4847752631 | 5313 Sunset Blvd, Charlotte, NC, 28207 | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |
| PRV-27468 | PRV | Patterson N Dorothy | 1963-07-14 | — | 9399406003 | 3384 Cedar Ln, Nashville, TN, 37266 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-23392 | PRV | Kimberly Y Vazquez | 1959-02-18 | — | — | 7007 Church St, Mesa, AZ, 85246 | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-21182 | PRV | Jonathan Richards | 1986-09-07 | UHC-51651-96 | 6914342207 | 4292 Camelback Rd, Charlotte, NC, 28231 | 0.94 | Phone reformattedMember ID reformattedPlaceholder values cleared |
| PRV-21334 | PRV | Arjun Austin | 1962-11-21 | — | 7974787148 | 1298 Union St, Charlotte, NC, 28274 | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-27263 | PRV | Christina H Hawkins | 1975-10-25 | — | 2014856966 | — | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |
| PRV-27953 | PRV | Joshua Herrera | 1954-10-01 | UHC-29222-37 | 7236077992 | 8343 Washington St, Columbus, OH, 43249 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-22826 | PRV | Logan Lews | 1969-06-02 | — | 5757926798 | 5160 Church St, Dallas, TX, 75205 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-27105 | PRV | Jack Rose | 1954-02-02 | UHC-37958-45 | — | — | 0.94 | Member ID reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-27764 | PRV | Sam Palmer | 2000-08-01 | UHC-81616-47 | 6529075080 | 7508 Cedar Ln, Chandler, AZ, 85208 | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |
| PRV-21003 | PRV | Carol Q Carlson | 1994-06-12 | UHC-74968-93 | 2485851096 | 841 Central Ave, Dallas, TX, 75220 | 0.94 | Phone reformattedMember ID reformattedPlaceholder values cleared |
| PRV-22069 | PRV | Larry Myers | 2001-02-11 | UHC-76370-95 | — | 6114 Church St, Atlanta, GA, 30327 | 0.94 | City re-casedEmail lower-casedPlaceholder values cleared |
| PRV-20949 | PRV | Gerald V Robertson | 1997-03-28 | UHC-86460-12 | 7969302546 | 7199 Camelback Rd, San Diego, CA, 92127 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-28978 | PRV | Olivia Hawkins | 1955-07-12 | — | — | — | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |
| PRV-21115 | PRV | Catherine Warren | 1967-02-15 | UHC-42276-35 | 8208426413 | 290 Grand Ave, Fresno, CA, 93735 | 0.94 | Phone reformattedMember ID reformattedPlaceholder values cleared |
| PRV-24803 | PRV | Jose L Morrison | 1953-08-27 | UHC-06840-28 | 7077132703 | — | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-28158 | PRV | Harper Michelle | 1952-04-17 | UHC-59426-45 | 8208969482 | 3693 Union St, Plano, TX, 75080 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-20745 | PRV | Kelly Carter | 1964-06-03 | UHC-41007-06 | — | — | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-23748 | PRV | Jennifer E Watson | 2004-05-07 | — | 8907140389 | 9725 Harbor Blvd, Tucson, AZ, 85783 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-20645 | PRV | Katherine Bowman | 1957-01-08 | — | 7706308355 | — | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-28208 | PRV | Elijah Padilla | 2006-09-07 | UHC-90343-90 | 4285014942 | 5747 Willow Ct, Glendale, AZ, 85381 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-20727 | PRV | Camila Woods | 1994-01-23 | UHC-11477-78 | 5385908180 | 1429 Lincoln Way, Jacksonville, FL, 32284 | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |
| PRV-22192 | PRV | Diana Freeman | 1984-11-23 | — | 3899674890 | 9230 Market St, Charlotte, NC, 28295 | 0.94 | Date of birth reformattedPhone reformattedPlaceholder values cleared |
| PRV-26990 | PRV | Doris Barnes | 1980-03-13 | — | — | 9519 Washington St, Denver, CO, 80204 | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-22027 | PRV | Laura Kelly | 1956-02-22 | UHC-41118-16 | 5728815057 | 9767 Broadway, Minneapolis, MN, 55477 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-20869 | PRV | Kathleen Gibson | 2007-07-19 | — | 3352473029 | — | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-22109 | PRV | Hannah Rose | 1969-11-16 | — | 2465355809 | 3727 Sunset Blvd, Denver, CO, 80280 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-24028 | PRV | Wayne Ryan | 1988-04-16 | — | 6204195305 | — | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-26084 | PRV | Keith Diaz | 1996-11-13 | — | 8696037650 | 2922 Park Pl, Minneapolis, MN, 55455 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-25776 | PRV | Sofia Matthews | 1948-02-23 | — | 7109726382 | — | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-20507 | PRV | Bryan Mitchell | 1940-10-05 | — | — | — | 0.94 | Date of birth reformattedEmail lower-casedPlaceholder values cleared |
| PRV-27295 | PRV | Michelle Gutierrez | 1998-01-28 | UHC-25707-51 | 6387680342 | 6253 Grand Ave, Orlando, FL, 32870 | 0.94 | City re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-23225 | PRV | Scott Nguyn | 2003-07-04 | UHC-18187-48 | 6503855194 | 343 Broadway, Phoenix, AZ, 85047 | 0.94 | Date of birth reformattedPhone reformattedPlaceholder values cleared |
| PRV-21304 | PRV | Grace Gardner | 1961-12-10 | UHC-54937-30 | — | — | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-20801 | PRV | Danielle Perry | 1981-01-25 | UHC-15283-06 | 7823792073 | 372 Church St, Denver, CO, 80253 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-23536 | PRV | Diego L Carroll | 1953-07-05 | UHC-04213-88 | 9617760210 | — | 0.94 | Email lower-casedWhitespace trimmedPlaceholder values cleared |
| PRV-25318 | PRV | Heather Reid | 1963-12-13 | UHC-28309-78 | 8945046104 | 2510 Apache Blvd, Tucson, AZ, 85735 | 0.94 | Phone reformattedEmail lower-casedPlaceholder values cleared |
| PRV-28174 | PRV | Benjamin Brown | 1989-10-03 | — | 8598417434 | 3447 Sage Ct, Denver, CO, 80241 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-20509 | PRV | Martha D Harrison | 1980-03-26 | UHC-15211-78 | — | 7138 Lincoln Way, Denver, CO, 80288 | 0.94 | State code upper-casedWhitespace trimmedPlaceholder values cleared |
| PRV-27602 | PRV | Ahmed Nichols | 1966-12-09 | — | — | — | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |
| PRV-27833 | PRV | Jaanet A Jimenez | 1962-03-12 | UHC-69017-81 | — | 4320 Ocean Ave, Las Vegas, NV, 89175 | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |
| PRV-20256 | PRV | Sarah Garrett | 1983-06-22 | UHC-10408-31 | 2517175277 | 9114 Indian School Rd, San Diego, CA, 92186 | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |
| PRV-26026 | PRV | Wayne Y Brown | 1980-08-27 | — | — | — | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-27030 | PRV | Bradley Daniels | 1938-07-26 | UHC-73036-62 | 5104665254 | 9430 Lincoln Way, Los Angeles, CA, 90046 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-28717 | PRV | Sandra G Hart | 1957-12-16 | UHC-88610-44 | 9508397903 | 9810 Jefferson Ave, San Diego, CA, 92119 | 0.94 | Phone reformattedEmail lower-casedPlaceholder values cleared |
| PRV-24178 | PRV | Paul D Collins | 1958-04-25 | — | — | 2464 Central Ave, San Diego, CA, 92124 | 0.94 | Date of birth reformattedCity re-casedWhitespace trimmed |
| PRV-23782 | PRV | Hannah Simmons | 1981-12-04 | UHC-61478-12 | 5957911275 | — | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |