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 “Date of birth reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagDate of birth reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-416206	CLM	Maria Meyer	1957-11-25	UHC-73025-52	—	7272 Mesa Dr, Dallas, TX, 75247	0.68	Date of birth reformatted SSN last four extracted ZIP+4 trimmed Placeholder values cleared
CLM-422501	CLM	Ryan Brooks	1985-04-09	UHC-19949-87	—	9135 Hillcrest Rd, Jacksonville, FL	0.68	Date of birth reformatted State name converted to code ZIP missing Whitespace trimmed
CLM-420756	CLM	Jacob Maldonado	1996-07-26	UHC-78781-64	—	4546 Ridge Rd Apt 30, San Diego, CA, 92121	0.68	Name split from “Last, First”Date of birth reformatted Unit split from street Placeholder values cleared
CLM-405081	CLM	Sofia Fuller	1956-08-14	—	—	9744 Cedar Ln # 821, Tucson, AZ, 85784	0.68	Name split from “Last, First”Date of birth reformatted Unit split from street Placeholder values cleared
CLM-400824	CLM	Adam Sone	1969-12-25	—	—	7730 Church St, Seattle, WA, 98104	0.68	Date of birth reformatted ZIP+4 trimmed Gender normalised Placeholder values cleared
CLM-421365	CLM	Lori Santiago	1993-02-12	UHC-83318-54	4878488971	3583 Hillcrest Rd, Tempe, AZ, 85206	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
CLM-420588	CLM	Emma Sanders	1948-08-06	UHC-54455-12	—	6865 Sage Ct, Nashville, TN, 37297	0.68	Date of birth reformatted ZIP+4 trimmed Gender normalised Placeholder values cleared
CLM-420587	CLM	Emma Sanders	1948-08-06	UHC-54455-12	—	6865 Sage Ct, Nashville, TN, 37297	0.68	Date of birth reformatted ZIP+4 trimmed Gender normalised Placeholder values cleared
CLM-402282	CLM	Ana Z Vazquez	1950-08-01	UHC-27900-79	—	8506 Ridge Rd, Phoenix, AZ, 85055	0.68	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code
CLM-400319	CLM	Anthony K Armstrong	1939-07-20	—	—	5629 Harbor Blvd, Houston, TX, 77055	0.68	Name split from “Last, First”Date of birth reformatted State name converted to code Placeholder values cleared
CLM-403406	CLM	Mariana Webb	1960-07-07	—	9562358950	9040 Canyon Rd, Houston, TX, 77026	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised
CLM-424426	CLM	Andrea Bryant	1955-03-03	UHC-85336-01	—	—	0.68	Date of birth reformatted Phone missing area code Gender normalised Placeholder values cleared
CLM-427095	CLM	Julia Kellly	1938-12-28	UHC-69821-83	—	4420 Union St, Tampa, FL, 33662	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
CLM-406771	CLM	Ruzsell Stewart	1938-12-17	—	2287968735	79 Union St, Denver, CO	0.68	Name split from “Last, First”Date of birth reformatted ZIP missing Placeholder values cleared
CLM-427811	CLM	Steven George	1984-07-09	UHC-26902-16	—	6220 Lincoln Way, Seattle, WA, 98128	0.68	Date of birth reformatted State name converted to code Gender normalised Placeholder values cleared
CLM-410962	CLM	Marttha Patel	1948-05-04	—	—	7106 Harbor Blvd Apt 2, Las Vegas, NV, 89184	0.68	Name split from “Last, First”Date of birth reformatted Unit split from street Placeholder values cleared
CLM-415543	CLM	Eugene Roberts	1991-08-14	—	—	5606 Lincoln Way, San Antonio, TX, 78285	0.68	Date of birth reformatted State name converted to code ZIP+4 trimmed Placeholder values cleared
CLM-429624	CLM	Mateo Riley	1995-03-20	UHC-78610-28	—	231 Cedar Ln, Eden Prairie, MN, 55313	0.68	Name split from “Last, First”Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
CLM-412179	CLM	Julie B Alexander	1990-01-15	—	—	8043 Pine Dr, San Diego, CA, 92164	0.68	Middle initial moved out of first name Date of birth reformatted State name converted to code Placeholder values cleared
CLM-426525	CLM	Raymond Carpenter	1968-04-14	UHC-37527-46	—	64 Palm Dr, Tucson, AZ	0.68	Date of birth reformatted ZIP missing Gender normalised Placeholder values cleared
CLM-419474	CLM	Margaret Bryant	1978-09-05	UHC-57103-48	—	9466 Church St, Gilbert, AZ, 85227	0.68	Date of birth reformatted ZIP+4 trimmed Gender normalised Placeholder values cleared
CLM-411463	CLM	Austin Padilla	1938-07-03	UHC-50622-97	5313303332	2950 Desert Sky Blvd, Chandler, AZ	0.68	Date of birth reformatted Phone reformatted SSN last four extracted ZIP missing
CLM-420899	CLM	Elizabeth Schultz	1967-12-24	UHC-01992-56	—	9384 Pine Dr Apt 34, Fresno, CA, 93758	0.68	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased
CLM-429730	CLM	Barbara Rodriguez	1954-04-20	UHC-58424-93	—	8259 Sage Ct, Phoenix, AZ, 85014	0.68	Name split from “Last, First”Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
CLM-410931	CLM	Doris Simms	1987-06-10	UHC-19611-18	—	2883 Oak St, San Diego, CA	0.68	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing
CLM-425042	CLM	Patrick H Jordan	1948-08-20	UHC-27638-29	9009636389	5088 Mesa Dr, San Antonio, TX, 78269	0.68	Date of birth reformatted State name converted to code Gender normalised Placeholder values cleared
CLM-409256	CLM	Arjun Elliott	1997-06-07	UHC-67426-37	—	6148 Grand Ave Apt 14, Tampa, FL, 33654	0.68	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased
CLM-417791	CLM	Fatima Gaza	1972-11-26	—	—	1370 Lincoln Way, Scottsdale, AZ, 85285	0.68	Date of birth reformatted SSN last four extracted ZIP+4 trimmed Placeholder values cleared
CLM-409532	CLM	Nency Salazar	1981-03-05	UHC-90313-65	8346663805	4822 Sunset Blvd # 686, Columbus, OH, 43220	0.68	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased
CLM-413420	CLM	Doris U Hamilton	1949-03-21	—	—	8807 Indian School Rd Apt 7, Los Angeles, CA, 90063	0.68	Name split from “Last, First”Date of birth reformatted Unit split from street Placeholder values cleared
CLM-405188	CLM	Virginia Ortiz	2008-03-22	UHC-29964-53	—	—	0.68	Date of birth reformatted SSN last four extracted Gender normalised Placeholder values cleared
CLM-430816	CLM	Diego Montgomery	1950-06-08	—	—	2865 Main St, Columbus, OH, 43211	0.68	Name split from “Last, First”Date of birth reformatted State name converted to code Placeholder values cleared
CLM-416517	CLM	Christian Ferguson	1949-08-19	—	—	7562 Indian School Rd, Fresno, CA	0.68	Date of birth reformatted ZIP missing Gender normalised Placeholder values cleared
CLM-427332	CLM	Camila Phillips	1977-11-17	UHC-26863-57	—	—	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
CLM-425698	CLM	Cynthia Porter	1983-10-11	UHC-55361-65	—	9877 Union St, Miami, FL, 33102	0.68	Name split from “Last, First”Date of birth reformatted State name converted to code Placeholder values cleared
CLM-432729	CLM	Madison Thomas	1945-05-25	UHC-45958-44	—	9336 Maple Ave Apt 4, Minneapolis, MN, 55440	0.68	Date of birth reformatted SSN last four extracted Unit split from street Placeholder values cleared
CLM-421024	CLM	Justin G Griffin	1966-09-20	—	—	—	0.68	Middle initial moved out of first name Date of birth reformatted Gender normalised Placeholder values cleared
CLM-411608	CLM	Lawrence Weaver	1964-02-04	UHC-26133-98	9292120024	3519 Church St Apt 15, Tempe, AZ, 85219	0.68	Name split from “Last, First”Date of birth reformatted Unit split from street Whitespace trimmed
CLM-407847	CLM	Bobby Dixon	1958-01-25	UHC-60044-90	6504333180	2777 Washington St, Dallas, TX, 75278	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
CLM-401765	CLM	Walter Wang	1947-09-13	—	—	5093 Grand Ave # 799, Plano, TX, 75090	0.68	Date of birth reformatted Unit split from street Gender normalised Placeholder values cleared
CLM-429666	CLM	Jack Robertson	1976-04-13	—	—	1846 Main St, Glendale, AZ, 85303	0.68	Date of birth reformatted ZIP+4 trimmed Gender normalised Placeholder values cleared
CLM-423341	CLM	Robert Watkins	2001-07-07	UHC-29270-37	—	—	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
CLM-431094	CLM	Elijah Owens	1953-05-21	UHC-18979-40	—	8030 Cedar Ln Apt 30, Mesa, AZ, 85278	0.68	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased
CLM-402036	CLM	Thomas Chavze	1958-01-21	UHC-08205-93	—	6626 Market St, Miami, FL, 33199	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
CLM-424731	CLM	Philip Willis	1968-02-27	—	—	8286 Bayshore Dr, Seattle, WA, 98134	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
CLM-429691	CLM	Ashley O Ryan	1982-05-26	—	2359843599	5777 Grand Ave Apt 34, Fresno, CA, 93780	0.68	Date of birth reformatted Unit split from street Gender normalised Placeholder values cleared
CLM-405840	CLM	Ruth Stephens	1956-11-26	UHC-49733-39	—	—	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
CLM-430602	CLM	Randy Cok	1977-02-14	—	—	5729 Central Ave, San Diego, CA, 92155	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
CLM-411025	CLM	Sara Andrews	1961-11-02	UHC-45537-10	—	—	0.68	Name split from “Last, First”Date of birth reformatted Phone missing area code Placeholder values cleared
CLM-408092	CLM	William Weaver	2005-10-15	UHC-50237-81	—	8974 Indian School Rd # 663, Atlanta, GA, 30355	0.68	Date of birth reformatted Phone missing area code Unit split from street Placeholder values cleared

10,559 rows, page 63 of 212Previous Next