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-24235 | PRV | Stephen Romero | 1987-01-15 | UHC-58897-97 | 7644912566 | 7926 Camelback Rd, Eden Prairie, MN, 55316 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27818 | PRV | Denise Smith | 1962-02-23 | — | 7722464564 | 3876 Baseline Rd, Tucson, AZ, 85705 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26427 | PRV | Brenda W Edwards | 1966-12-10 | — | 8634794468 | 5077 Hillcrest Rd, Charlotte, NC, 28204 | 0.76 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more |
| PRV-20390 | PRV | Steven Y Lewis | 1941-11-08 | — | 9614692590 | 5512 Ridge Rd, Glendale, AZ, 85379 | 0.76 | Name re-casedPhone reformattedCity re-casedState name converted to code+2 more |
| PRV-26720 | PRV | Ben Fuller | 1964-03-15 | UHC-11971-67 | — | 4702 Spring St, Nashville, TN, 37237 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-22769 | PRV | Mariana Johnson | 1997-03-21 | — | 4404821064 | 1867 Mountain View Dr, Dallas, TX, 75206 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-22428 | PRV | Nicholas Williamson | 1986-07-06 | — | 2684133515 | 4949 Canyon Rd, Minneapolis, MN, 55472 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28505 | PRV | Judy Patterson | 1998-03-07 | — | 2455673822 | 7921 Church St, Austin, TX, 78767 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27534 | PRV | Douglas Edwards | 1962-05-28 | — | 6676298303 | 6463 Palm Dr, Denver, CO, 80246 | 0.76 | Name re-casedPhone reformattedCity re-casedState name converted to code+2 more |
| PRV-22423 | PRV | Sandra Ryan | 1995-12-02 | — | 8896439703 | 3076 Spring St, Chandler, AZ, 85250 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more |
| PRV-25496 | PRV | Hiroshi Powell | 1951-07-05 | UHC-87923-96 | 4258524904 | 7769 Camelback Rd, Tucson, AZ, 85759 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26194 | PRV | Henry Myers | 1953-05-04 | — | 2132071418 | 2969 Cedar Ln, Las Vegas, NV, 89100 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21356 | PRV | Amy Fuller | 1982-08-24 | — | 7492760762 | 6125 Pine Dr, Tucson, AZ, 85746 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26027 | PRV | Alan J Kelly | 1973-05-25 | — | 3325331571 | 8577 Baseline Rd, Jacksonville, FL, 32299 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28086 | PRV | Alexis Salazar | 2003-10-05 | UHC-58806-09 | 3797506143 | 4868 Lake View Rd, Las Vegas, NV, 89182 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-27805 | PRV | Michael Schmidt | 2004-10-28 | UHC-23738-80 | 5799566239 | 7258 Harbor Blvd, Dallas, TX, 75268 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21596 | PRV | Kevin Payne | 1968-05-07 | UHC-53463-33 | 8209362751 | 8737 Desert Sky Blvd, Seattle, WA, 98125 | 0.76 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| PRV-28017 | PRV | Fatima Freeman | 1986-09-04 | UHC-38123-26 | 5438216398 | 6623 Church St, Glendale, AZ, 85378 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27349 | PRV | Arjun B Coleman | 1985-06-02 | — | 8497450821 | 9309 Willow Ct, Scottsdale, AZ, 85233 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20545 | PRV | Wayne Howell | 1965-10-08 | — | 3884811126 | 9750 Central Ave, Tempe, AZ, 85230 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22262 | PRV | Sofia Castro | 1999-02-28 | — | 8704668083 | 3667 Cedar Ln, Charlotte, NC, 28253 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-23442 | PRV | Gloria Holmes | 1985-08-04 | UHC-47269-70 | 8878901218 | 606 Jefferson Ave, Seattle, WA, 98123 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21272 | PRV | Gregory Ward | 1981-01-22 | UHC-42600-61 | 4227143570 | 886 Bayshore Dr, Miami, FL, 33159 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21273 | PRV | Gregory Ward | 1981-01-22 | UHC-42600-61 | 4227143570 | 886 Bayshore Dr, Miami, FL, 33159 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21635 | PRV | Jack Ortiz | 1957-12-15 | UHC-23081-51 | 9454820627 | — | 0.76 | Name re-casedPhone reformattedMember ID reformattedGender normalised+2 more |
| PRV-26895 | PRV | Jeffrey S Gutyerrez | 2001-02-05 | — | 5304506803 | 8454 Forest Ave, Dallas, TX, 75288 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24632 | PRV | Cynthia J Mitchell | 1993-08-18 | UHC-39160-11 | 2164820816 | 308 Broadway, Tampa, FL, 33602 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more |
| PRV-24631 | PRV | Cynthia J Mitchell | 1993-08-18 | UHC-39160-11 | 2164820816 | 308 Broadway, Tampa, FL, 33602 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more |
| PRV-24001 | PRV | Jerry Vasquez | 1939-08-13 | — | 6389572398 | 6965 Camelback Rd, Tampa, FL, 33681 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23038 | PRV | Ahmed Burke | 1958-06-22 | UHC-38144-72 | 3877647745 | 2720 Spring St, Minneapolis, MN, 55435 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21493 | PRV | Emma O Reed | 1991-06-07 | UHC-91196-41 | 6332224385 | 161 Desert Sky Blvd, Charlotte, NC, 28294 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more |
| PRV-26216 | PRV | David Ray | 2006-09-26 | — | 5379777346 | 8279 Mountain View Dr, Phoenix, AZ, 85014 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26896 | PRV | Jeffrey Gutierrez | 2001-02-05 | UHC-79792-52 | 5304506803 | 8454 Forest Ave, Dallas, TX, 75288 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-26061 | PRV | Catherine Contreras | 1972-02-12 | UHC-37529-48 | 3605769314 | 8879 Grand Ave, Dallas, TX, 75291 | 0.76 | Name re-casedPhone reformattedEmail lower-casedGender normalised+2 more |
| PRV-28612 | PRV | Cheryl Sanchez | 2004-10-26 | UHC-38922-46 | 3358407861 | 8988 Ocean Ave, San Antonio, TX | 0.76 | Date of birth reformattedPhone reformattedCity re-casedZIP missing+2 more |
| PRV-28397 | PRV | Jack Warren | 1966-02-10 | — | 8407697979 | 7172 Mountain View Dr, Los Angeles, CA, 90037 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23684 | PRV | Jack W Ryan | 1945-08-05 | — | 8276886418 | 6718 Church St, Scottsdale, AZ, 85251 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23019 | PRV | Nicole Munoz | 2006-06-19 | — | 4447610655 | 9023 Church St, Nashville, TN, 37248 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20175 | PRV | Daniel Y Burton | — | — | 7544322656 | 8924 Canyon Rd, Phoenix, AZ, 85021 | 0.76 | Name re-casedDate of birth missingPhone reformattedState code upper-cased+2 more |
| PRV-28008 | PRV | Ronald R Hicks | 1976-02-20 | — | 3463455568 | 8513 Union St, Tampa, FL, 33671 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25462 | PRV | Barbara F James | 1988-06-23 | — | 6589504207 | 2480 Ocean Ave, Miami, FL, 33103 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27113 | PRV | Sarah Reed | 1945-11-23 | — | 4773336920 | 5662 Oak St, Los Angeles, CA, 90052 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22706 | PRV | Terry E Rivera | 1993-04-10 | — | 2339455683 | 4242 Hillcrest Rd, Miami, FL, 33159 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25355 | PRV | William Ryan | 1991-12-16 | — | 2524274978 | 8692 Forest Ave, Nashville, TN, 37202 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24288 | PRV | Kevin Morris | 1938-05-10 | UHC-09232-82 | 3923878287 | 2441 Forest Ave, Tucson, AZ, 85707 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27730 | PRV | Heather Rios | 1960-07-24 | UHC-67463-23 | 6472954779 | 6475 Desert Sky Blvd, Sacramento, CA, 95827 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21253 | PRV | Alexis Edwards | 1976-03-25 | — | 2863973708 | 561 Indian School Rd, San Antonio, TX, 78201 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26650 | PRV | Pamela Tran | 1947-06-05 | — | 7449348201 | 4889 Spring St # 189, Sacramento, CA, 95828 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more |
| PRV-28735 | PRV | Karen Hayes | 1944-09-06 | UHC-95889-23 | 4973406912 | 6714 Union St, Eden Prairie, MN, 55386 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22164 | PRV | Peter Elliott | 1976-10-08 | — | 4098608284 | 6020 River Rd Apt 8, Charlotte, NC, 28247 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more |