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-117285 | ENR | Kevin Le | 1955-05-21 | UHC-36777-51 | — | 37 Park Pl, Austin, TX | 0.46 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+5 more |
| ENR-131465 | ENR | Charles G Perry | 1953-09-03 | UHC-24528-85 | 8819610904 | 3200 Mesa Dr, Glendale, AZ, 85307 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-114951 | ENR | Wei Young | — | UHC-83500-09 | 2738162623 | 3320 Sunset Blvd, Scottsdale, AZ, 85295 | 0.46 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+5 more |
| ENR-132091 | ENR | —Junk | 1954-10-10 | UHC-35421-78 | 9599179021 | 8938 Union St, Gilbert, AZ, 85212 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-130446 | ENR | Richard Hansen | 1959-10-08 | UHC-25477-10 | 3505892402 | 1452 Cedar Ln # 851, Nashville, TN, 37215 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-110645 | ENR | Randy Wood | 1981-05-19 | UHC-10379-19 | 7357520739 | 4592 Desert Sky Blvd, Glendale, AZ | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-104513 | ENR | Nancy V Santiago | 1977-01-19 | UHC-01581-34 | 8404222900 | 7831 Market St # 701, Las Vegas, NV, 89116 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-106681 | ENR | Luis Ramos | 1965-11-22 | UHC-28626-89 | 7892327072 | 8960 Apache Blvd, Minneapolis, MN | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-131725 | ENR | Frances O Watins | 1946-10-08 | UHC-87981-39 | 7625923138 | 983 Highland Ave, Orlando, FL, 32864 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-105682 | ENR | Brenda O Kelley | — | UHC-29633-02 | 2376015830 | 9588 Hillcrest Rd, Glendale, AZ | 0.46 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+5 more |
| ENR-129612 | ENR | Charlotte R Welch | — | UHC-86033-30 | 4717463433 | 3149 Cedar Ln, Plano, TX, 75039 | 0.46 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more |
| ENR-106713 | ENR | AJunk | 1961-10-25 | UHC-64703-56 | 4732937664 | 870 Market St, Orlando, FL, 32832 | 0.46 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-109862 | ENR | Carlos Hudson | 1945-12-01 | UHC-71677-01 | 9866245949 | 4734 Ocean Ave Apt 18, Las Vegas, NV | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-122403 | ENR | Amy V Espinoza | 1996-03-02 | UHC-22324-60 | 6385586027 | 3957 Sage Ct Apt 21, Dallas, TX, 75233 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more |
| ENR-103805 | ENR | Tony B Gilbert | 1968-05-02 | UHC-97232-04 | 8368966269 | 6768 Church St, Los Angeles, CA, 90038 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-112479 | ENR | Jacqueline S Gonzales | 1967-01-28 | UHC-45582-20 | 5388382389 | 6288 Sage Ct # 111, Mesa, AZ, 85282 | 0.46 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-138995 | ENR | Barbara A Rodriguez | 1954-04-20 | UHC-58424-93 | 7292017508 | 8259 Sage Ct, Phoenix, AZ, 85014 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-116199 | ENR | Mdaison Padilla | 1963-07-01 | UHC-08831-32 | 5458405782 | 409 Bayshore Dr, Fresno, CA, 93733 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-139175 | ENR | Keith Adams | 1965-02-05 | — | 3974342422 | 1984 Church St, San Antonio, TX, 78298 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-127529 | ENR | Virginia M Jordan | 1974-06-18 | UHC-40489-77 | 3566574341 | 585 Ocean Ave, Fresno, CA, 93792 | 0.46 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more |
| ENR-105949 | ENR | Kathryn Perez | 1986-11-13 | UHC-05255-47 | 4134831790 | 1011 Indian School Rd # 420, Seattle, WA, 98117 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-106312 | ENR | Bradley Schmidt | 1954-04-16 | UHC-91040-77 | 9573535031 | 7492 Camelback Rd, Eden Prairie, MN, 55395 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-106313 | ENR | Bradley Schmidt | 1954-04-16 | UHC-91040-77 | 9573535031 | 7492 Camelback Rd, Eden Prairie, MN, 55395 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-132705 | ENR | Austin Benett | 1948-10-24 | UHC-98289-93 | 2318273358 | 7038 Mesa Dr, Gilbert, AZ, 85223 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |
| ENR-110420 | ENR | Roy Flores | 1943-03-01 | UHC-28140-87 | 5329526394 | 41 Pine Dr # 235, Orlando, FL, 32898 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more |
| ENR-141414 | ENR | Michelle I Austin | 1983-10-27 | UHC-36989-92 | 3093520686 | 2830 Jefferson Ave # 392, Mesa, AZ, 85244 | 0.46 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more |
| ENR-141106 | ENR | Ana T Rodriguez | 1950-02-13 | UHC-52673-18 | 3977060063 | 7984 Palm Dr, San Diego, CA, 92126 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-101420 | ENR | Emma Reyes | 1992-04-17 | UHC-53606-43 | 2464615050 | 6614 Lake View Rd # 682, Sacramento, CA, 95827 | 0.48 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-133292 | ENR | Ahmed G Li | — | UHC-22067-18 | 8592720573 | 754 Elm St, Seattle, WA, 98104 | 0.48 | Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more |
| ENR-125901 | ENR | Denise Byd | 1943-06-25 | UHC-49446-36 | 8582052390 | 3478 Bayshore Dr Apt 6, Tampa, FL, 33645 | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-131997 | ENR | Diana Turner | 1970-11-06 | UHC-55479-79 | 7939690217 | 3212 Lake View Rd, Gilbert, AZ | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-142680 | ENR | Evelyn Frnaklin | 1956-10-02 | UHC-47615-63 | 7313852638 | 5532 Cedar Ln, Mesa, AZ, 85268 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-133125 | ENR | Gerald R Russell | 1951-07-01 | UHC-95632-60 | 9252030479 | 6855 Maple Ave, Tucson, AZ | 0.48 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-102821 | ENR | Bryan Warren | 1974-02-14 | UHC-40178-96 | 7282132622 | 8514 Desert Sky Blvd, Phoenix, AZ | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-114365 | ENR | Jacqueline B Cox | 1978-10-27 | UHC-39035-76 | 5398218201 | 521 Union St, Scottsdale, AZ, 85277 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-112926 | ENR | Priya Roberts | 1949-04-22 | UHC-42307-61 | 5755388631 | 7499 Market St, Las Vegas, NV, 89101 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-129463 | ENR | Samuel J Brown | 2001-05-09 | UHC-22101-79 | 9465149159 | 8733 Main St # 212, Scottsdale, AZ, 85220 | 0.48 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-133629 | ENR | Ronald D Morales | 1948-01-28 | UHC-99938-63 | 5609962582 | 2228 Church St, Phoenix, AZ | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-141547 | ENR | Andrew Hoffman | — | UHC-49164-75 | 5524392270 | 8112 Meadow Ln # 918, Tampa, FL, 33690 | 0.48 | Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-133964 | ENR | Carol H Day | 1965-09-01 | UHC-08350-05 | 7899428724 | 4642 Lake View Rd # 217, Sacramento, CA, 95856 | 0.48 | Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-117665 | ENR | Adam I McCoy | — | UHC-56750-62 | 2552709479 | 6072 Canyon Rd, San Antonio, TX, 78263 | 0.48 | Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-132970 | ENR | Michele J Tucker | 1939-07-22 | UHC-99041-10 | — | 5313 Broadway # 171, Gilbert, AZ, 85269 | 0.48 | Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more |
| ENR-135571 | ENR | Jordan D Padilla | 2000-03-12 | UHC-26828-27 | 3954694704 | 1639 Baseline Rd, Phoenix, AZ, 85032 | 0.48 | Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-104454 | ENR | Jessica G Brns | 2007-05-20 | UHC-28147-73 | 4863633735 | 8189 Sage Ct, Seattle, WA | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-131942 | ENR | Jeffrey Watson | 1977-11-28 | UHC-56766-49 | 3715467483 | 1332 Central Ave, Tempe, AZ, 85236 | 0.48 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-131734 | ENR | Janet Knight | — | UHC-89314-66 | 5265465202 | 8349 Forest Ave, Seattle, WA, 98153 | 0.48 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-105545 | ENR | Sandra Q Henry | 1954-08-15 | UHC-32427-83 | 7616116831 | 6380 Union St, Miami, FL, 33159 | 0.48 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-107504 | ENR | Nathan O Adams | 1963-09-07 | UHC-35012-64 | 4514050581 | 6781 Pine Dr, Houston, TX, 77012 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-131044 | ENR | Alan T Thompson | 1972-10-05 | UHC-77689-96 | 5816288126 | 2288 Sunset Blvd, Eden Prairie, MN | 0.48 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-100602 | ENR | Patrick D Jensen | 1979-11-07 | UHC-29674-55 | 6515849272 | 5738 Forest Ave, Houston, TX, 77068 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |