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
Enrollment, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| ENR-118529 | ENR | Gary G Greene | 1983-08-06 | UHC-86614-46 | 8706424329 | 4571 Jefferson Ave, Atlanta, GA, 30364 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-119876 | ENR | Robert Z Dominguez | — | UHC-72381-88 | 4066349198 | 3310 Willow Ct, Los Angeles, CA | 0.50 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more |
| ENR-112547 | ENR | Becky P Ferguson | 1939-04-11 | UHC-58326-17 | 2436302509 | 429 Harbor Blvd # 785, Tampa, FL, 33658 | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-111348 | ENR | Julie Hall | 2008-02-10 | UHC-86527-90 | 5212095610 | 6710 Mesa Dr, San Antonio, TX, 78249 | 0.50 | Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-114399 | ENR | Sandra Peterson | 1970-06-24 | UHC-01975-42 | 6312063229 | 9822 Washington St, Los Angeles, CA | 0.50 | Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-110363 | ENR | Christian I Gonzales | — | UHC-04668-80 | 5396447971 | 2643 Maple Ave, Orlando, FL, 32879 | 0.50 | Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more |
| ENR-108855 | ENR | Ahmed M Hudson | 2000-03-10 | UHC-80428-70 | 9817944266 | 4171 Valley View Dr Apt 33, Sacramento, CA, 95809 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-128247 | ENR | Doris Guzman | 1956-10-23 | UHC-56787-59 | 3642722355 | 3126 Indian School Rd, Minneapolis, MN, 55466 | 0.50 | Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-128246 | ENR | Doris Guzman | 1956-10-23 | UHC-56787-59 | 3642722355 | 3126 Indian School Rd, Minneapolis, MN, 55466 | 0.50 | Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-126423 | ENR | Ashley Murray | 1984-07-27 | UHC-29306-70 | 4915297452 | 8578 Harbor Blvd, Orlando, FL, 32891 | 0.50 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-140600 | ENR | Dyylan R Stephens | 1982-08-03 | UHC-29218-23 | 3878070018 | 8540 Meadow Ln, Plano, TX | 0.50 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-126422 | ENR | Pirya Y Ramos | 1960-03-13 | UHC-54011-48 | 2178346182 | 814 Apache Blvd, Miami, FL, 33179 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-101934 | ENR | Robert C Alexander | 1959-03-08 | UHC-08776-21 | — | 814 Camelback Rd, Orlando, FL, 32866 | 0.50 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135018 | ENR | Jose L Harvey | 1991-04-12 | UHC-37133-74 | 2435640448 | 8461 Elm St, San Diego, CA, 92136 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-115276 | ENR | Billy Grant | 1958-09-19 | UHC-16300-53 | 7687321105 | 3323 Mountain View Dr # 467, Scottsdale, AZ | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-102243 | ENR | Andrea Holmes | 1965-05-05 | UHC-52048-24 | — | 1113 River Rd Apt 37, Atlanta, GA, 30336 | 0.50 | Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| ENR-107374 | ENR | Heather G Black | 1983-01-18 | UHC-29594-73 | 6555486532 | 3321 Washington St, Los Angeles, CA, 90040 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-107373 | ENR | Heather G Black | 1983-01-18 | UHC-29594-73 | 6555486532 | 3321 Washington St, Los Angeles, CA, 90040 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-106474 | ENR | Jason Nelson | 1990-01-28 | UHC-26606-97 | 8774549967 | 5012 Desert Sky Blvd # 887, San Diego, CA, 92187 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-138536 | ENR | Roger V Taylor | 1996-11-08 | UHC-26029-98 | 6877346758 | 4847 Church St, Dallas, TX, 75292 | 0.50 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109418 | ENR | Henry Roberts | 1969-10-21 | UHC-17992-75 | 6856078523 | 7955 Sage Ct, Chandler, AZ, 85285 | 0.50 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-136413 | ENR | Willie Bailey | 1973-10-24 | UHC-45370-87 | 6732864536 | 9548 Union St, San Antonio, TX, 78284 | 0.50 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121028 | ENR | Kelly L Contreras | 1992-03-23 | UHC-65136-03 | 6797463100 | 9844 Valley View Dr, Las Vegas, NV | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-121027 | ENR | Kelly L Contreras | 1992-03-23 | UHC-65136-03 | 6797463100 | 9844 Valley View Dr, Las Vegas, NV | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-106676 | ENR | Madison V Hawkins | 1987-01-09 | UHC-63822-79 | 3995150164 | 8810 Lake View Rd, Minneapolis, MN, 55465 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-117058 | ENR | Harold Gonzales | 1980-06-19 | UHC-74823-63 | 2725768115 | 6248 Camelback Rd # 635, Tucson, AZ, 85713 | 0.50 | Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-119719 | ENR | George S Hernandez | 1955-03-23 | UHC-67581-90 | 2286317709 | 6868 Ridge Rd # 437, Mesa, AZ, 85297 | 0.50 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-138201 | ENR | Natalie Harrys | 2007-04-14 | UHC-83927-10 | 7507318648 | 4586 Cedar Ln, San Antonio, TX | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-103344 | ENR | Joseph QJunk | 1991-08-04 | UHC-11166-10 | 9616066920 | 9484 Highland Ave, Tucson, AZ | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-140994 | ENR | Susan Contreras | 1963-04-01 | UHC-06057-20 | — | 7437 Sage Ct, Columbus, OH, 43295 | 0.50 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| ENR-139579 | ENR | Ethan E Gardner | 1961-03-01 | — | 7583811982 | 8361 Indian School Rd, Nashville, TN, 37248 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-132614 | ENR | Janet A Hicks | 1953-06-15 | UHC-36211-77 | 3812935463 | 40 Main St, Columbus, OH, 43241 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-128765 | ENR | Keith Long | 1985-12-28 | UHC-61870-19 | 3656913767 | 8925 Highland Ave, Jacksonville, FL, 32227 | 0.50 | Phone reformattedSSN last four extractedCity re-casedZIP+4 trimmed+3 more |
| ENR-115653 | ENR | Jordan Z Tucker | 2007-11-17 | UHC-04978-28 | — | 7544 Ridge Rd, Phoenix, AZ, 85063 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-115654 | ENR | Jordan Z Tucker | 2007-11-17 | UHC-04978-28 | — | 7544 Ridge Rd, Phoenix, AZ, 85063 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-115157 | ENR | Aigail Y Franklin | 2001-09-17 | UHC-02014-79 | 3273400298 | 6682 Central Ave, Phoenix, AZ, 85079 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-122561 | ENR | Sophia T Jensen | 1955-01-11 | — | 7598340220 | 9101 Union St, Atlanta, GA | 0.50 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-125827 | ENR | Saron Ford | 1965-12-07 | UHC-29790-88 | 3493993797 | 845 Indian School Rd, Charlotte, NC, 28217 | 0.50 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-130440 | ENR | Elijah A Medina | 1950-10-18 | UHC-16726-86 | 3752726270 | 7673 Ridge Rd # 905, Plano, TX, 75014 | 0.50 | Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-133331 | ENR | Bobby T Nelson | — | UHC-69366-19 | 7233944195 | 2623 Ocean Ave, Gilbert, AZ, 85267 | 0.50 | Middle initial moved out of first nameDate of birth missingPhone reformattedStreet suffix standardised+3 more |
| ENR-137470 | ENR | Matthew D Shwa | — | UHC-20965-71 | 6278473968 | 1303 Ocean Ave, Fresno, CA, 93793 | 0.50 | Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more |
| ENR-115280 | ENR | Lawrence K Weaver | 1964-02-04 | UHC-26133-98 | 9292120024 | 3519 Church St Apt 22, Tempe, AZ, 85219 | 0.50 | Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more |
| ENR-111784 | ENR | Jim X Herrera | 2007-10-15 | UHC-91233-31 | 5506593172 | 3206 Washington St, Las Vegas, NV | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-137450 | ENR | Snyder H Carolyn | 1967-06-26 | UHC-76043-35 | 4036917212 | 9463 Hillcrest Rd, Eden Prairie, MN, 55391 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-121813 | ENR | Lawrence J Williams | 1987-07-11 | UHC-68040-19 | 8988804967 | 7519 Highland Ave, Minneapolis, MN, 55461 | 0.50 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-116674 | ENR | Jackie K Simpson | 1977-08-11 | — | 4259778476 | 9403 Highland Ave, Gilbert, AZ, 85246 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-119875 | ENR | Jesse L Bowman | 1997-04-20 | UHC-57466-82 | 4708210239 | 9636 Desert Sky Blvd, Sacramento, CA | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-125220 | ENR | Debra S Meyer | 1981-02-03 | UHC-68461-30 | 8817745015 | 3651 Central Ave, San Diego, CA | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110626 | ENR | Emily J Martin | 1997-05-14 | UHC-23423-50 | 9666136576 | 3958 Elm St, Miami, FL, 33109 | 0.50 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128484 | ENR | Shirley Lee | — | UHC-25265-26 | 9135818916 | 9437 Camelback Rd, Columbus, OH, 43205 | 0.50 | Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more |