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-26356 | PRV | George X Robinson | 1999-01-11 | — | 9589138536 | 4700 Highland Ave, Miami, FL, 33160 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23900 | PRV | Jordan Alvarado | 1984-03-12 | — | 4434067287 | 4827 Lake View Rd, Fresno, CA, 93725 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23065 | PRV | Mei Weber | 2005-05-07 | — | 5263491293 | 7138 Indian School Rd, Eden Prairie, MN, 55310 | 0.76 | Name re-casedPhone reformattedCity re-casedState name converted to code+2 more |
| PRV-24919 | PRV | Deeborah Price | 1940-11-15 | UHC-27304-07 | 3907276725 | 6605 Highland Ave, Phoenix, AZ, 85095 | 0.76 | Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28346 | PRV | Briittany Jacobs | 1952-07-13 | UHC-43748-69 | 4894834848 | 1326 Elm St, Los Angeles, CA, 90006 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25667 | PRV | Catherine Fuller | 1961-02-27 | UHC-08698-57 | 9046520459 | 3944 Oak St Apt 37, Denver, CO, 80224 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more |
| PRV-24653 | PRV | Randy Marshall | 2007-12-17 | — | 5213290907 | 1355 Harbor Blvd, Los Angeles, CA, 90048 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-26936 | PRV | Scott Marshall | 1985-02-16 | UHC-57608-82 | 7816414872 | 6184 Church St, Glendale, AZ, 85347 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-21869 | PRV | Dorothy Rose | 1979-11-05 | UHC-42865-97 | 7815800226 | 1083 Market St, Fresno, CA, 93779 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-21896 | PRV | Hiroshi P Nunez | 1976-12-20 | — | 4909072204 | 9881 Forest Ave, Gilbert, AZ, 85215 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29327 | PRV | Vincent Rliey | 1964-12-24 | UHC-46418-02 | 6384599174 | 1651 Grand Ave, Atlanta, GA, 30381 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21739 | PRV | Mari Daniels | 1982-10-09 | — | 9882751065 | 5183 Sunset Blvd, Fresno, CA, 93783 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28689 | PRV | Barbara Owens | 2002-06-24 | — | 5953490383 | 4882 Church St, Chandler, AZ, 85256 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-28044 | PRV | Scott Mitchell | 1975-02-20 | — | 7735492511 | 9701 Main St, Scottsdale, AZ, 85219 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-20780 | PRV | Teresa Freeman | 1960-04-11 | UHC-86980-83 | — | 6947 Elm St, Miami, FL, 33116 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-24268 | PRV | Mateo Ellliott | 1996-02-27 | — | 5548525222 | 8436 Highland Ave, San Diego, CA, 92196 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28097 | PRV | Hiroshi Moore | 1950-09-08 | — | 3349456011 | 952 Union St, Glendale, AZ, 85388 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23402 | PRV | Arjun O Jackson | 1988-01-06 | UHC-19640-97 | 8265469652 | 9393 Forest Ave, Jacksonville, FL, 32294 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25037 | PRV | William X Gonzales | 1977-08-17 | UHC-92544-37 | 4629391825 | 2689 Market St, Minneapolis, MN, 55475 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23895 | PRV | Camila Snyder | 1951-11-11 | — | 3255531780 | 8443 Valley View Dr, Austin, TX, 78762 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26688 | PRV | Sean F Mendoza | 1962-11-14 | — | 9033023098 | 7046 Highland Ave, Atlanta, GA, 30380 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29224 | PRV | Mason Q Stone | 1983-10-10 | — | — | 5591 Park Pl, Glendale, AZ, 85392 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-27781 | PRV | George K Dominguez | 1961-11-27 | UHC-82930-52 | 2814436322 | 684 Highland Ave, Scottsdale, AZ, 85265 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-29269 | PRV | Larry N Hamilton | 1963-11-20 | UHC-53343-08 | 8167876758 | 890 Apache Blvd, Gilbert, AZ, 85264 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-20769 | PRV | Christine Henry | 1952-04-26 | — | 9073872354 | 217 Elm St, Charlotte, NC, 28262 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22411 | PRV | Alice P Wang | 1938-03-05 | UHC-19783-63 | 7666882633 | 9104 River Rd, Austin, TX, 78739 | 0.76 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23898 | PRV | Evelyn Y Reyes | 1999-09-05 | UHC-54787-27 | 6927560326 | 48 Mountain View Dr, Los Angeles, CA, 90035 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27219 | PRV | Alexander V Silva | 1984-08-10 | UHC-70392-45 | 3258510146 | 5783 Pine Dr, Phoenix, AZ, 85008 | 0.76 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| PRV-24647 | PRV | Margaret Bailey | 1998-02-27 | UHC-26153-91 | 2706876690 | 3713 Cedar Ln, Gilbert, AZ, 85210 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21808 | PRV | Gabriel Brown | 1995-05-27 | — | 9387919979 | 3573 Forest Ave, Tampa, FL, 33681 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28786 | PRV | Mateo Y Gardner | 1991-11-03 | UHC-88333-70 | 2283716017 | 2185 Market St, Minneapolis, MN, 55468 | 0.76 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more |
| PRV-22964 | PRV | Bryan Lynch | 1957-04-19 | — | 8449923921 | 7025 Bayshore Dr, Chandler, AZ, 85247 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23643 | PRV | Jean Chen | 1989-09-10 | — | 7803961369 | 9310 Camelback Rd, Plano, TX, 75025 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25153 | PRV | Judy L Silva | 1973-11-13 | — | 5246309303 | 4581 River Rd, Tempe, AZ, 85296 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21729 | PRV | Alexander Reed | 1960-08-02 | UHC-32257-08 | 4352731328 | 7671 Church St, Austin, TX, 78717 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-29165 | PRV | Carl Sims | 1964-06-26 | UHC-22625-51 | 8967386776 | 3056 Indian School Rd, Tucson, AZ, 85781 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28235 | PRV | Margaret J Jordan | 1966-06-21 | UHC-24141-95 | 7087911723 | 3038 Sage Ct, Tempe, AZ, 85286 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23410 | PRV | Debra Cook | 1943-11-19 | UHC-39496-64 | 2486045893 | 4011 Palm Dr, Orlando, FL, 32860 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25626 | PRV | Anthony F Fernandez | 1950-07-04 | — | 7575491957 | 899 River Rd, Jacksonville, FL, 32254 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20762 | PRV | Cheryl Dunn | 1988-05-22 | UHC-52816-13 | 7768574988 | 6558 Canyon Rd, Columbus, OH, 43256 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23073 | PRV | Santiago Snydre | 1990-10-11 | — | 6966411171 | 7460 Forest Ave, Jacksonville, FL, 32230 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27824 | PRV | Catherine U Medina | 1970-09-07 | UHC-50377-75 | 3318657151 | 4377 Park Pl, Houston, TX, 77001 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23372 | PRV | Mateo A King | 1951-02-19 | UHC-58436-86 | 6123188216 | 4459 Hillcrest Rd, Tempe, AZ, 85203 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more |
| PRV-21993 | PRV | Alexis Fernandez | 1944-09-25 | — | 8329421719 | 4367 Valley View Dr, Scottsdale, AZ, 85267 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27977 | PRV | Alexander Hudson | 1964-03-17 | UHC-67582-64 | 4126394110 | 965 Hillcrest Rd, Gilbert, AZ, 85290 | 0.76 | Name re-casedPhone reformattedMember ID reformattedState name converted to code+2 more |
| PRV-27167 | PRV | Sophia F Scott | 1949-03-16 | UHC-50442-67 | 3436297675 | 3828 Palm Dr, Charlotte, NC, 28283 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22105 | PRV | Abigail R Jenkins | 1943-02-14 | UHC-10662-01 | 9712970797 | 2333 Central Ave, Tempe, AZ, 85295 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27757 | PRV | Brittany Walsh | 1984-05-09 | — | 9664013822 | 6263 Forest Ave, Denver, CO, 80220 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27756 | PRV | Brittany Walsh | 1984-05-09 | — | 9664013822 | 6263 Forest Ave, Denver, CO, 80220 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21055 | PRV | Christopher Burns | 1996-12-12 | — | 3549422013 | 7466 Union St, Charlotte, NC, 28296 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |