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-132867 | ENR | Sara Hoffman | 1944-11-21 | UHC-72647-57 | 4095091371 | 4871 Forest Ave, Fresno, CA | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-120188 | ENR | Bradley Lopez | 2005-02-24 | UHC-46200-39 | 4502381175 | 5000 Central Ave, Denver, CO, 80235 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-122283 | ENR | Olivia J Padilla | 2001-03-03 | UHC-79554-60 | 5407022348 | 847 Market St, Tempe, AZ, 85266 | 0.62 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-134092 | ENR | Russell R Mendoza | 1989-07-06 | UHC-92121-34 | 8048992322 | 2400 Hillcrest Rd # 119, Tempe, AZ, 85215 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-102331 | ENR | Maria Castro | 1997-07-28 | UHC-91369-52 | — | 3820 Mountain View Dr, Eden Prairie, MN, 55386 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-101015 | ENR | Wei Patterson | 1949-07-04 | UHC-24216-61 | 9183319313 | 4830 Elm St, San Antonio, TX, 78235 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-100809 | ENR | Ed Williamson | 1960-06-18 | UHC-60200-80 | 9057505634 | 4053 Church St, Chandler, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-131415 | ENR | Scott Bryant | 1964-06-07 | UHC-34466-60 | 5566545472 | 7703 Spring St, Fresno, CA, 93731 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121009 | ENR | Priya S Morales | 1938-05-26 | UHC-40542-36 | 4034626164 | 7223 Sunset Blvd, Chandler, AZ, 85233 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-104575 | ENR | Danielle Q Bradley | 1946-04-12 | UHC-12229-41 | 2354782240 | 3413 Broadway, Tampa, FL | 0.62 | Two-digit birth yearPhone reformattedAddress re-casedCity re-cased+3 more |
| ENR-124551 | ENR | Joseph N McCoy | 1967-03-26 | UHC-16425-97 | 7926288552 | 5635 Meadow Ln # 710, Tucson, AZ, 85795 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-119819 | ENR | Albert Tran | 2004-12-08 | — | 7418427978 | 2632 Cedar Ln # 907, Austin, TX, 78779 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-140611 | ENR | Justin Le | 1977-05-22 | UHC-43468-04 | 4799229662 | 1662 Market St, Phoenix, AZ, 85049 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-101714 | ENR | Virginia Ruiz | 2002-06-11 | UHC-83107-13 | 2748714431 | 2822 Elm St, Las Vegas, NV, 89175 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-125582 | ENR | Shirley A Shaw | 1981-11-18 | UHC-36002-70 | 7184181521 | 2333 Apache Blvd, Jacksonville, FL, 32269 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-119049 | ENR | Raymond Y Ward | 1973-06-13 | UHC-67172-96 | 4636369559 | 3959 Sunset Blvd, Las Vegas, NV, 89197 | 0.62 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-118836 | ENR | Stephanie Mejia | 1984-11-12 | UHC-10286-01 | 5648476984 | 3840 Highland Ave, Glendale, AZ, 85383 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-125396 | ENR | Ethan Gilbert | 1997-06-26 | UHC-51622-74 | 8179001392 | 3637 Main St, Atlanta, GA, 30323 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-125395 | ENR | Ethan Gilbert | 1997-06-26 | UHC-51622-74 | 8179001392 | 3637 Main St, Atlanta, GA, 30323 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-124048 | ENR | Larry S Morgan | 1970-12-27 | UHC-28354-94 | 6455726478 | 6551 Lincoln Way, San Diego, CA, 92134 | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110632 | ENR | Gregory Franklin | 2000-06-12 | — | 9023727137 | 5586 Pine Dr, Los Angeles, CA, 90053 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120505 | ENR | Richaard I Stone | 1951-11-11 | UHC-97487-13 | 5483300684 | 5628 Grand Ave, Chandler, AZ | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-138196 | ENR | Barndon Santos | 1965-05-10 | UHC-60608-39 | 7203435308 | 1113 Broadway, Houston, TX, 77091 | 0.62 | Name split from “Last, First”Phone reformattedMember ID reformattedAddress re-cased+3 more |
| ENR-142535 | ENR | Stephen Valdez | 1975-03-18 | UHC-30831-40 | 7747303736 | 3115 Park Pl Apt 17, Denver, CO, 80251 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-114762 | ENR | Carlos Spencer | 1952-05-26 | UHC-03040-35 | 5722819371 | 1250 Sage Ct, Minneapolis, MN, 55429 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-114600 | ENR | Michael R Davis | 1954-08-05 | UHC-14997-20 | 9064631628 | 9821 Hillcrest Rd, Tampa, FL | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-102839 | ENR | James O Marshall | 2006-09-03 | UHC-35247-81 | 3546443991 | 2554 Willow Ct, San Antonio, TX, 78240 | 0.62 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120729 | ENR | Joyce Hunter | 2006-07-08 | UHC-09705-62 | 9648327304 | 3697 Main St, Plano, TX, 75042 | 0.62 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128963 | ENR | Olivia Davis | 1995-11-18 | UHC-46336-83 | 2384802672 | 5346 Elm St, Columbus, OH, 43281 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-133011 | ENR | Tyler V Mills | 1994-07-04 | UHC-15931-61 | 4192515318 | 9120 Market St, Columbus, OH, 43272 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128859 | ENR | Roy G Willis | 1996-05-27 | UHC-62931-06 | 8757766344 | 7433 Indian School Rd, Miami, FL, 33101 | 0.62 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-103348 | ENR | Emma A Perez | 1997-09-25 | UHC-52568-47 | 5022144702 | 5635 Oak St, Gilbert, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-105184 | ENR | Timothy Aronld | 1957-04-13 | — | 7719871622 | 7089 Mesa Dr, Charlotte, NC, 28227 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-116467 | ENR | Carlos Y Guerrero | 1960-03-11 | UHC-84016-21 | 6975859369 | 53 Grand Ave, Gilbert, AZ, 85241 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-103398 | ENR | Helen Allen | 1961-06-07 | UHC-39252-84 | 9865520656 | 1340 Main St, Tucson, AZ, 85732 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-116845 | ENR | Judy X Ryan | 2006-04-20 | UHC-02874-79 | 8629133049 | 4017 Ocean Ave # 262, Plano, TX, 75088 | 0.62 | Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-142458 | ENR | Dick Hall | 1968-05-21 | UHC-80730-48 | 3653793998 | 1642 Mountain View Dr, Dallas, TX | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-140535 | ENR | Boyd Sara | 1989-11-16 | UHC-00830-94 | 8828356136 | 3848 Bayshore Dr, Las Vegas, NV, 89101 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-120107 | ENR | RebeccaJunk | 1958-11-12 | UHC-46812-67 | 8822371742 | 7931 Washington St, Atlanta, GA, 30312 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-116069 | ENR | Mark U Tran | 1961-04-26 | UHC-77913-35 | 7622754588 | 427 Washington St, San Diego, CA, 92164 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-115583 | ENR | Jordan Perkins | 1951-03-03 | UHC-84504-72 | 9474822634 | 9661 Mesa Dr, Charlotte, NC, 28231 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-101304 | ENR | Ralph Y Vargas | 1969-06-27 | UHC-63428-97 | 5144147151 | 5769 Cedar Ln, Tempe, AZ, 85279 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128353 | ENR | Samantha Dominguez | 1983-01-27 | UHC-55189-26 | 3103023238 | 1012 Bayshore Dr # 259, Columbus, OH, 43249 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-133577 | ENR | Alexis O Vasquez | 1968-08-12 | UHC-44563-43 | 7719250588 | 6026 Ocean Ave, Chandler, AZ, 85241 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| ENR-133578 | ENR | Alexis O Vasquez | 1968-08-12 | UHC-44563-43 | 7719250588 | 6026 Ocean Ave, Chandler, AZ, 85241 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| ENR-130248 | ENR | Christine James | 2004-08-08 | UHC-20756-55 | 4473361752 | 264 Lake View Rd, Charlotte, NC | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-112889 | ENR | Cheryl Welch | 1938-01-06 | UHC-07157-28 | 4148287096 | 6366 Hillcrest Rd Apt 27, Miami, FL, 33154 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-128719 | ENR | Helen Mills | 1972-02-09 | UHC-72226-56 | 6919339184 | 8254 Cedar Ln, San Diego, CA, 92127 | 0.62 | Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-111145 | ENR | Lawrence L Morrison | 1965-09-14 | UHC-89838-16 | 8405275947 | 2495 Pine Dr, Miami, FL, 33199 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-134240 | ENR | Arjun Bradley | 2006-08-16 | UHC-09600-58 | 9807022600 | 3080 Valley View Dr # 905, Chandler, AZ, 85273 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |