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-114552 | ENR | Lori Cruz | 1954-01-08 | UHC-43223-03 | 4323531512 | 3912 Main St Apt 17, Austin, TX, 78730 | 0.50 | Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-141659 | ENR | Omar O Vasquez | 1948-02-20 | UHC-98026-90 | 3389128104 | 2352 Spring St, Atlanta, GA, 30349 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-138189 | ENR | Amy K Morrison | 1977-02-06 | UHC-29243-33 | 4846396784 | 4055 Palm Dr, Austin, TX, 78794 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-101980 | ENR | Alice X Le | 1943-10-22 | UHC-49554-66 | 5785317456 | 845 Bayshore Dr, Charlotte, NC, 28234 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120386 | ENR | Arjun Chavez | 1979-07-17 | UHC-26292-82 | 9826161875 | 3090 Apache Blvd, Tucson, AZ, 85770 | 0.50 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-142009 | ENR | Lisa Knight | — | UHC-55792-79 | 4128534894 | 2320 Palm Dr, Dallas, TX, 75215 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-125208 | ENR | Camila E Fowler | 1956-08-27 | UHC-16999-76 | 6932846411 | 8730 River Rd, Eden Prairie, MN, 55369 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109754 | ENR | Christopher X Adams | 1956-06-26 | UHC-88794-67 | — | 4764 Spring St, Atlanta, GA, 30333 | 0.50 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-109755 | ENR | Christopher X Adams | 1956-06-26 | UHC-88794-67 | — | 4764 Spring St, Atlanta, GA, 30333 | 0.50 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-108645 | ENR | Emma X Meyer | 1997-06-18 | UHC-13185-09 | — | 4208 Palm Dr # 288, Eden Prairie, MN, 55334 | 0.50 | SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-132237 | ENR | Randy U Fox | 1941-10-24 | UHC-87702-57 | 4125287256 | 8737 Valley View Dr, Minneapolis, MN | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-134413 | ENR | Tom O Ortiz | 2003-10-15 | UHC-63591-98 | 4166854456 | 2226 Lincoln Way, Eden Prairie, MN, 55300 | 0.50 | Name split from “Last, First”Phone reformattedSSN last four extractedCity re-cased+3 more |
| ENR-138636 | ENR | Wayne W Fuller | 1986-06-06 | UHC-56628-53 | 5197180552 | 1113 Camelback Rd, Tucson, AZ, 85774 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-101086 | ENR | Shirley Santiago | 1957-01-23 | UHC-02122-89 | 6385260045 | 4627 Apache Blvd, Tempe, AZ | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-111433 | ENR | Jennifer H McCoy | 1993-09-28 | UHC-33786-54 | 6588741586 | 7647 Sunset Blvd, Dallas, TX, 75241 | 0.50 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-113130 | ENR | Heather T Cox | 1991-04-26 | UHC-00078-47 | 5762936904 | 5992 Apache Blvd, Las Vegas, NV, 89143 | 0.50 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-132528 | ENR | Randy Dunn | 1998-10-09 | UHC-86655-21 | 4626535238 | 1915 Ocean Ave # 657, Jacksonville, FL, 32243 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more |
| ENR-119544 | ENR | Mark V Ruiz | 1968-09-18 | UHC-35056-44 | — | 3205 Church St Apt 37, Tampa, FL, 33683 | 0.50 | Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+3 more |
| ENR-137796 | ENR | Hannah Howard | 1942-09-21 | UHC-78722-81 | 4659046325 | 5163 Apache Blvd, Miami, FL | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-110942 | ENR | Julia Jensen | 1958-06-21 | UHC-89834-38 | 3894618707 | 6824 Broadway, Phoenix, AZ, 85014 | 0.50 | Name split from “Last, First”Date of birth reformattedMember ID reformattedZIP+4 trimmed+3 more |
| ENR-118077 | ENR | Vincent H Mills | 1977-06-11 | UHC-69802-96 | 4602437886 | 2548 Market St, Glendale, AZ, 85309 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-116970 | ENR | Gerald M Pena | 1978-10-23 | UHC-42304-14 | — | 9382 Bayshore Dr # 723, Phoenix, AZ, 85038 | 0.50 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-101769 | ENR | Jose B Olson | 2003-05-28 | UHC-32021-76 | 9768270409 | 5299 Elm St, Jacksonville, FL | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-104885 | ENR | Alexander J Marshall | 1969-09-02 | UHC-93972-26 | 9455477468 | 9664 Highland Ave, Dallas, TX, 75230 | 0.50 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-132198 | ENR | Arthur Wright | 1982-02-07 | UHC-04266-22 | — | 8322 Main St, Tampa, FL, 33655 | 0.50 | Name re-casedTwo-digit birth yearSSN last four extractedCity re-cased+3 more |
| ENR-127491 | ENR | Patrick Q Henderson | 1968-09-17 | UHC-63091-04 | 7089560937 | 5981 Park Pl, Tampa, FL, 33645 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-118572 | ENR | Jessicca Wang | 2003-01-20 | UHC-04085-61 | 4653325459 | 5652 Meadow Ln, Sacramento, CA, 95839 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-108721 | ENR | Singh S Brenda | 1999-05-10 | UHC-58435-51 | 6762420877 | 7872 Indian School Rd, Glendale, AZ, 85389 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-103964 | ENR | Terry D Lane | 1969-03-27 | UHC-59619-27 | 7423245453 | 2703 Hillcrest Rd, Los Angeles, CA, 90071 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-134800 | ENR | Cheryl Hernandez | 1999-11-11 | UHC-59365-23 | 2177932044 | 275 Park Pl # 704, Atlanta, GA, 30376 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-131226 | ENR | Laurn L Johnston | 1983-11-27 | UHC-59566-95 | 6783463128 | 7541 Mountain View Dr Apt 20, San Antonio, TX, 78201 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-125912 | ENR | Jack A Wallace | 1997-11-15 | UHC-74691-10 | 8824500777 | 2153 Elm St, Gilbert, AZ, 85290 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-122804 | ENR | Isabella Cook | 2003-12-09 | UHC-20907-19 | 4063223680 | 1808 Elm St, Eden Prairie, MN, 55386 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-115812 | ENR | Lauren Olsno | 1990-03-18 | UHC-21681-25 | 6442761521 | 3523 Indian School Rd, Jacksonville, FL, 32260 | 0.50 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-142976 | ENR | Amanda M Arnold | 1995-04-08 | UHC-03979-01 | 5357008100 | 5631 Sage Ct, Eden Prairie, MN | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121485 | ENR | Barbara R Diaz | 1981-12-13 | UHC-33594-96 | 3624880523 | 8743 Oak St, Gilbert, AZ, 85299 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-107167 | ENR | Cheryl M Hill | 1949-12-23 | UHC-69418-07 | 7959883143 | 3321 Mountain View Dr, Chandler, AZ, 85213 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-138427 | ENR | Joseph I Riley | 1974-11-28 | UHC-21875-34 | 5145502294 | 6915 Hillcrest Rd, Gilbert, AZ, 85223 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100770 | ENR | Virginia K Hill | 1962-09-15 | UHC-08541-98 | — | 5020 Ridge Rd # 349, Tampa, FL, 33666 | 0.50 | Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+3 more |
| ENR-115609 | ENR | John Y Sanders | 1999-07-08 | UHC-07416-24 | 2016376492 | 7846 Mountain View Dr, Plano, TX, 75075 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128104 | ENR | Bruce Jensen | 1965-06-05 | UHC-93320-87 | — | 1824 Park Pl, Scottsdale, AZ, 85243 | 0.50 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-102472 | ENR | Pamela Ruiz | — | UHC-56632-98 | 8947061618 | 2604 Baseline Rd, Gilbert, AZ, 85256 | 0.50 | Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-113031 | ENR | Elijah Hanson | 2003-03-04 | UHC-11708-39 | 2764045252 | 119 Indian School Rd Apt 8, Jacksonville, FL, 32200 | 0.50 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-136027 | ENR | Jessica Snyder | 1947-04-25 | UHC-52061-50 | 2045991278 | 7810 Ocean Ave, Glendale, AZ, 85357 | 0.50 | Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+3 more |
| ENR-119701 | ENR | Anthony Ross | 1940-11-24 | UHC-19608-19 | 4488891620 | 9648 Highland Ave # 746, Las Vegas, NV, 89142 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-142417 | ENR | Ann L Reid | 1952-10-15 | UHC-19399-44 | 3273429297 | 5406 Jefferson Ave, Tucson, AZ, 85748 | 0.50 | Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-112254 | ENR | Dennis J Medina | 1967-07-25 | UHC-69245-14 | 3388039639 | 7642 Mesa Dr # 472, Jacksonville, FL, 32238 | 0.50 | Middle initial moved out of first nameName re-casedDate of birth reformattedUnit split from street+3 more |
| ENR-100464 | ENR | Ralph B Little | 1941-02-04 | UHC-15915-54 | 8487806162 | 3843 Elm St, Tucson, AZ | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-104405 | ENR | Mei U Guzman | 1948-06-07 | UHC-54129-77 | 4847578175 | 5967 Grand Ave, Mesa, AZ, 85206 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-108697 | ENR | Gerrald Banks | 2008-05-13 | UHC-39464-74 | 2188807953 | 8023 Oak St, Chandler, AZ | 0.50 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |