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-112282 | ENR | Aisha P Burke | 1958-10-14 | UHC-98365-72 | 6749400075 | 6872 Palm Dr # 999, Nashville, TN, 37298 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-102816 | ENR | Andrew C Cooper | 1975-01-17 | UHC-60313-72 | 5254063091 | 7383 Bayshore Dr, Columbus, OH, 43269 | 0.52 | Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more |
| ENR-107028 | ENR | Elijah A Brooks | 1964-10-22 | UHC-25287-21 | 2769406433 | 2640 Baseline Rd Apt 25, Orlando, FL, 32829 | 0.52 | Two-digit birth yearPhone reformattedUnit split from streetGender normalised+2 more |
| ENR-107155 | ENR | Scott D Howard | 1989-08-10 | UHC-12674-72 | 6227219418 | 2527 Union St, Chandler, AZ | 0.52 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-126232 | ENR | Anthony G Hansen | 1963-05-16 | UHC-17160-06 | 7177672181 | 8380 Elm St, Orlando, FL | 0.52 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| ENR-107303 | ENR | Mari Nguyen | 2003-04-02 | UHC-01436-76 | 8202037758 | 4081 Willow Ct, Phoenix, AZ, 85030 | 0.52 | Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-109101 | ENR | Matthew K Montgomery | — | UHC-40390-81 | 9079446751 | 4920 Lake View Rd, Charlotte, NC, 28279 | 0.52 | Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-128398 | ENR | Jose A McCoy | 1991-07-07 | UHC-05379-73 | — | 2234 Ocean Ave, Columbus, OH, 43233 | 0.52 | Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| ENR-115215 | ENR | BJunk | 1966-06-21 | UHC-05736-04 | 4117308927 | 6799 Desert Sky Blvd, Jacksonville, FL, 32232 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-134688 | ENR | Roy A Lawrence | 1993-06-09 | UHC-96696-03 | 3749643075 | 1251 Main St, Dallas, TX | 0.52 | Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more |
| ENR-100817 | ENR | Danny Welch | 2003-10-02 | UHC-49645-12 | 7715285780 | 143 Ocean Ave, Mesa, AZ, 85239 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-114353 | ENR | Carl N Boyd | 1942-12-18 | UHC-08601-36 | — | 8407 Washington St, Mesa, AZ, 85269 | 0.52 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-105439 | ENR | Emily Q Rojas | 1973-08-11 | UHC-97762-04 | — | 3791 Baseline Rd, Mesa, AZ | 0.52 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-105587 | ENR | Jordan L Ross | — | UHC-47728-62 | 2939518374 | 8556 Market St, Eden Prairie, MN, 55365 | 0.52 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-140695 | ENR | Jule N Guerrero | 1976-02-13 | — | 9008893494 | 3375 Apache Blvd, Sacramento, CA, 95822 | 0.52 | Two-digit birth yearPhone reformattedSSN last four extractedEmail lower-cased+2 more |
| ENR-104470 | ENR | Janice Little | 1980-06-04 | UHC-10517-84 | 2215710456 | 1594 Indian School Rd, Las Vegas, NV, 89199 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-127678 | ENR | Brenda M Ray | 1980-05-09 | UHC-99155-76 | 2572142905 | 9660 Elm St, Mesa, AZ, 85232 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| ENR-126765 | ENR | Jean Martin | 1980-08-25 | UHC-24078-99 | — | 2678 Cedar Ln # 136, Columbus, OH, 43276 | 0.52 | Name re-casedPhone missing area codeUnit split from streetState name converted to code+2 more |
| ENR-128414 | ENR | Sophia Ray | 1999-10-03 | UHC-48513-75 | 7377922231 | 707 Valley View Dr # 825, Austin, TX | 0.52 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-136633 | ENR | JamesJunk | 1966-02-24 | UHC-52508-51 | — | 9781 Harbor Blvd, Phoenix, AZ | 0.52 | Name re-casedState name converted to codeZIP missingWhitespace trimmed+2 more |
| ENR-100847 | ENR | Sarah D Howell | 1966-05-27 | UHC-08662-71 | 2373550725 | 320 Main St, Austin, TX, 78751 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-118351 | ENR | Frances Kyng | 1988-05-04 | UHC-31602-81 | 5065820088 | 6888 Forest Ave, Tempe, AZ, 85254 | 0.52 | Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| ENR-109824 | ENR | Juan J Wong | 1992-03-15 | UHC-16504-57 | 7986465537 | 5751 Union St, Los Angeles, CA, 90043 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-139050 | ENR | Arthur Watkins | 1939-08-05 | UHC-78749-93 | — | 8530 Canyon Rd, Gilbert, AZ, 85272 | 0.52 | Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-137590 | ENR | William T Woong | 1980-05-15 | UHC-15878-72 | 4207455743 | 7700 Palm Dr Apt 8, Scottsdale, AZ, 85254 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more |
| ENR-137611 | ENR | Logaan Jimenez | 1974-10-24 | UHC-70338-30 | 2525023913 | 8893 Mesa Dr, San Antonio, TX | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-125341 | ENR | Judith Robertson | 1974-05-11 | UHC-96845-24 | — | 9604 Elm St Apt 14, Nashville, TN, 37268 | 0.52 | Name split from “Last, First”Date of birth reformattedUnit split from streetGender normalised+2 more |
| ENR-123998 | ENR | Tyler A Oliver | 1951-05-20 | UHC-51920-31 | — | 7954 Market St, Seattle, WA, 98173 | 0.52 | Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-123991 | ENR | Alan F Ward | 1981-08-20 | UHC-36246-03 | 9299486177 | 117 Mesa Dr, Dallas, TX, 75213 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-135489 | ENR | Marcus Ford | 1972-01-02 | UHC-07354-04 | 7046364739 | 4043 Washington St, Eden Prairie, MN, 55344 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-102705 | ENR | Raymond Scott | 1988-07-05 | UHC-74464-51 | 2233122221 | 7866 Lincoln Way Apt 16, Denver, CO, 80228 | 0.52 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-120023 | ENR | Kyle Harrison | 1967-05-15 | UHC-34852-96 | 6359648948 | 2106 Mountain View Dr, Gilbert, AZ, 85217 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedZIP+4 trimmed+2 more |
| ENR-105125 | ENR | Anthony X Jensen | — | UHC-85828-85 | 8413906782 | 4054 Church St, Tampa, FL, 33636 | 0.52 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-121504 | ENR | Valentina G Cunningham | 1969-08-28 | UHC-01564-71 | 4835649196 | 2965 Baseline Rd, Chandler, AZ, 85244 | 0.52 | Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-137007 | ENR | Beverly Gonzalez | 1995-11-24 | UHC-10930-89 | 4328947915 | 6102 Camelback Rd, Seattle, WA | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-142137 | ENR | Barbara Hernandez | 1942-08-22 | UHC-51058-65 | 8998436564 | 7256 River Rd, Glendale, AZ, 85347 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| ENR-109847 | ENR | Judy R Rose | 1991-12-22 | UHC-66936-96 | 4538850988 | 2851 Sunset Blvd, Minneapolis, MN, 55417 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-128107 | ENR | Jack Chavez | 1984-03-24 | UHC-35215-81 | 6542024061 | 2789 Baseline Rd, Eden Prairie, MN, 55379 | 0.52 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more |
| ENR-116489 | ENR | Janet Mason | 1993-12-07 | UHC-60080-69 | — | 5646 Highland Ave, Fresno, CA, 93769 | 0.52 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-141752 | ENR | Bruce Sandoval | 1945-12-02 | UHC-23741-56 | 5496220755 | 2479 Mesa Dr, Mesa, AZ, 85282 | 0.52 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| ENR-119802 | ENR | Danielle F Kelley | 2003-01-07 | UHC-50091-64 | 9042489215 | 3285 Forest Ave, Fresno, CA, 93715 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-124314 | ENR | Nick L Garrett | 1987-02-16 | UHC-58324-10 | 8963032558 | 8090 Lincoln Way # 428, Tucson, AZ, 85776 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-140984 | ENR | Carlos Thomas | 1984-08-16 | UHC-19784-35 | 3103077383 | 9622 Washington St, Charlotte, NC, 28270 | 0.52 | Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more |
| ENR-138991 | ENR | Tim Simmons | 1957-09-16 | UHC-07596-21 | 6864441659 | 4725 Ocean Ave, Orlando, FL, 32872 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-117899 | ENR | Ruth Brooks | 1962-11-18 | UHC-73684-25 | 4472187387 | 298 Church St, Denver, CO, 80237 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-138740 | ENR | Carol A Shaw | 2002-10-06 | UHC-74988-59 | 5447173992 | 1968 Willow Ct # 833, Orlando, FL, 32826 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-141305 | ENR | Charles Jimenez | 1946-02-17 | UHC-25702-22 | 9815565596 | 5023 River Rd # 250, Austin, TX, 78767 | 0.52 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-116552 | ENR | Charles Patel | 1997-03-15 | UHC-51142-35 | 7994562682 | 8381 Hillcrest Rd, Tempe, AZ, 85219 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-101642 | ENR | Bobby L Willis | 1977-09-23 | UHC-83718-05 | 6207256619 | 5788 Camelback Rd, Eden Prairie, MN, 55312 | 0.52 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| ENR-135294 | ENR | Paul Marquez | 1949-10-11 | UHC-66457-34 | — | 2834 Indian School Rd # 749, Tampa, FL, 33661 | 0.52 | Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+2 more |