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-139709 | ENR | Ashley Q Mejia | 1969-02-05 | UHC-53643-77 | 8658817090 | 4736 Desert Sky Blvd, Scottsdale, AZ, 85286 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-109790 | ENR | Charlotte Nunez | 1945-02-17 | UHC-75383-35 | 9598232911 | 1243 Main St, Orlando, FL, 32873 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-142154 | ENR | Jessica Z Gonzalez | 1982-06-25 | UHC-56950-38 | 6133110776 | 8554 Ridge Rd, Columbus, OH, 43200 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+4 more |
| ENR-128848 | ENR | Jesse V West | 1946-11-25 | UHC-82874-61 | 9418218477 | 6026 Hillcrest Rd, Denver, CO, 80256 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-120302 | ENR | Priya Simpson | 1997-11-22 | UHC-26606-78 | 7079954573 | 5204 Meadow Ln Apt 29, Columbus, OH, 43257 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-120393 | ENR | Deborah Lawson | 1955-02-26 | UHC-80225-75 | — | 4298 Central Ave Apt 27, Tucson, AZ, 85734 | 0.60 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-116430 | ENR | Samuel C Kelley | 1955-07-10 | UHC-55006-25 | 7046110385 | 6204 Union St, Orlando, FL, 32816 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| ENR-142000 | ENR | Valentina Medina | 1985-10-12 | UHC-26308-88 | 2317529088 | 1073 Ocean Ave, Tampa, FL, 33641 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-113187 | ENR | Christian Rogers | 1943-09-06 | UHC-47495-44 | 2594153330 | 5635 Cedar Ln, Dallas, TX, 75261 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-116672 | ENR | Ralph Weaver | 1945-03-16 | UHC-96928-89 | 8495346181 | 2322 Hillcrest Rd, Miami, FL, 33123 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-138039 | ENR | Charlotte D Perry | 1983-12-12 | UHC-56932-15 | 4792872369 | 6577 Spring St, Scottsdale, AZ, 85266 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-131670 | ENR | Grace Z Jimenez | 1949-02-21 | UHC-20386-06 | — | 2343 Mountain View Dr, Nashville, TN, 37229 | 0.60 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+4 more |
| ENR-133005 | ENR | Charles Chan | 1978-06-13 | UHC-57012-54 | 8274940267 | 2023 Meadow Ln, Tucson, AZ | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-113639 | ENR | Matthew O Hunt | 1964-09-03 | UHC-31740-14 | 5485113418 | 7991 Sunset Blvd, Scottsdale, AZ, 85263 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-114929 | ENR | Marcus Campbell | 1994-03-25 | — | 4334968311 | 5934 Canyon Rd, Seattle, WA | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-123047 | ENR | Daniel Q Mendez | 1958-11-04 | UHC-21332-78 | 9787564344 | 1144 Main St, Columbus, OH | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-141016 | ENR | Joan R Rivera | 1988-12-18 | UHC-22799-76 | — | 5441 Ocean Ave, Gilbert, AZ, 85279 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-141822 | ENR | Marilyn Henderson | 1982-05-24 | UHC-96699-72 | 5264755262 | 3603 Camelback Rd, Houston, TX, 77070 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-115840 | ENR | Rebecca Greee | 2006-05-05 | UHC-66153-41 | — | 3070 Palm Dr, Tampa, FL, 33694 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-105171 | ENR | Amy Wagner | 1956-09-09 | UHC-05819-84 | 6112867706 | 1324 Bayshore Dr, Columbus, OH, 43269 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-110751 | ENR | Frances Hill | 1941-11-27 | UHC-11640-50 | 7687767218 | 8660 Apache Blvd, Eden Prairie, MN, 55359 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-142493 | ENR | Brandon Z Martin | 2003-01-17 | UHC-01660-56 | 8787811703 | 2141 Willow Ct, Eden Prairie, MN, 55362 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-104018 | ENR | Bryan R Bowman | 1963-12-26 | UHC-61619-10 | 4337776150 | 6735 Market St, Atlanta, GA, 30350 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-135389 | ENR | Harold V Matthews | 1967-11-23 | UHC-47451-76 | 8814601146 | 1371 Elm St, Nashville, TN, 37212 | 0.60 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-128948 | ENR | Tyler Barnes | 1966-03-01 | UHC-63428-80 | 7433776119 | 2446 Apache Blvd, Jacksonville, FL, 32219 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-100412 | ENR | Jacob E Hamilton | 1987-09-19 | UHC-17863-18 | 7252173776 | 9073 Grand Ave, Columbus, OH, 43214 | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-122905 | ENR | Lawrence Russell | 1981-02-16 | UHC-68841-12 | 6623194772 | 7206 Valley View Dr, Miami, FL, 33112 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-132332 | ENR | Susan Huntter | 1999-07-24 | UHC-70915-70 | 5355554838 | 5487 Lake View Rd, Mesa, AZ, 85299 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-140116 | ENR | Jacob S Hayes | 1982-11-11 | UHC-47437-62 | 2512518074 | 5141 Camelback Rd, Phoenix, AZ, 85073 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-129698 | ENR | Hiroshi G Rivera | 1952-01-23 | UHC-30776-85 | 8885005013 | 5321 River Rd, Orlando, FL, 32859 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| ENR-118180 | ENR | Serah Yang | 1986-04-09 | UHC-33199-01 | — | 6524 Camelback Rd, Tampa, FL, 33626 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111378 | ENR | Brenda M Patel | 1995-12-09 | UHC-73125-94 | 5034557537 | 7529 Union St, Eden Prairie, MN | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-114392 | ENR | Robert V Murray | 1960-04-28 | UHC-06624-68 | 2265750560 | 8849 Mesa Dr, Tampa, FL, 33680 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111627 | ENR | Joan Ortega | 1958-03-20 | UHC-14047-49 | 9314481093 | 6390 Ocean Ave, Jacksonville, FL, 32210 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-107323 | ENR | Harold U Little | 1944-05-17 | UHC-28581-15 | 6758344200 | 298 Mountain View Dr # 544, Austin, TX, 78782 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-119697 | ENR | Kyle Harper | — | UHC-24220-25 | 3408117174 | 4809 Meadow Ln, Mesa, AZ, 85216 | 0.60 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| ENR-115806 | ENR | Jose W Campbell | 1980-01-09 | UHC-70117-04 | 6684951635 | 5850 Union St, Jacksonville, FL, 32269 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-103016 | ENR | Kenneth Wallace | 1958-11-28 | UHC-00563-50 | 2588243229 | 4932 Indian School Rd, Miami, FL | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-100416 | ENR | Arthur K Torres | 1941-08-23 | UHC-50812-37 | 8169079232 | 5706 River Rd, Tucson, AZ, 85704 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-125249 | ENR | Sharon Chapman | 1967-01-14 | UHC-40644-74 | 7188265245 | 249 Ocean Ave, Los Angeles, CA, 90051 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-102537 | ENR | Isabella Y Price | 1964-03-25 | UHC-41557-49 | 4734495502 | 7692 Meadow Ln, San Antonio, TX, 78235 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-109165 | ENR | Ruth Q Weaver | 1986-01-08 | UHC-27012-03 | 3148644818 | 7988 Mesa Dr # 261, San Antonio, TX, 78217 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-130567 | ENR | Virginia L Lane | 1957-09-09 | UHC-53686-49 | 4409852591 | 8548 Indian School Rd, Denver, CO, 80250 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-101468 | ENR | Alan M Carroll | 1984-09-13 | UHC-76726-26 | 4122979545 | 3589 Ridge Rd, Phoenix, AZ, 85006 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-139296 | ENR | Alexis E Duncan | 1970-08-12 | UHC-79293-81 | 3037285635 | 9398 Maple Ave, Gilbert, AZ, 85284 | 0.60 | Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-122394 | ENR | Carl F Nichols | 1962-11-25 | UHC-14580-29 | — | 6806 Mesa Dr, Tampa, FL, 33697 | 0.60 | Name re-casedDate of birth reformattedPhone missing area codeCity re-cased+4 more |
| ENR-112652 | ENR | Ralph Chavez | 1988-12-07 | UHC-46584-60 | 8275916623 | 8378 Ridge Rd, Denver, CO | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-122208 | ENR | Priya Thomas | 2007-07-14 | UHC-93116-67 | 8102713142 | 5410 Mesa Dr, San Antonio, TX | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111466 | ENR | Aaron F Welch | 2008-09-03 | UHC-51582-83 | 6519602271 | 6030 Bayshore Dr # 696, Austin, TX, 78727 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-113693 | ENR | Keelly P Miller | 1977-09-23 | UHC-87446-96 | 7748767147 | 1236 Sage Ct, Gilbert, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |