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-24258 | PRV | Nancy R Cole | 2002-04-25 | UHC-89188-42 | — | 8672 Bayshore Dr, Atlanta, GA, 30324 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25606 | PRV | Amanda U King | 1986-07-04 | — | 3299230443 | 1813 Maple Ave, Mesa, AZ, 85208 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26285 | PRV | Riley I Marcus | 1963-12-07 | UHC-91091-69 | 8256558062 | 7986 Union St, Los Angeles, CA, 90099 | 0.76 | Date of birth reformattedPhone reformattedState name converted to codeEmail lower-cased+2 more |
| PRV-25147 | PRV | Roger Edwards | 2002-10-01 | UHC-27243-62 | 8782199861 | 7296 Union St, Tempe, AZ, 85298 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25055 | PRV | Yuki Rios | 1979-11-21 | — | 5425797223 | 2827 Central Ave, Orlando, FL, 32883 | 0.76 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more |
| PRV-29123 | PRV | Nathan Lewis | 1952-06-10 | UHC-96932-40 | 8036967538 | 8798 Park Pl, Sacramento, CA, 95848 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21004 | PRV | Kellly Shaw | 1994-12-10 | UHC-70062-36 | — | 7662 Lake View Rd, Chandler, AZ, 85265 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27574 | PRV | Sharon L Stevens | 1948-08-04 | UHC-69450-62 | 6828459845 | 5794 Jefferson Ave, Los Angeles, CA, 90084 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29247 | PRV | Terry Hansen | 1994-10-11 | — | 8696771414 | 213 Pine Dr, Columbus, OH, 43272 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-21204 | PRV | Bruce Nichols | 1943-10-11 | UHC-21925-74 | 4717227129 | 7296 Indian School Rd, San Antonio, TX, 78234 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21827 | PRV | Brittany Robinson | 1966-08-08 | UHC-17369-36 | 7726091297 | 521 Lincoln Way, Austin, TX, 78797 | 0.76 | Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+2 more |
| PRV-26408 | PRV | Cynthia Q Ortega | 1943-02-04 | UHC-81402-27 | 4387570627 | 8531 Mountain View Dr, Atlanta, GA, 30311 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29283 | PRV | William I Vargas | 1981-12-28 | UHC-52456-25 | 5274421061 | 5990 Apache Blvd, Nashville, TN, 37247 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21790 | PRV | Frank Murray | 2006-09-23 | UHC-51068-95 | 6035882037 | 6786 Mountain View Dr, Fresno, CA, 93779 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28348 | PRV | Brandon E Peters | 2000-03-27 | — | 4913998978 | 1442 Harbor Blvd, Eden Prairie, MN, 55392 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28592 | PRV | Christine Hughes | 1964-05-10 | — | 3112840799 | 3921 Bayshore Dr, Orlando, FL, 32893 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21597 | PRV | Mariana Sanders | 1991-09-09 | — | 8117223521 | 2727 Willow Ct, Tempe, AZ, 85244 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more |
| PRV-29565 | PRV | Melissa Perez | 1938-08-04 | UHC-17175-25 | 9395377186 | 631 Union St, Sacramento, CA, 95842 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-22618 | PRV | Beverly Wilson | 1942-07-05 | — | 6135429013 | 6056 Forest Ave, Jacksonville, FL, 32289 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-24039 | PRV | Bruce Banks | 1983-06-21 | — | 3515860335 | 5040 Harbor Blvd, Atlanta, GA, 30334 | 0.76 | Phone reformattedCity re-casedEmail lower-casedGender normalised+2 more |
| PRV-29038 | PRV | Jessica Alvarez | 1950-03-27 | — | 7407250663 | 976 Sunset Blvd, Gilbert, AZ, 85218 | 0.76 | Date of birth reformattedPhone reformattedState code upper-casedZIP+4 trimmed+2 more |
| PRV-25479 | PRV | Justin Schultz | 1985-08-09 | UHC-07089-67 | 4286094867 | 6556 Mountain View Dr, Glendale, AZ, 85309 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-20650 | PRV | Alexis W Shaw | 2006-03-21 | UHC-99178-38 | 2864031843 | 7789 Union St, Los Angeles, CA, 90090 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24458 | PRV | Aaron Evans | 1944-06-16 | UHC-51560-75 | 6935365422 | 2320 Central Ave, Austin, TX, 78753 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26955 | PRV | Mei Q Carter | 1992-06-24 | — | 4672594055 | 635 Highland Ave, Houston, TX, 77055 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28651 | PRV | Dylan R Fuller | 1938-03-20 | UHC-49709-97 | 6133801722 | 9644 Indian School Rd, Miami, FL | 0.76 | Phone reformattedMember ID reformattedState code upper-casedZIP missing+2 more |
| PRV-24475 | PRV | Kyle Harrison | 1967-05-15 | — | 6359648948 | 2106 Mountain View Dr, Gilbert, AZ, 85217 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-26851 | PRV | Rachel Garza | 1951-02-09 | — | 2363283587 | 4470 Park Pl, Fresno, CA, 93732 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28043 | PRV | Lawrence Ellis | 1972-12-15 | UHC-86802-85 | 3298366874 | 2366 Indian School Rd, San Diego, CA, 92152 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26288 | PRV | Stephanie Alvarado | 1994-11-24 | — | 9217919909 | 7956 Camelback Rd, Las Vegas, NV, 89197 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23998 | PRV | Sarah I Oliver | 1996-07-24 | UHC-32902-31 | 2285136446 | 4779 Union St, Minneapolis, MN, 55405 | 0.76 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23997 | PRV | Sarah I Oliver | 1996-07-24 | UHC-32902-31 | 2285136446 | 4779 Union St, Minneapolis, MN, 55405 | 0.76 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28550 | PRV | Christine A Rios | 1942-05-09 | — | 4482283647 | 2798 Jefferson Ave, Nashville, TN, 37216 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23016 | PRV | Pat H Sanchez | 1955-04-09 | UHC-04893-31 | 2199865988 | 8588 Church St, Dallas, TX, 75215 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22518 | PRV | Larry Spencer | 1961-04-01 | UHC-08518-76 | — | 3145 Sunset Blvd, Austin, TX, 78795 | 0.76 | Name re-casedMember ID reformattedEmail lower-casedGender normalised+2 more |
| PRV-27654 | PRV | Aisha V Wilson | 1964-02-01 | — | 6583317945 | 2473 Bayshore Dr, Nashville, TN, 37229 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25407 | PRV | Billy T Ryan | 1941-06-01 | — | 5717744679 | 9764 Union St, Scottsdale, AZ, 85241 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20723 | PRV | Brittany Wright | 1946-05-25 | UHC-09549-37 | — | 9086 Hillcrest Rd, Miami, FL, 33101 | 0.76 | Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+2 more |
| PRV-24277 | PRV | Henry Pierce | 2006-12-27 | UHC-37182-32 | 2612814971 | 1170 Camelback Rd, Jacksonville, FL, 32208 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22467 | PRV | Camila M Lucas | 1959-11-09 | — | 4029460018 | 1620 Jefferson Ave, Dallas, TX, 75232 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24996 | PRV | Danielle G Garza | 1996-10-19 | UHC-85381-16 | 6062864936 | 3040 Spring St, Glendale, AZ, 85371 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-27426 | PRV | Martha Watsoon | 1976-12-23 | — | 6966517927 | 6159 Union St, Eden Prairie, MN, 55365 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20571 | PRV | Justin Cooper | 1943-04-08 | — | 8333266042 | 8956 Baseline Rd, Fresno, CA, 93724 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-22585 | PRV | Susan Chavez | 1982-09-21 | — | 3233610184 | 6323 Camelback Rd, Charlotte, NC, 28229 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-20110 | PRV | David Padilla | 1952-11-13 | UHC-51025-47 | 5289081998 | 5065 Hillcrest Rd, Tampa, FL, 33633 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23153 | PRV | Carol Hughs | 1979-02-28 | — | 3375477490 | 2280 Bayshore Dr, Seattle, WA, 98128 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26996 | PRV | Wei K Powell | 1941-11-23 | — | 7154287219 | 4263 Cedar Ln, Glendale, AZ, 85343 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22198 | PRV | Amanda Rodriguez | 1951-11-11 | — | 2043474799 | 2060 Valley View Dr, Tampa, FL, 33618 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22470 | PRV | Catherine M Gomez | 1998-10-01 | — | 4822010233 | 2035 Lake View Rd, Atlanta, GA, 30395 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-20180 | PRV | Lisa Fernandez | 1994-08-02 | — | 4397644733 | 6537 Lake View Rd, Nashville, TN, 37219 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |