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 “Gender normalised”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagGender normalisedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-113904	ENR	Marcus Y Garcia	1994-04-08	UHC-38847-35	—	—	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-137096	ENR	Christian Z Carroll	1979-11-01	UHC-52814-08	4364853360	6134 Oak St, Nashville, TN, 37283	0.80	Name re-cased Date of birth reformatted Gender normalised Placeholder values cleared
ENR-106415	ENR	Virginia J Munoz	1964-08-23	UHC-21025-48	6556513146	4537 Oak St, Los Angeles, CA, 90018	0.80	Name re-cased Date of birth reformatted City re-cased Gender normalised
ENR-111351	ENR	Matthew O Day	1971-04-04	UHC-65445-38	2849282812	3392 Washington St, Nashville, TN, 37226	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-128327	ENR	Aisha Silva	1999-03-11	UHC-68482-80	9004801730	7275 Lincoln Way, Houston, TX, 77071	0.80	Phone reformatted City re-cased Gender normalised Whitespace trimmed
ENR-116309	ENR	Catherine Z Long	2007-09-16	UHC-07684-49	9346528446	2761 Jefferson Ave, Mesa, AZ, 85254	0.80	Phone reformatted State code upper-cased Gender normalised Placeholder values cleared
ENR-103721	ENR	Lawrence W Cunningham	1940-04-17	UHC-18224-74	7995619041	9533 Maple Ave, Atlanta, GA, 30328	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
ENR-108193	ENR	Michael Murphy	1979-09-25	UHC-74131-37	—	4048 Broadway, Chandler, AZ, 85251	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
ENR-130852	ENR	Jessica Elliott	2005-07-04	UHC-51147-59	7989824634	2452 Maple Ave, Tempe, AZ, 85284	0.80	Name re-cased Date of birth reformatted Phone reformatted Gender normalised
ENR-142145	ENR	Margaret M Stone	1939-12-20	UHC-82602-39	9749293907	854 River Rd, Phoenix, AZ, 85041	0.80	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed
ENR-122452	ENR	Yuki Rios	1979-11-21	UHC-04431-12	5425797223	2827 Central Ave, Orlando, FL, 32883	0.80	Name re-cased Phone reformatted City re-cased Gender normalised
ENR-142898	ENR	Bryan Walker	1961-01-12	UHC-36656-10	—	2491 Sunset Blvd, Tempe, AZ, 85272	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-121556	ENR	Danielle Ross	1997-05-10	UHC-36430-99	7348374218	—	0.80	Phone reformatted Email lower-cased Gender normalised Whitespace trimmed
ENR-101785	ENR	Ann S Harrison	1979-09-24	UHC-02311-94	2996817307	4916 Central Ave, Chandler, AZ, 85206	0.80	Phone reformatted Member ID reformatted Gender normalised Whitespace trimmed
ENR-111875	ENR	Grace Z Hill	1995-03-20	UHC-12202-06	5419545298	8723 Harbor Blvd, Plano, TX, 75086	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-122743	ENR	Jerry Adams	1969-04-08	UHC-89076-74	3582723830	5849 Maple Ave, Scottsdale, AZ, 85289	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-106683	ENR	Sean F Soto	1957-01-28	UHC-24426-72	8524303535	6854 Canyon Rd, Plano, TX, 75020	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-102127	ENR	Ruth V Hunter	1971-10-28	UHC-38317-03	4538313227	2293 Baseline Rd, Austin, TX, 78775	0.80	Name re-cased Phone reformatted Email lower-cased Gender normalised
ENR-101523	ENR	Anthony Gardner	2003-11-02	UHC-79973-15	—	2095 Oak St, Mesa, AZ, 85241	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-105370	ENR	Sean Allen	1993-09-14	UHC-37430-07	—	1226 Willow Ct, Los Angeles, CA, 90091	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
ENR-133980	ENR	Noah Z Riice	2006-10-16	UHC-32746-37	8516263340	7927 Church St, Columbus, OH, 43203	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-136765	ENR	Daniel N Vargas	1964-04-22	UHC-13090-50	5096385027	2461 Mesa Dr, Chandler, AZ, 85294	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-128425	ENR	Rachel D Howard	1965-12-02	UHC-36253-69	6202387880	—	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
ENR-139386	ENR	Lauren V Simpson	1939-11-23	UHC-98457-01	4334748240	7336 River Rd, Tucson, AZ, 85762	0.80	Name re-cased Date of birth reformatted Phone reformatted Gender normalised
ENR-105462	ENR	Eric Morrison	1974-02-26	UHC-70851-21	4052328483	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
ENR-104773	ENR	Carl C Hill	1994-10-06	UHC-13848-92	7799725256	2200 Bayshore Dr, Phoenix, AZ, 85010	0.80	Phone reformatted Email lower-cased Gender normalised Whitespace trimmed
ENR-109057	ENR	Charlotte Dominguez	1956-06-30	UHC-94279-14	8283025672	2235 Sunset Blvd, Sacramento, CA, 95856	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-101725	ENR	Madison Kim	1944-08-07	UHC-14696-90	2398916827	184 Indian School Rd, Minneapolis, MN, 55453	0.80	Name re-cased Member ID reformatted Gender normalised Whitespace trimmed
ENR-121717	ENR	Kelly L Morris	1974-05-20	UHC-85386-10	4962653075	5910 Camelback Rd, Austin, TX, 78719	0.80	Name re-cased Phone reformatted Email lower-cased Gender normalised
ENR-126591	ENR	Hannah Bryant	1981-07-09	UHC-40068-97	8762848176	8975 Bayshore Dr, San Diego, CA, 92173	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
ENR-110549	ENR	Philip C Castillo	1980-12-26	UHC-47239-24	4637222639	1405 Sage Ct, Tempe, AZ, 85225	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-107009	ENR	Victoria Lawson	1999-08-01	UHC-84803-60	4876562336	7779 Central Ave, Austin, TX, 78723	0.80	Name re-cased Date of birth reformatted Phone reformatted Gender normalised
ENR-128536	ENR	Wayne Lee	1949-01-02	UHC-57483-83	8754384567	6588 Sage Ct, Denver, CO, 80286	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
ENR-101896	ENR	Gerald Andrews	1957-01-24	UHC-92735-21	5137568274	7825 Meadow Ln, Atlanta, GA, 30381	0.80	City re-cased Email lower-cased Gender normalised Whitespace trimmed
ENR-101366	ENR	Stephanie U Haes	2007-10-20	UHC-72841-28	3116595826	403 Washington St, Houston, TX, 77013	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-135377	ENR	Catherine Wheeler	1952-10-07	UHC-48380-89	8033194021	3516 Harbor Blvd, Tampa, FL, 33696	0.80	Date of birth reformatted Gender normalised Plan code upper-cased Whitespace trimmed
ENR-127826	ENR	Jeeremy Sullivan	1981-10-18	UHC-15896-37	5239176767	5808 Camelback Rd, Columbus, OH, 43237	0.80	Phone reformatted State code upper-cased Gender normalised Whitespace trimmed
ENR-130476	ENR	Carol James	1953-11-16	UHC-44524-66	7807649703	7355 Main St, Charlotte, NC, 28254	0.80	Phone reformatted Email lower-cased Gender normalised Placeholder values cleared
ENR-142115	ENR	William Jordan	1990-02-22	UHC-70177-71	8013680090	1244 River Rd, Glendale, AZ, 85329	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-100796	ENR	Brandon R Bryant	1980-12-31	UHC-78047-95	9533400231	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
ENR-134889	ENR	Thereesa Perkins	1999-09-13	UHC-07303-70	4976370684	3310 Palm Dr, Dallas, TX, 75203	0.80	Name re-cased Phone reformatted Email lower-cased Gender normalised
ENR-140407	ENR	Martha S Contreras	1989-08-17	UHC-22276-22	9743544292	—	0.80	Name re-cased Date of birth reformatted Member ID reformatted Gender normalised
ENR-139953	ENR	Jacqueline M Henderson	1960-06-06	UHC-88501-18	5677662257	6545 Spring St, Fresno, CA, 93777	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-117647	ENR	Peter Weaver	1988-01-21	UHC-91738-96	6709798253	6620 Main St, Glendale, AZ, 85357	0.80	Phone reformatted City re-cased Gender normalised Whitespace trimmed
ENR-112004	ENR	Jacqueline F Jones	1952-04-15	UHC-47354-32	4894819297	390 Central Ave, Scottsdale, AZ, 85241	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-111521	ENR	George Z Guerrero	1954-03-15	UHC-05538-48	2855619555	5087 Union St, Eden Prairie, MN, 55314	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-134255	ENR	William Pierce	1995-12-23	UHC-68099-42	7153596595	9244 Cedar Ln, Sacramento, CA, 95827	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-108192	ENR	William Contreras	1984-05-25	UHC-31788-54	7746119428	1811 Valley View Dr, Miami, FL, 33166	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
ENR-138440	ENR	Kim T Reynolds	1958-05-25	UHC-85504-11	—	9123 Desert Sky Blvd, Minneapolis, MN, 55471	0.80	Name re-cased Email lower-cased Gender normalised Whitespace trimmed
ENR-118236	ENR	William Tran	1974-06-12	UHC-33437-18	4553916789	2839 Grand Ave, Plano, TX, 75032	0.80	Name re-cased Phone reformatted City re-cased Gender normalised

7,326 rows, page 133 of 147Previous Next