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
Third-party administrator, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| TPA-52689 | TPA | Debra Collins | 1980-11-19 | — | — | 6116 Market St, Sacramento, CA, 95866 | 0.84 | State name converted to codePlaceholder values cleared |
| TPA-55995 | TPA | Santiago H Fox | 1950-11-04 | — | — | — | 0.84 | Name split from “Last, First”Placeholder values cleared |
| TPA-50193 | TPA | Margaret Chavez | 1951-03-19 | — | — | 5663 Spring St, Minneapolis, MN, 55457 | 0.84 | ZIP+4 trimmedPlaceholder values cleared |
| TPA-60373 | TPA | Brittany Schmidt | 1942-06-10 | UHC-24552-67 | — | 7006 Elm St, Glendale, AZ, 85381 | 0.84 | Street suffix standardisedAddress re-cased |
| TPA-61546 | TPA | Ryan Gibson | 2000-03-01 | — | — | — | 0.84 | Gender normalisedPlaceholder values cleared |
| TPA-63682 | TPA | Julie Fernandez | 1943-02-14 | UHC-12499-80 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| TPA-56190 | TPA | Doris A Li | 1999-01-07 | UHC-88009-26 | — | — | 0.84 | Name split from “Last, First”Placeholder values cleared |
| TPA-63975 | TPA | Roy Cole | 1963-09-07 | — | — | 5514 Union St, Las Vegas, NV | 0.84 | City re-casedZIP missing |
| TPA-56715 | TPA | Hiroshi Bkaer | — | — | — | — | 0.84 | Date of birth unreadablePlaceholder values cleared |
| TPA-52199 | TPA | Isabella B Lawrence | 1943-05-05 | — | 2977052794 | 2092 Indian School Rd, Minneapolis, MN, 55462 | 0.84 | Gender normalisedPlaceholder values cleared |
| TPA-59435 | TPA | Ralph Jimenez | 1989-07-12 | — | — | 5171 Desert Sky Blvd, Los Angeles, CA, 90063 | 0.84 | Street suffix standardisedAddress re-cased |
| TPA-59111 | TPA | Jonathan Marquez | 1953-08-07 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| TPA-52601 | TPA | Evelyn Chavez | 1955-01-09 | — | — | 6106 Maple Ave, Nashville, TN | 0.84 | ZIP missingPlaceholder values cleared |
| TPA-51953 | TPA | Alan Soto | — | — | 7157709265 | — | 0.84 | Date of birth unreadablePlaceholder values cleared |
| TPA-50846 | TPA | Charlotte Alexander | 2001-07-07 | — | — | 903 Meadow Ln, Houston, TX, 77049 | 0.84 | Gender normalisedPlaceholder values cleared |
| TPA-55390 | TPA | Diego Carroll | 1953-07-05 | — | — | — | 0.84 | Name split from “Last, First”Placeholder values cleared |
| TPA-57068 | TPA | Michelle Taylor | 2003-11-02 | — | — | 9367 Park Pl, Tucson, AZ, 85790 | 0.84 | Gender normalisedPlaceholder values cleared |
| TPA-51945 | TPA | Daniel Carroll | 2008-09-22 | — | — | 4534 Highland Ave, Charlotte, NC, 28286 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| TPA-61638 | TPA | Mari Jordan | 1979-04-01 | UHC-32080-45 | — | 7536 Central Ave, Atlanta, GA, 30385 | 0.84 | State name converted to codePlaceholder values cleared |
| TPA-50152 | TPA | Grace B Soto | 1946-03-03 | — | — | 4634 Forest Ave, Orlando, FL, 32819 | 0.84 | Name split from “Last, First”Placeholder values cleared |
| TPA-62262 | TPA | Michelle Reed | 1990-08-13 | — | — | 8363 Mesa Dr, Phoenix, AZ, 85052 | 0.84 | State name converted to codePlaceholder values cleared |
| TPA-64073 | TPA | Mariana Little | 1943-09-05 | — | 5145791028 | 4453 Market St, Chandler, AZ | 0.84 | ZIP missingPlaceholder values cleared |
| TPA-62282 | TPA | Michelle Harper | 1952-04-17 | UHC-59426-45 | — | 3693 Union St, Plano, TX, 75080 | 0.86 | Gender normalised |
| TPA-63104 | TPA | Aisha McCoy | 2004-08-22 | — | — | 354 Market St Apt 10, San Diego, CA, 92198 | 0.86 | Unit split from street |
| TPA-60754 | TPA | Dorothy Harvey | 2002-08-24 | UHC-41546-10 | 3136040690 | 4150 Apache Blvd, Glendale, AZ, 85322 | 0.86 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| TPA-56698 | TPA | Jerry Armstrong | 1940-04-10 | UHC-40480-51 | — | 6898 Mountain View Dr, Phoenix, AZ, 85058 | 0.86 | State name converted to code |
| TPA-60300 | TPA | Michelle Cuok | 1991-03-23 | — | 4353602887 | 7428 Church St, Mesa, AZ, 85202 | 0.86 | Name re-casedPhone reformattedCity re-casedState code upper-cased+3 more |
| TPA-56844 | TPA | Logan Lawson | 1992-11-11 | — | 2836807393 | 9216 Mesa Dr, Atlanta, GA, 30313 | 0.86 | ZIP+4 trimmed |
| TPA-50832 | TPA | Jean Contreras | 1943-05-24 | — | 6796195090 | — | 0.88 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more |
| TPA-54020 | TPA | Arjun Elliott | 1997-06-07 | UHC-67426-37 | 5797593513 | — | 0.88 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more |
| TPA-52410 | TPA | Roger Porter | 1992-03-10 | UHC-61167-62 | 3457276244 | 5095 Ridge Rd, Chandler, AZ, 85256 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more |
| TPA-52970 | TPA | Kimberly Salazar | 1972-04-19 | — | 6567188969 | — | 0.88 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more |
| TPA-55292 | TPA | Lisa O Walker | 1961-01-24 | — | 4962548510 | — | 0.88 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more |
| TPA-51480 | TPA | Vicky Hughes | 1949-09-21 | UHC-95800-59 | — | 267 Willow Ct, Minneapolis, MN, 55444 | 0.88 | Date of birth reformattedCity re-casedState code upper-casedEmail lower-cased+2 more |
| TPA-63818 | TPA | Hannah Ramos | 1952-09-18 | UHC-51097-46 | — | 8140 Broadway, Tempe, AZ, 85258 | 0.88 | Name re-casedDate of birth reformattedAddress re-casedCity re-cased+2 more |
| TPA-51803 | TPA | Maria X Allen | 1963-12-08 | — | 8012015427 | 4502 Hillcrest Rd, Phoenix, AZ, 85052 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more |
| TPA-58965 | TPA | Sara Z Harvey | 1984-02-18 | — | 6245431462 | 8811 Church St, Denver, CO, 80257 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| TPA-58966 | TPA | Sara Z Harvey | 1984-02-18 | — | 6245431462 | 8811 Church St, Denver, CO, 80257 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| TPA-59748 | TPA | Luis P Freeman | 1990-03-27 | — | — | 3146 Canyon Rd, Gilbert, AZ, 85274 | 0.88 | Name re-casedDate of birth reformattedCity re-casedState code upper-cased+2 more |
| TPA-51870 | TPA | Charlotte Dunn | 1987-10-01 | UHC-00603-18 | 5874341669 | 6874 Broadway, Denver, CO, 80250 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedAddress re-cased+2 more |
| TPA-60290 | TPA | Jacob Cruz | 1964-06-27 | — | 9732991035 | — | 0.88 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more |
| TPA-60589 | TPA | Mason Schultz | 1953-01-26 | — | 4609188267 | 8463 Willow Ct, Chandler, AZ, 85202 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| TPA-57305 | TPA | Noah Turner | 1949-03-28 | — | 9412898050 | 441 Palm Dr, Chandler, AZ, 85287 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedPlan code upper-cased+2 more |
| TPA-54826 | TPA | Paul Howell | 1968-11-17 | — | 3039472238 | — | 0.88 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more |
| TPA-53836 | TPA | Jacob F Cruz | 1988-07-09 | — | — | 7937 Lincoln Way, San Diego, CA, 92162 | 0.88 | Name re-casedDate of birth reformattedCity re-casedEmail lower-cased+2 more |
| TPA-57537 | TPA | Camila Hamilton | 1959-08-25 | — | 8039367556 | — | 0.88 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more |
| TPA-51365 | TPA | Virginia Nichols | 1988-12-07 | UHC-98941-14 | 2417139080 | 5032 Canyon Rd, Eden Prairie, MN, 55380 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more |
| TPA-57217 | TPA | Ruth Peterson | 1959-09-25 | — | — | 2019 River Rd, Denver, CO, 80270 | 0.88 | Name re-casedDate of birth reformattedCity re-casedState code upper-cased+2 more |
| TPA-50779 | TPA | Ross Edward | 1956-02-20 | — | 2218702828 | 784 Ocean Ave, Las Vegas, NV, 89100 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedPlan code upper-cased+2 more |
| TPA-51923 | TPA | Gregory Jensen | 2005-08-16 | — | 6088586740 | 3096 Pine Dr, Scottsdale, AZ, 85285 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |