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-120947 | ENR | Margaret R Lane | 1979-04-20 | UHC-85163-67 | — | 2784 Spring St, Plano, TX, 75015 | 0.62 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-115728 | ENR | Andrea Cunninhgam | 2002-03-21 | UHC-76946-30 | 3855062175 | 8232 Palm Dr, Glendale, AZ, 85388 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128119 | ENR | Jack Peterson | 1948-07-06 | UHC-88562-34 | 8114394732 | 1460 Elm St # 339, Gilbert, AZ, 85208 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-116946 | ENR | Angela Russell | 1994-02-13 | UHC-68381-32 | 3505888932 | 7156 Palm Dr, Charlotte, NC, 28213 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-129283 | ENR | Charles D Cook | 1998-06-25 | UHC-52550-77 | 5102279429 | 7590 Harbor Blvd, San Diego, CA, 92174 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-111555 | ENR | Nathan Rose | 1964-05-05 | UHC-57831-42 | 9882545271 | 439 Baseline Rd, Denver, CO, 80269 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-129324 | ENR | Valentina Weebr | 2006-12-12 | UHC-57709-74 | 2583108678 | 312 Hillcrest Rd, Columbus, OH, 43201 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more |
| ENR-112464 | ENR | Aaron O Estrada | 1988-08-23 | UHC-63672-89 | 3947125800 | 8086 Pine Dr, Scottsdale, AZ, 85208 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-105466 | ENR | Alexis Z Davis | 1952-08-28 | UHC-98113-37 | 2836132995 | 3470 Bayshore Dr, Los Angeles, CA | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-116990 | ENR | Daniel George | 1953-03-20 | UHC-72093-23 | 4159415765 | 9371 Meadow Ln, Los Angeles, CA, 90007 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-132719 | ENR | Wayne E Obryen | 1973-01-20 | UHC-06710-35 | 4597804684 | 1154 Mountain View Dr # 807, Denver, CO, 80293 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-120954 | ENR | Deborah B Daniels | 1957-09-12 | UHC-00645-06 | 6517443924 | 8562 Oak St, Columbus, OH, 43288 | 0.62 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-142283 | ENR | Jeffey Bell | 1972-05-09 | UHC-87351-38 | 6087265591 | 5075 Lincoln Way, Charlotte, NC | 0.62 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| ENR-130592 | ENR | Virginia Guerrero | 1945-06-21 | UHC-61356-39 | 5128171485 | 6889 Oak St, Gilbert, AZ, 85265 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-117801 | ENR | Jason T Phillips | 1986-08-11 | UHC-16875-64 | — | 6367 Maple Ave, Houston, TX, 77051 | 0.62 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| ENR-142491 | ENR | Amy L Sanchez | 1972-07-02 | UHC-63205-92 | 4658717286 | 7045 Desert Sky Blvd, Sacramento, CA, 95892 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more |
| ENR-138022 | ENR | Emma Q Jones | 1984-09-21 | UHC-90645-71 | 7348637725 | 6315 Spring St, Mesa, AZ, 85228 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-133346 | ENR | Kathleen Jordan | 1993-05-20 | UHC-29134-81 | 4562653540 | 5168 River Rd, Houston, TX, 77026 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-107148 | ENR | Dan T Williams | 1939-11-01 | UHC-57654-55 | 3412590056 | 8390 Park Pl Apt 31, Minneapolis, MN, 55408 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-125134 | ENR | Nathan Patterson | 2007-05-04 | UHC-25197-71 | 2359977325 | 1020 Central Ave, Los Angeles, CA, 90095 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| ENR-130996 | ENR | Kathryn L Schmidt | 1992-04-13 | UHC-54467-52 | 8232869894 | 6379 Main St, Phoenix, AZ, 85000 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-135169 | ENR | Sara I Baker | 1979-12-05 | UHC-35017-70 | 5226618224 | 9270 Valley View Dr Apt 7, Houston, TX, 77071 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-111762 | ENR | Kevin Rice | 1999-08-06 | UHC-54331-49 | 2332187197 | 8670 Main St, Chandler, AZ, 85265 | 0.62 | Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+3 more |
| ENR-143080 | ENR | Alan Mendez | 1979-10-25 | UHC-71838-76 | 5805988097 | 7393 Central Ave # 835, Eden Prairie, MN, 55302 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-123035 | ENR | Jerry L Jenkins | 1965-07-13 | UHC-66005-72 | 6953877776 | 4174 Pine Dr, Tampa, FL, 33627 | 0.62 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more |
| ENR-118454 | ENR | Kayla P Patel | 1964-09-08 | UHC-00656-58 | 4189011716 | 4595 Bayshore Dr, Tampa, FL, 33672 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| ENR-117468 | ENR | Nicole O Bowman | 2003-02-21 | UHC-37752-72 | 7065917740 | 7831 Jefferson Ave, Sacramento, CA, 95828 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-111134 | ENR | Judy Duncan | 1948-02-27 | UHC-42260-42 | — | 8799 Palm Dr, San Antonio, TX, 78217 | 0.62 | Name re-casedPhone missing area codeCity re-casedState name converted to code+3 more |
| ENR-121768 | ENR | Ahmed P Fisher | 1986-05-01 | UHC-68058-04 | 5053056699 | 44 Elm St, Seattle, WA, 98149 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more |
| ENR-107792 | ENR | Jacob Warren | 1988-08-12 | — | 9794341797 | 860 Market St, Dallas, TX, 75236 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-140348 | ENR | Timothy Carter | 1941-02-01 | UHC-21773-28 | 9864805461 | 405 Sage Ct # 285, Sacramento, CA, 95803 | 0.62 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-140684 | ENR | Michael Alexander | 1989-04-27 | UHC-07738-35 | 8776182850 | 3873 Market St # 862, Dallas, TX, 75298 | 0.62 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more |
| ENR-120696 | ENR | John F Poorter | 1993-06-22 | UHC-39257-53 | 7939670501 | 2936 Camelback Rd # 595, San Diego, CA, 92107 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-128788 | ENR | Mei D Montgomery | 1980-10-03 | UHC-76866-45 | 8806903350 | 3156 Harbor Blvd, Gilbert, AZ, 85276 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-137639 | ENR | Cynthia V Fuller | 1974-01-03 | UHC-17057-28 | 2178250135 | 2479 Park Pl, Charlotte, NC, 28299 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-117433 | ENR | Benjamin Mendez | 1939-12-09 | UHC-12746-66 | 2567746169 | 5835 Oak St, Gilbert, AZ, 85248 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-120202 | ENR | Paul E Hernandez | 1954-12-17 | UHC-38285-60 | 3323706862 | 9335 Indian School Rd, Chandler, AZ, 85207 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-101295 | ENR | Amber N Greene | 1942-05-19 | UHC-79174-43 | 2484631948 | 7738 Market St, Denver, CO, 80286 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-114256 | ENR | Hiroshi R Elliott | 1970-05-26 | UHC-09860-18 | 2019379785 | 9492 Maple Ave, Chandler, AZ, 85239 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-140507 | ENR | Julie Walsh | 1980-09-08 | UHC-41401-24 | 7853136471 | 4721 Meadow Ln, Fresno, CA, 93756 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-111225 | ENR | Gary Greene | 1939-11-01 | UHC-81078-05 | 5075734084 | 1733 River Rd # 757, Houston, TX, 77027 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-137955 | ENR | Cheryl R Harvey | 1954-09-11 | UHC-06347-28 | 4122967564 | 1249 Hillcrest Rd Apt 13, Plano, TX, 75028 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| ENR-128374 | ENR | Justin X Barnes | 1994-06-25 | UHC-81905-48 | — | 2955 Elm St, Mesa, AZ, 85228 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128375 | ENR | Justin X Barnes | 1994-06-25 | UHC-81905-48 | — | 2955 Elm St, Mesa, AZ, 85228 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-100834 | ENR | Dense L Thomas | 1973-08-10 | UHC-85521-23 | 6464396033 | 4469 Union St, Seattle, WA, 98191 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-138439 | ENR | Padilla Ann | 2008-10-04 | UHC-67047-34 | 7436905782 | 6081 Lake View Rd, Minneapolis, MN | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-101820 | ENR | LarryJunk | 1970-10-10 | UHC-13292-28 | 3102216691 | 6320 Baseline Rd, Eden Prairie, MN, 55358 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-138596 | ENR | Teresa V Ortega | 1938-08-18 | UHC-69546-42 | 6216123060 | 7314 Oak St, Jacksonville, FL, 32227 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-111751 | ENR | Sofia U Vazquez | 1971-05-03 | UHC-95246-52 | 4575405160 | 6152 Apache Blvd, Seattle, WA, 98197 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| ENR-131414 | ENR | Mark H Kelly | 1978-10-13 | UHC-20486-09 | 2392338348 | 9319 Main St Apt 40, San Diego, CA, 92127 | 0.62 | Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more |