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-20678 | PRV | Betty Lucaas | 1984-12-10 | UHC-91442-85 | 6316599428 | 8176 Mesa Dr, Nashville, TN, 37212 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21300 | PRV | Timothy Tran | 1958-04-25 | — | 4657645355 | 5906 Apache Blvd # 357, Glendale, AZ, 85384 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-23960 | PRV | Tim Dixon | 1951-11-17 | UHC-54331-87 | 4456310971 | 1368 Ridge Rd, Plano, TX, 75078 | 0.62 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-23453 | PRV | Nicole Vasquez | 1951-02-03 | UHC-78209-60 | 7984068344 | 1687 Mesa Dr, Scottsdale, AZ, 85258 | 0.62 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25512 | PRV | Christian Chavez | 1996-01-20 | — | 5037920366 | 7834 Oak St, Seattle, WA | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24821 | PRV | Wei Cook | 1991-12-07 | UHC-33024-75 | 6399599575 | 6459 Ocean Ave, Gilbert, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28912 | PRV | Hannah Morrison | 1983-07-12 | UHC-56979-48 | 4438803052 | 3111 Grand Ave, Austin, TX, 78728 | 0.62 | Name split from “Last, First”Phone reformattedMember ID reformattedCity re-cased+3 more |
| PRV-21408 | PRV | Yuki Nguyen | 1955-01-22 | UHC-27496-70 | 8686306366 | 1631 Jefferson Ave, Orlando, FL, 32805 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25442 | PRV | Isabella N Guerrero | 1993-10-01 | UHC-86915-27 | 4148118317 | 1635 Church St, Sacramento, CA, 95841 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-22010 | PRV | Charles Lewis | — | — | 4777413745 | 3573 Indian School Rd, Seattle, WA, 98102 | 0.62 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22009 | PRV | Charles Lewis | — | — | 4777413745 | 3573 Indian School Rd, Seattle, WA, 98102 | 0.62 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23836 | PRV | Frances Fields | 1951-11-04 | — | 4146613290 | 565 Main St, Tempe, AZ, 85239 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23835 | PRV | Frances Fields | 1951-11-04 | — | 4146613290 | 565 Main St, Tempe, AZ, 85239 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25066 | PRV | Dick Jacobs | 1974-12-03 | UHC-92645-71 | 2947781536 | 6914 Lincoln Way, Tucson, AZ, 85780 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedZIP+4 trimmed+3 more |
| PRV-26187 | PRV | Stephanie Harper | 1964-06-15 | UHC-74220-77 | 4434033199 | 2829 Cedar Ln, Orlando, FL | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27748 | PRV | Dorothy Smith | 2003-10-07 | UHC-01581-36 | 5346791797 | 624 Central Ave, Gilbert, AZ, 85257 | 0.62 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-20818 | PRV | Catherine Cook | 1990-06-20 | UHC-04400-74 | 6793246419 | 9282 Church St, Atlanta, GA, 30369 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedEmail lower-cased+3 more |
| PRV-29041 | PRV | Ethan S Garza | 2002-06-26 | UHC-91432-94 | 3496815937 | 9873 Market St Apt 22, Atlanta, GA, 30335 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| PRV-25504 | PRV | Ashley Thompson | 1999-11-22 | UHC-62776-77 | 4078435113 | 8765 Central Ave, Eden Prairie, MN | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+3 more |
| PRV-27662 | PRV | Kevin V Knight | 1953-01-22 | — | 8899796016 | 7111 Ridge Rd, Minneapolis, MN | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22669 | PRV | Santiago McDonald | 1991-02-20 | — | 5596507491 | 9803 Canyon Rd, Denver, CO, 80207 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-26082 | PRV | Sara Hanson | 1993-07-16 | UHC-23621-71 | 6265279615 | 2711 Sage Ct, Charlotte, NC, 28237 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22813 | PRV | Denise F Lopez | 1984-03-27 | — | 8946613553 | 5822 Hillcrest Rd, Minneapolis, MN | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| PRV-22829 | PRV | Aisha Mason | 2002-10-17 | UHC-99034-92 | 4116705178 | 5568 Hillcrest Rd, San Diego, CA, 92148 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26728 | PRV | Randy Gonzales | 1963-06-10 | — | 7609111496 | 37 Forest Ave, Las Vegas, NV | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20337 | PRV | Nathan Y Delgado | 1947-12-17 | UHC-06879-35 | 2056078663 | 425 Desert Sky Blvd, Dallas, TX, 75287 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-20653 | PRV | Gary Munoz | 1965-10-25 | UHC-01867-73 | 7376018815 | 8538 Ocean Ave, Nashville, TN, 37225 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28815 | PRV | Jshua Stewart | 1988-02-15 | — | 6618979534 | 1223 Sunset Blvd # 828, Seattle, WA | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| PRV-20990 | PRV | Patrick Olson | 1993-11-18 | UHC-19445-85 | 8122132692 | 3332 Central Ave, Eden Prairie, MN, 55372 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20538 | PRV | Madison J Welch | 1946-12-10 | UHC-40299-97 | 5966626268 | 2397 Hillcrest Rd, Phoenix, AZ, 85076 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25816 | PRV | Justin Butler | 1953-11-08 | UHC-04020-20 | 6109317064 | 2044 Mountain View Dr, Austin, TX, 78706 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20978 | PRV | Rcahel Maldonado | 1940-03-05 | — | 3004230351 | 1474 Ridge Rd # 742, Sacramento, CA, 95818 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-25277 | PRV | Wayne Simpson | 1996-12-17 | UHC-80007-46 | 5759495120 | 1873 Ridge Rd, Chandler, AZ, 85208 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-27510 | PRV | Virginia Graham | 1965-09-01 | UHC-41763-34 | 2764573892 | 4219 Mesa Dr, Austin, TX, 78789 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-20835 | PRV | James Reid | 2008-10-13 | UHC-04022-72 | 8103721681 | 5685 Sage Ct, Scottsdale, AZ | 0.62 | Name re-casedDate of birth reformattedZIP missingEmail lower-cased+3 more |
| PRV-28132 | PRV | Brandon Bennett | 1939-08-21 | UHC-20776-28 | 8373045542 | 1280 Camelback Rd, Tucson, AZ, 85732 | 0.62 | Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more |
| PRV-22844 | PRV | Anthony S Phillips | 1950-01-11 | UHC-18242-24 | 5786686154 | 6503 Lake View Rd, Charlotte, NC, 28260 | 0.62 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21636 | PRV | Willie Schmidt | 1978-04-21 | UHC-26025-53 | 4779530898 | 5446 Forest Ave, Charlotte, NC, 28201 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24234 | PRV | George Jensen | 1951-03-02 | UHC-18575-03 | 4303150474 | 4915 Highland Ave, Columbus, OH, 43237 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25697 | PRV | Judith Herrera | 2000-05-21 | — | 5244278363 | 1589 Meadow Ln, Austin, TX, 78752 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29258 | PRV | Jonathan Meyer | 1993-07-27 | UHC-33815-73 | 9179306798 | 5475 Baseline Rd, Atlanta, GA, 30368 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21137 | PRV | Jesse Ryan | 1984-11-25 | — | 5747534802 | 1048 Mesa Dr, Glendale, AZ, 85303 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-21926 | PRV | Camila Santiago | 1940-08-03 | UHC-21140-26 | 5508216953 | 1728 Valley View Dr, Scottsdale, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23773 | PRV | Lawrence King | 1953-12-26 | — | 2084035748 | 569 Ridge Rd, Dallas, TX | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24981 | PRV | Brenda Dunn | 1966-10-10 | — | — | 5964 Church St, Fresno, CA, 93745 | 0.62 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| PRV-24072 | PRV | Joan Alvarado | 1946-07-21 | UHC-00087-63 | 8823688818 | 8314 Forest Ave Apt 24, Miami, FL, 33182 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| PRV-27982 | PRV | Bryan O Burke | 1998-09-15 | UHC-45325-26 | 7426339903 | 8698 Bayshore Dr, Dallas, TX, 75228 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-23412 | PRV | Theresa U Richards | 1968-04-08 | — | 4569637577 | 5657 Ridge Rd, Las Vegas, NV, 89140 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25061 | PRV | Sarah Jenkins | 1938-04-18 | — | — | 4815 Ridge Rd, Orlando, FL, 32889 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-24622 | PRV | Hannah Dunn | 1973-09-11 | UHC-05051-44 | 4698171397 | 9272 Mountain View Dr, Dallas, TX, 75217 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |