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-131486 | ENR | Aaron Holmes | 1996-05-19 | UHC-77158-63 | 9508664719 | 8374 Palm Dr, Glendale, AZ, 85352 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-127905 | ENR | Shirley L Morris | 1985-03-17 | UHC-89888-33 | 2182862611 | 7543 Canyon Rd, Atlanta, GA | 0.62 | Date of birth reformattedPhone reformattedState name converted to codeZIP missing+3 more |
| ENR-107301 | ENR | Brian X Martin | 1955-12-12 | UHC-59137-20 | — | 8828 Cedar Ln, Seattle, WA, 98113 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-130589 | ENR | Vicky G Cook | 1987-07-25 | UHC-08669-16 | 8377569564 | 2012 Ridge Rd Apt 22, San Antonio, TX, 78240 | 0.62 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-102616 | ENR | Scott Z Shaw | 1943-09-25 | UHC-47109-16 | 5699184977 | 663 Market St, Dallas, TX, 75296 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-141845 | ENR | Wayne V Dean | 1988-12-23 | UHC-74792-22 | 9394366445 | 5386 Church St, Plano, TX, 75056 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-134677 | ENR | Scott Garcia | 1938-10-27 | UHC-93685-32 | — | 5651 Market St, Mesa, AZ, 85228 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-108625 | ENR | Eugene G Cox | 1983-02-14 | UHC-38773-39 | 9205851897 | 28 Spring St Apt 20, Miami, FL, 33105 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-109541 | ENR | Lisa J Bryant | 1997-02-06 | UHC-10875-81 | 9268184628 | 5893 Meadow Ln, Nashville, TN, 37224 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-103912 | ENR | Santiago U Montgomery | 1957-05-16 | UHC-14592-19 | 5512532287 | 6139 Sunset Blvd, Plano, TX, 75047 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-120971 | ENR | Olivya D Hunter | 1948-05-23 | UHC-36158-75 | 2374301747 | 785 Cedar Ln Apt 40, Seattle, WA, 98166 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-114866 | ENR | Maria Y Sngh | 1987-02-18 | UHC-25269-47 | 4212876631 | 3060 Lincoln Way, Austin, TX, 78790 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-119356 | ENR | Carol Bishop | 1992-06-15 | UHC-23853-93 | 2999235884 | 8981 Church St, Columbus, OH, 43232 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135516 | ENR | Anna P Ortiz | 1950-04-27 | UHC-17770-72 | 4955288843 | 7138 Forest Ave, Jacksonville, FL, 32293 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-137194 | ENR | Denise D Dominguez | 1972-05-01 | UHC-13081-73 | 8045114895 | 2833 Palm Dr, Jacksonville, FL, 32276 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-142871 | ENR | Carol X Montgomery | 1940-02-12 | UHC-00036-56 | 5968147229 | 7758 Desert Sky Blvd, Tampa, FL, 33697 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-121898 | ENR | Valentina Y Johnson | 1952-12-16 | UHC-30272-86 | 7883367091 | 9880 Canyon Rd, San Diego, CA, 92191 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-118171 | ENR | Alexis F Peterson | 1971-06-13 | UHC-41655-03 | 2862788240 | 3155 Camelback Rd, Austin, TX, 78766 | 0.62 | Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more |
| ENR-105955 | ENR | Torres Janet | 1984-02-13 | UHC-48740-56 | 5929955683 | 4107 Bayshore Dr, Phoenix, AZ, 85014 | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112485 | ENR | Margaret L Stone | 1979-11-12 | UHC-82032-35 | 5038517790 | 5524 Pine Dr, Plano, TX, 75014 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-115160 | ENR | Kimberly T Berry | 1983-04-14 | UHC-52540-52 | 6779848631 | 8813 Apache Blvd, Mesa, AZ, 85226 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120255 | ENR | Walter Aguilar | 2001-02-15 | UHC-45116-92 | 9019774333 | 2327 Ridge Rd, Dallas, TX, 75247 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-123128 | ENR | Jesse Walsh | 1944-08-24 | UHC-06548-56 | — | 5398 Willow Ct, Seattle, WA, 98151 | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-111975 | ENR | Willie Stephens | 1957-11-02 | UHC-37196-32 | 6005121032 | 9514 Maple Ave, Mesa, AZ | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+3 more |
| ENR-119151 | ENR | Jeffrey Morales | 1946-12-07 | UHC-24187-91 | 6006902413 | 6273 Harbor Blvd, Tempe, AZ, 85246 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-128388 | ENR | Justin Maldonado | 1979-10-04 | UHC-51965-78 | 8946478089 | 199 Washington St, Miami, FL | 0.62 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-126660 | ENR | Elijah A Willaims | 1995-05-03 | UHC-10327-07 | 4655312447 | 3403 Valley View Dr, Phoenix, AZ | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-101432 | ENR | Sandoval P Willie | 2000-02-15 | UHC-46612-21 | — | 5599 River Rd, Fresno, CA, 93749 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-107683 | ENR | Randy Reid | 1953-07-28 | UHC-70283-31 | 4143437462 | 8551 Washington St, Las Vegas, NV, 89101 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-127921 | ENR | Rebecca Park | 1981-01-12 | UHC-63041-07 | 5574085092 | 119 Market St, Fresno, CA, 93758 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-111261 | ENR | Anna Mason | 1996-04-17 | UHC-83078-50 | 2546820406 | 5640 Harbor Blvd, Tucson, AZ, 85781 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-124340 | ENR | Bruce R Sanchez | 1958-03-21 | UHC-55488-72 | 7244931820 | 2162 Hillcrest Rd, Sacramento, CA, 95843 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109186 | ENR | Roy M Burke | 1983-06-10 | UHC-62696-46 | 9533327951 | 3888 Oak St, Orlando, FL, 32865 | 0.62 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-120095 | ENR | Jeremy X Vegga | 1977-08-14 | UHC-89426-04 | — | 3125 Sunset Blvd, Denver, CO, 80214 | 0.62 | Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+3 more |
| ENR-112707 | ENR | Bishop Kathleen | 1956-12-25 | UHC-56849-46 | 4532993828 | 9143 Grand Ave, San Antonio, TX, 78206 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-131733 | ENR | Charles P Murray | 1952-01-15 | UHC-35400-66 | 6703295030 | 8544 Apache Blvd, Nashville, TN, 37208 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133441 | ENR | Diego Kennedy | — | UHC-03807-20 | 4146203493 | 6394 Central Ave, Los Angeles, CA, 90071 | 0.62 | Date of birth missingPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-103429 | ENR | Natalie Payne | 1987-09-12 | UHC-22342-22 | 6493787170 | 2230 Palm Dr, Mesa, AZ | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-130408 | ENR | Joseph F Rice | 1940-03-25 | UHC-28149-34 | 2445973218 | 2675 Ocean Ave, Austin, TX | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-106241 | ENR | Amanda P Ward | 1970-02-23 | UHC-44504-28 | 3816714921 | 177 Park Pl, Columbus, OH, 43278 | 0.62 | Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128679 | ENR | Andrew K Tucker | 1980-06-07 | UHC-92091-72 | 8538245953 | 336 Indian School Rd, Sacramento, CA, 95842 | 0.62 | Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more |
| ENR-131386 | ENR | Willie G Schmidt | 2001-04-01 | UHC-48367-52 | 6686292085 | 7045 Desert Sky Blvd, Jacksonville, FL, 32210 | 0.62 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-117648 | ENR | Barbara C Edwards | 1951-10-01 | UHC-91524-18 | 8699664205 | 4467 Ocean Ave, Seattle, WA, 98174 | 0.62 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-106405 | ENR | Kayla G Rojas | 1987-03-19 | UHC-99967-49 | — | 2708 Bayshore Dr, Denver, CO, 80251 | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-110306 | ENR | Christopher I Santos | 1995-05-06 | UHC-66123-93 | 3859521845 | 609 Spring St, Eden Prairie, MN, 55332 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-102445 | ENR | Frances Ray | 1988-10-13 | UHC-36209-53 | 2533795889 | 2798 Mesa Dr Apt 34, Charlotte, NC, 28263 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-107547 | ENR | Anna Meyer | 1938-09-23 | UHC-27108-48 | 7529064013 | 1046 Palm Dr, Houston, TX, 77007 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-117446 | ENR | Eric S Barnes | 1982-03-02 | UHC-25921-67 | 7614412740 | 927 Palm Dr # 906, Charlotte, NC, 28260 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-133401 | ENR | Kevin Warren | 1988-06-20 | UHC-45262-71 | 5955916148 | 1936 Indian School Rd, Columbus, OH, 43268 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-127443 | ENR | Paul D Benett | 1970-06-17 | UHC-74898-50 | 9694094238 | 479 Camelback Rd, Austin, TX, 78772 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |