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-23500 | PRV | Hiroshi Hanson | 1939-12-11 | UHC-76924-24 | 9484755377 | 6791 Baseline Rd, Minneapolis, MN, 55425 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21359 | PRV | Janet Arnold | 1962-08-10 | — | 3933533885 | 2671 Palm Dr, Jacksonville, FL, 32296 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-28135 | PRV | Harold Morales | 1967-11-19 | — | 3496873951 | 9344 Main St, Glendale, AZ, 85364 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23360 | PRV | Alice Reed | 1960-03-07 | UHC-07621-79 | 2868782398 | 8551 Park Pl, Tucson, AZ, 85740 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21470 | PRV | Lawrence H Ward | 1983-01-07 | UHC-20136-99 | 9838497743 | 664 Elm St, Tempe, AZ, 85233 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26438 | PRV | Zachary Robertson | 1963-06-17 | UHC-51782-76 | 3365881947 | 9048 Jefferson Ave, Tucson, AZ, 85731 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-20137 | PRV | Wayne S Carpenter | 1993-02-01 | — | 9764727482 | 6771 Bayshore Dr, Eden Prairie, MN, 55375 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21584 | PRV | Philip Lawrence | 1991-10-02 | — | 8023222072 | 1594 River Rd, Chandler, AZ, 85200 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27353 | PRV | Frances Weaver | 1999-12-23 | UHC-64989-59 | 8169184825 | 9050 Camelback Rd, Seattle, WA, 98143 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-20162 | PRV | Ralph P Weaver | 1957-09-18 | — | 5376103292 | 4786 Ridge Rd, Charlotte, NC, 28232 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more |
| PRV-25335 | PRV | Jack X Dunn | 1975-08-10 | UHC-22549-45 | 5743947611 | 4632 Mesa Dr, Los Angeles, CA, 90029 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-20166 | PRV | Emily Shaw | 1952-02-06 | — | 7387266016 | 1742 Indian School Rd, Nashville, TN, 37253 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-28572 | PRV | Sara Williams | 1973-12-22 | — | 6887004716 | 5037 Washington St, Seattle, WA | 0.76 | Name re-casedPhone reformattedCity re-casedZIP missing+2 more |
| PRV-20836 | PRV | Benjamin Y Castillo | 2007-09-15 | — | 8553087264 | 374 Canyon Rd, Los Angeles, CA, 90012 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27744 | PRV | Donald Morales | 1965-12-15 | UHC-67538-62 | 8892940574 | 9049 Ridge Rd, Atlanta, GA, 30395 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27561 | PRV | Arjun Jensen | 1978-03-02 | — | 3204151379 | 7875 River Rd, Las Vegas, NV, 89115 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20127 | PRV | Linda Wong | 1947-02-11 | UHC-59924-42 | 8165059028 | 6511 Canyon Rd, Denver, CO, 80243 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22741 | PRV | Teresa Williamson | 1981-01-26 | UHC-54512-54 | 4142162987 | 2913 Lincoln Way, Dallas, TX, 75257 | 0.76 | Two-digit birth yearPhone reformattedMember ID reformattedCity re-cased+2 more |
| PRV-28688 | PRV | Barbara Owens | 2002-06-24 | — | 5953490383 | 4882 Church St, Chandler, AZ, 85256 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26943 | PRV | Ethan Phhillips | 1996-03-07 | — | 5539981186 | 8497 Oak St, Gilbert, AZ, 85282 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more |
| PRV-25522 | PRV | John N Santiago | 1958-10-20 | — | 9329606619 | 4038 Sage Ct, Minneapolis, MN, 55489 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24082 | PRV | Omar D Nguyen | 1997-06-08 | — | 8802568685 | 5478 Lake View Rd, Tampa, FL, 33621 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27515 | PRV | Grace Armstrong | 1959-03-16 | — | 8696162345 | 6118 Sage Ct, Scottsdale, AZ, 85288 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-25381 | PRV | Harold K Mejia | 1969-10-17 | UHC-63645-91 | 5163320294 | 1262 Willow Ct, Nashville, TN, 37270 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23701 | PRV | Santiago A Wong | 1969-10-19 | — | 6855242033 | 4049 Washington St, Houston, TX, 77081 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28031 | PRV | Ana A Cox | 1981-07-08 | — | 9546857596 | 8684 Main St, Tempe, AZ, 85216 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-28019 | PRV | Emily Reynolds | 1962-04-06 | UHC-54398-28 | 8903392682 | 5254 Mountain View Dr, Austin, TX, 78712 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25666 | PRV | Gerald Little | 1996-11-14 | UHC-94042-51 | 6915941652 | 3476 Ocean Ave, Columbus, OH, 43297 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21586 | PRV | Marilyn Fisher | 1985-04-16 | UHC-53466-53 | 6327881364 | 4815 Sage Ct, San Antonio, TX, 78201 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-24300 | PRV | Sue Carr | 2005-06-19 | UHC-11023-15 | 4392075440 | 5207 Pine Dr, Las Vegas, NV, 89177 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-24106 | PRV | Danielle Andrews | 1952-11-02 | — | 3413261209 | 247 Camelback Rd, Eden Prairie, MN, 55393 | 0.76 | Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+2 more |
| PRV-27403 | PRV | Grace Dixon | 1983-09-19 | UHC-62535-51 | 8104551642 | 5204 Palm Dr, Miami, FL, 33134 | 0.76 | Two-digit birth yearPhone reformattedMember ID reformattedCity re-cased+2 more |
| PRV-23581 | PRV | Mateo P Obrien | 1969-03-09 | UHC-64674-51 | — | 9873 Pine Dr, Fresno, CA, 93740 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28902 | PRV | Christina N Evans | 1944-12-04 | UHC-35274-45 | — | 6102 Camelback Rd, Jacksonville, FL, 32212 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25120 | PRV | Michelle Walker | 2003-08-05 | UHC-17580-14 | 3015838848 | 7539 Bayshore Dr, Jacksonville, FL, 32259 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29049 | PRV | Patricia P King | 1967-06-23 | — | 4872781868 | 5936 Willow Ct, Dallas, TX, 75246 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23097 | PRV | Olson B Keith | 2006-03-05 | — | 9494048924 | 500 Highland Ave Apt 22, Sacramento, CA, 95828 | 0.76 | Name re-casedPhone reformattedUnit split from streetCity re-cased+2 more |
| PRV-20298 | PRV | Carolyn Lewis | 1996-08-27 | — | — | 5024 Spring St, Charlotte, NC, 28254 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-20547 | PRV | Betty Peters | 1940-12-28 | — | 9106580553 | 7521 Camelback Rd, Sacramento, CA, 95881 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23178 | PRV | David Rose | 1970-11-27 | — | 8742522938 | 703 Palm Dr, Minneapolis, MN, 55433 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-25604 | PRV | Roy Martinez | 1954-12-03 | UHC-35367-39 | 5233003240 | 985 Union St, Glendale, AZ, 85377 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22764 | PRV | Jessica Brooks | 1968-01-08 | UHC-63784-90 | 5462337236 | 5621 Elm St, Glendale, AZ, 85362 | 0.78 | Name re-casedDate of birth reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-27197 | PRV | Angela F Wells | 1985-07-25 | — | 3067956585 | 2563 Pine Dr, Fresno, CA, 93715 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25267 | PRV | Jose Scott | 1979-05-02 | — | 7915452789 | 1716 Ridge Rd, Nashville, TN, 37283 | 0.78 | Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-26041 | PRV | Donna Greene | 1989-01-17 | — | 8568609815 | 5500 Hillcrest Rd, San Diego, CA, 92179 | 0.78 | Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-27761 | PRV | Gloria A Fernandez | 1954-01-05 | UHC-87618-90 | 7484380394 | 8069 River Rd, Dallas, TX, 75203 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+1 more |
| PRV-28234 | PRV | Cheryl Richards | 1997-05-27 | UHC-37478-59 | 4355715397 | — | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-28150 | PRV | Jeffrey Harvey | 1969-10-15 | — | 3353580723 | 6301 Valley View Dr, Nashville, TN, 37244 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-25157 | PRV | Natalie Miller | 1995-01-18 | UHC-17934-72 | 8182611742 | 9031 Apache Blvd, Scottsdale, AZ, 85210 | 0.78 | Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-27085 | PRV | Anna Wagner | 1969-02-07 | — | 3694535865 | 2838 Main St, Chandler, AZ, 85251 | 0.78 | Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |