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
All sources, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| TPA-50617 | TPA | Jack U Hunt | 1974-11-04 | — | — | 8639 Main St, Miami, FL, 33144 | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more |
| PRV-25333 | PRV | Luis Sandoval | 1971-07-04 | UHC-78529-45 | 6944229068 | 6877 Mountain View Dr, Jacksonville, FL, 32234 | 0.48 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-107354 | ENR | Catherine Hudson | 2001-05-05 | UHC-76200-83 | 5978103544 | 370 Harbor Blvd Apt 12, Miami, FL, 33129 | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-128085 | ENR | Sofia Marin | 1954-04-11 | UHC-48966-84 | 9825973219 | 5715 Sunset Blvd Apt 33, Los Angeles, CA, 90024 | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-122212 | ENR | Douglas Q Tucker | 1971-11-13 | UHC-69945-91 | — | 7086 Cedar Ln, San Antonio, TX | 0.48 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-127422 | ENR | Scott Hall | 2003-02-18 | UHC-57013-81 | 7217117160 | 2441 Maple Ave # 466, Jacksonville, FL, 32208 | 0.48 | Name re-casedSSN last four extractedUnit split from streetStreet suffix standardised+4 more |
| PRV-21909 | PRV | Luis Reed | 1944-04-24 | UHC-97310-50 | 2423077489 | 3980 Meadow Ln, Orlando, FL, 32821 | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-101046 | ENR | Deborah Butler | 1994-02-19 | UHC-90382-97 | — | 6452 Church St, San Antonio, TX, 78232 | 0.48 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| TPA-55720 | TPA | Angela Z Watkins | 1997-08-02 | — | — | 2215 Canyon Rd, Tampa, FL, 33613 | 0.48 | Name re-casedDate of birth reformattedPhone missing area codeCity re-cased+4 more |
| TPA-54859 | TPA | Madison Rios | 1983-03-13 | UHC-86944-52 | 2314587048 | 8428 Desert Sky Blvd, Eden Prairie, MN | 0.48 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-130920 | ENR | Samuel R Clark | 1942-06-03 | UHC-46047-49 | — | 7145 Valley View Dr, Eden Prairie, MN, 55372 | 0.48 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |
| CLM-409279 | CLM | Jason Franklin | 2003-03-23 | UHC-91114-24 | 8025247804 | 9488 Forest Ave, Tucson, AZ, 85788 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111147 | ENR | Raymond Peterson | 1961-03-06 | UHC-76146-60 | 3609456095 | 2005 Hillcrest Rd, Tampa, FL, 33668 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-104376 | ENR | Dylan A Day | 1968-03-05 | UHC-69809-48 | 4364032927 | 522 Indian School Rd # 828, Denver, CO, 80214 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-128570 | ENR | Wei Lawrence | 1949-01-10 | UHC-49718-56 | 7589640200 | 4975 Central Ave # 604, Gilbert, AZ, 85201 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more |
| TPA-52756 | TPA | Bill Stewart | — | — | 2198079607 | 7629 Ridge Rd, Tampa, FL, 33650 | 0.48 | Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-104515 | ENR | David Q Hall | 1947-06-04 | UHC-32874-59 | — | 766 Central Ave, Denver, CO, 80252 | 0.48 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more |
| ENR-110462 | ENR | Cynthia I Lucas | 1964-12-23 | UHC-72108-02 | 4202361988 | 64 Indian School Rd, Minneapolis, MN, 55436 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| PRV-21880 | PRV | Jean Davis | 1979-12-02 | — | 7123828977 | 4831 Highland Ave # 411, Nashville, TN, 37203 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| CLM-405375 | CLM | Sara M Ray | 1970-06-23 | — | 5504800879 | 2228 Jefferson Ave, Las Vegas, NV, 89120 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-118369 | ENR | Theresa Kelly | 1950-01-02 | UHC-26103-49 | 6876560179 | 1014 Hillcrest Rd, San Diego, CA, 92124 | 0.48 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-26003 | PRV | Keith I Gordon | 1965-09-11 | — | 3936293122 | 9536 Lake View Rd Apt 38, Dallas, TX, 75240 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-142426 | ENR | George T Miller | 1950-12-18 | UHC-23025-90 | 2897008779 | 2078 Grand Ave, Columbus, OH, 43286 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-107845 | ENR | Victoria Luna | 1947-05-10 | UHC-75189-78 | — | 7581 Willow Ct, Mesa, AZ, 85298 | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more |
| ENR-108023 | ENR | Adam Contraras | 1973-04-05 | UHC-75072-26 | 2844825112 | 5706 Indian School Rd, Plano, TX, 75091 | 0.48 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-128807 | ENR | Rebecca Fox | 2000-04-23 | UHC-17190-79 | — | 9718 Main St, Fresno, CA, 93789 | 0.48 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| TPA-56767 | TPA | Helen Castillo | 1915-10-10 | — | — | 4757 Highland Ave, Los Angeles, CA, 90010 | 0.48 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more |
| ENR-100794 | ENR | Brandon R Bryant | 1980-12-13 | UHC-78047-95 | 9533400231 | 2086 Maple Ave, Atlanta, GA, 30342 | 0.48 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-124395 | ENR | Russell C Murphy | — | UHC-65080-58 | 7742284369 | 3490 Hillcrest Rd, Las Vegas, NV, 89141 | 0.48 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| CLM-422737 | CLM | Terry A Turner | 1971-11-01 | UHC-21752-21 | 2737798336 | 1967 Valley View Dr, Houston, TX | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-140491 | ENR | Kimberly F Wang | 1988-01-05 | UHC-99271-57 | 9326759001 | 935 Jefferson Ave, Sacramento, CA, 95809 | 0.48 | Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more |
| ENR-136931 | ENR | Ana N Cook | — | UHC-77205-44 | 5818258142 | 8193 Ridge Rd, Tempe, AZ, 85251 | 0.48 | Name re-casedDate of birth missingPhone reformattedSSN last four extracted+4 more |
| PRV-21785 | PRV | Luis Porter | 2006-06-17 | — | 6658578571 | 2013 Lake View Rd, Jacksonville, FL | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-136215 | ENR | Amber N Lee | 2004-04-08 | UHC-32742-91 | 5362651559 | 8105 Desert Sky Blvd, San Diego, CA, 92184 | 0.48 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-106581 | ENR | Andrew Woods | 2001-06-02 | UHC-24692-84 | 7913240164 | 4197 Union St, Eden Prairie, MN, 55336 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-408132 | CLM | Andrea Coleman | 1998-03-17 | UHC-21993-89 | 5059686150 | 7471 Washington St, Tempe, AZ, 85232 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| CLM-422315 | CLM | Lisa Ferguson | 1965-10-13 | — | 5077289719 | 4972 Cedar Ln, Eden Prairie, MN, 55370 | 0.48 | Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+4 more |
| TPA-59003 | TPA | Frank Munoz | 1968-01-24 | — | 4466169201 | 2100 Indian School Rd, San Diego, CA | 0.48 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-107280 | ENR | Judith P Rilay | 1985-11-28 | UHC-59294-39 | 8332537016 | 2484 Valley View Dr, Columbus, OH, 43247 | 0.48 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| CLM-414041 | CLM | Daviid Hernandez | 1987-06-28 | UHC-79977-02 | 6913086821 | 1326 Washington St, Denver, CO, 80226 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-126316 | ENR | Bryan Fernandez | 2000-03-06 | UHC-35946-82 | 4945869374 | 1410 Jefferson Ave, Houston, TX, 77064 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-110118 | ENR | Lynch Q Timothy | 1944-09-12 | UHC-82887-94 | 9687898570 | 689 Main St # 568, Columbus, OH, 43234 | 0.48 | Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more |
| ENR-113239 | ENR | Joan Y Clark | 1967-11-09 | UHC-92120-58 | 2364835610 | 3163 Grand Ave, Atlanta, GA, 30308 | 0.48 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-122585 | ENR | Jacob Reyes | 1998-07-28 | UHC-39351-80 | 6537723905 | 2180 River Rd, Tucson, AZ, 85764 | 0.48 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-20070 | PRV | Henry Brown | 1998-08-21 | UHC-21741-37 | 7043968916 | 3158 Indian School Rd # 376, Miami, FL, 33178 | 0.48 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| TPA-58495 | TPA | Alice Gordon | 1961-02-17 | — | — | 9363 Lincoln Way, Seattle, WA, 98122 | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-100963 | ENR | Albert Harrison | 1944-03-24 | UHC-16381-51 | 5139965012 | 5207 Valley View Dr, Scottsdale, AZ, 85231 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-28273 | PRV | Alexander Patel | 1985-09-23 | — | 4435563349 | 5375 Sunset Blvd Apt 40, Plano, TX | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-138788 | ENR | Ethan Simmoons | 1985-09-21 | UHC-89876-67 | 7505270934 | 9378 Church St, Gilbert, AZ, 85295 | 0.48 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-114297 | ENR | Wei X Rios | 1953-05-08 | UHC-03294-76 | — | 9157 Bayshore Dr, Chandler, AZ, 85248 | 0.48 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |