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-103683 | ENR | Ronald Morales | 1967-07-24 | UHC-74352-88 | 3958378373 | 6914 Cedar Ln, Denver, CO, 80215 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-130871 | ENR | Wayne Nelson | 2003-08-18 | UHC-16289-79 | 6403276604 | 4213 Spring St, Charlotte, NC, 28293 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-110446 | ENR | Beverly U Lewis | 1979-09-21 | UHC-51806-33 | — | 1731 Sunset Blvd, Tempe, AZ, 85252 | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more |
| ENR-120227 | ENR | Alice Patterson | — | UHC-05568-65 | 3976284792 | 9575 Washington St, Chandler, AZ | 0.48 | Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-120873 | ENR | Lauren E Davis | 1980-12-09 | UHC-50623-59 | 7923393453 | 3712 Main St, Columbus, OH, 43293 | 0.48 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more |
| ENR-111680 | ENR | Berb S Weaver | 1958-06-24 | UHC-62451-86 | 5819129100 | 4612 Cedar Ln, Phoenix, AZ, 85009 | 0.48 | Middle initial moved out of first nameSSN last four extractedStreet suffix standardisedAddress re-cased+4 more |
| ENR-130287 | ENR | Douglas Wallace | 2001-08-24 | UHC-52717-40 | 7335890995 | 6536 Lake View Rd, Glendale, AZ, 85379 | 0.48 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-102963 | ENR | Diego Carter | 1966-08-09 | UHC-45682-26 | 9796565703 | 1203 Mountain View Dr, Austin, TX | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-105303 | ENR | Roger Watson | 1948-04-27 | UHC-88620-95 | 4367914775 | 6246 Forest Ave, Minneapolis, MN, 55429 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-105302 | ENR | Roger Watson | 1948-04-27 | UHC-88620-95 | 4367914775 | 6246 Forest Ave, Minneapolis, MN, 55429 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-119224 | ENR | Frances Z Luna | 2001-12-16 | UHC-25455-90 | 3867086336 | 2882 Canyon Rd, Gilbert, AZ, 85271 | 0.48 | Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+4 more |
| ENR-102066 | ENR | Ronald R Howard | 2000-04-14 | UHC-79531-36 | 2446930748 | 4968 Valley View Dr, Jacksonville, FL | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-141580 | ENR | Christian P Lee | 1989-05-03 | UHC-56820-66 | 6987080386 | 3985 Canyon Rd, Atlanta, GA | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-137937 | ENR | Gloria Chapman | 1938-10-11 | UHC-10323-58 | 4782630196 | 4425 Mesa Dr Apt 8, Denver, CO | 0.48 | Phone reformattedMember ID reformattedUnit split from streetCity re-cased+4 more |
| ENR-115903 | ENR | Ana W Andrews | 1952-07-20 | UHC-89158-54 | — | 2817 Apache Blvd, Denver, CO | 0.48 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more |
| ENR-102285 | ENR | Anna K King | 1941-01-11 | UHC-76044-90 | 5507012262 | 251 Main St # 202, Eden Prairie, MN, 55323 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-135250 | ENR | Jordan Ferguson | — | UHC-68665-03 | 3254919247 | 6753 Sage Ct, Seattle, WA, 98133 | 0.48 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-132500 | ENR | Zachary Gibson | 2001-08-24 | UHC-91881-98 | 4965029512 | 1442 Maple Ave, Austin, TX, 78796 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-137595 | ENR | Grace U Mendez | 1962-06-05 | UHC-83618-82 | 5597330883 | 4883 Apache Blvd Apt 18, Orlando, FL, 32821 | 0.48 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-125068 | ENR | Heather V Berry | 2004-06-17 | UHC-78489-95 | 2218450099 | 4277 Spring St, San Antonio, TX, 78243 | 0.48 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-105254 | ENR | Ashley Hayes | 1993-03-18 | UHC-32375-64 | 4067729967 | 3942 Highland Ave, Plano, TX, 75009 | 0.48 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-114296 | ENR | Laura W Jonson | 1981-01-03 | UHC-73708-61 | 2892278574 | 184 Meadow Ln, San Antonio, TX, 78203 | 0.48 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-130047 | ENR | Kathy J Fisher | 1940-06-22 | UHC-76265-13 | 4052561273 | 8461 Harbor Blvd, San Diego, CA, 92108 | 0.48 | Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-126407 | ENR | Virginia Wilson | 1999-05-18 | UHC-88267-97 | — | 7763 Oak St, San Antonio, TX, 78268 | 0.48 | Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more |
| ENR-137144 | ENR | Denny O Dean | 1974-02-06 | UHC-07591-25 | 3653866925 | 863 Forest Ave, Gilbert, AZ, 85273 | 0.48 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-123769 | ENR | Rachel Murray | — | UHC-86163-90 | 6178472809 | 1127 River Rd, Tampa, FL, 33628 | 0.48 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-120318 | ENR | Logan Stewart | 1974-03-04 | UHC-35018-95 | 9838076756 | 7919 Mesa Dr # 262, Nashville, TN, 37266 | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-114251 | ENR | Frank Q Gomez | 1940-12-15 | UHC-57895-27 | 5378475354 | 2750 Mesa Dr, Austin, TX, 78787 | 0.48 | Name re-casedDate of birth reformattedMember ID reformattedSSN last four extracted+4 more |
| ENR-107354 | ENR | Catherine Hudson | 2001-05-05 | UHC-76200-83 | 5978103544 | 370 Harbor Blvd Apt 12, Miami, FL, 33129 | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-128085 | ENR | Sofia Marin | 1954-04-11 | UHC-48966-84 | 9825973219 | 5715 Sunset Blvd Apt 33, Los Angeles, CA, 90024 | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-122212 | ENR | Douglas Q Tucker | 1971-11-13 | UHC-69945-91 | — | 7086 Cedar Ln, San Antonio, TX | 0.48 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-127422 | ENR | Scott Hall | 2003-02-18 | UHC-57013-81 | 7217117160 | 2441 Maple Ave # 466, Jacksonville, FL, 32208 | 0.48 | Name re-casedSSN last four extractedUnit split from streetStreet suffix standardised+4 more |
| ENR-101046 | ENR | Deborah Butler | 1994-02-19 | UHC-90382-97 | — | 6452 Church St, San Antonio, TX, 78232 | 0.48 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-130920 | ENR | Samuel R Clark | 1942-06-03 | UHC-46047-49 | — | 7145 Valley View Dr, Eden Prairie, MN, 55372 | 0.48 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |
| ENR-111147 | ENR | Raymond Peterson | 1961-03-06 | UHC-76146-60 | 3609456095 | 2005 Hillcrest Rd, Tampa, FL, 33668 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-104376 | ENR | Dylan A Day | 1968-03-05 | UHC-69809-48 | 4364032927 | 522 Indian School Rd # 828, Denver, CO, 80214 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-128570 | ENR | Wei Lawrence | 1949-01-10 | UHC-49718-56 | 7589640200 | 4975 Central Ave # 604, Gilbert, AZ, 85201 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more |
| ENR-104515 | ENR | David Q Hall | 1947-06-04 | UHC-32874-59 | — | 766 Central Ave, Denver, CO, 80252 | 0.48 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more |
| ENR-110462 | ENR | Cynthia I Lucas | 1964-12-23 | UHC-72108-02 | 4202361988 | 64 Indian School Rd, Minneapolis, MN, 55436 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-118369 | ENR | Theresa Kelly | 1950-01-02 | UHC-26103-49 | 6876560179 | 1014 Hillcrest Rd, San Diego, CA, 92124 | 0.48 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-142426 | ENR | George T Miller | 1950-12-18 | UHC-23025-90 | 2897008779 | 2078 Grand Ave, Columbus, OH, 43286 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-107845 | ENR | Victoria Luna | 1947-05-10 | UHC-75189-78 | — | 7581 Willow Ct, Mesa, AZ, 85298 | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more |
| ENR-108023 | ENR | Adam Contraras | 1973-04-05 | UHC-75072-26 | 2844825112 | 5706 Indian School Rd, Plano, TX, 75091 | 0.48 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-128807 | ENR | Rebecca Fox | 2000-04-23 | UHC-17190-79 | — | 9718 Main St, Fresno, CA, 93789 | 0.48 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-100794 | ENR | Brandon R Bryant | 1980-12-13 | UHC-78047-95 | 9533400231 | 2086 Maple Ave, Atlanta, GA, 30342 | 0.48 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-124395 | ENR | Russell C Murphy | — | UHC-65080-58 | 7742284369 | 3490 Hillcrest Rd, Las Vegas, NV, 89141 | 0.48 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| ENR-140491 | ENR | Kimberly F Wang | 1988-01-05 | UHC-99271-57 | 9326759001 | 935 Jefferson Ave, Sacramento, CA, 95809 | 0.48 | Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more |
| ENR-136931 | ENR | Ana N Cook | — | UHC-77205-44 | 5818258142 | 8193 Ridge Rd, Tempe, AZ, 85251 | 0.48 | Name re-casedDate of birth missingPhone reformattedSSN last four extracted+4 more |
| ENR-136215 | ENR | Amber N Lee | 2004-04-08 | UHC-32742-91 | 5362651559 | 8105 Desert Sky Blvd, San Diego, CA, 92184 | 0.48 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-106581 | ENR | Andrew Woods | 2001-06-02 | UHC-24692-84 | 7913240164 | 4197 Union St, Eden Prairie, MN, 55336 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |