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-113303 | ENR | Roy F Gray | — | UHC-24777-38 | 7296664724 | 7049 Cedar Ln, Orlando, FL, 32880 | 0.80 | Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-106830 | ENR | Ana D Contreras | — | UHC-79284-72 | 6187624848 | 9416 Ridge Rd, Atlanta, GA, 30359 | 0.80 | Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-102800 | ENR | Alexxander W Parker | — | UHC-39613-61 | 6475091647 | 1372 Broadway, Columbus, OH, 43256 | 0.80 | Name re-casedDate of birth unreadablePhone reformattedAddress re-cased |
| ENR-123522 | ENR | Greg Taylor | — | UHC-40403-19 | 8789534201 | — | 0.80 | Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared |
| ENR-111717 | ENR | Maria Ortiz | — | UHC-34340-27 | 2869611624 | 1527 Park Pl, Nashville, TN, 37222 | 0.80 | Name re-casedDate of birth unreadableCity re-casedWhitespace trimmed |
| ENR-130364 | ENR | Carolyn Evans | — | UHC-34615-37 | 4522393819 | 2666 Broadway, Scottsdale, AZ, 85203 | 0.80 | Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-112462 | ENR | Emily T Little | — | UHC-13577-79 | 2425511162 | 6250 Willow Ct, Las Vegas, NV, 89138 | 0.80 | Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-120441 | ENR | Sharon Z Simmons | — | UHC-71089-33 | — | 3873 Hillcrest Rd, Miami, FL, 33126 | 0.80 | Date of birth unreadableMember ID reformattedWhitespace trimmedPlaceholder values cleared |
| ENR-120154 | ENR | Kenneth J Shaw | — | UHC-78163-44 | 2528267769 | 9058 Broadway, Columbus, OH, 43245 | 0.82 | Date of birth unreadablePhone reformattedPlaceholder values cleared |
| ENR-120703 | ENR | Benjamin Z Harper | — | UHC-31896-42 | 8068666322 | 493 Spring St, Mesa, AZ, 85224 | 0.82 | Date of birth unreadableWhitespace trimmedPlaceholder values cleared |
| ENR-127389 | ENR | Emily Harper | — | UHC-67702-49 | — | 4685 Desert Sky Blvd, Nashville, TN, 37239 | 0.82 | Date of birth unreadableEmail lower-casedPlaceholder values cleared |
| ENR-107164 | ENR | Jason S Mills | — | UHC-87174-74 | 2812475291 | 1493 Sage Ct, Columbus, OH, 43203 | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-130271 | ENR | Sandra S Banks | — | UHC-77872-48 | 5844352533 | 7841 Park Pl, Tucson, AZ, 85736 | 0.82 | Date of birth unreadableWhitespace trimmedPlaceholder values cleared |
| ENR-130583 | ENR | Janice Lucas | — | UHC-20193-99 | 4867459238 | 9737 Meadow Ln, Jacksonville, FL, 32204 | 0.82 | Date of birth unreadableEmail lower-casedWhitespace trimmed |
| ENR-110587 | ENR | Sophia Peters | — | UHC-41273-98 | — | 1565 Bayshore Dr, Scottsdale, AZ, 85283 | 0.82 | Date of birth unreadableWhitespace trimmedPlaceholder values cleared |
| ENR-120170 | ENR | Lawrence Nichols | — | UHC-23434-16 | — | 2895 Canyon Rd, Las Vegas, NV, 89183 | 0.82 | Date of birth unreadableWhitespace trimmedPlaceholder values cleared |
| ENR-105413 | ENR | Dylan Webb | — | UHC-32490-35 | — | 2218 Harbor Blvd, Eden Prairie, MN, 55324 | 0.82 | Date of birth unreadableMember ID reformattedCity re-cased |
| ENR-117856 | ENR | Emily P Wallace | — | UHC-48730-84 | 8558219814 | 4775 Camelback Rd, Denver, CO, 80211 | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-101137 | ENR | Aaron Payne | — | UHC-50453-48 | 9089543112 | 9763 Indian School Rd, Glendale, AZ, 85375 | 0.82 | Date of birth unreadablePhone reformattedPlaceholder values cleared |
| ENR-102539 | ENR | Isabella Y Price | — | UHC-41557-49 | 4734495502 | 7692 Meadow Ln, San Antonio, TX, 78235 | 0.82 | Date of birth unreadablePhone reformattedPlaceholder values cleared |
| ENR-129155 | ENR | Maria Schultz | — | UHC-53299-27 | 8525186227 | — | 0.82 | Date of birth unreadableEmail lower-casedPlaceholder values cleared |
| ENR-123368 | ENR | Gerald T Sandoval | — | UHC-41043-56 | 4605688417 | 1877 Mesa Dr, Mesa, AZ, 85212 | 0.82 | Date of birth unreadablePlan code upper-casedWhitespace trimmed |
| ENR-118634 | ENR | Frank Patel | — | UHC-94541-33 | 5214958016 | — | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-122496 | ENR | Alice B Graham | — | UHC-35055-31 | — | 1877 Forest Ave, Seattle, WA, 98129 | 0.82 | Name re-casedDate of birth unreadableWhitespace trimmed |
| ENR-111304 | ENR | Charlotte Owens | — | UHC-49048-55 | 2747782087 | 1858 Jefferson Ave, Orlando, FL, 32867 | 0.82 | Date of birth unreadableEmail lower-casedWhitespace trimmed |
| ENR-129108 | ENR | Yuki Ramirez | — | UHC-45942-10 | 7775651937 | 5770 Apache Blvd, Fresno, CA, 93798 | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-102094 | ENR | Gregory M Williamson | — | UHC-62492-19 | 2918086349 | 9673 Ocean Ave, Houston, TX, 77003 | 0.82 | Name re-casedDate of birth unreadablePhone reformatted |
| ENR-114154 | ENR | Barbara Wong | — | UHC-80734-81 | 5876705306 | 1106 Bayshore Dr, Orlando, FL, 32805 | 0.82 | Name re-casedDate of birth unreadablePhone reformatted |
| ENR-129104 | ENR | Henry N Salazar | — | UHC-44361-63 | 8067857829 | 3077 Park Pl, Las Vegas, NV, 89163 | 0.82 | Date of birth unreadablePhone reformattedPlaceholder values cleared |
| ENR-117683 | ENR | Wright U Joshua | — | UHC-71174-31 | 3802215070 | 7265 Desert Sky Blvd, Chandler, AZ, 85273 | 0.82 | Name re-casedDate of birth unreadablePlaceholder values cleared |
| ENR-117684 | ENR | Wright U Joshua | — | UHC-71174-31 | 3802215070 | 7265 Desert Sky Blvd, Chandler, AZ, 85273 | 0.82 | Name re-casedDate of birth unreadablePlaceholder values cleared |
| ENR-115096 | ENR | Cynthia Elliott | — | UHC-89870-57 | 9576259400 | 8525 Sage Ct, Eden Prairie, MN, 55386 | 0.82 | Name re-casedDate of birth unreadablePhone reformatted |
| ENR-108584 | ENR | Hannah V Wright | — | UHC-63052-14 | — | 9518 Lincoln Way, Las Vegas, NV, 89116 | 0.82 | Name re-casedDate of birth unreadablePlaceholder values cleared |
| ENR-106844 | ENR | Thomas Boyd | — | UHC-64494-34 | 4789265496 | 7546 Sunset Blvd, Sacramento, CA, 95883 | 0.82 | Date of birth reformattedDate of birth unreadablePhone reformatted |
| ENR-125662 | ENR | Julia I Foster | — | UHC-10308-90 | — | 7149 Jefferson Ave, Tucson, AZ, 85723 | 0.82 | Name re-casedDate of birth unreadablePlan code upper-cased |
| ENR-140034 | ENR | Omar Espinoza | — | UHC-74422-88 | 5698243595 | 9085 Baseline Rd, Chandler, AZ, 85253 | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-140035 | ENR | Omar Espinoza | — | UHC-74422-88 | 5698243595 | 9085 Baseline Rd, Chandler, AZ, 85253 | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-137452 | ENR | Victoria P Ramos | — | UHC-08939-34 | 7694038682 | 6219 Lincoln Way, Fresno, CA, 93783 | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-113514 | ENR | Martha S Price | — | UHC-69123-31 | 8369054353 | 9418 Broadway, Glendale, AZ, 85367 | 0.82 | Name re-casedDate of birth unreadablePlaceholder values cleared |
| ENR-129988 | ENR | Carlos P Weber | — | UHC-85560-15 | — | 5935 Broadway, Dallas, TX, 75244 | 0.82 | Name re-casedDate of birth unreadableWhitespace trimmed |
| ENR-103568 | ENR | Dorothy T Ward | — | UHC-42279-56 | 8963014926 | 1415 Camelback Rd, Chandler, AZ, 85276 | 0.82 | Name re-casedDate of birth unreadablePhone reformatted |
| ENR-113690 | ENR | Kayla J Diaz | — | UHC-50759-52 | 2199231856 | 3694 Meadow Ln, Jacksonville, FL, 32284 | 0.82 | Name re-casedDate of birth unreadableWhitespace trimmed |
| ENR-140554 | ENR | Philip E Jnesen | — | UHC-52547-09 | 5577218696 | 9751 River Rd, Columbus, OH, 43238 | 0.82 | Name re-casedDate of birth unreadableWhitespace trimmed |
| ENR-120762 | ENR | Sara Estrada | — | UHC-50584-31 | 8857278051 | 785 Palm Dr, Jacksonville, FL, 32220 | 0.82 | Name re-casedDate of birth unreadableWhitespace trimmed |
| ENR-142167 | ENR | Mateo C Harris | — | UHC-00465-51 | 5333285612 | — | 0.82 | Name re-casedDate of birth unreadablePhone reformatted |
| ENR-107789 | ENR | Linda B Bowman | — | UHC-62137-15 | 3198410592 | 7825 Desert Sky Blvd, San Antonio, TX, 78204 | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-110201 | ENR | Santiago Q Olson | — | UHC-28731-61 | 6347264569 | 9184 Camelback Rd, Austin, TX, 78736 | 0.82 | Name re-casedDate of birth unreadableWhitespace trimmed |
| ENR-113562 | ENR | Willie Mejia | — | UHC-65942-13 | 2302938681 | 2372 Meadow Ln, Dallas, TX, 75259 | 0.82 | Date of birth unreadablePhone reformattedWhitespace trimmed |
| ENR-135086 | ENR | Doris Little | — | UHC-78387-34 | 9727215663 | 5197 Central Ave, Orlando, FL, 32814 | 0.82 | Name re-casedDate of birth unreadableWhitespace trimmed |
| ENR-135087 | ENR | Doris Little | — | UHC-78387-34 | 9727215663 | 5197 Central Ave, Orlando, FL, 32814 | 0.82 | Name re-casedDate of birth unreadableWhitespace trimmed |