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-428134	CLM	Judith Espinoza	1987-06-10	—	—	403 Spring St, Mesa, AZ	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+2 more
TPA-51322	TPA	Samantha Jensen	1962-07-24	—	—	8073 Central Ave, Fresno, CA	0.64	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
CLM-421624	CLM	Olivia Gonzales	1943-12-08	UHC-00411-18	9682994643	8846 Apache Blvd, Seattle, WA	0.64	Name re-cased Date of birth reformatted Phone reformatted ZIP missing+2 more
ENR-112871	ENR	Angela F Andrews	1965-06-22	UHC-91199-12	5328592317	3605 Mesa Dr, Denver, CO	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-137519	ENR	Jeremy B Sandoval	1994-03-14	UHC-32667-25	2655860897	9010 Mountain View Dr, Houston, TX	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP missing+2 more
PRV-28745	PRV	Catherine R Larson	1971-12-20	—	6422852095	2721 Sunset Blvd, San Diego, CA	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+2 more
PRV-25109	PRV	Angela Watkins	1959-11-08	UHC-59656-73	3539147433	3595 Mountain View Dr, Jacksonville, FL	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-419877	CLM	Mariana Nguyen	1974-09-10	UHC-30578-85	7332586892	789 Highland Ave, Glendale, AZ	0.64	Name re-cased Date of birth reformatted Phone reformatted State name converted to code+2 more
PRV-23328	PRV	Barbara Pena	2005-02-23	—	4433485397	2978 Church St, Atlanta, GA	0.64	Street suffix standardised Address re-cased State code upper-cased ZIP missing+2 more
ENR-137383	ENR	Abgail Hanson	1989-08-08	UHC-48519-93	8327799402	9129 Canyon Rd, Fresno, CA	0.64	Name re-cased Phone reformatted City re-cased ZIP missing+2 more
ENR-111731	ENR	Alan Q Soto	2000-09-04	UHC-40031-82	4185428741	2984 Mesa Dr, Plano, TX	0.64	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-123969	ENR	Omar G Rivera	1956-11-01	UHC-34231-80	9509040727	2530 Sunset Blvd, Tampa, FL	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+2 more
ENR-128761	ENR	Ana J Wilson	2008-11-12	UHC-64306-22	2318393725	4501 Union St, San Antonio, TX	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
TPA-53283	TPA	Megan Rivera	1971-12-11	—	—	4402 Elm St, San Antonio, TX	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-109198	ENR	Danielle Elliott	1987-11-06	UHC-10138-47	4158089417	5017 Indian School Rd, Miami, FL	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-105588	ENR	Laura Greene	2001-07-01	UHC-17929-77	8654149484	204 Sunset Blvd, Fresno, CA	0.64	Name split from “Last, First”Phone reformatted State code upper-cased ZIP missing+2 more
PRV-23660	PRV	Olivia Dominguez	1977-08-09	—	4399614950	7574 Bayshore Dr, Scottsdale, AZ	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-414922	CLM	Jessica Cunningham	1978-09-04	UHC-94194-72	—	6160 Central Ave, Phoenix, AZ	0.64	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-112854	ENR	Debra V Freeman	1995-03-18	UHC-23985-64	9324062109	1183 Apache Blvd, Fresno, CA	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-414304	CLM	Knight Kathleen	1981-08-22	—	2336873624	3149 Park Pl, Dallas, TX	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-134257	ENR	Alexander S Daniels	1957-08-17	UHC-31734-73	—	7936 Central Ave, Fresno, CA	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+2 more
CLM-416749	CLM	Lauren Riley	1952-01-08	UHC-01311-77	—	1156 Hillcrest Rd, Minneapolis, MN	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-409822	CLM	Frances Graham	1971-04-22	UHC-93802-82	4645193646	1867 Ocean Ave, Nashville, TN	0.64	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
TPA-55006	TPA	Pamela Burns	1944-05-11	—	—	8027 Ridge Rd, Houston, TX	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+2 more
ENR-108476	ENR	Paul Herrera	1994-10-15	UHC-49772-88	8872767298	2380 Broadway, Seattle, WA	0.64	Date of birth reformatted Address re-cased City re-cased ZIP missing+2 more
ENR-122134	ENR	James U White	1958-06-21	UHC-66551-78	8569966147	2410 Canyon Rd, Chandler, AZ	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
CLM-428701	CLM	Susan Hamilton	1983-12-09	UHC-49973-47	—	4288 Church St, Sacramento, CA	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+2 more
ENR-141681	ENR	Joe Matthews	1967-06-22	UHC-59785-40	—	7710 Broadway, Atlanta, GA	0.64	Name re-cased Date of birth reformatted City re-cased ZIP missing+2 more
ENR-121760	ENR	Maggie V Tucker	1993-08-05	UHC-50426-10	6546041409	3606 Mesa Dr, San Diego, CA	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-26196	PRV	Nicole Snyder	1988-07-06	—	3302417673	6336 Spring St, San Antonio, TX	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-418953	CLM	Oar Hunt	1938-05-20	UHC-97434-51	4543629865	9314 Bayshore Dr, Los Angeles, CA	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-28813	PRV	Carol Warren	1952-07-21	—	7727283716	7040 Hillcrest Rd, Gilbert, AZ	0.64	Name re-cased Phone reformatted ZIP missing Gender normalised+2 more
TPA-61721	TPA	Kevin Freeman	1952-09-01	—	—	7508 Oak St, Mesa, AZ	0.64	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
CLM-407621	CLM	Teressa Z Porter	1983-10-23	—	7316388441	8615 Hillcrest Rd, Chandler, AZ	0.64	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
ENR-113865	ENR	Amber Perez	1943-10-25	UHC-24581-99	4013011768	6547 Union St, Nashville, TN	0.64	Date of birth reformatted Phone reformatted City re-cased State name converted to code+2 more
CLM-417528	CLM	Ailce Griffin	1973-02-01	UHC-73266-95	4854263168	393 Park Pl, Denver, CO	0.64	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
CLM-405030	CLM	Christopher Cunningham	1946-04-04	—	2956630065	3285 River Rd, Charlotte, NC	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
TPA-54844	TPA	Luri Cruz	—	UHC-43223-03	—	3912 Main St, Austin, TX	0.64	Name re-cased Date of birth unreadable Member ID reformatted City re-cased+2 more
ENR-129188	ENR	Marilyn T Taylor	1973-12-28	UHC-48770-91	9596807090	9388 Ridge Rd, Minneapolis, MN	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP missing+2 more
TPA-62950	TPA	Ann Sims	1992-02-16	—	4029507313	2701 Pine Dr, Gilbert, AZ	0.64	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-125057	ENR	Charlotte Fowler	1973-02-10	UHC-87423-71	4117027036	5221 Sage Ct, Tucson, AZ	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-25219	PRV	Arthur Gibson	1982-09-25	—	2933056159	6998 Cedar Ln, Austin, TX	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-111324	ENR	Dennis K Alvarez	2004-04-22	UHC-68394-96	5332054449	8893 Maple Ave, Tempe, AZ	0.64	Name re-cased City re-cased State code upper-cased ZIP missing+2 more
TPA-62681	TPA	Joe Perry	1940-12-09	—	—	4480 Willow Ct, Denver, CO	0.64	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
TPA-62680	TPA	Joe Perry	1940-12-09	—	—	4480 Willow Ct, Denver, CO	0.64	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
ENR-100246	ENR	Cynthia Peterson	1984-03-27	UHC-59351-27	2918480003	5694 Central Ave, Nashville, TN	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-131627	ENR	Gerald Obrien	1977-03-10	UHC-71049-32	3527023449	4101 Sage Ct, Dallas, TX	0.64	Name split from “Last, First”Name re-cased Phone reformatted ZIP missing+2 more
CLM-408098	CLM	Ryan Richards	1980-05-09	UHC-91216-27	—	8087 Mesa Dr, Seattle, WA	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+2 more
ENR-131809	ENR	Wei B Vazquez	2006-01-12	UHC-51207-32	5803674684	2703 River Rd, Glendale, AZ	0.64	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
ENR-100828	ENR	Gary J Gutierrez	1992-12-06	UHC-65560-71	3813418968	3140 Canyon Rd, Sacramento, CA	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more

7,146 rows, page 85 of 143Previous Next