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 “Date of birth reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagDate of birth reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-51446	TPA	Evelyn Delgado	1939-08-07	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-53763	TPA	Carlos Tayor	1960-11-05	UHC-54687-87	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-63455	TPA	Evelyn Richardson	1945-01-07	—	—	5570 Maple Ave, Orlando, FL, 32877	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-62322	TPA	Mary Herrear	1973-03-20	UHC-96852-32	—	7943 Palm Dr, Houston, TX, 77040	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-64051	TPA	Austin Williamson	1965-02-11	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-56896	TPA	Brian Reed	1964-12-08	—	—	586 Ocean Ave, Dallas, TX, 75209	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-61277	TPA	Thomas Hansen	1944-03-03	—	—	1327 Union St, Tampa, FL, 33680	0.94	Date of birth reformatted City re-cased Placeholder values cleared
TPA-53630	TPA	Alan A Wilson	2000-03-06	—	—	9375 Camelback Rd, Columbus, OH, 43279	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-55138	TPA	Catherine Harvey	1960-07-11	—	—	5638 Indian School Rd, Orlando, FL, 32831	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-51623	TPA	Bruce Mills	1956-05-02	—	—	3929 Elm St, Scottsdale, AZ, 85217	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-53244	TPA	Henry Chhen	1969-10-15	—	—	7153 Indian School Rd, Houston, TX, 77027	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-51715	TPA	Brittany Maldonado	1961-07-22	—	—	9764 Union St, Seattle, WA, 98117	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-59282	TPA	Stephen Elliott	1993-12-09	UHC-16349-63	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-53346	TPA	Tyler Ellis	1964-06-11	—	—	9799 Maple Ave, Las Vegas, NV, 89140	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-59127	TPA	Angela Cle	1959-05-24	—	—	8885 Lincoln Way, Las Vegas, NV, 89158	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-63123	TPA	Robret Brooks	1999-02-24	—	5805595575	5314 Palm Dr, Fresno, CA, 93722	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-58299	TPA	Anthony Taylor	2004-02-11	UHC-75125-22	—	1177 Sage Ct, San Antonio, TX, 78208	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-62437	TPA	Virginia Scott	2005-05-02	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-61319	TPA	Madison Rse	1966-11-16	—	3446203431	3811 Bayshore Dr, Scottsdale, AZ, 85291	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-59869	TPA	Donald Amstrong	1956-03-18	—	—	3391 Lincoln Way, Glendale, AZ, 85380	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-55885	TPA	Lauren Grant	2004-10-28	—	8502877272	7880 Ridge Rd, Miami, FL, 33125	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
TPA-51190	TPA	Gary B Martin	1975-05-19	—	—	8737 Main St, Denver, CO, 80251	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-54109	TPA	Douglas Robinson	1974-11-27	—	—	9031 Apache Blvd, Nashville, TN, 37242	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-55724	TPA	Roger Holmes	1978-08-03	—	—	289 Grand Ave, Los Angeles, CA, 90087	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-57652	TPA	Alan Diaz	1958-03-13	—	—	2159 Mesa Dr, Austin, TX, 78732	0.94	Date of birth reformatted City re-cased Placeholder values cleared
TPA-60424	TPA	Donna Owens	1956-08-12	—	2574381946	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
TPA-63701	TPA	Fatima I Price	1945-11-18	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-50972	TPA	Abigail Snyder	1997-05-24	—	—	—	0.94	Date of birth reformatted Email lower-cased Placeholder values cleared
TPA-56251	TPA	Henry P Foster	1990-02-24	—	2919267600	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-50417	TPA	Barb Ryen	1964-05-01	—	—	6299 Sunset Blvd, San Diego, CA, 92148	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-56804	TPA	Maria J Vazquez	1954-10-10	—	2385506675	891 Canyon Rd, Los Angeles, CA, 90042	0.94	Date of birth reformatted City re-cased Placeholder values cleared
TPA-53164	TPA	Carlos L Montgomery	1956-05-18	—	—	9412 Broadway, Austin, TX, 78724	0.94	Date of birth reformatted City re-cased Placeholder values cleared
TPA-62144	TPA	Emily Dunncan	1995-02-28	—	3099604838	9117 Harbor Blvd, Sacramento, CA, 95818	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
TPA-53611	TPA	Isabella Fernandez	1972-07-11	—	—	4521 Jefferson Ave, Orlando, FL, 32843	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-53802	TPA	Janice Burton	1955-04-03	—	—	5988 Baseline Rd, Seattle, WA, 98179	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-61801	TPA	Mateo Lee	1944-02-24	—	—	9241 Baseline Rd, Seattle, WA, 98157	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-61040	TPA	Mark Hughes	1941-03-17	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-51238	TPA	Nicole Pierce	2003-05-18	—	—	5141 Market St, Austin, TX, 78769	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-50160	TPA	Ethan Burton	1962-07-06	—	7365372560	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-62044	TPA	Maria Stewart	2006-12-26	—	—	9251 Pine Dr, Eden Prairie, MN, 55398	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-62909	TPA	Lisa Taylor	1983-09-14	UHC-20686-86	2418473837	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-61771	TPA	Kayla Gomez	2007-10-28	UHC-51906-01	9705218394	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-52549	TPA	Luis Chen	1973-04-19	—	5054308468	6380 Maple Ave, Minneapolis, MN, 55461	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-63173	TPA	Gabriel Schmidt	1950-09-05	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-54290	TPA	Amy Kennedy	1947-06-19	UHC-82897-98	6655382478	2061 Canyon Rd, Atlanta, GA, 30382	0.94	Date of birth reformatted Email lower-cased Placeholder values cleared
TPA-51224	TPA	Olivia Chpman	1975-01-18	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-53982	TPA	Gregory Wheeler	1989-03-15	—	4629891783	8819 Camelback Rd, Mesa, AZ, 85269	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-50671	TPA	Santiago Ford	1994-12-11	—	—	179 Apache Blvd, Tucson, AZ, 85720	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-62045	TPA	Harold N Blck	1953-02-20	—	7536522416	1814 Lincoln Way, San Diego, CA, 92187	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
TPA-53286	TPA	Mateo Henry	1970-07-04	UHC-87661-26	4738412596	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared

4,728 rows, page 91 of 95Previous Next