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
All sources, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| ENR-125587 | ENR | Donna Luna | 1994-02-02 | — | 9639893508 | 4405 Willow Ct Apt 19, Eden Prairie, MN, 55333 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-116126 | ENR | Ralph Bowman | 1941-08-25 | UHC-50182-69 | 5895560311 | 8891 Camelback Rd, Dallas, TX | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| TPA-56246 | TPA | Stephen Q Evans | 1941-07-16 | — | 5667832046 | 539 Indian School Rd, Houston, TX, 77016 | 0.48 | Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more |
| TPA-63621 | TPA | Ethan Gilbert | 1974-06-16 | — | 4593999877 | 5664 Washington St, Houston, TX | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| TPA-60385 | TPA | Aaron Rojas | 1938-03-27 | — | — | 7749 Mesa Dr, Gilbert, AZ | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-116476 | ENR | Arthur V Santiago | 1957-01-17 | UHC-93303-99 | 4239085680 | 8326 Main St, Tempe, AZ, 85260 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-108165 | ENR | Kathryn Ramirez | — | UHC-00624-02 | 8616212548 | 9294 Park Pl, Gilbert, AZ, 85281 | 0.48 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-139588 | ENR | Catherine Riley | 1999-11-09 | UHC-20404-24 | 5239039881 | 7227 Canyon Rd, Mesa, AZ | 0.48 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111577 | ENR | Karen F Jackson | 1947-05-22 | UHC-05379-68 | 8543379329 | 1428 Jefferson Ave, Los Angeles, CA, 90023 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-114138 | ENR | Lauren Perry | — | UHC-79257-94 | 9664326969 | 1166 Camelback Rd, Eden Prairie, MN, 55300 | 0.48 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| TPA-62413 | TPA | William Hughes | 1978-01-02 | — | 8224563791 | 9230 Canyon Rd, Minneapolis, MN | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-128852 | ENR | Douglas Q Perry | 1979-03-18 | UHC-12328-71 | 3826546399 | 1326 Apache Blvd Apt 37, Austin, TX, 78772 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| CLM-412112 | CLM | Benjamin Shaw | 1992-05-24 | UHC-42535-60 | 6359194924 | 4124 Bayshore Dr, San Antonio, TX, 78298 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-113751 | ENR | Olivia Riz | 1980-03-08 | UHC-33228-23 | 2839755211 | 4821 Market St, Austin, TX, 78765 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| TPA-58816 | TPA | Jeeremy Robertts | 1994-12-02 | — | 5318715301 | 9863 Sage Ct # 320, Columbus, OH, 43260 | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| CLM-428863 | CLM | Arthur Johnson | 1954-04-15 | UHC-46807-70 | 8954334474 | 58 Spring St, Houston, TX, 77035 | 0.48 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-124461 | ENR | Debra Y Ortega | 1998-11-09 | UHC-53202-94 | 2993726462 | 3452 Meadow Ln, Orlando, FL | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-21243 | PRV | Marilyn Wyllis | 1997-06-15 | UHC-30752-12 | 8272927043 | 8924 Grand Ave, Atlanta, GA | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-104311 | ENR | Scott Barnes | 1999-01-19 | UHC-33275-94 | 6877396692 | 8037 Forest Ave, Chandler, AZ, 85280 | 0.48 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-106646 | ENR | Diana O Harrison | 1966-08-06 | UHC-09874-03 | 4013185529 | 7744 Central Ave, Gilbert, AZ | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-417875 | CLM | Madison Stephens | 1951-08-04 | — | — | 1893 Washington St, Chandler, AZ, 85243 | 0.48 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more |
| ENR-123936 | ENR | Dylan C Reed | 2005-08-19 | UHC-39800-75 | 3157449919 | 4465 Desert Sky Blvd # 550, Austin, TX, 78735 | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| PRV-27056 | PRV | Lisa Wnog | 1966-09-13 | UHC-10089-20 | 5915578825 | 6788 Oak St, Tucson, AZ, 85722 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| TPA-54950 | TPA | Jerry Greene | 1968-01-26 | — | 3499293563 | 6098 Sunset Blvd, Tempe, AZ, 85202 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-126954 | ENR | Dot Hall | — | UHC-15763-54 | 8307841334 | 6357 Highland Ave, Las Vegas, NV | 0.48 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| ENR-114204 | ENR | Benjamin Turner | 1949-04-08 | UHC-47719-18 | 3579393116 | 3818 Canyon Rd # 799, Tempe, AZ, 85282 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more |
| ENR-107721 | ENR | Ralph R Williamson | 1987-07-26 | — | 4805300172 | 1667 Palm Dr # 816, Scottsdale, AZ, 85254 | 0.48 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-105038 | ENR | Timothy P Reed | 1952-01-06 | UHC-12264-39 | — | 6718 Lincoln Way, Miami, FL, 33103 | 0.48 | Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+4 more |
| CLM-406161 | CLM | Noah Bryant | 1967-08-07 | — | 3669318406 | 5278 Mountain View Dr # 784, Columbus, OH, 43256 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-103739 | ENR | Elizabeth Mendez | 1941-01-06 | UHC-68235-58 | 8786261987 | 6053 Church St, Tampa, FL | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-107203 | ENR | Emily R Lopez | 1943-12-14 | UHC-00216-34 | 6468353919 | 6843 Camelback Rd Apt 4, Chandler, AZ | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| CLM-412875 | CLM | Donna F Le | 1965-02-06 | UHC-38557-93 | 3839133452 | 6110 Valley View Dr Apt 10, Chandler, AZ, 85262 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-141053 | ENR | Thomas M Luna | 1997-10-20 | UHC-95083-87 | 8886275690 | 4011 Main St, Orlando, FL, 32803 | 0.48 | Middle initial moved out of first nameName re-casedPhone reformattedCity re-cased+4 more |
| ENR-102759 | ENR | Cynthia L George | 1997-10-13 | UHC-88626-78 | — | 8035 Lincoln Way, Los Angeles, CA, 90033 | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-130538 | ENR | Jon Petersun | 1958-09-11 | UHC-98787-15 | 3702107906 | 8169 Sunset Blvd, Houston, TX, 77071 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| ENR-138872 | ENR | Richard Carpenter | 1973-01-14 | UHC-63811-16 | 7212280784 | 1751 Elm St, Fresno, CA | 0.48 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-418818 | CLM | Joseph Evans | 1996-07-02 | UHC-53901-47 | 9574916916 | 7198 Oak St, Tempe, AZ, 85236 | 0.48 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-136602 | ENR | Aaron Reid | 1968-04-25 | UHC-10885-76 | 7645795913 | 1642 Apache Blvd, Miami, FL, 33146 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| TPA-62272 | TPA | Austin Gibson | 1985-01-01 | — | — | 8410 Sage Ct, Seattle, WA, 98137 | 0.48 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more |
| ENR-114555 | ENR | Mei N Gibson | 1976-07-16 | UHC-57095-09 | 5373260077 | 8772 Union St, Seattle, WA, 98121 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-422814 | CLM | Natalie Ferguson | 1942-05-16 | UHC-75951-23 | 5516753146 | 8350 Hillcrest Rd, Tempe, AZ, 85206 | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-134944 | ENR | Sandra Martin | 2003-11-26 | UHC-35036-04 | 9778538341 | 5929 Indian School Rd, Columbus, OH, 43227 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| ENR-140890 | ENR | Isabella Parrk | 1943-09-21 | UHC-62319-56 | 8943437923 | 2082 Lake View Rd, Minneapolis, MN, 55450 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-418946 | CLM | Pat Ford | 1991-01-12 | — | 9043307144 | 6567 Mountain View Dr, Mesa, AZ, 85235 | 0.48 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| ENR-111204 | ENR | Gregory Martinez | 1950-05-21 | UHC-78137-30 | 8033377345 | 4284 Jefferson Ave, Las Vegas, NV, 89172 | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-102177 | ENR | Grace M Valdez | 2002-08-14 | UHC-35478-16 | 9686821189 | 2005 Elm St, Jacksonville, FL, 32298 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-136206 | ENR | Margaret Ryan | 1961-09-12 | UHC-30630-78 | 2418857734 | 3627 Mountain View Dr, Nashville, TN, 37229 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| PRV-27837 | PRV | Ralph Kelley | 1975-09-22 | UHC-28952-82 | 8395879904 | 1320 Pine Dr, Tempe, AZ | 0.48 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more |
| ENR-141777 | ENR | Mason I Mason | 1956-07-17 | UHC-59847-77 | 9004442189 | 682 Main St, Columbus, OH, 43245 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| ENR-127510 | ENR | Elijah Phillips | 1995-11-21 | UHC-93293-77 | 9525091543 | 2832 Baseline Rd # 432, Sacramento, CA, 95820 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |