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-22951 | PRV | Nancy Lynch | 1970-02-10 | UHC-62977-75 | 8325056289 | 1365 Spring St, Denver, CO, 80289 | 0.72 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-26083 | PRV | Samantha G Fowler | 1947-10-17 | — | 9442115222 | 5051 Mountain View Dr, Gilbert, AZ, 85228 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-24434 | PRV | Teresa Harrison | 2007-01-27 | — | — | 1781 Harbor Blvd, San Antonio, TX, 78294 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27368 | PRV | Aaron Lopez | 2003-04-10 | UHC-79349-76 | 2832008018 | 2613 Palm Dr, Fresno, CA, 93785 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20663 | PRV | Hiroshi D Baker | 1984-01-19 | UHC-28647-99 | 4398996615 | 6310 Indian School Rd, Glendale, AZ, 85357 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-20662 | PRV | Hiroshi D Baker | 1984-01-19 | UHC-28647-99 | 4398996615 | 6310 Indian School Rd, Glendale, AZ, 85357 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-29129 | PRV | Susan Contreras | 1963-04-01 | UHC-06057-20 | 5623228934 | 7437 Sage Ct, Columbus, OH, 43295 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20343 | PRV | James Bryant | 2000-12-16 | — | — | 8331 Mesa Dr, Glendale, AZ, 85377 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24857 | PRV | Janice L Carlson | 1973-10-08 | — | 2506697187 | 6435 Highland Ave, Fresno, CA, 93784 | 0.74 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-29405 | PRV | Denise Morales | 1952-09-16 | UHC-22051-95 | — | 6636 Meadow Ln, Charlotte, NC, 28220 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22435 | PRV | Jason Rice | 1973-09-06 | — | 6978119305 | 5229 Sage Ct, Gilbert, AZ, 85227 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23266 | PRV | Alexander Reynolds | 1990-08-03 | — | 6993042577 | 7344 Cedar Ln, Glendale, AZ, 85333 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-24250 | PRV | Tim Sims | 2008-09-12 | UHC-24501-74 | 8627090425 | 3299 River Rd, Las Vegas, NV, 89134 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21251 | PRV | Joyce D Ramos | 1952-01-06 | — | 5677609145 | 471 Spring St, Las Vegas, NV, 89109 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-24126 | PRV | Ralph Wang | 1957-12-03 | UHC-14239-31 | 9104336575 | 5835 Washington St, Chandler, AZ, 85295 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27578 | PRV | Yuki U Perez | 1986-01-19 | — | 6265875624 | 5798 Elm St, Sacramento, CA, 95846 | 0.74 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-24815 | PRV | Lias Mills | 1942-08-12 | — | 6846097269 | 4582 Pine Dr, Las Vegas, NV, 89107 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21029 | PRV | Christian Perez | 1978-01-11 | UHC-47113-40 | — | 9660 Grand Ave Apt 35, Tempe, AZ, 85211 | 0.74 | Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+3 more |
| PRV-28830 | PRV | Diane Carter | 1974-06-22 | — | 3799179824 | 663 Main St, San Diego, CA, 92173 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27539 | PRV | Omar Valdaz | 1961-04-21 | — | 7395475822 | 6802 Highland Ave, Scottsdale, AZ, 85215 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20829 | PRV | Ben Greene | 1994-06-08 | — | 5836925529 | 1364 Oak St, Dallas, TX, 75286 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22881 | PRV | Jessica R Fox | 1991-05-08 | UHC-31731-49 | 4932291787 | 2148 Apache Blvd, Jacksonville, FL, 32241 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26617 | PRV | Abigail Soto | 1953-03-27 | UHC-46807-97 | 6174447910 | 3268 Lake View Rd, Mesa, AZ, 85252 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24371 | PRV | Wayne N Aguilar | 1998-01-22 | UHC-31468-14 | 3359284877 | 8546 Hillcrest Rd, Columbus, OH, 43204 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-27374 | PRV | Judy Espinoza | 1940-07-03 | — | 6108541427 | 4889 Cedar Ln, Los Angeles, CA, 90056 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-22736 | PRV | Scott Jacobs | 1954-07-22 | UHC-89192-22 | 3704954147 | 9709 Grand Ave, Tampa, FL, 33658 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-24571 | PRV | Kevin Austin | 1961-08-28 | UHC-21846-45 | 4956428308 | 5743 Union St, Scottsdale, AZ, 85270 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-27717 | PRV | Kevin L Tucker | 1951-06-09 | UHC-01358-75 | 3235213877 | 1128 Harbor Blvd, Columbus, OH, 43242 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-27716 | PRV | Kevin L Tucker | 1951-06-09 | UHC-01358-75 | 3235213877 | 1128 Harbor Blvd, Columbus, OH, 43242 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-20202 | PRV | Ashley Brown | 1940-06-24 | — | 6696799132 | 1274 Ridge Rd, Nashville, TN, 37257 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-20203 | PRV | Ashley Brown | 1940-06-24 | — | 6696799132 | 1274 Ridge Rd, Nashville, TN, 37257 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-22803 | PRV | Billy Holmes | 1941-01-13 | UHC-51978-56 | 4696482637 | 1950 Valley View Dr, Charlotte, NC, 28241 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-24366 | PRV | Dennis Murphy | 1962-08-12 | — | 3272899178 | 1093 Baseline Rd, Plano, TX, 75094 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-24849 | PRV | Christian Wheeler | 1961-12-05 | UHC-52926-58 | 3179274242 | 1245 Cedar Ln, Seattle, WA, 98100 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-22322 | PRV | Gloria Kim | 1953-04-03 | UHC-38778-99 | 4409054905 | 4694 Sunset Blvd, Tempe, AZ, 85237 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21484 | PRV | Jerry Andrews | 1974-08-08 | UHC-29366-06 | 7103215741 | 3021 Hillcrest Rd, Plano, TX, 75055 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21485 | PRV | Jerry Andrews | 1974-08-08 | UHC-29366-06 | 7103215741 | 3021 Hillcrest Rd, Plano, TX, 75055 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26133 | PRV | Pamela X Rodriguez | 1996-11-07 | UHC-63913-60 | 4616804801 | 1749 Hillcrest Rd, Fresno, CA, 93795 | 0.74 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-21378 | PRV | Peteer Clark | 1947-06-08 | — | 6056117774 | 275 Cedar Ln, Denver, CO, 80294 | 0.74 | Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| PRV-28194 | PRV | Nicholas Jackson | 1987-08-03 | UHC-25427-08 | 5773694218 | 1109 Maple Ave, Chandler, AZ, 85260 | 0.74 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-28195 | PRV | Nicholas Jackson | 1987-08-03 | UHC-25427-08 | 5773694218 | 1109 Maple Ave, Chandler, AZ, 85260 | 0.74 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-25969 | PRV | Logan Gardner | 1946-06-26 | UHC-53930-19 | 5898706565 | 6261 Washington St, San Antonio, TX, 78256 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23811 | PRV | Aaron Rojes | 1980-11-08 | UHC-11544-93 | 3164352379 | 1121 Union St, Houston, TX, 77058 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24491 | PRV | Diana Oliver | 2003-10-02 | — | 3282569089 | 4633 Hillcrest Rd, Seattle, WA, 98134 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-23401 | PRV | Stephanie Flores | 1990-11-05 | UHC-94918-95 | 9376058985 | 1443 Elm St, Los Angeles, CA, 90020 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-20464 | PRV | Mary Murray | 1980-11-05 | — | 2116793407 | 1000 Spring St, Miami, FL, 33103 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23976 | PRV | Brittany Munoz | 1960-04-02 | UHC-87830-57 | 8025740413 | 8564 Meadow Ln, Orlando, FL, 32831 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29053 | PRV | Wille Rogers | 1940-07-17 | UHC-19353-05 | 3196414899 | 3843 Mesa Dr, Las Vegas, NV, 89176 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26694 | PRV | Melissa Dean | 1947-06-22 | UHC-69799-61 | 7139706252 | 3888 Harbor Blvd, Phoenix, AZ, 85065 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20970 | PRV | Dorothy Rogers | 1976-08-24 | — | 3407199887 | 5012 Elm St, Dallas, TX, 75238 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |