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-121058 | ENR | Arthur R Jones | 1952-10-25 | UHC-47132-05 | 6917133101 | 6332 Camelback Rd, Tucson, AZ, 85705 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-112896 | ENR | Virginia X Fox | 1962-11-23 | UHC-87518-06 | 8415476810 | 5562 Grand Ave, Miami, FL, 33143 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-110142 | ENR | Raymond Banks | 2004-07-09 | UHC-53680-51 | 8823434683 | 2102 Central Ave # 626, Denver, CO, 80236 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-108962 | ENR | Nancy H Spencer | 2009-09-06 | UHC-62462-17 | 6803761098 | 6931 Ocean Ave, Charlotte, NC, 28255 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-142910 | ENR | Douglas Berry | 1969-10-11 | UHC-83888-39 | 8863284662 | 1607 Lake View Rd, Jacksonville, FL, 32270 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+3 more |
| ENR-122841 | ENR | Elizabeth Gibson | 1955-05-15 | UHC-53210-52 | 3338331944 | 833 Sage Ct, Tampa, FL, 33661 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112077 | ENR | Cheryl M Riley | 1984-03-14 | UHC-78761-15 | 4796605566 | 1550 Spring St, Eden Prairie, MN, 55385 | 0.62 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123592 | ENR | Daniel G Marquez | 1957-01-11 | UHC-27316-13 | 4324113358 | 4511 Meadow Ln, Tampa, FL, 33664 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-114396 | ENR | Janice O Holmes | 1981-12-11 | UHC-67731-09 | 8938854425 | 638 Elm St, San Antonio, TX | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-134012 | ENR | Anna G Hart | 1988-05-13 | UHC-08766-79 | 4213793374 | 8807 Mesa Dr, San Antonio, TX, 78253 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-139824 | ENR | Diego H Contreras | 1948-02-23 | UHC-46032-06 | 5944815555 | 2310 Forest Ave, Eden Prairie, MN, 55360 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-137218 | ENR | Raymond T Gzman | 1991-02-02 | UHC-14684-42 | 3606511435 | 2259 Union St, Seattle, WA, 98173 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-130335 | ENR | Jennifer U Weaver | 1966-01-21 | UHC-23136-26 | 5179445337 | 8978 Oak St, Denver, CO | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedState name converted to code+3 more |
| ENR-111081 | ENR | Anthony E Henderson | 1989-01-09 | UHC-92935-47 | 2262270341 | 3140 Central Ave, Tucson, AZ, 85701 | 0.62 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-107703 | ENR | Mgan N Wilson | 1938-09-13 | UHC-23279-44 | 5693176233 | 9365 Jefferson Ave, Gilbert, AZ, 85278 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123288 | ENR | Wei G Harris | 1954-03-16 | UHC-52056-94 | 5394748760 | 5028 Ridge Rd, Columbus, OH, 43212 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120463 | ENR | Jaon W Riios | 2008-12-12 | UHC-15718-04 | 2185854793 | 3062 Grand Ave, Chandler, AZ, 85216 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100504 | ENR | Grace Soot | 1946-03-03 | UHC-54130-50 | 4238927617 | 4634 Forest Ave, Orlando, FL, 32819 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-103883 | ENR | Gary B Barnes | 1956-08-21 | UHC-36095-57 | 6057612471 | 4992 Ridge Rd, Mesa, AZ, 85265 | 0.62 | Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-128197 | ENR | Logan F Mills | 2004-06-12 | UHC-21983-89 | 5779904428 | 3968 Grand Ave # 848, Sacramento, CA, 95851 | 0.62 | Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-103900 | ENR | Samuel Ortiz | 1965-08-20 | UHC-34784-08 | 2657097942 | 5149 Jefferson Ave, Fresno, CA, 93785 | 0.62 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-135693 | ENR | Joe Rose | 1951-06-22 | UHC-91305-46 | 9475084966 | 9445 Hillcrest Rd, Plano, TX, 75063 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-140022 | ENR | Ray Peters | 1972-08-03 | UHC-72190-33 | — | 2221 Lake View Rd, Austin, TX, 78732 | 0.62 | Name re-casedDate of birth reformattedMember ID reformattedSSN last four extracted+3 more |
| ENR-112102 | ENR | Santiago Ris | 2000-12-27 | UHC-32377-67 | 2939297477 | 337 Elm St Apt 2, Glendale, AZ, 85324 | 0.62 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-141092 | ENR | Sarah Turner | 1985-04-22 | UHC-91678-08 | 7919348761 | 2910 Valley View Dr # 747, Columbus, OH, 43220 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-115668 | ENR | Jean P Parker | 1969-10-17 | UHC-94740-71 | 7234586722 | 1308 Church St, Mesa, AZ, 85274 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-112169 | ENR | Brian P Contreras | 1961-03-10 | UHC-53081-01 | 6579809121 | 3766 Ridge Rd Apt 30, Houston, TX, 77024 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-140887 | ENR | Ahmed J Castro | 1947-09-25 | UHC-57979-50 | 5233484164 | 7417 Park Pl, Tucson, AZ, 85763 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109353 | ENR | Mateo Taylor | 1978-02-24 | UHC-48830-68 | 8673324034 | 4707 Church St, Denver, CO, 80203 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-126869 | ENR | Arjun F Lawrence | 1984-05-05 | UHC-29118-42 | — | 6371 Sage Ct, San Antonio, TX, 78294 | 0.62 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-121099 | ENR | Cheril I Rose | 1998-08-22 | UHC-60983-94 | — | 1514 Church St, Houston, TX, 77017 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-124225 | ENR | Martha T Castro | 1983-04-01 | UHC-41311-30 | 2207065826 | 5565 Hillcrest Rd, Nashville, TN, 37234 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-119014 | ENR | Ashley Mejia | 1941-02-15 | UHC-36724-72 | 5984304073 | 1713 Union St, Austin, TX, 78733 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-129024 | ENR | Jason Espinoza | 1941-09-04 | UHC-85301-17 | 4345411814 | 764 Indian School Rd, Dallas, TX, 75202 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedZIP+4 trimmed+3 more |
| ENR-108038 | ENR | Teresa Reid | 1988-07-24 | UHC-23512-04 | 6166325139 | 7882 Market St # 374, Nashville, TN, 37257 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-121060 | ENR | Austin Stevens | 1960-06-14 | UHC-43550-76 | 5567049968 | 2950 Spring St, Mesa, AZ, 85268 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100404 | ENR | Walter E Coleman | 2005-01-12 | UHC-49325-18 | — | 4570 Ocean Ave, Austin, TX, 78786 | 0.62 | Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more |
| ENR-100221 | ENR | Justin D Espinoza | 1972-09-14 | UHC-99989-03 | 4798731607 | 2598 Elm St, Eden Prairie, MN | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-115678 | ENR | George Tucker | 1943-03-16 | UHC-44073-63 | 2544930839 | 8913 Ocean Ave, Austin, TX | 0.62 | Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more |
| ENR-119473 | ENR | William Nelson | 1969-02-23 | UHC-40816-54 | 4174585752 | 3672 Main St, San Antonio, TX | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-142359 | ENR | Rachel Wallace | 1996-08-06 | UHC-99092-84 | — | 1465 Camelback Rd, Minneapolis, MN, 55450 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-132485 | ENR | Valentina L Roberts | 1942-02-27 | UHC-23942-76 | 3484015934 | 3276 Highland Ave, Fresno, CA, 93784 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-127707 | ENR | Madison I Fisher | 1940-11-14 | UHC-88122-62 | — | 2191 River Rd, Tampa, FL, 33675 | 0.62 | Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121475 | ENR | Hiroshi Z Sanchez | 1999-06-15 | UHC-87722-88 | — | 5705 Union St, Sacramento, CA, 95809 | 0.62 | Name re-casedDate of birth reformattedCity re-casedState name converted to code+3 more |
| ENR-110532 | ENR | Brian C Schmidt | 1958-10-15 | — | 5882885313 | 1569 Sunset Blvd, Tempe, AZ, 85296 | 0.62 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more |
| ENR-107228 | ENR | Sophia Green | 1975-07-06 | UHC-94628-79 | 8815992347 | 2872 Forest Ave, Las Vegas, NV | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-138645 | ENR | Richard Q Wheeler | 1945-09-02 | UHC-39801-46 | 8679540304 | 4484 Valley View Dr, Charlotte, NC, 28216 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-111498 | ENR | Jerry Scott | 2004-10-26 | UHC-49219-18 | 3052959367 | 8838 Baseline Rd, Nashville, TN, 37249 | 0.62 | Member ID reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more |
| ENR-127942 | ENR | Vincent Diaz | 1958-10-01 | UHC-09083-91 | 3337818612 | 8104 Lincoln Way # 427, Seattle, WA, 98147 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-113158 | ENR | Larry B Ford | 1953-07-21 | UHC-19018-05 | 6637965103 | 5272 Maple Ave, Tempe, AZ, 85245 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |