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-112430 | ENR | Bobby Hernandez | 1974-07-03 | UHC-97966-71 | 3022428803 | 6500 Harbor Blvd, Orlando, FL, 32849 | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-127109 | ENR | Alice Mendoza | 1973-07-01 | UHC-85886-84 | 3163785373 | 4821 Cedar Ln, Atlanta, GA, 30336 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-109813 | ENR | Mason Ramirez | 1964-05-03 | UHC-58089-01 | — | 3165 Spring St, Fresno, CA, 93769 | 0.48 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more |
| ENR-103209 | ENR | Keith Mills | 1940-08-12 | UHC-71507-37 | 9135190687 | 3588 Canyon Rd, Plano, TX | 0.48 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-114695 | ENR | Jonathan W Lawson | 1945-03-06 | UHC-79224-89 | 8564140716 | 12 Forest Ave, San Antonio, TX, 78210 | 0.48 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more |
| ENR-111556 | ENR | Nathan Rose | 1964-05-05 | UHC-57831-42 | — | 439 Baseline Rd, Denver, CO | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-115169 | ENR | Logan N Collins | — | UHC-11070-99 | 5114008104 | 9814 Pine Dr, Las Vegas, NV, 89137 | 0.48 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-107032 | ENR | Nicole Hanson | 2006-01-09 | UHC-87068-62 | 5768526252 | 3984 River Rd, Jacksonville, FL, 32217 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-120857 | ENR | Jordan Carroll | 1999-11-13 | UHC-70296-29 | 9327809077 | 3188 Desert Sky Blvd, Atlanta, GA, 30357 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-127700 | ENR | Joyce S Perez | 1958-08-13 | UHC-34295-45 | 6864413846 | 8692 Hillcrest Rd, Miami, FL, 33106 | 0.48 | Date of birth reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-129439 | ENR | Elijah Cerr | 1980-02-25 | UHC-17312-61 | 5356770932 | 8995 Sunset Blvd, Miami, FL, 33157 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-126821 | ENR | Jesse Thomas | 1968-01-15 | UHC-48971-29 | 3866148478 | 1706 Valley View Dr, Miami, FL, 33168 | 0.48 | Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-101268 | ENR | Joan Singh | 1960-03-25 | UHC-03484-76 | 7248919613 | 5676 Palm Dr # 496, Eden Prairie, MN, 55317 | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-100284 | ENR | George R Knight | 1976-08-20 | UHC-05781-78 | 4034327514 | 5156 Palm Dr, Gilbert, AZ | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-121912 | ENR | Kathryn Y Perkins | 1951-10-26 | UHC-15775-34 | 3214850266 | 8788 Highland Ave, Charlotte, NC | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-139904 | ENR | Emily F Ortiz | 1959-03-07 | UHC-21261-58 | 7145428920 | 9081 Willow Ct # 686, Charlotte, NC, 28203 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-114765 | ENR | Russell V Donald | 1974-02-22 | UHC-63213-46 | 7492927220 | 5913 Maple Ave, Houston, TX, 77046 | 0.48 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more |
| ENR-102535 | ENR | Lisa L Thompson | 1939-05-26 | UHC-64914-64 | 9324547658 | 6126 Ridge Rd # 441, Houston, TX, 77096 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-115085 | ENR | Victoria O Cooper | 1960-10-11 | UHC-00539-49 | 3323998149 | 6043 Forest Ave, Charlotte, NC | 0.48 | Name re-casedSSN last four extractedCity re-casedState name converted to code+4 more |
| ENR-125753 | ENR | Laura OJunk | 1969-02-08 | UHC-98868-67 | 3154633883 | 2369 Bayshore Dr, Dallas, TX, 75253 | 0.48 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-103126 | ENR | Lori King | 1957-04-06 | UHC-92761-58 | 3412408898 | 3025 Lake View Rd, Jacksonville, FL | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-124214 | ENR | Helen Oliver | 1978-08-26 | UHC-84939-80 | 7446677328 | 7301 Church St, Columbus, OH, 43250 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-101152 | ENR | Fatima E Nguyen | 1984-03-14 | UHC-77642-95 | 9804492578 | 2819 Palm Dr Apt 39, Houston, TX, 77080 | 0.48 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-118950 | ENR | Jacqueline E Spencer | — | UHC-18603-59 | — | 1667 Camelback Rd, Tampa, FL, 33622 | 0.48 | Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more |
| ENR-142146 | ENR | Margaret M Stone | 1939-12-20 | UHC-82602-39 | 9749293907 | 854 River Rd, Phoenix, AZ, 85041 | 0.48 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-123326 | ENR | Elizabeth Pierce | 1956-05-17 | UHC-85478-50 | 7536361557 | 1579 Union St, Gilbert, AZ, 85267 | 0.48 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-114497 | ENR | Roger Nunez | 1974-03-26 | UHC-36065-06 | 8719846154 | 7888 Market St, Glendale, AZ | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-121465 | ENR | Alexander Sttone | 1954-02-21 | UHC-79178-97 | — | 5648 Harbor Blvd, Atlanta, GA, 30352 | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more |
| ENR-124990 | ENR | Helen G Mendez | 1949-07-10 | UHC-76991-24 | 5279763713 | 8102 Market St # 888, Glendale, AZ, 85300 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-115800 | ENR | Jesse N Pena | — | UHC-04366-25 | — | 2100 Jefferson Ave, Charlotte, NC, 28220 | 0.48 | Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more |
| ENR-131628 | ENR | Aisha Harvey | 1979-02-02 | UHC-39601-09 | 2292988233 | 4208 Main St, Dallas, TX, 75211 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-124527 | ENR | Luis S Nichols | 1972-03-13 | UHC-68522-27 | 2518277999 | 3220 Apache Blvd, Nashville, TN, 37281 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-123382 | ENR | Brandon Harper | 1987-08-21 | UHC-68742-37 | 2909477843 | 6786 Willow Ct, Gilbert, AZ | 0.48 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-114247 | ENR | Aisha Allen | 1956-12-26 | UHC-82372-26 | 8734271601 | 5681 Hillcrest Rd, Dallas, TX, 75288 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-135183 | ENR | Joe C Harvey | 1970-03-07 | UHC-23152-20 | 6054023698 | 7400 Spring St, Orlando, FL, 32890 | 0.48 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-111553 | ENR | Larry Murphy | — | UHC-56832-36 | 6239891647 | 5457 Harbor Blvd, Tempe, AZ, 85211 | 0.48 | Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-119733 | ENR | Brenda P Martin | 1947-08-27 | UHC-38052-66 | 3287057641 | 1423 Forest Ave, Charlotte, NC | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111542 | ENR | Austin X Bryant | 1982-03-20 | UHC-43474-78 | 5275559875 | 3056 Willow Ct, Houston, TX, 77008 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-134491 | ENR | Martha U Richardson | 2002-07-26 | UHC-71174-19 | 5337951462 | 3299 Ocean Ave Apt 29, Glendale, AZ, 85360 | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-100369 | ENR | Charltote M Oritz | 2002-10-16 | UHC-52389-49 | — | 7944 Canyon Rd, Columbus, OH, 43239 | 0.48 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more |
| ENR-133993 | ENR | Sophia G Walker | 1996-05-18 | UHC-84938-93 | 9819677772 | 2087 Highland Ave, Las Vegas, NV, 89140 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-105739 | ENR | Kyle Shaw | 1944-01-27 | UHC-46000-39 | — | 9403 Washington St, Charlotte, NC, 28272 | 0.48 | Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more |
| ENR-123938 | ENR | Stephanie O Grant | 2000-05-13 | UHC-90074-55 | 6776554225 | 3746 Maple Ave # 831, San Antonio, TX, 78243 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more |
| ENR-113181 | ENR | Sofia Weaver | 1968-06-05 | UHC-51460-08 | 3593601826 | 1381 Union St # 767, Mesa, AZ, 85234 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-111572 | ENR | Vincent R Shaw | 1984-04-27 | — | 7722673629 | 3323 Church St, Eden Prairie, MN, 55394 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-104485 | ENR | Samuel Le | 1988-05-21 | UHC-07604-11 | 7368141823 | 8848 Cedar Ln # 856, Columbus, OH, 43229 | 0.48 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-133216 | ENR | Peter N Walsh | 2004-07-27 | UHC-87363-59 | 4254994240 | 3658 Meadow Ln, Tempe, AZ, 85208 | 0.48 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more |
| ENR-103817 | ENR | Gregory Hudson | 2001-05-05 | — | — | 3589 Spring St, Tucson, AZ, 85701 | 0.48 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-110651 | ENR | Albert S Morrison | 1992-12-06 | UHC-99651-99 | 7703016775 | 7326 Harbor Blvd, Mesa, AZ, 85235 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-120594 | ENR | Maria Rios | 1988-04-10 | UHC-61386-44 | — | 9019 Cedar Ln, Sacramento, CA, 95803 | 0.48 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more |