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-132123 | ENR | Russell T George | 2005-01-25 | UHC-35845-96 | 5175327379 | 613 Apache Blvd, Charlotte, NC | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-111601 | ENR | Lindda L Moore | 1961-12-17 | UHC-65655-62 | 8206938727 | 1540 Market St, San Antonio, TX | 0.62 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-123163 | ENR | Lucai Hernandez | 2003-08-05 | UHC-88709-12 | 2966076326 | 5947 Bayshore Dr, Tempe, AZ, 85287 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-124937 | ENR | Judith G Burns | 1978-04-16 | UHC-74937-93 | 2458534053 | 8847 Pine Dr, Nashville, TN | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| ENR-110999 | ENR | Brandon Johnston | 1994-03-05 | UHC-18239-79 | 8106611108 | 5819 Jefferson Ave, Minneapolis, MN, 55479 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-100537 | ENR | Jesse W Moreno | 1984-12-15 | UHC-81082-27 | 9195504794 | 3578 Jefferson Ave, Dallas, TX, 75211 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-130414 | ENR | Denise T Vargas | 1949-10-23 | UHC-01600-93 | 6146730135 | 4158 Central Ave, Nashville, TN | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-105710 | ENR | Mariana S Delgado | 1989-10-06 | UHC-41386-07 | 8826588091 | 516 Maple Ave, Orlando, FL, 32818 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-121998 | ENR | Omar Hicks | 1993-06-28 | UHC-71644-16 | 9682023886 | 1129 Indian School Rd, Glendale, AZ, 85347 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109386 | ENR | Helen N Kelley | 1996-05-12 | UHC-08411-81 | 7704623558 | 9444 Valley View Dr, Columbus, OH, 43248 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-137815 | ENR | Sharon F Martin | 1946-05-10 | UHC-49913-33 | 9199233370 | 2983 Forest Ave, Seattle, WA, 98144 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-109130 | ENR | Dennis Stephens | 1971-12-20 | UHC-47797-27 | 2939222173 | 1079 Indian School Rd, Glendale, AZ, 85337 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-115711 | ENR | Keith Russell | 1992-02-01 | UHC-15398-69 | 9848661925 | 6957 Lake View Rd, Seattle, WA | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135032 | ENR | Mateo Lee | — | UHC-39222-72 | — | 9241 Baseline Rd, Seattle, WA, 98157 | 0.62 | Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more |
| ENR-126114 | ENR | Daniel R Ellliott | 1944-03-10 | UHC-52792-25 | 8264030069 | 8182 Washington St, San Diego, CA, 92172 | 0.62 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more |
| ENR-125889 | ENR | Samuel N Fields | 1973-02-01 | UHC-70900-77 | 6908229153 | 2094 Desert Sky Blvd, Fresno, CA | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-140751 | ENR | Pamela Webb | 1959-08-09 | UHC-44862-76 | 5886398018 | 6001 Church St, Austin, TX, 78760 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-116040 | ENR | Reynolds Christian | 1969-06-13 | UHC-89526-48 | 8917377096 | 1150 Meadow Ln, Plano, TX, 75080 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-102640 | ENR | Doris Owens | 1976-10-07 | UHC-50196-22 | 4906184510 | 3552 Highland Ave, Minneapolis, MN, 55408 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-134642 | ENR | Weber Amanda | 1939-09-08 | UHC-56145-05 | 9142764637 | 4921 Desert Sky Blvd, Scottsdale, AZ, 85283 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-138323 | ENR | Kenneth McDonald | 2002-12-23 | UHC-23880-38 | 2342356337 | 1501 River Rd # 192, Tampa, FL, 33610 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-120942 | ENR | Virginia Bennett | 2007-07-09 | UHC-85901-18 | 3779212384 | 3368 Lincoln Way, San Antonio, TX, 78246 | 0.62 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-129532 | ENR | Ralph A Mendoza | 1977-11-03 | UHC-00344-49 | 7793092735 | 1456 Palm Dr, Los Angeles, CA | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-142968 | ENR | Linda Bishop | 1943-05-16 | UHC-76949-11 | 4547007895 | 1478 Maple Ave, Jacksonville, FL, 32238 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-132297 | ENR | Elizabeth Johnson | 1956-08-09 | UHC-09419-50 | 7193118670 | 6599 River Rd, Phoenix, AZ, 85020 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more |
| ENR-103495 | ENR | Amy Watson | 1942-07-11 | UHC-71029-24 | 9552748042 | 9190 Apache Blvd, San Diego, CA, 92158 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-128540 | ENR | Nicole A Cooper | — | UHC-91874-56 | 5788690100 | 3515 Pine Dr, Eden Prairie, MN, 55302 | 0.62 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112474 | ENR | Madison Z Mendez | 1988-10-11 | UHC-71301-92 | 4598043383 | 8233 Bayshore Dr, Dallas, TX, 75257 | 0.62 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-115627 | ENR | Aiisha E Kelley | 1964-11-03 | UHC-96102-18 | 3852508349 | 5803 Spring St, Las Vegas, NV, 89131 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-137603 | ENR | Patricia S Davis | 2002-01-17 | UHC-96971-12 | 6146052699 | 5868 Oak St, Plano, TX, 75095 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-127458 | ENR | Samantha S Jones | 1956-09-12 | UHC-43746-71 | 4175954313 | 8027 Union St, Tucson, AZ, 85787 | 0.62 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-139927 | ENR | David Vezquez | 1991-07-20 | UHC-60007-82 | 6243644386 | 5431 Mesa Dr, Atlanta, GA, 30391 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-118916 | ENR | Denise N Hughes | 1952-09-28 | UHC-47133-47 | 5744076369 | 4650 Market St, Jacksonville, FL, 32249 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-135725 | ENR | Charles M Wang | 1994-02-03 | UHC-35113-59 | — | 9780 Willow Ct, Los Angeles, CA, 90031 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-137350 | ENR | Gary S Watkins | 1952-02-13 | UHC-53844-08 | 6104923695 | 1472 Union St, San Diego, CA, 92107 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-108601 | ENR | Gerald P Lopez | — | UHC-58085-71 | — | 3691 Jefferson Ave, Jacksonville, FL, 32288 | 0.62 | Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more |
| ENR-133751 | ENR | Pamela Garza | 1997-11-02 | UHC-24284-08 | 7784506236 | 3571 Cedar Ln, Columbus, OH | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-113500 | ENR | Debra E Mejia | 2004-10-27 | UHC-43299-12 | 4674659001 | 212 Sage Ct, Dallas, TX | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-124249 | ENR | Kathryn O Henderson | 2006-01-19 | UHC-99531-61 | 6602192606 | 3638 Pine Dr # 972, Sacramento, CA, 95892 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-128973 | ENR | Maria P Dunn | 1941-02-26 | UHC-43773-50 | 6773488503 | 5593 Church St, Jacksonville, FL | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-127265 | ENR | Sara Carpenter | 1950-10-24 | UHC-95596-44 | 4195231041 | 5046 Mesa Dr, Columbus, OH, 43252 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121373 | ENR | Gloria V Weber | 1955-05-05 | UHC-93543-01 | 7097026501 | 9287 Oak St, Dallas, TX | 0.62 | Name re-casedPhone reformattedMember ID reformattedCity re-cased+3 more |
| ENR-124870 | ENR | Emily R Young | 1977-01-26 | UHC-47480-60 | 8583436208 | 8117 Apache Blvd, Mesa, AZ, 85237 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more |
| ENR-141453 | ENR | Juan C Obrien | 2008-07-20 | UHC-63527-62 | 4288045490 | 1923 Elm St, Los Angeles, CA, 90045 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-130929 | ENR | Eugene A Morales | 1976-03-11 | UHC-18419-70 | — | 7390 Bayshore Dr, Austin, TX, 78766 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-140516 | ENR | Gonzalez Katherine | 1958-10-26 | — | — | 3627 Highland Ave, Tampa, FL, 33637 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-138864 | ENR | Kevin H Romero | 2005-01-10 | UHC-28011-67 | 5086187276 | 6858 Lake View Rd, Fresno, CA, 93706 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-108707 | ENR | Jean I Brown | 1938-02-24 | UHC-02515-86 | 8969464597 | 9596 Lake View Rd, Glendale, AZ, 85354 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-137584 | ENR | Margaret Bradley | 1966-09-13 | UHC-01772-13 | 6739750394 | 2445 Spring St, Glendale, AZ, 85314 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-134148 | ENR | Gabriel M Spencer | 1954-01-08 | UHC-44268-23 | 5799634676 | 5592 Pine Dr, Miami, FL, 33150 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |