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-108376 | ENR | William F Moreno | 1953-05-16 | UHC-32552-30 | 7122664779 | 4043 Jefferson Ave, Glendale, AZ, 85353 | 0.60 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-135457 | ENR | Brandon G Sanchez | 1949-12-04 | UHC-72460-94 | 9658622273 | 6448 Lake View Rd # 450, Tucson, AZ, 85765 | 0.60 | Name re-casedDate of birth reformattedUnit split from streetCity re-cased+4 more |
| ENR-138843 | ENR | Ryan Moore | 2005-12-02 | UHC-30429-82 | 2345312824 | 6150 Market St, Los Angeles, CA | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-105504 | ENR | Lawrence Harris | 2008-04-03 | UHC-52485-42 | 4144172685 | 2714 Elm St, Mesa, AZ, 85275 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-137161 | ENR | Noah Herrera | 1955-02-25 | UHC-36445-13 | 2652811140 | 6367 Market St, Denver, CO, 80200 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-122346 | ENR | Wasington C Walter | 1981-12-16 | UHC-34661-92 | — | 6312 Park Pl, Nashville, TN, 37285 | 0.60 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |
| ENR-127073 | ENR | Samuel Franklin | 1992-05-03 | UHC-56314-59 | 5207116506 | 2707 Washington St, Gilbert, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-126235 | ENR | Albert E Dean | 1990-11-20 | UHC-88054-86 | 5273213288 | 5601 Market St, Sacramento, CA, 95829 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| ENR-118559 | ENR | Denise X Warren | 1952-03-06 | UHC-93992-96 | 4016969677 | 747 Camelback Rd, Nashville, TN, 37229 | 0.60 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-129475 | ENR | Philip I Hanson | 1996-01-09 | UHC-81956-03 | 9847546213 | 4609 Spring St, Eden Prairie, MN, 55373 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| ENR-134826 | ENR | Frank McCoy | 1981-12-27 | UHC-92717-26 | 8769792749 | 4261 Union St # 245, Orlando, FL, 32828 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-100853 | ENR | Jeremy S Wilson | 1983-10-25 | UHC-59488-37 | 6244094160 | 4960 Grand Ave, Miami, FL, 33138 | 0.60 | Name re-casedPhone reformattedMember ID reformattedCity re-cased+4 more |
| ENR-117713 | ENR | Scott A Fuller | 1965-02-05 | UHC-05207-17 | 8076727536 | 7273 Mountain View Dr, Miami, FL, 33115 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-113539 | ENR | Aisha P Butler | 1971-04-13 | UHC-74011-36 | 5842846470 | 181 Maple Ave, Denver, CO, 80237 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-123913 | ENR | Diane Barnes | 1956-12-03 | UHC-78693-64 | 5219240164 | 3474 River Rd, Denver, CO, 80282 | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-104127 | ENR | Ronald F Crawford | 1981-11-13 | UHC-93325-15 | 2175870524 | 4226 Harbor Blvd, Glendale, AZ, 85385 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-127045 | ENR | Mary E Prike | 1946-09-18 | UHC-79267-93 | 5314924067 | 4950 Union St, San Antonio, TX, 78285 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+4 more |
| ENR-124825 | ENR | Denise V Garza | 1982-10-16 | UHC-77826-78 | 4135593814 | 7798 Central Ave, Phoenix, AZ, 85027 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-117702 | ENR | Ryan X Reid | 1964-08-10 | UHC-51919-52 | 5275583522 | 1384 Apache Blvd, Orlando, FL, 32877 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-101229 | ENR | Camila L Cruz | 1998-04-14 | UHC-36189-79 | 5088337527 | 3842 Ocean Ave, Atlanta, GA, 30346 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-132037 | ENR | Virginia Harper | 1971-08-20 | UHC-28583-58 | 7436664876 | 9462 Valley View Dr # 997, Glendale, AZ, 85387 | 0.60 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-109620 | ENR | Judy D Clark | 1983-12-04 | UHC-51036-46 | 8315794265 | 6401 Highland Ave, Glendale, AZ, 85334 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-143050 | ENR | Mateo V Simpson | 1998-02-15 | UHC-48188-73 | 9685961322 | 9683 Canyon Rd Apt 8, Minneapolis, MN, 55409 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-115344 | ENR | Marttha J Ramirez | 1997-05-05 | UHC-27227-35 | — | 9690 Valley View Dr, Los Angeles, CA, 90091 | 0.60 | Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+4 more |
| ENR-123360 | ENR | Olivia Duncan | 1983-01-27 | UHC-66759-58 | 2285278900 | 894 Mountain View Dr, Tampa, FL, 33658 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-134420 | ENR | Bryan Bradley | 1987-05-12 | UHC-56034-71 | 2126093209 | 5040 Oak St, Miami, FL | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-127358 | ENR | Adam Stewart | 1954-09-02 | UHC-00514-65 | 3346406936 | 7139 Oak St, Chandler, AZ, 85293 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-106872 | ENR | Keith Hernandez | 1998-11-21 | UHC-09533-29 | 4353518061 | 1394 Apache Blvd, Scottsdale, AZ, 85239 | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-140804 | ENR | Stephanie Mendez | 1980-03-02 | UHC-15957-27 | 7685738727 | 2954 Forest Ave, Las Vegas, NV | 0.60 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-105158 | ENR | Mark Z Fox | 1993-04-05 | UHC-45874-92 | 7479183905 | 1877 Indian School Rd, Atlanta, GA, 30302 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-118218 | ENR | Nathan Y Ryan | 1996-09-17 | UHC-40820-53 | 6078447520 | 8757 Desert Sky Blvd, Denver, CO, 80273 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-131615 | ENR | Linda B Chavez | 1994-09-26 | UHC-41372-85 | — | 5792 Valley View Dr, San Antonio, TX, 78238 | 0.60 | Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+4 more |
| ENR-113495 | ENR | Ramirez D Nicole | — | UHC-75032-76 | 6223696412 | 588 Ridge Rd, Tampa, FL, 33651 | 0.60 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| ENR-116339 | ENR | Robetr G Perkins | 1968-08-21 | UHC-94691-18 | 7489469741 | 782 Grand Ave, Houston, TX, 77076 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-134728 | ENR | Gregory Day | 1959-02-20 | UHC-38456-67 | 5348763142 | 195 Meadow Ln, Charlotte, NC | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-106250 | ENR | Jacob P Carr | 1969-11-15 | UHC-37195-05 | 4344197742 | 7246 Maple Ave, Seattle, WA, 98117 | 0.60 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-122528 | ENR | Sharon Q Delgado | 1991-11-24 | UHC-81716-07 | 7182563747 | 3990 Central Ave, Plano, TX, 75083 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-127464 | ENR | Ana Ortiz | 1959-05-28 | UHC-28766-26 | 6247425118 | 1779 Central Ave Apt 15, Atlanta, GA, 30336 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-116258 | ENR | Heather X Sims | 1986-06-13 | UHC-21954-04 | 7628443339 | 2595 Elm St, Austin, TX, 78756 | 0.60 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-132960 | ENR | Cheryl Munoz | 1971-07-19 | UHC-33442-68 | — | 2972 Union St, Chandler, AZ, 85205 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-112584 | ENR | Daniel E Lynch | 2001-05-17 | UHC-59668-42 | 3225507904 | 2820 Valley View Dr, Mesa, AZ, 85224 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-114446 | ENR | Hannah Sandoval | 2000-09-08 | UHC-26476-44 | 8996970636 | 9114 Grand Ave, Tucson, AZ, 85739 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-116149 | ENR | Logan P Soto | 1944-04-23 | UHC-78783-45 | 7958357007 | 7453 Maple Ave, Jacksonville, FL, 32295 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-114068 | ENR | Amber S Jimenez | 1983-11-10 | UHC-69635-02 | 4882439681 | 5374 Desert Sky Blvd, Austin, TX, 78718 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-128274 | ENR | Andrew R Reynolds | 1942-10-24 | UHC-72683-78 | 6032066749 | 4784 Willow Ct, Phoenix, AZ, 85072 | 0.60 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-131168 | ENR | Raymond Torres | 2007-03-02 | UHC-11215-39 | 6008236456 | 6610 Pine Dr, Austin, TX, 78714 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-123104 | ENR | Walter J Salazar | 1984-12-04 | UHC-43435-44 | 7329258370 | 150 Desert Sky Blvd Apt 11, Tampa, FL, 33665 | 0.60 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-128391 | ENR | Jon Murphy | 1988-04-25 | UHC-59517-51 | 6044703811 | 1540 Canyon Rd, Mesa, AZ, 85299 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-137359 | ENR | Linda Boyd | 1993-03-26 | UHC-33993-62 | 9213191642 | 3073 Highland Ave, Jacksonville, FL | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-110082 | ENR | Valentina A Price | 2004-04-24 | UHC-82856-79 | 6477209931 | 9812 Meadow Ln, Phoenix, AZ, 85032 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |