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
All sources, flag “State name converted to code”, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| ENR-116886 | ENR | Martha Y Elliott | 1995-11-26 | — | 2856366646 | 5196 Lake View Rd, Tampa, FL, 33602 | 0.82 | Date of birth reformattedState name converted to codeEmail lower-cased |
| ENR-105204 | ENR | Mark Hudson | 2002-05-17 | UHC-88797-59 | 3323772261 | 2758 Broadway, Gilbert, AZ, 85283 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| TPA-55205 | TPA | Aaron Sandoval | 2006-04-13 | — | — | 8939 Valley View Dr, Jacksonville, FL, 32220 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| ENR-124245 | ENR | Joseph Vargas | 1967-03-08 | UHC-78519-23 | 7969068393 | 8941 Baseline Rd, Tempe, AZ, 85247 | 0.82 | Date of birth reformattedState name converted to codeWhitespace trimmed |
| ENR-135000 | ENR | Eric Fosteer | 1953-07-26 | UHC-04955-08 | 3585718910 | 4997 Elm St, Tempe, AZ, 85241 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| CLM-408715 | CLM | Diane B Hernandez | 1958-05-05 | UHC-01294-03 | 9364793791 | 3542 Ridge Rd, Orlando, FL, 32821 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-401967 | CLM | Nathan Carpenter | 1959-06-26 | UHC-33486-31 | 7788386260 | 3681 Meadow Ln, Scottsdale, AZ, 85218 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| ENR-126879 | ENR | Katherine F Washington | 1954-07-10 | UHC-56868-26 | 3405341092 | 9106 Valley View Dr, Glendale, AZ, 85388 | 0.82 | Date of birth reformattedState name converted to codeWhitespace trimmed |
| CLM-431214 | CLM | Sophia Daniels | 1983-05-06 | — | — | 9788 Jefferson Ave, Denver, CO, 80275 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-409928 | CLM | Evelyn Gardner | 1981-08-14 | UHC-86706-87 | 7355625257 | 7508 Highland Ave, Los Angeles, CA, 90020 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| ENR-100442 | ENR | Anthony K Armstrong | 1939-07-20 | UHC-62796-06 | 8882006534 | 5629 Harbor Blvd, Houston, TX, 77055 | 0.82 | State name converted to codeEmail lower-casedWhitespace trimmed |
| ENR-135065 | ENR | Bobby Ferguson | 1975-12-21 | UHC-85211-32 | 6909679502 | 3949 Broadway, Sacramento, CA, 95828 | 0.82 | Name re-casedAddress re-casedState name converted to code |
| ENR-140802 | ENR | Aaron X Vargas | 1963-06-02 | UHC-28405-72 | 4843342474 | 9066 Cedar Ln, Sacramento, CA, 95865 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| ENR-114551 | ENR | Donna G Cruz | 1958-07-02 | UHC-86514-39 | 3567959915 | 431 Camelback Rd, Minneapolis, MN, 55430 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| ENR-119416 | ENR | Brenda H Singh | 1973-12-05 | UHC-47269-68 | 2684378600 | 1625 Lake View Rd, Seattle, WA, 98123 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| CLM-407988 | CLM | Katherine E Ford | 1993-07-16 | UHC-11119-53 | — | 9302 Main St, Tucson, AZ, 85720 | 0.82 | State name converted to codeEmail lower-casedWhitespace trimmed |
| PRV-26642 | PRV | Helen Williams | 1978-04-25 | UHC-69324-22 | 3814271921 | 1803 Bayshore Dr, San Antonio, TX, 78208 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| ENR-109582 | ENR | Jean D Black | 2006-07-24 | UHC-16293-86 | 7765838904 | 7087 Lincoln Way, Nashville, TN, 37274 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| CLM-427235 | CLM | Joseph G Turner | 1957-06-14 | — | — | 4916 Camelback Rd, Tampa, FL, 33682 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-116334 | ENR | Juan Cooper | 1957-12-25 | UHC-84981-77 | 2476641286 | 4091 Indian School Rd, Fresno, CA, 93762 | 0.82 | City re-casedState name converted to codeWhitespace trimmed |
| ENR-111418 | ENR | Alan Wright | 1989-12-18 | UHC-55110-52 | 8023353758 | 3178 Lincoln Way, Seattle, WA, 98157 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-419223 | CLM | Amy Carroll | 1993-12-13 | UHC-63613-61 | — | 3972 River Rd, Atlanta, GA, 30398 | 0.82 | Member ID reformattedState name converted to codePlaceholder values cleared |
| PRV-28679 | PRV | Diane P Snyder | 1952-05-14 | — | — | 2666 Spring St, Austin, TX, 78738 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| CLM-421678 | CLM | Yuki Gonzales | 1983-06-23 | UHC-45856-82 | — | 7979 Pine Dr, Charlotte, NC, 28244 | 0.82 | Member ID reformattedState name converted to codePlaceholder values cleared |
| TPA-64175 | TPA | Adam Schmidt | 1973-02-12 | — | — | 3416 Palm Dr, Orlando, FL, 32827 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-134807 | ENR | Elijah Morales | 1950-03-08 | UHC-10705-85 | 5423397098 | 7332 Forest Ave, Columbus, OH, 43216 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| CLM-413364 | CLM | Andrew P Ramos | 1951-09-27 | UHC-09140-27 | 9076343928 | 2590 Market St, Dallas, TX, 75211 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| PRV-21257 | PRV | Denny Simmons | 1983-04-07 | — | 8409043209 | 2133 Apache Blvd, Austin, TX, 78720 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-403831 | CLM | Lori Wells | 1955-02-07 | — | 4527102603 | 7001 Meadow Ln, Los Angeles, CA, 90036 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-110554 | ENR | Gary Z Sandoval | 1987-07-20 | UHC-91237-16 | 4432608822 | 2024 Valley View Dr, Los Angeles, CA, 90081 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| CLM-417356 | CLM | Paul Woods | 2007-09-24 | UHC-41066-57 | — | 8824 Spring St, Scottsdale, AZ, 85296 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| PRV-25875 | PRV | Anna Grant | 1985-06-28 | UHC-58902-34 | 2085096051 | 9801 Jefferson Ave, Columbus, OH, 43214 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| CLM-418316 | CLM | Joan Anderson | 1968-07-17 | — | 3468447514 | 3501 Washington St, Orlando, FL, 32868 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-123139 | ENR | Anthony D Contreras | 2001-05-20 | UHC-98576-80 | 8358703402 | 6242 Desert Sky Blvd, Miami, FL, 33159 | 0.82 | Name re-casedState name converted to codeWhitespace trimmed |
| TPA-55948 | TPA | Noah Padilla | 1984-09-20 | — | — | 5201 Highland Ave, Austin, TX, 78774 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| PRV-27438 | PRV | Sandoval V Deborah | 1948-06-07 | — | 3176322535 | 7276 Willow Ct, Minneapolis, MN, 55467 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| TPA-57656 | TPA | Judy Pierce | 1991-02-15 | — | — | 2875 Maple Ave, San Antonio, TX, 78239 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-102893 | ENR | Camila Martinez | 1995-03-24 | UHC-83618-98 | 6546998141 | 3375 Mesa Dr, Atlanta, GA, 30375 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| TPA-57921 | TPA | John Hicks | 1965-03-05 | — | — | 5013 Sage Ct, Miami, FL, 33176 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-115498 | ENR | Kim Y Vazquez | 1959-02-18 | UHC-98212-72 | — | 7007 Church St, Mesa, AZ, 85246 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| PRV-27012 | PRV | Dennis Alvarez | 1979-08-21 | — | — | 3110 Desert Sky Blvd, Plano, TX, 75063 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| ENR-114615 | ENR | Sean U Fields | 1971-03-17 | UHC-34368-01 | 4694156981 | 8945 Baseline Rd, Chandler, AZ, 85275 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| CLM-418840 | CLM | Jonathan Aguilar | 1951-05-10 | UHC-85529-50 | — | 2803 Palm Dr, Seattle, WA, 98184 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| PRV-22044 | PRV | Heather Duncan | 1958-11-01 | UHC-89472-32 | 6719271132 | 7625 Desert Sky Blvd, Dallas, TX, 75279 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| ENR-101914 | ENR | Willie Chen | 1948-01-05 | UHC-53221-26 | 2966266483 | 4617 Park Pl, Scottsdale, AZ, 85287 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| ENR-140892 | ENR | Victoria Watson | 1965-04-28 | UHC-16748-13 | 6152945436 | 5576 Sunset Blvd, Glendale, AZ, 85367 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| ENR-139736 | ENR | Sofia N McCoy | 1945-07-01 | UHC-12731-65 | 5383870124 | 2722 Willow Ct, Scottsdale, AZ, 85289 | 0.82 | State name converted to codeEmail lower-casedWhitespace trimmed |
| PRV-28680 | PRV | Kenneth Cox | 1953-06-17 | UHC-45864-37 | — | 3484 Maple Ave, Glendale, AZ, 85331 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-102480 | ENR | Stephanie Cole | 1997-09-22 | UHC-53992-59 | 2058735435 | 4353 Ocean Ave, Houston, TX, 77031 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| ENR-114250 | ENR | Christian Lopez | 1986-05-17 | UHC-99195-40 | 6809002567 | 6459 Jefferson Ave, Seattle, WA, 98150 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |