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-111363 | ENR | Cheryl Rios | 1947-10-04 | UHC-04103-47 | 7477868492 | 4133 River Rd, Minneapolis, MN, 55477 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-131200 | ENR | Logan L Ward | 1957-07-06 | UHC-11133-92 | 8943911727 | 3076 Valley View Dr, San Antonio, TX, 78233 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-134391 | ENR | Mark Z Vazquez | 1992-11-10 | UHC-54827-07 | 5148555400 | 2171 Hillcrest Rd # 959, Minneapolis, MN, 55476 | 0.50 | Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-101287 | ENR | George Y Rios | 1974-11-12 | UHC-27407-51 | 9455101110 | 6504 Valley View Dr, Austin, TX, 78707 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-125681 | ENR | Matthew K Kelley | 1954-01-02 | UHC-67263-62 | 2295604446 | 3283 Camelback Rd, Gilbert, AZ | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-124484 | ENR | Catherine Carroll | 1971-06-08 | UHC-19278-55 | 2748450117 | 5270 Highland Ave # 824, Orlando, FL, 32847 | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-137058 | ENR | James Aguilar | 1963-09-23 | UHC-21148-68 | 6619012532 | 1987 Sage Ct # 638, Columbus, OH, 43278 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-122558 | ENR | Christine F Davis | 1968-04-16 | UHC-61321-56 | 9487277411 | 5608 Lincoln Way # 143, Dallas, TX, 75252 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-140597 | ENR | Charlotte Chapman | 1979-11-17 | UHC-57418-29 | 4075991025 | 3896 Church St, Miami, FL, 33103 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-124432 | ENR | Lauren Graham | 1979-06-03 | UHC-12369-48 | 4347087361 | 7492 Jefferson Ave, Scottsdale, AZ, 85207 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123160 | ENR | Steve C Carpenter | 1973-02-04 | UHC-76604-67 | 4632820237 | 1248 Union St, Sacramento, CA | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123161 | ENR | Steve C Carpenter | 1973-02-04 | UHC-76604-67 | 4632820237 | 1248 Union St, Sacramento, CA | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-136935 | ENR | Logan J Larson | 1945-04-19 | UHC-56916-28 | 9866887457 | 6157 Forest Ave, Phoenix, AZ, 85053 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-109970 | ENR | Noah Martinez | 1971-01-07 | UHC-54843-07 | 5695071780 | 9722 Union St, Los Angeles, CA, 90097 | 0.50 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-113774 | ENR | Janice J Russell | 1954-07-22 | UHC-82902-77 | 3635133487 | 4026 Camelback Rd, San Antonio, TX, 78245 | 0.50 | Middle initial moved out of first namePhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-136842 | ENR | Deborah Fox | — | UHC-40257-90 | — | 3808 Highland Ave, Houston, TX, 77059 | 0.50 | Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more |
| ENR-135999 | ENR | Fatima Z Morgan | 1999-05-22 | UHC-94906-30 | 8285576908 | 5820 Baseline Rd, Las Vegas, NV, 89180 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112917 | ENR | Jerry L Nelson | 2005-05-26 | UHC-34021-91 | 8483190273 | 4180 Apache Blvd, Charlotte, NC, 28250 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-118372 | ENR | Dot Perry | 1999-05-01 | UHC-17361-72 | — | 769 Harbor Blvd, Minneapolis, MN, 55448 | 0.50 | Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-120712 | ENR | William O Marquez | 1979-01-28 | UHC-52616-48 | — | 8067 Apache Blvd, Tempe, AZ, 85239 | 0.50 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-118508 | ENR | Margaret A Olson | 1958-11-22 | UHC-41517-04 | 4358121706 | 222 Desert Sky Blvd, Gilbert, AZ, 85284 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-139685 | ENR | Karen M Alexander | 1975-02-26 | UHC-57783-27 | 5069389902 | 6849 Cedar Ln, Nashville, TN, 37254 | 0.50 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-141316 | ENR | Pamela Young | — | UHC-52866-41 | 9883237413 | 3553 River Rd Apt 38, Columbus, OH, 43280 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more |
| ENR-116497 | ENR | Priay Wright | 1951-01-21 | UHC-02911-90 | 4283327125 | 6085 Baseline Rd, Jacksonville, FL, 32223 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-108247 | ENR | Cheryl N Scott | 1991-02-23 | UHC-34552-42 | 3889988992 | 8386 Lake View Rd, Tempe, AZ, 85200 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-103251 | ENR | CJunk | 1977-12-02 | UHC-33344-70 | 2208398187 | 6511 Harbor Blvd, Tampa, FL, 33608 | 0.50 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133175 | ENR | Nathan Y Patterson | 1954-10-23 | UHC-45106-07 | 9054485241 | 5732 Harbor Blvd, Los Angeles, CA, 90066 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more |
| ENR-100410 | ENR | Kelly Hugehs | 1982-12-05 | UHC-94709-09 | 2303809948 | 2624 Park Pl, Orlando, FL, 32892 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-101676 | ENR | Scott J Garrdner | 1995-05-09 | UHC-89463-27 | 8072364122 | 7640 Central Ave Apt 36, Las Vegas, NV, 89111 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-101675 | ENR | Scott J Garrdner | 1995-05-09 | UHC-89463-27 | 8072364122 | 7640 Central Ave Apt 36, Las Vegas, NV, 89111 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-121329 | ENR | Anthony H Rodriguez | 2002-10-08 | UHC-83511-59 | 6872400960 | 1004 Palm Dr, Minneapolis, MN, 55457 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-121860 | ENR | Terry Jensen | 1940-09-26 | UHC-66597-64 | — | 8449 Mountain View Dr # 892, Mesa, AZ, 85249 | 0.50 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-126484 | ENR | Anna P Watkins | 1983-08-25 | UHC-81236-85 | — | 5278 Sunset Blvd, Seattle, WA, 98129 | 0.50 | Name split from “Last, First”Phone missing area codeMember ID reformattedStreet suffix standardised+3 more |
| ENR-103430 | ENR | Melissa Hart | 2005-02-10 | UHC-06739-23 | 3355163640 | 4588 Baseline Rd, Atlanta, GA | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-103296 | ENR | Mateo Jackson | 1990-04-07 | UHC-48696-50 | 9494711696 | 3971 Lincoln Way # 814, Las Vegas, NV, 89146 | 0.50 | Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more |
| ENR-103057 | ENR | Heather G Boyd | 1954-10-26 | UHC-21223-18 | 9519957781 | 4167 Ridge Rd, Minneapolis, MN, 55492 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-120155 | ENR | Julie Allen | 2006-07-18 | UHC-71841-70 | 9586179676 | 455 Indian School Rd, Dallas, TX, 75215 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110775 | ENR | Kayla Johnson | 1990-01-07 | UHC-82773-21 | 6019714583 | 9081 River Rd, Tampa, FL, 33639 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-117553 | ENR | Mateo N Bowman | — | UHC-22409-06 | 2692096715 | 4933 Bayshore Dr, Glendale, AZ, 85359 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-107560 | ENR | OJunk | 1991-05-19 | — | 3354668249 | 2636 Highland Ave, Sacramento, CA, 95889 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-105632 | ENR | Helen McCoy | 1999-07-23 | UHC-48762-31 | 3759522691 | 858 Market St, Tampa, FL | 0.50 | Phone reformattedMember ID reformattedSSN last four extractedState name converted to code+3 more |
| ENR-140045 | ENR | Charlotte F Ross | 1978-02-09 | UHC-07779-40 | 6056329565 | 2008 Ocean Ave, Dallas, TX, 75253 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110472 | ENR | Dylan Santiago | 1991-06-20 | UHC-31030-97 | — | 8719 Pine Dr, Atlanta, GA, 30368 | 0.50 | Name re-casedTwo-digit birth yearPhone missing area codeCity re-cased+3 more |
| ENR-134392 | ENR | Charles M Hoffman | 1958-06-21 | UHC-08773-02 | 2152540032 | 2378 Bayshore Dr Apt 2, Mesa, AZ, 85275 | 0.50 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-123706 | ENR | Jessica Gordon | 1965-09-14 | UHC-38164-21 | 9532635493 | 7519 Pine Dr Apt 35, Sacramento, CA | 0.50 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-111011 | ENR | Jeremy Schmidt | 1971-11-24 | UHC-95137-59 | — | 4185 Meadow Ln, Los Angeles, CA, 90068 | 0.50 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-117439 | ENR | Lucia E Bryant | 2000-10-15 | UHC-21632-31 | 4998044964 | 7434 Market St # 638, Glendale, AZ, 85323 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more |
| ENR-114560 | ENR | Sophia Miller | 2004-08-07 | — | 5386532881 | 9556 Canyon Rd, Miami, FL | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-116997 | ENR | Carl Lewis | 1984-10-22 | UHC-93843-37 | 7535333183 | 1821 Bayshore Dr, Orlando, FL | 0.50 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-132900 | ENR | Ahmed Rose | 1972-11-01 | UHC-11855-20 | 9007684149 | 4535 Camelback Rd # 907, Seattle, WA | 0.50 | Name re-casedPhone reformattedUnit split from streetState name converted to code+3 more |