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 “Plan code upper-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagPlan code upper-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-413611	CLM	Gloria Burke	1981-11-07	UHC-56404-96	3933439367	8287 Valley View Dr, Tucson, AZ, 85728	0.92	Name re-cased Phone reformatted Plan code upper-cased Placeholder values cleared
CLM-432492	CLM	Roger Martinez	1990-03-15	UHC-40330-54	5044255946	6998 Cedar Ln, Phoenix, AZ, 85049	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-416841	CLM	Kimberly Henry	1990-03-27	—	—	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-426044	CLM	Russell Mendoza	1990-07-06	—	—	—	0.92	Date of birth reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-400664	CLM	Nicole Hamilton	1968-10-20	UHC-21000-52	—	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-408634	CLM	Susen D Reynolds	1966-09-20	UHC-74764-44	9374251094	2323 Camelback Rd, Las Vegas, NV, 89115	0.92	Phone reformatted City re-cased Plan code upper-cased Placeholder values cleared
CLM-423678	CLM	Adam B Griffin	1984-03-08	—	2058315730	—	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-411147	CLM	Noah Burns	2000-03-03	—	5035800367	7504 Broadway, Tampa, FL, 33687	0.92	Email lower-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-405169	CLM	Terry Williams	1974-12-27	—	—	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-416475	CLM	Roger Z Gutierrez	1975-02-25	UHC-01201-48	—	5417 Sunset Blvd, Los Angeles, CA, 90080	0.92	Name re-cased Date of birth reformatted Plan code upper-cased Placeholder values cleared
CLM-430797	CLM	Jacqueline Reyes	1961-02-08	UHC-83183-03	3416776370	—	0.92	Name re-cased Phone reformatted Plan code upper-cased Placeholder values cleared
CLM-409284	CLM	Janice Montgomery	2005-11-28	UHC-33646-35	—	5292 Union St, Jacksonville, FL, 32272	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-409288	CLM	Skott Johnston	1991-06-01	UHC-09585-03	—	8261 Pine Dr, San Diego, CA, 92181	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-425597	CLM	Kimberly Bryant	1999-01-19	UHC-33003-66	—	1902 Willow Ct, Dallas, TX, 75298	0.92	City re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-421933	CLM	Maria J Wells	2005-07-01	UHC-83588-76	—	2693 Highland Ave, Eden Prairie, MN, 55364	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-414941	CLM	Benjamin I Contreras	1980-06-23	—	9464555695	—	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-418796	CLM	Anna Hawkins	1960-01-26	UHC-90995-47	3525018254	—	0.92	Date of birth reformatted Phone reformatted Plan code upper-cased Placeholder values cleared
CLM-430904	CLM	Douglas Ellis	1981-09-08	UHC-82981-54	6889434064	—	0.92	Name re-cased Phone reformatted Plan code upper-cased Placeholder values cleared
CLM-405047	CLM	Paul U Garza	1981-06-15	—	—	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-422543	CLM	Jonathan Sanchez	2003-11-10	UHC-05896-07	—	—	0.92	Date of birth reformatted Member ID reformatted Plan code upper-cased Placeholder values cleared
CLM-418191	CLM	Jacqueline Adnrews	2000-03-06	—	—	2173 Oak St, Atlanta, GA, 30333	0.92	Date of birth reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-419628	CLM	Timothy Perry	2008-05-20	UHC-32260-32	8855819733	7814 Highland Ave, Miami, FL, 33136	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-429037	CLM	Sharon Stone	1949-09-05	UHC-07361-35	—	—	0.92	Date of birth reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-431737	CLM	Arthur Valdez	1996-08-18	—	4296674000	—	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-418471	CLM	Madison McCoy	1979-04-23	—	7418068186	—	0.92	Name re-cased Phone reformatted Plan code upper-cased Placeholder values cleared
CLM-412457	CLM	Cynthia X Dunn	1973-06-23	—	7412417191	5109 River Rd, Nashville, TN, 37230	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-403926	CLM	Wayne Henry	1983-09-06	UHC-55782-53	—	8107 Indian School Rd, Mesa, AZ, 85268	0.92	Name re-cased Date of birth reformatted Plan code upper-cased Whitespace trimmed
CLM-413872	CLM	Nicholas Bowman	1965-06-26	UHC-26614-77	9727230482	—	0.92	Name re-cased Phone reformatted Plan code upper-cased Whitespace trimmed
CLM-409754	CLM	Patriciia Phillips	1963-07-20	UHC-92486-54	8568847797	—	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-430884	CLM	Joshua D Stevens	1947-07-11	—	7107124016	—	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-422372	CLM	Jessica Sanchez	1948-10-19	UHC-54681-25	—	—	0.92	Date of birth reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-401162	CLM	Brenda T Bradley	1946-05-19	—	9604523025	7376 Bayshore Dr, Chandler, AZ, 85281	0.92	Name re-cased Phone reformatted Plan code upper-cased Placeholder values cleared
CLM-407581	CLM	Alice Murphy	1967-09-28	UHC-19582-46	3518854451	—	0.92	Date of birth reformatted Phone reformatted Plan code upper-cased Placeholder values cleared
CLM-410513	CLM	Brandon Sandovel	1947-03-07	UHC-30571-89	3475981600	5758 Baseline Rd, Minneapolis, MN, 55492	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-410514	CLM	Brandon Sandovel	1947-03-07	UHC-30571-89	3475981600	5758 Baseline Rd, Minneapolis, MN, 55492	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-412889	CLM	Ashley D Schmidt	1947-03-01	UHC-48601-56	8658408318	—	0.92	Name re-cased Phone reformatted Plan code upper-cased Placeholder values cleared
CLM-412079	CLM	Gregory T Moreno	1991-02-06	—	—	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-402735	CLM	Joseph Murphy	1956-01-11	—	—	—	0.92	Name re-cased Date of birth reformatted Plan code upper-cased Placeholder values cleared
CLM-413675	CLM	Carol Gutierrez	2000-09-08	—	8695427797	5447 Church St, Plano, TX, 75085	0.92	Name re-cased Phone reformatted Plan code upper-cased Placeholder values cleared
CLM-422171	CLM	Lori Robinson	1955-05-14	UHC-28139-43	9885457599	1793 Mountain View Dr, Tampa, FL, 33627	0.92	Name re-cased City re-cased Plan code upper-cased Whitespace trimmed
CLM-429752	CLM	Betty Burke	1966-02-08	UHC-91816-98	—	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-422345	CLM	Carolyn Brooks	1952-02-17	UHC-30493-05	—	1260 Harbor Blvd, Jacksonville, FL, 32257	0.92	Date of birth reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-422308	CLM	Camila Cox	1938-02-19	—	—	2807 Grand Ave, Las Vegas, NV, 89111	0.92	Date of birth reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-425988	CLM	Camila Herrera	1946-01-08	UHC-53583-98	4765411019	6176 Park Pl, Glendale, AZ, 85380	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-402446	CLM	Ethan Hughes	1959-03-09	UHC-73338-55	—	3985 Palm Dr, Tucson, AZ, 85755	0.92	Date of birth reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-423644	CLM	Daniel Lawrence	1953-09-12	UHC-08974-21	—	6349 Church St, Atlanta, GA, 30377	0.92	Date of birth reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-400249	CLM	Sofia Woods	1961-10-28	UHC-13736-25	—	6262 Forest Ave, Chandler, AZ, 85238	0.92	Date of birth reformatted State code upper-cased Plan code upper-cased Placeholder values cleared
CLM-419827	CLM	Cheryl Harper	1996-10-02	UHC-35989-19	5649933179	404 Lincoln Way, San Antonio, TX, 78233	0.92	Phone reformatted Member ID reformatted Plan code upper-cased Placeholder values cleared
CLM-429916	CLM	Melissa O Soto	1979-06-25	—	—	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-427729	CLM	Alexander Smith	1958-09-25	—	5583827401	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared

825 rows, page 14 of 17Previous Next