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-127749 | ENR | Jose Brooks | 1985-11-20 | UHC-69339-04 | 5608342817 | 9210 Main St, Nashville, TN | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-126585 | ENR | Logan Park | 1943-12-09 | UHC-39537-44 | 5322791353 | 8579 Highland Ave, Sacramento, CA, 95884 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-140451 | ENR | Lucia Tucker | 1984-08-18 | UHC-39477-43 | 4314122677 | 174 Mountain View Dr Apt 17, Austin, TX, 78781 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-125190 | ENR | Sarah I Crawford | 1975-07-11 | UHC-51995-26 | — | 1056 Forest Ave, Tempe, AZ, 85252 | 0.46 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-137943 | ENR | Elijah Stewart | 1948-05-18 | UHC-91439-06 | 6226728947 | 7215 Mesa Dr # 809, Atlanta, GA, 30367 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-137790 | ENR | Zachary R Welch | 1944-07-14 | UHC-56247-92 | 2716681493 | 8305 Jefferson Ave # 167, Columbus, OH, 43245 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-139027 | ENR | Richard Olson | 1957-09-12 | UHC-22683-75 | — | 9564 Pine Dr Apt 8, Austin, TX, 78723 | 0.46 | Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+5 more |
| ENR-127246 | ENR | Jean L Scott | 1974-06-25 | UHC-25460-52 | 5583857707 | 4107 Park Pl, Los Angeles, CA, 90029 | 0.46 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-119106 | ENR | Jonathan P Sullivan | 1969-06-09 | UHC-02849-76 | 6668885855 | 2307 Forest Ave Apt 6, Charlotte, NC | 0.46 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more |
| ENR-104263 | ENR | Hiroshi D Cunningham | 1950-08-06 | UHC-06723-47 | 2743143055 | 590 Spring St, Glendale, AZ | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-101925 | ENR | Amanda Walsh | 1965-11-10 | UHC-09751-10 | 7003584369 | 9882 Cedar Ln, Orlando, FL, 32884 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-133017 | ENR | Megan M Butler | 1953-12-25 | UHC-88806-59 | 7994156664 | 8973 Church St, Atlanta, GA, 30351 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-134682 | ENR | Evelyn P Palmer | — | UHC-50583-39 | 6092390924 | 8011 Church St, Tucson, AZ, 85758 | 0.46 | Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+5 more |
| ENR-109842 | ENR | Evelyn Aguilar | 1950-07-13 | UHC-87143-55 | 7835865413 | 2316 Ridge Rd, Tampa, FL, 33637 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-134132 | ENR | Joshua Aguilar | 1959-08-24 | UHC-27301-63 | 9344950086 | 6369 Oak St, San Antonio, TX, 78201 | 0.46 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+5 more |
| ENR-101756 | ENR | Arjun Gardner | 1987-08-28 | UHC-24635-15 | 4878303467 | 7270 Bayshore Dr, Denver, CO | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-109958 | ENR | Judith O Boyd | — | UHC-46308-61 | — | 9713 Desert Sky Blvd, Charlotte, NC, 28258 | 0.46 | Name re-casedDate of birth unreadablePhone missing area codeMember ID reformatted+5 more |
| ENR-132490 | ENR | Hiroshi Brooks | 1990-08-15 | UHC-65032-33 | 4385737130 | 2677 Washington St, Mesa, AZ | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-134884 | ENR | Dylan Padila | 1974-09-27 | UHC-64991-66 | 6059307896 | 8669 Meadow Ln Apt 38, Plano, TX, 75018 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more |
| ENR-110137 | ENR | Emma S Moore | 1940-06-16 | UHC-42322-25 | 4854941826 | 7623 Spring St, Eden Prairie, MN | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-140522 | ENR | Terry Arnold | 1941-04-23 | UHC-90021-63 | — | 6184 Pine Dr, San Antonio, TX | 0.46 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-112276 | ENR | Bradley W Jones | 1980-07-11 | UHC-91461-93 | 8189072740 | 2163 Baseline Rd, Las Vegas, NV, 89162 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-128292 | ENR | Hnery Chen | — | UHC-33237-14 | 3595577703 | 7603 Sunset Blvd, Dallas, TX, 75297 | 0.46 | Name re-casedDate of birth missingPhone reformattedMember ID reformatted+5 more |
| ENR-127559 | ENR | Kathleen UJunk | 1981-08-17 | UHC-96127-46 | 4137038990 | 3451 Sunset Blvd, Orlando, FL, 32860 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-119121 | ENR | Natalie Sims | — | UHC-65915-99 | 6168001734 | 3877 Main St, Las Vegas, NV, 89162 | 0.46 | Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-136623 | ENR | Valentina Payne | 1974-01-26 | UHC-22618-46 | 8846579959 | 4929 Church St, Jacksonville, FL, 32288 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-110806 | ENR | Jonathan Sanndoval | 1962-03-06 | UHC-01777-85 | 8107213077 | 2173 Mesa Dr Apt 33, Nashville, TN, 37299 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-105477 | ENR | Elijah M Delgado | 1982-04-20 | UHC-99236-88 | 2645003478 | 4532 Canyon Rd, Sacramento, CA | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |
| ENR-122462 | ENR | Evelyn P Colmean | 1987-02-14 | UHC-14941-93 | 2359681318 | 1338 Ridge Rd, Gilbert, AZ, 85253 | 0.46 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-104456 | ENR | Aisha N Cole | 1975-04-01 | UHC-86878-50 | 4593416989 | 4922 Cedar Ln, Minneapolis, MN | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more |
| ENR-125435 | ENR | Mary B Cook | 1976-10-13 | UHC-16807-52 | 2643791110 | 7214 Palm Dr Apt 36, Nashville, TN, 37249 | 0.46 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-105318 | ENR | Bryan Li | 1943-02-22 | UHC-16862-67 | 8793330394 | 5152 Central Ave, Glendale, AZ, 85386 | 0.46 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-105781 | ENR | Gerald Powell | 1948-10-22 | UHC-96423-73 | 2937337385 | 730 Camelback Rd, San Antonio, TX | 0.46 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-128863 | ENR | Walter Q Porter | 1954-07-21 | UHC-68877-75 | 4745678988 | 8571 Lincoln Way, Tempe, AZ, 85253 | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-128862 | ENR | Walter Q Porter | 1954-07-21 | UHC-68877-75 | 4745678988 | 8571 Lincoln Way, Tempe, AZ, 85253 | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-124231 | ENR | Sharon V Greene | 1982-12-09 | UHC-72907-79 | 4024881705 | 6821 Grand Ave # 981, Miami, FL, 33132 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more |
| ENR-112473 | ENR | Ruth U Larsun | 1960-08-11 | UHC-12479-78 | 5659225745 | 1086 Forest Ave, Denver, CO, 80224 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-127157 | ENR | Schmidt Sarah | 1965-01-28 | UHC-67055-10 | 4608207029 | 8051 Willow Ct # 958, San Diego, CA, 92166 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-134370 | ENR | Burce G Moore | 1964-11-19 | UHC-28109-74 | 3156653892 | 1620 Willow Ct, Mesa, AZ, 85236 | 0.46 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more |
| ENR-117844 | ENR | Gerald H Silva | 1976-09-23 | UHC-54444-80 | 2935575873 | 3638 Valley View Dr, San Antonio, TX, 78284 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-141739 | ENR | Lucia I Robertson | 1985-09-01 | UHC-90498-98 | 5993145405 | 4263 Cedar Ln, Tempe, AZ, 85289 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-122826 | ENR | Kelly T Day | 1983-01-19 | UHC-30774-01 | 9776229722 | 8106 Forest Ave, Gilbert, AZ, 85277 | 0.46 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more |
| ENR-102312 | ENR | Mariana Shaw | 1991-10-19 | UHC-03384-46 | 5577106620 | 1773 Park Pl Apt 29, Nashville, TN | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-140594 | ENR | Singh Katherine | 1989-10-16 | UHC-36821-73 | 7246348022 | 9696 Mountain View Dr, Denver, CO, 80209 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-123200 | ENR | Rachel F Maldonado | — | UHC-71621-23 | 5604859058 | 9202 Main St, Austin, TX, 78720 | 0.46 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+5 more |
| ENR-139679 | ENR | Mariana K Mitchell | 1972-03-12 | UHC-47406-20 | 7717381941 | 762 Sage Ct, Tempe, AZ | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-108623 | ENR | Justin G Cooper | 1991-11-18 | UHC-26825-50 | 2288619677 | 7406 Spring St, Miami, FL, 33143 | 0.46 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-116972 | ENR | Greg Washington | 1972-09-15 | UHC-30230-14 | 4474142347 | 9052 Forest Ave, San Diego, CA, 92177 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-117257 | ENR | Dlan Hunter | 1970-12-16 | UHC-44105-80 | 9209200762 | 4137 Sunset Blvd, Fresno, CA | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-135601 | ENR | Marilyn R Sullivan | 1952-05-20 | UHC-59465-80 | 2748519508 | 5246 Desert Sky Blvd, Miami, FL, 33143 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |