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-113032 | ENR | Bobby F Ferguson | 1954-07-24 | UHC-22343-80 | 8354778259 | 541 Hillcrest Rd, Orlando, FL, 32896 | 0.50 | Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-131020 | ENR | Madison O Garza | 2005-11-04 | UHC-78183-73 | — | 9875 Mountain View Dr, Houston, TX, 77059 | 0.50 | Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-137954 | ENR | Cheryl R Harvey | 1954-09-11 | UHC-06347-28 | 4122967564 | 1249 Hillcrest Rd, Plano, TX | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-105451 | ENR | Joseph Wright | 1976-04-20 | UHC-09052-51 | 7436136113 | 2096 Willow Ct, Tampa, FL | 0.50 | Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-109062 | ENR | Judy D Rose | 1944-02-08 | UHC-90243-80 | 5324027610 | 6538 Park Pl, Los Angeles, CA, 90010 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-138619 | ENR | Jordan L Carr | 1973-07-06 | UHC-39558-60 | — | 205 Spring St, Gilbert, AZ, 85242 | 0.50 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| ENR-142718 | ENR | Christian T Price | 1944-08-02 | UHC-56714-75 | — | 1279 Church St, Tucson, AZ, 85725 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| ENR-140484 | ENR | Mark G Phillips | 1983-11-26 | UHC-10262-11 | 9655214060 | 7082 Camelback Rd Apt 38, Plano, TX, 75032 | 0.50 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-100827 | ENR | Ralph I Ortega | 1952-12-18 | UHC-17574-67 | 6463306441 | 2079 Meadow Ln Apt 16, Mesa, AZ, 85253 | 0.50 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-116158 | ENR | Walter L Mitchell | 1982-09-11 | UHC-14812-10 | 8143449306 | 909 Washington St Apt 8, Dallas, TX, 75274 | 0.50 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-123944 | ENR | William Jones | 2004-06-01 | — | 7995863731 | 4520 Canyon Rd, Atlanta, GA, 30349 | 0.50 | Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| ENR-131341 | ENR | Jennifer I Medina | 2000-06-27 | UHC-07728-57 | 7192372482 | 1107 Valley View Dr, Eden Prairie, MN, 55325 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-131342 | ENR | Jennifer I Medina | 2000-06-27 | UHC-07728-57 | 7192372482 | 1107 Valley View Dr, Eden Prairie, MN, 55325 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-136105 | ENR | George Ray | 2001-06-05 | UHC-83002-54 | 8359095135 | 2902 Union St, Houston, TX, 77045 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-129372 | ENR | Doris Griffin | 1994-02-10 | — | 9596854431 | 6340 Mesa Dr, Miami, FL | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-106659 | ENR | Austin V Berry | 2007-04-07 | UHC-63286-32 | 5375701799 | 4427 Washington St, Nashville, TN, 37276 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-107595 | ENR | Eugene Q Weber | 1996-02-13 | UHC-24096-95 | 3455033568 | 5066 Maple Ave, Minneapolis, MN, 55455 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-120326 | ENR | Julie D Thomas | 1980-10-02 | UHC-72071-18 | 7663789857 | 1788 Oak St Apt 3, Scottsdale, AZ, 85220 | 0.50 | Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-138489 | ENR | Sean M Delgado | 2007-05-22 | UHC-78051-06 | — | 8367 Cedar Ln, Orlando, FL, 32827 | 0.50 | Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-140438 | ENR | Carol A Jordan | — | UHC-04959-09 | 2436162008 | 4129 Lincoln Way # 700, Eden Prairie, MN, 55358 | 0.50 | Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-115479 | ENR | Chris D Hoffman | 1946-05-04 | UHC-47909-72 | 9243090019 | 6080 Baseline Rd, Houston, TX, 77022 | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-128121 | ENR | Cheryl Knight | 1961-08-03 | UHC-48893-14 | 2702108459 | 7882 Lake View Rd Apt 9, San Diego, CA, 92128 | 0.50 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-125135 | ENR | Samuel Salazar | 1980-09-13 | UHC-29299-52 | 4666535533 | 8284 Harbor Blvd, Sacramento, CA, 95851 | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-126342 | ENR | Julie Parker | 1957-11-17 | UHC-17844-10 | 8668998377 | 5167 Main St, Nashville, TN | 0.50 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-122315 | ENR | Pamela Howell | 1958-11-20 | UHC-60374-83 | 8199048004 | 8664 Mountain View Dr, Plano, TX, 75005 | 0.50 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-138085 | ENR | Omar Santos | — | UHC-67223-77 | 4687698289 | 7590 Willow Ct, Denver, CO, 80247 | 0.50 | Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-132861 | ENR | Mray P Olson | 1959-05-05 | UHC-41659-11 | 4605878102 | 853 Forest Ave # 785, Orlando, FL, 32830 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more |
| ENR-137047 | ENR | Mark Y Hicks | 1990-04-12 | UHC-61038-68 | 3108023624 | 2633 Hillcrest Rd, Austin, TX, 78718 | 0.50 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more |
| ENR-108469 | ENR | Joan X Bryant | 1976-01-01 | UHC-90182-19 | 3477781633 | 7618 Meadow Ln, Tucson, AZ, 85726 | 0.50 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-120882 | ENR | Samanha Crawford | 2006-05-16 | UHC-50412-88 | 5273036319 | 5510 Highland Ave, Tampa, FL, 33685 | 0.50 | Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-140930 | ENR | Elizabeth D Myers | 1981-12-18 | UHC-25672-92 | 3663642933 | 9332 Ridge Rd, Dallas, TX, 75292 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| ENR-100557 | ENR | Joohn Gardner | 1947-11-06 | UHC-45824-49 | 7044809229 | 6299 Desert Sky Blvd Apt 3, Austin, TX, 78722 | 0.50 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-115044 | ENR | Angela M Spencer | 1957-03-27 | UHC-26327-07 | 5559695081 | 3030 Indian School Rd, Columbus, OH, 43200 | 0.50 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-114257 | ENR | Dot H Elliott | 1963-04-10 | UHC-67017-31 | 6238675387 | 6036 Highland Ave, Plano, TX, 75048 | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-126145 | ENR | Bryan S Ramirez | 1996-01-11 | UHC-62667-46 | 2718844585 | 9889 Indian School Rd, Plano, TX, 75009 | 0.50 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-117607 | ENR | Abigail O Walker | 1944-08-21 | UHC-24452-04 | 8683317783 | 9062 Ridge Rd Apt 36, Sacramento, CA | 0.50 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| ENR-120577 | ENR | Hannah Wlliams | 1987-08-16 | UHC-36369-69 | 4214869341 | 7355 Camelback Rd, Tucson, AZ, 85768 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| ENR-128749 | ENR | Justin Mejia | 1982-04-05 | UHC-92003-96 | 9807822813 | 7815 Forest Ave, Minneapolis, MN | 0.50 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-140248 | ENR | Bryan Wallace | — | UHC-43200-36 | 6908774170 | 399 Desert Sky Blvd, Nashville, TN, 37226 | 0.50 | Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-141676 | ENR | Brenda Gilbert | 1964-04-10 | UHC-88402-76 | 7834110707 | 5169 Spring St Apt 6, Nashville, TN, 37209 | 0.50 | Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| ENR-133545 | ENR | Jonathan Roberts | 1942-08-19 | UHC-96363-58 | 7883418493 | 2139 Ocean Ave, Fresno, CA, 93779 | 0.50 | Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-142798 | ENR | Luis O Montgomery | 1992-02-03 | UHC-06571-51 | 3707124936 | 3225 Harbor Blvd, Houston, TX, 77058 | 0.50 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-109539 | ENR | Jacqueline Ward | 2005-10-19 | UHC-85118-85 | 4097503030 | 523 Lake View Rd, Tucson, AZ | 0.50 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| ENR-103963 | ENR | Juan A Washington | 1959-11-14 | UHC-91717-92 | 3765476480 | 2948 Highland Ave, Chandler, AZ, 85282 | 0.50 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| ENR-101543 | ENR | Kate Fiels | — | UHC-27585-35 | 8537793302 | 7998 Spring St, Mesa, AZ, 85205 | 0.50 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| ENR-142716 | ENR | George Coleman | — | UHC-22944-32 | 2869210112 | 7711 Valley View Dr, Sacramento, CA, 95896 | 0.50 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| ENR-121764 | ENR | Stephanie Lane | 1941-06-10 | UHC-25162-84 | 4474942332 | 7072 Baseline Rd, Atlanta, GA, 30315 | 0.50 | Two-digit birth yearMember ID reformattedSSN last four extractedState code upper-cased+3 more |
| ENR-133769 | ENR | Diego Snyder | — | UHC-57459-82 | 3989341877 | 2917 Washington St, Seattle, WA, 98101 | 0.50 | Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| ENR-105156 | ENR | Willie Schmit | 1946-01-03 | UHC-97718-83 | 7539794678 | 7642 Forest Ave, Seattle, WA, 98118 | 0.50 | Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more |
| ENR-120010 | ENR | Dennis G Carter | 1993-05-11 | UHC-04709-16 | 5205396307 | 749 Mountain View Dr, Atlanta, GA, 30381 | 0.50 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |