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, flag “Date of birth unreadable”, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| ENR-104391 | ENR | Dorothy W Rogers | — | UHC-06003-66 | 3407199887 | — | 0.82 | Date of birth unreadablePhone reformattedPlaceholder values cleared |
| ENR-119846 | ENR | Amber Burns | — | UHC-27318-12 | 9218102296 | 7470 Lincoln Way, Chandler, AZ, 85241 | 0.82 | Name re-casedDate of birth unreadablePhone reformatted |
| ENR-114853 | ENR | Cheryl V Payne | — | UHC-07886-22 | 6958506699 | 7084 Apache Blvd, Scottsdale, AZ, 85289 | 0.82 | Date of birth unreadablePhone reformattedMember ID reformatted |
| ENR-142526 | ENR | Hiroshi B Russell | — | UHC-16259-54 | 5902349183 | 203 Oak St, Phoenix, AZ, 85030 | 0.82 | Name re-casedDate of birth unreadablePhone reformatted |
| ENR-128778 | ENR | Lauren J Willis | — | UHC-41715-68 | 8298238232 | 9796 Park Pl, Glendale, AZ, 85338 | 0.82 | Date of birth unreadablePhone reformattedPlaceholder values cleared |
| ENR-113429 | ENR | Benjamin F Ferguson | — | UHC-84231-89 | 8477293458 | 2793 Apache Blvd, Chandler, AZ, 85236 | 0.82 | Name re-casedDate of birth unreadablePhone reformatted |
| ENR-104958 | ENR | Scott G Schultz | — | UHC-40594-68 | 4324935516 | 6925 Bayshore Dr, Tampa, FL, 33699 | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-126650 | ENR | Sen G Munoz | — | UHC-30839-32 | 9802167970 | — | 0.82 | Date of birth unreadablePhone reformattedPlaceholder values cleared |
| ENR-123159 | ENR | Beverly Hicks | — | UHC-10140-65 | — | 3610 Bayshore Dr, Houston, TX, 77040 | 0.82 | Date of birth unreadableEmail lower-casedWhitespace trimmed |
| ENR-142652 | ENR | Julie K Romero | — | UHC-01895-18 | 2125637377 | 5688 Highland Ave, San Antonio, TX, 78229 | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-120807 | ENR | Chares Walker | — | UHC-36240-36 | 4335898997 | 2543 Oak St, Orlando, FL, 32828 | 0.82 | Name re-casedDate of birth unreadableWhitespace trimmed |
| ENR-116730 | ENR | Harold P Patterson | — | UHC-04603-36 | 3754075325 | 226 Harbor Blvd, San Antonio, TX, 78260 | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-133561 | ENR | Jack Kennedy | — | UHC-82804-57 | 8119803553 | 1930 Valley View Dr, Orlando, FL, 32880 | 0.82 | Date of birth unreadablePhone reformattedEmail lower-cased |
| ENR-127352 | ENR | Danielle Murray | — | UHC-55126-74 | 4683016909 | 7790 Meadow Ln, Eden Prairie, MN, 55330 | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-132253 | ENR | Julia F Dean | — | UHC-21980-71 | 6408302752 | 5101 Central Ave, Gilbert, AZ, 85221 | 0.82 | Date of birth unreadablePhone reformattedPlaceholder values cleared |
| ENR-120910 | ENR | Judy Williams | — | UHC-14307-75 | 4322595626 | 1930 Apache Blvd, Tampa, FL, 33683 | 0.82 | Date of birth unreadablePhone reformattedPlaceholder values cleared |
| ENR-135268 | ENR | Kimberly Fox | — | UHC-78140-79 | 8758928832 | 3661 Bayshore Dr, Houston, TX, 77087 | 0.82 | Name re-casedDate of birth unreadableWhitespace trimmed |
| ENR-139957 | ENR | Kathy S Moore | — | UHC-75963-29 | — | 6354 Sage Ct, San Diego, CA, 92109 | 0.84 | Date of birth unreadablePlaceholder values cleared |
| ENR-115569 | ENR | Gabriel Woods | — | UHC-32492-25 | 2889487679 | 1388 Broadway, Las Vegas, NV, 89188 | 0.84 | Date of birth unreadableCity re-cased |
| ENR-127960 | ENR | Katherine V Willis | — | UHC-08939-72 | 2407526608 | 7286 Market St, Tampa, FL, 33675 | 0.84 | Date of birth unreadablePhone reformatted |
| ENR-122067 | ENR | Janet I Cruz | — | UHC-94131-80 | 7995542291 | 6842 Oak St, Chandler, AZ, 85244 | 0.84 | Date of birth unreadablePhone reformatted |
| ENR-108356 | ENR | Betty W Howell | — | UHC-02016-96 | 4619683607 | 9513 Apache Blvd, Columbus, OH, 43264 | 0.84 | Name re-casedDate of birth unreadable |
| ENR-107527 | ENR | Donna Robertson | — | UHC-66274-68 | 9275933963 | 7904 Washington St, Fresno, CA, 93730 | 0.84 | Date of birth unreadablePhone reformatted |
| ENR-111933 | ENR | Nicole R Gonzalez | — | UHC-66531-64 | — | 2729 Lincoln Way, San Antonio, TX, 78253 | 0.84 | Date of birth unreadableWhitespace trimmed |
| ENR-121782 | ENR | Debra Wagner | — | UHC-54439-28 | — | 4557 Canyon Rd, San Antonio, TX, 78240 | 0.84 | Date of birth unreadablePlaceholder values cleared |
| ENR-134832 | ENR | Olivia Howard | — | UHC-07176-58 | 3585107272 | 4243 Oak St, Jacksonville, FL, 32241 | 0.84 | Date of birth unreadablePhone reformatted |
| ENR-102523 | ENR | Albert H Fields | — | UHC-51978-32 | 9662119279 | 3255 Union St, Minneapolis, MN, 55420 | 0.84 | Date of birth unreadablePhone reformatted |
| ENR-112550 | ENR | Russell F Carlson | — | UHC-77117-13 | 9526754342 | 1243 Main St, Miami, FL, 33176 | 0.84 | Date of birth unreadableWhitespace trimmed |
| ENR-137220 | ENR | Beverly Andrews | — | UHC-46632-04 | 9302678660 | 3754 Market St, Las Vegas, NV, 89190 | 0.84 | Date of birth unreadablePhone reformatted |
| ENR-136707 | ENR | Matthew I Howell | — | UHC-86672-41 | 3443060500 | 609 Apache Blvd, Gilbert, AZ, 85243 | 0.84 | Date of birth unreadableEmail lower-cased |
| ENR-142931 | ENR | Melissa B Perez | — | UHC-17175-25 | 9395377186 | 631 Union St, Sacramento, CA, 95842 | 0.84 | Date of birth unreadablePhone reformatted |
| ENR-106586 | ENR | Kathleen C Wagner | — | UHC-50953-59 | 2303262343 | 8548 Bayshore Dr, Seattle, WA, 98166 | 0.84 | Date of birth unreadablePhone reformatted |
| ENR-111618 | ENR | Emma N Dunn | — | UHC-28577-51 | 6095564294 | 7042 Broadway, Chandler, AZ, 85249 | 0.84 | Date of birth unreadableWhitespace trimmed |
| ENR-100876 | ENR | Logan Gardner | — | UHC-91262-32 | 6242686654 | 7230 Park Pl, Scottsdale, AZ, 85272 | 0.84 | Date of birth unreadableWhitespace trimmed |
| ENR-139762 | ENR | Jeremy Hunt | — | UHC-59297-43 | — | 4716 Sunset Blvd, Jacksonville, FL, 32236 | 0.84 | Date of birth unreadablePlaceholder values cleared |
| ENR-133863 | ENR | Raymond Jenkins | — | UHC-34809-40 | 9199131442 | 669 Washington St, Plano, TX, 75097 | 0.84 | Date of birth unreadableWhitespace trimmed |
| ENR-120841 | ENR | Randy Robertson | — | UHC-77559-84 | 4489147374 | 4391 Baseline Rd, Columbus, OH, 43230 | 0.86 | Date of birth unreadable |
| ENR-106427 | ENR | Christopher Welch | — | UHC-41607-47 | 6949201547 | 8198 Grand Ave, Orlando, FL, 32871 | 0.86 | Date of birth unreadable |
| ENR-104223 | ENR | Jean Contreras | — | UHC-29251-65 | 2555930153 | 3730 Hillcrest Rd, San Antonio, TX, 78202 | 0.86 | Date of birth unreadable |
| ENR-102419 | ENR | Marcus Grifffin | — | UHC-10120-08 | — | 4569 Grand Ave, San Diego, CA, 92129 | 0.86 | Date of birth unreadable |
| ENR-100524 | ENR | Terry Richardson | — | UHC-04412-61 | 7636692754 | 2542 Jefferson Ave, Atlanta, GA, 30395 | 0.86 | Date of birth unreadable |