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-111713 | ENR | Michelle Bowman | 1947-11-06 | UHC-20763-80 | 3252942988 | 8737 Ridge Rd, Austin, TX, 78747 | 0.46 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more |
| PRV-20652 | PRV | Harold G Singh | 1949-12-22 | — | 5817802635 | 7435 Lake View Rd, San Antonio, TX, 78285 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| CLM-401362 | CLM | Cheryl Chen | 1997-10-27 | UHC-19223-34 | 3213310797 | 3073 Park Pl, Plano, TX, 75093 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-132289 | ENR | Tyler Broosk | 1994-09-10 | UHC-33688-95 | 6848392067 | 8696 Grand Ave, Charlotte, NC, 28262 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| PRV-26178 | PRV | Beverly Z Soto | — | UHC-36735-65 | 2823367123 | 5451 Camelback Rd, Fresno, CA | 0.46 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more |
| ENR-124097 | ENR | Emily Boyd | 1998-06-24 | UHC-29831-34 | — | 547 Willow Ct, Tucson, AZ | 0.46 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more |
| ENR-142920 | ENR | Pamela Gibson | 1970-11-19 | UHC-30740-55 | 3713686572 | 4351 Hillcrest Rd, Glendale, AZ | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| CLM-403949 | CLM | John W Perkins | 1943-11-03 | UHC-89638-37 | 2463731624 | 9781 Harbor Blvd Apt 1, Houston, TX | 0.46 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| CLM-420194 | CLM | Benjamin W Wood | 1948-01-20 | — | 5985588953 | 9764 Pine Dr, Charlotte, NC, 28293 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-126744 | ENR | Melissa Ramos | 2002-06-10 | UHC-99031-01 | 8763769108 | 7751 Bayshore Dr, Chandler, AZ, 85233 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-101232 | ENR | John Z Taylor | 1971-08-28 | UHC-19378-10 | 4673857651 | 8613 Washington St, Atlanta, GA, 30374 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-117366 | ENR | Martin Philip | 1959-12-27 | UHC-41017-34 | 2937186556 | 8416 Jefferson Ave, Jacksonville, FL, 32266 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more |
| ENR-125200 | ENR | Jason B Garrett | 1947-05-05 | UHC-10837-58 | 8519954500 | 3428 Highland Ave, Austin, TX, 78767 | 0.46 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more |
| CLM-422936 | CLM | Susan X Webb | 1952-10-06 | — | — | 2347 Lincoln Way # 613, Eden Prairie, MN, 55390 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| CLM-415050 | CLM | Vincent Gutierrez | 1979-05-28 | — | 6807536539 | 4765 Hillcrest Rd, Sacramento, CA, 95899 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| TPA-60197 | TPA | Sean Webb | 2001-10-08 | — | 8102179880 | 3689 Willow Ct, Tucson, AZ, 85768 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-129857 | ENR | Emily E Obrien | 2007-07-06 | UHC-25966-27 | 3733177257 | 3702 Elm St, Los Angeles, CA, 90067 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-117239 | ENR | Sarah S Hansen | 1960-08-17 | UHC-44827-08 | — | 4346 Cedar Ln, Las Vegas, NV, 89184 | 0.46 | Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+5 more |
| ENR-141812 | ENR | Arthur I Simpson | 1989-03-06 | UHC-42939-64 | 9104017402 | 7971 Indian School Rd, Dallas, TX, 75222 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| PRV-29125 | PRV | Arjun X Crawford | — | UHC-35273-61 | 4133761866 | 8223 Highland Ave, Eden Prairie, MN, 55372 | 0.46 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+5 more |
| CLM-432158 | CLM | Amber A Greene | 1989-06-27 | — | 2667403546 | 239 Oak St, Scottsdale, AZ, 85290 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| PRV-25939 | PRV | Kayla Richards | 1976-01-10 | UHC-42568-66 | 2535320764 | 2779 Pine Dr, Dallas, TX, 75256 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| TPA-58786 | TPA | Kimberly Morrison | 1991-05-06 | UHC-31666-52 | 9112292031 | 6635 Palm Dr, Gilbert, AZ, 85239 | 0.46 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-108541 | ENR | Jordan L Cole | 1979-11-01 | UHC-83214-78 | 5794394335 | 4226 Spring St, Minneapolis, MN, 55459 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| PRV-22070 | PRV | Larry Myers | 2001-02-11 | — | 9599045305 | 6114 Church St, Atlanta, GA, 30327 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+5 more |
| CLM-429611 | CLM | Gary Graham | 1991-05-19 | UHC-98479-75 | — | 6136 Willow Ct, Los Angeles, CA, 90038 | 0.46 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-129620 | ENR | Patrick Castro | 2008-08-26 | UHC-51479-94 | 6542298143 | 1268 Washington St # 711, Fresno, CA, 93735 | 0.46 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-101300 | ENR | Diane I Washington | 1971-08-01 | UHC-22655-79 | 2037679231 | 6998 Bayshore Dr Apt 12, Plano, TX, 75068 | 0.46 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+5 more |
| ENR-142291 | ENR | Carl Q McCoy | — | UHC-91013-94 | 6098298021 | 6685 Sunset Blvd, Austin, TX, 78784 | 0.46 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more |
| ENR-103053 | ENR | Aisha O Hanson | 1946-05-24 | UHC-09335-84 | 7092804776 | 573 Bayshore Dr, Las Vegas, NV, 89119 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-102644 | ENR | Benjamin T Johnston | 1948-02-17 | UHC-90631-95 | 4976145415 | 5939 Cedar Ln, Orlando, FL | 0.46 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more |
| CLM-400401 | CLM | Payne Diego | 1962-04-18 | UHC-65200-03 | 7578067166 | 9440 Mountain View Dr # 763, Scottsdale, AZ, 85213 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| TPA-61296 | TPA | Timothy Lawrence | 1973-06-15 | UHC-34368-51 | 3344286808 | 5015 Park Pl, Tempe, AZ | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-111388 | ENR | Lori F Dominguez | 2000-09-04 | UHC-82440-56 | 9458088602 | 730 Sage Ct, Miami, FL | 0.46 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+5 more |
| TPA-59180 | TPA | Elizabeth Schultz | 1967-12-24 | — | 9066673297 | 9384 Pine Dr, Fresno, CA, 93758 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-127101 | ENR | Nicholas Clark | 1963-11-09 | UHC-59054-98 | 5335782541 | 7847 Highland Ave, San Diego, CA | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-119007 | ENR | Donna Jacobs | 1980-04-28 | UHC-93706-58 | 2157237645 | 1474 Hillcrest Rd Apt 37, Gilbert, AZ, 85224 | 0.46 | Name re-casedPhone reformattedSSN last four extractedUnit split from street+5 more |
| ENR-133600 | ENR | Daniel A Ortiz | 2005-03-05 | UHC-04338-14 | 8989372565 | 6892 Mesa Dr, Gilbert, AZ, 85208 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| TPA-51925 | TPA | Gloria V Ortega | 2007-02-20 | — | 6256642450 | 4707 Highland Ave, Tempe, AZ, 85252 | 0.46 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more |
| PRV-23521 | PRV | Beverly Z Harrison | 1962-03-11 | UHC-76087-44 | 4336407608 | 8994 Cedar Ln, Sacramento, CA, 95836 | 0.46 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedMember ID reformatted+5 more |
| PRV-23232 | PRV | Virginia A Lynch | 2002-12-21 | UHC-46988-53 | 5415557444 | 8501 Valley View Dr, Atlanta, GA, 30374 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-407419 | CLM | Rachel O Mnoz | 2004-03-17 | UHC-15937-04 | 8985084666 | 7646 Bayshore Dr, Eden Prairie, MN, 55307 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-132828 | ENR | Joshua Gray | 1994-04-12 | UHC-40679-05 | 8249883339 | 1373 Lincoln Way # 696, Sacramento, CA, 95872 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more |
| ENR-130831 | ENR | Mary L Reed | 1962-05-05 | UHC-27530-28 | 2619382756 | 1552 Jefferson Ave Apt 28, San Diego, CA, 92185 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-103847 | ENR | Kimberly A Butler | 1938-02-21 | UHC-78911-70 | 5695767545 | 8151 Mesa Dr Apt 15, Seattle, WA, 98180 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-131212 | ENR | Samantha Y Delgado | 1956-05-27 | UHC-63618-43 | 5457180927 | 2868 Apache Blvd, Scottsdale, AZ | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-119280 | ENR | Brittany N Harveey | 1969-03-05 | UHC-61789-32 | 4628849703 | 862 Willow Ct, Tempe, AZ | 0.46 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+5 more |
| TPA-55353 | TPA | Brittany Fowler | 1995-11-07 | — | 2982697516 | 3562 Apache Blvd, Austin, TX, 78742 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| CLM-430138 | CLM | Ronald Butler | — | UHC-23449-92 | 8394708174 | 6971 Lake View Rd, Las Vegas, NV, 89162 | 0.46 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more |
| CLM-416622 | CLM | Wayne Bailey | 2007-07-10 | — | 7077290054 | 8816 Forest Ave Apt 19, Phoenix, AZ | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |