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

All sources, flag “ZIP missing”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP missingClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-430137	CLM	Ronald U Butler	1971-07-18	UHC-23449-92	8394708174	6971 Lake View Rd, Las Vegas, NV	0.80	Date of birth reformatted ZIP missing 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
ENR-127274	ENR	Sue Q Vaqzuez	2005-09-06	UHC-65517-83	7918100949	4082 Camelback Rd, Minneapolis, MN	0.80	Date of birth reformatted Phone reformatted ZIP missing Placeholder values cleared
ENR-135580	ENR	Steven N Welch	2002-11-08	—	8193149122	4193 Market St, Los Angeles, CA	0.80	Date of birth reformatted Phone reformatted ZIP missing Whitespace trimmed
ENR-117603	ENR	Tyler X Dominguez	1982-11-27	UHC-61632-38	9122885514	7545 Canyon Rd, Nashville, TN	0.80	Name re-cased Phone reformatted ZIP missing Whitespace trimmed
CLM-430186	CLM	Runald Thomas	1999-03-07	UHC-18112-04	6868544321	700 Grand Ave, Los Angeles, CA	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
ENR-112741	ENR	William Q Robertson	2001-07-05	UHC-09716-52	2898298506	4166 Pine Dr, Gilbert, AZ	0.80	Name re-cased Phone reformatted ZIP missing Whitespace trimmed
TPA-60997	TPA	Joe Ramos	1969-08-23	—	—	6532 Mountain View Dr, San Antonio, TX	0.80	Name re-cased ZIP missing 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
ENR-130854	ENR	Peter Y Hernandez	1986-02-20	UHC-11079-43	8894600573	7574 Baseline Rd, Gilbert, AZ	0.80	Date of birth reformatted Phone reformatted City re-cased ZIP missing
ENR-125583	ENR	Peter Fields	1951-08-26	UHC-22629-71	3975399393	3175 Jefferson Ave, Eden Prairie, MN	0.80	Date of birth reformatted Phone reformatted City re-cased ZIP missing
CLM-413951	CLM	Abigail Romero	1978-01-03	—	—	4879 Desert Sky Blvd, San Antonio, TX	0.80	Date of birth reformatted City re-cased ZIP missing Placeholder values cleared
CLM-412962	CLM	Bryan Alvarez	1955-06-09	UHC-34162-31	9589694496	5263 Canyon Rd, Eden Prairie, MN	0.80	Name re-cased City re-cased ZIP missing Placeholder values cleared
ENR-114166	ENR	Lucia F Edwards	1970-06-17	UHC-42348-35	4374751530	6382 Jefferson Ave, Dallas, TX	0.80	Phone reformatted City re-cased ZIP missing Whitespace trimmed
CLM-420576	CLM	Willie Daniels	2006-11-01	—	—	604 Broadway, San Antonio, TX	0.80	Address re-cased ZIP missing Whitespace trimmed Placeholder values cleared
ENR-124978	ENR	Robert Hamilton	1945-06-04	UHC-63183-12	6295378477	4834 Jefferson Ave, Tempe, AZ	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared
PRV-27912	PRV	Alan Vega	1974-07-23	UHC-86604-43	9872276908	7471 Ocean Ave, Mesa, AZ	0.80	Phone reformatted ZIP missing Whitespace trimmed 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
ENR-126975	ENR	Sophia Le	2000-04-12	UHC-07226-46	7436655837	3641 Forest Ave, Dallas, TX	0.80	Name re-cased Phone reformatted Member ID reformatted ZIP missing
ENR-118483	ENR	Jason Cooper	1955-08-08	UHC-89789-03	4467080607	7903 Main St, Phoenix, AZ	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-100954	ENR	Larry Contreras	1982-04-15	UHC-12711-13	5988309403	5780 Lincoln Way, Tempe, AZ	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
PRV-21675	PRV	Kathleen Taylor	2004-01-06	—	3412996523	7201 Union St, Gilbert, AZ	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-126081	ENR	Fatima W Reed	1985-08-22	UHC-50785-10	4962488328	7651 Sage Ct, Minneapolis, MN	0.80	Date of birth reformatted Phone reformatted City re-cased ZIP missing
ENR-106620	ENR	Christine X Kelly	1951-10-08	UHC-16902-14	4626658256	1310 Main St, Atlanta, GA	0.80	Name re-cased State code upper-cased ZIP missing Whitespace trimmed
CLM-425393	CLM	Janet Payne	1992-07-08	UHC-51229-92	7036460010	2335 Camelback Rd, Mesa, AZ	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
CLM-423133	CLM	Bruce Jackson	1956-01-19	—	—	8460 Oak St, Jacksonville, FL	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
TPA-55269	TPA	Margaret Mendooza	2008-02-05	—	9565530815	678 Broadway, Plano, TX	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-120414	ENR	Angela Ward	2002-06-15	UHC-52024-35	5657977987	4207 Palm Dr, San Antonio, TX	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
CLM-408021	CLM	Carlos Stone	1982-01-01	—	—	3927 Lincoln Way, Atlanta, GA	0.80	Name re-cased City re-cased ZIP missing Placeholder values cleared
ENR-138476	ENR	Janet B Myers	1976-03-26	UHC-34234-73	3436329039	1433 Jefferson Ave, Jacksonville, FL	0.80	Name re-cased ZIP missing Email lower-cased Whitespace trimmed
CLM-403855	CLM	Anna L Armstrong	2002-07-05	UHC-24555-91	4383975442	2216 Willow Ct, Plano, TX	0.80	Name re-cased Date of birth reformatted ZIP missing Placeholder values cleared
TPA-54504	TPA	Edward Q Cole	1994-09-24	—	—	9543 Forest Ave, Fresno, CA	0.80	Name re-cased Date of birth reformatted ZIP missing Placeholder values cleared
ENR-104976	ENR	Susan B Kim	1987-02-04	UHC-90882-73	9385723040	9058 Camelback Rd, Minneapolis, MN	0.80	Phone reformatted ZIP missing Email lower-cased Whitespace trimmed
CLM-422160	CLM	Paul Romaro	1971-11-27	UHC-28842-64	—	8261 Harbor Blvd, Miami, FL	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
CLM-409517	CLM	Amanda Nunez	1973-09-04	UHC-71122-93	—	7796 Main St, Atlanta, GA	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
CLM-418561	CLM	Stephen Cox	1997-04-01	—	9453304929	9136 Broadway, San Antonio, TX	0.80	Phone reformatted Address re-cased ZIP missing Placeholder values cleared
PRV-23557	PRV	Raymond Moreno	1971-05-25	UHC-10088-57	2553943970	8655 Grand Ave, Orlando, FL	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
CLM-428098	CLM	Kathleen Hudson	1949-01-18	—	7937086911	7360 Church St, Miami, FL	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-122533	ENR	Jennifer Jimenez	1953-04-09	UHC-61935-26	6434196820	2631 Desert Sky Blvd, Phoenix, AZ	0.80	Name re-cased Phone reformatted ZIP missing Whitespace trimmed
ENR-130307	ENR	Santiago O Foster	1987-03-15	UHC-08857-93	7864705098	6861 Ridge Rd, Eden Prairie, MN	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-128357	ENR	Kathleen Lynch	1979-09-21	UHC-39030-53	2289098244	7652 Sage Ct, Austin, TX	0.80	Name re-cased Phone reformatted ZIP missing Whitespace trimmed
CLM-405264	CLM	Judith Armstrong	1987-10-18	UHC-17023-89	7363228520	7259 Pine Dr, Scottsdale, AZ	0.80	Name re-cased Date of birth reformatted ZIP missing Placeholder values cleared
CLM-431307	CLM	Amber Mills	1988-04-07	UHC-83923-02	4644549085	6809 River Rd, San Diego, CA	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
CLM-424027	CLM	Yuki Evans	1984-12-08	—	—	8031 Broadway, San Antonio, TX	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
CLM-405315	CLM	Samuel Diaz	1954-09-13	UHC-54213-52	—	1684 Oak St, Atlanta, GA	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
CLM-401520	CLM	Christopher Chen	1983-02-11	UHC-36761-10	—	7443 Main St, Chandler, AZ	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-109744	ENR	Keith Vazquze	1987-09-11	UHC-87562-79	6329315897	764 Camelback Rd, Charlotte, NC	0.80	Name re-cased Phone reformatted ZIP missing Whitespace trimmed
CLM-419327	CLM	Ann Hduson	1947-09-06	—	—	2748 Palm Dr, Eden Prairie, MN	0.80	Date of birth reformatted City re-cased ZIP missing Placeholder values cleared
ENR-131738	ENR	Katherine J Cox	2008-07-13	UHC-99478-30	4399238866	1424 Market St, Minneapolis, MN	0.80	Date of birth reformatted Phone reformatted ZIP missing Whitespace trimmed
CLM-414417	CLM	Ronald X Murray	1953-02-23	—	2799224710	1842 Meadow Ln, Gilbert, AZ	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared

7,146 rows, page 129 of 143Previous Next