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, flag “State name converted to code”, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| CLM-412513 | CLM | Steven Bradley | 1952-11-19 | UHC-17904-26 | — | 4367 Desert Sky Blvd, Houston, TX, 77010 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| ENR-111205 | ENR | Anna Hawkins | 1966-01-10 | UHC-07114-46 | 7497465360 | 105 Indian School Rd, Las Vegas, NV, 89148 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| CLM-430032 | CLM | Carolyn P Patel | 1948-08-01 | UHC-70506-50 | — | 9476 Jefferson Ave, Jacksonville, FL, 32221 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-114549 | ENR | Josshua B Willias | 2008-03-12 | UHC-99131-33 | 5504729057 | 8376 Union St, Dallas, TX, 75220 | 0.82 | Date of birth reformattedPhone reformattedState name converted to code |
| CLM-409509 | CLM | Jean Hunt | 2000-11-13 | UHC-31215-87 | — | 3757 Central Ave, Seattle, WA, 98175 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| PRV-24015 | PRV | Katherine N Porter | 1945-05-01 | UHC-30660-13 | 7955121059 | 8266 Lincoln Way, Eden Prairie, MN, 55386 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| CLM-409465 | CLM | Jessica J Brooks | 1968-01-08 | UHC-63784-90 | 5462337236 | 5621 Elm St, Glendale, AZ, 85362 | 0.82 | Phone reformattedCity re-casedState name converted to code |
| TPA-53814 | TPA | Nathan Bennett | 1952-12-14 | UHC-27614-09 | — | 2690 Lincoln Way, Denver, CO, 80206 | 0.82 | State name converted to codePlan code upper-casedPlaceholder values cleared |
| ENR-118350 | ENR | Keiht A Rios | 1962-08-24 | UHC-36163-12 | 8047526055 | 7688 Indian School Rd, Seattle, WA, 98151 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| PRV-27014 | PRV | Heather Chavez | 1947-10-03 | UHC-48341-50 | 2995580953 | 698 Apache Blvd, Miami, FL, 33189 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| CLM-413819 | CLM | Ann Salazar | 1991-01-03 | UHC-52249-72 | — | 4627 Union St, Phoenix, AZ, 85089 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-133186 | ENR | Juan A Graham | 1938-06-16 | UHC-15294-97 | 8819876906 | 4334 Harbor Blvd, Fresno, CA, 93733 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| ENR-133187 | ENR | Juan A Graham | 1938-06-16 | UHC-15294-97 | 8819876906 | 4334 Harbor Blvd, Fresno, CA, 93733 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| ENR-139552 | ENR | Zachary U Black | 2008-07-06 | UHC-26635-36 | 7755495429 | 7325 Oak St, Orlando, FL, 32820 | 0.82 | City re-casedState name converted to codeWhitespace trimmed |
| PRV-21146 | PRV | Abigail Andrews | 1980-05-16 | — | 8794888751 | 499 Lincoln Way, Minneapolis, MN, 55455 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| ENR-141028 | ENR | Tyler X Wallacce | 1992-09-05 | UHC-31842-98 | 3919207989 | 1949 Pine Dr, Orlando, FL, 32859 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| ENR-105380 | ENR | Robertson N Ahmed | 1994-02-11 | UHC-07829-56 | 2277087311 | 986 Broadway, Plano, TX, 75019 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| ENR-130651 | ENR | Stephen Payne | 1984-09-04 | UHC-77518-93 | 9003853128 | 3739 Baseline Rd, Nashville, TN, 37236 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| ENR-136982 | ENR | Taylor Russell | 2004-05-10 | UHC-00465-69 | 9764622402 | 5030 Camelback Rd, Atlanta, GA, 30333 | 0.82 | Date of birth reformattedState name converted to codeWhitespace trimmed |
| ENR-103631 | ENR | Alan Brown | 2004-01-08 | UHC-69982-03 | 6279760412 | 740 Central Ave, Phoenix, AZ, 85077 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| ENR-112401 | ENR | Kenneth F Stewart | 2003-04-08 | UHC-91857-26 | 2539247268 | 333 Jefferson Ave, Atlanta, GA, 30389 | 0.82 | Name re-casedCity re-casedState name converted to code |
| PRV-22202 | PRV | Elijah Aguilar | 1996-12-19 | UHC-11836-39 | — | 1294 Sage Ct, Jacksonville, FL, 32292 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| PRV-27586 | PRV | Anthony Hernandez | 1986-02-11 | UHC-00616-73 | 5736512891 | 9401 Central Ave, Orlando, FL, 32845 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| TPA-52623 | TPA | Brittany Hall | 1964-03-06 | UHC-67985-87 | — | 6962 Desert Sky Blvd, Houston, TX, 77081 | 0.82 | State name converted to codePlan code upper-casedPlaceholder values cleared |
| ENR-110287 | ENR | Bruce K Knight | 1939-12-12 | UHC-68728-83 | 8533925864 | 743 Mesa Dr, Dallas, TX, 75235 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| ENR-104479 | ENR | Paul G Ward | 1965-12-01 | UHC-06878-76 | 4179516531 | 3165 Sage Ct, Seattle, WA, 98180 | 0.82 | Name re-casedState name converted to codeWhitespace trimmed |
| TPA-55170 | TPA | Melissa J Jordan | 1981-10-21 | — | — | 1628 Central Ave, Mesa, AZ, 85235 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| CLM-416476 | CLM | Judith J Salazar | 1938-02-17 | UHC-63958-44 | 2699514154 | 3981 Harbor Blvd, Las Vegas, NV, 89197 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| CLM-405294 | CLM | Camila T Snyder | 1993-06-09 | UHC-17020-16 | 4196341764 | 3515 Willow Ct, Miami, FL, 33192 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| ENR-133932 | ENR | Hiroshi T Oliver | 2005-11-26 | UHC-75827-14 | 7224875878 | 4758 Pine Dr, Columbus, OH, 43255 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| CLM-408644 | CLM | Maateo Ortega | 1956-01-09 | — | 4685438303 | 7123 Lincoln Way, Houston, TX, 77027 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| TPA-52452 | TPA | Abigail Fowler | 1986-06-21 | — | — | 4013 Broadway, Charlotte, NC, 28240 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-430768 | CLM | Lisa Rogers | 1955-05-21 | UHC-24194-21 | — | 6526 Park Pl, Los Angeles, CA, 90048 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-111033 | ENR | Anna Li | 1986-09-07 | UHC-60433-73 | 7559063279 | 8326 Lake View Rd, San Diego, CA, 92121 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| PRV-26622 | PRV | Douglas Stevens | 2003-03-17 | — | — | 7040 Oak St, Columbus, OH, 43236 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-110005 | ENR | Gregory Wagner | 1987-12-28 | UHC-51627-22 | 9418383423 | 6925 Broadway, Miami, FL, 33105 | 0.82 | Phone reformattedCity re-casedState name converted to code |
| TPA-57402 | TPA | Elijah Tucker | 1958-10-28 | — | 9823645918 | 6906 Harbor Blvd, Plano, TX, 75055 | 0.82 | Date of birth reformattedPhone reformattedState name converted to code |
| ENR-141280 | ENR | Philip Perry | 1989-04-23 | UHC-35107-86 | 8195845782 | 6786 Spring St, Austin, TX, 78708 | 0.82 | Name re-casedState name converted to codeEmail lower-cased |
| CLM-400350 | CLM | Bruce Henry | 2001-02-18 | UHC-59684-25 | — | 415 Palm Dr, Nashville, TN, 37202 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-106158 | ENR | Ema Morris | 2007-11-25 | UHC-26345-16 | — | 2595 Central Ave, Jacksonville, FL, 32282 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| ENR-120611 | ENR | Sandra M Garcia | 2004-02-16 | UHC-27633-77 | 5015151031 | 679 Pine Dr, Austin, TX, 78788 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| TPA-62893 | TPA | Sara Romero | 1961-01-11 | — | — | 1684 Market St, Tucson, AZ, 85734 | 0.82 | State name converted to codeEmail lower-casedPlaceholder values cleared |
| ENR-102546 | ENR | Beverly Ramos | 1944-03-10 | UHC-14839-38 | 9183627716 | 8320 River Rd, Las Vegas, NV, 89116 | 0.82 | Date of birth reformattedPhone reformattedState name converted to code |
| CLM-404319 | CLM | Christina Soto | 1990-04-18 | UHC-05302-85 | 2887741702 | 6040 Harbor Blvd, Charlotte, NC, 28292 | 0.82 | Date of birth reformattedPhone reformattedState name converted to code |
| PRV-25119 | PRV | Robert Jacobs | 1957-03-14 | — | 5642961872 | 6001 Canyon Rd, Jacksonville, FL, 32224 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| CLM-405102 | CLM | Diane Knight | 1942-11-18 | — | — | 2976 Market St, Tucson, AZ, 85760 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-131089 | ENR | Christian E Spencer | 1974-07-25 | UHC-07631-84 | 8556373894 | 9861 Valley View Dr, Houston, TX, 77090 | 0.82 | Phone reformattedState name converted to codeEmail lower-cased |
| CLM-431367 | CLM | Heather Reid | 1993-03-26 | UHC-36200-07 | — | 5533 Maple Ave, Fresno, CA, 93711 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| ENR-100728 | ENR | Madison F Cook | 1960-01-25 | UHC-96515-99 | 4014081478 | 8386 Spring St, Tucson, AZ, 85738 | 0.82 | Name re-casedState name converted to codeWhitespace trimmed |
| ENR-110002 | ENR | Emiy G Arnlod | 1952-11-01 | UHC-96912-28 | 2788876145 | 3966 Sage Ct, Gilbert, AZ, 85265 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |