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-126519 | ENR | Julia I Snyder | 1946-10-05 | UHC-96900-09 | 7862064638 | 512 Willow Ct # 648, Sacramento, CA, 95816 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-111238 | ENR | Gabriel Q Vazquez | 1954-02-21 | UHC-21481-63 | 4397280630 | 529 Baseline Rd, Austin, TX, 78780 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-107834 | ENR | Eugene Carlson | 1993-08-18 | UHC-73643-65 | 4763169237 | 7646 Ridge Rd # 888, Phoenix, AZ, 85051 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-116156 | ENR | Terry Elliott | 1980-05-20 | UHC-43012-07 | 3874921011 | 6936 Willow Ct, Tempe, AZ, 85260 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-131060 | ENR | Justin W Garrett | 1988-09-04 | — | 7485102147 | 1158 River Rd, Tampa, FL, 33677 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-130745 | ENR | Rebecca S Butler | 1972-12-26 | UHC-82111-65 | — | 6189 Desert Sky Blvd, Gilbert, AZ | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-139889 | ENR | Christina Mills | 1968-09-02 | UHC-64877-91 | 7227301526 | 2856 Grand Ave, Fresno, CA, 93737 | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-136898 | ENR | Douglas F Li | — | UHC-11021-38 | 3665457281 | 7472 Pine Dr, Nashville, TN, 37291 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-127354 | ENR | Mariana U Jackson | 1992-11-20 | UHC-36939-96 | 4996310529 | 8346 Palm Dr, Austin, TX, 78738 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-116327 | ENR | Austin Robertson | 1968-11-08 | UHC-21088-14 | 6407955327 | 169 Valley View Dr, Gilbert, AZ, 85284 | 0.60 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-101816 | ENR | Maria Jones | 1986-03-13 | UHC-87021-76 | 4369810040 | 9532 Elm St # 575, Charlotte, NC, 28268 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-140866 | ENR | Lawrence C Berry | 1995-06-24 | UHC-98898-79 | 4672041352 | 5911 Lake View Rd # 254, Seattle, WA, 98198 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-109090 | ENR | David Lee | 1962-01-02 | UHC-73882-26 | 5885345140 | 997 Desert Sky Blvd, Mesa, AZ | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-102879 | ENR | Andrew Anderson | 2002-11-16 | UHC-32112-15 | 5227422366 | 7051 Valley View Dr, Phoenix, AZ | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-123481 | ENR | Justin A Turner | 1995-11-12 | UHC-52766-67 | 4686196634 | 3538 Indian School Rd, Miami, FL, 33160 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-135701 | ENR | Teresa V Sims | 1981-01-25 | UHC-68801-10 | 3847185091 | 9302 Meadow Ln, Houston, TX, 77045 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-122324 | ENR | Jose Q Williamson | 1947-04-24 | UHC-42690-59 | 5177243856 | 6243 Ridge Rd, Tucson, AZ, 85751 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-116341 | ENR | Bruce Yang | 1955-02-10 | UHC-72059-81 | — | 578 Willow Ct Apt 1, Miami, FL, 33193 | 0.60 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-124257 | ENR | Aaron Bell | 1965-07-04 | UHC-16001-92 | 5996254481 | 5517 Desert Sky Blvd # 635, Miami, FL, 33162 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-132376 | ENR | Scott I Soto | 2005-09-04 | UHC-92231-93 | 3664455284 | 9832 Sage Ct, Houston, TX | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-139260 | ENR | Bruce Garza | 1948-11-15 | UHC-00733-12 | 7333245407 | 3302 Jefferson Ave, Plano, TX | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-120999 | ENR | Daniel K Ramirez | 1992-09-15 | UHC-57427-66 | 6727715403 | 815 Sunset Blvd, Miami, FL, 33128 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-102767 | ENR | Luis R Freeman | 1981-07-01 | UHC-54061-22 | 4378136234 | 147 Central Ave, Tucson, AZ, 85797 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-141272 | ENR | Wayne Lopez | 2001-12-26 | UHC-76174-84 | 6396090321 | 8070 Highland Ave, Dallas, TX, 75296 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-120957 | ENR | Juhn E Ramos | 1941-03-16 | UHC-03305-70 | 4482304692 | 8029 Park Pl, San Antonio, TX, 78277 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| ENR-126743 | ENR | Alexander A Oliver | — | UHC-50971-06 | 9722061895 | 909 Valley View Dr, Houston, TX, 77030 | 0.60 | Date of birth missingPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-112922 | ENR | Danielle U Ryan | 1999-03-06 | UHC-83966-96 | 4269041568 | 7283 Ocean Ave, San Diego, CA | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-122559 | ENR | Christine F Davis | 1968-04-16 | UHC-61321-56 | 9487277411 | 5608 Lincoln Way, Dallas, TX, 75252 | 0.60 | Two-digit birth yearPhone reformattedCity re-casedState code upper-cased+4 more |
| ENR-119562 | ENR | Timothy Q Berry | 2007-12-24 | UHC-32504-88 | 6572168277 | 1940 Cedar Ln, Plano, TX, 75095 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-127837 | ENR | Heather Q Montgomery | 1968-06-17 | UHC-06795-87 | 2263930575 | 4552 Church St, Los Angeles, CA, 90047 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-133310 | ENR | Steven Rams | 1969-01-26 | UHC-53604-06 | 7312929098 | 1184 Hillcrest Rd, Sacramento, CA, 95863 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-139539 | ENR | Kyyle G Rivera | 2007-12-24 | UHC-99475-72 | 5918657063 | 8014 Central Ave, Atlanta, GA, 30341 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-105865 | ENR | Hannah Dunn | 1997-04-14 | UHC-06542-72 | 8167955693 | 7528 Willow Ct, Plano, TX, 75065 | 0.60 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more |
| ENR-130727 | ENR | Walter V Coleman | 1968-08-12 | UHC-12362-91 | — | 2052 River Rd, Los Angeles, CA | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-130209 | ENR | Ken V Nguyen | 1989-12-14 | UHC-88779-51 | 8144767892 | 8140 Palm Dr, Las Vegas, NV, 89149 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-115930 | ENR | Michael T Mills | 1943-11-05 | UHC-22066-20 | — | 5025 Highland Ave, Las Vegas, NV, 89191 | 0.60 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-123308 | ENR | Joan Kelley | 1998-02-01 | UHC-58059-63 | 3764787600 | 8796 Sage Ct, Minneapolis, MN, 55459 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-130913 | ENR | Nathhan E Knight | 2000-02-11 | UHC-02960-10 | 9477704749 | 431 Highland Ave, Dallas, TX, 75254 | 0.60 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-120829 | ENR | Arjun X Robinson | 2004-09-19 | UHC-13026-76 | 2095424717 | 7011 Forest Ave # 397, Tucson, AZ, 85718 | 0.60 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-132740 | ENR | Ashley Moore | 1966-04-16 | UHC-92997-42 | 2739035923 | 5502 River Rd, Nashville, TN, 37268 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-118849 | ENR | Luys A Jones | 2000-02-09 | UHC-29350-58 | 9748678233 | 5765 Bayshore Dr, Sacramento, CA, 95822 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-122014 | ENR | Aisha P Biley | 1993-03-09 | UHC-32930-20 | 6723969448 | 3532 Highland Ave, Austin, TX | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-102631 | ENR | Walter Ortega | 1960-11-18 | UHC-32319-15 | 7589864166 | 3191 Elm St # 238, San Antonio, TX, 78296 | 0.60 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-138516 | ENR | Beverly Ortega | 1950-07-16 | UHC-09931-26 | 5759757794 | 830 Bayshore Dr, Dallas, TX, 75209 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-106123 | ENR | Jesse F Fowler | 1998-12-11 | UHC-13704-87 | 5134605829 | 4715 Sage Ct, Miami, FL, 33199 | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-127515 | ENR | Gary P Garrett | — | UHC-95391-30 | 3285024835 | 9326 Highland Ave, Charlotte, NC, 28207 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-125359 | ENR | Joseph Moore | 1990-05-26 | UHC-14260-60 | 2924703851 | 5602 Mesa Dr, Tucson, AZ, 85740 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-118223 | ENR | Nancy X Murray | 1976-09-03 | UHC-72199-70 | 6068535308 | 2773 Maple Ave, Scottsdale, AZ, 85243 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-112951 | ENR | Jose H Jackson | 1954-11-11 | UHC-92950-03 | 5845062029 | 338 Indian School Rd, Mesa, AZ, 85221 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-140645 | ENR | Brandon H Fields | 1969-09-11 | UHC-95171-29 | — | 2541 Willow Ct, Denver, CO, 80298 | 0.60 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |