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-135346 | ENR | Nicholas Diaz | 2004-04-09 | UHC-37468-77 | 2239982353 | 9304 Elm St # 560, Seattle, WA, 98139 | 0.52 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-104473 | ENR | Kathelen Baker | 1943-04-12 | UHC-40436-49 | 7135346339 | 9748 Washington St, Atlanta, GA, 30329 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-140613 | ENR | Raymond Q Alvarado | 1940-05-14 | UHC-63639-31 | 2114911603 | 1325 Market St, Dallas, TX, 75230 | 0.52 | Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+2 more |
| ENR-104662 | ENR | Kelly SJunk | 2002-11-22 | UHC-86692-91 | 8183498188 | 2310 Highland Ave, Columbus, OH, 43286 | 0.52 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-112085 | ENR | Emily T Rose | 1981-08-12 | UHC-79044-52 | 9749847204 | 7724 Grand Ave # 881, Nashville, TN, 37229 | 0.52 | Middle initial moved out of first nameName re-casedUnit split from streetState name converted to code+2 more |
| ENR-126556 | ENR | Donald B Vzquez | 1967-07-25 | UHC-46967-70 | 8135808579 | 3799 Indian School Rd, Miami, FL, 33155 | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-114595 | ENR | Ethan Wood | 2008-02-15 | UHC-34077-39 | 5013258690 | 3802 Indian School Rd, Fresno, CA | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-106054 | ENR | Stephanie Reed | 1994-02-26 | UHC-72165-55 | 8794793904 | 7279 Bayshore Dr, Seattle, WA, 98103 | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-109506 | ENR | Laura B Vasquez | — | UHC-24014-44 | 5645558912 | 5673 Harbor Blvd, Glendale, AZ, 85344 | 0.52 | Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more |
| ENR-112993 | ENR | Sarah C Crawford | 1967-09-27 | UHC-35859-85 | — | 7164 Hillcrest Rd, Austin, TX, 78768 | 0.52 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-129141 | ENR | Patrick Ortega | 2001-07-20 | UHC-45462-68 | — | 348 Cedar Ln, Atlanta, GA, 30305 | 0.52 | Name re-casedDate of birth reformattedPhone missing area codeState name converted to code+2 more |
| ENR-111974 | ENR | Naoh O Moore | 1987-04-28 | UHC-57675-74 | 5248929032 | 2448 Lincoln Way, Phoenix, AZ, 85084 | 0.52 | Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-121655 | ENR | Andrew W Cooper | 1983-06-12 | — | 8329935777 | 805 Desert Sky Blvd, Charlotte, NC, 28211 | 0.52 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more |
| ENR-114134 | ENR | Lawrence P Romero | 1947-12-28 | UHC-11868-35 | 3973857667 | 4907 Apache Blvd # 703, Eden Prairie, MN, 55395 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-118323 | ENR | Judith Foster | — | UHC-34522-45 | 5396566661 | 6667 Elm St # 433, Dallas, TX, 75243 | 0.52 | Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-116452 | ENR | Pamela Gordon | 1978-11-04 | UHC-80712-55 | 9375485980 | 4998 Canyon Rd, Denver, CO, 80244 | 0.52 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| ENR-125304 | ENR | Zachary Payne | 1948-03-24 | UHC-70686-74 | 9853600044 | 4827 Baseline Rd, Eden Prairie, MN, 55398 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| ENR-121279 | ENR | Yuki D Jones | 1987-04-24 | UHC-69070-02 | 5826373080 | 2363 Maple Ave # 476, Jacksonville, FL, 32260 | 0.52 | Two-digit birth yearPhone reformattedUnit split from streetCity re-cased+2 more |
| ENR-135514 | ENR | Sofia U Andrews | 1996-02-17 | UHC-65628-97 | 6905613448 | 377 Spring St, Charlotte, NC | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-135819 | ENR | Harold Herrera | 1958-11-09 | — | 3753762737 | 6162 Canyon Rd, Plano, TX, 75085 | 0.52 | Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-126144 | ENR | Mason R Morales | 1999-10-26 | UHC-64421-02 | 3927661155 | 7153 Washington St, Plano, TX, 75091 | 0.52 | SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-106593 | ENR | Carl V Dean | 1972-03-28 | UHC-87857-89 | 5768443760 | 9585 Oak St # 839, Tampa, FL, 33642 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more |
| ENR-114300 | ENR | Carol Hughes | 1979-02-28 | UHC-70476-15 | 3375477490 | 2280 Bayshore Dr # 570, Seattle, WA, 98128 | 0.52 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-116838 | ENR | Lisa Hayes | 1985-07-09 | UHC-46841-84 | 4594449792 | 33 Grand Ave, Gilbert, AZ | 0.52 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| ENR-123648 | ENR | Carlyn D Coleman | 1985-08-11 | UHC-68786-20 | 4407605969 | 6924 Bayshore Dr, Jacksonville, FL, 32225 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| ENR-139226 | ENR | Susan Perry | 1946-01-03 | UHC-00025-27 | — | 8796 Camelback Rd, Eden Prairie, MN, 55309 | 0.52 | Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more |
| ENR-113394 | ENR | Dylan P Simpsoon | 1996-12-09 | UHC-44034-72 | 4672681835 | 4745 Lake View Rd, Minneapolis, MN, 55475 | 0.52 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-138496 | ENR | Carolyn S Hernandez | 1939-12-07 | UHC-64823-02 | 3632254257 | 2739 Pine Dr Apt 27, Austin, TX, 78739 | 0.52 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more |
| ENR-141338 | ENR | Joan O Jimeenz | 1945-02-22 | UHC-52208-38 | — | 3952 Valley View Dr, San Diego, CA, 92160 | 0.52 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| ENR-120122 | ENR | Sean Guzman | 2002-12-28 | UHC-71216-47 | 3514030326 | 3295 Church St, Glendale, AZ, 85352 | 0.52 | Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more |
| ENR-114712 | ENR | John S Gomez | 1958-03-19 | UHC-49320-75 | 5354630642 | 5201 Park Pl, Orlando, FL | 0.52 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| ENR-130990 | ENR | Priya Fernandez | 1961-09-06 | UHC-54311-92 | 2232494186 | 9179 Spring St, Tucson, AZ, 85785 | 0.52 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more |
| ENR-111591 | ENR | Jacob D Hoffman | 1997-03-25 | UHC-51039-01 | 6847649540 | 6402 Willow Ct, Chandler, AZ, 85236 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-111619 | ENR | Theresa Wheeler | 1953-07-08 | UHC-04306-87 | 3283542633 | 8531 Camelback Rd, San Diego, CA, 92187 | 0.52 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-125658 | ENR | Alexxander Fisher | 1947-06-15 | UHC-01049-28 | 2939755973 | 3904 Baseline Rd # 325, Jacksonville, FL, 32299 | 0.52 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| ENR-128433 | ENR | Larry Q Simpson | 1973-01-25 | UHC-81950-28 | — | 406 Lincoln Way, Charlotte, NC, 28235 | 0.52 | Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| ENR-125183 | ENR | TerryJunk | 1994-07-21 | UHC-97302-84 | 3747824898 | 1875 Indian School Rd, Dallas, TX, 75254 | 0.52 | Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| ENR-135614 | ENR | Laura U Jackson | 1987-12-28 | UHC-55292-33 | — | 4088 Highland Ave, Chandler, AZ, 85270 | 0.52 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| ENR-109642 | ENR | Sofia Henderson | 1998-04-15 | UHC-82416-11 | 3994538678 | 6222 Cedar Ln, Eden Prairie, MN, 55314 | 0.52 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-133534 | ENR | Luis Y Green | 1964-04-24 | UHC-57723-18 | 5752658492 | 873 Indian School Rd, Fresno, CA, 93783 | 0.52 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| ENR-101614 | ENR | Diana H Morrison | — | UHC-01125-53 | — | 9490 Willow Ct, Minneapolis, MN, 55472 | 0.52 | Date of birth unreadableStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| ENR-100341 | ENR | Jonathan P Black | 1952-12-24 | UHC-08559-01 | — | 6042 Forest Ave, Seattle, WA, 98184 | 0.52 | Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| ENR-125278 | ENR | Frances Garza | 2000-08-16 | UHC-66708-43 | — | 3974 Valley View Dr, Fresno, CA | 0.52 | Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more |
| ENR-135500 | ENR | Ana W Bell | 2007-05-09 | UHC-07204-04 | 5076229056 | 2813 Lake View Rd, Seattle, WA, 98127 | 0.52 | Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+2 more |
| ENR-111599 | ENR | David Ryan | 1984-05-22 | UHC-43444-74 | — | 701 Ridge Rd, Mesa, AZ | 0.52 | Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more |
| ENR-136390 | ENR | Brandon Bennett | 1939-08-21 | UHC-20776-28 | 8373045542 | 1280 Camelback Rd, Tucson, AZ | 0.52 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more |
| ENR-136391 | ENR | Brandon Bennett | 1939-08-21 | UHC-20776-28 | 8373045542 | 1280 Camelback Rd, Tucson, AZ | 0.52 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more |
| ENR-131240 | ENR | Fatima T Carroll | 1945-03-08 | UHC-54168-90 | 6583010002 | 8669 Maple Ave Apt 19, Tempe, AZ, 85291 | 0.52 | Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more |
| ENR-135924 | ENR | Nicholas B Park | 1963-11-01 | UHC-31302-45 | 4787258907 | 6548 Jefferson Ave, Los Angeles, CA, 90047 | 0.52 | Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| ENR-138383 | ENR | Virginia U Rose | 1996-07-26 | UHC-18993-70 | 2893171464 | 6726 Market St, Minneapolis, MN, 55431 | 0.52 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more |