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-124771 | ENR | Lucia Franklin | 1961-12-27 | UHC-71285-85 | 3859634515 | 4600 Ridge Rd, Nashville, TN, 37263 | 0.50 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-108973 | ENR | Joe J Hart | 1969-06-25 | UHC-94161-65 | 7048806885 | 3185 Pine Dr # 174, Jacksonville, FL, 32299 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-126228 | ENR | Cynthia Jimenez | 1989-07-14 | UHC-68580-40 | 9785684151 | 7864 Market St, Columbus, OH | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-103456 | ENR | Virginia M Moore | 1952-11-16 | UHC-66744-78 | 7366392874 | 6835 Pine Dr Apt 26, Miami, FL, 33172 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-111815 | ENR | Shirley Hamilton | 1965-04-13 | UHC-34685-86 | 2013063578 | 7853 Ridge Rd, Atlanta, GA, 30328 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-105977 | ENR | Ahmed R Hill | 1939-10-14 | UHC-13347-11 | — | 6465 Spring St, Tempe, AZ, 85249 | 0.50 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-137913 | ENR | Kimberly T Bell | 2003-09-01 | UHC-86763-22 | 5979033704 | 3424 Central Ave # 416, Tempe, AZ, 85277 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-106775 | ENR | Lina R Elliott | — | UHC-90738-32 | 5577741928 | 6169 Lake View Rd, Atlanta, GA, 30323 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-116989 | ENR | Nicholas Price | 1942-09-03 | UHC-89676-44 | — | 4129 Maple Ave, Fresno, CA, 93785 | 0.50 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-101568 | ENR | Ethan Maldonado | 1970-10-25 | UHC-81823-63 | 5677378172 | 2378 Sunset Blvd, Phoenix, AZ, 85028 | 0.50 | Name re-casedPhone reformattedSSN last four extractedState name converted to code+3 more |
| ENR-134481 | ENR | Cynthia T Robinson | 1969-08-26 | UHC-25770-44 | 2334150499 | 1360 Meadow Ln, Houston, TX, 77037 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-104787 | ENR | Sean Clark | 1973-12-09 | UHC-83360-30 | — | 6639 Mountain View Dr, Sacramento, CA, 95813 | 0.50 | Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-134319 | ENR | Barbara Richards | 1996-08-19 | UHC-03646-01 | 2549037805 | 8224 Grand Ave, Tampa, FL | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-123919 | ENR | Diana H Black | — | UHC-32855-08 | — | 4681 Forest Ave, Phoenix, AZ, 85070 | 0.50 | Name split from “Last, First”Date of birth reformattedDate of birth unreadableStreet suffix standardised+3 more |
| ENR-118488 | ENR | Amanda Shaw | — | UHC-91321-72 | 8639911050 | 7331 Washington St, Columbus, OH, 43256 | 0.50 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-104543 | ENR | Betty Alvarez | 1972-04-14 | UHC-47990-27 | — | 5477 Mountain View Dr, Scottsdale, AZ, 85223 | 0.50 | Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+3 more |
| ENR-132050 | ENR | Kenneth Reynolds | 1948-05-04 | UHC-87659-01 | 6783598088 | 1528 Jefferson Ave Apt 14, Gilbert, AZ, 85211 | 0.50 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-116625 | ENR | Elizabeth N Chapman | 1944-12-23 | UHC-12513-30 | 8676977543 | 2615 Ridge Rd, San Antonio, TX | 0.50 | Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+3 more |
| ENR-136550 | ENR | Mason T Lawrence | 1946-08-12 | UHC-62902-14 | 6027210466 | 8662 Forest Ave Apt 3, Glendale, AZ, 85308 | 0.50 | Member ID reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more |
| ENR-105859 | ENR | Anna Z Reyes | — | UHC-62772-75 | 9174886248 | 273 Highland Ave, Austin, TX, 78775 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+3 more |
| ENR-131111 | ENR | Camila Rice | 1963-08-13 | UHC-37080-07 | 8559683729 | 5371 River Rd, Columbus, OH, 43208 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109722 | ENR | Natalie W Wang | 2000-08-13 | UHC-11557-27 | 4885065406 | 5773 Baseline Rd Apt 33, Minneapolis, MN, 55489 | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-111855 | ENR | Ruth Lewis | 1970-09-20 | UHC-46141-66 | 7488133012 | 4673 Market St, Sacramento, CA, 95801 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-138385 | ENR | Lucia P Ellis | 1972-09-15 | UHC-81593-46 | 9297806190 | 1316 Sage Ct, Chandler, AZ, 85252 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-136786 | ENR | Amber Tran | 1950-07-23 | UHC-66499-50 | 2176414689 | 7892 Highland Ave # 733, Nashville, TN, 37202 | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-120826 | ENR | Keith White | 1950-05-09 | UHC-00331-85 | 5229317985 | 5603 Jefferson Ave, Denver, CO, 80215 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-136006 | ENR | Sharon Williamson | — | UHC-81879-83 | 5442846180 | 938 Camelback Rd, Eden Prairie, MN, 55304 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-106118 | ENR | Mary A Wilson | 2008-01-16 | UHC-13806-99 | — | 5888 Canyon Rd Apt 34, Los Angeles, CA | 0.50 | Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-123407 | ENR | Fatima S Garza | 1972-11-26 | UHC-26672-93 | 7346831773 | 1370 Lincoln Way Apt 6, Scottsdale, AZ, 85285 | 0.50 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-141005 | ENR | Bruce T Garrett | 1962-07-12 | UHC-64079-01 | 8223304412 | 383 Central Ave, Miami, FL, 33114 | 0.50 | Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more |
| ENR-141052 | ENR | Thomas M Luna | 1997-10-20 | UHC-95083-87 | 8886275690 | 4011 Main St # 201, Orlando, FL, 32803 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-122629 | ENR | Eugene K Parker | 1988-06-25 | UHC-32909-27 | 7575722235 | 2035 Ocean Ave, Minneapolis, MN | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-102596 | ENR | Robert T Chen | 1981-09-28 | UHC-20989-04 | 9444041252 | 3700 Willow Ct, Las Vegas, NV, 89139 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-117405 | ENR | Eddie Alvarez | 1948-01-05 | — | — | 9770 Highland Ave, Fresno, CA, 93745 | 0.50 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| ENR-108646 | ENR | Emma X Meyer | 1997-06-18 | UHC-13185-09 | 2227302295 | 5206 Sunset Blvd, Columbus, OH, 43225 | 0.50 | Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-135217 | ENR | Sean X Barnes | 1988-07-02 | UHC-81350-59 | 9827299022 | 8435 Mesa Dr, Las Vegas, NV, 89154 | 0.50 | Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120735 | ENR | Ronald Li | 2005-05-05 | UHC-48215-18 | 3247442986 | 7592 Canyon Rd, Chandler, AZ, 85209 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-104861 | ENR | Amber R Lawrence | 1997-10-14 | UHC-47479-45 | — | 6010 Indian School Rd, San Diego, CA, 92161 | 0.50 | Name split from “Last, First”Middle initial moved out of first nameMember ID reformattedCity re-cased+3 more |
| ENR-102212 | ENR | Kylle Q Wang | 1939-09-22 | UHC-43409-27 | 2606172007 | 5461 Indian School Rd, Fresno, CA, 93741 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120406 | ENR | Steve I Aguilar | 1938-03-08 | UHC-51621-70 | 5473924566 | 8456 Baseline Rd, Gilbert, AZ, 85203 | 0.50 | Middle initial moved out of first namePhone reformattedMember ID reformattedSSN last four extracted+3 more |
| ENR-138726 | ENR | Julia B Lucas | 1981-07-20 | UHC-72844-78 | 3215592607 | 504 Sunset Blvd, Minneapolis, MN, 55447 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-105506 | ENR | Daniel Matthews | 1942-11-06 | UHC-84431-15 | 7993957727 | 2893 Church St # 942, Tucson, AZ, 85714 | 0.50 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-137593 | ENR | Kathy Palmer | 1986-09-15 | UHC-42607-41 | 8633279032 | 2434 Sunset Blvd Apt 11, Phoenix, AZ, 85069 | 0.50 | Phone reformattedMember ID reformattedSSN last four extractedUnit split from street+3 more |
| ENR-100558 | ENR | Terry I Martinez | 1970-10-08 | UHC-27731-53 | 6723861608 | 5456 Park Pl, San Antonio, TX, 78251 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-117769 | ENR | Sephen N Miller | 1973-09-12 | UHC-27582-63 | 3896210901 | 800 Central Ave, Sacramento, CA, 95811 | 0.50 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-141123 | ENR | Joe Graham | 1972-07-05 | UHC-78221-88 | 8115051406 | 8873 Harbor Blvd, Tampa, FL | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-117379 | ENR | Ryan K Edwards | — | UHC-00951-12 | 2522258706 | 7275 Harbor Blvd, Glendale, AZ, 85367 | 0.50 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-141428 | ENR | Hannah G Luna | 1948-02-25 | UHC-64545-19 | 9574752730 | 7909 Spring St, Dallas, TX, 75212 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135044 | ENR | Jennifer Bishop | 1971-11-19 | UHC-66354-28 | 7299319861 | 8524 Lake View Rd # 125, Charlotte, NC, 28265 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more |
| ENR-133032 | ENR | Kyle R Allen | 1975-06-13 | UHC-18084-56 | 3518917686 | 1239 Sage Ct, Tempe, AZ, 85260 | 0.50 | Two-digit birth yearMember ID reformattedSSN last four extractedStreet suffix standardised+3 more |