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-118225 | ENR | Nancy X Murray | 1976-09-03 | UHC-72199-70 | 6068535308 | 2773 Maple Ave, Scottsdale, AZ, 85243 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-141900 | ENR | Juan G Myers | 2000-11-12 | UHC-57612-75 | 9623449518 | 5401 Park Pl, Dallas, TX, 75281 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-117930 | ENR | Ryan V Harvey | 1976-06-26 | UHC-08814-34 | 7476642665 | 5411 Harbor Blvd Apt 27, Mesa, AZ, 85272 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-111585 | ENR | Elizabeth Bell | 1968-12-27 | UHC-65359-87 | 3476491358 | 4741 Hillcrest Rd Apt 11, Dallas, TX, 75249 | 0.60 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-105362 | ENR | Marilyn Y Jimenez | 2007-08-03 | UHC-04201-04 | 5458440152 | 7500 Maple Ave, Gilbert, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-119477 | ENR | Kathryn P Hall | 1978-10-11 | UHC-42231-04 | 3409730598 | 4517 Jefferson Ave, Phoenix, AZ, 85086 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-134332 | ENR | Dorothy F Collins | 1942-04-11 | UHC-66552-94 | 4869286027 | 8752 Broadway, Orlando, FL | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedAddress re-cased+4 more |
| ENR-138076 | ENR | Stephen E Fuller | 1966-02-27 | UHC-14276-03 | 5912434363 | 3178 Valley View Dr, San Antonio, TX, 78223 | 0.60 | Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more |
| ENR-126980 | ENR | Keith Diaz | 1996-11-13 | UHC-14729-92 | 8696037650 | 2922 Park Pl, Minneapolis, MN, 55455 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-116060 | ENR | Larry V Morgan | 1952-06-04 | UHC-19275-79 | 7059729318 | 5623 Market St, Sacramento, CA, 95874 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedSSN last four extracted+4 more |
| ENR-110232 | ENR | Sophia J Bowman | 1983-01-26 | UHC-12484-24 | 7946108740 | 1910 Forest Ave, San Diego, CA, 92167 | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-110380 | ENR | Harold D Hudson | 1980-08-07 | UHC-86397-55 | 4974924107 | 7039 Jefferson Ave, Dallas, TX, 75254 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-111530 | ENR | Albert Burton | 2004-07-01 | UHC-40536-65 | 2797710596 | 8988 Pine Dr # 495, Tucson, AZ, 85745 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-137722 | ENR | Jim R Kelley | 1947-11-13 | UHC-86255-50 | 9036209614 | 9773 Ocean Ave Apt 27, Tampa, FL, 33683 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-106264 | ENR | Jesse Gardner | 1984-12-15 | UHC-82310-03 | 4489826754 | 7386 Central Ave, Glendale, AZ | 0.60 | Name re-casedPhone reformattedCity re-casedZIP missing+4 more |
| ENR-109514 | ENR | Julia George | 1959-01-27 | UHC-91645-03 | 4694981212 | 2430 Valley View Dr, Charlotte, NC, 28221 | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111231 | ENR | Charles C Morrison | 1954-02-22 | UHC-66990-41 | 7069965379 | 5746 Harbor Blvd, Glendale, AZ, 85353 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| ENR-122246 | ENR | Paul U Lawson | 2005-04-09 | UHC-29000-24 | 3639530976 | 2360 Mesa Dr, Eden Prairie, MN, 55372 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-136068 | ENR | Lauren R Murphy | 1969-08-21 | UHC-46397-91 | 9237297088 | 2578 Lake View Rd # 376, Orlando, FL, 32845 | 0.60 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-104118 | ENR | Austin Hughes | 2000-06-04 | UHC-81540-49 | 4454953335 | 138 Meadow Ln, Eden Prairie, MN, 55308 | 0.60 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-142759 | ENR | Andrea Kelly | 1999-08-23 | UHC-83502-01 | 7415790386 | 3451 Valley View Dr, San Antonio, TX, 78230 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-113856 | ENR | Mei S Neslon | 1998-05-06 | UHC-81996-09 | 9375833268 | 6349 Indian School Rd, San Antonio, TX, 78263 | 0.60 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-130285 | ENR | Sean G Cooper | 1974-10-22 | UHC-87922-42 | 8649372471 | 567 Bayshore Dr, San Antonio, TX, 78291 | 0.60 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-109240 | ENR | Virginia C Weber | 1973-10-18 | UHC-27686-59 | 4492257728 | 3723 Ocean Ave, Seattle, WA, 98103 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-116317 | ENR | Olivia X Pena | 1962-11-01 | UHC-64907-39 | 4994022698 | 3732 Lake View Rd, Las Vegas, NV, 89186 | 0.60 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-110277 | ENR | Judy X Little | 2002-04-17 | UHC-61353-44 | 3639432651 | 1140 Cedar Ln, Columbus, OH | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-114483 | ENR | Heather H Lynch | 1996-05-02 | UHC-37423-63 | 6293745670 | 695 Highland Ave, Plano, TX | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-102427 | ENR | Patricia G Wood | 1957-06-24 | UHC-51254-08 | — | 2526 Meadow Ln, Jacksonville, FL, 32260 | 0.60 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-140352 | ENR | Kathryn B Salazar | 1942-07-06 | UHC-94095-01 | 7883228340 | 996 Sage Ct, San Antonio, TX, 78249 | 0.60 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-107295 | ENR | Mason D Ryan | 1990-04-02 | — | 5065248906 | 5688 Pine Dr, Chandler, AZ, 85297 | 0.60 | Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more |
| ENR-107281 | ENR | Camila L Meyer | 1971-08-08 | UHC-63608-27 | 4529304374 | 3788 Main St, Glendale, AZ, 85310 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-106962 | ENR | Sofia X Ortiz | 1942-11-24 | UHC-21428-86 | 9444603185 | 8551 Market St # 716, Fresno, CA, 93776 | 0.60 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-120683 | ENR | Amy Bell | 1952-11-17 | UHC-13517-15 | 8357067795 | 588 Church St, Plano, TX, 75054 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-108483 | ENR | Marcus J Delgado | 1990-12-17 | UHC-19436-23 | 9009239963 | 2234 Camelback Rd, Glendale, AZ, 85375 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-105757 | ENR | Austin Lucas | 1973-04-28 | UHC-18883-68 | — | 9566 Oak St, Minneapolis, MN, 55454 | 0.62 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| ENR-108265 | ENR | Isabella Carr | 1960-06-13 | UHC-32279-06 | 6887517986 | 1829 Mountain View Dr, Phoenix, AZ, 85008 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-111640 | ENR | Sarah Henderson | 1972-04-16 | UHC-24133-93 | 5716900431 | 8426 Cedar Ln, Mesa, AZ, 85238 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109624 | ENR | Kathryn L Carpeenter | 1974-11-22 | UHC-20471-72 | 2479061184 | 7653 Canyon Rd, Las Vegas, NV, 89153 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-121321 | ENR | Carol N Dunn | — | UHC-98857-51 | 9644550797 | 5140 Apache Blvd, Fresno, CA, 93731 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+3 more |
| ENR-120181 | ENR | Mary U Crawford | 1987-09-04 | UHC-87669-12 | 5073608916 | 9191 Ocean Ave, Scottsdale, AZ | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-120182 | ENR | Mary U Crawford | 1987-09-04 | UHC-87669-12 | 5073608916 | 9191 Ocean Ave, Scottsdale, AZ | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-113706 | ENR | Catherine Y Bennett | 1945-01-20 | UHC-61792-31 | 4918452836 | 9312 Indian School Rd, Orlando, FL, 32854 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-123606 | ENR | Andrrew O Matthews | 1977-04-05 | UHC-70642-50 | 7812181951 | 9858 Baseline Rd Apt 31, Orlando, FL, 32895 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-111022 | ENR | Camila Lucas | 1959-11-09 | UHC-50549-37 | — | 4364 Maple Ave, Chandler, AZ, 85205 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-140871 | ENR | Debra Q Burton | 1998-08-18 | UHC-42500-84 | 9399357160 | 639 Cedar Ln, Plano, TX, 75074 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-127351 | ENR | Danielle Murray | — | UHC-55126-74 | 4683016909 | 7790 Meadow Ln, Eden Prairie, MN, 55330 | 0.62 | Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more |
| ENR-112421 | ENR | Emily Stewart | 2005-11-05 | UHC-09336-70 | 7276010399 | 4286 Forest Ave # 201, Atlanta, GA, 30366 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| ENR-128915 | ENR | Anthony James | — | UHC-64793-65 | 9794147274 | 2390 Church St, Glendale, AZ, 85385 | 0.62 | Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+3 more |
| ENR-141885 | ENR | Arthur S Kennedy | 1983-12-05 | UHC-39550-85 | 6153030100 | 1114 River Rd # 901, Scottsdale, AZ, 85215 | 0.62 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-135449 | ENR | Wayne Boyd | 1966-06-01 | UHC-37084-54 | 4284496491 | 3787 Apache Blvd, Miami, FL, 33191 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |