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-422459	CLM	Shirley Baker	1984-05-13	UHC-45715-13	3837270329	—	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-431856	CLM	Natalie Daniels	1951-11-18	UHC-67354-43	6543049510	1690 Pine Dr, Eden Prairie, MN, 55375	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-402610	CLM	Maria U Smith	1953-10-16	UHC-01303-13	3393999416	9547 Cedar Ln, Nashville, TN, 37202	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-412474	CLM	Cheryl Pierce	1939-01-25	UHC-79286-56	2996266409	7454 Union St, Charlotte, NC, 28247	0.78	Date of birth reformatted Phone reformatted State code upper-cased ZIP+4 trimmed+1 more
CLM-421089	CLM	Roger Thomas	1953-10-06	UHC-41176-15	8967664439	—	0.78	Phone reformatted Member ID reformatted Gender normalised Whitespace trimmed+1 more
CLM-406457	CLM	Catherine Nguyen	1998-09-22	UHC-20991-26	9423799253	4832 Main St Apt 6, San Antonio, TX, 78265	0.78	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed+1 more
CLM-402360	CLM	Wayne McDonald	1994-04-18	—	3504933614	6884 Lincoln Way, Los Angeles, CA, 90017	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-416524	CLM	Beverly Mendoza	2008-09-20	UHC-46120-86	4572721300	9052 Desert Sky Blvd, Tampa, FL, 33662	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-417451	CLM	Kenneth Mason	1962-08-27	UHC-03925-28	2707546714	8342 Washington St, Charlotte, NC, 28233	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-418208	CLM	Juan Tucker	1956-04-19	UHC-20590-80	8943112412	732 Valley View Dr, Atlanta, GA, 30361	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-401463	CLM	Gerald Roberts	1971-08-19	UHC-67087-61	8499643728	4789 Baseline Rd, Seattle, WA, 98156	0.78	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
CLM-409021	CLM	Mei Mejia	1987-08-02	UHC-42573-98	6409461791	1454 Mesa Dr, Fresno, CA, 93722	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-412280	CLM	Justin Padilla	1991-01-05	UHC-89279-40	8173599085	822 Highland Ave, Jacksonville, FL, 32282	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-412848	CLM	Kathleen Butler	1997-07-03	—	5743413084	7271 Jefferson Ave, Jacksonville, FL, 32263	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-419036	CLM	Becky Williams	1980-04-20	UHC-32568-63	9349285863	1967 Union St, Charlotte, NC, 28278	0.78	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-413795	CLM	Denise Ortega	2006-09-20	—	5596106358	7305 Maple Ave, Seattle, WA, 98162	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-416302	CLM	Philip Watson	1968-01-28	UHC-44423-90	8264190894	1330 Maple Ave, Houston, TX, 77048	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-432576	CLM	Melissa Alen	1954-02-25	UHC-41301-70	8376521130	—	0.78	Two-digit birth year Phone reformatted Email lower-cased Whitespace trimmed+1 more
CLM-421326	CLM	Martha Silva	1999-10-03	—	4559877433	313 Main St, Chandler, AZ, 85257	0.78	Date of birth reformatted Phone reformatted State name converted to code Whitespace trimmed+1 more
CLM-428254	CLM	Linda Arnold	2006-09-02	UHC-08033-27	3327740177	6989 Forest Ave, Charlotte, NC, 28267	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-432382	CLM	Kelly King	—	—	8112433331	2448 Broadway, Nashville, TN, 37233	0.78	Name re-cased Date of birth unreadable Phone reformatted Address re-cased+1 more
CLM-418805	CLM	Heather Z Williamson	1954-09-11	UHC-16635-25	9093592363	3052 Valley View Dr, Chandler, AZ, 85241	0.78	Phone reformatted Member ID reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-418806	CLM	Heather Z Williamson	1954-09-11	UHC-16635-25	9093592363	3052 Valley View Dr, Chandler, AZ, 85241	0.78	Phone reformatted Member ID reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-429346	CLM	Joyce Spencer	1967-09-14	UHC-65674-90	3148639728	9339 Oak St, Eden Prairie, MN, 55317	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-425781	CLM	Albert Sanders	1975-04-25	UHC-20970-55	6986405762	7144 Market St, Las Vegas, NV, 89114	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-409133	CLM	Don T Tayllor	2000-01-13	—	7222985698	1401 Hillcrest Rd, Miami, FL, 33106	0.78	Name re-cased Two-digit birth year Phone reformatted State code upper-cased+1 more
CLM-414120	CLM	Zachary Riley	1957-11-26	UHC-92442-40	8716610553	3916 Main St, Las Vegas, NV, 89163	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-415268	CLM	Katherine Reynolds	1943-04-06	UHC-99813-94	2264451946	9140 Elm St, Seattle, WA, 98115	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-400388	CLM	Maria Dominguez	1997-08-23	UHC-24070-78	8515428995	5877 Lake View Rd, Mesa, AZ, 85266	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-400387	CLM	Maria Dominguez	1997-08-23	UHC-24070-78	8515428995	5877 Lake View Rd, Mesa, AZ, 85266	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-432511	CLM	Susan G Perez	1938-06-23	UHC-09172-06	8805255677	—	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-431386	CLM	Kimberly Mills	1955-12-07	UHC-05503-20	8016234112	9137 Main St, Gilbert, AZ, 85208	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-401704	CLM	Virginia Castillo	1992-06-06	UHC-00947-15	7614498180	6133 Canyon Rd, Los Angeles, CA, 90090	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-403536	CLM	Joyce Wang	1980-08-14	—	3296635105	2091 Pine Dr, Tucson, AZ, 85787	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
CLM-420492	CLM	Alan Powell	1986-10-20	UHC-61794-36	7382050511	4543 Harbor Blvd, San Antonio, TX, 78203	0.78	Date of birth reformatted Phone reformatted City re-cased State name converted to code+1 more
CLM-430765	CLM	Carolyn D Simmons	1960-04-05	UHC-93810-96	8766516529	7621 Camelback Rd, Jacksonville, FL, 32270	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-421329	CLM	Rebecca Mitchell	1963-12-03	—	6237979279	8905 Canyon Rd, Plano, TX	0.78	Name re-cased Phone reformatted ZIP missing Email lower-cased+1 more
CLM-413297	CLM	Gary Miller	1993-04-20	UHC-58590-92	2112920633	4974 Union St, Miami, FL, 33144	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-416431	CLM	Ann Luna	2007-08-13	UHC-70271-69	9158627196	6600 Hillcrest Rd, Tucson, AZ, 85711	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-425251	CLM	Marilyn Mills	1958-04-07	UHC-97613-50	2392064253	837 Jefferson Ave, Mesa, AZ, 85237	0.78	Date of birth reformatted Phone reformatted City re-cased Gender normalised+1 more
CLM-425449	CLM	Judy Snyder	2001-04-21	—	9553458882	4775 Baseline Rd, Austin, TX, 78741	0.78	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed+1 more
CLM-424909	CLM	Scott Roero	1949-12-11	—	8605180711	9688 Spring St, Seattle, WA, 98188	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-403847	CLM	Fatima Green	1971-01-19	UHC-56858-96	8975855235	764 River Rd, Minneapolis, MN, 55442	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-427881	CLM	Ana Barnes	1983-04-19	UHC-47145-41	8869763314	4649 Pine Dr, Columbus, OH, 43286	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-428392	CLM	Jeremy Mason	1962-12-28	UHC-67531-66	8153981570	4853 Apache Blvd, Jacksonville, FL, 32253	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-410447	CLM	Diane Burke	2005-07-17	UHC-64090-94	8889678215	4779 Union St, Denver, CO, 80222	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-420344	CLM	David R Yang	1947-05-10	UHC-30445-94	3884721360	1680 Jefferson Ave, Nashville, TN, 37270	0.78	Date of birth reformatted Phone reformatted State name converted to code Whitespace trimmed+1 more
CLM-429690	CLM	Sharon D Burke	2001-12-20	—	3514196066	655 Harbor Blvd, Glendale, AZ, 85344	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-409785	CLM	Mariana Q Stevens	1967-07-19	—	8007454249	2593 Main St, Minneapolis, MN, 55471	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-418385	CLM	David Larson	1986-04-27	—	5044796623	5735 Valley View Dr, Houston, TX, 77007	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more

11,960 rows, page 137 of 240Previous Next