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 “Unit split from street”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagUnit split from streetClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-425974	CLM	Tyler Myers	1945-12-14	—	—	7937 River Rd # 960, Atlanta, GA, 30377	0.62	Name re-cased Unit split from street Street suffix standardised Address re-cased+3 more
CLM-414048	CLM	Mason Le	1954-04-12	—	6057531126	1454 Camelback Rd Apt 7, Glendale, AZ, 85361	0.62	Name re-cased Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-402572	CLM	Kayla Soto	1948-08-02	UHC-34616-97	—	5011 Harbor Blvd Apt 25, Fresno, CA, 93700	0.62	Name re-cased Member ID reformatted Unit split from street Street suffix standardised+3 more
CLM-410526	CLM	Ann W Hudson	1944-06-11	UHC-45319-60	4872690160	1546 Highland Ave # 211, Nashville, TN, 37278	0.62	Name re-cased Two-digit birth year Phone reformatted Member ID reformatted+3 more
CLM-428921	CLM	Andrea Griffin	1985-06-07	—	—	5822 Bayshore Dr Apt 1, Charlotte, NC, 28203	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-419028	CLM	Natalie Ramos	1958-04-23	—	7477556480	7803 Washington St Apt 2, Phoenix, AZ, 85046	0.62	Name re-cased Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-415108	CLM	Virginia Jackson	1958-05-09	UHC-96033-99	3025990288	1576 Oak St # 749, Austin, TX, 78774	0.62	Name re-cased Unit split from street Street suffix standardised Address re-cased+3 more
CLM-428994	CLM	Jack Pena	2004-03-20	—	6559910376	4207 Baseline Rd Apt 23, Phoenix, AZ, 85083	0.62	Name re-cased Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-404385	CLM	Gregory K Smith	1984-03-20	—	—	6641 Mesa Dr # 209, Seattle, WA, 98150	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-402037	CLM	Thomas Chavez	1959-01-21	UHC-08205-93	6396910334	6626 Market St # 710, Miami, FL, 33199	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-414044	CLM	Stephen L Lawson	1974-09-03	UHC-40167-97	8942114802	5405 Valley View Dr # 813, Denver, CO, 80244	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-430132	CLM	Zachary W Harvey	1982-02-22	UHC-43673-22	—	7636 Canyon Rd Apt 15, Miami, FL, 33176	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-403556	CLM	Marilyn G Hayes	1971-05-03	UHC-81234-76	7412004925	9800 Grand Ave Apt 30, Charlotte, NC, 28207	0.62	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-431418	CLM	Joan Elliott	1983-05-03	—	—	8888 Central Ave Apt 27, Miami, FL, 33158	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-431419	CLM	Joan Elliott	1983-05-03	—	—	8888 Central Ave Apt 27, Miami, FL, 33158	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-401705	CLM	Sean Nunez	1997-10-03	UHC-98948-59	—	4431 Forest Ave # 376, Fresno, CA, 93704	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-406096	CLM	Alan Tran	1970-06-06	UHC-55420-11	—	7475 Valley View Dr Apt 21, Nashville, TN, 37292	0.62	Member ID reformatted Unit split from street Street suffix standardised Address re-cased+3 more
CLM-421538	CLM	Charles Payne	1954-10-06	UHC-44575-47	2646873784	4594 Ocean Ave Apt 3, Atlanta, GA, 30368	0.62	Date of birth reformatted Phone reformatted Member ID reformatted Unit split from street+3 more
CLM-405012	CLM	Eugene Romero	1966-01-01	—	7629913511	4701 Oak St # 253, Jacksonville, FL	0.62	Name re-cased Phone reformatted Unit split from street City re-cased+3 more
CLM-417807	CLM	Gregory Smith	1980-08-27	UHC-84719-85	2843201062	9597 Sage Ct # 467, Charlotte, NC, 28267	0.62	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-423830	CLM	Elijah Day	1964-05-06	UHC-27074-93	9622866486	6639 Union St # 625, San Antonio, TX, 78255	0.62	Name re-cased Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-428693	CLM	Lucia Rios	1938-04-02	UHC-92720-51	—	5436 Camelback Rd # 958, Denver, CO, 80248	0.62	Name re-cased Unit split from street Street suffix standardised Address re-cased+3 more
CLM-405389	CLM	Andrew Gutierrez	1981-04-13	UHC-30348-83	—	7873 Cedar Ln Apt 28, Los Angeles, CA, 90061	0.62	Name re-cased Member ID reformatted Unit split from street Street suffix standardised+3 more
CLM-423673	CLM	Albert Santos	1975-05-16	—	7459294057	2445 Church St Apt 39, Jacksonville, FL, 32229	0.62	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-421100	CLM	Ryan Li	1963-09-10	—	2393549599	5648 Elm St # 719, Fresno, CA, 93735	0.62	Name re-cased Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-421169	CLM	Priya Ortega	1998-10-25	—	—	2401 Park Pl # 271, Charlotte, NC, 28297	0.62	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+3 more
CLM-408864	CLM	Jerry Crawford	1980-07-03	UHC-60376-73	9117180729	7106 Jefferson Ave # 683, Jacksonville, FL, 32219	0.62	Name re-cased Phone reformatted Member ID reformatted Unit split from street+3 more
CLM-400462	CLM	David Coleman	1950-03-23	—	7444465866	2925 Main St # 565, Scottsdale, AZ, 85286	0.62	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-415746	CLM	Doonald Murrray	2001-12-17	UHC-38778-25	—	7821 Lincoln Way # 717, Sacramento, CA, 95825	0.62	Name re-cased Member ID reformatted Unit split from street City re-cased+3 more
CLM-407106	CLM	Maria Collins	1938-11-13	UHC-92321-89	6362104997	9590 Central Ave # 804, Mesa, AZ, 85261	0.62	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+3 more
CLM-400214	CLM	Lori Parker	1949-09-28	UHC-06551-05	2927735526	5635 Elm St Apt 2, Chandler, AZ, 85238	0.62	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-429452	CLM	Melissa Burns	1981-06-05	UHC-05550-71	—	5052 Willow Ct Apt 30, Gilbert, AZ, 85218	0.62	Name re-cased Date of birth reformatted Unit split from street City re-cased+3 more
CLM-405099	CLM	Marilyn Romero	1954-08-02	UHC-22595-40	—	2973 Main St # 195, Eden Prairie, MN, 55338	0.62	Name re-cased Member ID reformatted Unit split from street Street suffix standardised+3 more
CLM-405098	CLM	Marilyn Romero	1954-08-02	UHC-22595-40	—	2973 Main St # 195, Eden Prairie, MN, 55338	0.62	Name re-cased Member ID reformatted Unit split from street Street suffix standardised+3 more
CLM-419565	CLM	Andrea Russell	1944-08-16	UHC-54510-32	—	8847 Apache Blvd # 841, Plano, TX, 75059	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-426500	CLM	Gregory Alvraez	1982-03-27	—	2565908925	1067 Oak St Apt 2, Tempe, AZ, 85229	0.62	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-410403	CLM	Michael Willis	1983-03-07	—	9113124229	6056 Lake View Rd # 511, Las Vegas, NV, 89157	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-429708	CLM	Stephen Harris	1981-05-01	UHC-18032-11	—	9649 River Rd # 128, Chandler, AZ, 85246	0.62	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+3 more
CLM-420991	CLM	Gregory Contreras	1990-10-04	UHC-39315-75	8263552504	5978 Mesa Dr # 834, Tampa, FL, 33630	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-428675	CLM	Joe Perry	1940-12-09	UHC-87923-85	5905279824	4480 Willow Ct Apt 16, Denver, CO, 80275	0.62	Name re-cased Unit split from street Street suffix standardised Address re-cased+3 more
CLM-409718	CLM	Aisha Baker	1944-03-19	UHC-54571-05	2258031079	5994 Indian School Rd Apt 16, Charlotte, NC, 28210	0.62	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-426390	CLM	Debra Sullivan	2002-06-28	UHC-69005-94	8518981416	9094 Union St # 225, San Diego, CA, 92148	0.62	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-429546	CLM	Jacob C Coleman	1952-08-26	—	2623414306	7965 Palm Dr # 931, Jacksonville, FL, 32268	0.62	Name re-cased Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-401536	CLM	McIhael Fields	1969-09-14	UHC-13912-97	—	332 Baseline Rd Apt 6, Tucson, AZ, 85756	0.62	Name re-cased Unit split from street Street suffix standardised Address re-cased+3 more
CLM-418578	CLM	Keith Hicks	1951-08-22	—	—	6882 Oak St # 524, Eden Prairie, MN, 55316	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-412340	CLM	Russell D Carter	1940-10-16	UHC-58996-04	7005991659	1066 Main St Apt 21, Fresno, CA, 93705	0.62	Phone reformatted Member ID reformatted Unit split from street Street suffix standardised+3 more
CLM-416996	CLM	Abby H Gomez	1954-05-20	UHC-76184-54	2342380498	9733 Apache Blvd Apt 37, Tempe, AZ, 85256	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-421314	CLM	Emma Hayes	1947-11-22	UHC-08659-93	—	7363 Cedar Ln # 368, Charlotte, NC, 28215	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-424261	CLM	Lawrence Carpenter	1948-04-25	UHC-02642-89	6622215798	132 Valley View Dr # 304, Columbus, OH, 43281	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-429593	CLM	Austin Parker	1952-07-03	UHC-47167-07	—	3166 Spring St # 887, Miami, FL, 33123	0.62	Name re-cased Unit split from street Street suffix standardised Address re-cased+3 more

2,038 rows, page 19 of 41Previous Next