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-135369 | ENR | Sophia Rojas | 1998-05-10 | UHC-55388-52 | 3722518134 | 7059 Mesa Dr, Tempe, AZ, 85239 | 0.50 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-126861 | ENR | David B Rogers | 1950-12-15 | UHC-03997-69 | 6937497399 | 5317 Washington St Apt 22, Mesa, AZ, 85218 | 0.50 | Name re-casedDate of birth reformattedUnit split from streetCity re-cased+3 more |
| ENR-132083 | ENR | William Allen | 2006-07-18 | — | 8033117613 | 9630 Mountain View Dr, Miami, FL, 33163 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123963 | ENR | Isabella M Harper | 1952-12-28 | UHC-58378-71 | — | 6566 Cedar Ln Apt 35, Las Vegas, NV, 89133 | 0.50 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-105258 | ENR | Jack P Munoz | 1991-10-14 | UHC-15695-15 | 3212263400 | 6160 Forest Ave, Minneapolis, MN, 55496 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more |
| ENR-136078 | ENR | Kimberly Gordon | 2006-12-28 | UHC-89560-95 | 7845845260 | 88 Willow Ct Apt 12, Eden Prairie, MN, 55360 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more |
| ENR-126462 | ENR | Isabella Barnes | 2006-03-11 | UHC-66242-93 | 4086715531 | 1853 Oak St, Mesa, AZ | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-134514 | ENR | Bradley T Barnes | 1967-01-17 | UHC-82109-20 | 9392818172 | 6202 Meadow Ln, Austin, TX | 0.50 | Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-130800 | ENR | Jerry Webb | 1992-10-06 | UHC-72023-82 | 6563385071 | 6340 Apache Blvd, Charlotte, NC, 28259 | 0.50 | Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-128282 | ENR | Diana K Webb | 1967-05-27 | UHC-08113-64 | 7994065836 | 5776 Oak St, Scottsdale, AZ | 0.50 | Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-123351 | ENR | Thomas Larson | 1946-11-19 | UHC-97162-26 | 3114547369 | 8467 Mesa Dr Apt 11, Tempe, AZ, 85228 | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-138664 | ENR | Ryan Price | 1972-08-09 | UHC-22613-78 | 8555782591 | 6961 Market St, Mesa, AZ, 85290 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-119804 | ENR | Ronald Evans | 1987-01-25 | UHC-63870-54 | 2197587715 | 8732 Meadow Ln, Gilbert, AZ, 85296 | 0.50 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-104020 | ENR | Stephanie D Wells | 1982-03-03 | UHC-88362-40 | 9569168260 | 961 Pine Dr, Sacramento, CA, 95895 | 0.50 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-131118 | ENR | Matthew X Siimpson | 1997-11-10 | UHC-82576-60 | 7577750863 | 8156 Ridge Rd, Las Vegas, NV | 0.50 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-122204 | ENR | Michelle Chavez | 1992-04-26 | UHC-36979-40 | 7644180305 | 5832 Sunset Blvd, Scottsdale, AZ | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-115242 | ENR | Ahmed I Patel | — | UHC-86063-13 | 6123970918 | 7258 Apache Blvd, Austin, TX, 78766 | 0.50 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128987 | ENR | Jordan C Mitchell | 1995-11-27 | UHC-28654-53 | 3135680767 | 9584 Valley View Dr # 135, Scottsdale, AZ, 85224 | 0.50 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-139905 | ENR | Catherine J George | 1998-04-25 | UHC-90701-57 | 6532199948 | 5642 Church St Apt 28, Austin, TX | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-123761 | ENR | Donna Q Marquez | 1942-02-24 | UHC-23095-78 | 3948879379 | 6518 Cedar Ln, Miami, FL, 33163 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-108818 | ENR | Maria Robinson | 1962-12-03 | UHC-39058-94 | 2829200240 | 717 Grand Ave, Columbus, OH | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+3 more |
| ENR-135296 | ENR | Jessica Y Mejia | 2002-10-23 | UHC-87470-48 | 6846784659 | 7277 Meadow Ln Apt 37, Los Angeles, CA | 0.50 | Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-129963 | ENR | Angela D Carlson | 1968-09-22 | UHC-78453-72 | 7955642339 | 4333 Church St # 900, Seattle, WA, 98134 | 0.50 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-117404 | ENR | Keren Morrison | 2000-06-28 | UHC-23765-47 | 4764116775 | 5196 Cedar Ln, Miami, FL, 33141 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-102122 | ENR | Lori E Carlson | 1945-09-28 | UHC-83409-06 | 8613804519 | 2001 Elm St, Scottsdale, AZ, 85270 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-135110 | ENR | Debra A Andrews | 1971-11-10 | UHC-51903-21 | 8489119182 | 9658 River Rd, Dallas, TX | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-110822 | ENR | Tony L Torres | 1940-10-14 | UHC-59591-76 | 8453167535 | 6430 Palm Dr, Sacramento, CA, 95812 | 0.50 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-142281 | ENR | Justin Ortiz | 1979-01-21 | UHC-85757-15 | 2407956489 | 6818 Ridge Rd, Charlotte, NC, 28209 | 0.50 | Name split from “Last, First”Two-digit birth yearMember ID reformattedEmail lower-cased+3 more |
| ENR-117347 | ENR | Ann X Fields | 1946-01-03 | UHC-32591-81 | 2802824556 | 5259 Valley View Dr Apt 22, Tempe, AZ, 85241 | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-125215 | ENR | Angela E Murray | 2004-11-25 | UHC-17948-28 | 9422472957 | 53 Elm St, Nashville, TN, 37215 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100995 | ENR | Shirley Q Wiliamson | 1962-04-25 | UHC-89515-83 | 9466380048 | 4586 Church St, Tampa, FL, 33619 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121280 | ENR | Thomas E Harvey | 1977-10-25 | UHC-55914-02 | 9672293694 | 6330 Cedar Ln, Plano, TX, 75096 | 0.50 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112772 | ENR | Ralph T Mitchell | 1990-02-21 | UHC-17638-14 | 6095253763 | 3670 Spring St, Minneapolis, MN, 55402 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more |
| ENR-106670 | ENR | Sarah E Park | 1964-06-27 | UHC-57297-32 | 2248538438 | 1654 Church St, Atlanta, GA, 30343 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more |
| ENR-139046 | ENR | Kathryn I Wallace | 1991-04-10 | UHC-49905-75 | 6103310650 | 8278 Canyon Rd # 197, Jacksonville, FL, 32271 | 0.50 | Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+3 more |
| ENR-136587 | ENR | Kyle L Weber | 1987-08-09 | UHC-48005-03 | 9683645938 | 9279 Forest Ave, San Diego, CA, 92182 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-135532 | ENR | Priya Little | 1949-11-22 | UHC-53505-69 | 7528168242 | 9710 Desert Sky Blvd, Columbus, OH, 43213 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-129025 | ENR | Kenneth H Kelley | 2002-12-13 | UHC-23045-77 | 9177800729 | 6639 Harbor Blvd, Tempe, AZ | 0.50 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-136884 | ENR | Jack Bishop | 1943-04-02 | UHC-95340-02 | 4489283197 | 411 Washington St, San Antonio, TX, 78280 | 0.50 | Two-digit birth yearPhone reformattedCity re-casedState name converted to code+3 more |
| ENR-128976 | ENR | Lucia Stone | 1995-04-04 | UHC-78323-14 | 8965624143 | 2092 Bayshore Dr, Tempe, AZ, 85240 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-113426 | ENR | Jennifer J Nunez | 1981-07-17 | UHC-84002-20 | 4029078641 | 2821 Grand Ave, Eden Prairie, MN | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-111837 | ENR | Walter O Peterson | 1965-10-07 | UHC-30055-98 | 7395661763 | 4110 Spring St, Seattle, WA, 98144 | 0.50 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-127659 | ENR | Billy O Morris | 2002-09-27 | UHC-18091-66 | 8985323762 | 4614 Jefferson Ave, Denver, CO, 80274 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-121516 | ENR | Gregory M Payne | 1946-01-12 | UHC-68898-10 | 2447502625 | 9887 Valley View Dr # 775, Los Angeles, CA, 90064 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-110791 | ENR | MJunk | 1993-04-16 | UHC-59220-89 | 5092409310 | 2179 Pine Dr, Los Angeles, CA, 90073 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-105619 | ENR | Gary Welch | 1940-12-20 | UHC-29174-76 | 2667960060 | 2977 Main St # 237, Seattle, WA, 98151 | 0.50 | Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-138061 | ENR | Sophia F Carroll | 1994-02-22 | UHC-95494-80 | 6867873544 | 1654 Highland Ave, Miami, FL, 33187 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-134152 | ENR | Douglas R Woods | 1940-01-07 | UHC-42719-19 | 3723233546 | 2430 Elm St, Columbus, OH | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-106293 | ENR | Mateo V Perkins | 2004-11-20 | UHC-15495-94 | 3846192115 | 8531 Ridge Rd Apt 13, Nashville, TN, 37270 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-105366 | ENR | Carl Carpenter | 1950-12-14 | UHC-83740-01 | — | 8723 Central Ave, Sacramento, CA, 95845 | 0.50 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |