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 |
|---|---|---|---|---|---|---|---|---|
| PRV-25695 | PRV | Cynthia Lopez | 2003-11-17 | — | 3319725403 | 4377 Washington St, Austin, TX, 78715 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| TPA-63585 | TPA | Randy Woods | 1949-10-25 | — | — | 8616 Camelback Rd, Jacksonville, FL, 32235 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-413731 | CLM | Sara Franklin | 1955-09-04 | UHC-76769-82 | — | 3518 Central Ave, Las Vegas, NV, 89141 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| ENR-142833 | ENR | Joan N Silva | 1968-06-25 | UHC-84623-38 | 7258589637 | 5289 Mountain View Dr, Columbus, OH, 43287 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| ENR-123978 | ENR | Eugene Gordon | 2000-06-13 | UHC-51400-98 | 3958359187 | 3363 Forest Ave, Las Vegas, NV, 89134 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| ENR-104603 | ENR | Maria Chavez | 1966-05-25 | UHC-22088-39 | 3435827211 | 9462 Mountain View Dr, Atlanta, GA, 30318 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| TPA-52856 | TPA | Luis Reed | 1944-04-24 | — | 2423077489 | 3980 Meadow Ln, Orlando, FL, 32821 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| ENR-131459 | ENR | Grake T Kelly | 1948-11-19 | UHC-37534-77 | 3454961591 | 884 Grand Ave, Nashville, TN, 37265 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| ENR-135420 | ENR | Andrea T Cunningham | 1943-06-09 | UHC-36872-64 | 7334317270 | 976 Bayshore Dr, Atlanta, GA, 30365 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| TPA-61898 | TPA | Mason Fuller | 2006-01-11 | — | — | 6548 Washington St, Austin, TX, 78700 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| TPA-60124 | TPA | Kelly Silva | 1965-06-28 | — | — | 5859 Spring St, Eden Prairie, MN, 55313 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-106417 | ENR | Chuck K Fernandez | 1978-08-07 | UHC-24771-49 | 9172822558 | 9216 Main St, Eden Prairie, MN, 55335 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-118510 | ENR | Sam D Jones | 1955-08-22 | UHC-22027-29 | 3436143556 | 3113 Oak St, Atlanta, GA, 30376 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| ENR-124909 | ENR | Amanda Muonz | 1955-09-15 | UHC-84667-95 | 2349923464 | 7334 Cedar Ln, Sacramento, CA, 95858 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| TPA-61756 | TPA | Barbara Johnston | 1973-12-10 | — | 8266139748 | 7133 Apache Blvd, Tampa, FL, 33651 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-120303 | ENR | Priya Simpson | 1997-11-22 | — | 7079954573 | 5204 Meadow Ln, Columbus, OH, 43257 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| TPA-62183 | TPA | Deborah Nichols | 1990-01-21 | — | 2984751728 | 7500 Broadway, Tampa, FL, 33601 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-404392 | CLM | Bradley Marquez | 2003-05-02 | UHC-30238-54 | — | 7375 Lake View Rd, Chandler, AZ, 85254 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| PRV-25130 | PRV | Alexis J West | 1996-10-23 | — | — | 5812 Church St, Dallas, TX, 75264 | 0.82 | State name converted to codeEmail lower-casedPlaceholder values cleared |
| ENR-117321 | ENR | Adam B Ruiz | 1949-03-03 | UHC-14238-60 | — | 2103 Harbor Blvd, Phoenix, AZ, 85042 | 0.82 | Date of birth reformattedState name converted to codeWhitespace trimmed |
| ENR-130375 | ENR | Joshua E Morris | 2006-05-07 | UHC-36471-25 | 8165555804 | 8949 Mesa Dr, Houston, TX, 77074 | 0.82 | Name re-casedState name converted to codeEmail lower-cased |
| CLM-419387 | CLM | Shirley Gutierrez | 1958-08-13 | UHC-95109-52 | — | 2473 Willow Ct, San Antonio, TX, 78276 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-123593 | ENR | Larry Rogers | 1970-02-10 | UHC-32272-09 | 4189493983 | 7957 Highland Ave, Eden Prairie, MN, 55349 | 0.82 | State name converted to codeEmail lower-casedWhitespace trimmed |
| ENR-118227 | ENR | Mary Martinez | 1975-06-28 | UHC-53383-92 | 8996544642 | 1478 Church St, Columbus, OH, 43234 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| CLM-421820 | CLM | Vincent W Padilla | 1986-01-12 | UHC-44861-15 | — | 1843 Central Ave, San Diego, CA, 92180 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| TPA-61091 | TPA | Camila Hanson | 2008-01-09 | — | 9133989663 | 9600 Lincoln Way, Nashville, TN, 37256 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| ENR-126505 | ENR | Pamela B Brooks | 1965-09-10 | UHC-52321-23 | — | 3184 Meadow Ln, Scottsdale, AZ, 85271 | 0.82 | Member ID reformattedState name converted to codeWhitespace trimmed |
| ENR-132143 | ENR | Philip Maldonado | 1995-01-07 | UHC-05637-01 | 2824773887 | 7707 Palm Dr, Tempe, AZ, 85228 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| ENR-133061 | ENR | Beverly E Nunez | 1952-01-05 | UHC-25845-36 | 7086295485 | 8457 Desert Sky Blvd, San Diego, CA, 92174 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| PRV-20500 | PRV | Abigail O Perkins | 1971-04-28 | UHC-99873-07 | — | 7914 Oak St, Columbus, OH, 43289 | 0.82 | Name re-casedDate of birth reformattedState name converted to code |
| ENR-130301 | ENR | Matthew Ferguson | 1995-03-20 | UHC-66125-48 | 5806281556 | 1582 Camelback Rd, Houston, TX, 77086 | 0.82 | State name converted to codeEmail lower-casedWhitespace trimmed |
| TPA-57456 | TPA | Michelle Andrews | 1993-08-24 | — | 2377871199 | 6315 Highland Ave, Orlando, FL, 32874 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| CLM-415901 | CLM | Rachal Alen | 1990-08-27 | UHC-61641-27 | — | 1261 Lake View Rd, Chandler, AZ, 85284 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| TPA-64336 | TPA | Joe Stevens | 1952-07-16 | — | — | 6977 Apache Blvd, Seattle, WA, 98174 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-413193 | CLM | Jackie Wattson | 2005-05-22 | UHC-06280-11 | 5204923549 | 1973 Cedar Ln, Tucson, AZ, 85733 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| CLM-419624 | CLM | Logan Jacobs | 2008-01-17 | — | — | 1439 Church St, Gilbert, AZ, 85242 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-112916 | ENR | Debra Q Lee | 1977-01-25 | UHC-96470-57 | 7693478346 | 2601 Hillcrest Rd, Jacksonville, FL, 32231 | 0.82 | Name re-casedDate of birth reformattedState name converted to code |
| CLM-425682 | CLM | Arjun Jensen | 1978-03-02 | UHC-55251-35 | — | 7875 River Rd, Las Vegas, NV, 89115 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| PRV-28456 | PRV | Shirley Patel | 1990-11-08 | — | — | 8596 Mountain View Dr, Fresno, CA, 93740 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| TPA-57303 | TPA | Frnk Kelley | 1942-02-28 | UHC-40168-92 | 4224129873 | 4477 Sunset Blvd, Jacksonville, FL, 32204 | 0.82 | City re-casedState name converted to codeWhitespace trimmed |
| TPA-54156 | TPA | Roy Crawford | 1991-07-27 | — | — | 6673 Oak St, Seattle, WA, 98175 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| CLM-408180 | CLM | Lucia Cox | 1983-07-14 | UHC-14104-68 | 4206251798 | 7864 Harbor Blvd, Fresno, CA, 93710 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| TPA-57865 | TPA | Amy Ferguson | 1944-01-22 | UHC-39422-02 | — | 3896 Camelback Rd, Tucson, AZ, 85757 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| TPA-62693 | TPA | Andrea Boyd | 2001-04-15 | UHC-99046-48 | — | 6842 Harbor Blvd, Columbus, OH, 43208 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| PRV-27664 | PRV | Sara Gordon | 1942-10-07 | — | 3573169412 | 7925 Highland Ave, Tampa, FL, 33697 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| ENR-103262 | ENR | Katherine K Martin | 1977-03-27 | UHC-75180-73 | 6539376502 | 343 Washington St, Los Angeles, CA, 90039 | 0.82 | Date of birth reformattedCity re-casedState name converted to code |
| CLM-401185 | CLM | Victoria Hawkins | 1978-02-12 | UHC-25243-57 | 7876796539 | 1995 Spring St, Las Vegas, NV, 89155 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| TPA-61359 | TPA | Amber Jordan | 1985-02-17 | — | — | 1088 Sunset Blvd, Seattle, WA, 98186 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-124030 | ENR | Walter R Stewart | 1987-11-13 | UHC-24161-31 | 4734252957 | 6528 Camelback Rd, Gilbert, AZ, 85218 | 0.82 | Date of birth reformattedPhone reformattedState name converted to code |
| ENR-124029 | ENR | Walter R Stewart | 1987-11-13 | UHC-24161-31 | 4734252957 | 6528 Camelback Rd, Gilbert, AZ, 85218 | 0.82 | Date of birth reformattedPhone reformattedState name converted to code |