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 “Name re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagName re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-59454	TPA	William P Clark	1986-07-21	—	8369436892	—	0.96	Name re-cased Placeholder values cleared
TPA-64452	TPA	Sean Gardner	1976-11-13	—	—	6474 Main St, Atlanta, GA, 30303	0.96	Name re-cased Placeholder values cleared
TPA-54256	TPA	Charlotte Parker	1998-09-07	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-58267	TPA	Albert Walsh	1947-03-02	—	—	3120 Elm St, Chandler, AZ, 85298	0.96	Name re-cased Placeholder values cleared
TPA-51640	TPA	Ryan Rose	1964-12-20	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-63606	TPA	Linda Carpenter	1940-10-18	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-52095	TPA	Roy Q Bennett	1950-11-23	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-51777	TPA	Beverly Fuller	1941-08-02	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-51082	TPA	Jennifer A Baker	1957-02-01	—	—	5369 Lincoln Way, Columbus, OH, 43240	0.96	Name re-cased Placeholder values cleared
TPA-57160	TPA	Sandra Ortega	1980-12-26	—	—	7314 Hillcrest Rd, Tucson, AZ, 85779	0.96	Name re-cased Placeholder values cleared
TPA-52840	TPA	Brian Guerrero	2003-07-22	—	—	1517 Apache Blvd, Houston, TX, 77038	0.96	Name re-cased Placeholder values cleared
TPA-55520	TPA	Jacqueline West	1959-07-12	UHC-81934-17	—	—	0.96	Name re-cased Placeholder values cleared
TPA-52244	TPA	Carol W Fisher	1991-11-18	—	—	5545 Park Pl, Scottsdale, AZ, 85285	0.96	Name re-cased Placeholder values cleared
TPA-53765	TPA	Olivia Banks	1974-05-06	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-61866	TPA	Aaron Scott	1982-12-27	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-63979	TPA	Natalie P Bennett	1992-11-25	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-55287	TPA	Marria Z Hoffman	2004-02-01	—	4172852297	7344 Apache Blvd, Gilbert, AZ, 85295	0.96	Name re-cased Phone reformatted
TPA-56846	TPA	Camila Moore	2004-08-02	—	—	9833 Lake View Rd, Chandler, AZ, 85231	0.96	Name re-cased Placeholder values cleared
TPA-62047	TPA	Christine Valdez	1960-02-08	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-63222	TPA	Jerry Dean	1977-11-14	—	—	5719 Lincoln Way, Charlotte, NC, 28268	0.96	Name re-cased Placeholder values cleared
TPA-55999	TPA	Amber Dean	1961-02-19	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-63631	TPA	Scott Fowler	1905-02-03	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-56302	TPA	Adam Harper	1995-09-18	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-50978	TPA	Eric Barnes	1962-01-02	—	4925171926	—	0.96	Name re-cased Placeholder values cleared
TPA-62881	TPA	Lauren Brown	2002-02-20	—	—	4201 Lincoln Way, Glendale, AZ, 85315	0.96	Name re-cased Placeholder values cleared
TPA-57686	TPA	Logan Hanson	1963-03-14	—	2544081290	—	0.96	Name re-cased Placeholder values cleared
TPA-51642	TPA	Cherl Collins	1973-08-10	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-57010	TPA	Christian Carter	1964-06-17	—	—	2175 Spring St, Tucson, AZ, 85720	0.96	Name re-cased Placeholder values cleared
TPA-57011	TPA	Christian Carter	1964-06-17	—	—	2175 Spring St, Tucson, AZ, 85720	0.96	Name re-cased Placeholder values cleared
TPA-56711	TPA	Cynthia Chavez	1957-05-17	—	—	2401 Palm Dr, Columbus, OH, 43228	0.96	Name re-cased Placeholder values cleared
TPA-54508	TPA	Vincent Wilson	1948-08-22	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-54446	TPA	Theresa Diaz	1940-08-20	—	6303533211	—	0.96	Name re-cased Placeholder values cleared
TPA-57672	TPA	Emily Harris	1968-10-25	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-52844	TPA	Lara Ryan	1993-01-22	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-60133	TPA	Ben C Barnes	1943-11-28	UHC-74392-69	—	—	0.96	Name re-cased Placeholder values cleared
TPA-55195	TPA	Cynthia Maatthews	1985-07-10	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-58025	TPA	Ahmed I Adams	2001-12-06	—	—	3121 Union St, Las Vegas, NV, 89139	0.96	Name re-cased Placeholder values cleared
TPA-57548	TPA	Ashley Fields	1986-05-25	—	—	6344 Forest Ave, Jacksonville, FL, 32225	0.96	Name re-cased Placeholder values cleared
TPA-53123	TPA	Brenda Mills	1991-04-18	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-53124	TPA	Brenda Mills	1991-04-18	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-53391	TPA	Jennifer Martinez	1975-04-05	UHC-86220-05	—	3815 Highland Ave, Nashville, TN, 37279	0.96	Name re-cased Placeholder values cleared
TPA-58340	TPA	Beverly Matinez	1985-09-20	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-61525	TPA	Martha Snyder	1990-05-08	—	—	6526 Broadway, Plano, TX, 75074	0.96	Name re-cased Placeholder values cleared
TPA-56120	TPA	Christian F Owens	1962-06-09	—	—	1675 Sage Ct, Denver, CO, 80281	0.96	Name re-cased Placeholder values cleared
TPA-52239	TPA	Billy Duncan	1983-12-27	UHC-74793-36	—	—	0.96	Name re-cased Placeholder values cleared
TPA-59071	TPA	Mary Weber	1964-12-04	UHC-98691-21	6949401767	8305 Ocean Ave, Glendale, AZ, 85301	0.96	Name re-cased Placeholder values cleared
TPA-57103	TPA	Theresa Hawkins	2007-04-19	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-57104	TPA	Theresa Hawkins	2007-04-19	—	—	—	0.96	Name re-cased Placeholder values cleared
TPA-57183	TPA	Lrary Perez	1982-05-22	UHC-26253-85	3759861762	6800 Main St, Gilbert, AZ, 85233	0.98	Name re-cased
TPA-58865	TPA	Daniel Greene	2007-02-23	—	—	—	0.98	Name re-cased

5,750 rows, page 115 of 115Previous Next