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-408351	CLM	Mariana D Fields	1960-11-22	UHC-96749-28	6022285654	—	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
CLM-427802	CLM	Debra Q Singh	1993-07-11	—	4242360970	1303 Maple Ave, Mesa, AZ, 85264	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-416686	CLM	Melissa Holmes	1950-12-25	UHC-70244-48	5407880357	7566 Spring St, San Antonio, TX, 78203	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-416056	CLM	Raymond Morales	1963-01-08	UHC-83339-38	8602309791	—	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
CLM-403900	CLM	George Maldonado	2003-06-28	UHC-54438-55	—	8555 Palm Dr, Tampa, FL, 33677	0.78	Date of birth reformatted Street suffix standardised Address re-cased Email lower-cased+1 more
CLM-428633	CLM	Christopher Young	1993-07-09	UHC-27607-79	—	1866 Church St, Chandler, AZ, 85269	0.78	Name re-cased Date of birth reformatted State name converted to code Whitespace trimmed+1 more
CLM-427795	CLM	Camial E Parker	1957-05-01	UHC-18232-09	—	—	0.78	Date of birth reformatted Member ID reformatted Gender normalised Whitespace trimmed+1 more
CLM-411253	CLM	Nancy Espinoza	1995-02-11	UHC-50303-16	—	1313 Oak St, Eden Prairie, MN, 55361	0.78	Date of birth reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-416866	CLM	Angela Garrett	1948-05-06	UHC-27727-94	—	—	0.78	Date of birth reformatted Gender normalised Plan code upper-cased Whitespace trimmed+1 more
CLM-413241	CLM	Lisa Mendez	1953-09-05	UHC-19854-24	5005642611	9253 Jefferson Ave, San Diego, CA	0.78	Name re-cased Date of birth reformatted Phone reformatted ZIP missing+1 more
CLM-419429	CLM	Shirley Shaw	1981-11-18	UHC-36002-70	7184181521	2333 Apache Blvd, Jacksonville, FL, 32269	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-403846	CLM	Fatyma Green	1971-01-19	UHC-56858-96	—	764 River Rd, Minneapolis, MN, 55442	0.78	Date of birth reformatted City re-cased State code upper-cased ZIP+4 trimmed+1 more
CLM-403027	CLM	Jordan F Gardenr	1969-10-17	UHC-58120-60	5216098775	8315 Market St, Phoenix, AZ, 85090	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-412728	CLM	Ann Welch	1990-11-23	UHC-96949-18	—	5773 Grand Ave, Seattle, WA, 98173	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-418044	CLM	Sue L Murphy	1969-07-25	—	3835492958	—	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-421645	CLM	Santiago Gonzzales	1989-11-03	UHC-46097-50	6169054240	—	0.78	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed+1 more
CLM-422129	CLM	Carlos V Gonzalez	1969-02-05	—	4072734178	2079 Valley View Dr, Phoenix, AZ, 85086	0.78	Date of birth reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-414072	CLM	Janice Patterson	1986-07-13	UHC-57062-91	—	1381 Bayshore Dr, Gilbert, AZ, 85274	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-419590	CLM	Nathan Robertson	1997-07-22	—	9166607192	8063 Meadow Ln, Mesa, AZ, 85274	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-426046	CLM	Roy W Ortega	1952-09-11	—	8275698113	5579 Baseline Rd, Phoenix, AZ, 85054	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-403116	CLM	Jesse Webb	1952-05-09	UHC-06711-16	—	—	0.78	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed+1 more
CLM-418807	CLM	Heather Williamson	1954-09-11	UHC-16635-25	—	3052 Valley View Dr, Chandler, AZ, 85241	0.78	Date of birth reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-409512	CLM	Abigail Montgomery	1945-06-27	UHC-74702-59	7394997841	3460 Forest Ave, Minneapolis, MN	0.78	Date of birth reformatted Phone reformatted ZIP missing Whitespace trimmed+1 more
CLM-401321	CLM	Maarilyn Miller	1955-01-17	UHC-47254-57	—	6379 Pine Dr, Sacramento, CA, 95808	0.78	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
CLM-401320	CLM	Maarilyn Miller	1955-01-17	UHC-47254-57	—	6379 Pine Dr, Sacramento, CA, 95808	0.78	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
CLM-418736	CLM	Denise Soto	1966-06-11	UHC-64839-09	7777088400	6039 Elm St, Los Angeles, CA, 90076	0.78	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+1 more
CLM-419901	CLM	Kathryn Y Robinson	1968-05-13	UHC-69124-67	—	8157 Ridge Rd, Charlotte, NC, 28201	0.78	Name split from “Last, First”Date of birth reformatted City re-cased Whitespace trimmed+1 more
CLM-419902	CLM	Kathryn Y Robinson	1968-05-13	UHC-69124-67	—	8157 Ridge Rd, Charlotte, NC, 28201	0.78	Name split from “Last, First”Date of birth reformatted City re-cased Whitespace trimmed+1 more
CLM-403905	CLM	Ralph Martin	1998-03-07	—	—	3214 Valley View Dr, Los Angeles, CA, 90098	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-429020	CLM	Nancy Martin	1947-07-28	UHC-66350-74	8185449260	7326 Highland Ave, Tempe, AZ, 85243	0.78	Date of birth reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-417044	CLM	Thomas Foster	1999-05-26	UHC-99921-94	—	369 Ocean Ave, Denver, CO, 80260	0.78	Date of birth reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-411096	CLM	Brittany Stephens	1945-01-14	—	9795777865	3384 Oak St, Columbus, OH, 43201	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-408093	CLM	Jonathan Ferguson	1989-10-14	UHC-53355-99	4392098209	7819 Cedar Ln, Seattle, WA, 98120	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-429047	CLM	Gregory Y Espinoza	1982-11-20	UHC-77447-91	—	5603 Indian School Rd, Columbus, OH, 43279	0.78	Date of birth reformatted City re-cased Gender normalised Whitespace trimmed+1 more
CLM-431189	CLM	Terry Williams	1939-10-17	UHC-02175-32	8036281479	2679 Ocean Ave, Glendale, AZ, 85377	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-401938	CLM	Katherine Montgomery	1996-08-07	—	9325545090	6855 Sunset Blvd, Tempe, AZ	0.78	Date of birth reformatted Phone reformatted ZIP missing Whitespace trimmed+1 more
CLM-426031	CLM	Eliijah Mitchell	1998-11-18	—	—	4345 Mesa Dr, Eden Prairie, MN, 55386	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-429213	CLM	Betty Moreno	1952-11-17	UHC-41237-68	—	4291 Washington St, Houston, TX, 77063	0.78	Date of birth reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-412565	CLM	Kathleen Lane	2001-01-26	—	4949725027	7643 Highland Ave, Miami, FL, 33193	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-416775	CLM	Bryan Stevens	1997-05-16	UHC-77358-20	6423989218	—	0.78	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+1 more
CLM-410715	CLM	Harold Nelson	1971-09-18	—	3195965425	918 Elm St, Austin, TX, 78796	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-402594	CLM	Olivia Hughes	1985-02-19	UHC-11245-96	—	6459 Lake View Rd, Denver, CO, 80228	0.78	Date of birth reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-402593	CLM	Olivia Hughes	1985-02-19	UHC-11245-96	—	6459 Lake View Rd, Denver, CO, 80228	0.78	Date of birth reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-405930	CLM	Michael Wells	1953-10-18	—	—	4425 Mesa Dr, Charlotte, NC, 28254	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-425074	CLM	Ashley J Oliver	1973-04-06	UHC-27439-19	5064834373	229 Bayshore Dr, Gilbert, AZ, 85201	0.78	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed+1 more
CLM-407656	CLM	Rebecca L Hernandez	1991-06-24	—	6463540178	—	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-420974	CLM	Angela Williamson	1947-10-26	—	—	6565 Baseline Rd, Phoenix, AZ, 85072	0.78	Date of birth reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-419200	CLM	Mei West	1967-06-26	UHC-89424-95	6868852208	9560 Lincoln Way Apt 4, Austin, TX, 78729	0.78	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed+1 more
CLM-406165	CLM	Christina J Harrison	1983-12-03	UHC-49614-16	—	1526 Union St, Fresno, CA, 93724	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-414343	CLM	Kathryn Nunez	1984-11-27	UHC-98186-22	—	3733 Meadow Ln Apt 11, Los Angeles, CA, 90025	0.78	Name re-cased Date of birth reformatted Unit split from street Whitespace trimmed+1 more

10,559 rows, page 112 of 212Previous Next