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-115632 | ENR | Nathan Fox | 1968-01-26 | UHC-69999-99 | 6797759415 | 4909 Mountain View Dr, Fresno, CA, 93763 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-115608 | ENR | Beverly O Sanchez | — | UHC-57625-59 | 3632999023 | 8609 Forest Ave, Chandler, AZ, 85295 | 0.60 | Name re-casedDate of birth missingPhone reformattedMember ID reformatted+4 more |
| ENR-128083 | ENR | Peter R Ferguson | 1948-03-25 | UHC-45310-05 | 4004185678 | 1560 Central Ave, Houston, TX, 77066 | 0.60 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-121447 | ENR | Willie Li | — | UHC-81208-23 | 7986394227 | 8736 Jefferson Ave, Los Angeles, CA, 90075 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more |
| ENR-124627 | ENR | Janice M Wets | 1946-05-25 | UHC-30537-94 | 7406652820 | 207 Meadow Ln, Chandler, AZ | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-106863 | ENR | Jason Duncan | 1996-06-16 | UHC-47431-54 | 2323134848 | 783 Washington St, Houston, TX, 77091 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-101392 | ENR | Christian Marshall | 1949-12-23 | UHC-23971-08 | 2994479169 | 8663 Desert Sky Blvd, San Diego, CA, 92108 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-105126 | ENR | Christina Cruz | 1986-09-05 | UHC-96388-39 | 3087113051 | 4501 Jefferson Ave, Eden Prairie, MN, 55391 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-142865 | ENR | Catherine L Bennett | 1980-01-12 | UHC-58898-70 | 2587124462 | 939 Ocean Ave Apt 32, Austin, TX, 78790 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-103829 | ENR | Jacqueline Sanders | 1964-11-23 | UHC-67570-52 | 6232414781 | 6642 Ridge Rd, Gilbert, AZ, 85267 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-140828 | ENR | Christopher I Henderson | 1979-03-26 | UHC-31623-41 | 4103437224 | 983 Grand Ave, Atlanta, GA, 30375 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-101690 | ENR | Melissa Jimenez | 1939-10-06 | UHC-42639-44 | 8898156374 | 6734 Pine Dr, Atlanta, GA, 30373 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-101723 | ENR | Catherine X Ellis | 1939-12-19 | UHC-05992-19 | 7513768712 | 3991 Park Pl, Chandler, AZ, 85202 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-139276 | ENR | Danielle Austin | 1971-08-11 | UHC-75102-81 | 3442004802 | 8500 Canyon Rd, Minneapolis, MN, 55406 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-114348 | ENR | Aisha Miller | 1948-10-19 | UHC-31707-73 | 5973635984 | 5672 Elm St # 540, Austin, TX, 78716 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-114109 | ENR | Jacqueline Rice | 1965-03-03 | UHC-18053-04 | 3648347640 | 8134 Lake View Rd, Atlanta, GA, 30349 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-119492 | ENR | Amber Gutierrez | 2002-09-05 | UHC-40564-33 | 9679222206 | 7696 River Rd, Tucson, AZ, 85766 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-132806 | ENR | Kayla E Padilla | 2008-11-26 | UHC-70209-49 | 6276291174 | 7096 Lake View Rd, Gilbert, AZ, 85254 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-132162 | ENR | Roger O Sanchez | 1966-03-16 | UHC-37942-63 | 5426546812 | 7701 Lake View Rd # 645, Columbus, OH, 43295 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-114585 | ENR | Christopher Z Stewart | 2007-01-04 | UHC-24875-05 | 2935431305 | 3083 Main St, Houston, TX, 77068 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-117032 | ENR | Luis S Howard | 1987-09-10 | UHC-63334-20 | 5407541885 | 744 Harbor Blvd, Las Vegas, NV, 89139 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-100795 | ENR | Brnadon R Bryant | 1980-12-13 | UHC-78047-95 | 9533400231 | 2086 Maple Ave, Atlanta, GA, 30342 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-111380 | ENR | Catherine H Morgan | 2006-04-10 | UHC-30159-88 | 5718480669 | 6975 Hillcrest Rd Apt 36, Tempe, AZ, 85237 | 0.60 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-102349 | ENR | Debra V White | 1951-01-13 | UHC-67594-75 | — | 7964 Valley View Dr, Minneapolis, MN, 55491 | 0.60 | Name re-casedCity re-casedState code upper-casedZIP+4 trimmed+4 more |
| ENR-142571 | ENR | Ronald H Harrison | 1984-04-25 | UHC-20068-10 | — | 8832 Mountain View Dr, San Diego, CA, 92193 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-143002 | ENR | Marcus H Fernandez | 1997-10-04 | UHC-69524-07 | 4979829474 | 1095 Hillcrest Rd, Tempe, AZ, 85298 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-112418 | ENR | Jessica Elis | 1997-03-05 | UHC-51002-75 | 8908184992 | 2135 Mesa Dr Apt 21, Jacksonville, FL, 32280 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-124651 | ENR | Dennis B Mitchell | 1993-04-03 | UHC-59416-92 | 6122587459 | 9110 Mountain View Dr, Austin, TX, 78738 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-118694 | ENR | Lori I Austyn | 2003-07-23 | UHC-45897-76 | 6905672213 | 3574 Cedar Ln, Fresno, CA, 93760 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-133291 | ENR | Raymond Grant | 1957-06-21 | UHC-33272-26 | 5254095899 | 9859 Elm St, Miami, FL | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-141355 | ENR | Roger Reid | 1961-06-04 | UHC-97347-56 | — | 9877 Valley View Dr, Sacramento, CA, 95880 | 0.60 | Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more |
| ENR-119349 | ENR | Mason U Pierce | 1970-10-14 | UHC-14486-45 | 7584183726 | 5979 Maple Ave, San Antonio, TX, 78271 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-106607 | ENR | Charlotte Payne | 1943-09-07 | UHC-66273-80 | 3037776461 | 5422 Oak St, Las Vegas, NV, 89121 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-135319 | ENR | Brittany B Moore | 2007-05-24 | UHC-86886-77 | 5712535563 | 2956 Sunset Blvd, Tampa, FL, 33651 | 0.60 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-113207 | ENR | Mateo P McCoy | 1989-09-18 | UHC-20963-71 | 8246598642 | 514 Spring St, Scottsdale, AZ, 85279 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-140368 | ENR | Austin Santos | 2004-09-16 | UHC-27796-57 | 3052768455 | 9199 Church St, Dallas, TX, 75207 | 0.60 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-100934 | ENR | Robert Nichols | 2007-10-24 | UHC-85970-41 | 6913974850 | 5023 Cedar Ln, Seattle, WA | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-142422 | ENR | Justin Chapman | 1967-03-13 | UHC-61066-97 | 9317053642 | 3608 Sage Ct # 377, Charlotte, NC, 28216 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-111617 | ENR | Emma N Dunn | 1972-11-22 | UHC-28577-51 | 6095564294 | 7042 Broadway, Chandler, AZ, 85249 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-108922 | ENR | Samuel Murphy | 1938-03-23 | UHC-88511-69 | 6496299727 | 5850 Main St, San Diego, CA, 92114 | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-136805 | ENR | Janice L Hamilton | 1977-02-23 | UHC-98453-76 | 3966720156 | 6541 Cedar Ln, Las Vegas, NV, 89137 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-133392 | ENR | Rachel D Kim | 1946-03-19 | UHC-21617-33 | — | 977 Ridge Rd, Plano, TX, 75086 | 0.60 | Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-100267 | ENR | Kathryn J Kelly | 1955-01-24 | UHC-61592-30 | 6586513640 | 6310 Cedar Ln, Mesa, AZ, 85255 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-140612 | ENR | Bradley Perez | 1988-02-23 | UHC-12473-59 | 8529010649 | 3352 Oak St, Orlando, FL, 32837 | 0.60 | Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more |
| ENR-139997 | ENR | Stephen U Herrera | 1950-05-18 | UHC-99274-57 | 9304105875 | 1373 Park Pl, Minneapolis, MN, 55449 | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-137650 | ENR | Gregory Pena | 1944-04-24 | UHC-46769-63 | 5237698601 | 1872 Meadow Ln, Columbus, OH, 43218 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-139873 | ENR | Natalie Spencer | 1986-01-27 | UHC-74798-50 | 9136532007 | 6562 Jefferson Ave, Houston, TX | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-116638 | ENR | Thomas A Guzman | 1998-04-26 | UHC-06290-37 | 8538788154 | 6043 Apache Blvd, Tempe, AZ, 85234 | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-133667 | ENR | Carl Pierce | 1981-07-24 | UHC-13973-18 | 5402391218 | 7608 Baseline Rd # 234, Orlando, FL, 32873 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-102271 | ENR | Priya M Bryant | 1995-09-20 | UHC-21221-38 | 9698744362 | 2965 Lake View Rd, Chandler, AZ, 85288 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |