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-110925 | ENR | Helen Spencer | 1939-09-05 | UHC-12971-42 | 3945372124 | 3371 Meadow Ln Apt 40, Orlando, FL, 32807 | 0.46 | Name re-casedPhone reformattedSSN last four extractedUnit split from street+5 more |
| ENR-118764 | ENR | Jeremy J Ortega | 2002-08-07 | UHC-18231-87 | 3009812935 | 4675 Indian School Rd, Charlotte, NC, 28278 | 0.46 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-139950 | ENR | Brandon M Hamilton | 1965-04-13 | UHC-11844-80 | 6679283938 | 8869 Mountain View Dr, Tucson, AZ | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-119744 | ENR | Laura Watkins | 1961-02-15 | UHC-86062-54 | 2947284413 | 2762 Willow Ct Apt 17, Mesa, AZ, 85231 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-113079 | ENR | Katherine B Larson | 1972-09-17 | UHC-24304-50 | 4912407045 | 4444 Main St, Los Angeles, CA | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-123016 | ENR | Melissa Hart | 1959-12-19 | — | 5719269051 | 1003 Apache Blvd, San Diego, CA, 92175 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-124183 | ENR | Santiago Z Dominguez | 1963-04-09 | UHC-05052-57 | 5992637780 | 9297 Forest Ave, Dallas, TX, 75214 | 0.46 | Name split from “Last, First”Phone reformattedMember ID reformattedSSN last four extracted+5 more |
| ENR-113586 | ENR | Julia S Nguyen | 1969-11-02 | UHC-27419-79 | 4658031478 | 5776 Meadow Ln Apt 20, Charlotte, NC, 28293 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-100026 | ENR | Nancy O Campbell | 1991-05-20 | UHC-10392-04 | 7332381159 | 3517 Baseline Rd # 391, Jacksonville, FL, 32266 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-102206 | ENR | Arthur N Mason | 1975-07-11 | UHC-95789-74 | 3373974367 | 5652 Jefferson Ave # 776, San Antonio, TX, 78266 | 0.46 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more |
| ENR-110807 | ENR | Kathleen Wganer | 1990-12-17 | UHC-97845-16 | 7716306860 | 9711 Spring St # 709, Tampa, FL, 33653 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-129468 | ENR | Tyler M Mason | — | UHC-65746-05 | 7276199688 | 4287 Union St, San Diego, CA, 92134 | 0.46 | Middle initial moved out of first nameName re-casedDate of birth missingPhone reformatted+5 more |
| ENR-127727 | ENR | Katherine V Wagner | 1962-05-06 | UHC-22531-13 | 7622018414 | 1301 Ocean Ave, Columbus, OH, 43273 | 0.46 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-136373 | ENR | Doris X James | 1957-05-03 | — | 5085601226 | 1527 Elm St, Plano, TX, 75087 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-134771 | ENR | Alan Smith | 2004-11-04 | UHC-62253-64 | 9226668786 | 8017 Highland Ave, Glendale, AZ, 85346 | 0.46 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+5 more |
| ENR-137757 | ENR | Ann Santiago | 1990-01-07 | UHC-72018-89 | 4313414103 | 4669 Main St, Glendale, AZ, 85338 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-122059 | ENR | Frank Weber | 1956-03-02 | UHC-60254-75 | 8028170414 | 3595 Valley View Dr, Glendale, AZ, 85311 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-120615 | ENR | Samantha Z Dunn | 1938-03-25 | UHC-02275-68 | 3393534169 | 627 Lake View Rd # 972, Tempe, AZ, 85298 | 0.46 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-127192 | ENR | Mary G Nunez | 1967-06-23 | UHC-30029-90 | 4078082756 | 326 Willow Ct, Houston, TX, 77049 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-115999 | ENR | Roy Mills | 1949-09-10 | UHC-24316-20 | 5212529707 | 1396 Union St, Sacramento, CA, 95803 | 0.46 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-129890 | ENR | Ana N Gilbert | 1979-03-17 | UHC-96425-46 | 3386953263 | 5440 Valley View Dr # 433, Austin, TX, 78725 | 0.46 | Name re-casedTwo-digit birth yearMember ID reformattedUnit split from street+5 more |
| ENR-129889 | ENR | Ana N Gilbert | 1979-03-17 | UHC-96425-46 | 3386953263 | 5440 Valley View Dr # 433, Austin, TX, 78725 | 0.46 | Name re-casedTwo-digit birth yearMember ID reformattedUnit split from street+5 more |
| ENR-101177 | ENR | Kenneth Valdez | 2007-03-07 | UHC-31713-51 | 8025418269 | 8917 Apache Blvd, Fresno, CA, 93719 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-112933 | ENR | Justin Warren | 1970-02-02 | UHC-50704-53 | 6902588402 | 6843 Mountain View Dr Apt 30, Glendale, AZ, 85350 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-134131 | ENR | Alexander N Marquez | 1978-08-01 | UHC-84217-49 | 6996762498 | 8121 Park Pl, Denver, CO, 80215 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-130849 | ENR | Ryan Howard | 1976-12-22 | UHC-33587-02 | 4484202585 | 6625 Market St, Dallas, TX, 75230 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-115906 | ENR | Lee V Joan | 1984-11-22 | UHC-28497-10 | 7964782947 | 7316 Elm St, San Antonio, TX, 78218 | 0.46 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-142576 | ENR | Zachary X Maldonado | 1967-10-02 | UHC-32396-94 | 3883900597 | 1940 Desert Sky Blvd Apt 7, Fresno, CA, 93714 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-107499 | ENR | Anna Q Carpenter | 1952-02-03 | UHC-11448-93 | 9069622013 | 5759 River Rd, Jacksonville, FL | 0.46 | Middle initial moved out of first nameName re-casedPhone reformattedMember ID reformatted+5 more |
| ENR-126029 | ENR | —Junk | 1959-09-06 | UHC-21710-99 | 7805907279 | 5221 Canyon Rd, Columbus, OH, 43297 | 0.46 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-117122 | ENR | Brian Peterson | 1984-01-16 | UHC-97293-31 | 6976198015 | 1670 Market St, Plano, TX, 75009 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-102855 | ENR | Bradley HJunk | 1987-08-15 | UHC-35169-53 | 8616957227 | 3152 Harbor Blvd, Atlanta, GA, 30325 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-102854 | ENR | Bradley HJunk | 1987-08-15 | UHC-35169-53 | 8616957227 | 3152 Harbor Blvd, Atlanta, GA, 30325 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-107565 | ENR | Debra G Patel | 1948-01-07 | UHC-55850-08 | 2388216340 | 3271 River Rd, Orlando, FL, 32835 | 0.46 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+5 more |
| ENR-114988 | ENR | Joshua Walsh | — | UHC-13971-36 | 5252764697 | 3202 Pine Dr, Denver, CO, 80286 | 0.46 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+5 more |
| ENR-105490 | ENR | Austin X Grant | 1947-04-20 | UHC-51653-67 | 2097630263 | 3805 Central Ave, Atlanta, GA | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |
| ENR-139138 | ENR | Keith T Herrera | 1956-03-18 | UHC-35510-37 | 2102088165 | 1213 Palm Dr, Plano, TX, 75043 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-108462 | ENR | DJunk | 1950-03-04 | UHC-22102-23 | — | 8121 Camelback Rd, Jacksonville, FL, 32223 | 0.46 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more |
| ENR-132165 | ENR | Heather Q Moreno | 1963-08-07 | UHC-49093-34 | 8734612717 | 2841 Lake View Rd, San Diego, CA, 92191 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-109432 | ENR | Richard R Medina | 1988-06-20 | UHC-01593-38 | 5669552739 | 9218 Highland Ave, Eden Prairie, MN | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-113870 | ENR | Juustin D Wevaer | 1975-01-26 | UHC-21503-23 | 2036835867 | 7373 Palm Dr, Sacramento, CA, 95870 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-108215 | ENR | Eugene P Freeman | 1938-02-14 | — | 2019155824 | 8811 Sage Ct, Scottsdale, AZ | 0.46 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more |
| ENR-118080 | ENR | Karen Gibson | 1976-02-21 | UHC-49708-56 | 5348288152 | 6786 Grand Ave Apt 2, Denver, CO, 80299 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-115287 | ENR | Roger J Chavez | 1990-11-09 | UHC-74003-19 | 3275114423 | 148 Jefferson Ave, Los Angeles, CA, 90077 | 0.46 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-136907 | ENR | Mei L Claark | 1987-03-09 | UHC-15546-20 | 7658962929 | 4102 Sunset Blvd, Glendale, AZ, 85329 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-101924 | ENR | Amanda E Walsh | 1965-11-10 | UHC-09751-10 | 7003584369 | 9882 Cedar Ln Apt 13, Orlando, FL | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-142550 | ENR | Jeffrey J Edwards | 1993-02-09 | UHC-98325-80 | 9718937258 | 4979 Bayshore Dr, Plano, TX, 75032 | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-113205 | ENR | Debra Rojas | 1943-07-15 | UHC-41714-20 | 7817565985 | 8068 Meadow Ln, Tampa, FL, 33688 | 0.46 | Date of birth reformattedPhone reformattedSSN last four extractedCity re-cased+5 more |
| ENR-116159 | ENR | Christopher A Rivera | 1982-06-16 | UHC-38401-49 | — | 7584 Grand Ave, Tucson, AZ | 0.46 | Member ID reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+5 more |
| ENR-110209 | ENR | Charles O Ellis | 1972-11-13 | UHC-01634-67 | 7657103637 | 9432 Church St, San Diego, CA, 92152 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |