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-137792 | ENR | Chris D Moreno | 1982-03-18 | UHC-90490-58 | 8139920653 | 7662 Cedar Ln, Seattle, WA, 98104 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-104615 | ENR | Jerry Dunn | — | UHC-07648-70 | 5796312993 | 5051 Ridge Rd, Dallas, TX, 75270 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-114513 | ENR | Sophia T Nunez | 1976-11-07 | UHC-45080-80 | 3096830015 | 6284 Maple Ave, Scottsdale, AZ, 85213 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120694 | ENR | Ahmed L Meyer | 1981-10-19 | UHC-94500-92 | 2555211062 | 5017 Canyon Rd, Miami, FL, 33130 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-132885 | ENR | Elizabeth W Richardson | 1994-01-12 | UHC-10396-69 | — | 7983 Park Pl, Sacramento, CA, 95858 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-141192 | ENR | Michael Johnson | 1991-03-07 | UHC-54027-41 | 7854458153 | 56 Church St, Plano, TX | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-117548 | ENR | Albert Hayes | 1993-09-23 | UHC-37155-48 | 4886590186 | 1017 Willow Ct, Tempe, AZ, 85201 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-127804 | ENR | Julie M Chapman | 1939-03-04 | UHC-21000-12 | 8823078782 | 7752 Sage Ct, Gilbert, AZ, 85253 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-100105 | ENR | Natalie Salazar | 1957-02-22 | UHC-30096-44 | — | 2985 Canyon Rd, Chandler, AZ, 85242 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-125485 | ENR | Janice E Cunningham | 1973-06-02 | UHC-38763-55 | 4502687904 | 721 Union St, Glendale, AZ, 85334 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-141791 | ENR | Jennifer R Gordon | 2002-07-06 | UHC-37220-36 | 2845846813 | 4519 Bayshore Dr, Plano, TX, 75068 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| ENR-136145 | ENR | Fatima Warren | 1943-01-18 | UHC-57298-39 | 5983363300 | 9247 Oak St, Minneapolis, MN, 55453 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-111414 | ENR | Stephen H Ross | 1967-10-22 | UHC-82658-64 | 5525070734 | 8689 Park Pl, San Antonio, TX, 78221 | 0.62 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-139469 | ENR | Amy V Butler | 1959-06-20 | UHC-35018-52 | 4196633809 | 1003 Harbor Blvd, Tucson, AZ, 85753 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-130721 | ENR | Billy A Watkins | 1990-11-07 | UHC-49351-53 | 5172848724 | 4593 River Rd, Las Vegas, NV, 89153 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128923 | ENR | Sofia N Kelly | 1946-04-05 | UHC-33102-93 | 9365977430 | 8132 Elm St, Glendale, AZ, 85320 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112012 | ENR | Emma Carter | 1943-02-15 | UHC-30598-22 | 9209783981 | 2898 Church St, Austin, TX, 78758 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-133833 | ENR | Guzman E David | 1957-08-27 | UHC-47294-74 | 3904235765 | 8849 Oak St, Sacramento, CA, 95848 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123973 | ENR | Theresa T Harvey | 2001-04-06 | UHC-35453-33 | — | 2571 Pine Dr, Orlando, FL, 32850 | 0.62 | Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-119475 | ENR | Cynthia Jensen | 1959-05-28 | UHC-82520-15 | — | 454 Apache Blvd, Columbus, OH, 43277 | 0.62 | Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-136615 | ENR | Justin Ortiz | 1987-06-05 | UHC-24192-57 | 9226345024 | 4394 Main St, Scottsdale, AZ, 85281 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-129176 | ENR | Albert Snders | 1976-05-06 | UHC-69469-95 | 8042734753 | 5471 Camelback Rd, Las Vegas, NV | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-102251 | ENR | Patricia N Price | 1985-05-18 | UHC-93968-03 | — | 8942 Apache Blvd, Phoenix, AZ | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| ENR-126741 | ENR | Raymond Mills | 1957-05-17 | UHC-11438-15 | 4986616054 | 5768 Forest Ave, Eden Prairie, MN, 55355 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-100681 | ENR | Fatima A Kim | 1976-08-22 | UHC-90579-88 | 5886622435 | 6634 Baseline Rd, Charlotte, NC, 28222 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-131154 | ENR | Judy B Burns | 2005-12-12 | UHC-78712-92 | 7358660169 | 7490 Spring St, Seattle, WA, 98149 | 0.62 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-103641 | ENR | Charles Foord | 1950-05-01 | UHC-71049-42 | 6656299130 | 5204 Washington St, Mesa, AZ, 85230 | 0.62 | SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-139760 | ENR | Debbie Gordon | 1995-09-18 | UHC-25449-95 | 3019583669 | 5176 Mesa Dr Apt 20, San Diego, CA, 92158 | 0.62 | Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-110204 | ENR | Benjamin R Taylor | 1985-01-15 | UHC-56897-70 | 5406899345 | 6028 Maple Ave, Houston, TX, 77028 | 0.62 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-134757 | ENR | Mei Read | 1940-12-02 | UHC-67578-17 | 5438771739 | 8628 Forest Ave, Austin, TX, 78702 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedSSN last four extracted+3 more |
| ENR-141614 | ENR | Harold Y Alvarado | 1974-10-05 | UHC-97987-12 | 4247622889 | 2637 Church St, San Antonio, TX, 78216 | 0.62 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-102663 | ENR | Thomas V Johnston | 1982-01-26 | UHC-03506-46 | 9517046677 | 2797 Market St, Scottsdale, AZ | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120687 | ENR | Terry Watson | 1968-12-15 | UHC-91677-64 | 5534822391 | 9625 Market St, San Antonio, TX, 78262 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120688 | ENR | Terry Watson | 1968-12-15 | UHC-91677-64 | 5534822391 | 9625 Market St, San Antonio, TX, 78262 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-116331 | ENR | Susan Clark | 1983-12-06 | UHC-41538-04 | 4646232642 | 9001 River Rd, Houston, TX, 77035 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-102761 | ENR | Diana T Herrera | 1963-06-23 | UHC-29988-99 | 3056230488 | 2719 Spring St, Minneapolis, MN | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-141667 | ENR | Diego Larsun | — | UHC-84199-26 | 5383557504 | 4740 Desert Sky Blvd, San Antonio, TX, 78245 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedCity re-cased+3 more |
| ENR-106615 | ENR | Amber K Vargas | 1985-01-01 | UHC-53395-28 | 4279148014 | 2261 Central Ave, Jacksonville, FL | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100564 | ENR | Gregory Dean | 1965-10-03 | UHC-84278-91 | 9263007432 | 8034 Pine Dr, Minneapolis, MN, 55458 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-139447 | ENR | Lauren E Valdez | 1996-05-01 | UHC-93804-18 | 9553628354 | 9898 River Rd, Tampa, FL, 33602 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-143015 | ENR | Tyler Lewis | 1972-06-24 | — | 2676143133 | 2862 Forest Ave, Los Angeles, CA, 90080 | 0.62 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-102298 | ENR | Angela Fowler | 1969-11-24 | UHC-91761-70 | 4055581516 | 1269 Sage Ct, Tempe, AZ, 85283 | 0.62 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-141520 | ENR | Bruce Harper | 1946-08-07 | UHC-39693-44 | 3453664427 | 3955 Union St, Mesa, AZ, 85290 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-119083 | ENR | Philip Vazquez | 1996-06-27 | UHC-46410-96 | — | 5436 Union St, Columbus, OH, 43262 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-118127 | ENR | Justin Montgomery | 1981-06-01 | UHC-35192-79 | 9682228172 | 6366 Pine Dr, Seattle, WA, 98137 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-113137 | ENR | Alice Armstrong | 1999-11-04 | UHC-49773-32 | 6552040663 | 5394 River Rd, Charlotte, NC | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135233 | ENR | Sarah Q Simpson | 2006-07-06 | UHC-83348-38 | 9668139023 | 3947 Lincoln Way, Atlanta, GA, 30325 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-125675 | ENR | Emily Jenkins | 1991-03-01 | UHC-63131-22 | 7337855742 | 3664 Camelback Rd, Austin, TX, 78775 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-135255 | ENR | Henry Watson | 1964-01-03 | UHC-95535-50 | 9256767420 | 2496 Valley View Dr, Charlotte, NC | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-104416 | ENR | Ahmed Y Ferguson | 1965-04-04 | UHC-66248-58 | 7888599768 | 7654 Valley View Dr, Charlotte, NC, 28282 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |