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-131702 | ENR | Betty W Perez | 1993-11-02 | UHC-48568-73 | 6404220879 | 7980 Sage Ct, Houston, TX, 77045 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-138358 | ENR | Alice R Gibson | 1952-08-03 | UHC-06859-92 | 9569565704 | 3399 Palm Dr, Los Angeles, CA | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-121858 | ENR | Marcus Johnston | 1957-01-12 | UHC-13149-50 | 4234305655 | 7914 Meadow Ln, Las Vegas, NV, 89167 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-140952 | ENR | Marilyn Hart | 1964-01-17 | UHC-50479-15 | — | 448 Highland Ave, Eden Prairie, MN, 55376 | 0.50 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| ENR-113849 | ENR | Karen Jones | 2002-07-28 | UHC-76594-76 | 7426539630 | 203 Washington St, Los Angeles, CA, 90029 | 0.50 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-142250 | ENR | Carol X Hoffman | 1961-10-11 | UHC-22754-18 | 6155433254 | 2719 Elm St, Mesa, AZ, 85249 | 0.50 | Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+3 more |
| ENR-106297 | ENR | William Fox | 1961-11-11 | UHC-95380-97 | 3753489670 | 2561 Spring St, Charlotte, NC, 28243 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-136311 | ENR | Amy Fernandez | 1948-03-16 | UHC-54769-51 | 2897204760 | 3078 Lake View Rd, Los Angeles, CA, 90029 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-124285 | ENR | Julia N Jackson | 1986-05-03 | UHC-00538-03 | 7779058540 | 9856 Maple Ave, San Antonio, TX | 0.50 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-101932 | ENR | Mary B Simmons | 1941-09-06 | UHC-87003-66 | 5559499580 | 5610 River Rd, San Diego, CA | 0.50 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-106566 | ENR | Janet D Rios | 1994-08-18 | UHC-21359-12 | 4443876382 | 2984 Canyon Rd, Orlando, FL, 32801 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-128695 | ENR | Nancy Williamson | 1948-03-24 | UHC-86218-75 | 8245117466 | 8444 Apache Blvd # 354, Fresno, CA, 93781 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more |
| ENR-139692 | ENR | Wayne Z Wells | 1995-08-28 | UHC-44029-86 | 2015292038 | 1864 Oak St Apt 8, Nashville, TN, 37210 | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-114201 | ENR | Dorothy Q Mason | 1997-01-28 | UHC-16584-13 | — | 8937 Desert Sky Blvd, Glendale, AZ, 85340 | 0.50 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135387 | ENR | Martha P Jenkins | 1987-01-15 | UHC-38108-73 | 2944769082 | 8650 Apache Blvd, Sacramento, CA, 95821 | 0.50 | Name re-casedPhone reformattedSSN last four extractedState name converted to code+3 more |
| ENR-117485 | ENR | Albert Chavez | 1977-02-08 | UHC-43543-75 | 3206029693 | 6905 Maple Ave Apt 25, Fresno, CA, 93783 | 0.50 | Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-139771 | ENR | Juan Owens | 1990-04-23 | UHC-80301-15 | 9665314257 | 9414 Hillcrest Rd # 736, Orlando, FL, 32819 | 0.50 | Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-112646 | ENR | Christina Allen | 1957-02-22 | UHC-12140-68 | 3233474932 | 5023 Apache Blvd, Charlotte, NC, 28205 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more |
| ENR-143021 | ENR | Tyler S Anderson | 2002-09-16 | UHC-60331-66 | — | 7392 Main St, Sacramento, CA | 0.50 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| ENR-107863 | ENR | Roger Gonzalez | 1979-03-28 | UHC-13173-01 | — | 4584 Central Ave, Los Angeles, CA, 90057 | 0.50 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-107864 | ENR | Roger Gonzalez | 1979-03-28 | UHC-13173-01 | — | 4584 Central Ave, Los Angeles, CA, 90057 | 0.50 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-102909 | ENR | Christina Y Bradley | 1958-08-26 | UHC-61892-18 | 9852474058 | 934 Apache Blvd Apt 11, Plano, TX, 75078 | 0.50 | Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-100667 | ENR | Hiroshi I Payne | 1973-06-23 | UHC-37270-06 | 8092524500 | 6131 Apache Blvd, Austin, TX, 78777 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-114182 | ENR | Harold Fox | 1946-07-09 | UHC-10508-05 | 6978267472 | 8814 Elm St, Columbus, OH, 43242 | 0.50 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133661 | ENR | Wayne B Hansen | 1992-06-27 | UHC-73085-85 | 3507887140 | 9844 Mountain View Dr, San Diego, CA, 92131 | 0.50 | Middle initial moved out of first nameName re-casedPhone reformattedMember ID reformatted+3 more |
| ENR-132948 | ENR | Ryan Davis | 1968-07-03 | UHC-16030-43 | — | 3316 Hillcrest Rd, Sacramento, CA | 0.50 | Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+3 more |
| ENR-108351 | ENR | Camila D Murphy | 1983-01-06 | UHC-75358-97 | 5742191506 | 3039 Pine Dr, Glendale, AZ, 85303 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123103 | ENR | Jeffrey K Singh | 2008-10-28 | UHC-30073-49 | 9054588942 | 3844 Cedar Ln, Las Vegas, NV | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-126934 | ENR | Alan P Rice | 1997-11-15 | UHC-77693-50 | 7126101939 | 1231 Desert Sky Blvd, Phoenix, AZ, 85087 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-126933 | ENR | Alan P Rice | 1997-11-15 | UHC-77693-50 | 7126101939 | 1231 Desert Sky Blvd, Phoenix, AZ, 85087 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-112399 | ENR | Bobby Harper | 1991-12-14 | UHC-24069-93 | 2702784382 | 516 Park Pl, Fresno, CA, 93701 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135409 | ENR | Daniel Y Jensen | 1974-09-12 | UHC-77446-05 | 9178022537 | 3605 Baseline Rd, Chandler, AZ, 85239 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-129074 | ENR | Marcus P Lewis | 1981-05-06 | UHC-53639-04 | 3939827389 | 2066 Main St, Atlanta, GA, 30343 | 0.50 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-140635 | ENR | Kenneth H Garrett | 1999-04-11 | UHC-93400-76 | 8187002990 | 1710 Harbor Blvd, Minneapolis, MN, 55446 | 0.50 | Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-108920 | ENR | Jean Myers | 1977-02-04 | UHC-89681-88 | 4287338255 | 4776 Pine Dr, Orlando, FL, 32867 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-121350 | ENR | Alan O Maldonado | 1940-09-18 | UHC-40405-98 | 9648640740 | 3947 Willow Ct # 239, Fresno, CA, 93760 | 0.50 | Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-117222 | ENR | Sophia Ferguson | 1956-12-12 | UHC-38535-74 | 6188715819 | 5698 Baseline Rd, San Antonio, TX, 78225 | 0.50 | Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-111440 | ENR | Mason B Thmas | 1975-02-27 | UHC-72107-50 | 8042854375 | 9032 Hillcrest Rd, San Antonio, TX, 78283 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-128702 | ENR | Henry Sean | 2006-09-22 | UHC-61982-60 | 2738717720 | 4054 Apache Blvd Apt 38, Jacksonville, FL, 32272 | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-104768 | ENR | Lawrence V Estrada | 1944-10-22 | UHC-71464-18 | 2576532633 | 4645 Harbor Blvd, Columbus, OH, 43290 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-107762 | ENR | Kevin Franklin | 1974-07-23 | UHC-68794-85 | 4983975282 | 8025 Valley View Dr, Gilbert, AZ, 85242 | 0.50 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109417 | ENR | Shirley Cruz | 1978-10-23 | UHC-86255-78 | 8457280068 | 814 Baseline Rd, Glendale, AZ, 85314 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-117186 | ENR | Ann Barnes | 2002-11-15 | UHC-79988-61 | 8394609081 | 9185 Central Ave, Charlotte, NC | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-104160 | ENR | Vincent T Brooks | 1946-11-09 | UHC-04330-68 | 4282903653 | 1195 Ridge Rd, Eden Prairie, MN | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-133868 | ENR | Nathan A Alvarez | 1999-11-21 | UHC-29311-43 | 7384171614 | 3534 Mesa Dr, Seattle, WA, 98176 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-105673 | ENR | Patryck Willis | 1966-07-03 | UHC-50932-49 | 4114404827 | 1850 Cedar Ln, Denver, CO, 80233 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased+3 more |
| ENR-116893 | ENR | Michael V Harrison | — | UHC-04868-24 | 9577426060 | 7551 Lake View Rd, Los Angeles, CA, 90095 | 0.50 | Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-125096 | ENR | Debra S Coleman | 1946-01-26 | UHC-23801-02 | — | 9237 Washington St, Miami, FL, 33147 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-100971 | ENR | Ronald Perez | 1980-01-07 | UHC-12194-35 | 4698227013 | 3180 Elm St, Charlotte, NC, 28284 | 0.50 | Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more |
| ENR-109063 | ENR | Amber O Delgado | 1998-09-15 | UHC-52060-85 | 7168981217 | 6469 Market St # 734, Minneapolis, MN, 55401 | 0.50 | Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more |