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-116255 | ENR | Charlie Soto | 1980-10-08 | UHC-26975-03 | 3764246105 | 833 Jefferson Ave, Eden Prairie, MN, 55352 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-111309 | ENR | Ahmed Peters | 1946-01-14 | UHC-83992-23 | 7319567631 | 9559 Spring St, Seattle, WA, 98172 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-140415 | ENR | Sarah D Simpson | 1949-03-19 | UHC-92684-12 | 3025034767 | 7775 Valley View Dr # 785, Austin, TX, 78798 | 0.60 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-109270 | ENR | Mark K Fisher | 1990-05-05 | — | — | 585 Spring St Apt 24, Chandler, AZ, 85258 | 0.60 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-109269 | ENR | Mark K Fisher | 1990-05-05 | — | — | 585 Spring St Apt 24, Chandler, AZ, 85258 | 0.60 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-142859 | ENR | Jeremy Jacobs | 1965-10-04 | UHC-51630-28 | 5878285211 | 4442 Meadow Ln, Seattle, WA, 98134 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-115815 | ENR | Jerry Y Price | 1957-10-17 | UHC-62204-46 | 4324037551 | 563 Desert Sky Blvd, Glendale, AZ, 85340 | 0.60 | Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more |
| ENR-100485 | ENR | Munoz Elizabeth | 1982-02-13 | UHC-40216-61 | — | 4165 Willow Ct, Columbus, OH, 43235 | 0.60 | Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-113015 | ENR | Ronald S Hunt | 1965-02-09 | UHC-85178-59 | — | 2077 Ridge Rd, Scottsdale, AZ, 85276 | 0.60 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-130134 | ENR | Kimberly P Gutierrez | 2007-02-14 | UHC-33455-54 | 7488836952 | 7415 Ridge Rd, Jacksonville, FL, 32204 | 0.60 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-125027 | ENR | Anthony Weber | 1986-11-02 | UHC-65934-35 | 4307245735 | 1777 River Rd, Mesa, AZ, 85277 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-104216 | ENR | Terry Rodriugez | 1964-02-21 | UHC-76538-79 | 3492659436 | 2114 Ocean Ave, Fresno, CA, 93791 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-104217 | ENR | Terry Rodriugez | 1964-02-21 | UHC-76538-79 | 3492659436 | 2114 Ocean Ave, Fresno, CA, 93791 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-125663 | ENR | Willie X Martin | 1953-11-25 | UHC-69388-74 | 3206206265 | 1258 Union St, Nashville, TN, 37256 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-137933 | ENR | Victoria Nunze | 1991-02-24 | UHC-10473-09 | 7912379308 | 5348 Central Ave, Houston, TX, 77087 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-128668 | ENR | Megan Evans | 1970-09-20 | — | 3592274876 | 7587 Market St, Houston, TX, 77091 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-103359 | ENR | Catherine Mendez | 1966-11-23 | UHC-56577-77 | 2997021880 | 125 Church St, San Diego, CA, 92135 | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-129929 | ENR | Randy Stewart | 1955-03-05 | UHC-05456-20 | — | 8689 Grand Ave, San Diego, CA, 92137 | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-130818 | ENR | Franklin Saarah | 1979-02-19 | UHC-19757-48 | 6752135009 | 5484 Central Ave, Sacramento, CA | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-138236 | ENR | Evelyn Grant | 1977-07-28 | UHC-10977-25 | 5597806749 | 1772 Mountain View Dr # 232, Minneapolis, MN, 55442 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-121532 | ENR | Grace U Soto | 1948-12-28 | UHC-03021-42 | — | 9467 Harbor Blvd, Chandler, AZ, 85281 | 0.60 | Middle initial moved out of first nameName re-casedMember ID reformattedStreet suffix standardised+4 more |
| ENR-108810 | ENR | Megan X Le | 1985-01-07 | — | 3237450606 | 3665 Washington St, Tampa, FL, 33636 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-132604 | ENR | Andrew H Palmer | 1939-02-02 | UHC-25445-68 | 4727111552 | 4190 Meadow Ln, Sacramento, CA | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-115696 | ENR | Kimberly I Hunter | 1983-09-07 | UHC-75741-71 | 7283996473 | 3181 Forest Ave, San Antonio, TX, 78290 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-117241 | ENR | Helen K Morales | 1959-10-23 | UHC-42089-79 | 3252917069 | 3155 Apache Blvd, Los Angeles, CA, 90026 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-125962 | ENR | Theresa G Ruiz | 1938-05-07 | UHC-19329-14 | 8887560910 | 5807 Bayshore Dr, Columbus, OH, 43290 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-126565 | ENR | Maria Gonzales | 1966-05-05 | UHC-94421-13 | 9815902792 | 8457 Cedar Ln, Tempe, AZ, 85287 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-110022 | ENR | Frank M Tarn | 1951-05-03 | UHC-06995-33 | 6883038399 | 1692 Sunset Blvd Apt 27, San Diego, CA, 92149 | 0.60 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-107104 | ENR | Marcus Spencer | 1947-03-27 | UHC-75217-26 | — | 8143 Oak St, Miami, FL, 33127 | 0.60 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more |
| ENR-134221 | ENR | Russell L Ruiz | 1988-10-09 | UHC-24684-36 | 6944616234 | 5862 Jefferson Ave, Sacramento, CA | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-103159 | ENR | Alexis N Nguyen | 1960-09-04 | UHC-40777-06 | 4247615077 | 9279 Forest Ave, Houston, TX, 77040 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-108298 | ENR | Billy Lopez | 1986-07-01 | UHC-13319-91 | 4766387685 | 5763 Hillcrest Rd, Gilbert, AZ, 85202 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-101187 | ENR | Ramos M Ryan | 1957-10-11 | UHC-44488-08 | 5743513230 | 5901 Apache Blvd, Mesa, AZ, 85208 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-107840 | ENR | Rachel M West | 1951-09-13 | UHC-58253-49 | 2376717144 | 6249 Harbor Blvd # 352, Houston, TX, 77067 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| ENR-124878 | ENR | Maggie Banks | 1980-03-24 | UHC-08433-75 | — | 4041 Market St, Jacksonville, FL, 32234 | 0.60 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-133999 | ENR | Dorothy R Salazar | 1992-09-11 | UHC-11013-30 | 5905830646 | 3621 Park Pl, San Antonio, TX, 78258 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-123322 | ENR | Amy Boyd | 1941-04-09 | UHC-38686-34 | 5793209927 | 2242 Indian School Rd, Tampa, FL, 33655 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-125481 | ENR | Philip Bradley | 1959-11-21 | UHC-70449-36 | 4068911868 | 411 Sunset Blvd, Mesa, AZ, 85242 | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-123063 | ENR | Nicole Maldonado | 2000-01-09 | UHC-52377-23 | 5316962577 | 8288 Bayshore Dr, Orlando, FL, 32801 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-141763 | ENR | Gary Q Peters | 1974-05-07 | UHC-57117-44 | 6122374597 | 157 Spring St, Columbus, OH, 43230 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-105355 | ENR | Joshua Mendoza | 1954-10-27 | UHC-08725-60 | 9532876576 | 650 Valley View Dr, Houston, TX, 77067 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-104002 | ENR | Ranyd Ward | 1980-01-25 | UHC-24436-39 | 7975544450 | 1813 Union St # 905, Plano, TX, 75009 | 0.60 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more |
| ENR-115764 | ENR | Charlotte Vargas | 1977-08-08 | UHC-37948-31 | 9469432870 | 3912 Harbor Blvd, Minneapolis, MN, 55471 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-116025 | ENR | Sarah Sullivan | 1968-10-17 | UHC-55633-98 | 3043402380 | 4140 Highland Ave # 395, San Diego, CA, 92155 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-135978 | ENR | Hannah Z Palmer | 1971-02-15 | UHC-66921-31 | 2983609730 | 3561 Oak St, Charlotte, NC, 28284 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-108944 | ENR | Virginia Clark | 1948-02-25 | UHC-21787-94 | 9696052278 | 670 Sage Ct, Glendale, AZ, 85356 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-112074 | ENR | Zachary O Nichols | 1973-09-11 | UHC-39053-23 | 6344942060 | 7771 Harbor Blvd, Atlanta, GA, 30378 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-141931 | ENR | Michael C Kim | — | UHC-02686-18 | 9009701989 | 351 Union St, Austin, TX, 78787 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more |
| ENR-132427 | ENR | Ahmed Lewis | 1992-06-19 | UHC-65200-10 | 8107477113 | 2645 Forest Ave, Columbus, OH, 43209 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-111417 | ENR | Danielle Warren | 1978-07-03 | UHC-02346-95 | 2193497984 | 4650 Maple Ave, Plano, TX, 75033 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |