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-134917 | ENR | Donna Myers | 1954-01-21 | UHC-28456-29 | 9273674387 | 648 Oak St, Gilbert, AZ, 85215 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-106558 | ENR | Santiago Ross | 1972-09-08 | UHC-67982-12 | — | 2850 Lake View Rd, San Diego, CA, 92128 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-143082 | ENR | Brittany Reyes | 1949-01-21 | UHC-87647-23 | 5013171028 | 7712 Highland Ave, Eden Prairie, MN, 55373 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-143083 | ENR | Brittany Reyes | 1949-01-21 | UHC-87647-23 | 5013171028 | 7712 Highland Ave, Eden Prairie, MN, 55373 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-109517 | ENR | Kenneth Gordon | 1939-07-13 | UHC-62055-42 | 2056183860 | 8838 Sage Ct, Chandler, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-133617 | ENR | Betty M Willis | 1958-07-17 | UHC-87716-71 | 9513124114 | 2735 Cedar Ln Apt 31, Houston, TX, 77086 | 0.60 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-120524 | ENR | Nicholas Espinoza | 2003-07-25 | UHC-39988-70 | 2948060529 | 2471 Indian School Rd, Glendale, AZ, 85381 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-118210 | ENR | Jesssica G Perez | 1997-02-15 | UHC-75199-96 | 8917133214 | 9284 Willow Ct, Dallas, TX, 75277 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-131691 | ENR | Nicholas Thompson | 1985-05-12 | — | 7153641284 | 8063 Park Pl, Minneapolis, MN, 55465 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-131776 | ENR | Carol Bryant | 1990-11-22 | UHC-19112-85 | 8627026676 | 5725 Baseline Rd, Seattle, WA, 98103 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-118942 | ENR | Ahmed A Jones | 1943-03-22 | UHC-81105-23 | 3932081531 | 2851 Indian School Rd, Miami, FL, 33127 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-107078 | ENR | Andrew U Gutierrez | 1981-04-13 | UHC-30348-83 | 3406524371 | 7873 Cedar Ln, Los Angeles, CA, 90061 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-100511 | ENR | Grace P Burton | 1981-01-26 | UHC-52024-75 | 2889449993 | 8064 Maple Ave, Columbus, OH, 43279 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-101567 | ENR | Carl Morrison | 1989-06-26 | UHC-22994-76 | 6654491872 | 3084 River Rd, Denver, CO, 80236 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-133304 | ENR | Pamela Bailey | 2008-05-18 | UHC-81807-50 | 9346485691 | 4529 Church St # 166, Miami, FL, 33152 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-101345 | ENR | Sue Taylor | 1959-08-10 | UHC-47369-79 | 3212126844 | 867 Bayshore Dr, Gilbert, AZ, 85284 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-123062 | ENR | Emily Johnson | 1975-09-13 | UHC-34879-85 | 4289981778 | 7510 Meadow Ln, Miami, FL, 33103 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-134297 | ENR | Nathan H Brown | 2004-07-03 | UHC-58183-45 | 7184169819 | 7754 Mountain View Dr, Austin, TX, 78746 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-109835 | ENR | Shirley E Rice | 1955-01-14 | UHC-46384-12 | 7628816467 | 9570 Harbor Blvd, Houston, TX, 77069 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-117248 | ENR | Andrea P Green | 1946-07-01 | UHC-80096-47 | — | 2561 Jefferson Ave, Chandler, AZ, 85221 | 0.60 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-107520 | ENR | Roy Cook | 1997-05-23 | UHC-10849-81 | 7689751122 | 8933 Camelback Rd, Glendale, AZ, 85325 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-127307 | ENR | Frances V Stevens | 1958-06-16 | UHC-72258-94 | 7825624817 | 6045 Washington St, Chandler, AZ | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-117802 | ENR | Ana Wheeler | 1947-03-19 | UHC-60445-48 | 4218728078 | 4863 Lake View Rd, Fresno, CA, 93712 | 0.60 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-134564 | ENR | Raymond D Wesst | 1958-12-27 | UHC-79449-15 | 7544736506 | 451 Union St Apt 25, Columbus, OH, 43207 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-114591 | ENR | Adam Rogers | 1991-02-14 | UHC-08320-64 | — | 550 Valley View Dr, Tampa, FL, 33679 | 0.60 | Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more |
| ENR-105563 | ENR | Carl Y Li | 1956-09-06 | UHC-41105-72 | 5179122797 | 8507 Highland Ave, Houston, TX | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-125112 | ENR | Luis N Wang | 1950-12-22 | UHC-24120-80 | 8509369707 | 4636 Maple Ave # 122, Minneapolis, MN, 55493 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-123300 | ENR | Jack F Lawson | 1992-03-07 | UHC-45514-20 | 2059405754 | 5849 Cedar Ln, Columbus, OH, 43207 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-126377 | ENR | Ashley Garrett | 1975-10-05 | UHC-61998-34 | 6482839997 | 5074 Sage Ct, Phoenix, AZ, 85000 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-109745 | ENR | Amanda Rodriguez | 1951-11-11 | UHC-01866-39 | — | 2060 Valley View Dr Apt 38, Tampa, FL, 33618 | 0.60 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-142603 | ENR | Patricia S Richards | 1965-06-27 | UHC-53338-88 | 8175337623 | 2662 Main St, Chandler, AZ, 85211 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-120674 | ENR | Astin H Kennedy | 1996-05-24 | UHC-71747-72 | 6596026380 | 9136 Willow Ct, Atlanta, GA, 30341 | 0.60 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-113951 | ENR | Douglas A Obrien | — | UHC-06611-98 | 9703175716 | 8787 Central Ave, Atlanta, GA, 30382 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-101113 | ENR | Helen X Munoz | 1983-02-20 | UHC-59265-33 | 8249746784 | 1197 Lake View Rd, Las Vegas, NV, 89195 | 0.60 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-135081 | ENR | Jennifer Gray | 1977-08-21 | UHC-61559-04 | 3082645014 | 1201 Maple Ave, Atlanta, GA, 30345 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-124597 | ENR | Carl W Banks | 1979-07-28 | UHC-44122-85 | 7795715705 | 7792 Jefferson Ave, Fresno, CA, 93782 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-123349 | ENR | Doris Morris | 1981-02-14 | — | 3819961961 | 4738 Willow Ct, Columbus, OH, 43236 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-109067 | ENR | Robert J Tucker | 2004-07-14 | UHC-10873-92 | 6222042561 | 2275 Sunset Blvd, Tempe, AZ, 85284 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedSSN last four extracted+4 more |
| ENR-108752 | ENR | Lori O Lewis | 1949-03-09 | UHC-65986-60 | 9466565587 | 6077 Highland Ave, Atlanta, GA | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-125097 | ENR | Karen S Rivera | 1984-05-22 | UHC-62284-61 | 6439595537 | 9144 Ridge Rd, Fresno, CA, 93779 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-135640 | ENR | Jackie B McCoy | 1972-03-15 | UHC-04810-61 | 2505932088 | 39 Church St, Las Vegas, NV, 89127 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-135605 | ENR | Heather Austin | 1994-10-27 | UHC-79946-28 | 2465374210 | 4774 Harbor Blvd, Gilbert, AZ, 85244 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-106571 | ENR | Marcus Ward | 1952-05-03 | UHC-01655-80 | 8878421034 | 8789 Park Pl, Plano, TX, 75059 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-105615 | ENR | Jennifer Z Gibson | 1944-01-23 | UHC-49917-43 | 7113607567 | 7719 Canyon Rd, Orlando, FL, 32848 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-118844 | ENR | Jordan Stone | 1989-11-22 | UHC-29838-90 | 4534019809 | 2253 Sage Ct, Fresno, CA, 93795 | 0.60 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-125835 | ENR | Justin Butler | 1953-11-08 | UHC-04020-20 | 6109317064 | 2044 Mountain View Dr, Austin, TX, 78706 | 0.60 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-129254 | ENR | Edwerd Reed | 1957-05-20 | UHC-06276-31 | 8336528564 | 1422 Lincoln Way, San Antonio, TX, 78207 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-126274 | ENR | Priya J Duncan | 1990-06-08 | UHC-97186-66 | 6076146230 | 2247 Bayshore Dr, Austin, TX, 78724 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-100481 | ENR | Bruce Henry | 2001-02-18 | UHC-59684-25 | 9738491510 | 5877 Indian School Rd, Plano, TX | 0.60 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-138422 | ENR | Brittany J Richardson | 1952-12-02 | UHC-80551-30 | 5917710659 | 4734 Baseline Rd, Plano, TX | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |