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,257
Placeholder tokens such as NULL, N/A, UNKNOWN or "-" treated as empty
Whitespace trimmed57,061
Leading or trailing whitespace removed from one or more fields
Address re-cased56,490
Street line re-cased and punctuation removed
Street suffix standardised55,824
Street suffix standardised to USPS abbreviation (Street to St, Avenue to Ave, and so on)
Phone reformatted50,244
Phone reduced to ten digits, punctuation and leading country code removed
Name re-cased39,996
Name letter-case rewritten to Title Case and stray characters removed
Date of birth reformatted32,400
Date of birth rewritten to ISO 8601 from a source format (MM/DD/YYYY, YYYYMMDD, Mon D, YYYY)
City re-cased17,850
City re-cased to Title Case
Gender normalised16,828
Gender mapped to F or M from a longer or variant value
Email lower-cased11,635
Email lower-cased
Name split from “Last, First”9,980
First-name field held "LAST, FIRST"; the two parts were split into their own fields
State name converted to code9,084
Full state name replaced by its two-letter USPS code
ZIP+4 trimmed8,263
ZIP+4 trimmed to the five-digit ZIP
Member ID reformatted7,723
Member ID re-hyphenated and upper-cased to the UHC-#####-## pattern
ZIP missing7,146
Street address present but no ZIP supplied
Unit split from street6,994
Apartment, suite or unit designator split from street line and re-appended in standard form
Two-digit birth year6,661
Date of birth carried a two-digit year; century inferred by pivot
State code upper-cased4,010
Two-letter state code upper-cased
Plan code upper-cased3,278
Plan code upper-cased
SSN last four extracted2,817
Last four digits of SSN extracted from a longer or punctuated value
Date of birth unreadable2,274
Date of birth did not match any known format or was out of range; cleared
Phone missing area code2,021
Phone had only seven digits (no area code); cleared
Middle initial moved out of first name1,125
A single middle initial was embedded in the first-name field and moved to middle name
Date of birth missing990
Date of birth absent or a null token; left empty
No usable name (quarantined)505
No usable last name; record quarantined as junk and excluded from matching

Normalised records

Third-party administrator, flag “ZIP missing”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP missingClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-54899	TPA	Russell Andrews	—	—	—	2725 Pine Dr, Chandler, AZ	0.52	Date of birth missing Street suffix standardised Address re-cased ZIP missing+2 more
TPA-63687	TPA	Christian Coleman	2001-06-07	—	6378226687	1394 Palm Dr # 409, San Diego, CA	0.52	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
TPA-53714	TPA	Roy Mendez	1973-06-03	—	7732206513	9475 Meadow Ln, Scottsdale, AZ	0.52	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing+2 more
TPA-59042	TPA	Juan Lewis	1964-04-09	UHC-51931-21	9282759792	4772 Jefferson Ave, Scottsdale, AZ	0.52	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
TPA-64257	TPA	Jack Graham	1981-03-04	—	—	9805 Camelback Rd, Eden Prairie, MN	0.52	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
TPA-61253	TPA	Joe Bradley	2005-11-16	—	—	5348 Apache Blvd Apt 39, Denver, CO	0.52	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
TPA-55600	TPA	Zachary Gonzalez	1994-03-17	—	9378045143	6204 Hillcrest Rd, Las Vegas, NV	0.52	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
TPA-59754	TPA	Joyce K Reynolds	1963-10-28	—	—	3813 Harbor Blvd, Sacramento, CA	0.52	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing+2 more
TPA-59842	TPA	Andrew Carr	1974-06-15	—	—	1806 Church St, Houston, TX	0.52	Street suffix standardised Address re-cased ZIP missing Gender normalised+2 more
TPA-60968	TPA	Kenneth West	1989-04-08	—	—	8925 Pine Dr, Austin, TX	0.52	Street suffix standardised Address re-cased State name converted to code ZIP missing+2 more
TPA-60967	TPA	Kenneth West	1989-04-08	—	—	8925 Pine Dr, Austin, TX	0.52	Street suffix standardised Address re-cased State name converted to code ZIP missing+2 more
TPA-60389	TPA	Patrick Knight	1978-08-19	—	—	4240 Indian School Rd, Plano, TX	0.52	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
TPA-55047	TPA	Terry N Arnold	1952-02-27	—	—	5298 Elm St, Sacramento, CA	0.52	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing+2 more
TPA-58258	TPA	Aisha Snyder	1967-03-11	—	—	7756 Hillcrest Rd, Atlanta, GA	0.52	Street suffix standardised Address re-cased State name converted to code ZIP missing+2 more
TPA-63705	TPA	Madison Spencer	1973-01-18	—	9489971918	8387 River Rd, Denver, CO	0.52	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
TPA-58647	TPA	Carolyn Gordn	1956-11-16	UHC-62649-12	—	5433 Desert Sky Blvd, Scottsdale, AZ	0.52	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
TPA-59407	TPA	Jeffrey X Prk	1938-06-15	—	—	5894 Pine Dr, Chandler, AZ	0.52	Street suffix standardised Address re-cased State code upper-cased ZIP missing+2 more
TPA-55887	TPA	Eric Jenkinns	2004-02-27	—	4014251483	8967 Pine Dr, Nashville, TN	0.52	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
TPA-56677	TPA	Paul Garza	1980-09-17	—	—	9746 Forest Ave, Austin, TX	0.52	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code+2 more
TPA-50837	TPA	Kyle Z Phillips	1964-08-19	—	—	4114 Cedar Ln, Chandler, AZ	0.52	Name re-cased Two-digit birth year ZIP missing Gender normalised+2 more
TPA-61307	TPA	Mason McDonaald	1974-03-23	UHC-56620-79	8689519816	2651 Mountain View Dr, Glendale, AZ	0.52	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
TPA-64228	TPA	Lisa Graham	1951-12-26	—	—	4093 Ridge Rd, Tampa, FL	0.52	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing+2 more
TPA-58815	TPA	Jeremy A Roberts	1994-12-02	—	—	9863 Sage Ct, Columbus, OH	0.52	Street suffix standardised Address re-cased State code upper-cased ZIP missing+2 more
TPA-63948	TPA	Natalie Ryan	2004-06-05	—	—	9790 Washington St # 404, Minneapolis, MN	0.52	Name re-cased Unit split from street ZIP missing Gender normalised+2 more
TPA-56478	TPA	Steven George	—	UHC-39607-73	—	3251 Desert Sky Blvd, Charlotte, NC	0.52	Date of birth unreadable Street suffix standardised Address re-cased ZIP missing+2 more
TPA-57168	TPA	Alice I Sanders	2002-07-10	—	—	1418 Forest Ave, Plano, TX	0.52	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
TPA-57167	TPA	Alice I Sanders	2002-07-10	—	—	1418 Forest Ave, Plano, TX	0.52	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
TPA-61489	TPA	Valentina Morris	2000-09-25	UHC-14927-47	—	1890 Mesa Dr, Austin, TX	0.52	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
TPA-59776	TPA	Nancy Austin	1950-10-02	—	—	3707 Valley View Dr # 833, Austin, TX	0.52	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
TPA-58481	TPA	Gerald Banks	1998-10-17	UHC-54196-42	—	1424 Desert Sky Blvd, Mesa, AZ	0.52	Two-digit birth year Street suffix standardised Address re-cased ZIP missing+2 more
TPA-51416	TPA	Kevin Rogers	1973-08-11	—	—	4596 Central Ave, Plano, TX	0.52	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code+2 more
TPA-61902	TPA	James Gardner	1993-12-01	—	—	4528 Desert Sky Blvd, Nashville, TN	0.52	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
TPA-53372	TPA	Natalie Burton	1967-05-28	—	—	523 Main St Apt 11, Tucson, AZ	0.52	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
TPA-55987	TPA	Carlos P Le	1944-10-15	UHC-07359-80	—	7655 Lake View Rd, Charlotte, NC	0.52	Name re-cased Street suffix standardised Address re-cased State name converted to code+2 more
TPA-54908	TPA	Keith Jones	1956-01-16	—	—	4325 Church St, Gilbert, AZ	0.52	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
TPA-60063	TPA	Laura Weber	1941-09-14	—	—	3697 Highland Ave, Orlando, FL	0.52	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing+2 more
TPA-55608	TPA	Jerry E Porter	1980-01-22	—	—	8480 Forest Ave, Tempe, AZ	0.52	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing+2 more
TPA-60240	TPA	Denise Young	1969-11-18	—	—	2167 Desert Sky Blvd, Tempe, AZ	0.52	Date of birth reformatted State name converted to code ZIP missing Gender normalised+2 more
TPA-50876	TPA	Martha M Dean	1989-02-17	—	—	5105 Spring St, Tempe, AZ	0.52	Street suffix standardised Address re-cased State name converted to code ZIP missing+2 more
TPA-50457	TPA	Beverly Dominguez	1963-06-01	—	9233500104	2507 Cedar Ln, San Diego, CA	0.52	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
TPA-54980	TPA	Dylan Deaan	1940-04-18	—	3722813844	3307 Apache Blvd, Atlanta, GA	0.52	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
TPA-59257	TPA	Jordan Murphy	1986-12-16	—	—	621 Indian School Rd, Gilbert, AZ	0.52	Name re-cased Street suffix standardised Address re-cased State name converted to code+2 more
TPA-63043	TPA	—Junk	1975-03-16	—	—	4120 River Rd, Jacksonville, FL	0.52	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+2 more
TPA-57264	TPA	Janet X Henderson	1976-07-16	—	9843086993	7039 Mountain View Dr Apt 28, Houston, TX	0.52	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
TPA-55780	TPA	Diana Dixon	1963-04-18	—	5818824163	5701 Union St, Nashville, TN	0.52	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing+2 more
TPA-64272	TPA	Benjamin Walker	1995-12-12	—	—	4431 Union St Apt 10, Jacksonville, FL	0.52	Unit split from street Street suffix standardised Address re-cased ZIP missing+2 more
TPA-51983	TPA	Timothy Tran	1958-04-25	—	4657645355	5906 Apache Blvd, Glendale, AZ	0.52	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
TPA-58587	TPA	Randy Long	1990-01-25	—	—	3698 River Rd, San Diego, CA	0.54	Street suffix standardised Address re-cased ZIP missing Gender normalised+1 more
TPA-58971	TPA	Gloria Tran	1945-05-04	—	—	403 Lake View Rd, Tampa, FL	0.54	Name split from “Last, First”ZIP missing Gender normalised Whitespace trimmed+1 more
TPA-55069	TPA	Joshua Ramos	1952-07-04	—	—	1749 Broadway # 313, Minneapolis, MN	0.54	Name split from “Last, First”Unit split from street ZIP missing Whitespace trimmed+1 more

1,012 rows, page 6 of 21Previous Next