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

Claims, flag “Name split from “Last, First””, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagName split from “Last, First”Clear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-417016	CLM	Alice Soto	1970-05-14	UHC-08324-56	6696781003	3964 Baseline Rd, Eden Prairie, MN, 55306	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-403164	CLM	Diego Daniels	1953-10-13	—	—	3198 Highland Ave, Eden Prairie, MN, 55357	0.66	Name split from “Last, First”City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-418335	CLM	Camila Ramos	1952-05-01	UHC-23396-60	3156815432	8909 Market St, Charlotte, NC	0.66	Name split from “Last, First”Phone reformatted ZIP missing Whitespace trimmed+1 more
CLM-417265	CLM	Jack Alexaander	1971-04-20	UHC-89498-08	7237404966	—	0.66	Name split from “Last, First”Two-digit birth year Phone reformatted Whitespace trimmed+1 more
CLM-400808	CLM	Kathleen Soto	1939-10-26	UHC-10461-05	8439704719	—	0.66	Name split from “Last, First”Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-424492	CLM	Ryan Ramirez	1940-06-16	UHC-68274-91	—	2106 Cedar Ln Apt 4, Sacramento, CA, 95845	0.66	Name split from “Last, First”Date of birth reformatted Unit split from street Whitespace trimmed+1 more
CLM-413099	CLM	Sofia Lewis	1938-03-27	UHC-91831-67	—	3032 Valley View Dr, Mesa, AZ, 85261	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-429900	CLM	Diego M Knight	1939-10-11	UHC-87115-85	3115284149	—	0.66	Name split from “Last, First”Two-digit birth year Phone reformatted Plan code upper-cased+1 more
CLM-408479	CLM	Sharon Maldonado	1972-08-13	UHC-56381-23	—	3759 Maple Ave, Mesa, AZ, 85281	0.66	Name split from “Last, First”Street suffix standardised Address re-cased City re-cased+1 more
CLM-418035	CLM	William Williams	1953-12-19	—	—	6941 Elm St, Scottsdale, AZ, 85239	0.66	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-418416	CLM	Ryan Hunter	1965-10-05	UHC-48235-63	9726429827	7479 Forest Ave, Charlotte, NC, 28209	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-426267	CLM	Olivia L Soto	1941-06-17	—	5936636180	8769 Grand Ave, Dallas, TX, 75254	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-404570	CLM	Diana Patterson	2002-09-09	UHC-03595-51	—	8120 Maple Ave, Scottsdale, AZ, 85215	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-423019	CLM	Bradley Carlson	1951-06-21	—	—	—	0.66	Name split from “Last, First”Date of birth reformatted Gender normalised Whitespace trimmed+1 more
CLM-429194	CLM	Brandon Andrews	1956-02-04	UHC-68112-03	5848021755	414 Oak St, Tucson, AZ, 85712	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised+1 more
CLM-427238	CLM	Russell King	1946-12-11	—	7872580235	9139 Willow Ct Apt 32, Fresno, CA, 93734	0.66	Name split from “Last, First”Phone reformatted Unit split from street Whitespace trimmed+1 more
CLM-419440	CLM	Thomaas U Johnston	1997-12-06	—	7955059663	4189 Market St, Tampa, FL, 33690	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-418060	CLM	Dorothy Austin	1949-11-11	UHC-48631-14	—	8657 Oak St, Los Angeles, CA, 90068	0.66	Name split from “Last, First”City re-cased State name converted to code Whitespace trimmed+1 more
CLM-402661	CLM	Christine Henry	—	UHC-14353-96	9073872354	—	0.66	Name split from “Last, First”Date of birth missing Phone reformatted Whitespace trimmed+1 more
CLM-409992	CLM	Mariana T Green	1989-08-17	UHC-41515-80	—	9052 Grand Ave, Denver, CO, 80222	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-428836	CLM	Ashley Walsh	1961-10-13	—	4522281878	7897 Palm Dr, Nashville, TN	0.66	Name split from “Last, First”Phone reformatted ZIP missing Whitespace trimmed+1 more
CLM-400378	CLM	Victoria J Lynch	1959-10-10	—	4788710032	9353 Baseline Rd, Jacksonville, FL, 32296	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+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
CLM-408616	CLM	David Berry	1958-08-22	UHC-53040-86	—	2050 Oak St, Nashville, TN, 37217	0.66	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-421045	CLM	Joshua Williamson	1987-07-19	—	—	2202 Apache Blvd, Jacksonville, FL, 32286	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-403678	CLM	Frank P Williamson	1938-10-13	—	—	5825 Forest Ave # 233, Los Angeles, CA, 90091	0.66	Name split from “Last, First”Date of birth reformatted Unit split from street Whitespace trimmed+1 more
CLM-418360	CLM	Dorothy W Vega	2007-12-16	—	—	1660 Ridge Rd, Atlanta, GA, 30306	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-430594	CLM	Susan Laarson	1966-04-24	—	9407838231	8213 Indian School Rd # 994, Orlando, FL, 32859	0.66	Name split from “Last, First”Unit split from street City re-cased Whitespace trimmed+1 more
CLM-401376	CLM	Nicoole Simpson	1969-11-11	UHC-07493-84	—	802 Ridge Rd, Nashville, TN, 37233	0.66	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-401131	CLM	Adam Torres	1994-02-07	UHC-94361-64	—	24 Jefferson Ave, Fresno, CA, 93790	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Plan code upper-cased+1 more
CLM-402287	CLM	Olivia Hart	1976-10-26	UHC-78547-45	8638372853	9622 Highland Ave, Houston, TX, 77017	0.66	Name split from “Last, First”Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-423933	CLM	Sara I Wallace	1992-04-20	—	9407614454	1117 Baseline Rd, Tempe, AZ, 85202	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+1 more
CLM-409598	CLM	Debra Olson	1973-11-04	UHC-20571-53	6247223764	8781 Indian School Rd, Orlando, FL, 32828	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-401652	CLM	Lauren Parker	1986-10-21	UHC-44890-54	8495108221	4890 Ocean Ave, San Antonio, TX, 78243	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-404005	CLM	Ryan Thompson	1943-03-11	—	—	2844 Camelback Rd, Glendale, AZ, 85390	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
CLM-403051	CLM	Larry K Carpenter	1945-06-21	UHC-87326-29	—	9390 Valley View Dr, Miami, FL, 33129	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
CLM-410184	CLM	William Robinson	1980-09-06	UHC-37175-59	—	1200 Valley View Dr, Nashville, TN, 37228	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
CLM-416002	CLM	Amanda Mendoza	1941-02-24	UHC-89922-24	—	11 Bayshore Dr, Gilbert, AZ, 85248	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
CLM-424907	CLM	Diego Knight	1952-03-13	—	—	6387 Indian School Rd, Dallas, TX, 75233	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
CLM-421277	CLM	Elizabeth Santiago	1974-02-24	UHC-79914-44	—	1713 Ridge Rd, Mesa, AZ, 85274	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
CLM-428015	CLM	Jeffrey Harvey	1990-09-09	UHC-72004-42	—	7611 Oak St, Dallas, TX, 75283	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
CLM-400016	CLM	Margret Bell	2006-07-25	—	—	4859 Elm St, Tampa, FL, 33618	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
CLM-428363	CLM	Bradley J Warren	2005-07-23	—	5883727120	93 Valley View Dr, Atlanta, GA, 30385	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
CLM-412031	CLM	Keith Lopez	1954-12-07	UHC-85819-38	4926077912	—	0.68	Name split from “Last, First”Member ID reformatted Gender normalised Placeholder values cleared
CLM-426056	CLM	Ruh Perez	2002-04-14	—	4504778897	8217 Pine Dr, Glendale, AZ, 85377	0.68	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased
CLM-421102	CLM	Jeremy Garcia	1967-05-14	—	—	5842 Forest Ave, Sacramento, CA, 95862	0.68	Name split from “Last, First”Date of birth reformatted City re-cased Gender normalised
CLM-431025	CLM	Amanda G Gibson	1938-02-15	UHC-89438-32	7508292181	—	0.68	Name split from “Last, First”Phone reformatted Gender normalised Placeholder values cleared
CLM-425271	CLM	Bruce U Evans	1946-06-09	—	4119456514	2759 Spring St, Charlotte, NC, 28204	0.68	Name split from “Last, First”Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-405241	CLM	Dorothy K Moreno	1944-06-07	UHC-95806-45	—	4861 Washington St, Gilbert, AZ	0.68	Name split from “Last, First”ZIP missing Whitespace trimmed Placeholder values cleared
CLM-411156	CLM	Dylan Palmer	2003-10-15	UHC-54824-76	8592910532	2321 Mesa Dr, Chandler, AZ, 85278	0.68	Name split from “Last, First”Date of birth reformatted State name converted to code Placeholder values cleared

3,226 rows, page 38 of 65Previous Next