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-125751 | ENR | Maria M Banks | 1962-11-18 | — | 3439996331 | 6292 Church St, Los Angeles, CA | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-129065 | ENR | Sarah Phillips | 1981-01-22 | UHC-31199-52 | 3443740128 | 1159 Spring St, Jacksonville, FL | 0.48 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-107290 | ENR | Bradley Morrsion | 1982-11-11 | UHC-89051-37 | 4197127965 | 461 Central Ave, Tucson, AZ, 85713 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-134920 | ENR | Sofia N Davys | 1971-05-14 | UHC-61212-01 | — | 1769 Lincoln Way Apt 32, Plano, TX, 75021 | 0.48 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-140062 | ENR | Grace D Hughes | 1965-10-15 | UHC-78713-50 | 6717940564 | 181 Central Ave, Tampa, FL, 33632 | 0.48 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-134233 | ENR | Roy Reed | 1975-08-05 | UHC-26068-80 | 6882559284 | 4501 Indian School Rd, Fresno, CA, 93786 | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-106452 | ENR | Laura N Green | 1971-08-01 | UHC-02350-82 | 5412710172 | 7399 Church St, Glendale, AZ, 85317 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-101617 | ENR | Brandon O Adams | 1957-09-08 | UHC-04938-69 | 3874682776 | 2111 Jefferson Ave, Eden Prairie, MN, 55357 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-101899 | ENR | Diana S Myers | 1994-04-19 | UHC-65881-90 | 7665062301 | 4782 Sage Ct # 409, Plano, TX, 75060 | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-101900 | ENR | Diana S Myers | 1994-04-19 | UHC-65881-90 | 7665062301 | 4782 Sage Ct # 409, Plano, TX, 75060 | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-127986 | ENR | Christian P Nelson | — | UHC-83748-44 | 6033036816 | 499 Pine Dr, Los Angeles, CA, 90068 | 0.48 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-141678 | ENR | Gabriel Vazquez | 1979-05-14 | UHC-22403-99 | 5247442623 | 2070 Apache Blvd, Phoenix, AZ, 85060 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-125058 | ENR | Hannah G Dean | 1943-06-10 | UHC-03019-59 | 7805122733 | 248 River Rd, Scottsdale, AZ, 85242 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-109171 | ENR | Luis Bailey | 1976-06-02 | UHC-42810-13 | 3477249469 | 7673 Main St, Minneapolis, MN, 55451 | 0.48 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-111059 | ENR | Sara Greene | 1987-04-04 | UHC-84724-26 | 2129192051 | 2557 Main St, Las Vegas, NV, 89166 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-134242 | ENR | Raymond Hicks | 2007-09-22 | UHC-56313-54 | 8437869678 | 7323 Baseline Rd, Orlando, FL, 32825 | 0.48 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more |
| ENR-129623 | ENR | Arthur Ryan | 1964-06-17 | UHC-17123-61 | 6007025020 | 2777 Oak St Apt 5, Tampa, FL, 33672 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more |
| ENR-113034 | ENR | Linda Lawrence | 1940-05-16 | UHC-42978-12 | 8735890123 | 4617 Palm Dr Apt 39, Tucson, AZ, 85757 | 0.48 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-121278 | ENR | Tyler Q Rose | 1982-01-28 | UHC-35992-83 | — | 959 Palm Dr, Mesa, AZ, 85272 | 0.48 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-104755 | ENR | Nathan Morrison | — | UHC-32458-35 | 5257772917 | 1788 Valley View Dr, Seattle, WA, 98117 | 0.48 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-122780 | ENR | Michelle Walker | 2003-08-05 | UHC-17580-14 | 3015838848 | 7539 Bayshore Dr Apt 19, Jacksonville, FL, 32259 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more |
| ENR-123645 | ENR | Carl N Valdez | 1964-02-03 | UHC-93111-39 | 4095222600 | 6049 Forest Ave, Atlanta, GA, 30380 | 0.48 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-118359 | ENR | Joe Wright | 1992-06-04 | UHC-08635-40 | 6875965982 | 907 Apache Blvd, Gilbert, AZ, 85291 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-135528 | ENR | Frances E Vega | 1981-01-14 | UHC-40876-79 | 7665060586 | 8278 Ridge Rd, Dallas, TX, 75257 | 0.48 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-110740 | ENR | Doris Jones | 1970-08-26 | UHC-98385-23 | 6407883084 | 1468 Mountain View Dr, Austin, TX, 78782 | 0.48 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-133879 | ENR | Harper K Philip | 1963-02-22 | UHC-80108-67 | 6875732299 | 3956 Bayshore Dr, Orlando, FL, 32854 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-108259 | ENR | Kathryn Lawson | — | UHC-39531-79 | 6822446367 | 6646 Canyon Rd, Orlando, FL, 32893 | 0.48 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| ENR-119005 | ENR | Willie Barnes | 1986-01-11 | UHC-72052-81 | 4753052583 | 3387 Cedar Ln, Nashville, TN, 37265 | 0.48 | Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-122577 | ENR | Danielle Peterson | 1949-01-25 | UHC-54962-64 | 2584846687 | 1519 Jefferson Ave, Mesa, AZ | 0.48 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-107800 | ENR | Kyle Q Snyder | 1945-05-19 | UHC-90590-98 | 5405635130 | 6754 Sage Ct, Tampa, FL, 33666 | 0.48 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-127162 | ENR | Jacob Z Carpenter | 2007-11-22 | UHC-24720-46 | 3346355146 | 5511 Mountain View Dr, Tempe, AZ, 85296 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-110698 | ENR | Frank M Vasquez | 2007-09-18 | UHC-46737-11 | 8063187040 | 7100 Main St, Scottsdale, AZ, 85274 | 0.48 | Name split from “Last, First”Phone reformattedMember ID reformattedCity re-cased+4 more |
| ENR-107978 | ENR | George Munoz | 1956-12-23 | UHC-84709-91 | 3717474418 | 1291 Cedar Ln # 923, Tampa, FL, 33605 | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-107977 | ENR | George Munoz | 1956-12-23 | UHC-84709-91 | 3717474418 | 1291 Cedar Ln # 923, Tampa, FL, 33605 | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-142214 | ENR | Diane Gordon | 1974-08-21 | UHC-37282-96 | — | 9704 Sage Ct, Plano, TX | 0.48 | Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more |
| ENR-126177 | ENR | Samuel N Marquez | 1995-12-04 | UHC-23159-56 | 2459718161 | 927 Church St, Phoenix, AZ, 85093 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more |
| ENR-104038 | ENR | Megan K Gordon | 2001-04-14 | UHC-50440-17 | 7984445814 | 5144 Maple Ave Apt 28, Tampa, FL, 33663 | 0.48 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-134863 | ENR | Stephen Q Alvarado | 1990-04-08 | UHC-69270-12 | 7345033997 | 580 Grand Ave, Scottsdale, AZ, 85217 | 0.48 | Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more |
| ENR-132811 | ENR | Gregory V Weaver | 1940-03-01 | UHC-54753-15 | — | 2147 Hillcrest Rd, Denver, CO | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+4 more |
| ENR-108837 | ENR | Lori J Lucas | — | UHC-00588-86 | 2448153512 | 9365 Palm Dr, Denver, CO, 80288 | 0.48 | Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+4 more |
| ENR-140211 | ENR | Alexander Fowler | 1941-11-14 | UHC-53266-82 | 2795181775 | 5555 Bayshore Dr, Sacramento, CA, 95844 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-101665 | ENR | Virginia L Thomas | 1988-05-17 | UHC-94590-15 | 9125701293 | 1797 Lake View Rd, Gilbert, AZ, 85235 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-141060 | ENR | Peggy Watson | 2007-04-27 | UHC-53720-04 | 7522404124 | 5608 Elm St, Orlando, FL, 32883 | 0.48 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-112945 | ENR | Olivia Tran | 1980-03-18 | UHC-76853-38 | — | 3305 Indian School Rd, Mesa, AZ, 85293 | 0.48 | Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+4 more |
| ENR-121209 | ENR | Chaarles Hunt | 1970-07-25 | UHC-19975-87 | 2439283590 | 3754 Union St Apt 40, Orlando, FL, 32869 | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-103106 | ENR | Albert I Lane | 1994-01-16 | UHC-80551-45 | 6895672062 | 3769 Pine Dr, Denver, CO | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-113363 | ENR | William Cnotreras | 2002-04-08 | UHC-63728-04 | 2025322515 | 3013 Grand Ave, Seattle, WA, 98116 | 0.48 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-128496 | ENR | Camila I Adams | 1985-01-02 | UHC-65667-70 | 4819527172 | 918 Canyon Rd # 488, Tampa, FL, 33697 | 0.48 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-127981 | ENR | Camila G Jaackson | 1961-05-15 | UHC-96379-79 | 3078514175 | 9839 Lincoln Way, Chandler, AZ, 85221 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-130789 | ENR | Matt Roberts | 1981-08-12 | UHC-34127-65 | 9213863935 | 5944 Bayshore Dr, Las Vegas, NV, 89188 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |