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-61021 | TPA | Asha Medina | 1999-02-06 | — | — | 7802 Ocean Ave # 473, San Antonio, TX, 78270 | 0.82 | Name re-casedUnit split from streetPlaceholder values cleared |
| TPA-52321 | TPA | Kathryn Garkia | 1978-03-16 | UHC-36279-13 | — | 6454 Indian School Rd, Columbus, OH | 0.82 | Name re-casedZIP missingPlaceholder values cleared |
| TPA-53675 | TPA | Joe Robnson | 1941-10-27 | — | 2634106889 | 5475 Lake View Rd, Jacksonville, FL, 32290 | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| TPA-58130 | TPA | Maria Castillo | 1955-10-06 | — | — | 3511 Ocean Ave, Seattle, WA, 98161 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| TPA-58214 | TPA | Henry Daniels | 1945-03-11 | — | — | 2317 Church St, Los Angeles, CA, 90076 | 0.82 | Two-digit birth yearWhitespace trimmedPlaceholder values cleared |
| TPA-52746 | TPA | —Junk | 1953-11-17 | — | — | — | 0.82 | Email lower-casedPlaceholder values clearedNo usable name (quarantined) |
| TPA-55499 | TPA | Kimberly Santiago | 1984-11-27 | UHC-16774-11 | 7462057795 | 3655 Mountain View Dr, Denver, CO, 80211 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| TPA-52400 | TPA | JacobJunk | 2004-06-04 | — | — | — | 0.82 | Name re-casedPlaceholder values clearedNo usable name (quarantined) |
| TPA-52766 | TPA | Sophia Z Lynch | 1967-10-21 | — | — | — | 0.82 | Name re-casedGender normalisedPlaceholder values cleared |
| TPA-50798 | TPA | Yuki Wheeler | 1983-06-06 | — | — | 462 Union St, Scottsdale, AZ, 85200 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| TPA-56556 | TPA | Dorothy Hudson | 1988-11-08 | — | — | 3077 Meadow Ln, Minneapolis, MN, 55437 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| TPA-64262 | TPA | Cheryl Obrien | 1938-08-14 | — | — | 7836 Union St, Chandler, AZ | 0.82 | Name re-casedZIP missingPlaceholder values cleared |
| TPA-52391 | TPA | John Snyder | 1949-04-10 | UHC-19895-89 | 9214928644 | 1460 Church St, San Diego, CA, 92181 | 0.82 | Name re-casedTwo-digit birth yearPhone reformatted |
| TPA-52937 | TPA | Raymond Rodriguez | 1980-09-11 | — | 7043124628 | — | 0.82 | Two-digit birth yearWhitespace trimmedPlaceholder values cleared |
| TPA-60986 | TPA | Diane George | 1953-11-21 | — | 3558489536 | 900 River Rd, Scottsdale, AZ, 85239 | 0.82 | Phone reformattedStreet suffix standardisedAddress re-cased |
| TPA-52675 | TPA | Don Luna | 1955-01-09 | — | 2685572026 | 8713 Main St, Scottsdale, AZ, 85205 | 0.82 | Phone reformattedStreet suffix standardisedAddress re-cased |
| TPA-53447 | TPA | Emily Ellis | 2001-01-27 | UHC-19306-54 | 9315959115 | 321 Sage Ct, Austin, TX, 78748 | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| TPA-59925 | TPA | John Hughes | 1947-09-08 | — | — | 1769 Mesa Dr, Tempe, AZ, 85216 | 0.82 | Name re-casedTwo-digit birth yearPlaceholder values cleared |
| TPA-61651 | TPA | Hannah Nguyen | 1939-07-28 | UHC-93448-83 | 9458314352 | 8600 Lincoln Way, Los Angeles, CA, 90071 | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| TPA-58932 | TPA | Maria N George | 1948-01-05 | — | — | 8471 Cedar Ln, Glendale, AZ, 85386 | 0.82 | State name converted to codeEmail lower-casedPlaceholder values cleared |
| TPA-52055 | TPA | Aisha Robison | 1990-08-11 | — | — | 9227 Canyon Rd, Chandler, AZ, 85251 | 0.82 | Name split from “Last, First”Whitespace trimmedPlaceholder values cleared |
| TPA-53999 | TPA | Eugene I Jones | 1966-02-20 | — | — | 1907 Broadway, Chandler, AZ, 85295 | 0.82 | Middle initial moved out of first nameName re-casedPlaceholder values cleared |
| TPA-59073 | TPA | Stephanie Washiington | 1945-01-03 | — | — | 1804 Mountain View Dr, Dallas, TX, 75230 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| TPA-50774 | TPA | Hiroshi Hamilton | 1951-10-10 | — | 6399479484 | 4949 Lincoln Way, Orlando, FL, 32858 | 0.82 | ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared |
| TPA-58887 | TPA | George Mason | 1981-12-17 | — | 9257007570 | 6505 Sunset Blvd, Seattle, WA, 98186 | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| TPA-62327 | TPA | Larson Keith | 1994-01-19 | UHC-83530-31 | — | 6408 Lincoln Way, Los Angeles, CA, 90046 | 0.82 | Member ID reformattedGender normalisedPlaceholder values cleared |
| TPA-62626 | TPA | Gerald Johnston | 1938-05-21 | — | 3935165250 | — | 0.82 | Name split from “Last, First”Date of birth reformattedPlaceholder values cleared |
| TPA-59561 | TPA | Charlotte Hayes | 1991-10-15 | — | — | 7221 Bayshore Dr, Los Angeles, CA, 90097 | 0.84 | Name split from “Last, First”Placeholder values cleared |
| TPA-61258 | TPA | Christina Campbell | — | — | — | 6439 Apache Blvd, Miami, FL, 33141 | 0.84 | Date of birth unreadablePlaceholder values cleared |
| TPA-62172 | TPA | Diane P Willis | 1941-02-08 | — | — | 4367 Park Pl, Gilbert, AZ | 0.84 | ZIP missingPlaceholder values cleared |
| TPA-60847 | TPA | Hannah Burton | 2003-10-26 | — | — | 7667 Desert Sky Blvd, Denver, CO, 80245 | 0.84 | ZIP+4 trimmedPlaceholder values cleared |
| TPA-60247 | TPA | Luis Nunez | 1978-02-27 | — | — | 967 Bayshore Dr, Tampa, FL, 33601 | 0.84 | ZIP+4 trimmedPlaceholder values cleared |
| TPA-59976 | TPA | Doris Fisher | 1999-12-25 | — | 3082115052 | — | 0.84 | Name split from “Last, First”Placeholder values cleared |
| TPA-55629 | TPA | Matthew Phillips | 1974-09-16 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| TPA-51396 | TPA | Yuki Richardson | 1982-02-08 | — | 6144330688 | 2434 Forest Ave # 229, Eden Prairie, MN, 55340 | 0.84 | Unit split from streetPlaceholder values cleared |
| TPA-63440 | TPA | Matthew Ellis | 1967-12-06 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| TPA-60273 | TPA | Nicholas Bradley | 2006-03-27 | — | — | 4519 Palm Dr, Eden Prairie, MN, 55331 | 0.84 | Gender normalisedPlaceholder values cleared |
| TPA-58698 | TPA | Virginia Delgado | 1965-02-23 | — | 6779327801 | 7260 Union St, Sacramento, CA, 95836 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| TPA-63634 | TPA | Christopher Ross | 1990-02-16 | UHC-51132-99 | — | 5213 Spring St, Seattle, WA, 98152 | 0.84 | Gender normalisedPlaceholder values cleared |
| TPA-58522 | TPA | Austin Cunningham | — | — | — | — | 0.84 | Date of birth unreadablePlaceholder values cleared |
| TPA-53247 | TPA | Katherine James | 2001-09-14 | — | — | 6636 Highland Ave, Miami, FL, 33180 | 0.84 | SSN last four extractedPlaceholder values cleared |
| TPA-51314 | TPA | Valentina Banks | 1954-05-17 | — | — | 7203 Palm Dr, Atlanta, GA, 30397 | 0.84 | Gender normalisedPlaceholder values cleared |
| TPA-62236 | TPA | Peter R Brooks | 1989-05-13 | — | 2624929134 | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| TPA-51916 | TPA | Denise Phillips | 1994-05-27 | — | — | 8538 Spring St, Dallas, TX, 75212 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| TPA-52146 | TPA | Andrea Berry | 1949-10-18 | — | — | 5291 Main St, Phoenix, AZ, 85010 | 0.84 | ZIP+4 trimmedPlaceholder values cleared |
| TPA-54619 | TPA | Frank Stephens | 1983-04-08 | — | — | 8890 Lincoln Way, Chandler, AZ, 85223 | 0.84 | Phone missing area codePlaceholder values cleared |
| TPA-52822 | TPA | Logan Nychols | 1955-08-13 | — | — | — | 0.84 | Name split from “Last, First”Placeholder values cleared |
| TPA-60103 | TPA | Brittany Alexander | 1988-01-14 | — | — | 7028 Lincoln Way, Glendale, AZ, 85361 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| TPA-56935 | TPA | Keith Phillips | 1947-06-23 | — | — | 4207 Apache Blvd, Gilbert, AZ, 85225 | 0.84 | Name re-casedZIP+4 trimmed |
| TPA-61535 | TPA | Rebecca Dunn | 1945-09-20 | — | — | 3054 Harbor Blvd, Sacramento, CA, 95884 | 0.84 | ZIP+4 trimmedPlaceholder values cleared |