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+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-107681	ENR	FJunk	1992-05-19	UHC-36150-61	4604583191	3691 Lincoln Way, Minneapolis, MN, 55469	0.66	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
ENR-141776	ENR	Carlos O Payne	1954-12-22	UHC-37293-70	2235059051	6927 Camelback Rd, Tucson, AZ, 85772	0.66	Phone reformatted Member ID reformatted ZIP+4 trimmed Gender normalised+1 more
PRV-26042	PRV	Ashley Ramos	1994-03-27	—	9385921902	1140 Forest Ave, Jacksonville, FL, 32283	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-409342	CLM	Fatima Coleman	1981-12-02	UHC-25318-23	—	4474 Sunset Blvd, Los Angeles, CA, 90061	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
ENR-116952	ENR	Maria K Flores	1956-05-10	UHC-60594-77	3234916534	8247 River Rd, Charlotte, NC, 28285	0.66	Name re-cased Two-digit birth year Phone reformatted ZIP+4 trimmed+1 more
TPA-57917	TPA	Mary Cox	1974-07-26	—	—	8749 Indian School Rd, Seattle, WA, 98151	0.66	Name re-cased Two-digit birth year ZIP+4 trimmed Whitespace trimmed+1 more
TPA-57916	TPA	Mary Cox	1974-07-26	—	—	8749 Indian School Rd, Seattle, WA, 98151	0.66	Name re-cased Two-digit birth year ZIP+4 trimmed Whitespace trimmed+1 more
CLM-402025	CLM	Elijah X Ray	2004-04-16	UHC-16733-85	5194246914	5905 Sunset Blvd, Mesa, AZ, 85267	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-125797	ENR	Mariana J Arnold	1973-01-18	UHC-82201-41	6208609139	7880 Ocean Ave, Tempe, AZ, 85216	0.66	Phone reformatted City re-cased State name converted to code ZIP+4 trimmed+1 more
CLM-417546	CLM	Walter D Moreno	1939-07-01	UHC-84396-39	5143662966	597 Elm St, Denver, CO, 80262	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
PRV-21591	PRV	Valentina B Dnucan	1952-02-08	UHC-28239-76	3317667418	5220 Indian School Rd, Los Angeles, CA, 90089	0.66	City re-cased ZIP+4 trimmed Gender normalised Whitespace trimmed+1 more
ENR-102751	ENR	Rachel Espinoza	1955-09-10	UHC-13174-25	3506031190	4838 Hillcrest Rd, Los Angeles, CA, 90052	0.66	Name re-cased Phone reformatted ZIP+4 trimmed Gender normalised+1 more
CLM-421649	CLM	Mark Washigton	2006-12-27	—	7607640652	5914 Ridge Rd, Minneapolis, MN, 55434	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-124896	ENR	Scott Silva	2004-08-21	UHC-66182-48	3642562449	156 Grand Ave, Austin, TX, 78755	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-135045	ENR	Theresa L Chavez	1978-03-09	UHC-34141-14	4145226938	2365 Palm Dr, Chandler, AZ, 85287	0.66	Phone reformatted City re-cased ZIP+4 trimmed Gender normalised+1 more
CLM-426601	CLM	Patricia S Owens	1950-08-04	UHC-87048-14	—	3078 Ocean Ave, Nashville, TN, 37201	0.66	Street suffix standardised Address re-cased City re-cased ZIP+4 trimmed+1 more
CLM-428296	CLM	Frank Alvarez	2002-04-13	—	—	221 Willow Ct, Los Angeles, CA, 90061	0.66	Name split from “Last, First”Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-136738	ENR	Drew James	1938-01-24	UHC-35033-47	7675307555	7426 Forest Ave, Jacksonville, FL, 32221	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
TPA-62203	TPA	Maadison Taylor	1940-07-08	UHC-46048-40	2937995844	3153 Oak St, Fresno, CA, 93751	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-108277	ENR	Joyce Palmer	1980-11-24	UHC-68741-60	4587326648	712 Pine Dr, Atlanta, GA, 30360	0.66	Street suffix standardised Address re-cased City re-cased ZIP+4 trimmed+1 more
ENR-116848	ENR	Brenda U Diaz	1997-06-04	UHC-52291-91	7737240838	2359 Apache Blvd, Scottsdale, AZ, 85230	0.66	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-126526	ENR	Jerry Hughes	1998-05-16	UHC-76428-97	4092087854	5967 Meadow Ln, Tempe, AZ, 85200	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-102151	ENR	Doris Martin	1979-11-14	UHC-99173-76	5788380145	2759 Ocean Ave, Scottsdale, AZ, 85299	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
TPA-62041	TPA	Randy T Burton	1938-03-02	UHC-32006-03	3015630417	8838 Market St, Fresno, CA, 93724	0.66	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-24828	PRV	Jonathan Weaver	—	—	8689333157	7790 Park Pl, Nashville, TN, 37221	0.66	Name re-cased Date of birth unreadable Phone reformatted ZIP+4 trimmed+1 more
TPA-51112	TPA	Emma A Perez	1997-09-25	UHC-52568-47	—	5635 Oak St, Gilbert, AZ, 85241	0.66	Street suffix standardised Address re-cased City re-cased ZIP+4 trimmed+1 more
CLM-420012	CLM	Terry Cooper	1960-07-24	—	7869346996	6679 Sunset Blvd, Fresno, CA, 93752	0.66	Name re-cased Phone reformatted ZIP+4 trimmed Gender normalised+1 more
PRV-21047	PRV	Matthew Snyer	2004-11-13	UHC-33098-14	6039445723	7898 Sage Ct, Miami, FL, 33143	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
PRV-20701	PRV	Debra Bennett	1990-11-07	UHC-53451-24	9208313051	6161 Union St, Sacramento, CA, 95838	0.66	Name re-cased Two-digit birth year Phone reformatted ZIP+4 trimmed+1 more
CLM-431233	CLM	Joan Rivera	1989-12-18	UHC-22799-76	—	7244 Oak St, Miami, FL, 33179	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-431232	CLM	Joan Rivera	1989-12-18	UHC-22799-76	—	7244 Oak St, Miami, FL, 33179	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
ENR-120410	ENR	Lisa Wang	1961-01-10	UHC-01264-90	3148895342	5726 Indian School Rd Apt 14, Scottsdale, AZ, 85282	0.66	Name re-cased Phone reformatted Unit split from street ZIP+4 trimmed+1 more
ENR-116926	ENR	Judy Ortega	1964-10-09	UHC-01762-01	9313430829	75 Union St, Denver, CO, 80241	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
CLM-405724	CLM	Will Simpson	1999-12-22	—	—	4472 Baseline Rd, Scottsdale, AZ, 85240	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
PRV-25449	PRV	David M Larson	1986-04-27	UHC-94457-68	5044796623	5735 Valley View Dr, Houston, TX, 77007	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-123760	ENR	Doris McCoy	1981-04-13	UHC-54370-10	9705001581	2699 Central Ave, Nashville, TN, 37205	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
TPA-60340	TPA	Rachel H Carr	1969-09-16	—	—	6128 Central Ave, Seattle, WA, 98165	0.66	Name split from “Last, First”City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
ENR-120247	ENR	Melissa E Deelgado	1976-06-01	UHC-32529-49	2166353244	2076 Camelback Rd, Tampa, FL, 33621	0.66	Middle initial moved out of first name Phone reformatted Member ID reformatted ZIP+4 trimmed+1 more
CLM-414374	CLM	Kimberly H George	1958-03-08	—	—	252 Harbor Blvd, Nashville, TN, 37296	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-424834	CLM	Joe Weaver	1989-10-27	UHC-65868-91	—	7990 Jefferson Ave, San Antonio, TX, 78245	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-105316	ENR	Danielle P Lynch	2000-02-09	UHC-65454-97	3177249878	1905 Elm St, Minneapolis, MN, 55432	0.66	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
ENR-112465	ENR	Amber V Cole	1981-11-08	UHC-83374-02	—	1908 Bayshore Dr, Mesa, AZ, 85277	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
ENR-117491	ENR	Michael Anderson	1946-08-12	UHC-73052-29	9392107782	1918 Palm Dr, Phoenix, AZ, 85056	0.68	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed
ENR-127327	ENR	Sndra Patel	1950-01-10	UHC-84344-21	7888946895	5464 Canyon Rd, Miami, FL, 33101	0.68	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed
ENR-127326	ENR	Sndra Patel	1950-01-10	UHC-84344-21	7888946895	5464 Canyon Rd, Miami, FL, 33101	0.68	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed
ENR-127582	ENR	Doris Gilbert	1945-07-11	UHC-96647-42	2979854632	8676 Canyon Rd, Las Vegas, NV, 89190	0.68	Phone reformatted ZIP+4 trimmed Gender normalised Placeholder values cleared
TPA-57263	TPA	Nicholas V Miller	1959-05-12	UHC-78923-11	—	5983 Spring St, Tampa, FL, 33697	0.68	Street suffix standardised Address re-cased ZIP+4 trimmed Placeholder values cleared
ENR-126599	ENR	Melissa I Gibson	1965-07-09	UHC-50376-45	—	9252 Mesa Dr, Mesa, AZ, 85294	0.68	Name re-cased Date of birth reformatted Phone missing area code ZIP+4 trimmed
TPA-51247	TPA	Roy Tucker	1946-01-17	—	—	7341 Oak St, Atlanta, GA, 30300	0.68	Street suffix standardised Address re-cased ZIP+4 trimmed Placeholder values cleared
ENR-125163	ENR	Melissa M Lucas	1958-02-13	UHC-85278-67	9513257060	3535 Lake View Rd, Seattle, WA, 98151	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted ZIP+4 trimmed

8,263 rows, page 121 of 166Previous Next