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-123345 | ENR | Logan Yaang | 1967-09-12 | UHC-36471-89 | 8243758064 | 622 Main St, Chandler, AZ, 85220 | 0.52 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-142797 | ENR | Maria Perry | 1959-07-07 | UHC-21303-62 | 8904423563 | 7211 Lake View Rd, Scottsdale, AZ, 85256 | 0.52 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more |
| ENR-120722 | ENR | Richard L Sandoval | 1947-10-27 | UHC-66581-87 | 6922986423 | 7359 Harbor Blvd, San Diego, CA, 92107 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-101673 | ENR | Walter Rogers | 1947-10-27 | UHC-57013-99 | 9043472505 | 3505 Baseline Rd # 880, Miami, FL, 33187 | 0.52 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-135194 | ENR | Billy M Robertson | 2004-11-07 | UHC-17775-68 | 7932812018 | 1554 Grand Ave, Phoenix, AZ, 85023 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-130938 | ENR | Mason M Vasquze | 1952-12-01 | UHC-56594-06 | 6696404326 | 7154 Maple Ave, Los Angeles, CA, 90097 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-126815 | ENR | Mary M Garrett | 2007-12-22 | UHC-35643-74 | 3962112281 | 2645 Lake View Rd, Phoenix, AZ, 85018 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-129837 | ENR | Betty Saniago | 1938-02-07 | UHC-84720-46 | 9765280152 | 6786 Elm St, Columbus, OH | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-105058 | ENR | Mariana X Roberts | 2002-01-01 | UHC-17847-12 | 3285538730 | 3588 Meadow Ln Apt 12, San Antonio, TX, 78264 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+2 more |
| ENR-131858 | ENR | Keith Carroll | 1988-08-27 | UHC-89001-42 | 9754329905 | 3969 Apache Blvd, Tempe, AZ, 85202 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more |
| ENR-128683 | ENR | Joshua Watson | 1993-02-28 | UHC-01191-79 | 2228836876 | 2168 Elm St, Orlando, FL, 32848 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-130206 | ENR | Mary C Ferguson | 1953-05-16 | UHC-59478-04 | — | 9096 Park Pl, Atlanta, GA, 30358 | 0.52 | Name re-casedPhone missing area codeCity re-casedState name converted to code+2 more |
| ENR-114980 | ENR | Christina I Guzman | 1999-07-27 | UHC-18324-39 | 3049036070 | 3359 Cedar Ln, Scottsdale, AZ, 85253 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-127059 | ENR | Lucia Vega | 1962-02-03 | UHC-18096-62 | 3203449877 | 5744 Spring St # 598, Las Vegas, NV, 89168 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more |
| ENR-127524 | ENR | Cynthia B Vazquez | 1980-11-27 | UHC-10386-45 | 5608344257 | 8953 Spring St, Tucson, AZ, 85752 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-101748 | ENR | Andrea R McDonald | 1960-02-20 | UHC-37874-98 | 7022642104 | 6585 Park Pl, Nashville, TN, 37270 | 0.52 | Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more |
| ENR-114356 | ENR | Valentina C Ray | 2000-05-10 | UHC-34927-03 | 5616824492 | 3346 Sunset Blvd, Fresno, CA, 93750 | 0.52 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more |
| ENR-111507 | ENR | —Junk | 1997-08-09 | UHC-17258-15 | — | 7205 Central Ave, Nashville, TN, 37285 | 0.52 | Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| ENR-119694 | ENR | Christine Bishop | 1963-08-16 | UHC-37025-54 | 8687631462 | 3732 Indian School Rd Apt 25, San Antonio, TX, 78266 | 0.52 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-101494 | ENR | Justin Z Webb | 1940-03-22 | UHC-44043-41 | 3768172453 | 2138 Harbor Blvd, Austin, TX, 78748 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-126363 | ENR | Edward W Elliott | 1979-05-08 | UHC-33180-88 | 9205284936 | 2976 Park Pl, Tempe, AZ, 85230 | 0.52 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-112914 | ENR | Linda D Matthews | 2000-05-27 | UHC-60641-45 | 6432611762 | 5828 Baseline Rd, Tampa, FL, 33693 | 0.52 | Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+2 more |
| ENR-119768 | ENR | Chris Fuller | 1947-05-27 | UHC-77707-71 | 9128520357 | 7758 River Rd, Eden Prairie, MN | 0.52 | Phone reformattedState name converted to codeZIP missingEmail lower-cased+2 more |
| ENR-133734 | ENR | Ruth E Wheeler | 2007-03-13 | UHC-38169-95 | 6276220062 | 4468 Cedar Ln, Minneapolis, MN, 55429 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-128175 | ENR | Stephen V Rss | 2000-09-10 | UHC-97438-20 | 3278205147 | 1885 Grand Ave, Jacksonville, FL, 32290 | 0.52 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-120917 | ENR | Mei S Luna | 1959-07-22 | UHC-88565-33 | 3703387982 | 6214 Pine Dr, Dallas, TX | 0.52 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-109188 | ENR | Heather P Wagner | 1991-12-14 | UHC-68131-47 | 4473470816 | 4720 Canyon Rd, Miami, FL, 33174 | 0.52 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| ENR-107122 | ENR | Hannah G Garrett | 1993-01-09 | UHC-32176-42 | 6057650156 | 478 Sunset Blvd, Minneapolis, MN, 55493 | 0.52 | Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-100253 | ENR | Christopher Stevens | 1949-06-27 | UHC-34040-26 | 7467742832 | 1811 Lincoln Way, Las Vegas, NV, 89118 | 0.52 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-125637 | ENR | Noah C Elliott | 1946-12-04 | UHC-45140-04 | 3237519435 | 1201 Harbor Blvd, Columbus, OH, 43233 | 0.52 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-123126 | ENR | Gerald B Dixon | 1986-01-13 | UHC-04299-88 | 3423122740 | 2943 Central Ave, Las Vegas, NV, 89158 | 0.52 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-126397 | ENR | Abigail F Adams | — | UHC-47242-41 | 6588168171 | 9028 Spring St # 617, Glendale, AZ, 85370 | 0.52 | Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-138100 | ENR | Mason F Porter | 1965-02-15 | UHC-54272-63 | 9097807963 | 6442 Apache Blvd # 590, San Diego, CA, 92148 | 0.52 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-128811 | ENR | Katherine U Medina | 1965-01-25 | UHC-13206-38 | 8152649263 | 6551 Central Ave, Los Angeles, CA, 90051 | 0.52 | Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more |
| ENR-115793 | ENR | Maria Z Hoffman | 2004-02-01 | UHC-06277-65 | 4172852297 | 7344 Apache Blvd, Gilbert, AZ | 0.52 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-122272 | ENR | Ralph Q Montgomery | 1992-12-15 | UHC-35654-55 | 4525731815 | 4474 Sage Ct, Mesa, AZ | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| ENR-113404 | ENR | Julia Torres | 1983-06-06 | UHC-43531-71 | 4072293235 | 4613 Apache Blvd Apt 12, Eden Prairie, MN, 55320 | 0.52 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-107095 | ENR | Judith H Cooper | 1957-01-28 | UHC-10497-18 | 9665560317 | 6211 Palm Dr, Eden Prairie, MN, 55331 | 0.52 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-132330 | ENR | Shirley S Munooz | 1962-10-06 | UHC-28956-10 | 5358922463 | 9750 Sage Ct, Fresno, CA, 93795 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-115367 | ENR | Heather M Rodriguez | 1960-12-16 | UHC-35708-48 | 5688503537 | 5155 Highland Ave, Fresno, CA, 93718 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-110580 | ENR | Cheryl Daniels | 1966-01-28 | UHC-21002-42 | — | 1820 Jefferson Ave, Phoenix, AZ, 85091 | 0.52 | Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-119525 | ENR | Judy Y Taylor | 1981-09-10 | UHC-53339-84 | 8006054995 | 3763 Meadow Ln, San Antonio, TX, 78245 | 0.52 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-110299 | ENR | Abigal Murphy | 1975-04-26 | UHC-18664-98 | 6034992873 | 6723 Willow Ct, Austin, TX | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-135745 | ENR | Edward N Ellis | 1979-04-10 | UHC-04613-77 | 3896890798 | 4385 Broadway, Mesa, AZ, 85288 | 0.52 | Name split from “Last, First”Phone reformattedSSN last four extractedAddress re-cased+2 more |
| ENR-129018 | ENR | Keith P Jordan | — | UHC-51305-30 | 5119803661 | 2390 Ridge Rd, Mesa, AZ, 85264 | 0.52 | Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more |
| ENR-128964 | ENR | Megan Park | 1948-12-04 | UHC-97248-72 | 5642837294 | 3187 Maple Ave, Seattle, WA, 98184 | 0.52 | Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-107233 | ENR | Doris P Simmpson | 1998-05-10 | UHC-01495-37 | 7798106558 | 638 Hillcrest Rd, Seattle, WA, 98105 | 0.52 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-119066 | ENR | Carlos F Perry | 2003-05-14 | — | 5754178557 | 1213 Spring St Apt 1, San Antonio, TX, 78226 | 0.52 | Middle initial moved out of first nameUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-142477 | ENR | Jeremy G Scott | 1980-01-26 | UHC-34112-33 | — | 9678 Forest Ave, Dallas, TX, 75225 | 0.52 | Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more |
| ENR-142484 | ENR | Julie F Hall | — | UHC-83195-17 | 8863741924 | 1783 Union St, Jacksonville, FL, 32202 | 0.52 | Middle initial moved out of first nameDate of birth missingPhone reformattedStreet suffix standardised+2 more |