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-101500 | ENR | Santiago L Freeman | 1970-08-14 | UHC-18981-37 | 6992151506 | 8797 Desert Sky Blvd # 706, Houston, TX, 77054 | 0.54 | Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more |
| ENR-142388 | ENR | Joyce B Tucker | 1950-08-04 | UHC-62211-22 | — | 3464 Valley View Dr, Los Angeles, CA, 90058 | 0.54 | Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+1 more |
| ENR-135941 | ENR | Brian F Thomas | 1956-12-02 | UHC-07672-91 | 8093837394 | 1654 Baseline Rd, Chandler, AZ, 85274 | 0.54 | Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more |
| ENR-127029 | ENR | Kevin Chen | 1994-04-03 | UHC-92993-91 | — | 4242 Forest Ave, Nashville, TN, 37216 | 0.54 | Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more |
| ENR-125818 | ENR | Frances I George | 1939-02-15 | UHC-23464-33 | 8102616775 | 4849 Lincoln Way, Minneapolis, MN | 0.54 | SSN last four extractedState name converted to codeZIP missingEmail lower-cased+1 more |
| ENR-106059 | ENR | Eugane W Tucker | — | UHC-26271-13 | 7955307172 | 9002 Maple Ave, Glendale, AZ, 85380 | 0.54 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| ENR-137381 | ENR | Freeman Diana | 2005-02-21 | UHC-59043-73 | 4383608815 | 8283 Ocean Ave, San Diego, CA | 0.54 | Name re-casedTwo-digit birth yearState name converted to codeZIP missing+1 more |
| ENR-117054 | ENR | Olivia Washington | 1982-05-10 | UHC-79196-55 | — | 4213 Lake View Rd, Glendale, AZ | 0.54 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more |
| ENR-107785 | ENR | Michael Reed | 1963-04-28 | UHC-36196-45 | 3323362758 | 4804 Sage Ct, Denver, CO | 0.54 | Phone reformattedState name converted to codeZIP missingGender normalised+1 more |
| ENR-142091 | ENR | David Green | 1962-05-06 | UHC-37765-37 | — | 3728 Jefferson Ave, Tucson, AZ, 85733 | 0.54 | Name re-casedTwo-digit birth yearState name converted to codeGender normalised+1 more |
| ENR-115177 | ENR | Noeh H Miller | 1962-11-10 | UHC-78031-25 | 5968760106 | 5151 Pine Dr, Glendale, AZ, 85396 | 0.54 | Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more |
| ENR-109103 | ENR | Nicole S Daniels | — | UHC-40675-56 | 4783734718 | 1019 Bayshore Dr, Nashville, TN, 37258 | 0.54 | Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+1 more |
| ENR-116584 | ENR | Austin Dean | 1970-06-23 | UHC-56519-58 | 8362932408 | 4643 Church St, San Diego, CA, 92176 | 0.54 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more |
| ENR-130963 | ENR | Brenda Q Allen | 1952-03-07 | UHC-73574-97 | 9175885664 | 2354 Apache Blvd, Atlanta, GA, 30345 | 0.54 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more |
| ENR-124789 | ENR | Bobby U Kelley | 1961-12-26 | UHC-42869-80 | — | 7569 Camelback Rd, Fresno, CA | 0.54 | Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+1 more |
| ENR-103002 | ENR | Frances Vargas | 1957-12-07 | UHC-44264-23 | 4286644373 | 6476 Maple Ave, Minneapolis, MN, 55480 | 0.54 | Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more |
| ENR-141927 | ENR | Diane Gonzalez | 1939-04-13 | UHC-47195-70 | 6669987737 | 1437 River Rd Apt 1, Miami, FL, 33156 | 0.54 | Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more |
| ENR-111616 | ENR | James Park | 2008-04-11 | UHC-67554-44 | 8294995123 | 5255 Church St Apt 20, Seattle, WA, 98113 | 0.54 | Unit split from streetState name converted to codeGender normalisedWhitespace trimmed+1 more |
| ENR-110869 | ENR | Jerry Oliver | 1986-02-24 | UHC-41721-67 | 3703964093 | 3207 Bayshore Dr, Fresno, CA, 93713 | 0.54 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| ENR-134483 | ENR | Philip Freeman | — | UHC-41323-38 | — | 3882 Central Ave, Phoenix, AZ | 0.54 | Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+1 more |
| ENR-108771 | ENR | Sarrah G Jams | 1984-12-20 | UHC-76376-81 | 3792469344 | 3221 Spring St, Atlanta, GA, 30381 | 0.54 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more |
| ENR-115661 | ENR | Albert L Luna | 1957-11-14 | UHC-70680-68 | 9658069568 | 908 Pine Dr, Columbus, OH, 43206 | 0.54 | Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more |
| ENR-132796 | ENR | Jacob Riley | 1943-04-26 | UHC-23169-11 | — | 1862 Hillcrest Rd, Seattle, WA, 98179 | 0.54 | Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+1 more |
| ENR-134321 | ENR | Barbara E Dunn | — | UHC-34994-98 | 4253954487 | 8620 Cedar Ln, Miami, FL, 33198 | 0.54 | Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+1 more |
| ENR-103102 | ENR | James K Welch | 1940-10-26 | UHC-63981-37 | 2538935806 | 2755 Canyon Rd, Austin, TX, 78771 | 0.54 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more |
| ENR-103103 | ENR | James K Welch | 1940-10-26 | UHC-63981-37 | 2538935806 | 2755 Canyon Rd, Austin, TX, 78771 | 0.54 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more |
| ENR-112016 | ENR | Gloria U Hofffman | 1978-12-18 | UHC-25518-91 | 9555756475 | 9333 Hillcrest Rd, Minneapolis, MN, 55493 | 0.54 | Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more |
| ENR-139213 | ENR | Joe Chen | 1947-11-23 | UHC-65483-46 | 2714842503 | 3130 Camelback Rd, Eden Prairie, MN, 55358 | 0.54 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more |
| ENR-109106 | ENR | Christine C Rojas | 1958-09-05 | UHC-29975-38 | 8212269940 | 9123 Spring St, Nashville, TN | 0.54 | Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+1 more |
| ENR-112500 | ENR | Marcus Howell | 1970-01-07 | UHC-10024-33 | — | 521 Mountain View Dr, Denver, CO, 80240 | 0.54 | Name re-casedPhone missing area codeMember ID reformattedState name converted to code+1 more |
| ENR-105844 | ENR | McDonald M Brittany | 1983-12-04 | UHC-98964-05 | 9199003356 | 9355 Willow Ct # 382, Atlanta, GA | 0.54 | Middle initial moved out of first nameDate of birth reformattedUnit split from streetZIP missing+1 more |
| ENR-140253 | ENR | Christian Gonzales | 1965-07-03 | UHC-94858-35 | 7919397589 | 457 Park Pl, Las Vegas, NV, 89119 | 0.54 | Name split from “Last, First”Phone reformattedState name converted to codeZIP+4 trimmed+1 more |
| ENR-120818 | ENR | Megan Ortiz | 1971-11-08 | UHC-52814-98 | — | 3042 Palm Dr, Columbus, OH, 43202 | 0.54 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more |
| ENR-102014 | ENR | Samantha Meyer | 1992-03-20 | UHC-98383-40 | 8155948815 | 8827 Main St, Chandler, AZ, 85240 | 0.54 | Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more |
| ENR-132940 | ENR | Ptaricia E Dominguez | 1990-10-19 | UHC-15071-60 | 4487713346 | 8768 Canyon Rd, Los Angeles, CA, 90034 | 0.54 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more |
| ENR-133930 | ENR | Gregory Weber | 1974-08-25 | UHC-50200-63 | 5018030549 | 4286 Church St # 935, Dallas, TX, 75272 | 0.54 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more |
| ENR-102050 | ENR | Vincent D Goerge | 1946-11-07 | UHC-32875-15 | 5577878361 | 2954 Lincoln Way # 206, Phoenix, AZ, 85029 | 0.54 | Phone reformattedUnit split from streetState name converted to codeGender normalised+1 more |
| ENR-102002 | ENR | Richard N James | 1952-10-02 | UHC-64647-08 | 8889976346 | 6005 Camelback Rd, Plano, TX, 75043 | 0.54 | Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more |
| ENR-114355 | ENR | Sarah Fernandez | — | UHC-46404-59 | 7394265314 | 3509 Willow Ct, Denver, CO | 0.54 | Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more |
| ENR-135730 | ENR | Catherine R Payne | 1963-09-07 | UHC-51686-10 | 6718456954 | 1795 Central Ave Apt 40, San Antonio, TX, 78229 | 0.54 | Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+1 more |
| ENR-135587 | ENR | Judith A Jenkins | 1971-08-10 | UHC-83319-71 | 8803860100 | 253 Highland Ave Apt 9, Phoenix, AZ, 85035 | 0.54 | Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more |
| ENR-115396 | ENR | Randy Z Maldonado | 1999-08-04 | UHC-32441-24 | 9193952834 | 5269 Church St # 762, Tucson, AZ, 85782 | 0.54 | Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more |
| ENR-141993 | ENR | Billy P Contreras | 1958-07-26 | UHC-74899-95 | 3096847475 | 556 Mountain View Dr Apt 19, Miami, FL, 33124 | 0.54 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+1 more |
| ENR-120664 | ENR | Jeffrey G Sullivan | 2001-12-17 | UHC-01818-10 | 4417322071 | 8471 Elm St, Houston, TX, 77054 | 0.54 | Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+1 more |
| ENR-117870 | ENR | Bobby Watson | 1949-06-19 | UHC-95185-49 | 5296779979 | 1172 Main St # 977, Denver, CO, 80204 | 0.54 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+1 more |
| ENR-115224 | ENR | Santiago L Miller | 1951-02-23 | UHC-98037-76 | 9432530574 | 963 Mountain View Dr, Sacramento, CA, 95893 | 0.54 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| ENR-142869 | ENR | Ahmed Q Hughes | 1976-07-24 | UHC-53596-51 | 2786303265 | 7300 Highland Ave, Dallas, TX, 75233 | 0.54 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more |
| ENR-116264 | ENR | Amebr G Lawson | 1962-09-26 | UHC-27031-71 | 9679214070 | 2988 Sunset Blvd, Orlando, FL, 32837 | 0.54 | Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more |
| ENR-119545 | ENR | Gloriia D Ramirez | 2008-09-21 | UHC-49725-20 | 6735669244 | 6554 Highland Ave # 803, Seattle, WA, 98133 | 0.54 | Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more |
| ENR-141966 | ENR | Anthonny Fields | 1940-01-11 | UHC-31593-83 | 6577355731 | 5442 Main St, Glendale, AZ, 85389 | 0.54 | Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+1 more |