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-128931 | ENR | Janet Tran | 1986-08-20 | UHC-03218-96 | 6709017122 | 2658 Broadway, Phoenix, AZ, 85018 | 0.62 | Two-digit birth yearPhone reformattedAddress re-casedCity re-cased+3 more |
| ENR-132200 | ENR | Emma Carter | 1944-09-24 | UHC-03566-32 | 8224416865 | 2297 Elm St, San Diego, CA, 92117 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-129720 | ENR | Heather P Cook | 1973-01-10 | UHC-56657-20 | 2199415062 | 6040 Mountain View Dr, Tampa, FL, 33672 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-131846 | ENR | Joe Bishop | 1988-10-18 | UHC-08767-48 | 5279154620 | 6422 Harbor Blvd, Nashville, TN, 37273 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-102143 | ENR | Nicholas Long | 2005-07-10 | UHC-15445-08 | 2514724615 | 8095 Main St, Orlando, FL, 32801 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-106875 | ENR | Danielle Silva | 1965-11-19 | UHC-68389-91 | 3924190147 | 1052 Jefferson Ave, Phoenix, AZ | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-106311 | ENR | Ann Castro | 1960-02-13 | UHC-12437-59 | 3968111393 | 8739 Sunset Blvd # 811, Columbus, OH, 43215 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-133645 | ENR | Willie Richardson | 1974-11-11 | UHC-00108-35 | 6152421262 | 1339 Cedar Ln, Austin, TX, 78703 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-108093 | ENR | Carol J Allen | 1949-11-14 | UHC-29947-52 | 5098935303 | 6323 Elm St, Mesa, AZ, 85257 | 0.62 | Name re-casedPhone reformattedCity re-casedState name converted to code+3 more |
| ENR-106406 | ENR | Julia G Gardner | 1971-04-02 | UHC-75422-85 | 7507552172 | 4318 Park Pl, Tampa, FL | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-112687 | ENR | George D Hernandez | 1951-04-18 | UHC-03121-86 | 5543491226 | 5190 Hillcrest Rd # 802, Chandler, AZ, 85235 | 0.62 | Name re-casedPhone reformattedUnit split from streetCity re-cased+3 more |
| ENR-124518 | ENR | Russell Avarado | 1957-01-28 | UHC-65013-70 | 4015939360 | 8197 River Rd, Gilbert, AZ, 85250 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-142113 | ENR | Wliliam J Jordan | 1990-02-22 | UHC-70177-71 | 8013680090 | 1244 River Rd, Glendale, AZ, 85329 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-142114 | ENR | Wliliam J Jordan | 1990-02-22 | UHC-70177-71 | 8013680090 | 1244 River Rd, Glendale, AZ, 85329 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-136033 | ENR | Mari Y Wright | 1998-06-04 | UHC-40044-28 | 9837622881 | 1445 Baseline Rd, Austin, TX, 78790 | 0.62 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-122816 | ENR | Alexis J West | 1996-10-23 | UHC-01606-34 | 3866129530 | 5812 Church St, Dallas, TX, 75264 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-103078 | ENR | Bernda G Le | 1970-07-25 | UHC-89078-75 | 3026335575 | 4818 Ocean Ave, Fresno, CA, 93785 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-125695 | ENR | Bradley J Santos | — | UHC-59865-84 | 3624043138 | 8363 Sage Ct, Phoenix, AZ, 85079 | 0.62 | Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+3 more |
| ENR-107189 | ENR | Betty B Rojas | 1989-12-03 | UHC-73203-96 | 6133597190 | 8374 Grand Ave, Dallas, TX | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-130142 | ENR | Mason L Esspinoza | 1994-02-10 | UHC-05793-04 | — | 8800 Sage Ct, Eden Prairie, MN, 55358 | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135705 | ENR | Kim Luacs | 1954-06-01 | — | 2512450596 | 3323 Bayshore Dr # 545, Tucson, AZ, 85737 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-102550 | ENR | Lucia B Vargas | 1975-11-13 | UHC-57841-42 | 5897625824 | 4762 Lake View Rd, Jacksonville, FL, 32201 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-109425 | ENR | Frank L Cartar | 1989-09-19 | UHC-96878-77 | 6873963969 | 8971 Market St, Tempe, AZ, 85210 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-141325 | ENR | Lori E Mason | — | UHC-67088-66 | — | 6710 Main St, Seattle, WA, 98128 | 0.62 | Date of birth unreadableStreet suffix standardisedAddress re-casedEmail lower-cased+3 more |
| ENR-122917 | ENR | Bradley Y Ramirez | 2001-02-14 | UHC-95752-20 | 9478906192 | 1256 Canyon Rd Apt 7, Mesa, AZ, 85261 | 0.62 | Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-130420 | ENR | Raymond I Snyder | 1975-01-06 | UHC-68621-79 | 7075318291 | 2895 Park Pl, Denver, CO, 80280 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more |
| ENR-121505 | ENR | Deborah K Jamse | 1944-12-13 | UHC-46277-47 | 5233074985 | 335 Indian School Rd, Tempe, AZ, 85285 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-136503 | ENR | Carol E Stevens | 1947-08-14 | UHC-99194-43 | 7813958341 | 5527 Highland Ave, Eden Prairie, MN, 55321 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-104705 | ENR | Jeffrey B Butler | 1961-04-09 | UHC-23786-41 | 5206609486 | 689 Church St, Fresno, CA, 93765 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-108266 | ENR | CJunk | 1953-10-08 | UHC-26846-56 | 9415282095 | 3747 Ocean Ave, San Antonio, TX, 78246 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-134054 | ENR | David Powell | 1977-12-09 | UHC-52885-07 | 2035583675 | 2066 Palm Dr, Miami, FL, 33177 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-128075 | ENR | Marilyn E Herrera | 1950-01-20 | UHC-81602-27 | 3685467433 | 7170 Meadow Ln, Plano, TX, 75060 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-100595 | ENR | Shirley B Ray | 1966-11-12 | UHC-66697-86 | — | 1778 Cedar Ln # 406, Glendale, AZ, 85383 | 0.62 | Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+3 more |
| ENR-100594 | ENR | Shirley B Ray | 1966-11-12 | UHC-66697-86 | — | 1778 Cedar Ln # 406, Glendale, AZ, 85383 | 0.62 | Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+3 more |
| ENR-129799 | ENR | Fatima U Alvrado | 1954-04-01 | UHC-94101-36 | 2188804520 | 2711 Desert Sky Blvd, Chandler, AZ, 85277 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+3 more |
| ENR-130467 | ENR | Justin Tucker | 1968-12-26 | UHC-61253-61 | 6603413357 | 7759 Forest Ave, Denver, CO, 80231 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-127723 | ENR | Robert Z Perez | 1995-06-13 | UHC-74612-05 | 9224637523 | 309 Church St, Phoenix, AZ, 85067 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-125379 | ENR | Crhistina Foster | 1940-05-04 | UHC-20894-63 | 6903074633 | 1579 Church St, Plano, TX, 75052 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-104049 | ENR | Sofia O Jordan | 2004-12-20 | UHC-64020-40 | 4322437969 | 8382 Church St, Plano, TX | 0.62 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-130553 | ENR | Hannah Z Yang | 1960-11-12 | UHC-38205-90 | 8628563844 | 9744 Church St, Tucson, AZ, 85713 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-134932 | ENR | Janet Delgado | 1978-07-16 | UHC-23589-50 | 9608319418 | 2078 Willow Ct, Los Angeles, CA | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110250 | ENR | Jesse H McCoy | 1975-02-20 | UHC-92772-95 | 9342804051 | 7398 Oak St, Charlotte, NC, 28246 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-110249 | ENR | Jesse H McCoy | 1975-02-20 | UHC-92772-95 | 9342804051 | 7398 Oak St, Charlotte, NC, 28246 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-133034 | ENR | Douglas M Ford | 1943-10-27 | UHC-73862-03 | 9556722086 | 8892 Willow Ct, Mesa, AZ, 85204 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-122132 | ENR | Larry V Cunningham | 1981-10-10 | UHC-55343-96 | 3823770299 | 2368 Canyon Rd, Tucson, AZ, 85721 | 0.62 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-122129 | ENR | —Junk | 1978-03-13 | UHC-39687-17 | 4452292900 | 2215 Valley View Dr, Orlando, FL, 32858 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-104409 | ENR | Samantha K Ryan | — | UHC-28334-48 | 6685237823 | 4238 Pine Dr, San Antonio, TX, 78298 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-104728 | ENR | Emily V Le | 1997-12-09 | UHC-71304-15 | 9219277847 | 7478 Oak St, Minneapolis, MN, 55479 | 0.62 | Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-135734 | ENR | Ahmed D Carter | 1994-10-16 | UHC-42546-68 | 5245089289 | 5512 Sunset Blvd, Minneapolis, MN, 55414 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-103131 | ENR | Karen Little | 1995-03-03 | UHC-06105-79 | 7352192983 | 8088 Sunset Blvd, Eden Prairie, MN | 0.62 | Name re-casedPhone reformattedMember ID reformattedCity re-cased+3 more |