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-138795 | ENR | Jonathan Bryant | — | UHC-15588-86 | 2879156837 | 8590 Apache Blvd, San Antonio, TX | 0.50 | Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+3 more |
| ENR-141552 | ENR | Billy R Fisher | 1980-06-20 | UHC-98030-27 | 6996269135 | 1611 Hillcrest Rd Apt 31, Seattle, WA, 98155 | 0.50 | Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-127541 | ENR | Joan U Morgan | 1953-12-09 | UHC-54119-07 | 3249343336 | 3800 Washington St, Eden Prairie, MN, 55328 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-125805 | ENR | Paul Montgomery | — | UHC-33633-18 | 9275616628 | 9334 Oak St, Phoenix, AZ, 85024 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-102128 | ENR | Aronld G Cheryl | 1939-07-17 | UHC-49778-27 | 9474471899 | 1883 Canyon Rd, Chandler, AZ, 85280 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-103358 | ENR | Julie E Olson | 1972-11-08 | UHC-69723-76 | 5783076515 | 2676 Hillcrest Rd, Jacksonville, FL | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-139111 | ENR | Yuki Ruiz | 1972-03-21 | UHC-19041-11 | — | 6056 Ridge Rd, Nashville, TN, 37257 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-137078 | ENR | Jason R Morgan | 2006-04-10 | UHC-31457-91 | 5042718566 | 2752 Hillcrest Rd, Tampa, FL | 0.50 | Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more |
| ENR-120144 | ENR | Kathryn J Hill | 1960-10-10 | UHC-93631-55 | 4632501044 | 7190 Maple Ave, Jacksonville, FL, 32242 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-127561 | ENR | Mason W Howard | 1981-02-03 | UHC-97472-90 | 9555254327 | 2216 Church St, Jacksonville, FL | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121404 | ENR | Lisa Bishop | 1946-04-25 | UHC-70027-59 | 4555713543 | 5476 Mesa Dr, Fresno, CA | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133727 | ENR | Zachary U Morris | 1985-09-28 | UHC-13938-46 | — | 6613 Pine Dr, Fresno, CA, 93723 | 0.50 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| ENR-105726 | ENR | UJunk | 1966-03-12 | UHC-76518-54 | 7278331495 | 733 Spring St, Los Angeles, CA, 90089 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112856 | ENR | Patrick Marquez | 1995-05-22 | UHC-59828-36 | 5522401961 | 4295 Apache Blvd, Austin, TX, 78754 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-136457 | ENR | Benjamin Mills | 1962-04-28 | UHC-47258-47 | 6086557476 | 4151 Desert Sky Blvd, Orlando, FL | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-116683 | ENR | Tyler Barnes | 1942-05-11 | UHC-01576-41 | 5726123637 | 7124 Market St # 346, Chandler, AZ | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-131549 | ENR | Lori WJunk | 1951-03-15 | UHC-50744-71 | 4456517797 | 3221 Canyon Rd, Minneapolis, MN, 55406 | 0.50 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-134815 | ENR | Joe B Cox | 1954-06-17 | UHC-98294-10 | 7263414021 | 5787 Sunset Blvd Apt 20, Orlando, FL, 32839 | 0.50 | Phone reformattedUnit split from streetState name converted to codeEmail lower-cased+3 more |
| ENR-118974 | ENR | Janice K Richards | 1938-06-13 | UHC-36443-23 | 6043317216 | 2622 Jefferson Ave, Charlotte, NC, 28254 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-138153 | ENR | Jerry Rosss | 1979-06-17 | UHC-06332-38 | — | 7056 Palm Dr, Charlotte, NC, 28271 | 0.50 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135731 | ENR | Isabella R Wong | 2002-04-02 | UHC-26829-40 | 2143931205 | 7567 Sage Ct, Gilbert, AZ, 85263 | 0.50 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-140883 | ENR | Sopia E Spencer | 1939-06-15 | UHC-86480-28 | 3084757171 | 7663 Ocean Ave, Houston, TX, 77013 | 0.50 | Middle initial moved out of first nameStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-117604 | ENR | Hamilton U Doris | 1949-03-21 | UHC-29716-43 | 8755174672 | 8807 Indian School Rd Apt 14, Los Angeles, CA, 90063 | 0.50 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-135962 | ENR | Henry V Obrien | — | UHC-71537-80 | 2409165120 | 1614 Camelback Rd # 839, Atlanta, GA, 30372 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more |
| ENR-134817 | ENR | Douglas O Harris | 1965-08-21 | UHC-03403-79 | — | 4687 Main St, Nashville, TN, 37255 | 0.50 | Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more |
| ENR-112543 | ENR | Nancy I Salazar | 1981-03-05 | UHC-90313-65 | 8346663805 | 5548 Sage Ct, Columbus, OH, 43296 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-104202 | ENR | Ruth M Hill | — | UHC-49852-18 | 3805349906 | 557 Jefferson Ave, Plano, TX, 75028 | 0.50 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-101507 | ENR | Anna Lawrence | 1983-12-17 | UHC-95417-06 | — | 9750 Sage Ct, Las Vegas, NV | 0.50 | Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more |
| ENR-101506 | ENR | Anna Lawrence | 1983-12-17 | UHC-95417-06 | — | 9750 Sage Ct, Las Vegas, NV | 0.50 | Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more |
| ENR-141186 | ENR | Anthony Ward | 1982-02-06 | UHC-87149-64 | 9407049238 | 1081 Pine Dr, Atlanta, GA, 30397 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-122538 | ENR | Omar D Johnson | 1962-12-05 | UHC-46064-43 | 6902619385 | 3316 Forest Ave, Phoenix, AZ, 85008 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-140009 | ENR | Vincent Delgado | 1960-02-12 | UHC-58815-25 | 7402126774 | 5442 Sunset Blvd, Miami, FL, 33162 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-139562 | ENR | Willie Chavez | 1952-10-12 | UHC-99334-33 | 8655801575 | 2780 Desert Sky Blvd, Plano, TX, 75096 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-114231 | ENR | Albert O Santos | 1985-08-12 | UHC-10621-50 | 6659790940 | 2953 Union St, Chandler, AZ, 85221 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-111986 | ENR | Sofia C Evans | 1941-08-25 | UHC-68436-79 | 9298454389 | 4963 Lake View Rd, Houston, TX, 77094 | 0.50 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-119212 | ENR | Sandra Soto | 2001-10-01 | UHC-82070-02 | 2129714286 | 9307 Mesa Dr Apt 32, Denver, CO, 80280 | 0.50 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-126242 | ENR | Wayne Davis | 1956-05-25 | UHC-67278-96 | — | 4681 Oak St, Eden Prairie, MN, 55309 | 0.50 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-119554 | ENR | Liz George | 1960-05-24 | UHC-90127-83 | 6874665661 | 2879 Sunset Blvd, Chandler, AZ, 85210 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-106540 | ENR | Austin Jordan | 1951-04-05 | UHC-02354-94 | — | 4762 Church St Apt 30, Eden Prairie, MN, 55340 | 0.50 | Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+3 more |
| ENR-122939 | ENR | Nicholas I Montgomery | 1976-12-24 | UHC-07349-58 | 2747217289 | 8660 Baseline Rd # 774, San Antonio, TX, 78250 | 0.50 | Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more |
| ENR-103235 | ENR | Denny Lopez | 1962-10-07 | UHC-83888-95 | 7704278758 | 2194 Church St, Seattle, WA, 98106 | 0.50 | Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+3 more |
| ENR-112429 | ENR | Sara B Ramos | 1998-09-02 | UHC-90845-02 | 6568151176 | 4731 Sage Ct, San Diego, CA, 92168 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-142908 | ENR | Joyyce U Snyder | 1993-12-04 | UHC-73911-66 | 4022466500 | 8349 Willow Ct, Fresno, CA, 93729 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-116637 | ENR | Sharon Jordan | 1940-10-09 | UHC-95905-11 | 4188870161 | 9743 Ridge Rd, Jacksonville, FL, 32207 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-115991 | ENR | Lucia T Reid | 2007-05-10 | UHC-97211-91 | 7009542204 | 2443 Washington St, Chandler, AZ, 85245 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112706 | ENR | Elijah Owens | — | UHC-32230-66 | 6147492074 | 428 Church St, Scottsdale, AZ, 85276 | 0.50 | Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more |
| ENR-112679 | ENR | Virginia T Rice | — | UHC-60262-09 | 5794576783 | 6678 Lincoln Way, Fresno, CA, 93726 | 0.50 | Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more |
| ENR-137936 | ENR | Gloria Chapman | 1938-10-11 | UHC-10323-58 | 4782630196 | 4425 Mesa Dr # 964, Denver, CO, 80291 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-133226 | ENR | Omar Castro | 1951-12-07 | UHC-27170-07 | 9416382938 | 7219 Oak St, Miami, FL, 33180 | 0.50 | Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-116567 | ENR | Jerry Burke | 1976-08-18 | UHC-38441-26 | — | 8032 Valley View Dr, Nashville, TN, 37248 | 0.50 | Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more |