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
All sources, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| 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 |
| CLM-401590 | CLM | Gloria Chapman | 1945-07-20 | UHC-02870-23 | 6343153093 | 9217 Elm St, Phoenix, AZ | 0.46 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more |
| CLM-417542 | CLM | Jacob Cooper | 1976-06-10 | UHC-40451-39 | 9829574303 | 7873 Jefferson Ave # 788, San Diego, CA, 92167 | 0.46 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+5 more |
| CLM-422885 | CLM | Kimberly Hart | 1995-12-05 | UHC-93318-25 | 7012846521 | 6600 Indian School Rd, Tempe, AZ | 0.46 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-426522 | CLM | Steven Spencer | 1973-06-20 | — | 3259185673 | 7438 Cedar Ln, San Diego, CA | 0.46 | Name split from “Last, First”Date of birth reformattedPhone 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 |
| CLM-419153 | CLM | Terry Fernandez | 1985-03-27 | UHC-26247-59 | 7844308706 | 6649 Grand Ave, Jacksonville, FL | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+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 |
| PRV-20606 | PRV | Randy D Barnes | 2000-03-03 | UHC-19730-93 | 2408991504 | 429 Union St, Houston, TX, 77094 | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| CLM-408570 | CLM | Timothy Obrien | 1994-05-22 | UHC-68603-34 | 9698669011 | 631 Sunset Blvd, Mesa, AZ, 85232 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+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 |
| PRV-26078 | PRV | Anthony Riley | 1941-12-25 | UHC-65454-36 | 9096795110 | 6638 Willow Ct, Charlotte, NC | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+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 |
| PRV-24808 | PRV | Aaron Willis | 1992-01-26 | UHC-69925-56 | 3095902243 | 446 Grand Ave, Fresno, CA, 93747 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+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 |
| PRV-23537 | PRV | Kathleen Hill | 1999-03-18 | UHC-13926-37 | 2953858485 | 8010 Oak St, Fresno, CA, 93746 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+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 |
| TPA-60902 | TPA | Gabriel Phillips | 1980-01-03 | — | — | 5932 Sage Ct # 795, San Antonio, TX | 0.46 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+5 more |
| PRV-26271 | PRV | Victoria Estrada | 1995-09-18 | UHC-18975-43 | — | 1939 Park Pl Apt 19, Seattle, WA, 98124 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| PRV-26272 | PRV | Victoria Estrada | 1995-09-18 | UHC-18975-43 | — | 1939 Park Pl Apt 19, Seattle, WA, 98124 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| CLM-424363 | CLM | Charlotte T Turner | 1962-12-18 | UHC-11473-27 | 6139356098 | 7851 Union St Apt 20, Nashville, TN, 37271 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet 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 |
| CLM-421170 | CLM | Priya Ortega | 1998-10-25 | UHC-14105-31 | 4057265347 | 2401 Park Pl, Charlotte, NC, 28297 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-403522 | CLM | Marcus Nichols | 2004-08-26 | UHC-44150-48 | — | 7644 Ridge Rd, Minneapolis, MN, 55461 | 0.46 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-418559 | CLM | Lauen Graham | 1979-06-03 | UHC-12369-48 | 4347087361 | 7492 Jefferson Ave Apt 18, Scottsdale, AZ, 85207 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+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 |
| CLM-410539 | CLM | Janet Wood | — | UHC-90445-01 | 4788274782 | 230 Ocean Ave, Phoenix, AZ, 85070 | 0.46 | Name split from “Last, First”Date of birth unreadablePhone reformattedMember ID reformatted+5 more |
| CLM-430773 | CLM | Jose K Owens | 1982-09-22 | UHC-76682-96 | 2926537417 | 2057 Indian School Rd # 132, Seattle, WA, 98191 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+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 |
| CLM-424381 | CLM | Heather Brooks | 1978-07-08 | UHC-62227-54 | 8225878741 | 8233 Indian School Rd, Plano, TX | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+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 |
| TPA-53637 | TPA | Elizabeth Ramirez | 2002-01-11 | — | 4077875231 | 2787 Indian School Rd, Austin, TX, 78741 | 0.46 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+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 |
| CLM-432822 | CLM | Margaret Patel | 1991-06-28 | UHC-64158-82 | — | 6042 Hillcrest Rd Apt 27, Austin, TX | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |