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-138630 | ENR | Kevin Mills | 1948-08-03 | UHC-92487-72 | 6254216797 | 7712 Mountain View Dr # 836, Scottsdale, AZ, 85209 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-103640 | ENR | Theresa M Weaver | 2001-03-15 | UHC-34492-56 | 6742434258 | 1689 Indian School Rd, Tampa, FL, 33682 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-127999 | ENR | Alan Lynch | 1993-06-03 | — | 8462609334 | 8507 Bayshore Dr, Tampa, FL, 33662 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-130771 | ENR | Pamla Y Hunt | 2001-10-27 | UHC-01030-03 | 8318026467 | 8873 River Rd, Plano, TX, 75042 | 0.46 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more |
| ENR-107224 | ENR | Sandra E Owens | 1978-11-16 | UHC-89246-62 | 8853856982 | 6957 Bayshore Dr, Seattle, WA, 98175 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-114125 | ENR | Alice A McDonald | 1963-06-01 | UHC-51908-02 | 9589190958 | 4905 Jefferson Ave, Tucson, AZ, 85722 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more |
| ENR-131356 | ENR | Roger Fox | 1990-07-18 | UHC-96985-70 | 6404148100 | 5466 Maple Ave # 686, Tampa, FL, 33680 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-125315 | ENR | Mari O Campbell | 1986-11-08 | UHC-54075-92 | 2086846093 | 3520 Lincoln Way, Charlotte, NC, 28219 | 0.46 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more |
| ENR-119598 | ENR | Lawrence Carter | 1993-01-26 | UHC-42533-01 | — | 1881 Jefferson Ave, Scottsdale, AZ, 85206 | 0.46 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more |
| ENR-119597 | ENR | Lawrence Carter | 1993-01-26 | UHC-42533-01 | — | 1881 Jefferson Ave, Scottsdale, AZ, 85206 | 0.46 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more |
| ENR-102299 | ENR | Angela Fowler | 1969-11-24 | UHC-91761-70 | 4055581516 | 1269 Sage Ct, Tempe, AZ, 85283 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-128634 | ENR | Haroold Rivera | 1954-10-21 | UHC-92156-95 | 6767250850 | 2799 Cedar Ln # 734, Orlando, FL, 32849 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-134939 | ENR | Willie Franklin | 1974-09-24 | UHC-39455-06 | — | 5953 Bayshore Dr, Dallas, TX, 75226 | 0.46 | Date of birth reformattedPhone missing area codeSSN last four extractedStreet suffix standardised+5 more |
| ENR-108846 | ENR | Carl Owens | 2001-01-10 | UHC-24250-02 | 8243071686 | 1298 Forest Ave, Minneapolis, MN | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-111637 | ENR | —Junk | 1981-08-16 | UHC-81108-80 | 8174093848 | 2178 Apache Blvd # 803, Eden Prairie, MN, 55348 | 0.46 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-140915 | ENR | Donald D Price | 1990-06-06 | UHC-98398-01 | 4618792627 | 1458 Oak St, San Antonio, TX | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-138859 | ENR | Robert W Jacobs | 1971-01-14 | UHC-66748-29 | 5938408570 | 7254 Central Ave, Atlanta, GA, 30335 | 0.46 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-122842 | ENR | Bryan Gordon | — | UHC-04003-37 | 7232021397 | 1344 Ocean Ave, Glendale, AZ, 85326 | 0.46 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+5 more |
| ENR-107731 | ENR | Camila A Perkins | 1961-05-20 | UHC-07700-45 | 4719038136 | 6104 Spring St, Scottsdale, AZ, 85222 | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-114943 | ENR | Charlotte J Watson | 1969-08-27 | UHC-45410-02 | 4589482383 | 429 Pine Dr, Atlanta, GA, 30356 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-114942 | ENR | Charlotte J Watson | 1969-08-27 | UHC-45410-02 | 4589482383 | 429 Pine Dr, Atlanta, GA, 30356 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-107316 | ENR | Jack V Bowman | 1974-02-24 | UHC-76339-06 | — | 6010 Broadway, Plano, TX, 75013 | 0.46 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone missing area code+5 more |
| ENR-117208 | ENR | Heather Reyes | 1945-01-26 | UHC-65077-06 | 7025427306 | 786 Sunset Blvd, Atlanta, GA, 30351 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-119233 | ENR | Kevin D George | 1941-01-17 | UHC-63679-21 | 8779891598 | 1143 Jefferson Ave, Houston, TX, 77030 | 0.46 | Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+5 more |
| ENR-109316 | ENR | Jackie Gray | — | UHC-83000-12 | 3257914314 | 5307 Baseline Rd, Denver, CO, 80263 | 0.46 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+5 more |
| ENR-113200 | ENR | Teresa Santos | 1959-12-22 | UHC-28319-23 | 9576359236 | 194 Oak St, Dallas, TX, 75256 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-133966 | ENR | Katherine King | 1947-06-28 | UHC-21776-91 | 2332893316 | 339 Church St, Dallas, TX, 75243 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |
| ENR-124893 | ENR | Adam H Lucas | 2003-03-21 | UHC-98067-38 | 9229537683 | 4190 Union St, San Diego, CA | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-139448 | ENR | Harold Lewis | 1983-03-15 | UHC-81818-96 | 4272662732 | 6789 Elm St Apt 9, Atlanta, GA, 30321 | 0.46 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-110421 | ENR | Tyler Oliver | 1988-04-04 | UHC-80744-56 | 2365774009 | 3506 Lincoln Way, San Diego, CA, 92139 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-105544 | ENR | Sofia Lawrence | 1986-02-24 | UHC-75151-15 | 8696347169 | 2571 Bayshore Dr, Seattle, WA | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-125046 | ENR | Carl Q White | 1943-02-06 | UHC-60657-23 | 4897021916 | 8984 Ridge Rd, Orlando, FL, 32863 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-109723 | ENR | Natlie Wang | 2000-08-13 | UHC-11557-27 | 4885065406 | 5773 Baseline Rd # 137, Minneapolis, MN | 0.46 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more |
| ENR-139181 | ENR | Pat H Gutierrez | 1991-10-17 | UHC-55935-35 | 6315592738 | 9066 Cedar Ln, Eden Prairie, MN | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-101426 | ENR | Sophia Munoz | 1977-05-22 | UHC-32629-21 | 8549995737 | 6455 Ridge Rd, Scottsdale, AZ, 85256 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-113417 | ENR | Gabriel N Mnoz | 1986-01-14 | UHC-68548-73 | 8388535293 | 3915 Park Pl, Atlanta, GA | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-140343 | ENR | Julie A George | 1961-08-14 | UHC-62078-43 | 8996242498 | 5628 Mountain View Dr, Seattle, WA, 98119 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-105551 | ENR | Logan Q Mendoza | 1997-07-19 | UHC-83159-66 | 3264563054 | 5812 Jefferson Ave, Tucson, AZ, 85728 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |
| ENR-123489 | ENR | Kelly K Park | 2003-01-04 | UHC-31870-54 | 2154662801 | 2146 Willow Ct, Jacksonville, FL, 32278 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-113903 | ENR | Nathan M Wilson | 2007-10-13 | UHC-55606-82 | 8825889225 | 8326 River Rd # 910, Miami, FL | 0.46 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-118480 | ENR | Debra J Elliott | — | UHC-29655-41 | 7519558773 | 5362 Park Pl, Nashville, TN, 37210 | 0.46 | Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+5 more |
| ENR-118142 | ENR | Gregory Lopez | 2003-10-17 | UHC-68258-65 | 3606217500 | 2870 Indian School Rd # 777, Tampa, FL | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-119326 | ENR | Evelyn Burns | 1991-10-17 | UHC-64453-70 | — | 4461 Spring St, Tampa, FL, 33671 | 0.46 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+5 more |
| ENR-120123 | ENR | Amy F Baker | 1967-05-15 | UHC-44725-60 | 6939921271 | 4115 Palm Dr, Chandler, AZ, 85223 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-131866 | ENR | Richard N Chapman | 1999-11-01 | UHC-28200-70 | 8314581341 | 5513 Desert Sky Blvd, Plano, TX, 75012 | 0.46 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-123941 | ENR | Grace P Kim | 1952-04-02 | UHC-89018-09 | 4764590477 | 2766 Sage Ct, Denver, CO | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |
| ENR-108228 | ENR | Shirley V Watson | 1942-01-18 | UHC-42611-87 | — | 5102 Main St, Austin, TX, 78707 | 0.46 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more |
| ENR-138119 | ENR | Natalie Kim | 1997-01-07 | UHC-69045-49 | 4997363276 | 9655 Cedar Ln # 327, Phoenix, AZ, 85081 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-111914 | ENR | Christine D Barnes | 2006-01-22 | UHC-70917-32 | 5322633861 | 5821 Washington St, Columbus, OH, 43290 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-134226 | ENR | Victoria Rogers | 2008-05-10 | UHC-57091-14 | 7343817018 | 1444 Indian School Rd, Plano, TX, 75029 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |