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 |
|---|---|---|---|---|---|---|---|---|
| ENR-106592 | ENR | Yuki Henry | 1953-04-22 | UHC-37640-18 | 3549943371 | 2055 Sunset Blvd, San Antonio, TX, 78268 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| ENR-113000 | ENR | Terrry Hall | 2007-01-15 | UHC-68463-16 | 3397902871 | 6584 Harbor Blvd, Phoenix, AZ, 85075 | 0.82 | Date of birth reformattedState name converted to codeWhitespace trimmed |
| PRV-22007 | PRV | Philip Woods | 2001-02-24 | — | 9877177326 | 8935 Valley View Dr, Eden Prairie, MN, 55320 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| ENR-121687 | ENR | Matthew Y Watkins | 1955-02-28 | UHC-51086-64 | 4593291415 | 2935 Harbor Blvd, Fresno, CA, 93782 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| TPA-57509 | TPA | Edward Sandoval | 1982-04-22 | — | — | 6632 Broadway, Minneapolis, MN, 55464 | 0.82 | Address re-casedState name converted to codePlaceholder values cleared |
| ENR-116912 | ENR | Judith E Dunn | 1974-06-08 | UHC-01652-57 | 4669492533 | 52 Lake View Rd, Atlanta, GA, 30375 | 0.82 | Phone reformattedState name converted to codeEmail lower-cased |
| TPA-64363 | TPA | Sandra Scott | 1974-11-01 | UHC-00116-94 | — | 3389 Harbor Blvd, Las Vegas, NV, 89158 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| TPA-50257 | TPA | Janice Kelley | 1960-05-25 | — | — | 5743 Pine Dr, Los Angeles, CA, 90036 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-107066 | ENR | Isabella K Andrews | 1959-10-19 | UHC-83174-58 | 8309365434 | 7949 Mesa Dr, Charlotte, NC, 28280 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| TPA-52178 | TPA | Christina Kennedy | 1985-08-03 | — | 2128347188 | 1803 Central Ave, Tucson, AZ, 85706 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| ENR-132299 | ENR | Randy T Miller | 1997-11-14 | UHC-62370-87 | 2535363072 | 5877 Sunset Blvd, Dallas, TX, 75286 | 0.82 | Date of birth reformattedPhone reformattedState name converted to code |
| TPA-60920 | TPA | Daniel Elliott | 1941-12-11 | — | — | 4953 Washington St, Eden Prairie, MN, 55370 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| PRV-22507 | PRV | Don Fialds | 1981-05-24 | UHC-22806-16 | 4973747885 | 7784 Broadway, Houston, TX, 77076 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| ENR-106281 | ENR | Angela G Kennedy | 1998-08-04 | UHC-50851-54 | 2565507688 | 890 Forest Ave, Dallas, TX, 75239 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| ENR-135548 | ENR | Andrew Wilson | 2000-12-16 | UHC-28885-14 | 8594999332 | 301 Church St, Orlando, FL, 32890 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| CLM-419978 | CLM | Kelly Q Lucas | 1938-05-23 | UHC-05461-94 | 5442390657 | 8835 Market St, Las Vegas, NV, 89106 | 0.82 | Member ID reformattedState name converted to codeWhitespace trimmed |
| ENR-105124 | ENR | Frances Ross | 1996-02-24 | UHC-77600-96 | 6732410218 | 1901 Sage Ct, Jacksonville, FL, 32266 | 0.82 | State name converted to codeEmail lower-casedWhitespace trimmed |
| ENR-124187 | ENR | Jeffrey Bryant | 1955-12-05 | — | 9697668740 | 356 Camelback Rd, Sacramento, CA, 95823 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| CLM-405485 | CLM | Luis Fernandez | 1939-03-16 | — | — | 6230 Camelback Rd, Austin, TX, 78790 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-131648 | ENR | Linda Wong | 1986-02-05 | UHC-53662-77 | 6142896788 | 2390 Apache Blvd, Tampa, FL, 33681 | 0.82 | Date of birth reformattedPhone reformattedState name converted to code |
| CLM-415837 | CLM | Gabriel Long | 1969-09-28 | UHC-46388-29 | — | 8401 Market St, Mesa, AZ, 85201 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| CLM-431195 | CLM | Timothy Long | 2003-10-01 | — | 2673602144 | 994 Broadway, Glendale, AZ, 85304 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| CLM-417774 | CLM | Patricia K Phillips | 1964-04-13 | — | — | 6649 Hillcrest Rd, Plano, TX, 75021 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| ENR-117629 | ENR | Luis Hunter | 1997-11-24 | UHC-49762-13 | 2293013474 | 189 Ocean Ave, Plano, TX, 75022 | 0.82 | City re-casedState name converted to codeWhitespace trimmed |
| CLM-415626 | CLM | Philip Carroll | 1942-06-22 | UHC-25359-26 | — | 4716 Highland Ave, San Diego, CA, 92130 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| CLM-410795 | CLM | Naancy S Carroll | 1979-05-04 | UHC-31589-42 | 7898429756 | 6414 Meadow Ln, Phoenix, AZ, 85091 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| ENR-135197 | ENR | Elijah Weaver | 1954-12-01 | UHC-12057-36 | 3912403286 | 2757 Cedar Ln, Seattle, WA, 98180 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| CLM-423739 | CLM | Alan Thompson | 1972-10-05 | UHC-77689-96 | 5816288126 | 2288 Sunset Blvd, Eden Prairie, MN, 55346 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| CLM-403149 | CLM | Melissa Y Thompson | 1990-08-26 | — | — | 9669 Valley View Dr, Orlando, FL, 32889 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| CLM-423719 | CLM | Diane Schultz | 1997-10-25 | — | — | 4295 Mesa Dr, Tampa, FL, 33680 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-101538 | ENR | Sean Burke | 1986-11-06 | UHC-28475-44 | 3448325322 | 6796 Bayshore Dr, Chandler, AZ, 85299 | 0.82 | State name converted to codeEmail lower-casedPlaceholder values cleared |
| ENR-129483 | ENR | Billy D Perry | 1982-09-19 | UHC-66672-37 | 5114417958 | 1501 Lincoln Way, Los Angeles, CA, 90067 | 0.82 | State name converted to codeEmail lower-casedWhitespace trimmed |
| ENR-127916 | ENR | Harold S Espinoza | 1984-09-28 | UHC-90072-37 | 3747988559 | 3889 Canyon Rd, Glendale, AZ, 85302 | 0.82 | Date of birth reformattedPhone reformattedState name converted to code |
| CLM-409964 | CLM | Roger Vazquez | 2005-07-09 | UHC-14553-33 | — | 8024 Hillcrest Rd, Jacksonville, FL, 32261 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-140989 | ENR | Diego U Collins | 2006-12-06 | UHC-59837-42 | 7065794686 | 1389 Lincoln Way, Plano, TX, 75034 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| ENR-106017 | ENR | Beverly Nunez | 1983-11-16 | UHC-32163-09 | 9658056767 | 3434 Spring St, Nashville, TN, 37226 | 0.82 | Phone reformattedState name converted to codeEmail lower-cased |
| CLM-429441 | CLM | Jacobs V Timothy | 1971-04-01 | UHC-40832-18 | 5884176875 | 507 Bayshore Dr, Sacramento, CA, 95894 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| PRV-26481 | PRV | Kenneth Schmidt | 1963-07-03 | — | 3512069883 | 2650 Harbor Blvd, Scottsdale, AZ, 85275 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| CLM-424664 | CLM | Alice Mejia | 1942-06-13 | — | — | 649 Apache Blvd, Denver, CO, 80254 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| CLM-412600 | CLM | Crawford Cheryl | 1953-01-26 | UHC-10278-83 | — | 1039 Willow Ct, Los Angeles, CA, 90015 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| ENR-138186 | ENR | Kevin Q Perez | 1989-09-24 | UHC-61731-59 | 3204814309 | 6212 Ocean Ave, Glendale, AZ, 85377 | 0.82 | Date of birth reformattedPhone reformattedState name converted to code |
| ENR-131817 | ENR | Shirley B Ross | 1969-06-11 | UHC-60836-54 | 7556646074 | 8165 Harbor Blvd, Charlotte, NC, 28223 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-122110 | ENR | Sandra T Hoffman | 1969-10-27 | UHC-22666-98 | 7888898371 | 7038 Desert Sky Blvd, Mesa, AZ, 85253 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| ENR-139729 | ENR | Bruce Y Contreras | 1991-04-17 | UHC-19978-45 | 6786850376 | 4131 Broadway, Charlotte, NC, 28286 | 0.82 | Name re-casedState name converted to codeWhitespace trimmed |
| ENR-135652 | ENR | William I Roze | 1964-03-08 | UHC-55154-36 | 8553123142 | 5030 Cedar Ln, Phoenix, AZ, 85035 | 0.82 | Name re-casedState name converted to codeWhitespace trimmed |
| CLM-416979 | CLM | Aisha Santos | 1981-12-07 | UHC-20680-09 | 8632051547 | 8512 Bayshore Dr, Miami, FL, 33184 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| CLM-413498 | CLM | Marilyn Long | 1948-06-28 | UHC-02319-99 | — | 4006 Broadway, Eden Prairie, MN, 55374 | 0.82 | Name re-casedState name converted to codeWhitespace trimmed |
| TPA-61621 | TPA | Gerald Harrison | 1965-08-14 | — | — | 6815 Market St, Miami, FL, 33190 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| PRV-24127 | PRV | Ralph Wang | 1957-12-03 | UHC-14239-31 | 9104336575 | 5835 Washington St, Chandler, AZ, 85295 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| ENR-106862 | ENR | Jessica X Montgomery | 1977-07-19 | UHC-28580-22 | 6654019985 | 4165 Jefferson Ave, Fresno, CA, 93787 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |