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-113660 | ENR | Mari Dunn | 2006-05-22 | UHC-02585-20 | — | 929 Union St, Dallas, TX, 75273 | 0.48 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more |
| ENR-117444 | ENR | Dorothy James | 1986-02-16 | UHC-93469-77 | 4016111175 | 8094 Indian School Rd, Eden Prairie, MN, 55392 | 0.48 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-105830 | ENR | Rachl X Davis | 1993-10-04 | UHC-17326-95 | 7689040466 | 4711 River Rd, Charlotte, NC, 28247 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-127383 | ENR | Thomas Lynch | 1955-12-03 | UHC-15368-92 | 4057663091 | 7119 Maple Ave, Atlanta, GA, 30364 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-138846 | ENR | Dylan Fernandez | 2006-08-09 | UHC-35577-71 | 8673533307 | 467 Indian School Rd # 103, Denver, CO, 80234 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-113463 | ENR | James I McDonald | 1959-03-20 | UHC-97198-99 | 4352519505 | 209 Mountain View Dr, Fresno, CA | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-102039 | ENR | Ronald J Crawforrd | 1946-11-23 | UHC-31165-99 | 2464405025 | 8237 Apache Blvd Apt 16, San Antonio, TX, 78278 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-107536 | ENR | Kyle Dominguez | 1953-04-28 | UHC-47896-19 | 2809134875 | 1431 Grand Ave Apt 7, Columbus, OH, 43217 | 0.48 | Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+4 more |
| ENR-115315 | ENR | Bruce Gordon | — | UHC-76548-65 | 9128951340 | 1965 Apache Blvd, Austin, TX, 78712 | 0.48 | Name re-casedDate of birth missingPhone reformattedCity re-cased+4 more |
| ENR-135766 | ENR | Alan Gray | 2005-10-03 | UHC-03446-34 | 3762867399 | 4622 Jefferson Ave, Atlanta, GA, 30320 | 0.48 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111708 | ENR | Anthony Vaga | 1969-08-01 | UHC-69881-96 | 6212547981 | 7684 Sage Ct, Charlotte, NC, 28207 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-109102 | ENR | Marilyn Hudson | 1998-12-27 | UHC-41649-59 | — | 2271 Desert Sky Blvd, Charlotte, NC, 28232 | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+4 more |
| ENR-126083 | ENR | Ann Singh | 1944-09-18 | UHC-68432-82 | 2323236049 | 1013 Camelback Rd # 671, Fresno, CA, 93720 | 0.48 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-129229 | ENR | Jacob O Herrera | 1943-08-15 | — | 9255373957 | 3774 Palm Dr, Plano, TX | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-136251 | ENR | Philip Perkins | 1944-08-04 | UHC-20874-77 | 8628068729 | 6656 Union St # 806, Gilbert, AZ, 85221 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more |
| ENR-141329 | ENR | Becky Q Jones | 1967-05-27 | UHC-46908-53 | 7535833803 | 7642 Lincoln Way Apt 9, Seattle, WA, 98182 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-116879 | ENR | Jerry Romero | 1964-03-24 | UHC-98312-99 | 2679081891 | 855 Lake View Rd, Tucson, AZ | 0.48 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-122069 | ENR | Peter Gray | 1985-08-23 | UHC-33256-68 | 4647764297 | 876 Spring St Apt 31, Los Angeles, CA | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-102978 | ENR | Joshua Johnson | — | UHC-72422-30 | 6657950588 | 7815 Maple Ave, Tucson, AZ, 85726 | 0.48 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more |
| ENR-119042 | ENR | Carolyn I Herrera | 1965-07-04 | UHC-83872-65 | 3757062283 | 7974 Washington St, Gilbert, AZ, 85261 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-104033 | ENR | Gerald C Cunningham | 1951-07-23 | UHC-47203-81 | 7875677578 | 3051 Washington St, Scottsdale, AZ | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-132964 | ENR | Diana Little | 1976-07-05 | UHC-64760-52 | 7043619723 | 346 Jefferson Ave, Eden Prairie, MN, 55312 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-126849 | ENR | Roger L Howard | 2001-08-11 | UHC-32346-57 | 9205552067 | 9283 Lincoln Way, Nashville, TN, 37209 | 0.48 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-117362 | ENR | Diana A Cooper | 1952-09-12 | UHC-80204-72 | 7916680548 | 9763 Hillcrest Rd, Las Vegas, NV | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-117076 | ENR | Lauren S Valdez | 1944-06-21 | UHC-73108-23 | 7699924425 | 1720 Market St # 963, Tucson, AZ, 85766 | 0.48 | Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more |
| ENR-142565 | ENR | Alice L Adams | 2003-11-05 | UHC-37979-98 | — | 2201 Canyon Rd, Gilbert, AZ, 85214 | 0.48 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more |
| ENR-102097 | ENR | Douglas Carr | 1967-01-03 | UHC-34967-07 | 6544442330 | 8779 Highland Ave, Phoenix, AZ, 85020 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-123698 | ENR | Paul M Robertson | — | UHC-98133-86 | 7868963192 | 1361 Maple Ave, Jacksonville, FL | 0.48 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more |
| ENR-127848 | ENR | Victoria Stewart | 1980-01-04 | UHC-07460-23 | 9043190599 | 860 Forest Ave, San Antonio, TX, 78296 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111732 | ENR | LoganJunk | 1994-07-22 | UHC-07950-97 | 4009736982 | 9605 Canyon Rd, Mesa, AZ, 85203 | 0.48 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-115996 | ENR | Joshua H Jensen | 2002-08-16 | UHC-44883-71 | 8132217562 | 5857 Cedar Ln, Dallas, TX, 75252 | 0.48 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-100717 | ENR | Dorothy N Hill | 1999-08-03 | UHC-52013-53 | 2707688647 | 7095 Elm St, Orlando, FL, 32863 | 0.48 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-103637 | ENR | Jerry McDonald | 1940-11-01 | UHC-42185-25 | 3376984913 | 8173 Hillcrest Rd Apt 35, Atlanta, GA, 30351 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-103636 | ENR | Jerry McDonald | 1940-11-01 | UHC-42185-25 | 3376984913 | 8173 Hillcrest Rd Apt 35, Atlanta, GA, 30351 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-119006 | ENR | Justin Snyder | 1941-02-25 | UHC-15556-78 | 8637442511 | 6092 Ocean Ave, Scottsdale, AZ | 0.48 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-123665 | ENR | Jennifer F West | 1962-05-28 | UHC-32000-97 | — | 9635 Camelback Rd, Austin, TX | 0.48 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-114070 | ENR | Camila Knight | 1975-02-01 | UHC-56856-16 | 9185685593 | 531 Baseline Rd Apt 2, Charlotte, NC, 28297 | 0.48 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-136144 | ENR | Isabella Z Reed | 1987-08-24 | UHC-76255-44 | 7686605539 | 8519 Main St, Gilbert, AZ, 85250 | 0.48 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-130856 | ENR | Arthur Garrett | 1991-02-17 | UHC-98433-73 | 7604555393 | 4997 Camelback Rd, Miami, FL, 33122 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-141932 | ENR | Douglas D Castillo | 1962-12-03 | UHC-86309-17 | 7402024997 | 5903 Lake View Rd # 572, Jacksonville, FL, 32208 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more |
| ENR-107747 | ENR | Larry L Herrera | 1954-02-16 | UHC-34195-55 | 2547296438 | 3663 Mountain View Dr, Austin, TX, 78779 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-107604 | ENR | Matthew Ryan | 1972-02-10 | UHC-87039-03 | 8419439485 | 2434 Willow Ct, Eden Prairie, MN | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-100409 | ENR | Heather H Thomas | 1998-02-05 | UHC-74493-68 | 2372145528 | 7841 Church St # 744, Minneapolis, MN, 55431 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-120436 | ENR | Katherine N Hawkins | — | UHC-90748-59 | 8819951080 | 7014 Valley View Dr, Austin, TX, 78788 | 0.48 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| ENR-101263 | ENR | Andrew Harper | 1978-03-24 | UHC-15603-56 | 9438400787 | 340 Lake View Rd, Los Angeles, CA, 90001 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-129277 | ENR | Samantha F Peters | 1997-12-01 | UHC-59150-84 | 6303396349 | 4730 Mountain View Dr, Miami, FL, 33142 | 0.48 | Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more |
| ENR-117986 | ENR | Ann L Morgan | 2001-12-12 | UHC-18409-32 | 7677201619 | 6424 Cedar Ln, San Diego, CA, 92107 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-110931 | ENR | Alan A Wilson | — | UHC-64460-07 | 4378382365 | 9375 Camelback Rd # 395, Columbus, OH, 43279 | 0.48 | Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-108984 | ENR | Jess Chapman | 2003-12-21 | UHC-58883-44 | 4519364767 | 360 Desert Sky Blvd, Tampa, FL, 33619 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| ENR-132192 | ENR | Vincant Sullivan | 1973-06-20 | UHC-26763-55 | 2977589648 | 8234 Jefferson Ave Apt 18, San Antonio, TX, 78246 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more |