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-115240	ENR	Rose E Eric	1970-06-16	UHC-00335-66	—	3527 Ocean Ave, Columbus, OH, 43202	0.80	Name re-cased Date of birth reformatted Gender normalised Placeholder values cleared
ENR-115075	ENR	Mari Z Arnold	1981-01-23	—	—	1595 Broadway, Miami, FL, 33188	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-110717	ENR	Mark H Garrrett	1972-10-28	UHC-65212-09	8685440164	3400 Ocean Ave, Gilbert, AZ, 85268	0.80	Date of birth reformatted Phone reformatted City re-cased Gender normalised
ENR-111520	ENR	Carl Q Willis	1946-06-26	UHC-20138-67	2382258133	3585 Desert Sky Blvd, Austin, TX, 78750	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-142129	ENR	Wei Marshall	1967-12-26	UHC-53955-09	8256521422	1183 Oak St, Seattle, WA, 98174	0.80	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed
ENR-124785	ENR	Jose Richards	1995-02-10	UHC-95582-35	7559058342	2591 Ocean Ave, Los Angeles, CA, 90066	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-110794	ENR	Abby V Woods	1967-06-22	UHC-93294-76	5362855879	8938 Camelback Rd, Jacksonville, FL, 32262	0.80	Name re-cased Member ID reformatted Gender normalised Whitespace trimmed
ENR-134383	ENR	Jordan Obrien	1969-11-25	UHC-60353-68	3227556321	8573 Willow Ct, Miami, FL, 33126	0.80	Name re-cased Phone reformatted Email lower-cased Gender normalised
ENR-103730	ENR	Virginia W Singh	1987-05-07	UHC-51745-25	6436022639	7667 Jefferson Ave, Tampa, FL, 33639	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-127887	ENR	Mari P Luna	1998-08-15	UHC-89693-76	4407334607	801 Indian School Rd, Glendale, AZ, 85332	0.80	Date of birth reformatted Phone reformatted Member ID reformatted Gender normalised
ENR-137608	ENR	Eric C Ryan	1942-11-12	UHC-58529-87	5012235874	726 Spring St, Fresno, CA, 93761	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-132038	ENR	Joe Owens	1949-05-26	UHC-88512-73	8519951077	5646 Sage Ct, Miami, FL, 33132	0.80	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed
ENR-117863	ENR	Timothy Dixon	1951-11-17	UHC-54331-87	4456310971	1368 Ridge Rd, Plano, TX, 75078	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-132896	ENR	Henry A Ruiz	1973-01-02	UHC-65473-87	8145226501	662 Willow Ct, Las Vegas, NV, 89154	0.80	Phone reformatted City re-cased Gender normalised Whitespace trimmed
ENR-116580	ENR	Kathleen Knight	1965-05-09	UHC-76468-25	2685902071	3964 Highland Ave, San Antonio, TX, 78239	0.80	Name re-cased Phone reformatted Email lower-cased Gender normalised
ENR-132847	ENR	Jack E Boyd	1984-07-26	UHC-29529-01	5403831398	2902 Valley View Dr, Austin, TX, 78732	0.80	Name re-cased Date of birth reformatted Phone reformatted Gender normalised
ENR-115923	ENR	Roy R Bowman	1951-07-07	UHC-76053-45	6592891954	1638 Pine Dr, Eden Prairie, MN, 55364	0.80	Date of birth reformatted Phone reformatted Email lower-cased Gender normalised
ENR-120556	ENR	Steven Mendoza	1954-08-20	UHC-36413-04	8496334172	9881 Market St, Mesa, AZ, 85294	0.80	Name re-cased City re-cased Gender normalised Placeholder values cleared
ENR-141189	ENR	Adam E Carroll	1971-03-14	UHC-50284-55	4687552486	3751 Camelback Rd, Tempe, AZ, 85261	0.80	Name re-cased Member ID reformatted Email lower-cased Gender normalised
ENR-134516	ENR	Carolyn J Wilson	1964-04-24	UHC-81583-75	4756896287	2570 Valley View Dr, Jacksonville, FL, 32243	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-107263	ENR	Joseph Duncan	1980-02-18	UHC-84016-25	9069646968	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-104000	ENR	Virginia Hamilton	1941-05-23	UHC-58071-15	—	2821 Ridge Rd, Seattle, WA, 98181	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-117100	ENR	Brittany Lucas	2000-03-27	UHC-42291-53	5408483129	1258 Park Pl, Plano, TX, 75017	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-107337	ENR	Hiroshi L Espinoza	1970-07-02	UHC-80972-01	5692583125	689 Pine Dr, San Diego, CA, 92117	0.80	Phone reformatted City re-cased Gender normalised Whitespace trimmed
ENR-117162	ENR	Natalie C Moore	1940-10-09	UHC-66648-36	6642066413	4797 Cedar Ln, Glendale, AZ, 85322	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-111710	ENR	Jerry C Crawford	1980-07-03	UHC-60376-73	9117180729	7106 Jefferson Ave, Jacksonville, FL, 32219	0.80	Name re-cased Date of birth reformatted Email lower-cased Gender normalised
ENR-100125	ENR	Abigail Kelly	1969-03-28	UHC-36444-82	—	—	0.80	Date of birth reformatted Member ID reformatted Gender normalised Placeholder values cleared
ENR-143014	ENR	Randy G Nunez	1967-12-19	UHC-82685-52	4592068764	4792 Hillcrest Rd, Phoenix, AZ, 85083	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-107487	ENR	Kim B Cole	1966-09-28	UHC-48269-67	5627526373	5001 Spring St, Glendale, AZ, 85345	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-108525	ENR	Luis Reed	1944-04-24	UHC-97310-50	—	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
ENR-103500	ENR	Kayla H Wells	1985-07-02	UHC-51813-94	2699514602	16 Forest Ave, Glendale, AZ, 85362	0.80	Phone reformatted City re-cased State code upper-cased Gender normalised
ENR-109590	ENR	Luis Jenkins	1996-12-09	UHC-40275-08	6677921761	5391 Indian School Rd, Columbus, OH, 43290	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-124516	ENR	Abigail C Harrison	1961-11-20	UHC-44752-52	6675789859	8701 River Rd, Houston, TX, 77026	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-118532	ENR	Karen N Welch	1955-01-05	UHC-51273-02	5568119896	5842 Washington St, Plano, TX, 75096	0.80	Name re-cased Date of birth reformatted Phone reformatted Gender normalised
ENR-119380	ENR	Judy Castro	1984-02-12	UHC-14119-09	2538618240	8470 Church St, Plano, TX, 75003	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-139423	ENR	Patrick U Hayes	1989-06-27	UHC-62613-40	9055286223	5129 Grand Ave, Orlando, FL, 32818	0.80	Name re-cased Phone reformatted City re-cased Gender normalised
ENR-116571	ENR	Nicole Y Hansen	2005-01-11	UHC-71879-24	6615507816	2192 Main St, San Antonio, TX, 78292	0.80	Phone reformatted Email lower-cased Gender normalised Whitespace trimmed
ENR-114958	ENR	Peter P Edwards	1948-09-12	UHC-22840-88	3774316210	6925 Pine Dr, Mesa, AZ, 85257	0.80	Phone reformatted City re-cased Gender normalised Placeholder values cleared
ENR-110784	ENR	Joyce B Montgomery	2004-11-13	UHC-31352-78	8813719477	4774 Baseline Rd, Orlando, FL, 32825	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-112505	ENR	Michael Luna	2003-11-16	UHC-17376-90	5522820674	1256 Broadway, Atlanta, GA, 30306	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-136095	ENR	Ronald Moreno	1997-04-28	UHC-09827-65	4496825674	9184 Bayshore Dr, Tempe, AZ, 85250	0.80	Name re-cased Phone reformatted Email lower-cased Gender normalised
ENR-117655	ENR	Grace Stephens	1970-07-10	UHC-10537-78	4736017500	8937 Apache Blvd, Seattle, WA, 98189	0.80	Phone reformatted Member ID reformatted Gender normalised Whitespace trimmed
ENR-119388	ENR	Shirley Alvarez	1957-10-21	UHC-17061-12	3066957737	9302 Pine Dr, Columbus, OH, 43204	0.80	Name re-cased Date of birth reformatted Phone reformatted Gender normalised
ENR-139644	ENR	Mark Garrett	2002-03-09	UHC-96165-68	2764224442	4341 Valley View Dr, Los Angeles, CA, 90099	0.80	Name re-cased Phone reformatted City re-cased Gender normalised
ENR-100849	ENR	Donna Garza	1972-02-09	UHC-39214-12	8753701654	6852 Church St, Minneapolis, MN, 55448	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
ENR-141498	ENR	Judy J Vargas	2004-04-11	UHC-30234-88	9565340812	3483 Washington St, Houston, TX, 77058	0.80	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed
ENR-110031	ENR	Abigail Herrera	2007-08-01	UHC-30685-36	5625269774	6743 Central Ave, Las Vegas, NV, 89114	0.80	Date of birth reformatted Email lower-cased Gender normalised Whitespace trimmed
ENR-112537	ENR	Larson Jen	1989-06-21	UHC-10361-83	2655330194	4725 Elm St, Phoenix, AZ, 85048	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
ENR-105627	ENR	Jacob V Patel	2006-12-19	UHC-00417-59	3114025690	—	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-132913	ENR	Keith A Perez	1944-10-15	UHC-42466-08	—	—	0.80	Email lower-cased Gender normalised Whitespace trimmed Placeholder values cleared

7,326 rows, page 135 of 147Previous Next