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 missing”, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| ENR-110216 | ENR | Katherine Ellis | — | UHC-68175-77 | — | 8308 Meadow Ln, Chandler, AZ, 85246 | 0.80 | Name re-casedDate of birth missingMember ID reformattedPlaceholder values cleared |
| ENR-100010 | ENR | Carolyn O Burns | — | UHC-64387-22 | 8647143924 | 7945 Forest Ave, Jacksonville, FL, 32288 | 0.80 | Name re-casedDate of birth missingPhone reformattedMember ID reformatted |
| ENR-104457 | ENR | Bruce G Cooper | — | UHC-60040-69 | 8924544397 | 3870 Broadway, Columbus, OH, 43291 | 0.80 | Name re-casedDate of birth missingMember ID reformattedPlaceholder values cleared |
| ENR-137868 | ENR | Teresa P Ramos | — | UHC-65278-62 | 7627983861 | 5696 Sunset Blvd, Las Vegas, NV, 89186 | 0.80 | Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared |
| ENR-123914 | ENR | Margaret Q Bishop | — | UHC-17308-48 | 8076132892 | 153 Main St, Mesa, AZ, 85235 | 0.80 | Date of birth missingMember ID reformattedWhitespace trimmedPlaceholder values cleared |
| ENR-106217 | ENR | Frnces Richardson | — | UHC-93602-77 | 4473830748 | 9785 Elm St, Orlando, FL, 32877 | 0.80 | Name re-casedDate of birth missingPlan code upper-casedWhitespace trimmed |
| ENR-113509 | ENR | Judith E Park | — | UHC-26411-53 | 2079862157 | — | 0.80 | Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared |
| ENR-142532 | ENR | Jeremy Z Murphy | — | UHC-74188-97 | 6127206749 | 2694 Ocean Ave, Miami, FL, 33148 | 0.80 | Date of birth missingCity re-casedWhitespace trimmedPlaceholder values cleared |
| ENR-123875 | ENR | Katherine A Rodriguez | — | UHC-60482-17 | 4708167449 | 9607 Camelback Rd, Eden Prairie, MN, 55394 | 0.80 | Name re-casedDate of birth missingCity re-casedWhitespace trimmed |
| ENR-134419 | ENR | Bryan Y Bradley | — | UHC-56034-71 | 2126093209 | 5040 Oak St, Miami, FL, 33161 | 0.80 | Name re-casedDate of birth missingMember ID reformattedWhitespace trimmed |
| ENR-131911 | ENR | Jerry A Edwards | — | UHC-51204-16 | 8338180022 | 922 Union St, Atlanta, GA, 30387 | 0.80 | Date of birth missingMember ID reformattedCity re-casedWhitespace trimmed |
| ENR-106233 | ENR | Brandon M Garrett | — | UHC-89215-09 | 7403791532 | 8946 Pine Dr, Denver, CO, 80231 | 0.80 | Name re-casedDate of birth missingCity re-casedPlaceholder values cleared |
| ENR-127543 | ENR | Camila O Reies | — | UHC-66882-65 | 5427601646 | 5782 Forest Ave, Tucson, AZ, 85762 | 0.80 | Name re-casedDate of birth missingPhone reformattedState code upper-cased |
| ENR-108747 | ENR | Jacqueline Nunez | — | UHC-70312-06 | 4592746367 | 2269 Sage Ct, Glendale, AZ, 85342 | 0.80 | Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared |
| ENR-130733 | ENR | Vincent Perry | — | UHC-67325-82 | 3627419856 | 7903 Ocean Ave, Mesa, AZ, 85217 | 0.82 | Date of birth missingPhone reformattedWhitespace trimmed |
| ENR-127656 | ENR | Brandon Gilbert | — | UHC-47987-53 | 6393887358 | 5070 Highland Ave, Phoenix, AZ, 85093 | 0.82 | Name re-casedDate of birth missingPhone reformatted |
| ENR-132622 | ENR | Vincent A Yang | — | UHC-62889-52 | 5988752721 | 6664 Hillcrest Rd, Columbus, OH, 43261 | 0.82 | Date of birth missingPhone reformattedEmail lower-cased |
| ENR-127016 | ENR | John Hill | — | UHC-16787-11 | 2995697305 | 4035 Ocean Ave, Denver, CO, 80238 | 0.82 | Name re-casedDate of birth missingWhitespace trimmed |
| ENR-119364 | ENR | Keith B Santos | — | UHC-87016-61 | 9236565752 | 153 Ridge Rd, Chandler, AZ, 85288 | 0.82 | Name re-casedDate of birth missingWhitespace trimmed |
| ENR-141079 | ENR | Nicholas B Perkins | — | UHC-71520-80 | 4993429935 | 1304 Meadow Ln, Plano, TX, 75099 | 0.82 | Name re-casedDate of birth missingEmail lower-cased |
| ENR-119770 | ENR | Judith U Owens | — | UHC-67070-87 | 2105906088 | — | 0.82 | Date of birth missingPhone reformattedPlaceholder values cleared |
| ENR-138127 | ENR | Mariana D Williamson | — | UHC-94555-31 | — | 4594 Main St, Denver, CO, 80267 | 0.82 | Date of birth missingWhitespace trimmedPlaceholder values cleared |
| ENR-118038 | ENR | Nicole Fisher | — | UHC-63867-60 | 3463444500 | 7671 Palm Dr, Tucson, AZ, 85793 | 0.82 | Date of birth missingPhone reformattedWhitespace trimmed |
| ENR-124002 | ENR | Dylan A Duncan | — | UHC-95456-57 | 3919571854 | — | 0.82 | Date of birth missingWhitespace trimmedPlaceholder values cleared |
| ENR-142195 | ENR | Carlos U Franklin | — | UHC-62891-95 | 7884487667 | 9563 Highland Ave, Jacksonville, FL, 32262 | 0.82 | Date of birth missingPhone reformattedPlaceholder values cleared |
| ENR-139227 | ENR | Mei Austin | — | UHC-55018-14 | 2655043622 | 4112 Indian School Rd, Chandler, AZ, 85268 | 0.82 | Name re-casedDate of birth missingWhitespace trimmed |
| ENR-125327 | ENR | Elijah Williamson | — | UHC-64784-94 | 5394225896 | 3111 Forest Ave, San Diego, CA, 92121 | 0.82 | Date of birth missingPhone reformattedWhitespace trimmed |
| ENR-113272 | ENR | Virginia Mason | — | UHC-15433-81 | 5815439419 | 8824 Indian School Rd, Atlanta, GA, 30306 | 0.82 | Date of birth missingPhone reformattedCity re-cased |
| ENR-123958 | ENR | Walter H Castillo | — | UHC-76016-86 | 2759980106 | 9338 Sage Ct, Columbus, OH, 43227 | 0.82 | Date of birth missingPhone reformattedCity re-cased |
| ENR-110969 | ENR | Debra S Guerrero | — | UHC-79292-33 | 4658006169 | 6541 Willow Ct, Plano, TX, 75018 | 0.82 | Name re-casedDate of birth missingPhone reformatted |
| ENR-141207 | ENR | Albert Howarrd | — | UHC-92633-37 | 2426438010 | 6203 Park Pl, Gilbert, AZ, 85222 | 0.82 | Name re-casedDate of birth missingPhone reformatted |
| ENR-135105 | ENR | Raymond B Vargas | — | UHC-85125-76 | 6504315259 | 9088 River Rd, Houston, TX, 77017 | 0.82 | Date of birth missingPhone reformattedPlaceholder values cleared |
| ENR-110708 | ENR | Alexander F Ortega | — | UHC-31229-34 | 5635909719 | 3118 Palm Dr, Sacramento, CA, 95830 | 0.82 | Date of birth missingPhone reformattedPlaceholder values cleared |
| ENR-142069 | ENR | Nicholas Hill | — | UHC-19819-24 | 5237625924 | 7755 Canyon Rd, Los Angeles, CA, 90089 | 0.82 | Date of birth missingMember ID reformattedWhitespace trimmed |
| ENR-119962 | ENR | Heather C Bailey | — | UHC-26075-27 | 5539586838 | — | 0.82 | Name re-casedDate of birth missingPhone reformatted |
| ENR-115322 | ENR | Brenda Y Montgomery | — | UHC-06242-21 | 2159996590 | 8095 Grand Ave, Los Angeles, CA, 90071 | 0.84 | Date of birth missingPhone reformatted |
| ENR-132171 | ENR | Jack U Austin | — | UHC-01081-09 | 3449547624 | 6937 Union St, Orlando, FL, 32834 | 0.84 | Date of birth missingWhitespace trimmed |
| ENR-125318 | ENR | Nancy Evans | — | UHC-67038-95 | — | 180 Forest Ave, Orlando, FL, 32825 | 0.84 | Date of birth missingPlaceholder values cleared |
| ENR-143019 | ENR | Julie Ross | — | UHC-35911-86 | 3829562824 | 7517 Meadow Ln, Chandler, AZ, 85280 | 0.84 | Date of birth missingWhitespace trimmed |
| ENR-129430 | ENR | Shiley U Baker | — | UHC-45715-13 | — | 2489 Lake View Rd, Tucson, AZ, 85782 | 0.84 | Date of birth missingPlaceholder values cleared |
| ENR-139859 | ENR | Frances Rice | — | UHC-56562-77 | 3756557059 | 817 Washington St, Las Vegas, NV, 89154 | 0.84 | Name re-casedDate of birth missing |
| ENR-109821 | ENR | Mateo Pierce | — | UHC-17328-37 | 2404505214 | 7217 Lincoln Way, Los Angeles, CA, 90012 | 0.84 | Date of birth missingPhone reformatted |
| ENR-140848 | ENR | Amber P Herrera | — | UHC-91429-67 | 9124045238 | 7215 Mesa Dr, Jacksonville, FL, 32259 | 0.84 | Date of birth missingPhone reformatted |
| ENR-127095 | ENR | Frances S Sanchez | — | UHC-05351-57 | 7467049493 | 7524 Broadway, Sacramento, CA, 95859 | 0.84 | Name re-casedDate of birth missing |
| ENR-115801 | ENR | Jesse N Pena | — | UHC-04366-25 | 6542340728 | 2100 Jefferson Ave, Charlotte, NC, 28220 | 0.84 | Date of birth missingPhone reformatted |
| ENR-125722 | ENR | Julia D Spencer | — | UHC-09111-93 | 9802434347 | 8863 Meadow Ln, Dallas, TX, 75296 | 0.84 | Date of birth missingPhone reformatted |
| ENR-120323 | ENR | Angela J Castillo | — | UHC-62876-52 | 5924123690 | 5311 Central Ave, Nashville, TN, 37223 | 0.84 | Name re-casedDate of birth missing |
| ENR-101959 | ENR | Dorothy K Ray | — | — | 9869724173 | 802 Church St, San Antonio, TX, 78250 | 0.86 | Date of birth missing |
| ENR-128796 | ENR | Katherine P Hamilton | — | UHC-73729-70 | 3095174131 | 10 Mountain View Dr, Columbus, OH, 43237 | 0.86 | Date of birth missing |