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-114163 | ENR | Keneth G Wells | 1941-09-05 | UHC-28757-58 | — | 6601 Highland Ave, Chandler, AZ, 85284 | 0.48 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |
| ENR-106792 | ENR | Marilyn Aguilar | 1977-06-02 | UHC-97377-90 | 2763483797 | 1454 Jefferson Ave # 544, Phoenix, AZ, 85025 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-117524 | ENR | Jeremy Romero | 1954-11-14 | UHC-73018-04 | 3467871225 | 4322 Bayshore Dr, Sacramento, CA, 95834 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-122063 | ENR | Michelle P Reed | 1962-08-23 | UHC-33270-80 | 6506369202 | 8956 Central Ave, San Diego, CA, 92173 | 0.48 | Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+4 more |
| ENR-121803 | ENR | Bruce G Cox | 1991-04-12 | UHC-19418-05 | 7135948119 | 1550 Harbor Blvd, Houston, TX, 77067 | 0.48 | Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more |
| ENR-138757 | ENR | Arthur Vassquez | 2002-12-15 | UHC-91248-73 | — | 2169 Baseline Rd, Mesa, AZ, 85271 | 0.48 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |
| ENR-113526 | ENR | Angela J Foster | 1989-05-22 | UHC-87261-18 | 6136855579 | 5359 Baseline Rd, San Antonio, TX, 78284 | 0.48 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-142182 | ENR | Raymond Richardson | 1987-01-13 | UHC-30484-31 | 4489062347 | 5745 Pine Dr, Gilbert, AZ, 85231 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-127017 | ENR | Soofia Peters | 2001-05-16 | UHC-73843-80 | 7665877977 | 4433 Camelback Rd Apt 33, Glendale, AZ, 85384 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-108861 | ENR | Eddward Delgado | 1986-01-16 | UHC-98565-10 | 4453176477 | 8051 Market St, Atlanta, GA, 30380 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-108860 | ENR | Eddward Delgado | 1986-01-16 | UHC-98565-10 | 4453176477 | 8051 Market St, Atlanta, GA, 30380 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-102221 | ENR | Heather Fisher | 1990-08-26 | UHC-46371-25 | 3853406694 | 6233 River Rd Apt 22, Miami, FL, 33137 | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-120426 | ENR | Joshua Gardner | 1941-01-10 | UHC-87871-01 | 2466967449 | 8336 Bayshore Dr, Tucson, AZ, 85774 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-123105 | ENR | Jose S Ryan | 1948-06-08 | UHC-19407-98 | — | 5976 Market St, Gilbert, AZ, 85281 | 0.48 | Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+4 more |
| ENR-124981 | ENR | Ann Martinez | 2006-09-21 | UHC-19690-85 | 2039082871 | 3769 Highland Ave Apt 39, Houston, TX, 77030 | 0.48 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-138017 | ENR | George Berry | 1987-02-04 | UHC-94256-16 | 9482191848 | 4676 Ocean Ave, Chandler, AZ, 85299 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-133603 | ENR | Betty S Lucas | 1958-05-20 | UHC-66849-38 | 2923740103 | 6439 Grand Ave, Los Angeles, CA | 0.48 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more |
| ENR-138305 | ENR | Emma R Black | 1975-09-27 | UHC-75057-97 | 3044807996 | 9463 Sage Ct, Los Angeles, CA, 90001 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-114106 | ENR | Ashley N Hayes | 1970-03-20 | UHC-08753-09 | 4842802916 | 2850 Valley View Dr Apt 38, Chandler, AZ | 0.48 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-133958 | ENR | Brandon U Hart | 1982-04-10 | UHC-55080-97 | 6422779496 | 2303 Indian School Rd Apt 33, Columbus, OH, 43218 | 0.48 | Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more |
| ENR-128167 | ENR | Mariana Nguyen | 1945-08-06 | UHC-21698-02 | 6836994159 | 9516 Ocean Ave Apt 18, Chandler, AZ, 85250 | 0.48 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-140219 | ENR | Edward Hicks | 1989-04-06 | UHC-50339-17 | 6545484363 | 3192 Mesa Dr, Columbus, OH | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-112207 | ENR | Brenda Coleman | 1992-11-18 | UHC-20384-71 | 6625946961 | 7077 Sunset Blvd, Denver, CO, 80293 | 0.48 | Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-132115 | ENR | Dennis Ruiz | — | UHC-75844-12 | 4304760934 | 2378 Valley View Dr, Dallas, TX | 0.48 | Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-109889 | ENR | Abby Kelley | 1987-10-27 | UHC-49343-30 | 2325778514 | 3540 Harbor Blvd Apt 23, Seattle, WA, 98172 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-122862 | ENR | Sean F Price | 1952-05-18 | — | 6433590619 | 469 Apache Blvd, Chandler, AZ, 85296 | 0.48 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more |
| ENR-141238 | ENR | Christine Z Dixon | 1964-08-18 | UHC-34283-65 | 8512489796 | 361 Mountain View Dr, San Antonio, TX, 78240 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-141386 | ENR | Bran O Fox | 1940-05-21 | UHC-71539-25 | 5779045222 | 4990 Highland Ave, Denver, CO, 80230 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-122010 | ENR | Virginia Lynch | 1988-09-10 | UHC-88578-38 | — | 9775 Willow Ct, San Antonio, TX | 0.48 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |
| ENR-122446 | ENR | Lauren C Montgomery | 1983-02-01 | UHC-75031-08 | 6044000336 | 3614 Canyon Rd, Fresno, CA | 0.48 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more |
| ENR-135950 | ENR | Martha I Campbell | 1970-12-14 | UHC-78455-90 | 4176077919 | 3970 Harbor Blvd, Gilbert, AZ, 85201 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-140499 | ENR | Ana E King | — | UHC-25436-16 | 3803949632 | 5915 Park Pl # 766, Orlando, FL, 32850 | 0.48 | Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-137392 | ENR | Sam Pierce | — | UHC-33483-59 | 6859217268 | 4847 Valley View Dr, Houston, TX, 77001 | 0.48 | Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-138534 | ENR | Nancy Sims | 1976-06-23 | UHC-57979-93 | 7655250239 | 9620 Hillcrest Rd, Atlanta, GA | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-115969 | ENR | Stephen Heyes | 1954-03-20 | UHC-21260-70 | 6433471467 | 3539 Union St, Scottsdale, AZ, 85203 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-103132 | ENR | Dennise C Perkins | 1971-11-25 | UHC-55403-36 | 8638741759 | 5125 Oak St, Glendale, AZ | 0.48 | Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-120358 | ENR | Noah D Bryant | 1949-03-15 | UHC-89912-12 | — | 8174 Pine Dr, Jacksonville, FL, 32262 | 0.48 | Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+4 more |
| ENR-113088 | ENR | Russell Marquez | 1962-03-11 | UHC-20668-29 | — | 2146 Mesa Dr, Scottsdale, AZ, 85285 | 0.48 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |
| ENR-113139 | ENR | Luis U Bell | 1956-03-23 | UHC-85259-84 | 6519571616 | 9061 Meadow Ln, Atlanta, GA, 30300 | 0.48 | Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-109990 | ENR | Gary Day | 1974-05-27 | UHC-86503-99 | 2048197147 | 5743 Hillcrest Rd # 228, Denver, CO, 80266 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-132941 | ENR | Paul Q Porter | 1941-07-27 | UHC-28456-84 | 2483459516 | 4240 Church St Apt 31, Plano, TX, 75025 | 0.48 | Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-110087 | ENR | Patrick Morris | 1992-10-26 | UHC-18755-45 | 5335151382 | 3131 Palm Dr, Eden Prairie, MN, 55381 | 0.48 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-108563 | ENR | Kevin Rice | 1953-10-21 | UHC-17571-21 | 7408127885 | 7401 Pine Dr, Fresno, CA | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-118702 | ENR | Ahmed U Ortiz | 1975-04-20 | UHC-09856-93 | 4328861956 | 7257 Desert Sky Blvd, Glendale, AZ | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-133658 | ENR | Camila Lynch | 1975-04-02 | UHC-24868-81 | 6426610686 | 7308 Jefferson Ave, Jacksonville, FL | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-120589 | ENR | Fatima D Schmidt | 1958-12-15 | UHC-18800-64 | — | 8945 Jefferson Ave, Glendale, AZ, 85368 | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more |
| ENR-118482 | ENR | Christopher E Evans | 1960-05-09 | UHC-90954-06 | 5362182375 | 6340 Cedar Ln, San Diego, CA | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-141122 | ENR | Angela Murray | 1987-06-24 | UHC-29472-03 | 4487160206 | 6807 Cedar Ln, Austin, TX, 78788 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more |
| ENR-116829 | ENR | Sentiago A Wong | 1969-01-19 | UHC-35346-77 | — | 4049 Washington St, Houston, TX | 0.48 | Middle initial moved out of first nameStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-136471 | ENR | Teresa Z Coleman | 2005-06-26 | UHC-01517-27 | 8149449845 | 5737 Maple Ave # 982, Phoenix, AZ, 85029 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |