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-26758 | PRV | Rachel X Daniels | 1952-07-18 | — | 2017855360 | 6715 Cedar Ln, Glendale, AZ, 85312 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28068 | PRV | Janet Dixon | 1983-02-25 | — | 3052815865 | 6872 Palm Dr, Seattle, WA, 98184 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21105 | PRV | Charyl Montgomery | 1991-03-14 | UHC-59035-49 | 2064742682 | 3629 Elm St, Dallas, TX, 75207 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-26191 | PRV | Gerald Larson | 1986-02-15 | — | 4435153502 | 8163 Valley View Dr, Atlanta, GA, 30381 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-24655 | PRV | Jose Green | 1998-10-12 | — | 7353054363 | 6617 Ocean Ave, Los Angeles, CA, 90002 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-25274 | PRV | Amy N Larson | 2005-06-02 | UHC-16715-78 | 9346058373 | 1811 Canyon Rd, Scottsdale, AZ, 85207 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21167 | PRV | Juile Contreras | 1939-10-28 | — | 2788724238 | 7644 Hillcrest Rd, Phoenix, AZ, 85039 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-25852 | PRV | Maria Morgan | 2007-02-11 | — | — | 6055 Willow Ct, Mesa, AZ, 85273 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-27205 | PRV | Bobby Dixon | 1984-11-06 | — | 9475334176 | 9367 Grand Ave, Las Vegas, NV, 89112 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24386 | PRV | Eugene Wallace | 1942-06-16 | UHC-99190-14 | 2207335096 | 8878 Baseline Rd, Jacksonville, FL, 32219 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27728 | PRV | Helen N Wagner | 1999-06-21 | — | 5417787587 | 7248 Union St, Atlanta, GA, 30341 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29227 | PRV | Larry Wong | 2001-10-02 | UHC-68223-92 | 7385895507 | 5452 Ridge Rd, Orlando, FL, 32886 | 0.76 | Name re-casedDate of birth reformattedState name converted to codePlan code upper-cased+2 more |
| PRV-21042 | PRV | Michelle A Lane | 1940-12-15 | UHC-28177-51 | 5816174089 | 7817 Lake View Rd, Phoenix, AZ, 85050 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-24331 | PRV | Jacob K Carr | 1995-12-25 | UHC-36540-95 | 7363781750 | 473 Grand Ave, San Antonio, TX, 78203 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20414 | PRV | Christian Welch | 1975-07-15 | UHC-53208-60 | 4503146399 | 4593 Elm St, Jacksonville, FL, 32299 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26385 | PRV | Emma Barnes | 1960-10-15 | UHC-43601-62 | 4779654838 | 3633 Desert Sky Blvd, Tucson, AZ, 85724 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-23123 | PRV | Mark T Harvey | 1969-12-23 | UHC-89999-98 | — | 7633 Bayshore Dr, Los Angeles, CA, 90094 | 0.76 | Name re-casedMember ID reformattedCity re-casedGender normalised+2 more |
| PRV-26641 | PRV | Haamilton Joseph | 1978-12-24 | — | — | 6887 Hillcrest Rd, Plano, TX, 75052 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28668 | PRV | Austin I Parker | 1952-07-03 | UHC-47167-07 | 3268066971 | 3166 Spring St, Miami, FL, 33123 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23362 | PRV | Ann Williamson | 1963-04-10 | — | 5353523822 | 402 Elm St, Miami, FL, 33107 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-26044 | PRV | Natalie Fields | 1991-03-02 | UHC-40274-76 | 9393577098 | 8410 Desert Sky Blvd, Tucson, AZ, 85720 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26509 | PRV | Jason Barnes | 1942-02-25 | UHC-10046-01 | 3638638695 | 8995 Indian School Rd, Fresno, CA, 93781 | 0.76 | Name re-casedDate of birth reformattedMember ID reformattedEmail lower-cased+2 more |
| PRV-26477 | PRV | Jonathan M Gibson | 1978-02-08 | UHC-88509-08 | 6126597893 | 3380 Lake View Rd, Seattle, WA | 0.76 | Name re-casedPhone reformattedCity re-casedZIP missing+2 more |
| PRV-29384 | PRV | Dennis Ferguson | 1954-09-28 | — | 2343626613 | 3009 Desert Sky Blvd, Eden Prairie, MN, 55396 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24152 | PRV | Jessica Morgan | 1957-05-01 | UHC-15395-10 | 3054304965 | 4019 Meadow Ln Apt 7, Glendale, AZ, 85317 | 0.76 | Name re-casedPhone reformattedUnit split from streetCity re-cased+2 more |
| PRV-24025 | PRV | Julia X Cunningam | 1954-05-28 | — | — | 3668 Spring St, Austin, TX, 78725 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28818 | PRV | Emily K Sanders | 1986-01-07 | UHC-00963-32 | 8853812859 | 261 Park Pl, Plano, TX, 75086 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-29433 | PRV | Jesse Hill | 1960-10-07 | UHC-84855-30 | 9426064653 | 9848 Indian School Rd, Jacksonville, FL, 32219 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23426 | PRV | Henry H Chapman | 2003-09-18 | UHC-23775-12 | 3826187785 | 1764 Canyon Rd, Glendale, AZ, 85371 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more |
| PRV-20483 | PRV | Mark Ryan | 1964-07-12 | UHC-13819-28 | 9753254922 | 3174 Harbor Blvd, Los Angeles, CA, 90047 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24756 | PRV | Lori Z Gibson | 1960-08-15 | — | 8174259575 | 8161 Ridge Rd, Austin, TX, 78715 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20568 | PRV | Sara Holmes | 1940-12-28 | — | 4394379229 | 31 Cedar Ln, Fresno, CA, 93736 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27694 | PRV | Anna Vega | 1982-11-17 | — | 4439452931 | 3495 Mountain View Dr, Phoenix, AZ, 85097 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-29231 | PRV | Yukki Simpson | 1964-09-27 | UHC-06184-67 | 2542366654 | 3800 Ridge Rd, Charlotte, NC, 28212 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27920 | PRV | Maria Obren | 1962-09-02 | — | — | 432 Elm St, Miami, FL, 33149 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-21698 | PRV | Omar Wood | 1986-11-02 | UHC-49107-09 | 6787691835 | 5185 Pine Dr, Las Vegas, NV, 89146 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23742 | PRV | Heather Chapman | 1981-12-02 | UHC-90502-74 | 6795081731 | 7036 Park Pl, Minneapolis, MN, 55418 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-22743 | PRV | Danielle Anderson | 1985-08-09 | — | 4277272430 | 8155 Church St, Charlotte, NC, 28284 | 0.76 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more |
| PRV-28939 | PRV | Kathryn Ray | 1974-06-13 | — | 9389458983 | 531 Union St, Eden Prairie, MN, 55370 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-27265 | PRV | Ronald Valdez | 1978-10-18 | — | 7287468816 | 9019 Central Ave, Jacksonville, FL, 32234 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-29155 | PRV | Edward K Burton | 2004-10-20 | UHC-96686-35 | 8339089193 | 1763 Palm Dr, Mesa, AZ, 85244 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28182 | PRV | Kyle L Wber | 1987-08-09 | — | 9683645938 | 9279 Forest Ave, San Diego, CA, 92182 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25410 | PRV | Bruce Olson | 1938-06-21 | — | 4864539108 | 2751 Ridge Rd, Seattle, WA, 98165 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26709 | PRV | Price J Priya | 1991-09-09 | UHC-86266-54 | 3308573968 | 7229 Harbor Blvd, Dallas, TX, 75289 | 0.76 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| PRV-20313 | PRV | Kenneth I Wog | 1994-06-21 | — | 5963981491 | 6751 Central Ave, Chandler, AZ, 85250 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27177 | PRV | Julie Alexander | 1996-01-22 | — | 7983554718 | 6091 Highland Ave, Miami, FL | 0.76 | Name re-casedPhone reformattedCity re-casedZIP missing+2 more |
| PRV-28961 | PRV | Sophia Soto | 1949-02-25 | — | 5622436561 | 8505 Ridge Rd, Jacksonville, FL, 32287 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-20042 | PRV | Jacqueline P Watson | 1974-05-28 | — | 8933271096 | 2412 Valley View Dr, Fresno, CA, 93727 | 0.76 | Date of birth reformattedPhone reformattedCity re-casedZIP+4 trimmed+2 more |
| PRV-21894 | PRV | Lauren Jordan | 1995-07-18 | — | 6187192622 | 3684 Ridge Rd, Minneapolis, MN, 55492 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23778 | PRV | Jessica Snyder | 1964-07-06 | UHC-92417-51 | 2095371111 | 7170 Desert Sky Blvd, Sacramento, CA, 95866 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |