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-140092 | ENR | Sandra Q White | 2005-05-03 | UHC-13421-40 | 9485449274 | 2142 Indian School Rd, Atlanta, GA, 30380 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-106742 | ENR | James Henderson | 1975-12-19 | UHC-00613-90 | 4786508381 | 6458 Meadow Ln # 469, Glendale, AZ, 85305 | 0.48 | Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+4 more |
| ENR-107472 | ENR | Brandon K Phillips | 1981-09-27 | UHC-77750-57 | 2928138521 | 5208 Pine Dr, Houston, TX, 77061 | 0.48 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-114362 | ENR | Christine H Black | 1998-05-15 | UHC-98661-87 | 3202571623 | 6515 Central Ave, Gilbert, AZ, 85223 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-102545 | ENR | Omar X Dixon | 1973-07-09 | UHC-94376-27 | 5108418557 | 636 Meadow Ln Apt 29, Tempe, AZ, 85280 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-132602 | ENR | Sara Davis | 1977-04-06 | UHC-11295-01 | 3144887525 | 8848 Willow Ct Apt 18, Las Vegas, NV, 89172 | 0.48 | Name re-casedPhone reformattedSSN last four extractedUnit split from street+4 more |
| ENR-132603 | ENR | Sara Davis | 1977-04-06 | UHC-11295-01 | 3144887525 | 8848 Willow Ct Apt 18, Las Vegas, NV, 89172 | 0.48 | Name re-casedPhone reformattedSSN last four extractedUnit split from street+4 more |
| ENR-113375 | ENR | Carol S Kim | 2007-10-18 | UHC-04642-40 | 3627918851 | 565 Meadow Ln # 962, Tucson, AZ, 85728 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-139180 | ENR | Julie Pena | 1994-12-14 | UHC-64751-19 | 8296431839 | 9289 Ridge Rd, Atlanta, GA, 30309 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-125374 | ENR | Richard Stevens | 1971-02-15 | UHC-64127-22 | — | 885 Indian School Rd, Houston, TX, 77072 | 0.48 | Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+4 more |
| ENR-111527 | ENR | Carolyn Bryant | 1990-06-16 | UHC-09342-45 | 7735473261 | 9240 Park Pl Apt 17, San Diego, CA | 0.48 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-100365 | ENR | Angela Bryant | 1938-04-06 | UHC-22165-57 | 6315043114 | 9768 Spring St, Mesa, AZ | 0.48 | Name re-casedPhone reformattedMember ID reformattedState name converted to code+4 more |
| ENR-119730 | ENR | Anthony Wilson | 1939-06-01 | UHC-13776-69 | 9828141368 | 2727 Ridge Rd, Fresno, CA, 93778 | 0.48 | Date of birth reformattedPhone reformattedMember ID reformattedSSN last four extracted+4 more |
| ENR-121719 | ENR | Russell C Cunningham | 1965-09-03 | UHC-36791-67 | 9266008714 | 4129 Valley View Dr, Miami, FL | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-141308 | ENR | Roy O Crawford | 1994-04-21 | UHC-94638-47 | 2384542823 | 7157 Valley View Dr, Minneapolis, MN, 55433 | 0.48 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-103954 | ENR | Hannah Q Peterson | — | UHC-35783-07 | 7797108154 | 3908 Pine Dr, Jacksonville, FL, 32263 | 0.48 | Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more |
| ENR-128134 | ENR | Frances O Rojas | 1985-05-01 | UHC-82208-39 | 7203371205 | 270 Willow Ct, Orlando, FL | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-135749 | ENR | Randy T Burton | 1938-03-02 | UHC-32006-03 | 3015630417 | 8838 Market St, Fresno, CA | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-136852 | ENR | Daid R Hawkins | 1982-08-05 | UHC-77123-33 | 5873923847 | 4607 Jefferson Ave, Fresno, CA, 93781 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-127467 | ENR | Grace N Patterson | 1983-10-22 | UHC-65183-74 | 9579054803 | 2433 Forest Ave, Jacksonville, FL, 32214 | 0.48 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-141811 | ENR | Arthur I Simpson | 1989-03-06 | UHC-42939-64 | 9104017402 | 7971 Indian School Rd, Dallas, TX, 75222 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-122950 | ENR | Kimberly X Mejia | 1985-02-21 | UHC-36570-17 | 6294855846 | 5419 Park Pl # 913, Seattle, WA, 98113 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-128912 | ENR | Terry N Lawson | 1974-04-04 | UHC-03302-69 | 4487968474 | 3688 Hillcrest Rd, Eden Prairie, MN, 55383 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-110727 | ENR | Charlotte Simmons | 1961-05-14 | UHC-98486-13 | 7835153357 | 1245 Ridge Rd # 702, Fresno, CA, 93702 | 0.48 | Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more |
| ENR-102075 | ENR | Nancy E Harper | 1959-06-26 | — | 5077890554 | 7991 Apache Blvd, Scottsdale, AZ, 85223 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-108342 | ENR | Doris Perry | 1995-06-20 | UHC-81544-25 | 5294842209 | 9693 Lincoln Way, Atlanta, GA, 30330 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-137993 | ENR | Harold Hall | — | UHC-71225-35 | 8363390651 | 4518 Union St, Dallas, TX, 75298 | 0.48 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-125049 | ENR | Jack Mills | 1971-05-18 | UHC-22367-74 | 9017854312 | 9097 Pine Dr, Dallas, TX, 75276 | 0.48 | Name split from “Last, First”Phone reformattedMember ID reformattedSSN last four extracted+4 more |
| ENR-133181 | ENR | Betty I Ortega | 1952-05-09 | UHC-77561-91 | 5036111315 | 4966 Highland Ave, Dallas, TX, 75208 | 0.48 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-139642 | ENR | Teresa A Anderson | 1956-03-17 | UHC-79731-73 | 5457376239 | 3024 Meadow Ln # 952, Seattle, WA, 98117 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-107241 | ENR | Rachel Wheeler | 1968-04-06 | UHC-03328-76 | 7983935087 | 3159 River Rd Apt 32, Chandler, AZ | 0.48 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-123492 | ENR | Andrea Hanson | 1971-11-09 | UHC-89587-64 | 5337465441 | 8510 Camelback Rd, Plano, TX, 75012 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-140327 | ENR | Amanda Riley | 1944-02-03 | UHC-25526-24 | 9844242836 | 3827 Ocean Ave, Plano, TX | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-113251 | ENR | Willie G Espinoza | — | UHC-99098-64 | 3943371897 | 6665 Harbor Blvd, Chandler, AZ, 85275 | 0.48 | Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more |
| ENR-109964 | ENR | Debra Burke | 1991-04-23 | UHC-64755-30 | 8818232393 | 3712 Bayshore Dr, Tampa, FL, 33619 | 0.48 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-103082 | ENR | Santiago L Green | — | UHC-37513-76 | 8392941285 | 7039 Church St, Los Angeles, CA | 0.48 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| ENR-120361 | ENR | Frances V Roes | 1991-03-14 | UHC-35281-32 | 3646072891 | 7938 Church St, Gilbert, AZ, 85260 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-118555 | ENR | Betty K Larson | 1944-06-06 | UHC-50271-71 | 6958636190 | 304 Baseline Rd, Orlando, FL, 32814 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-100045 | ENR | Ruth J Price | 1978-12-03 | UHC-48375-18 | — | 5458 Canyon Rd, Seattle, WA, 98144 | 0.48 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-106399 | ENR | Sofai R Phillips | 1978-12-26 | UHC-88188-92 | 7139869065 | 6707 Camelback Rd, Chandler, AZ | 0.48 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-105416 | ENR | Betty Padilla | 1979-09-12 | UHC-00259-16 | — | 7491 Canyon Rd, Tampa, FL, 33609 | 0.48 | Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more |
| ENR-138156 | ENR | Luis P Powell | — | UHC-83291-95 | 4008420868 | 7966 Ridge Rd, San Diego, CA, 92115 | 0.48 | Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+4 more |
| ENR-124854 | ENR | Ethan T Mitchell | 1954-08-17 | UHC-64818-21 | 2938524806 | 4533 Valley View Dr, Atlanta, GA, 30372 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-141950 | ENR | Olivia Morales | 1966-11-08 | UHC-35280-08 | 9059605359 | 2325 Forest Ave, San Diego, CA, 92148 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-127103 | ENR | Benjamin B Weaver | 1996-08-10 | UHC-20232-99 | — | 3047 Willow Ct, Columbus, OH, 43204 | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-112267 | ENR | Jason K Gordon | 1952-06-05 | UHC-52450-28 | 2277306812 | 8596 Desert Sky Blvd, Plano, TX | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-101433 | ENR | Jacqueline E Kelley | 1980-06-05 | UHC-56860-91 | 4042030074 | 4235 Highland Ave, Houston, TX, 77014 | 0.48 | Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-131083 | ENR | Brittany H Robertson | 1974-04-20 | UHC-97321-73 | 2553497492 | 4828 Union St, Sacramento, CA, 95893 | 0.48 | Middle initial moved out of first nameMember ID reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-138746 | ENR | Mei Robertson | 1987-02-22 | UHC-47647-46 | 7328625172 | 8987 Desert Sky Blvd, Jacksonville, FL, 32275 | 0.48 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-105437 | ENR | Peter Li | 1990-06-04 | UHC-75872-76 | 2692985473 | 4194 Washington St, Minneapolis, MN, 55440 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |