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-110763 | ENR | Timothy L Ortega | 1995-11-14 | UHC-61342-15 | 5465806924 | 9713 Park Pl, Los Angeles, CA, 90055 | 0.52 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| ENR-142710 | ENR | Arjun J Hanson | 1962-01-24 | UHC-47578-88 | 6287326931 | 7609 Spring St, Seattle, WA, 98109 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-134984 | ENR | Katherine G King | 1976-10-05 | UHC-75429-97 | 6082717320 | 7807 Baseline Rd, Atlanta, GA | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-117520 | ENR | Logan U Gibson | 1999-08-16 | UHC-61944-97 | 4448220382 | 1387 Lake View Rd, Miami, FL, 33127 | 0.52 | Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-118326 | ENR | Chris U Andrews | 2002-04-17 | UHC-48839-39 | 8816132588 | 9864 Washington St Apt 31, San Diego, CA, 92111 | 0.52 | Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+2 more |
| ENR-128161 | ENR | Marshall Wayne | 1983-10-09 | UHC-19370-19 | 3912203085 | 6085 Church St, San Antonio, TX, 78295 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-115706 | ENR | Ana X Scott | 1990-09-23 | UHC-07807-14 | 5164151717 | 569 Hillcrest Rd, Scottsdale, AZ, 85216 | 0.52 | Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| ENR-117397 | ENR | Marilyn Thompson | 1964-03-13 | UHC-26376-20 | 8227163831 | 3010 Market St, Tampa, FL, 33609 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-139497 | ENR | Roegr Carroll | 2003-09-20 | UHC-99287-92 | 5507948842 | 8485 Meadow Ln, Minneapolis, MN, 55402 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-141268 | ENR | Dennis Bryant | 1960-10-25 | UHC-89581-24 | 8935969372 | 9389 Central Ave, Plano, TX, 75080 | 0.52 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-124136 | ENR | Justin Coleman | 1971-12-12 | UHC-68642-60 | 5369949753 | 3927 Valley View Dr, Mesa, AZ, 85279 | 0.52 | Name split from “Last, First”Phone reformattedSSN last four extractedCity re-cased+2 more |
| ENR-139599 | ENR | Alice I Lopez | 1993-01-01 | UHC-78452-10 | 8373380794 | 7408 Mesa Dr, Jacksonville, FL, 32248 | 0.52 | Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-124342 | ENR | Justin P Li | 1939-12-07 | UHC-25803-73 | — | 540 Palm Dr, Austin, TX, 78799 | 0.52 | Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-122012 | ENR | Brandon F Morris | 1961-09-27 | UHC-64581-74 | 5829631175 | 3009 Maple Ave, Tampa, FL, 33626 | 0.52 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-117466 | ENR | Brian H Ford | 1998-09-28 | UHC-83014-83 | 6316478969 | 3178 Harbor Blvd, Houston, TX, 77071 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+2 more |
| ENR-137039 | ENR | Gary Herrera | 1983-11-17 | UHC-69117-24 | 5483689686 | 589 Mountain View Dr # 352, Plano, TX, 75017 | 0.52 | Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-138472 | ENR | Jose Day | 2004-10-04 | UHC-65678-01 | — | 3940 Desert Sky Blvd, Plano, TX, 75035 | 0.52 | Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-113830 | ENR | Adam Bailey | 2000-08-10 | UHC-61330-54 | 6804042855 | 6587 Jefferson Ave Apt 5, Scottsdale, AZ, 85222 | 0.52 | Name re-casedUnit split from streetCity re-casedState code upper-cased+2 more |
| ENR-102678 | ENR | Natalie W Graham | 1969-01-02 | UHC-06183-55 | 3888261089 | 8770 Oak St, Jacksonville, FL, 32228 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more |
| ENR-126277 | ENR | Jean J Vargas | 1990-06-03 | UHC-91924-50 | — | 3267 Oak St, Mesa, AZ, 85261 | 0.52 | Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-123611 | ENR | Kevin Cunningham | 1962-09-09 | UHC-16646-65 | 2608973093 | 4566 Forest Ave # 209, Phoenix, AZ, 85099 | 0.52 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-137918 | ENR | Kaayla Lucas | 1977-08-04 | UHC-47421-09 | 6537973895 | 8456 Valley View Dr, Eden Prairie, MN, 55377 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-112124 | ENR | Jack W Delgado | — | UHC-17106-67 | 6297836156 | 928 Harbor Blvd, Tucson, AZ, 85710 | 0.52 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more |
| ENR-103484 | ENR | Marcus Richards | 2008-01-28 | UHC-72468-49 | 7475956022 | 8720 Market St Apt 18, Atlanta, GA | 0.52 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-132100 | ENR | Brandon M Rose | 1976-05-22 | UHC-85159-64 | 2436368592 | 1264 Valley View Dr, Tucson, AZ, 85764 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+2 more |
| ENR-107611 | ENR | Stephen Lewis | 1958-03-04 | UHC-80754-67 | — | 7899 Church St, Miami, FL, 33177 | 0.52 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-120223 | ENR | Diana A Aguilar | 1958-08-04 | UHC-33485-42 | 7774006191 | 4656 Elm St Apt 6, Chandler, AZ, 85277 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-133721 | ENR | Daniele Bradley | 1998-02-18 | UHC-78142-72 | — | 670 Pine Dr, Denver, CO, 80201 | 0.52 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-133001 | ENR | Scott T Welch | 1959-08-19 | UHC-58824-47 | 9268572477 | 3195 Baseline Rd, Atlanta, GA, 30389 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedEmail lower-cased+2 more |
| ENR-104967 | ENR | Robert Wels | 1957-10-10 | UHC-36855-16 | 2588341398 | 3675 Mountain View Dr # 443, San Antonio, TX | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-110913 | ENR | MatthewJunk | 1992-09-05 | UHC-62583-91 | 5527562708 | 6539 Highland Ave, Plano, TX, 75036 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| ENR-107923 | ENR | Gerald W Richardson | 1957-04-11 | UHC-52791-35 | 2998825660 | 1747 Sage Ct # 988, Gilbert, AZ, 85254 | 0.52 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-121296 | ENR | Brittany K Ferguson | 1990-09-21 | UHC-84955-92 | — | 8269 Baseline Rd, Minneapolis, MN, 55433 | 0.52 | Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more |
| ENR-119363 | ENR | Teresa J Jimenez | 1989-01-10 | UHC-32575-99 | 6633116374 | 3894 Meadow Ln, Fresno, CA, 93770 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-118984 | ENR | Eevlyn Munoz | 1971-10-06 | UHC-08992-37 | 7896126352 | 6463 Ocean Ave, Glendale, AZ, 85333 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-139291 | ENR | Rachel M Fowler | 1983-05-20 | UHC-83408-02 | 2438832716 | 8542 Forest Ave Apt 39, Minneapolis, MN, 55405 | 0.52 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-112369 | ENR | Brenda M Phillips | 1945-10-26 | UHC-36458-25 | 5117760774 | 5189 Grand Ave, Orlando, FL, 32884 | 0.52 | Middle initial moved out of first nameName re-casedPhone reformattedZIP+4 trimmed+2 more |
| ENR-112937 | ENR | Matthew E Jones | 2002-04-11 | UHC-71563-08 | — | 9898 Valley View Dr, Los Angeles, CA, 90044 | 0.52 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-123947 | ENR | Diana H Lopez | 1990-12-20 | UHC-00021-65 | 6766634845 | 7282 Sunset Blvd, Tempe, AZ | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-102791 | ENR | Stephanie Allen | 1994-06-12 | UHC-95154-65 | 3008866836 | 6831 Oak St, Dallas, TX, 75259 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-107039 | ENR | Sandra A Dixon | 1966-11-08 | UHC-02208-33 | 6462029251 | 648 Union St, Mesa, AZ, 85267 | 0.52 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-130976 | ENR | Christine Wright | 1955-03-17 | UHC-12937-89 | 9174292664 | 1177 Hillcrest Rd, Chandler, AZ, 85277 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-117842 | ENR | Alice P Bowman | 1941-10-04 | UHC-07682-18 | 7879353391 | 6661 Main St, Houston, TX, 77040 | 0.52 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-111683 | ENR | Marilyn T Richads | 1995-06-26 | UHC-52260-31 | 9079841631 | 2627 Church St, Denver, CO, 80240 | 0.52 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more |
| ENR-137201 | ENR | Eugene V Watkins | 1965-11-24 | UHC-59440-01 | 6562618581 | 5076 Elm St # 250, Denver, CO, 80295 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-142483 | ENR | Charlie A Nunez | 1953-05-25 | UHC-42084-71 | 8627104283 | 1663 Mesa Dr, Seattle, WA, 98179 | 0.52 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-112867 | ENR | Zachary Hill | 1958-01-15 | UHC-33929-52 | 2539570730 | 7404 Market St # 840, Sacramento, CA, 95805 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-102733 | ENR | Greg Chen | — | UHC-87310-18 | — | 8242 Canyon Rd, Mesa, AZ, 85280 | 0.52 | Name re-casedDate of birth unreadableSSN last four extractedStreet suffix standardised+2 more |
| ENR-122681 | ENR | Kathryn L Burke | 1952-10-06 | UHC-37727-05 | 8855054340 | 5009 Grand Ave, Glendale, AZ, 85394 | 0.52 | Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-125182 | ENR | Gregory Morgan | 1943-01-06 | UHC-49778-47 | 8538846540 | 3106 Harbor Blvd, Denver, CO | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |