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-28618 | PRV | Donna Cook | 1944-02-16 | — | 2563339851 | 599 Washington St Apt 33, Fresno, CA, 93712 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-21113 | PRV | Tyler Wagner | 1952-07-18 | UHC-10977-65 | 6309165474 | 8381 Main St, Gilbert, AZ, 85270 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-26916 | PRV | Ashley Hnry | 1965-12-15 | — | 3019232575 | 8367 Church St, Atlanta, GA, 30347 | 0.62 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| PRV-21522 | PRV | Dylan I Hill | 1962-01-21 | — | 2656423198 | 5307 Valley View Dr, Charlotte, NC, 28251 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-23385 | PRV | Melissa Stephens | 2005-04-03 | — | 6326311041 | 2913 Sunset Blvd, Jacksonville, FL, 32280 | 0.62 | Name re-casedPhone reformattedZIP+4 trimmedEmail lower-cased+3 more |
| PRV-29090 | PRV | AlexisJunk | 1990-12-15 | — | 5808016873 | 5747 Camelback Rd, San Diego, CA, 92131 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24871 | PRV | Logan Kelly | 1978-06-24 | — | 8965104633 | 6858 Central Ave, Nashville, TN, 37221 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-20334 | PRV | Kenneth N Parker | 2001-02-16 | UHC-71358-38 | — | 6628 Baseline Rd, Charlotte, NC, 28215 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more |
| PRV-24961 | PRV | Juan Richards | 1968-07-12 | — | 2722861777 | 5895 Church St, Glendale, AZ, 85384 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-29233 | PRV | Wayne Rios | 1985-10-01 | — | 5787018798 | 4228 Market St, San Antonio, TX, 78253 | 0.62 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20850 | PRV | Gabriel Simpson | 1943-02-15 | UHC-23523-26 | 7445042495 | 6302 Lake View Rd, Chandler, AZ, 85210 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more |
| PRV-20582 | PRV | Beverly Ramos | 1944-03-10 | — | 9183627716 | 5540 Canyon Rd, Fresno, CA | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21086 | PRV | Gerald B Harris | 2001-11-10 | UHC-76132-83 | — | 2875 Mountain View Dr, Dallas, TX, 75275 | 0.62 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| PRV-29163 | PRV | Jacob C Guerrero | 1973-09-21 | — | 8169622844 | 2682 Sunset Blvd, Columbus, OH, 43283 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22003 | PRV | Julie Pena | 1989-12-02 | UHC-02461-38 | 2948505111 | 59 Mountain View Dr, Tucson, AZ, 85739 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-22336 | PRV | Tlyer Long | 1981-04-15 | — | 4175177821 | 277 Jefferson Ave, Dallas, TX, 75286 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-22123 | PRV | David H Weaver | 1967-12-12 | UHC-28824-31 | 5152145224 | 6824 Elm St Apt 32, Orlando, FL, 32867 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-20185 | PRV | Nicholas Lawson | 1958-01-19 | UHC-16478-62 | 5518029643 | 1395 Hillcrest Rd # 258, Atlanta, GA, 30321 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-23719 | PRV | Marcus Burke | 2008-04-17 | UHC-79080-92 | 8573819812 | 4628 River Rd, San Antonio, TX, 78278 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25955 | PRV | Laura H Cooper | 2007-11-04 | — | 3596564023 | 1831 Willow Ct Apt 19, San Diego, CA, 92106 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-29338 | PRV | Ann Perez | 1993-08-11 | — | 4377496926 | 2559 Baseline Rd, Phoenix, AZ, 85046 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-27195 | PRV | Ralph A Ruiz | 1950-05-14 | — | 8179605979 | 5738 Valley View Dr, Mesa, AZ, 85298 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22566 | PRV | Mariana Morrison | — | UHC-48094-21 | 8743343898 | 8632 Mesa Dr, Chandler, AZ, 85261 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| PRV-22093 | PRV | Samantha Freeman | 1977-05-08 | UHC-78622-78 | 7555115205 | 1512 Camelback Rd, Scottsdale, AZ | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26066 | PRV | Jerry X Martin | 1939-03-08 | — | — | 8116 Ridge Rd, Nashville, TN | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-26727 | PRV | Larry Watson | 1945-10-10 | UHC-02736-74 | 8574941531 | 6529 Baseline Rd Apt 18, Orlando, FL, 32815 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| PRV-21769 | PRV | Kathleen Daneils | 1939-03-11 | UHC-48830-22 | 7426086699 | 5667 Lake View Rd, Mesa, AZ, 85201 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23170 | PRV | Robert V Murray | 1960-04-28 | UHC-06624-68 | 2265750560 | 8849 Mesa Dr, Tampa, FL, 33680 | 0.62 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-20562 | PRV | Jacqueline Simpson | 1951-06-01 | UHC-21238-96 | — | 1304 Mountain View Dr, Gilbert, AZ, 85294 | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22019 | PRV | Cynthia Flores | 1953-03-20 | — | 2857015766 | 7392 Pine Dr, Minneapolis, MN, 55481 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22883 | PRV | Ryan Contreras | 2005-06-09 | UHC-89560-36 | 2107228461 | 3154 Elm St, Seattle, WA, 98117 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more |
| PRV-23012 | PRV | Anna Hamilton | 1947-07-28 | UHC-64350-02 | 5723082398 | 1273 Mesa Dr, Chandler, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24528 | PRV | Sofia Y Wilson | 2004-06-18 | UHC-06608-41 | 5902998121 | 3482 River Rd, San Diego, CA, 92138 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25999 | PRV | Emma H Pena | 2006-12-15 | UHC-89588-48 | 2135477737 | 1716 Sunset Blvd, Austin, TX, 78701 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26547 | PRV | Jeramy X Pena | 1952-07-10 | — | 5283734031 | 2723 Indian School Rd, Orlando, FL, 32847 | 0.62 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more |
| PRV-26040 | PRV | Donna Greene | — | UHC-31782-23 | 8568609815 | 5500 Hillcrest Rd, San Diego, CA, 92179 | 0.62 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more |
| PRV-26156 | PRV | Diego Matthews | 1938-12-01 | UHC-11271-69 | 5157312831 | 4858 Mountain View Dr, Tucson, AZ, 85708 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-21353 | PRV | Kathleen O Obren | 1988-02-05 | — | 4366344511 | 9351 Elm St, Los Angeles, CA, 90075 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26450 | PRV | Catherine Ford | 1977-12-27 | — | 9728980314 | 1919 Harbor Blvd, Sacramento, CA | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-24782 | PRV | Danielle King | 1982-05-23 | — | 6984437672 | 6050 Park Pl, Fresno, CA, 93707 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21986 | PRV | Janice K Alexander | 2008-05-23 | UHC-43589-03 | 8874523752 | 8708 Central Ave, Sacramento, CA, 95832 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26982 | PRV | Ashley Wong | 1981-05-08 | UHC-65191-42 | 4245107653 | 3178 Baseline Rd, Houston, TX, 77083 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-27269 | PRV | Diane Stephens | 1971-04-01 | UHC-27084-18 | 3586056108 | 2642 Highland Ave, Chandler, AZ, 85222 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21377 | PRV | Peter Clark | 1947-06-08 | UHC-99363-17 | 6056117774 | 275 Cedar Ln # 442, Denver, CO, 80294 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-27228 | PRV | Carlos Hoffman | 1963-08-01 | — | — | 559 Mesa Dr Apt 27, Austin, TX, 78768 | 0.62 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-25984 | PRV | Maria Gonzales | 1966-05-05 | UHC-94421-13 | 9815902792 | 8457 Cedar Ln # 938, Tempe, AZ, 85287 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-26306 | PRV | Paul Harris | 1943-10-08 | UHC-51958-95 | — | 881 Forest Ave, Tucson, AZ | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20787 | PRV | Jeff Rice | 1986-06-14 | UHC-50934-22 | 2398195243 | 788 Washington St, Mesa, AZ, 85261 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26749 | PRV | Bruce Wells | 1977-11-17 | — | 5457998325 | 7373 Pine Dr, Charlotte, NC, 28233 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24368 | PRV | Mason Lcas | 1969-06-01 | UHC-82569-27 | 4385568143 | 2967 Mesa Dr, Chandler, AZ | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |