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

Enrollment, flag “ZIP+4 trimmed”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP+4 trimmedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-130242	ENR	Mariana H Henderson	2002-03-27	UHC-04490-01	8248401156	3267 Broadway, Orlando, FL, 32884	0.80	Date of birth reformatted City re-cased ZIP+4 trimmed Whitespace trimmed
ENR-112516	ENR	Roy P Carroll	1970-10-11	UHC-05121-71	—	5560 Market St, Tempe, AZ, 85286	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-140243	ENR	Edward O Boyd	2003-11-09	UHC-44082-26	7173338374	8783 Willow Ct, San Diego, CA, 92123	0.80	Phone reformatted ZIP+4 trimmed Email lower-cased Whitespace trimmed
ENR-139470	ENR	Albert A Howell	1957-06-27	UHC-25153-40	6186460371	1373 Mountain View Dr, Miami, FL, 33198	0.80	Phone reformatted ZIP+4 trimmed Plan code upper-cased Whitespace trimmed
ENR-108602	ENR	Gerald P Lopez	2004-11-18	UHC-58085-71	3779268670	3691 Jefferson Ave, Jacksonville, FL, 32288	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-124542	ENR	Kim Q Kelly	1984-07-09	UHC-14965-69	5816632495	2592 Grand Ave, Atlanta, GA, 30326	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-141303	ENR	Terry Y Gray	1993-06-01	UHC-48983-58	4454079832	406 Grand Ave, Los Angeles, CA, 90019	0.80	Phone reformatted ZIP+4 trimmed Email lower-cased Whitespace trimmed
ENR-140258	ENR	Maria Alexander	1979-05-05	UHC-74312-70	5858634578	7164 Camelback Rd, Houston, TX, 77037	0.80	Phone reformatted Member ID reformatted ZIP+4 trimmed Whitespace trimmed
ENR-134908	ENR	Bevarly Morris	1960-03-26	UHC-42035-49	4229718925	502 Mesa Dr, Mesa, AZ, 85220	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-136368	ENR	Emily X Obrien	1941-06-06	UHC-64936-31	6845830935	1389 Lincoln Way, Atlanta, GA, 30392	0.80	Name re-cased Date of birth reformatted City re-cased ZIP+4 trimmed
ENR-126764	ENR	Douglas Allen	1953-09-02	UHC-14793-72	7317235113	3383 Meadow Ln, San Antonio, TX, 78245	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-116737	ENR	Hiroshi X Dunn	1991-12-08	UHC-40843-84	—	3236 Market St, Atlanta, GA, 30373	0.80	ZIP+4 trimmed Email lower-cased Whitespace trimmed Placeholder values cleared
ENR-111747	ENR	Mracus Olson	1944-02-07	UHC-01972-95	2926430177	2745 Broadway, Dallas, TX, 75202	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-111918	ENR	Amanda B Hason	1950-08-17	UHC-77297-50	9585075580	1274 Apache Blvd, Phoenix, AZ, 85068	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-114970	ENR	Jdy Miller	1994-05-09	UHC-09658-23	5378318756	9313 River Rd, Tampa, FL, 33660	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-119404	ENR	Lucia P Padilla	1976-10-15	UHC-86094-50	2872020051	1425 Broadway, Gilbert, AZ, 85229	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-104285	ENR	Diego Willis	1976-12-04	UHC-87330-63	3998853867	5065 Ocean Ave, Chandler, AZ, 85274	0.82	Name re-cased City re-cased ZIP+4 trimmed
ENR-107553	ENR	Sara R Santos	1974-01-28	UHC-39856-07	3576252802	3763 Broadway, Los Angeles, CA, 90091	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-130189	ENR	Hannah R Santos	1999-07-04	UHC-76256-41	6293963219	6379 Camelback Rd, Eden Prairie, MN, 55382	0.82	ZIP+4 trimmed Email lower-cased Placeholder values cleared
ENR-136850	ENR	Barbara W Knight	1964-05-08	UHC-15726-60	4469167701	2181 Harbor Blvd, Fresno, CA, 93760	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
ENR-132238	ENR	Ann Berry	2003-05-28	UHC-79552-37	5994548114	7288 Broadway, Eden Prairie, MN, 55364	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-101134	ENR	Bruce Evans	1996-03-05	UHC-53530-21	3156012190	5968 River Rd, Austin, TX, 78749	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-128916	ENR	Soto W Nicole	1997-03-04	UHC-13755-91	8676571276	7646 Lincoln Way, Minneapolis, MN, 55478	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-125713	ENR	Marcus K Banks	1986-08-14	UHC-82234-18	6522931767	6292 Mesa Dr, Plano, TX, 75055	0.82	Phone reformatted Member ID reformatted ZIP+4 trimmed
ENR-106097	ENR	Luis Torres	2003-12-09	UHC-28329-05	6293903873	4391 Palm Dr, Scottsdale, AZ, 85203	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
ENR-128074	ENR	Gloria C Watkins	1998-11-22	UHC-68547-42	9334284680	572 Bayshore Dr, Plano, TX, 75018	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
ENR-103986	ENR	Lawrence Lawson	1947-11-27	UHC-89452-36	5579213346	3465 Park Pl, Phoenix, AZ, 85011	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-139646	ENR	Virginia Hansen	1944-07-06	UHC-14278-08	8386718672	3692 Sunset Blvd, Jacksonville, FL, 32220	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-141255	ENR	Victoria Clark	1992-04-16	UHC-78240-28	—	5078 Forest Ave, Mesa, AZ, 85297	0.82	Name re-cased Member ID reformatted ZIP+4 trimmed
ENR-106278	ENR	Eric Ross	1989-03-20	UHC-65059-83	3503746694	2705 Broadway, Gilbert, AZ, 85237	0.82	Phone reformatted ZIP+4 trimmed Plan code upper-cased
ENR-129605	ENR	Charles Z Boyd	1950-09-14	UHC-87605-29	8107142846	2449 Ocean Ave, Gilbert, AZ, 85239	0.82	City re-cased ZIP+4 trimmed Email lower-cased
ENR-130917	ENR	Anthony P Median	1995-02-12	UHC-86103-32	8203975478	7982 Park Pl, Orlando, FL, 32864	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-130918	ENR	Anthony P Median	1995-02-12	UHC-86103-32	8203975478	7982 Park Pl, Orlando, FL, 32864	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-122080	ENR	Brandon W Hawkins	1968-06-07	UHC-66347-19	6984350617	140 Sunset Blvd, Plano, TX, 75062	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-129437	ENR	Diana E Cooper	1992-02-21	UHC-93659-24	8206167600	855 Pine Dr, Phoenix, AZ, 85047	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-123023	ENR	Amber P Ortega	1979-12-23	UHC-28858-52	7248751916	8545 Indian School Rd, Houston, TX, 77009	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-108114	ENR	Nick Harrison	1986-01-22	UHC-96747-20	5779084010	8587 Maple Ave, Dallas, TX, 75262	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-108555	ENR	Melissa Q Montgomery	1985-02-11	UHC-72768-33	3985284849	1611 Spring St, Plano, TX, 75087	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-109665	ENR	Richard T Lane	1956-07-03	UHC-34857-88	7005603653	5690 Broadway, Charlotte, NC, 28284	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-135859	ENR	Sophia G Rivera	1983-06-15	UHC-90624-07	6449329611	8091 Broadway, Gilbert, AZ, 85228	0.82	Phone reformatted ZIP+4 trimmed Email lower-cased
ENR-124380	ENR	Steven Bowman	1941-09-01	UHC-95679-56	7422010209	8216 Cedar Ln, Orlando, FL, 32899	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-105009	ENR	Julie Rojas	1988-10-15	UHC-33111-45	7367694309	296 Mesa Dr, Glendale, AZ, 85315	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-128592	ENR	Samantha N Wilson	1974-09-22	—	5017956420	521 Oak St, Orlando, FL, 32853	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-118749	ENR	Alexander P Phillips	1976-08-11	UHC-65809-64	—	6581 Harbor Blvd, Sacramento, CA, 95892	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
ENR-140324	ENR	Juan Graham	1961-07-16	UHC-34448-76	7589372325	6536 Park Pl, Fresno, CA, 93794	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-127105	ENR	Angela Fields	2007-09-01	UHC-07706-58	9873574399	6230 Central Ave, San Antonio, TX, 78229	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
ENR-138968	ENR	Charles Hunter	2000-04-06	UHC-06446-40	—	1395 Main St, Phoenix, AZ, 85063	0.82	Member ID reformatted ZIP+4 trimmed Placeholder values cleared
ENR-119345	ENR	Cynthia Green	1979-06-21	UHC-66762-67	2258551299	1316 Jefferson Ave, Orlando, FL, 32883	0.82	Phone reformatted Member ID reformatted ZIP+4 trimmed
ENR-108692	ENR	Christina Morales	1947-07-03	UHC-53202-71	7178285395	7231 Broadway, Jacksonville, FL, 32255	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-126962	ENR	Abigail U Peters	2003-10-20	UHC-38914-38	4145309293	8838 Elm St, Atlanta, GA, 30373	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed

3,951 rows, page 75 of 80Previous Next