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-28852 | PRV | Austin Miller | 2000-11-16 | UHC-05857-13 | 7426838444 | 1627 Church St, Minneapolis, MN, 55476 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27272 | PRV | Daniel Garcia | 1976-12-04 | — | 8269912312 | 645 Union St, Orlando, FL, 32805 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29183 | PRV | Denise Gibson | 1973-06-15 | — | 5727006996 | 3493 Elm St, Charlotte, NC, 28256 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22544 | PRV | DorisJunk | 1939-12-09 | UHC-24341-03 | 5302894016 | 9597 Camelback Rd, Tempe, AZ, 85259 | 0.74 | Name re-casedPhone reformattedMember ID reformattedState code upper-cased+3 more |
| PRV-20728 | PRV | Brandon Jenkins | 1994-08-01 | — | 6559348279 | 1660 Palm Dr, Scottsdale, AZ, 85209 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-22371 | PRV | Alan N Daniels | 2007-02-25 | — | 2799162449 | 8140 Willow Ct, Gilbert, AZ, 85259 | 0.74 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+3 more |
| PRV-26717 | PRV | Roger Ortega | 1939-04-19 | UHC-44775-27 | 5623955539 | 9312 Market St, Jacksonville, FL, 32210 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22219 | PRV | Gerald L Snyder | 1967-10-23 | — | 6493340589 | 6460 Camelback Rd, Houston, TX, 77038 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24922 | PRV | Christopher B Stewart | 2005-03-11 | — | — | 3758 Hillcrest Rd, Minneapolis, MN, 55435 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20413 | PRV | Christopher Espinoza | 1994-09-18 | UHC-74983-53 | 8208831326 | 5093 Lake View Rd, Eden Prairie, MN, 55378 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21927 | PRV | Jonathan Weaver | 1979-02-25 | — | 7328535279 | 1511 Palm Dr, Tucson, AZ, 85793 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22908 | PRV | Timothy O Lucas | 1939-02-26 | UHC-65767-08 | 7953580222 | 6117 Grand Ave, Las Vegas, NV, 89171 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| PRV-27072 | PRV | Maria V Vazquez | 1990-06-01 | UHC-44744-44 | 8449166831 | 7929 Union St, Charlotte, NC, 28230 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21073 | PRV | Grace Welch | 1951-12-11 | — | 9698162203 | 5334 Lake View Rd, Charlotte, NC, 28299 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24049 | PRV | Marilyn Franklin | 1965-01-13 | — | 9756714135 | 3405 Main St, Phoenix, AZ, 85044 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-28771 | PRV | James Carr | 1972-06-13 | — | 4798390086 | 6601 Washington St, Atlanta, GA, 30369 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21016 | PRV | CarlosJunk | 1951-12-17 | UHC-94148-09 | 3845930105 | — | 0.74 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| PRV-23448 | PRV | Ruth Howard | 1974-05-10 | UHC-24377-82 | 9545445065 | 8178 Willow Ct, Nashville, TN, 37243 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21500 | PRV | Billy Morgan | 1977-10-28 | UHC-03233-84 | 8478182485 | 2010 Union St, Denver, CO, 80224 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27579 | PRV | Jacob Bryant | 1961-03-25 | — | 2657874396 | 7699 Canyon Rd, Las Vegas, NV, 89177 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25378 | PRV | Alexis Ortega | 1967-10-25 | — | 5729478817 | 8143 Palm Dr, San Diego, CA, 92152 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21583 | PRV | Camila Knight | 1977-12-26 | — | 8666637272 | 9815 Harbor Blvd, Phoenix, AZ, 85062 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23617 | PRV | Cynthia D Watkins | 2002-08-03 | UHC-69888-49 | 8673673280 | 5861 Highland Ave, Orlando, FL, 32875 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20967 | PRV | Gary Austin | 1949-04-24 | — | 3079499616 | 2402 Ridge Rd, Austin, TX, 78735 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29435 | PRV | Amy Bowman | 2001-08-19 | UHC-43285-35 | 3054408132 | 6542 Valley View Dr, Eden Prairie, MN, 55368 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-24914 | PRV | Jak Bowman | 1940-04-17 | — | 3062909753 | 8293 Washington St, Gilbert, AZ, 85205 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24183 | PRV | Kathleen C Knight | 1981-08-22 | UHC-60314-10 | 2336873624 | 3149 Park Pl, Dallas, TX, 75204 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22892 | PRV | Sam Patterson | 2002-06-04 | — | 9643892607 | 4811 Hillcrest Rd, Columbus, OH, 43253 | 0.74 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-26489 | PRV | Noah Wright | 1960-06-04 | UHC-86044-28 | 7834840937 | 7972 Hillcrest Rd, Scottsdale, AZ, 85253 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25498 | PRV | Ryan Hernandez | 1959-01-19 | UHC-51810-13 | 5727094583 | 6988 Sage Ct, Charlotte, NC, 28205 | 0.74 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-21274 | PRV | Brandon Salazar | 1965-01-21 | — | 7157691691 | 4338 River Rd, Mesa, AZ, 85268 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21991 | PRV | Christian Morrison | 1969-06-28 | — | 5332752929 | 7318 Mesa Dr, Tempe, AZ, 85234 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28245 | PRV | Shirley H Elllis | 1975-01-21 | — | 2846315516 | 7905 Church St, Phoenix, AZ, 85068 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21641 | PRV | Brenda Marquez | 1974-03-24 | UHC-60566-59 | 7079907062 | 5518 Grand Ave, Las Vegas, NV, 89172 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29153 | PRV | Josshua Guerrero | 1963-09-04 | — | — | 7674 Baseline Rd, Dallas, TX, 75246 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22289 | PRV | Mari E Cook | 1963-04-04 | UHC-93632-88 | 8876752140 | 3872 Highland Ave, Atlanta, GA, 30353 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25518 | PRV | Ruth Weber | 1940-05-24 | — | 2436066165 | 9877 Market St, Glendale, AZ, 85334 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25529 | PRV | Anna Y Luna | 2001-08-13 | — | 8599159442 | 964 Apache Blvd # 925, Las Vegas, NV, 89108 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| PRV-20492 | PRV | Kim M Ramirez | 1979-07-26 | UHC-27862-28 | 5455727362 | 5718 Spring St, Denver, CO, 80298 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25825 | PRV | Danielle X Cox | 1943-04-12 | — | 7134007297 | 5635 Spring St, Sacramento, CA, 95887 | 0.74 | Date of birth reformattedPhone reformattedCity re-casedState name converted to code+3 more |
| PRV-25824 | PRV | Danielle X Cox | 1943-04-12 | — | 7134007297 | 5635 Spring St, Sacramento, CA, 95887 | 0.74 | Date of birth reformattedPhone reformattedCity re-casedState name converted to code+3 more |
| PRV-24618 | PRV | Beverly Hunter | 1996-11-15 | UHC-61579-57 | — | 121 Desert Sky Blvd, Plano, TX, 75041 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24617 | PRV | Beverly Hunter | 1996-11-15 | UHC-61579-57 | — | 121 Desert Sky Blvd, Plano, TX, 75041 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26964 | PRV | Shirley Harrison | 1940-04-24 | — | 7475212037 | 3720 Camelback Rd, Atlanta, GA | 0.74 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-23879 | PRV | Jeremy Romero | 1954-11-14 | — | 3467871225 | 4322 Bayshore Dr, Sacramento, CA, 95834 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-29528 | PRV | George Ramos | 1962-03-15 | — | 6926011459 | 2114 Willow Ct, Seattle, WA, 98113 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-24374 | PRV | Philip Jimenez | 1996-03-04 | UHC-42235-01 | 2139074021 | 2148 Jefferson Ave, Seattle, WA, 98156 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-24916 | PRV | Juila Hansen | 1986-07-22 | — | 6624891593 | 2065 Mountain View Dr, Phoenix, AZ, 85019 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-23983 | PRV | Aaron Bailey | 1938-10-12 | UHC-83010-96 | 3414456706 | 3294 Elm St, Eden Prairie, MN, 55325 | 0.74 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-20858 | PRV | Emily N Perkiins | 1988-03-16 | — | 8845902415 | 8902 Union St, San Antonio, TX, 78206 | 0.74 | Name re-casedPhone reformattedCity re-casedState code upper-cased+3 more |