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-110607 | ENR | Mark Cunningham | 1985-07-21 | UHC-57907-05 | 6224496832 | 5277 Park Pl, Scottsdale, AZ, 85225 | 0.52 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more |
| ENR-118161 | ENR | Jacob T Olson | 1974-05-07 | UHC-08496-94 | 7593862778 | 1616 Lake View Rd, Las Vegas, NV, 89131 | 0.52 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-130018 | ENR | Santiago Gibson | 2000-04-19 | UHC-15032-49 | 4796051313 | 9582 Willow Ct # 618, Houston, TX, 77050 | 0.52 | Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| ENR-117203 | ENR | Kelly L Guerrero | — | UHC-67014-51 | 3754796593 | 285 Cedar Ln, Tempe, AZ, 85206 | 0.52 | Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more |
| ENR-109613 | ENR | Michael J Bishop | 1994-10-07 | UHC-91419-82 | 8286672415 | 8711 Apache Blvd # 216, Los Angeles, CA, 90058 | 0.52 | Name re-casedPhone reformattedSSN last four extractedUnit split from street+2 more |
| ENR-102907 | ENR | Vincent Delgado | 1985-10-16 | UHC-73386-28 | 7657915969 | 8194 Mountain View Dr # 824, Orlando, FL, 32888 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-142878 | ENR | Hiroshi I Butler | 1966-04-03 | UHC-41564-73 | 3487174748 | 4742 Oak St, Denver, CO, 80231 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-115103 | ENR | Maggie Cruz | 2001-01-09 | UHC-61807-71 | — | 9104 Jefferson Ave, Glendale, AZ, 85353 | 0.52 | Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-115102 | ENR | Maggie Cruz | 2001-01-09 | UHC-61807-71 | — | 9104 Jefferson Ave, Glendale, AZ, 85353 | 0.52 | Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-102983 | ENR | Emily A George | 1964-04-20 | UHC-80583-22 | 2286135084 | 5984 Sunset Blvd, Plano, TX | 0.52 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-132999 | ENR | Brittany P Morales | 2003-09-13 | UHC-09344-34 | — | 1731 Park Pl, Chandler, AZ, 85233 | 0.52 | Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-118961 | ENR | Doris Aguilar | 1945-12-08 | UHC-72012-88 | 8156600352 | 7409 Mesa Dr, Jacksonville, FL, 32263 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| ENR-139256 | ENR | Nathan I Stephens | 1963-05-09 | UHC-96209-03 | 6594355969 | 4241 Mesa Dr, Minneapolis, MN | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-142229 | ENR | Kenneth E Gilbert | 1969-06-12 | UHC-30518-95 | 8777570094 | 3202 Canyon Rd, Glendale, AZ, 85367 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-138120 | ENR | Omar Q Reed | 1962-02-17 | UHC-46285-34 | — | 8059 Indian School Rd, Miami, FL, 33136 | 0.52 | Date of birth reformattedPhone missing area codeCity re-casedZIP+4 trimmed+2 more |
| ENR-113943 | ENR | Linda Martinez | 1953-09-17 | UHC-63238-73 | 3339614964 | 6116 Pine Dr Apt 30, Seattle, WA | 0.52 | Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-134776 | ENR | Jeremy F Contreras | 1948-03-15 | UHC-79282-02 | 2505650486 | 5889 Ocean Ave, Jacksonville, FL, 32201 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-116896 | ENR | Carol N Russell | 2000-08-10 | UHC-46311-72 | 6803131019 | 1060 Apache Blvd, Nashville, TN, 37221 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-120964 | ENR | Pamela B Rivera | 1959-06-01 | UHC-37756-28 | 6346029670 | 6476 Baseline Rd, Austin, TX | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-122117 | ENR | Gloria F Roberts | 1966-06-16 | UHC-36740-98 | — | 1681 Spring St, Austin, TX | 0.52 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-136973 | ENR | Rebecca K Ortiz | 1958-03-24 | UHC-50581-76 | 4757577059 | 6811 Harbor Blvd Apt 8, Phoenix, AZ, 85091 | 0.52 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-125644 | ENR | Jessica Hunt | 2001-05-01 | UHC-40668-92 | 8627860414 | 6736 Baseline Rd, Charlotte, NC | 0.52 | Phone reformattedState name converted to codeZIP missingGender normalised+2 more |
| ENR-142485 | ENR | Linda V Payne | 1993-12-06 | UHC-07120-79 | 8087800471 | 321 Mountain View Dr, Atlanta, GA, 30334 | 0.52 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| ENR-127296 | ENR | Doris Q Fowler | 1957-12-26 | UHC-45462-27 | 6243402078 | 9260 Apache Blvd, Minneapolis, MN, 55456 | 0.52 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-102385 | ENR | Lawrence X Young | 1953-09-03 | UHC-86523-36 | 4359361407 | 3964 Oak St Apt 3, Tucson, AZ, 85772 | 0.52 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-110247 | ENR | Virginia Cambell | 1960-05-26 | UHC-14615-21 | 2944303157 | 6558 Highland Ave, San Antonio, TX | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-103194 | ENR | Brittany N Wrgiht | 1946-05-25 | UHC-09549-37 | 3234081265 | 9086 Hillcrest Rd # 586, Miami, FL, 33101 | 0.52 | Phone reformattedUnit split from streetState name converted to codeEmail lower-cased+2 more |
| ENR-121567 | ENR | Christian Reid | 1972-02-24 | UHC-73377-60 | 6214125299 | 1703 Broadway, Miami, FL, 33157 | 0.52 | Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+2 more |
| ENR-111200 | ENR | Carroll K Roger | 1938-09-05 | UHC-33517-97 | 2234954526 | 5997 Lincoln Way, Plano, TX, 75033 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-140223 | ENR | Davis V Beverly | 1975-07-12 | UHC-26050-17 | 4556980357 | 3508 Grand Ave # 221, Dallas, TX, 75295 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-133913 | ENR | Bruce T Owens | 1947-01-12 | UHC-85462-64 | 9317172731 | 2822 Cedar Ln, Phoenix, AZ, 85080 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-103583 | ENR | Beverly T Santos | 1946-10-27 | UHC-54601-52 | 5796048510 | 3976 Baseline Rd, Sacramento, CA, 95811 | 0.52 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-122168 | ENR | Kevin N Reid | 1941-06-13 | UHC-59417-37 | 2734340725 | 7948 Meadow Ln, Scottsdale, AZ, 85232 | 0.52 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-120631 | ENR | Chris Valdez | 1942-10-24 | UHC-97505-59 | 4996053513 | 220 Pine Dr, Seattle, WA, 98107 | 0.52 | Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more |
| ENR-124253 | ENR | Ronald O Crawford | 1985-12-25 | UHC-84729-70 | 2114887181 | 3144 Market St Apt 9, San Antonio, TX, 78237 | 0.52 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-121593 | ENR | Anna F Bakar | 1944-10-27 | UHC-10154-58 | 7227887847 | 3705 Palm Dr, Chandler, AZ | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-127037 | ENR | Natalie Daniels | 1951-11-28 | UHC-39276-13 | 4798345221 | 5167 Ridge Rd, San Antonio, TX, 78271 | 0.52 | Name split from “Last, First”Date of birth reformattedState name converted to codeEmail lower-cased+2 more |
| ENR-127038 | ENR | Natalie Daniels | 1951-11-28 | UHC-39276-13 | 4798345221 | 5167 Ridge Rd, San Antonio, TX, 78271 | 0.52 | Name split from “Last, First”Date of birth reformattedState name converted to codeEmail lower-cased+2 more |
| ENR-110700 | ENR | Sarah Marshall | 1941-06-20 | UHC-65902-14 | 5417891031 | 4580 River Rd, Tucson, AZ, 85708 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| ENR-137444 | ENR | Isabella Murphy | 1957-02-06 | UHC-81397-53 | 2226476767 | 1338 Central Ave Apt 34, Columbus, OH, 43298 | 0.52 | Two-digit birth yearPhone reformattedSSN last four extractedUnit split from street+2 more |
| ENR-124974 | ENR | Lori Valdez | 1977-02-20 | UHC-27056-91 | 2942364855 | 5922 Palm Dr, San Diego, CA | 0.52 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-111848 | ENR | Diane A Simpson | 1972-09-27 | UHC-14389-58 | — | 366 Hillcrest Rd, Tempe, AZ, 85234 | 0.52 | Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-108892 | ENR | Elizabeth D Burton | 1988-07-18 | UHC-20589-20 | 8062450806 | 1311 Park Pl, Miami, FL, 33179 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-137234 | ENR | Eric Simmons | 1978-05-13 | UHC-98882-06 | 3534014020 | 4431 Lake View Rd, Tampa, FL, 33635 | 0.52 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-141989 | ENR | Theresa J Sims | 1984-01-16 | UHC-55226-19 | 5218851317 | 9244 Canyon Rd, Jacksonville, FL, 32261 | 0.52 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-126187 | ENR | Ronald Y Burton | 1938-12-05 | UHC-06575-07 | 6066131901 | 8308 Washington St, Denver, CO, 80243 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-142607 | ENR | Jason D Spencer | 1943-05-08 | UHC-03083-48 | — | 447 Washington St, Minneapolis, MN, 55409 | 0.52 | Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+2 more |
| ENR-116377 | ENR | Rebecca Pierce | 1997-01-17 | UHC-36404-38 | — | 3492 Forest Ave, Houston, TX, 77034 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone missing area codeCity re-cased+2 more |
| ENR-120404 | ENR | Diego U Schmidt | 1989-02-24 | UHC-25673-02 | 5554641793 | 6886 Forest Ave Apt 36, Miami, FL, 33187 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more |
| ENR-141469 | ENR | Deborah Barnes | 1978-07-21 | UHC-58944-23 | 6976447256 | 1318 Cedar Ln # 646, Dallas, TX, 75228 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |