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-26417 | PRV | Henry Allen | — | UHC-76663-03 | 8587768212 | 8503 Pine Dr, Columbus, OH, 43254 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+3 more |
| PRV-27313 | PRV | Philip Lawson | 1987-09-26 | — | 9528017086 | 5269 Hillcrest Rd, Plano, TX, 75056 | 0.62 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24524 | PRV | Sofia Lopaz | 1997-04-09 | — | 6672772546 | 5094 Mesa Dr Apt 23, Gilbert, AZ, 85254 | 0.62 | Name re-casedPhone reformattedUnit split from streetZIP+4 trimmed+3 more |
| PRV-25083 | PRV | Yuki Olson | 1963-11-14 | UHC-91705-70 | 5208408983 | 2544 Forest Ave, Fresno, CA, 93788 | 0.62 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-21938 | PRV | Sophia Carroll | 1979-02-23 | UHC-64413-52 | 5816388412 | 5642 Desert Sky Blvd, Atlanta, GA, 30394 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28905 | PRV | Diane Castillo | 1968-06-08 | UHC-29993-99 | 4447381256 | 8444 Camelback Rd, Miami, FL | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22491 | PRV | Davis Jason | 2008-11-02 | UHC-10468-58 | 8886258419 | 8435 Pine Dr, Gilbert, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22490 | PRV | Davis Jason | 2008-11-02 | UHC-10468-58 | 8886258419 | 8435 Pine Dr, Gilbert, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22643 | PRV | Paul Warren | 1989-02-11 | UHC-23202-90 | 6558986393 | 4438 Willow Ct, Los Angeles, CA | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20169 | PRV | Amy Husdon | 1994-02-15 | UHC-74527-15 | 8087278334 | 8671 Willow Ct, Denver, CO | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| PRV-22807 | PRV | Sophia Taylor | — | UHC-53505-21 | 2156519022 | 9815 Washington St, Orlando, FL, 32842 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| PRV-27118 | PRV | Danielle Herrera | 1948-03-21 | UHC-14995-82 | 4577387148 | 3140 Lincoln Way, Denver, CO, 80238 | 0.62 | Name re-casedPhone reformattedCity re-casedState name converted to code+3 more |
| PRV-26293 | PRV | Walter Cook | 1962-06-25 | UHC-07206-18 | 8353676991 | 4996 Meadow Ln, Tampa, FL, 33611 | 0.62 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29134 | PRV | Joshua Gonzales | 2001-03-06 | — | 4668332251 | 4712 Sunset Blvd, Phoenix, AZ, 85052 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25771 | PRV | Brenda Lewis | 1977-10-20 | UHC-78243-99 | 9142238628 | 4565 Church St, Las Vegas, NV, 89169 | 0.62 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21476 | PRV | William Dominguez | 1971-05-26 | UHC-78896-13 | 4583567555 | 7833 Baseline Rd, Columbus, OH, 43213 | 0.62 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21390 | PRV | Bradley Schmidt | 1954-04-16 | UHC-91040-77 | 9573535031 | 7492 Camelback Rd, Eden Prairie, MN, 55395 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more |
| PRV-26602 | PRV | Jeffrey Yang | 1953-08-11 | — | 6374470197 | 3040 Cedar Ln, Seattle, WA, 98108 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29295 | PRV | Denise Walker | 1960-07-11 | — | 3915528076 | 4844 Palm Dr # 237, Nashville, TN, 37274 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-27179 | PRV | Billy M Burns | 1994-09-28 | UHC-06095-01 | 6327330132 | 1909 River Rd, Columbus, OH, 43251 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26307 | PRV | Nathan Martin | 1993-02-17 | UHC-79747-51 | 3632210883 | 3231 Central Ave, Las Vegas, NV, 89120 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more |
| PRV-25337 | PRV | Carolyn D Coleman | 1985-08-11 | — | 4407605969 | 6924 Bayshore Dr, Jacksonville, FL, 32225 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22879 | PRV | Linda Lawrence | 1940-05-16 | — | 8735890123 | 9391 Indian School Rd, Scottsdale, AZ, 85237 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24035 | PRV | Christian Sanders | 1966-12-19 | UHC-91645-49 | 3813776241 | 1092 Park Pl, Tucson, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28399 | PRV | David P Price | 1938-01-09 | — | 6524434175 | 7458 Bayshore Dr, Columbus, OH, 43245 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-28277 | PRV | Bryan Y Foster | 2001-12-01 | — | 4513496968 | 636 Ocean Ave, Fresno, CA | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28039 | PRV | Philip Wells | — | — | 6092012456 | 5226 Baseline Rd, San Antonio, TX, 78229 | 0.62 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more |
| PRV-21261 | PRV | Alice Moris | 1995-06-09 | UHC-55977-01 | 6809602952 | 9349 Ocean Ave, Chandler, AZ, 85264 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22209 | PRV | Henry Z Hoffmaan | 1945-04-24 | UHC-24303-37 | 9004649957 | 8962 Hillcrest Rd, Orlando, FL, 32845 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21309 | PRV | Amber F White | 1962-01-21 | — | 8209117647 | 2131 Sunset Blvd # 710, Miami, FL, 33105 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-25096 | PRV | Mason Armstrong | 1938-08-21 | — | 9819027659 | 3613 Highland Ave, Columbus, OH | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-21347 | PRV | Mason Bowman | 1979-01-19 | — | 4143894502 | 1815 Sunset Blvd, Atlanta, GA, 30348 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22166 | PRV | Kiimberly White | — | UHC-64583-03 | — | 6560 Camelback Rd, San Antonio, TX, 78255 | 0.62 | Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more |
| PRV-26634 | PRV | Donna Miller | 1941-04-07 | — | 2442213102 | 4906 Canyon Rd, Jacksonville, FL, 32202 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22230 | PRV | Samantha Greene | 1976-09-02 | UHC-56755-08 | 2279261166 | 1516 Highland Ave, San Diego, CA, 92151 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24041 | PRV | Fatima James | 1988-09-04 | — | 2188143101 | 5401 Market St, Fresno, CA, 93774 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21201 | PRV | Julie M Garza | 1973-01-15 | — | 7675696487 | 6575 Meadow Ln, Seattle, WA, 98191 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29267 | PRV | Lawrence McDonald | 1941-07-03 | UHC-88707-71 | — | 970 Main St, Fresno, CA | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| PRV-29268 | PRV | Lawrence McDonald | 1941-07-03 | UHC-88707-71 | — | 970 Main St, Fresno, CA | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| PRV-28603 | PRV | Donald Banks | 1971-06-13 | — | 4742355070 | 5222 Camelback Rd, Austin, TX, 78730 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25493 | PRV | Wayne Bishop | 1999-10-26 | UHC-11867-64 | 7338562727 | 8020 Spring St, Scottsdale, AZ, 85252 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28660 | PRV | Stevens Zachary | 1983-11-03 | — | 2497305113 | 6105 Park Pl, Chandler, AZ, 85270 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24662 | PRV | Mary James | 1951-07-02 | — | 8399511799 | 4017 Mountain View Dr, Scottsdale, AZ, 85265 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-28543 | PRV | Jonathan Mendoza | 1997-01-20 | — | 6033249527 | 5911 Meadow Ln # 921, Dallas, TX, 75203 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-22625 | PRV | Mariana Mason | 1965-12-17 | UHC-25369-28 | 4572467847 | 7478 Mountain View Dr, Jacksonville, FL, 32270 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-25635 | PRV | Joe Sullivan | 1976-08-10 | UHC-21823-12 | 5595949883 | 6632 Baseline Rd, Miami, FL, 33142 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-23622 | PRV | Carlos Guerrero | 1960-03-11 | — | 6975859369 | 53 Grand Ave, Gilbert, AZ, 85241 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-29143 | PRV | Christine Murray | 1955-07-07 | UHC-07405-48 | 3613998351 | 894 Elm St, Orlando, FL, 32823 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24397 | PRV | Alexander D Welch | 1986-01-05 | — | 7666300088 | 2046 Palm Dr, Fresno, CA | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+3 more |
| PRV-23772 | PRV | Marilyn Peterson | 1942-12-11 | — | — | 2853 River Rd, Phoenix, AZ, 85070 | 0.62 | Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more |