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-122535 | ENR | Wayne E Morris | 1984-06-07 | UHC-85819-24 | — | 3686 Main St, Charlotte, NC, 28267 | 0.52 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-137698 | ENR | Patricia Coleman | 1958-05-18 | UHC-71949-76 | — | 6613 Apache Blvd, Atlanta, GA, 30344 | 0.52 | Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-112486 | ENR | Priya K Weber | 1977-01-08 | UHC-74953-20 | 6895453724 | 7071 Forest Ave Apt 21, Glendale, AZ, 85398 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more |
| ENR-108659 | ENR | Denise T Henderson | 1969-04-06 | UHC-14987-56 | 5205008740 | 5931 Jefferson Ave, Tampa, FL, 33611 | 0.52 | Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-111392 | ENR | Emma I Kennedy | 2004-08-12 | UHC-01628-56 | 8555773381 | 3560 Hillcrest Rd, Scottsdale, AZ, 85204 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-129390 | ENR | Michelle I Pierce | 1994-12-08 | UHC-38324-33 | 3853574846 | 1752 Washington St, Gilbert, AZ | 0.52 | Name split from “Last, First”Phone reformattedMember ID reformattedZIP missing+2 more |
| ENR-120031 | ENR | Willie T Gonzales | 1977-08-26 | UHC-39002-37 | 7115087819 | 7499 Canyon Rd, San Antonio, TX, 78299 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-127459 | ENR | Jeremy Clark | 1978-02-18 | UHC-95821-87 | 7239183787 | 6975 Ridge Rd, Houston, TX, 77014 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-137767 | ENR | Natalie A Alvarez | 2001-11-26 | UHC-85005-33 | 3469463185 | 9730 Canyon Rd, Austin, TX, 78760 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-127232 | ENR | Marilyn Fernandez | 1945-10-12 | UHC-92069-19 | 2827025375 | 2694 Meadow Ln, Dallas, TX, 75251 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-128686 | ENR | Ethan L Jackson | 1954-04-10 | UHC-62313-89 | 5583013069 | 801 Main St, San Antonio, TX, 78269 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-112210 | ENR | Brian Bailey | 1953-03-26 | UHC-51571-55 | 8239601059 | 4358 Indian School Rd, Los Angeles, CA, 90033 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-138313 | ENR | Marcus Hudson | 1977-06-02 | UHC-54432-48 | 7177341686 | 4570 Oak St, Minneapolis, MN, 55467 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-101871 | ENR | Melissa D Cruz | 1996-09-15 | UHC-43441-53 | 7224673408 | 8804 Mesa Dr, Gilbert, AZ | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-142029 | ENR | Camila I Jensen | 1989-03-15 | UHC-92035-13 | — | 1928 Canyon Rd, Eden Prairie, MN, 55338 | 0.52 | Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-126279 | ENR | Andrew Morgan | 1955-09-21 | UHC-71082-16 | 4714407551 | 9628 Apache Blvd, Glendale, AZ, 85360 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-113603 | ENR | Abigail Y Martinez | 1967-03-08 | UHC-84886-97 | 7512522900 | 2815 River Rd, Mesa, AZ, 85212 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-127143 | ENR | Jack X Alvarez | 1998-07-06 | UHC-88924-15 | 3919448494 | 8357 Cedar Ln, Charlotte, NC, 28268 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-114650 | ENR | Diana G Boyd | 1955-04-18 | UHC-11471-55 | 6088262669 | 1473 Sage Ct, San Antonio, TX, 78290 | 0.52 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-107687 | ENR | Judith G Thompson | 1961-01-17 | UHC-57935-70 | — | 6875 Valley View Dr, Los Angeles, CA, 90020 | 0.52 | Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone missing area code+2 more |
| ENR-116624 | ENR | Priya P Morgan | 1945-08-17 | UHC-69874-28 | 7852782422 | 2195 Lake View Rd, Dallas, TX, 75209 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-125870 | ENR | Stephanie Ross | 1990-12-11 | UHC-04168-70 | 3362998489 | 1376 Ridge Rd, Jacksonville, FL, 32239 | 0.52 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-128101 | ENR | Roonald Guerrero | 1953-09-22 | UHC-63884-96 | 8149949320 | 8347 Market St, Scottsdale, AZ, 85262 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-118985 | ENR | Kenneth Y Holmes | 1945-05-17 | UHC-49321-66 | 9282680443 | 5668 Church St, Los Angeles, CA | 0.52 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-124319 | ENR | Jacqueline Mason | 1993-07-08 | UHC-70522-46 | 8082142473 | 5140 Cedar Ln Apt 8, Minneapolis, MN, 55456 | 0.52 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-127035 | ENR | Bruce J Wrigt | 1963-11-10 | UHC-57010-36 | 3139077538 | 1735 Sage Ct, Mesa, AZ, 85205 | 0.52 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-141062 | ENR | Russell F Schultz | — | UHC-35071-02 | 6498910779 | 4539 Market St, Scottsdale, AZ, 85227 | 0.52 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-121520 | ENR | Lisa H Rice | 1975-07-12 | UHC-13130-09 | — | 1330 Ridge Rd, Phoenix, AZ, 85094 | 0.52 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-119507 | ENR | Christina Ortega | 1971-07-03 | UHC-06273-61 | 4727478991 | 2874 River Rd, Tucson, AZ, 85765 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-129934 | ENR | Richard D Kim | 1945-09-14 | UHC-66923-36 | 3649112568 | 9847 Oak St, Dallas, TX, 75234 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-120342 | ENR | James X Fernandez | 1994-08-23 | UHC-25043-68 | 7185591945 | 8740 Palm Dr, Seattle, WA | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-114341 | ENR | Diane Lawson | 1992-01-09 | UHC-62696-54 | 5178300677 | 9198 Mesa Dr, Chandler, AZ, 85296 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-128341 | ENR | Donna T Aguilar | 1991-06-09 | UHC-53014-02 | 2775435026 | 3600 Central Ave, San Diego, CA, 92164 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-114824 | ENR | Omar V Thomas | 1983-02-04 | UHC-30987-31 | 5039744189 | 3899 Union St # 135, Eden Prairie, MN | 0.52 | Name re-casedPhone reformattedUnit split from streetCity re-cased+2 more |
| ENR-114872 | ENR | Mark G Hicks | 1970-05-20 | UHC-81141-15 | 7067717139 | 3440 Ocean Ave, Tucson, AZ, 85766 | 0.52 | Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+2 more |
| ENR-140942 | ENR | Helen O Warreen | — | UHC-83673-48 | 5239432068 | 2410 Sage Ct, Chandler, AZ, 85219 | 0.52 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-117584 | ENR | Michelle T Lee | 1954-10-11 | UHC-92235-70 | 2072131280 | 5375 Hillcrest Rd, San Antonio, TX | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-121928 | ENR | Albert G Stephens | 1949-04-17 | UHC-81418-55 | 2676682075 | 2513 Lake View Rd, Seattle, WA, 98163 | 0.52 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-100856 | ENR | Russell Cox | 1996-09-22 | UHC-24189-14 | 5238771508 | 4322 Market St, Jacksonville, FL, 32256 | 0.52 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| ENR-124630 | ENR | Jasno N Watson | 1999-06-27 | UHC-31272-97 | 4322193804 | 8344 Harbor Blvd # 141, Columbus, OH, 43282 | 0.52 | Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-131402 | ENR | Payne T Jerry | 2007-09-09 | UHC-08650-24 | 2464010636 | 8748 Harbor Blvd Apt 27, Denver, CO, 80283 | 0.52 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-133672 | ENR | Brian Davis | 1966-07-20 | UHC-04570-35 | — | 6652 Park Pl # 207, Jacksonville, FL, 32214 | 0.52 | Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-119271 | ENR | Mason L Alvarez | 1960-01-20 | UHC-46407-37 | — | 9794 Cedar Ln, Mesa, AZ, 85281 | 0.52 | Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more |
| ENR-119270 | ENR | Mason L Alvarez | 1960-01-20 | UHC-46407-37 | — | 9794 Cedar Ln, Mesa, AZ, 85281 | 0.52 | Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more |
| ENR-129459 | ENR | Marcus Ward | 2004-03-13 | UHC-17912-68 | 7955419368 | 6546 Jefferson Ave, Charlotte, NC, 28231 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+2 more |
| ENR-113901 | ENR | Jennifer W Scott | 1990-10-11 | UHC-43086-65 | — | 3029 Market St, Sacramento, CA, 95839 | 0.52 | Name split from “Last, First”Phone missing area codeMember ID reformattedEmail lower-cased+2 more |
| ENR-129370 | ENR | Sarah U Kelley | 1946-09-03 | UHC-44030-41 | 7053860570 | 9831 Mountain View Dr Apt 13, Orlando, FL, 32802 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-139405 | ENR | Gary Chapman | 1981-02-12 | UHC-89611-35 | 6247951058 | 8674 Lake View Rd, San Diego, CA, 92145 | 0.52 | Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+2 more |
| ENR-107510 | ENR | Sadra Jackson | 1946-02-22 | UHC-13086-58 | — | 5992 Oak St Apt 20, Jacksonville, FL, 32207 | 0.52 | Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-124996 | ENR | Thomas Salazar | 1993-07-25 | UHC-08590-37 | 6516619342 | 7441 Valley View Dr, Austin, TX, 78755 | 0.52 | SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more |