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 “ZIP missing”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP missingClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-423167	CLM	Karen Reynolds	1987-01-01	UHC-41791-25	—	1102 Jefferson Ave, Fresno, CA	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
ENR-127209	ENR	Contreras G Henry	1982-11-16	UHC-97667-25	2215611815	4613 River Rd, Columbus, OH	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
CLM-425470	CLM	Steven Ramos	1969-01-26	—	7312929098	1184 Hillcrest Rd, Sacramento, CA	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted ZIP missing+1 more
CLM-410334	CLM	Abigail Y Martinez	1967-03-08	UHC-84886-97	—	2815 River Rd, Mesa, AZ	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
ENR-100257	ENR	Harris Y Lori	1998-03-20	UHC-92874-30	3394389721	7790 Washington St, Fresno, CA	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-125055	ENR	Maria Castillo	1952-04-26	UHC-23081-93	2489942114	9239 Elm St, Eden Prairie, MN	0.66	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
ENR-125054	ENR	Maria Castillo	1952-04-26	UHC-23081-93	2489942114	9239 Elm St, Eden Prairie, MN	0.66	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
TPA-63679	TPA	Kathryn Z Vasquez	1960-12-12	UHC-42036-52	—	9460 Sunset Blvd, San Antonio, TX	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
TPA-56431	TPA	Henry Pierce	2006-12-27	—	—	1170 Camelback Rd, Jacksonville, FL	0.66	Street suffix standardised Address re-cased State code upper-cased ZIP missing+1 more
ENR-121757	ENR	Jack Bowman	1940-04-17	UHC-69037-54	3062909753	8293 Washington St, Gilbert, AZ	0.66	Date of birth reformatted Phone reformatted ZIP missing Email lower-cased+1 more
CLM-431835	CLM	Ryen R Butler	2000-07-04	UHC-03130-93	3875605862	8043 River Rd, Tucson, AZ	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
CLM-424843	CLM	John Bell	1957-01-01	UHC-95187-29	3195396419	8461 Union St, Los Angeles, CA	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
CLM-416964	CLM	Shirley Q Wag	1946-08-25	—	—	9684 Ridge Rd, Mesa, AZ	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
CLM-412390	CLM	Jack Russell	1972-04-12	—	—	7332 Church St, Seattle, WA	0.66	Street suffix standardised Address re-cased City re-cased ZIP missing+1 more
ENR-136086	ENR	Margaret Butler	1944-11-25	UHC-48996-47	—	4150 Ridge Rd, Eden Prairie, MN	0.66	Date of birth reformatted Phone missing area code City re-cased ZIP missing+1 more
CLM-408834	CLM	Rebecca Roberts	1981-03-07	UHC-71907-16	8424824889	7830 Camelback Rd, Glendale, AZ	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
ENR-108458	ENR	Aaron F Kelley	1972-04-19	UHC-36205-79	—	909 Forest Ave, Glendale, AZ	0.66	Name split from “Last, First”City re-cased ZIP missing Whitespace trimmed+1 more
PRV-21457	PRV	Santiago Torres	—	—	2596244074	5968 Park Pl, Tucson, AZ	0.66	Date of birth unreadable Phone reformatted ZIP missing Whitespace trimmed+1 more
PRV-26754	PRV	Diane Hunt	1974-07-11	—	—	772 Bayshore Dr, Austin, TX	0.66	Date of birth reformatted Phone missing area code ZIP missing Whitespace trimmed+1 more
ENR-121899	ENR	Debra Wilson	1992-06-22	UHC-67369-44	8284136982	3651 Maple Ave, Denver, CO	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
ENR-111565	ENR	Linda B Wang	1951-03-02	UHC-62194-36	5513530861	4440 Broadway, Austin, TX	0.66	Address re-cased City re-cased ZIP missing Email lower-cased+1 more
CLM-432099	CLM	Rachel O Vazquez	1983-01-11	—	3859729498	7668 Central Ave, Atlanta, GA	0.66	Middle initial moved out of first name Name re-cased City re-cased ZIP missing+1 more
CLM-429579	CLM	Jacob Peters	1997-09-09	UHC-44382-28	—	7610 Highland Ave, Denver, CO	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
ENR-108303	ENR	Susan X Crzu	1999-02-13	UHC-91616-29	8619654207	9775 Cedar Ln, Atlanta, GA	0.66	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-420307	CLM	Tyler Mendez	1984-07-19	UHC-76563-32	—	8168 Church St, Tampa, FL	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
CLM-425712	CLM	Ronald Moralse	1948-01-28	—	—	2228 Church St Apt 35, Phoenix, AZ	0.66	Unit split from street City re-cased ZIP missing Whitespace trimmed+1 more
ENR-108526	ENR	Luis Reed	1944-04-24	UHC-97310-50	2423077489	3980 Meadow Ln, Orlando, FL	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
ENR-117327	ENR	Marcus Z Butler	1982-06-16	UHC-16283-93	4528775947	7360 Canyon Rd, San Antonio, TX	0.66	Name re-cased Phone reformatted ZIP missing Gender normalised+1 more
ENR-130389	ENR	Jackie X Daiz	1955-12-28	UHC-15009-91	4543731494	5150 Central Ave, San Antonio, TX	0.66	Name re-cased Date of birth reformatted State name converted to code ZIP missing+1 more
CLM-416024	CLM	Brnda Nelson	1946-06-04	UHC-04067-06	—	1315 Market St, Gilbert, AZ	0.66	Name re-cased Street suffix standardised Address re-cased State code upper-cased+1 more
CLM-416023	CLM	Brnda Nelson	1946-06-04	UHC-04067-06	—	1315 Market St, Gilbert, AZ	0.66	Name re-cased Street suffix standardised Address re-cased State code upper-cased+1 more
ENR-111870	ENR	Wayne Y Armstrong	2005-12-22	UHC-55770-22	—	1981 Mountain View Dr, Columbus, OH	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
ENR-130519	ENR	Sarah Z Guzman	1994-09-06	UHC-96855-51	5934413709	1172 Sage Ct, Denver, CO	0.66	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-432268	CLM	Kyle Q Wells	1988-04-04	UHC-72557-18	7323738105	5026 Sage Ct, Sacramento, CA	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
PRV-29148	PRV	Bruce T Rodriguez	1960-10-12	UHC-81012-41	2356127113	8269 Market St, Mesa, AZ	0.66	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+1 more
CLM-428734	CLM	Mary Hamilton	1961-07-01	—	3598889997	391 Union St, Tucson, AZ	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
TPA-59802	TPA	Omaar Myres	1982-12-10	—	—	7679 Maple Ave, Orlando, FL	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
CLM-419643	CLM	Danielle Cox	1943-04-12	UHC-81480-36	7134007297	5635 Spring St, Sacramento, CA	0.66	Phone reformatted ZIP missing Gender normalised Whitespace trimmed+1 more
PRV-25374	PRV	Kimberly Burns	1982-01-20	—	2305487241	3423 Camelback Rd, Tempe, AZ	0.66	Phone reformatted City re-cased ZIP missing Gender normalised+1 more
TPA-52612	TPA	Hunt Stephanie	1938-10-16	—	4562020786	1688 Grand Ave, San Diego, CA	0.66	Phone reformatted ZIP missing Gender normalised Whitespace trimmed+1 more
ENR-106836	ENR	Scott U Gomez	1994-12-27	UHC-06958-42	3048528575	5700 Baseline Rd, Tucson, AZ	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
ENR-102230	ENR	Dylan C Kim	2007-06-24	UHC-93308-26	8946694364	7800 Elm St, Dallas, TX	0.66	Phone reformatted City re-cased State name converted to code ZIP missing+1 more
TPA-60521	TPA	John Hamilton	1939-02-07	—	—	3945 Main St, Tucson, AZ	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
ENR-117003	ENR	Heather C Chapman	1981-12-02	UHC-90502-74	6795081731	7036 Park Pl, Minneapolis, MN	0.66	Name re-cased Phone reformatted ZIP missing Gender normalised+1 more
ENR-125673	ENR	Jeffrey Z Evans	1962-04-10	—	5099098857	207 Valley View Dr Apt 38, Gilbert, AZ	0.66	Phone reformatted Unit split from street ZIP missing Plan code upper-cased+1 more
CLM-413661	CLM	Daniel Sanchez	2004-03-03	UHC-64552-91	—	6681 Lake View Rd, Austin, TX	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
CLM-430916	CLM	Justin Le	1977-05-22	UHC-43468-04	4799229662	1662 Market St, Phoenix, AZ	0.66	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+1 more
CLM-411697	CLM	Jean G Oliver	1943-02-20	UHC-69298-44	—	6181 Sunset Blvd, Nashville, TN	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
ENR-137329	ENR	Larry Reyes	1965-06-27	UHC-64902-70	—	4844 Park Pl, Plano, TX	0.66	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+1 more
PRV-22047	PRV	Matt Montgomery	1972-10-03	—	9079446751	4920 Lake View Rd, Charlotte, NC	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more

7,146 rows, page 94 of 143Previous Next