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 dq 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.
- null_tokens_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_recased56,490Street line re-cased and punctuation removed
- address_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_recased39,996Name letter-case rewritten to Title Case and stray characters removed
- dob_reformatted32,400Date of birth rewritten to ISO 8601 from a source format (MM/DD/YYYY, YYYYMMDD, Mon D, YYYY)
- city_recased17,850City re-cased to Title Case
- gender_normalised16,828Gender mapped to F or M from a longer or variant value
- email_recased11,635Email lower-cased
- name_last_first_format9,980First-name field held "LAST, FIRST"; the two parts were split into their own fields
- state_expanded_to_code9,084Full state name replaced by its two-letter USPS code
- zip_plus4_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
- address_unit_split6,994Apartment, suite or unit designator split from street line and re-appended in standard form
- dob_two_digit_year6,661Date of birth carried a two-digit year; century inferred by pivot
- state_recased4,010Two-letter state code upper-cased
- plan_recased3,278Plan code upper-cased
- ssn4_extracted2,817Last four digits of SSN extracted from a longer or punctuated value
- dob_unparsed2,274Date of birth did not match any known format or was out of range; cleared
- phone_partial2,021Phone had only seven digits (no area code); cleared
- name_middle_embedded1,125A single middle initial was embedded in the first-name field and moved to middle name
- dob_missing990Date of birth absent or a null token; left empty
- junk_missing_name505No 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 | DQ score | Flags |
|---|---|---|---|---|---|---|---|---|
| ENR-140063 | ENR | Billy R Andrews | 1955-04-07 | UHC-79954-12 | 2518606280 | 7626 River Rd Apt 19, Columbus, OH | 0.06 | name_last_first_formatdob_reformattedphone_reformattedmember_id_reformatted+7 |
| TPA-54530 | TPA | Janice Dunn | 1953-04-18 | — | — | 3591 Oak St # 418, Denver, CO, 80249 | 0.06 | name_recaseddob_two_digit_yearssn4_extractedaddress_unit_split+7 |
| ENR-122320 | ENR | Melissa M Jones | 1991-01-08 | UHC-57867-73 | 7842759318 | 4590 Mesa Dr # 684, Orlando, FL | 0.06 | name_recaseddob_reformattedphone_reformattedssn4_extracted+7 |
| ENR-137840 | ENR | Arthur R Johnson | 1954-04-15 | UHC-46807-70 | 8954334474 | 58 Spring St # 837, Houston, TX | 0.08 | name_recaseddob_two_digit_yearphone_reformattedaddress_unit_split+6 |
| ENR-119405 | ENR | Amber P Meyer | 1970-04-13 | UHC-41600-72 | 3285644024 | 3676 Spring St # 765, Glendale, AZ, 85356 | 0.08 | name_recaseddob_two_digit_yearphone_reformattedssn4_extracted+6 |
| ENR-116726 | ENR | Diana Jenkins | 1950-07-14 | UHC-75693-90 | 8555050494 | 2055 Hillcrest Rd, Gilbert, AZ | 0.08 | name_last_first_formatphone_reformattedssn4_extractedaddress_suffix_standardised+6 |
| TPA-52163 | TPA | Dot Sullivan | 1975-07-13 | — | — | 1010 Union St Apt 8, Tucson, AZ, 85755 | 0.08 | name_last_first_formatdob_reformattedaddress_unit_splitaddress_suffix_standardised+6 |
| ENR-100357 | ENR | Mateo T Perez | 1987-01-11 | UHC-84161-20 | 2288512438 | 3898 Palm Dr, Dallas, TX, 75288 | 0.08 | name_last_first_formatdob_two_digit_yearphone_reformattedssn4_extracted+6 |
| PRV-23021 | PRV | Cheryl Collins | 1992-04-14 | — | 4783251355 | 5401 Church St # 246, Los Angeles, CA | 0.08 | name_last_first_formatdob_two_digit_yearphone_reformattedaddress_unit_split+6 |
| PRV-27330 | PRV | Denise F Anderson | 1987-05-16 | — | 2936129893 | 3970 Market St, Las Vegas, NV, 89189 | 0.08 | name_middle_embeddeddob_two_digit_yearaddress_suffix_standardisedaddress_recased+6 |
| ENR-108630 | ENR | Maria Dean | 1956-04-23 | UHC-74698-76 | 6763876139 | 7608 Washington St Apt 1, Seattle, WA | 0.08 | name_last_first_formatdob_two_digit_yearphone_reformattedaddress_unit_split+6 |
| PRV-20940 | PRV | Betty West | 2001-09-13 | — | — | 7361 Jefferson Ave # 637, Chandler, AZ, 85278 | 0.10 | name_last_first_formatphone_partialaddress_unit_splitaddress_suffix_standardised+5 |
| ENR-133281 | ENR | Kimberly H Willis | 1992-07-25 | UHC-08833-43 | 2645269645 | 2559 Palm Dr # 286, Miami, FL | 0.10 | name_last_first_formatphone_reformattedaddress_unit_splitaddress_suffix_standardised+5 |
| CLM-414257 | CLM | Ralph Z Green | 1993-05-05 | — | — | 6872 Main St, Dallas, TX | 0.10 | name_last_first_formatphone_partialaddress_suffix_standardisedaddress_recased+5 |
| ENR-112893 | ENR | Jordan Jordan | 1940-04-04 | UHC-52030-27 | — | 4162 Desert Sky Blvd # 622, Columbus, OH, 43234 | 0.10 | name_last_first_formatdob_reformattedphone_partialaddress_unit_split+5 |
| ENR-111055 | ENR | Randy K Garrett | 1948-06-22 | — | 9764691188 | 4836 Willow Ct # 850, Phoenix, AZ, 85023 | 0.10 | name_last_first_formatname_middle_embeddedphone_reformattedssn4_extracted+5 |
| TPA-53089 | TPA | Janet Z Fuller | 1948-11-25 | — | — | 1869 Palm Dr, Tempe, AZ | 0.12 | name_last_first_formatname_middle_embeddedssn4_extractedaddress_suffix_standardised+4 |
| ENR-101442 | ENR | Kathryn Holmes | — | UHC-21580-23 | 2069501377 | 1223 Canyon Rd Apt 37, Austin, TX, 78717 | 0.12 | name_last_first_formatdob_missingaddress_unit_splitaddress_suffix_standardised+4 |
| TPA-53711 | TPA | Stephen Hansen | 1976-07-12 | UHC-99306-74 | 7442354306 | 3572 Main St Apt 10, Glendale, AZ | 0.18 | name_recaseddob_reformattedphone_reformattedaddress_unit_split+7 |
| ENR-132732 | ENR | Martha U Gordon | 1978-11-07 | UHC-26479-39 | 6864228548 | 6440 Lincoln Way, Dallas, TX | 0.18 | name_recaseddob_two_digit_yearphone_reformattedmember_id_reformatted+7 |
| ENR-119911 | ENR | Adam K Espinoza | — | UHC-06637-93 | 4688521356 | 7933 Sunset Blvd, Phoenix, AZ, 85026 | 0.18 | name_middle_embeddedname_recaseddob_missingphone_reformatted+7 |
| PRV-25675 | PRV | Randy Flores | 1949-04-14 | UHC-96097-03 | 8879728592 | 9683 Indian School Rd Apt 33, Orlando, FL, 32876 | 0.18 | name_last_first_formatdob_reformattedphone_reformattedssn4_extracted+7 |
| ENR-125377 | ENR | Sharon Njunk | 1953-02-19 | UHC-70918-57 | 5476231979 | 5356 Spring St Apt 37, Denver, CO, 80211 | 0.20 | name_recasedphone_reformattedmember_id_reformattedaddress_unit_split+6 |
| ENR-112194 | ENR | Alan U Lane | 1957-12-15 | UHC-70794-22 | 6678340324 | 5399 Union St Apt 26, Eden Prairie, MN, 55380 | 0.20 | name_last_first_formatdob_reformattedmember_id_reformattedaddress_unit_split+6 |
| ENR-100640 | ENR | Stephanie V Carlson | 2004-04-11 | UHC-09860-36 | 4055129777 | 4973 Ocean Ave, Eden Prairie, MN | 0.20 | name_last_first_formatdob_reformattedaddress_suffix_standardisedaddress_recased+6 |
| ENR-103386 | ENR | Gregory H Richardson | 1960-04-11 | UHC-32697-71 | 2909667947 | 1687 Palm Dr Apt 34, Dallas, TX, 75271 | 0.20 | name_recaseddob_two_digit_yearphone_reformattedaddress_unit_split+6 |
| CLM-413386 | CLM | Elijah Boyd | — | UHC-80648-57 | 6663958132 | 5611 Hillcrest Rd, San Diego, CA | 0.20 | name_last_first_formatdob_unparsedaddress_suffix_standardisedaddress_recased+6 |
| ENR-131882 | ENR | Amanda Morgan | — | UHC-66379-93 | 5745696902 | 3949 Jefferson Ave, Miami, FL, 33179 | 0.20 | name_last_first_formatdob_unparsedphone_reformattedmember_id_reformatted+6 |
| ENR-113612 | ENR | Heather T Powell | 1976-04-09 | UHC-93409-15 | 6565984051 | 1816 Spring St # 128, Atlanta, GA | 0.20 | name_last_first_formatdob_reformattedphone_reformattedmember_id_reformatted+6 |
| CLM-425051 | CLM | Charles N Ortiz | 1938-04-02 | — | 9519246952 | 6243 Hillcrest Rd, Glendale, AZ, 85395 | 0.20 | name_last_first_formatname_middle_embeddeddob_two_digit_yearphone_reformatted+6 |
| CLM-428349 | CLM | Frances Berry | 1968-02-08 | — | 2047033326 | 384 Highland Ave # 681, Minneapolis, MN, 55406 | 0.20 | dob_two_digit_yearphone_reformattedaddress_unit_splitaddress_suffix_standardised+6 |
| ENR-140634 | ENR | Deborah B Hughes | 1956-01-10 | UHC-56499-04 | 8689929527 | 7923 Lake View Rd # 360, San Antonio, TX, 78224 | 0.20 | name_recaseddob_reformattedphone_reformattedaddress_unit_split+6 |
| PRV-22700 | PRV | Janice Mendoza | 1998-10-04 | — | 4709141900 | 8684 Main St Apt 23, Scottsdale, AZ, 85226 | 0.20 | name_recaseddob_two_digit_yearphone_reformattedaddress_unit_split+6 |
| ENR-108536 | ENR | Joe G Wong | 1984-10-19 | UHC-70034-25 | 4669484278 | 7380 Bayshore Dr, Sacramento, CA, 95806 | 0.20 | name_last_first_formatphone_reformattedaddress_suffix_standardisedaddress_recased+6 |
| CLM-407362 | CLM | Gary Sims | 1950-04-10 | — | 8036631340 | 7461 Maple Ave Apt 5, Tampa, FL, 33676 | 0.20 | name_recasedphone_reformattedssn4_extractedaddress_unit_split+6 |
| CLM-426274 | CLM | Stephen Morrison | — | UHC-09325-93 | 6654978473 | 141 Indian School Rd, Las Vegas, NV | 0.20 | name_recaseddob_unparsedphone_reformattedaddress_suffix_standardised+6 |
| ENR-132849 | ENR | Amanda Richards | — | UHC-51387-40 | 6545023050 | 7205 Cedar Ln # 712, Tempe, AZ, 85228 | 0.20 | name_last_first_formatdob_reformatteddob_unparsedphone_reformatted+6 |
| TPA-51065 | TPA | Richard Lawson | 1947-05-12 | UHC-60766-62 | — | 560 Maple Ave Apt 23, Dallas, TX, 75294 | 0.20 | name_recasedaddress_unit_splitaddress_suffix_standardisedaddress_recased+6 |
| ENR-135108 | ENR | Angela O Martinez | 1999-10-19 | UHC-65881-79 | 6313887471 | 8789 Indian School Rd # 632, Tempe, AZ, 85294 | 0.20 | name_recaseddob_two_digit_yearphone_reformattedaddress_unit_split+6 |
| ENR-123658 | ENR | Ken Fowler | 1989-05-09 | UHC-79833-73 | 6302317839 | 821 Bayshore Dr, Seattle, WA | 0.20 | name_recasedphone_reformattedssn4_extractedaddress_suffix_standardised+6 |
| ENR-133309 | ENR | Rob O Bradley | 1991-11-22 | UHC-05439-11 | 5582033873 | 3306 Willow Ct Apt 21, Phoenix, AZ | 0.20 | phone_reformattedmember_id_reformattedssn4_extractedaddress_unit_split+6 |
| CLM-403990 | CLM | Andrea Alvarado | 2001-04-04 | UHC-47319-34 | 8396574728 | 5259 Pine Dr, Mesa, AZ | 0.20 | name_last_first_formatdob_reformattedphone_reformattedaddress_suffix_standardised+6 |
| ENR-109410 | ENR | Grece Philllips | 1939-01-26 | UHC-41031-01 | — | 7250 Pine Dr, Houston, TX, 77002 | 0.20 | name_recaseddob_reformattedphone_partialssn4_extracted+6 |
| ENR-105494 | ENR | Kevin T Nelsson | 1946-03-21 | UHC-81221-67 | 2538063119 | 739 Washington St, Denver, CO, 80228 | 0.20 | name_last_first_formatname_middle_embeddeddob_reformattedphone_reformatted+6 |
| ENR-142191 | ENR | George A Wright | 1990-07-07 | UHC-50766-06 | 3342029082 | 7932 Camelback Rd # 949, Miami, FL, 33178 | 0.20 | name_recasedphone_reformattedaddress_unit_splitaddress_suffix_standardised+6 |
| CLM-400390 | CLM | Abiagil Olson | — | UHC-39205-83 | 8578754323 | 2663 Forest Ave Apt 37, Jacksonville, FL, 32270 | 0.20 | name_recaseddob_missingphone_reformattedaddress_unit_split+6 |
| ENR-110258 | ENR | Emily P Armstrong | 1959-12-08 | — | 4608754857 | 4902 Palm Dr # 432, Chandler, AZ, 85289 | 0.20 | name_middle_embeddeddob_reformattedphone_reformattedaddress_unit_split+6 |
| ENR-112759 | ENR | William A Walsh | 1983-03-25 | UHC-07070-34 | 5725663894 | 8684 Spring St Apt 34, Mesa, AZ, 85296 | 0.20 | name_recaseddob_two_digit_yearphone_reformattedmember_id_reformatted+6 |
| ENR-120779 | ENR | Doris Hunter | 1972-11-04 | UHC-71005-52 | — | 8898 Cedar Ln Apt 5, Atlanta, GA | 0.20 | name_recaseddob_two_digit_yearaddress_unit_splitaddress_suffix_standardised+6 |
| ENR-103381 | ENR | Donna G Torres | 1981-10-11 | UHC-70484-11 | — | 8447 Willow Ct Apt 11, Orlando, FL, 32879 | 0.20 | name_last_first_formatdob_reformattedphone_partialaddress_unit_split+6 |