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

All ENR CLM TPA PRV

Junk onlyFlagPhone reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-407146	CLM	Kathleen Obrien	1953-02-15	UHC-76854-65	6242279150	6948 Pine Dr, Columbus, OH, 43294	0.80	Name re-cased Phone reformatted State name converted to code Placeholder values cleared
CLM-412612	CLM	Jeremy Park	1943-06-19	UHC-53335-21	9472447035	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-414250	CLM	Tim Rice	1994-11-24	UHC-92138-91	6822990225	7270 River Rd, Tempe, AZ, 85232	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-402401	CLM	Cheryl Z King	1968-09-10	—	5733546069	—	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-400395	CLM	Yuki Alvarez	1968-03-25	UHC-52693-23	6543006021	2679 Oak St, Phoenix, AZ	0.80	Date of birth reformatted Phone reformatted ZIP missing Placeholder values cleared
CLM-422332	CLM	Deborah B Hill	1941-10-28	UHC-93002-46	4022273661	3555 Main St, Tucson, AZ, 85726	0.80	Phone reformatted City re-cased Gender normalised Placeholder values cleared
CLM-417608	CLM	Ashley Montgomery	1948-10-22	—	9675824786	—	0.80	Name split from “Last, First”Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-424748	CLM	Elizabeth M Jones	1996-02-25	—	4076820738	9833 Oak St, Los Angeles, CA, 90087	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-429106	CLM	Anna Murphy	1944-01-18	—	3474330116	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-427007	CLM	Adam Mendoza	1956-02-27	—	8238225670	430 Market St, Tucson, AZ, 85758	0.80	Date of birth reformatted Phone reformatted State name converted to code Placeholder values cleared
CLM-401881	CLM	Patricia G Wood	1957-06-24	—	2387076524	2526 Meadow Ln, Jacksonville, FL, 32260	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-418040	CLM	Valentnia Martinez	2003-01-05	UHC-82598-56	9819103430	8936 Palm Dr Apt 13, Miami, FL, 33113	0.80	Phone reformatted Unit split from street Whitespace trimmed Placeholder values cleared
CLM-417516	CLM	Denise Oliver	1970-05-03	—	3693422245	7593 Washington St Apt 11, Columbus, OH, 43298	0.80	Name re-cased Phone reformatted Unit split from street Placeholder values cleared
CLM-410203	CLM	Jennifer Nunez	—	UHC-84002-20	4029078641	2821 Grand Ave, Eden Prairie, MN, 55347	0.80	Date of birth unreadable Phone reformatted State code upper-cased Placeholder values cleared
CLM-408101	CLM	Judith Peters	1972-01-24	—	4798712757	1591 Canyon Rd, Dallas, TX, 75219	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-411135	CLM	Maria G Kelly	1970-02-25	UHC-02887-02	7049041430	478 Spring St, Minneapolis, MN, 55456	0.80	Name re-cased Phone reformatted State name converted to code Placeholder values cleared
CLM-413345	CLM	Lawrence Anderson	2001-08-07	UHC-75461-19	5843569567	6884 Meadow Ln, San Diego, CA, 92130	0.80	Name split from “Last, First”Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-404440	CLM	Gregory Ward	1981-01-22	UHC-42600-61	4227143570	886 Bayshore Dr, Miami, FL, 33159	0.80	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased
CLM-410729	CLM	Anthony Burton	1956-11-09	UHC-76511-82	9226340929	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-414745	CLM	—Junk	1997-01-21	UHC-60808-71	2649534678	—	0.80	Phone reformatted Whitespace trimmed Placeholder values cleared No usable name (quarantined)
CLM-427057	CLM	Jason Jacobs	1948-11-06	—	9388299196	—	0.80	Phone reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
CLM-406334	CLM	Samuel Q Cook	1994-08-16	UHC-53331-97	5187677614	3831 Bayshore Dr, Los Angeles, CA, 90049	0.80	Phone reformatted Street suffix standardised Address re-cased Email lower-cased
CLM-418259	CLM	Mariana Fowler	—	UHC-92162-53	3238211928	—	0.80	Date of birth missing Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-420871	CLM	Donna Cok	1978-02-12	—	8798708298	6772 Desert Sky Blvd, Nashville, TN, 37276	0.80	Name re-cased Phone reformatted Street suffix standardised Address re-cased
CLM-405522	CLM	Cheryl Munoz	1946-05-05	UHC-39247-46	8498714888	9140 Lake View Rd, Tempe, AZ, 85297	0.80	Date of birth reformatted Phone reformatted City re-cased State name converted to code
CLM-423626	CLM	Randy Soto	1943-12-07	UHC-23233-32	8336914874	8000 Pine Dr, Dallas, TX, 75231	0.80	Phone reformatted State name converted to code Whitespace trimmed Placeholder values cleared
CLM-400458	CLM	Janice Santiago	1940-08-07	UHC-59241-87	4093028714	5231 Oak St, Jacksonville, FL	0.80	Name re-cased Phone reformatted Member ID reformatted ZIP missing
CLM-426677	CLM	Betty Pena	—	—	6775151078	—	0.80	Name re-cased Date of birth unreadable Phone reformatted Placeholder values cleared
CLM-404721	CLM	Benjamin Morgen	1941-05-03	—	6626192430	8904 Main St, Fresno, CA, 93709	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-409761	CLM	Steven Vazquez	1997-02-28	UHC-56994-16	9825841612	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-426900	CLM	Angela Morgan	1975-12-15	UHC-21095-73	8005654624	6432 Cedar Ln, Orlando, FL, 32843	0.80	Phone reformatted State name converted to code Whitespace trimmed Placeholder values cleared
CLM-403162	CLM	Marcus Fields	1996-03-30	UHC-58975-56	6133079537	8621 Oak St, Nashville, TN, 37241	0.80	Phone reformatted City re-cased Gender normalised Placeholder values cleared
CLM-405899	CLM	Dorothy Mills	2006-01-06	UHC-14042-52	6328889802	8078 Union St, Plano, TX, 75057	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-415821	CLM	Jeremy Duncan	1969-05-17	—	7568930325	6026 Main St, Fresno, CA, 93731	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-413413	CLM	Christine Q Ray	—	UHC-79756-16	8399892244	—	0.80	Date of birth missing Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-428213	CLM	Carl G Murray	1998-01-19	UHC-43401-37	8857874803	1170 Elm St, Phoenix, AZ, 85048	0.80	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased
CLM-415332	CLM	Nancy Boyd	1967-04-18	—	4295382034	—	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-428613	CLM	Shirley Reyes	1940-05-17	UHC-10284-93	5454095040	2986 Cedar Ln, Orlando, FL, 32883	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-428612	CLM	Shirley Reyes	1940-05-17	UHC-10284-93	5454095040	2986 Cedar Ln, Orlando, FL, 32883	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-408840	CLM	Carolyn Clark	2000-02-04	—	6964068014	7512 Meadow Ln, Tampa, FL, 33629	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-428311	CLM	Matthew I Nguyen	1999-02-14	—	3937281930	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-430058	CLM	Christine Phillips	1989-02-18	—	7283023079	3969 Hillcrest Rd, Gilbert, AZ, 85291	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-410307	CLM	Helen Phillips	1969-10-04	—	5747149073	1268 Church St, Scottsdale, AZ, 85207	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-402376	CLM	Austin Yang	1983-07-18	UHC-35695-44	8615822064	9563 River Rd, Los Angeles, CA, 90099	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-425257	CLM	Dogulas Yang	1997-01-04	UHC-45248-33	2302138050	6930 Lincoln Way, Fresno, CA, 93790	0.80	Phone reformatted Street suffix standardised Address re-cased Plan code upper-cased
CLM-422530	CLM	Mariana Rios	1962-04-19	UHC-75754-51	8695158736	—	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
CLM-422911	CLM	Bradley Rodriguez	1956-08-20	—	4422875080	6966 Canyon Rd, Tampa, FL, 33620	0.80	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed
CLM-426430	CLM	Carol King	1980-12-06	UHC-51452-61	6226563870	—	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Placeholder values cleared
CLM-410892	CLM	Hiroshi Munoz	1976-06-14	—	3346043875	7710 Elm St, Tampa, FL, 33620	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-406784	CLM	Robert Dunn	1969-08-27	—	3044965421	4219 Indian School Rd, Plano, TX	0.80	Date of birth reformatted Phone reformatted ZIP missing Placeholder values cleared

11,960 rows, page 154 of 240Previous Next