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-128258 | ENR | Judy H Holmes | 1956-02-24 | UHC-57040-55 | 4867030099 | 5051 Mesa Dr, Orlando, FL, 32822 | 0.48 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-108449 | ENR | Wei E Nelson | 1998-12-11 | UHC-33550-60 | 9702606900 | 139 Main St, Minneapolis, MN, 55488 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-108181 | ENR | Peter S Cox | 1954-07-02 | UHC-84520-28 | 2525044820 | 9161 Baseline Rd, Tucson, AZ, 85760 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-126606 | ENR | Beverly I Baker | 1997-08-08 | UHC-69779-08 | — | 5700 Maple Ave # 597, Atlanta, GA | 0.48 | Name re-casedDate of birth reformattedUnit split from streetCity re-cased+4 more |
| ENR-141875 | ENR | John P White | 1999-05-07 | UHC-30249-93 | 4295284389 | 8455 Market St, Atlanta, GA, 30381 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-134718 | ENR | Kathleen Y Soto | 2002-08-13 | UHC-94654-92 | 4098981119 | 6214 Highland Ave, Columbus, OH, 43214 | 0.48 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-129395 | ENR | Amanda Brooks | 1966-05-17 | UHC-53265-89 | 3354943327 | 497 Canyon Rd, Nashville, TN | 0.48 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-124610 | ENR | George E Shaw | 1984-10-02 | UHC-36004-77 | — | 6572 Bayshore Dr, Tucson, AZ, 85780 | 0.48 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-125551 | ENR | Ethan A Wilson | 2008-04-09 | UHC-71543-29 | 6583609723 | 9614 Sunset Blvd, Austin, TX, 78714 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-142111 | ENR | William U Wells | 1996-06-27 | UHC-43805-72 | 9375878321 | 4905 Lake View Rd Apt 24, Phoenix, AZ | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-104396 | ENR | Brian Vazquez | 1997-04-17 | UHC-47957-28 | 2274042354 | 700 Willow Ct, Houston, TX, 77034 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-136561 | ENR | Charlotte B Riley | 2007-01-23 | UHC-92624-92 | 6864994338 | 355 Valley View Dr, Tucson, AZ, 85782 | 0.48 | Middle initial moved out of first nameName re-casedMember ID reformattedStreet suffix standardised+4 more |
| ENR-121607 | ENR | Terry Nunez | 1975-12-04 | UHC-45934-01 | 3813945129 | 4095 Main St, Phoenix, AZ, 85099 | 0.48 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more |
| ENR-141779 | ENR | Sara McCoy | 1938-02-24 | UHC-49462-80 | 8255562765 | 7050 Forest Ave Apt 25, Charlotte, NC, 28281 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-103192 | ENR | Deborah D Lopez | 1956-08-23 | UHC-90944-87 | 3793733950 | 8762 Ridge Rd, Austin, TX, 78791 | 0.48 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more |
| ENR-132449 | ENR | Andrew I Hunt | 2006-10-23 | UHC-82931-32 | 5568174802 | 3243 Church St Apt 21, Dallas, TX, 75260 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-132448 | ENR | Andrew I Hunt | 2006-10-23 | UHC-82931-32 | 5568174802 | 3243 Church St Apt 21, Dallas, TX, 75260 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-124450 | ENR | Gloria T Berry | 2008-08-04 | UHC-91554-58 | 7644499555 | 5979 Sage Ct, Mesa, AZ, 85216 | 0.48 | Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more |
| ENR-127492 | ENR | Chris L Castro | 2005-02-27 | UHC-53454-40 | — | 1841 Maple Ave, Las Vegas, NV, 89108 | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-133012 | ENR | Scott R Griffin | 1945-02-21 | UHC-41956-45 | — | 7211 Main St, Tempe, AZ | 0.48 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-129761 | ENR | Edward L Jenkins | 1970-06-11 | UHC-81374-07 | 6214437611 | 7960 River Rd Apt 20, Minneapolis, MN, 55478 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-120430 | ENR | CJunk | — | UHC-84757-69 | 5728034951 | 7108 Park Pl, Gilbert, AZ, 85204 | 0.48 | Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-114854 | ENR | Megan Brown | 1999-05-07 | UHC-23638-95 | 7673777536 | 6811 Grand Ave, Tempe, AZ | 0.48 | Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-142457 | ENR | Peter Taylor | 1950-09-15 | UHC-71038-41 | 7474108829 | 7689 Jefferson Ave # 374, Austin, TX, 78739 | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-134047 | ENR | David C Jacobs | 1999-01-03 | UHC-26875-93 | 2904286809 | 9035 Central Ave Apt 5, Seattle, WA, 98193 | 0.48 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-117891 | ENR | Ralph B Freeman | 1952-05-12 | UHC-01462-05 | 7995338931 | 4907 Mesa Dr, San Antonio, TX, 78269 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-115202 | ENR | Danielle Tucker | — | UHC-36926-50 | 9653882432 | 5004 Church St, San Antonio, TX, 78223 | 0.48 | Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more |
| ENR-124525 | ENR | James Ford | 1987-08-05 | UHC-80014-49 | 9278219832 | 5669 Elm St # 263, San Antonio, TX, 78233 | 0.48 | Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-128745 | ENR | Douglas G Soto | 1984-12-21 | UHC-83412-14 | 3118176795 | 5646 Canyon Rd, Fresno, CA, 93708 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-102350 | ENR | Matthew Y Gbison | 1973-03-05 | UHC-41424-77 | 3612678988 | 7642 Market St, Sacramento, CA, 95816 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-131517 | ENR | Roger Andrews | 1987-03-28 | UHC-96921-49 | 3558967732 | 6929 Palm Dr, Miami, FL, 33152 | 0.48 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-127187 | ENR | Anna H Santos | 1975-12-04 | UHC-15152-91 | 8695710303 | 6959 Desert Sky Blvd, Gilbert, AZ, 85234 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-125047 | ENR | Kyle Tran | — | UHC-53619-59 | 4514110427 | 4149 Willow Ct, Eden Prairie, MN, 55321 | 0.48 | Name re-casedDate of birth missingMember ID reformattedStreet suffix standardised+4 more |
| ENR-110310 | ENR | Roger X Stephens | 1991-01-11 | UHC-94066-98 | 9248808854 | 8151 Indian School Rd, Jacksonville, FL, 32282 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-120111 | ENR | Keith J Scott | 1999-07-09 | UHC-99761-49 | 9847610668 | 9133 Canyon Rd, San Antonio, TX | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-124811 | ENR | Donna C Kelley | 1998-05-24 | UHC-99118-77 | 7537095343 | 719 Highland Ave Apt 28, Fresno, CA | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-118230 | ENR | Christian R Sanders | 1966-12-19 | UHC-91645-49 | 3813776241 | 1092 Park Pl, Tucson, AZ, 85781 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-133825 | ENR | Richard Alvarez | 1952-08-20 | — | 2852452763 | 7885 Sunset Blvd, Phoenix, AZ, 85080 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-109839 | ENR | Donald D Watkins | 1974-01-14 | UHC-53110-97 | 2365744188 | 7620 Main St # 488, Houston, TX, 77082 | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-109605 | ENR | Victoria Reyes | 1996-12-06 | UHC-54437-63 | — | 3615 Valley View Dr, Miami, FL, 33107 | 0.48 | Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+4 more |
| ENR-103580 | ENR | Ashley Morrison | 1978-09-28 | UHC-52293-35 | 4759023644 | 3220 River Rd Apt 19, Columbus, OH | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-112905 | ENR | Charlotte P Parker | 1998-09-07 | UHC-15367-54 | 6489424426 | 15 Highland Ave # 871, Gilbert, AZ, 85272 | 0.48 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-112904 | ENR | Charlotte P Parker | 1998-09-07 | UHC-15367-54 | 6489424426 | 15 Highland Ave # 871, Gilbert, AZ, 85272 | 0.48 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-104090 | ENR | Isabella Webbb | — | UHC-38239-88 | 7976626723 | 2462 Spring St, Phoenix, AZ, 85039 | 0.48 | Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-118189 | ENR | Kathryn X Sims | 1967-11-06 | UHC-39197-67 | 9753018836 | 9716 River Rd Apt 17, Minneapolis, MN | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-121422 | ENR | Maria EJunk | 2006-10-09 | UHC-06607-37 | 4432473553 | 5649 Elm St # 350, Eden Prairie, MN, 55345 | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-117019 | ENR | Melissa Gonzalez | 1975-01-07 | UHC-79439-98 | 4406958139 | 546 Forest Ave, Denver, CO, 80252 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-116515 | ENR | Ronald L Sanders | 1984-07-24 | UHC-95380-54 | 2254638035 | 4342 Church St # 667, Minneapolis, MN, 55407 | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-136634 | ENR | Isabella Robertson | 1988-01-02 | UHC-25638-63 | 3447784951 | 4127 Lake View Rd # 279, San Diego, CA | 0.48 | Name re-casedPhone reformattedUnit split from streetZIP missing+4 more |
| ENR-123234 | ENR | Jones Brian | 1959-10-24 | UHC-05308-73 | 2994734601 | 2328 Pine Dr, San Antonio, TX, 78267 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |