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-105433 | ENR | Olivia Fox | 1976-01-11 | UHC-47212-39 | — | 1864 Market St Apt 5, Austin, TX, 78750 | 0.42 | Name split from “Last, First”Phone missing area codeUnit split from streetStreet suffix standardised+1 more |
| ENR-118522 | ENR | Matthew Sullivan | 1959-03-27 | UHC-21478-31 | 5767014173 | 1146 Indian School Rd Apt 1, Glendale, AZ | 0.42 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+7 more |
| ENR-128280 | ENR | Diana Webb | 1967-05-27 | UHC-08113-64 | 7994065836 | 5776 Oak St Apt 25, Scottsdale, AZ, 85244 | 0.42 | Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more |
| ENR-128507 | ENR | Adam Simpson | 1967-06-24 | UHC-96422-35 | — | 5636 Ridge Rd, Nashville, TN, 37256 | 0.42 | Name split from “Last, First”Two-digit birth yearPhone missing area codeStreet suffix standardised+1 more |
| ENR-109895 | ENR | Joshua Turner | 2005-08-27 | UHC-57288-86 | 4086696990 | 7345 Cedar Ln, Eden Prairie, MN, 55377 | 0.42 | Name split from “Last, First”Phone reformattedSSN last four extractedState name converted to code+1 more |
| ENR-125407 | ENR | Kathleen E Santos | 1956-12-09 | UHC-88039-83 | 7267525817 | 367 Oak St, Nashville, TN, 37296 | 0.42 | Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more |
| ENR-120852 | ENR | Natalie Jacobs | 2005-02-13 | UHC-20927-65 | — | 3207 Market St, Glendale, AZ, 85315 | 0.42 | Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more |
| ENR-138136 | ENR | Deborah Hoffman | 1940-03-02 | UHC-84676-19 | 8266769852 | 6121 Mesa Dr # 156, Columbus, OH | 0.42 | Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more |
| ENR-139687 | ENR | Alice Daniels | 1990-03-12 | UHC-83756-81 | 4567062248 | 4225 Sunset Blvd, Tucson, AZ, 85793 | 0.42 | Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more |
| ENR-117361 | ENR | Virginia Warren | 2000-10-18 | UHC-49628-15 | 2276978271 | 6360 Ridge Rd, San Antonio, TX, 78229 | 0.44 | Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+6 more |
| ENR-136447 | ENR | David I Gardner | 1964-12-07 | UHC-74358-71 | 4448133248 | 4966 Church St Apt 3, Sacramento, CA | 0.44 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+6 more |
| ENR-112503 | ENR | Jonathan G Bowman | 2001-09-03 | UHC-40062-05 | 9865520170 | 54 Grand Ave Apt 7, Miami, FL | 0.44 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+6 more |
| ENR-124366 | ENR | Keith N Simpson | — | UHC-20710-22 | 7635683456 | 6732 Church St, Fresno, CA, 93776 | 0.44 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+6 more |
| ENR-130640 | ENR | Victoria G Kelly | 2006-06-13 | UHC-05223-49 | 6567726359 | 3470 Park Pl, Scottsdale, AZ, 85267 | 0.44 | Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+6 more |
| ENR-120680 | ENR | Margaret Bailley | 1998-02-27 | UHC-26153-91 | — | 3713 Cedar Ln, Gilbert, AZ | 0.44 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-132620 | ENR | Nancy Z Rios | 1978-08-03 | UHC-35917-23 | 6233587537 | 5048 Hillcrest Rd, Jacksonville, FL, 32223 | 0.44 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-112788 | ENR | Helen Ward | 1998-10-21 | UHC-75310-08 | — | 1861 Jefferson Ave, Charlotte, NC, 28240 | 0.44 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-113563 | ENR | Bruce C Morris | 1986-01-18 | UHC-33350-17 | 7646439587 | 6865 Mesa Dr, Gilbert, AZ, 85258 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-103074 | ENR | Frank Santiago | 1946-02-25 | UHC-15366-30 | 2686214170 | 4144 Desert Sky Blvd, Tampa, FL, 33686 | 0.44 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+6 more |
| ENR-121051 | ENR | Bily Ortiz | 2006-10-20 | UHC-78085-15 | 7948078515 | 3156 Bayshore Dr, Eden Prairie, MN, 55357 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-113072 | ENR | Kathleen O Williamson | 1964-11-04 | UHC-41645-14 | 9418056680 | 7680 Indian School Rd, Charlotte, NC, 28244 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-103718 | ENR | Diego Valdez | 1962-04-06 | UHC-00431-81 | — | 315 Palm Dr, Tucson, AZ | 0.44 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-111554 | ENR | Timothy P Weber | 2001-09-27 | UHC-91272-09 | — | 3400 Park Pl, Scottsdale, AZ | 0.44 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+6 more |
| ENR-105768 | ENR | Jeremy Chapman | 1985-12-26 | UHC-44520-76 | 3586643307 | 5814 Forest Ave, Miami, FL, 33159 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-100457 | ENR | Jackie T Johnston | 1999-08-07 | UHC-56323-70 | 9353383997 | 568 Jefferson Ave, Plano, TX | 0.44 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+6 more |
| ENR-119488 | ENR | Isabella U Burton | 1980-11-25 | UHC-09055-50 | 7938588103 | 3009 Apache Blvd # 188, Tempe, AZ, 85238 | 0.44 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+6 more |
| ENR-116127 | ENR | Juie Sullivan | 1979-09-27 | UHC-95420-85 | — | 5655 Union St, Las Vegas, NV | 0.44 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+6 more |
| ENR-129338 | ENR | Bruce I Dean | 1983-05-07 | UHC-92761-61 | 4503754132 | 1899 Oak St, Houston, TX, 77033 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-115545 | ENR | Ethan Kennedy | — | UHC-94235-35 | 3559499214 | 2663 Hillcrest Rd # 756, Mesa, AZ, 85297 | 0.44 | Name re-casedDate of birth missingPhone reformattedMember ID reformatted+6 more |
| ENR-100688 | ENR | Martha B Parker | — | UHC-19603-97 | 6026444202 | 9366 Maple Ave Apt 24, Eden Prairie, MN, 55321 | 0.44 | Name re-casedDate of birth unreadablePhone reformattedUnit split from street+6 more |
| ENR-106044 | ENR | Randy Murray | 2001-09-26 | UHC-92433-34 | 9045989786 | 1777 Central Ave, Miami, FL, 33117 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-120316 | ENR | Cynthia Alvarez | 1953-07-13 | UHC-21356-89 | 8032261633 | 1555 Lake View Rd, Scottsdale, AZ | 0.44 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-120279 | ENR | Scott Guzman | 1989-02-04 | UHC-03230-14 | 3716428266 | 2262 Cedar Ln, Tampa, FL | 0.44 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more |
| ENR-128740 | ENR | VincentJunk | 1990-12-24 | UHC-51856-42 | 9089137181 | 8425 Jefferson Ave, Nashville, TN, 37245 | 0.44 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+6 more |
| ENR-117815 | ENR | Sophia Hill | 1975-08-12 | UHC-72031-89 | 2908416465 | 4128 Spring St # 237, Denver, CO, 80218 | 0.44 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+6 more |
| ENR-105153 | ENR | Timothy H Rivera | 1946-03-08 | UHC-26841-12 | 9212725890 | 5323 Canyon Rd, Scottsdale, AZ, 85236 | 0.44 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-129154 | ENR | Joseph M Daniiels | 1995-07-13 | UHC-26322-25 | 8167990088 | 9477 Bayshore Dr, Phoenix, AZ | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-124415 | ENR | Ashley E Thompson | 1999-11-22 | UHC-62776-77 | 4078435113 | 8765 Central Ave, Eden Prairie, MN, 55320 | 0.44 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+6 more |
| ENR-135864 | ENR | Emily C Dominguez | 1985-10-01 | UHC-30743-93 | 5233103106 | 4578 Pine Dr, Jacksonville, FL, 32253 | 0.44 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-115925 | ENR | Patricia B Kim | 1998-05-23 | UHC-30627-19 | 5126885251 | 3503 Elm St # 816, Columbus, OH, 43251 | 0.44 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+6 more |
| ENR-107898 | ENR | Ray U Ruiz | 1949-08-14 | UHC-95302-67 | 2634070107 | 4347 Camelback Rd Apt 28, Tempe, AZ, 85245 | 0.44 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+6 more |
| ENR-135689 | ENR | Maria G Stone | 1953-02-23 | UHC-66345-90 | 6979797447 | 3800 Sage Ct # 456, Sacramento, CA, 95814 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more |
| ENR-134675 | ENR | Nancy Sims | 2000-10-07 | UHC-83909-97 | 7729925748 | 8212 Market St Apt 7, Seattle, WA | 0.44 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more |
| ENR-142678 | ENR | Isabbella Gordon | 2007-08-24 | UHC-44059-85 | — | 752 Mountain View Dr, Los Angeles, CA | 0.44 | Name split from “Last, First”Two-digit birth yearZIP missingGender normalised |
| ENR-124209 | ENR | Brittany Ferguson | 1960-11-14 | UHC-34165-52 | 2619062973 | 8443 Valley View Dr, Fresno, CA, 93729 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more |
| ENR-127264 | ENR | Carol X Rogers | 1973-06-14 | UHC-29452-56 | 6437676642 | 6820 Hillcrest Rd, Minneapolis, MN, 55427 | 0.44 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-106041 | ENR | Amber White | 1962-10-21 | UHC-86611-68 | 8209117647 | 2131 Sunset Blvd, Miami, FL | 0.46 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-116462 | ENR | Lauren G Holmes | 1992-02-16 | UHC-98314-28 | 2107885949 | 8144 Camelback Rd, Austin, TX, 78749 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-119401 | ENR | Sophia P Dunn | 1968-06-01 | — | 3682036313 | 3089 Grand Ave # 798, Miami, FL, 33123 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-128529 | ENR | Jacqueline Stone | 1970-04-24 | UHC-69765-49 | 8124567795 | 607 Apache Blvd, Nashville, TN | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |