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

All sources, flag “Member ID reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagMember ID reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-411090	CLM	Lori Hawkins	1990-02-28	UHC-55156-14	4402943107	590 Meadow Ln, Tempe, AZ, 85211	0.74	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
PRV-26123	PRV	Kathleen Castillo	1998-11-21	UHC-90571-84	4122381597	3704 Sage Ct, Dallas, TX, 75249	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-420394	CLM	Brittany Nichols	1984-08-18	UHC-42580-56	6863678202	4311 Sage Ct, Eden Prairie, MN, 55357	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-127877	ENR	Susan Z Ellis	2007-01-09	UHC-65143-38	8923009983	1896 Indian School Rd, Seattle, WA, 98134	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-114260	ENR	Brenda D Rojas	1985-06-14	UHC-14306-22	5556592334	1484 Grand Ave, Chandler, AZ, 85228	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-102970	ENR	Noah Z Cox	1963-08-03	UHC-36111-12	2144891117	1809 Grand Ave, Los Angeles, CA, 90070	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
PRV-25108	PRV	Matthew Dunn	2008-11-24	UHC-78000-28	7806051992	2604 Ocean Ave, Tempe, AZ, 85282	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
ENR-106701	ENR	Justin Wong	1960-01-10	UHC-66794-56	5583050718	4253 Forest Ave, Tucson, AZ, 85741	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
ENR-127394	ENR	Jean N Espinoza	1942-05-24	UHC-17253-37	4893141789	3118 Jefferson Ave, Jacksonville, FL, 32261	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-125982	ENR	Kathryn C Day	1982-11-24	UHC-37330-92	4948845985	9600 Ridge Rd, Phoenix, AZ, 85081	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-131336	ENR	Sean P Sullivan	2008-04-20	UHC-26474-94	6269614484	2118 Oak St, Sacramento, CA, 95856	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-413224	CLM	Harold K Matthews	1978-02-24	UHC-67154-41	3305268321	176 Union St, Mesa, AZ, 85278	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-136335	ENR	Danielle J Hoffman	—	UHC-71342-86	5836526880	4187 Highland Ave, Los Angeles, CA, 90098	0.74	Name re-cased Date of birth reformatted Date of birth unreadable Phone reformatted+3 more
PRV-26124	PRV	Fatima Kelly	1973-06-10	UHC-76176-65	8454184269	4014 Jefferson Ave, Mesa, AZ, 85237	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-423243	CLM	Kyle Harper	1997-08-03	UHC-68942-57	2679801331	1435 Jefferson Ave, Gilbert, AZ, 85294	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-141218	ENR	Nicholas K Lawson	1948-07-21	UHC-59884-20	3693317859	3333 Union St, Denver, CO, 80252	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
CLM-425366	CLM	Janet Davis	1974-06-07	UHC-23902-55	9444432708	—	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
ENR-114521	ENR	Barbara R Espinoza	2001-10-25	UHC-95188-55	3637567177	4396 Valley View Dr, Tempe, AZ, 85224	0.74	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-113863	ENR	Beverly A Hernandez	1994-10-20	UHC-61868-50	3006338302	1804 Spring St, Atlanta, GA, 30334	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-418386	CLM	Sean Jordan	1968-11-12	UHC-98220-61	3269638291	6969 Canyon Rd, Jacksonville, FL, 32234	0.74	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
CLM-410263	CLM	Shirley E Phillips	1962-01-13	UHC-09624-69	4425085432	994 Jefferson Ave, Charlotte, NC, 28260	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-104093	ENR	Diana Tran	1972-04-06	UHC-97796-42	4294840474	8732 Broadway, Tucson, AZ, 85728	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
ENR-105411	ENR	Tim Armstrong	2004-03-19	UHC-94717-18	3165825812	5094 Willow Ct, Eden Prairie, MN, 55306	0.74	Date of birth reformatted Phone reformatted Member ID reformatted City re-cased+3 more
ENR-122811	ENR	Virignia Z Smith	1956-09-14	UHC-04753-63	2396118440	7807 Canyon Rd, Tempe, AZ, 85267	0.74	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-107217	ENR	Shirley P Estrada	1982-10-07	UHC-30222-74	2714414326	1380 Mountain View Dr, Tempe, AZ, 85202	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
TPA-51280	TPA	Virgginia F Delgado	1962-04-03	UHC-25625-24	5676392000	8879 Ocean Ave, Denver, CO, 80215	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-118072	ENR	Martha Henderson	2000-08-23	UHC-36844-45	6579638520	6304 Union St, Mesa, AZ, 85280	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
CLM-400366	CLM	Aisha Martinez	1982-02-27	UHC-74899-52	7212464143	6467 Broadway, Orlando, FL, 32886	0.74	Name re-cased Phone reformatted Member ID reformatted Address re-cased+3 more
CLM-403464	CLM	Noah Burke	2002-02-16	UHC-77481-12	—	7480 Jefferson Ave, Charlotte, NC, 28240	0.74	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
TPA-58193	TPA	Sean Adams	1968-12-24	UHC-01130-29	8357626925	6127 Indian School Rd, Los Angeles, CA, 90001	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
PRV-28637	PRV	Chistina Garcia	1969-02-11	UHC-73700-75	4336748812	7938 Church St, Houston, TX, 77017	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-119812	ENR	Carolyn J Bennett	1962-07-28	UHC-05367-86	—	4016 Baseline Rd, Jacksonville, FL, 32221	0.74	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-114431	ENR	Ralph M Sanchez	1964-04-07	UHC-99572-29	4734907828	8962 Palm Dr, Dallas, TX, 75257	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-432687	CLM	Ralph Fisher	1941-07-02	UHC-50500-74	2418801879	9548 Harbor Blvd, Miami, FL, 33126	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-403043	CLM	Brittany Kim	1958-12-16	UHC-44063-25	—	6440 Central Ave, Houston, TX, 77010	0.74	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+3 more
PRV-21572	PRV	Sara Patel	2002-03-22	UHC-48728-33	7678398428	1780 Baseline Rd, Tucson, AZ, 85768	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-423487	CLM	Mary Patel	1985-08-12	UHC-02629-56	5106015184	—	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
CLM-423488	CLM	Mary Patel	1985-08-12	UHC-02629-56	5106015184	—	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
ENR-114918	ENR	Heather Carr	1962-11-20	UHC-85036-04	8508041045	3873 Mesa Dr, Scottsdale, AZ, 85220	0.74	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-116360	ENR	Bobby U Watson	1997-02-10	UHC-36535-02	9432048692	9708 Palm Dr, Tampa, FL, 33656	0.74	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-106216	ENR	Philip Hoffman	1984-12-08	UHC-68347-54	7052103097	3090 Apache Blvd, San Diego, CA	0.74	Name re-cased Phone reformatted Member ID reformatted City re-cased+3 more
CLM-416232	CLM	Amanda Washington	2000-07-01	UHC-98242-34	7737883172	2909 Spring St, Charlotte, NC, 28257	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-420829	CLM	Paul Butler	1962-03-16	UHC-87262-31	—	528 Mesa Dr, Seattle, WA, 98195	0.74	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
ENR-103008	ENR	Jesse West	1984-05-23	UHC-97270-70	8635111474	5622 Highland Ave, Scottsdale, AZ, 85271	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-133896	ENR	Janet P Padilla	1974-06-13	UHC-27801-36	9404981769	5221 Washington St, Scottsdale, AZ, 85228	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-132649	ENR	Olivia King	1954-02-21	UHC-33741-51	4013725209	6000 Cedar Ln, Scottsdale, AZ, 85281	0.74	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-110151	ENR	Frank W Murphy	1972-06-08	UHC-42751-19	6369324119	6085 Grand Ave, Fresno, CA, 93706	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-408158	CLM	Kyle Jackson	1990-08-01	UHC-39947-84	2286516130	8941 Church St, Scottsdale, AZ, 85234	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
PRV-20408	PRV	Joe Y Reid	1960-07-03	UHC-26803-21	7926307434	8020 Sunset Blvd, Seattle, WA, 98118	0.74	Name re-cased Phone reformatted Member ID reformatted City re-cased+3 more
ENR-109179	ENR	Brian B Hawkins	1994-07-27	UHC-14140-52	7076109197	6391 Mesa Dr, Houston, TX, 77049	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more

7,723 rows, page 73 of 155Previous Next