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-27102 | PRV | Austin White | 1964-06-23 | UHC-80016-18 | 6328572529 | 2976 Market St, Minneapolis, MN, 55456 | 0.90 | Date of birth reformattedPhone reformattedMember ID reformattedWhitespace trimmed+1 more |
| PRV-23511 | PRV | Donald Griffin | 1953-10-07 | UHC-86624-42 | 6425235502 | 2979 Maple Ave, Dallas, TX, 75258 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-24067 | PRV | Nancy D Walsh | 1946-02-24 | UHC-03744-02 | 9755220095 | 5331 Lake View Rd, Minneapolis, MN, 55449 | 0.90 | Phone reformattedMember ID reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-25411 | PRV | Brue Olson | 1938-06-21 | — | 4864539108 | — | 0.90 | Date of birth reformattedPhone reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-28553 | PRV | Johnny T Armstrong | 1957-10-05 | UHC-89431-35 | 8637177539 | 7191 Main St, Las Vegas, NV, 89149 | 0.90 | Date of birth reformattedPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-27519 | PRV | Walter Morris | 1945-08-18 | — | 7528552367 | 9310 Forest Ave, Las Vegas, NV, 89124 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-26517 | PRV | Matthew Schmidt | 1990-04-09 | UHC-21293-99 | 7876960213 | — | 0.90 | Name re-casedMember ID reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-21556 | PRV | Christopehr Wallace | 2000-08-07 | — | 5297517988 | 2898 Indian School Rd, San Diego, CA, 92101 | 0.90 | Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-27267 | PRV | Frances D Jackson | 1961-02-19 | — | 2867510402 | 809 Apache Blvd, Minneapolis, MN, 55415 | 0.90 | Date of birth reformattedPhone reformattedState code upper-casedWhitespace trimmed+1 more |
| PRV-25918 | PRV | Henry Z Munoz | 2000-08-25 | UHC-77648-08 | 4953088610 | 9181 Oak St, Tempe, AZ, 85216 | 0.90 | Name re-casedPhone reformattedMember ID reformattedWhitespace trimmed+1 more |
| PRV-29173 | PRV | Willie Walker | 1944-02-16 | UHC-63045-56 | 5155736492 | 3616 Oak St, Los Angeles, CA, 90057 | 0.90 | Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-20342 | PRV | Elizebeth G West | 1964-07-01 | UHC-23324-07 | 3665091188 | 9763 Apache Blvd, San Antonio, TX, 78294 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-29346 | PRV | Natalie Nguyen | 1999-08-14 | UHC-95171-02 | 3027117996 | — | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-21022 | PRV | Ewdard N Porter | 1999-07-28 | UHC-26683-20 | — | 226 Broadway, Houston, TX, 77018 | 0.90 | Name re-casedMember ID reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-26461 | PRV | Ryan Garrett | 2005-04-05 | UHC-63270-32 | — | 7441 Market St, Minneapolis, MN, 55455 | 0.90 | Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-23761 | PRV | Ruth Vazquez | 2006-09-08 | UHC-11615-56 | 2439617794 | 3458 Oak St, San Antonio, TX, 78282 | 0.90 | Name re-casedDate of birth reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-20589 | PRV | Charles Alvarado | 1982-06-16 | — | 9086343767 | 2654 Cedar Ln, Minneapolis, MN, 55448 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-23628 | PRV | Melizsa Rivera | 1960-04-26 | UHC-44304-88 | 4159307452 | 2772 Park Pl, Atlanta, GA, 30378 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-29081 | PRV | Janet Lewis | 1970-10-07 | — | 6164624999 | 3583 River Rd, Phoenix, AZ, 85055 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+1 more |
| PRV-22029 | PRV | Brian J Taylor | 1941-09-09 | UHC-39486-76 | 2872784657 | 3111 Mesa Dr, Columbus, OH, 43207 | 0.90 | Name re-casedPhone reformattedState code upper-casedWhitespace trimmed+1 more |
| PRV-23279 | PRV | Charles C Bryant | 1969-02-06 | UHC-01319-03 | 4216140249 | — | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-22621 | PRV | Janice V Carlson | 2000-11-15 | — | 8155964117 | 627 Lincoln Way, Nashville, TN, 37253 | 0.90 | Date of birth reformattedPhone reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-26616 | PRV | Sharon Campbell | 1956-06-07 | UHC-06772-04 | 4465041093 | 878 Canyon Rd, Tucson, AZ, 85718 | 0.90 | Name re-casedPhone reformattedCity re-casedEmail lower-cased+1 more |
| PRV-23564 | PRV | Judy Cooper | 1964-09-18 | — | — | 3369 Apache Blvd, Gilbert, AZ, 85221 | 0.90 | Date of birth reformattedCity re-casedEmail lower-casedWhitespace trimmed+1 more |
| PRV-24864 | PRV | Bryna Y Rogers | 1943-10-08 | — | 7809418520 | 6623 Mountain View Dr, Phoenix, AZ, 85082 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-22252 | PRV | William McDonald | 1987-08-17 | — | 5639889435 | 2281 Pine Dr, Las Vegas, NV, 89161 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-23839 | PRV | Jordan Q Elliott | 1991-03-24 | — | 2489273796 | — | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-20237 | PRV | Matthew Brown | 1973-10-21 | UHC-42622-26 | 4644624267 | 9216 Desert Sky Blvd, Chandler, AZ, 85285 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-21483 | PRV | Kathy Padilla | 1969-03-14 | — | 9738738383 | 8881 Pine Dr, Fresno, CA, 93762 | 0.90 | Name re-casedPhone reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-27279 | PRV | Jose Tucker | 2004-12-21 | UHC-36863-60 | 3314349662 | 4862 Sage Ct, Las Vegas, NV, 89113 | 0.90 | Name re-casedPhone reformattedMember ID reformattedWhitespace trimmed+1 more |
| PRV-20911 | PRV | Mariana C Collins | 1966-09-24 | — | 7359498191 | 9011 Pine Dr, Jacksonville, FL, 32277 | 0.90 | Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-23727 | PRV | Ashley D Schmidt | 1947-03-01 | — | 8658408318 | 4122 Grand Ave, Tucson, AZ, 85714 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-27773 | PRV | Sharon Salazar | 1961-01-18 | UHC-10097-24 | 3908660416 | 6442 Market St, Denver, CO, 80278 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-26247 | PRV | Randy Carlson | 1948-01-28 | UHC-66217-85 | 3114600537 | 9624 Baseline Rd, Dallas, TX, 75207 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-22752 | PRV | Betty Mendoza | 1951-07-26 | UHC-65583-73 | 6337960987 | 9797 Valley View Dr, Mesa, AZ, 85231 | 0.90 | Name re-casedPhone reformattedMember ID reformattedWhitespace trimmed+1 more |
| PRV-24190 | PRV | Steve B Hayes | 1945-03-09 | — | 8712752032 | 5994 Willow Ct, Scottsdale, AZ, 85264 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-27024 | PRV | Christine Powell | 1984-11-14 | — | 9619844221 | 1042 Maple Ave, Houston, TX, 77000 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-24785 | PRV | Ashley George | 1995-02-09 | — | 7176625753 | 9213 Forest Ave, Charlotte, NC, 28214 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-27174 | PRV | Joseph O Richards | 1959-08-11 | — | 4788827316 | 821 Broadway, Glendale, AZ, 85333 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-27175 | PRV | Joseph O Richards | 1959-08-11 | — | 4788827316 | 821 Broadway, Glendale, AZ, 85333 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-23865 | PRV | Walter E Mitchell | 1938-07-02 | UHC-47670-92 | 3999909734 | 7108 Washington St, San Diego, CA, 92160 | 0.90 | Date of birth reformattedPhone reformattedMember ID reformattedWhitespace trimmed+1 more |
| PRV-23723 | PRV | Nancy Johnson | 1956-08-03 | UHC-08685-37 | 7753400220 | 7906 Broadway, Tucson, AZ, 85789 | 0.90 | Date of birth reformattedPhone reformattedMember ID reformattedWhitespace trimmed+1 more |
| PRV-21254 | PRV | Arthur K Meyer | 1985-07-06 | UHC-06599-74 | 4806786816 | 1047 Mountain View Dr, Houston, TX, 77050 | 0.90 | Name re-casedPhone reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-25864 | PRV | Theresa Garcia | 1940-11-08 | UHC-73103-71 | 9435629635 | 2889 Camelback Rd, Fresno, CA, 93725 | 0.90 | Name re-casedPhone reformattedMember ID reformattedCity re-cased+1 more |
| PRV-28015 | PRV | Brenda E Stewart | 1958-03-28 | UHC-39537-90 | 3394791544 | 2741 Hillcrest Rd, Miami, FL, 33143 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-21357 | PRV | Brenda L Stephens | 2000-03-02 | — | 8762196814 | 7450 Spring St, Tampa, FL, 33658 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+1 more |
| PRV-27208 | PRV | Samuel Y Simmons | 1945-05-25 | UHC-47169-69 | 8474100580 | 519 Grand Ave, Orlando, FL, 32885 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-29145 | PRV | Teresa Munoz | 1949-05-17 | — | 5286735953 | 4514 Broadway, Orlando, FL, 32868 | 0.90 | Name re-casedPhone reformattedAddress re-casedWhitespace trimmed+1 more |
| PRV-27687 | PRV | Martha Snyder | 1989-05-08 | — | 7964328536 | 6526 Broadway, Plano, TX, 75074 | 0.90 | Name re-casedDate of birth reformattedCity re-casedEmail lower-cased+1 more |
| PRV-23216 | PRV | Brittany Stephens | 1945-01-14 | UHC-39290-82 | 9795777865 | 3384 Oak St, Columbus, OH, 43201 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |