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-103468 | ENR | Samantha T West | 1943-12-24 | UHC-38587-30 | 5536641665 | 303 Cedar Ln, Dallas, TX, 75299 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| ENR-111277 | ENR | Yuki R Gibson | 2005-09-19 | UHC-16421-67 | 3084509405 | 4005 Main St, Glendale, AZ, 85346 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-122889 | ENR | Joyce Medina | 1943-09-18 | UHC-17090-46 | 7676833062 | 1257 Central Ave, San Diego, CA, 92137 | 0.60 | Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased+4 more |
| ENR-103356 | ENR | Ann Z Shaw | 1970-06-27 | UHC-79774-48 | 3556298164 | 9422 Grand Ave, Scottsdale, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-140822 | ENR | Gary Daniels | 2007-01-19 | UHC-24336-40 | 4364137189 | 2076 Lincoln Way, Nashville, TN, 37261 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-124585 | ENR | Heather JJunk | 1979-10-22 | UHC-85304-14 | 3157239515 | 9293 Apache Blvd, Chandler, AZ, 85240 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-100792 | ENR | Isabella A Herrera | 1994-01-06 | UHC-23502-35 | — | 3105 Highland Ave, San Antonio, TX, 78207 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-107694 | ENR | Samuel U Oliver | — | UHC-97217-14 | 9693933028 | 1197 Valley View Dr, Los Angeles, CA, 90090 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-108110 | ENR | Camila M Webb | 1977-10-18 | UHC-57634-72 | 8864779404 | 4854 Bayshore Dr, Scottsdale, AZ, 85206 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-114849 | ENR | Debbie Q Cooper | 1980-01-04 | UHC-66987-74 | 6489207149 | 5581 Central Ave, San Antonio, TX, 78203 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-105823 | ENR | Noah G Vasquez | 1962-02-27 | UHC-16757-75 | 3819455628 | 8356 Camelback Rd, San Antonio, TX, 78224 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-131495 | ENR | Nathan T Myers | 1951-12-17 | UHC-34928-07 | — | 2856 Spring St, Charlotte, NC, 28297 | 0.60 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |
| ENR-101235 | ENR | Carolyn Lewis | 1996-08-27 | UHC-83255-14 | 7738625543 | 5024 Spring St, Charlotte, NC, 28254 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-105252 | ENR | Henry R Mills | 1943-07-24 | UHC-00734-23 | 5723372649 | 4169 Church St, Tempe, AZ, 85222 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-118500 | ENR | Hannah S Robertson | 1957-12-15 | UHC-70400-39 | 7626412917 | 6030 Hillcrest Rd, Houston, TX, 77047 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-125846 | ENR | Timothy S Tran | 1968-02-05 | UHC-74571-52 | 2228275548 | 1174 Canyon Rd, Las Vegas, NV | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-135117 | ENR | Katherine Brant | 1946-11-11 | UHC-82369-83 | 9557593856 | 7987 Apache Blvd Apt 18, Phoenix, AZ, 85032 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-124778 | ENR | Robert C Dean | 1949-03-03 | UHC-93553-41 | 8195638371 | 8653 Elm St, Chandler, AZ, 85280 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-102145 | ENR | Donna G Perez | — | UHC-15786-23 | 5403346902 | 8563 Palm Dr, Atlanta, GA, 30396 | 0.60 | Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-139015 | ENR | Lauren Harrison | 1939-06-04 | UHC-42762-07 | 5346917206 | 3981 Grand Ave, Tempe, AZ, 85253 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-133351 | ENR | Aaron Palmer | 2005-08-20 | UHC-08236-22 | 3215976906 | 9580 Indian School Rd, Scottsdale, AZ, 85208 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-104283 | ENR | Diego U Willis | 1976-12-04 | UHC-87330-63 | 3998853867 | 5065 Ocean Ave, Chandler, AZ, 85274 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| ENR-104284 | ENR | Diego U Willis | 1976-12-04 | UHC-87330-63 | 3998853867 | 5065 Ocean Ave, Chandler, AZ, 85274 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| ENR-133287 | ENR | Megan Ferguson | 1988-08-10 | UHC-02328-78 | — | 3570 Grand Ave, Seattle, WA, 98152 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-126669 | ENR | Sarah Hall | 1963-09-18 | UHC-42069-39 | 7335977930 | 7399 Park Pl, Gilbert, AZ, 85205 | 0.60 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-126668 | ENR | Sarah Hall | 1963-09-18 | UHC-42069-39 | 7335977930 | 7399 Park Pl, Gilbert, AZ, 85205 | 0.60 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-120338 | ENR | Helen X Bradley | 1983-08-18 | UHC-31370-36 | 7649095307 | 4064 Mesa Dr, Scottsdale, AZ, 85223 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-115928 | ENR | Judith Q Stephens | 1965-01-01 | UHC-37396-05 | 7492547758 | 250 Lincoln Way, Phoenix, AZ, 85034 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-137839 | ENR | Lucia B Watkins | 1984-02-13 | UHC-64281-09 | 3277331491 | 952 Bayshore Dr, Scottsdale, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-129807 | ENR | Joan Cunningham | 2006-11-14 | UHC-78634-64 | 3887130492 | 4473 Union St # 203, Tampa, FL, 33627 | 0.60 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-139885 | ENR | Maria R Greene | 1981-03-10 | UHC-79831-39 | — | 2309 Market St, Las Vegas, NV, 89167 | 0.60 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-106195 | ENR | Joseph R Obrien | 1978-10-10 | UHC-03406-45 | 6749279236 | 1682 Sage Ct, Orlando, FL, 32897 | 0.60 | Name split from “Last, First”Name re-casedPhone reformattedStreet suffix standardised+4 more |
| ENR-137128 | ENR | Mari Little | 1941-06-21 | UHC-24075-34 | 4209178852 | 1334 Harbor Blvd, Phoenix, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-120981 | ENR | Alexander B Marc | 1987-11-15 | UHC-89293-82 | 4999021320 | 1390 Valley View Dr, Tempe, AZ, 85294 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-141418 | ENR | Amanda O Li | 1967-03-22 | UHC-98440-07 | 4057045202 | 8177 Ridge Rd, Gilbert, AZ, 85282 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-107888 | ENR | Joseph M Lee | 1989-04-06 | UHC-71702-95 | 2192072779 | 1096 Desert Sky Blvd, Scottsdale, AZ, 85258 | 0.60 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-125005 | ENR | Douglas Scott | 1972-11-23 | UHC-87164-66 | 5747645660 | 4134 Jefferson Ave, Las Vegas, NV, 89168 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-138353 | ENR | Soofia J Alvarez | 1970-01-10 | UHC-12565-68 | 4097160451 | 3305 Mesa Dr, Orlando, FL | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-103501 | ENR | Lucia L Gonzales | 1955-04-17 | UHC-58807-87 | 3995271271 | 2783 Sage Ct, San Antonio, TX, 78241 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-134159 | ENR | Carol Jordan | 1984-07-07 | UHC-99700-18 | 2044010024 | 8464 Baseline Rd, Mesa, AZ, 85275 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-106445 | ENR | Kayla A Williamson | 2008-07-14 | UHC-28782-70 | 4432446373 | 9478 Jefferson Ave, Columbus, OH, 43221 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-141519 | ENR | Abigail I Ruiz | 1976-09-10 | UHC-10453-32 | 9563680218 | 5194 Lake View Rd, Miami, FL, 33132 | 0.60 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-102396 | ENR | Lucia Turner | 2001-01-12 | UHC-13056-72 | 5704951378 | 7359 Willow Ct, Charlotte, NC, 28240 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-136289 | ENR | Charlotte J Morgan | 2001-03-03 | UHC-53059-88 | 4269777010 | 3169 Canyon Rd, Denver, CO, 80242 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-120086 | ENR | Jackie Hanen | 1978-12-04 | — | — | 9569 Desert Sky Blvd, Nashville, TN, 37294 | 0.60 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |
| ENR-132681 | ENR | Karen James | 2001-11-21 | UHC-70063-36 | 3295971449 | 2189 Apache Blvd, Las Vegas, NV | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-123267 | ENR | Jack Meyer | 1996-06-12 | UHC-47355-03 | — | 8203 Mesa Dr, San Diego, CA, 92140 | 0.60 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |
| ENR-110517 | ENR | Beverly W Gonzales | 1944-03-03 | UHC-28012-85 | 3879371789 | 2540 Grand Ave, San Antonio, TX, 78225 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-112574 | ENR | Stephanie Henderson | 1999-04-19 | UHC-71447-86 | 4776563789 | 2267 Sage Ct, Sacramento, CA, 95811 | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-112575 | ENR | Stephanie Henderson | 1999-04-19 | UHC-71447-86 | 4776563789 | 2267 Sage Ct, Sacramento, CA, 95811 | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |