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+4 trimmed”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP+4 trimmedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-142536	ENR	Alice Y McDonald	1993-09-23	UHC-21511-16	7092161458	4747 Elm St, Los Angeles, CA, 90057	0.82	Date of birth reformatted Member ID reformatted ZIP+4 trimmed
TPA-57848	TPA	Roger Nelson	1989-06-14	UHC-31937-38	—	1103 Desert Sky Blvd, Tucson, AZ, 85733	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
CLM-404866	CLM	Elizabeth Hawkins	1999-04-14	—	9709534215	8844 Maple Ave, Eden Prairie, MN, 55350	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-125987	ENR	Sophia I Myers	1945-07-23	UHC-31513-50	5278917616	3570 River Rd, San Antonio, TX, 78299	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
CLM-407219	CLM	Bobby Wang	1988-10-27	UHC-78541-97	8244797281	8463 Central Ave, Mesa, AZ, 85277	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-129684	ENR	Melissa Dean	1947-06-22	UHC-69799-61	7139706252	3888 Harbor Blvd, Phoenix, AZ, 85065	0.82	Phone reformatted City re-cased ZIP+4 trimmed
ENR-122848	ENR	Ana T Mason	1960-05-06	UHC-37551-83	3148898155	4563 Lincoln Way, Eden Prairie, MN, 55381	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
CLM-423091	CLM	Amber N Watkins	1976-10-16	—	—	9383 Baseline Rd, Tempe, AZ, 85292	0.82	ZIP+4 trimmed Email lower-cased Placeholder values cleared
TPA-55959	TPA	Ann G Simpson	1984-06-28	—	—	9591 Camelback Rd, Atlanta, GA, 30397	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-137341	ENR	Lisa B Yang	1971-07-13	UHC-51154-51	4563494508	5461 Valley View Dr, Seattle, WA, 98194	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
CLM-421392	CLM	Mariana Vasquez	1978-07-23	UHC-43094-42	—	3090 Canyon Rd, Dallas, TX, 75208	0.82	City re-cased ZIP+4 trimmed Placeholder values cleared
TPA-56430	TPA	Patrick D Wiilliamson	1971-11-13	—	—	105 Highland Ave, Miami, FL, 33162	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-54805	TPA	Charlotte Lee	1938-01-07	—	—	1687 Maple Ave, Columbus, OH, 43216	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-103399	ENR	Joyce Armstrong	1968-01-03	UHC-64475-41	5275559035	7518 Desert Sky Blvd, Houston, TX, 77024	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
CLM-405981	CLM	Luis K Reynolds	1946-04-03	UHC-81820-65	—	5142 Baseline Rd, Tucson, AZ, 85705	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-420869	CLM	Don N Hernandez	1976-04-09	UHC-18780-96	7905633254	8741 Union St, Orlando, FL, 32802	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-119956	ENR	Cynthia W Hughes	1952-03-22	UHC-65736-97	6802691383	2167 Union St, Tempe, AZ, 85230	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-101066	ENR	Jordan J Marquez	1992-05-14	UHC-73259-57	2878219461	6662 Palm Dr, Seattle, WA, 98187	0.82	Name re-cased City re-cased ZIP+4 trimmed
ENR-117384	ENR	Cynthia J Robinson	1980-09-09	UHC-24600-14	3562768027	9382 Lincoln Way, Austin, TX, 78739	0.82	ZIP+4 trimmed Plan code upper-cased Placeholder values cleared
CLM-410501	CLM	Christian Y Gibson	1999-04-16	—	7906028534	564 Bayshore Dr, Phoenix, AZ, 85088	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-419174	CLM	Russell C Cunningham	1971-02-19	—	—	4697 Sage Ct, Eden Prairie, MN, 55356	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-432372	CLM	Ana Mendoza	1983-03-07	—	—	2702 Lake View Rd, Atlanta, GA, 30307	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-108381	ENR	Brian Torres	1986-09-09	UHC-82191-10	—	9749 Lincoln Way, Columbus, OH, 43205	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-405655	CLM	Victoria Evans	1994-03-26	—	—	9661 Forest Ave, Houston, TX, 77068	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
TPA-54248	TPA	Ann Jecobs	1982-08-04	—	—	5062 Lake View Rd, Fresno, CA, 93738	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-140000	ENR	Evelyn Richardson	1945-01-07	UHC-13286-06	8315343327	5570 Maple Ave, Orlando, FL, 32877	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
TPA-50901	TPA	Ray Scott	1988-07-05	—	2233122221	7866 Lincoln Way, Denver, CO, 80228	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-116666	ENR	Jacob Pierce	1950-04-11	UHC-39294-12	6216545488	3638 Hillcrest Rd, Mesa, AZ, 85229	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
TPA-54534	TPA	Alice Marshall	1988-11-22	UHC-34390-28	6698641806	5036 Bayshore Dr, Plano, TX, 75009	0.82	Member ID reformatted ZIP+4 trimmed Placeholder values cleared
CLM-423844	CLM	Marcus Coleman	1964-04-27	UHC-67091-76	6195191216	9477 Highland Ave, Sacramento, CA, 95820	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-101826	ENR	Cheryl K Delgado	1945-11-19	UHC-94153-76	—	4867 Highland Ave, Las Vegas, NV, 89114	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-133219	ENR	Edward G Wood	1998-06-07	UHC-42271-24	6954383747	9185 Desert Sky Blvd, Glendale, AZ, 85344	0.82	Phone reformatted ZIP+4 trimmed Email lower-cased
PRV-20136	PRV	Vincent Espinoza	1986-11-16	—	7908805643	6278 Apache Blvd, Columbus, OH, 43266	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-108089	ENR	Jesse R Hudson	1980-07-05	UHC-11447-56	9543492522	9481 Baseline Rd, San Antonio, TX, 78290	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-142650	ENR	Russell Washington	1980-07-27	UHC-22282-40	2263158292	3675 Sunset Blvd, Sacramento, CA, 95874	0.82	ZIP+4 trimmed Email lower-cased Whitespace trimmed
TPA-58251	TPA	Christian James	1977-10-08	UHC-82723-91	—	9378 Oak St, Tempe, AZ, 85242	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-100145	ENR	Josh F Burke	1994-09-03	UHC-16651-46	3297627345	6405 Hillcrest Rd, Denver, CO, 80285	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-135114	ENR	Austin I Reynolds	1956-10-01	UHC-59055-39	8615918818	3810 Elm St, Tampa, FL, 33625	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
TPA-52754	TPA	Alexis L Rodriguez	1965-01-09	—	—	8359 Camelback Rd, Seattle, WA, 98199	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-141783	ENR	Mary A Lawrence	1974-11-24	UHC-37820-56	—	895 Indian School Rd, Houston, TX, 77051	0.82	ZIP+4 trimmed Email lower-cased Placeholder values cleared
CLM-428841	CLM	Samantha Bell	1970-12-02	—	—	5505 Church St, Tampa, FL, 33695	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-417750	CLM	Gerald Sandoval	1994-01-28	UHC-41043-56	—	1877 Mesa Dr, Mesa, AZ, 85212	0.82	Member ID reformatted ZIP+4 trimmed Placeholder values cleared
ENR-140163	ENR	Janet G Grant	1991-05-18	UHC-09003-41	4312737256	7089 Willow Ct, Los Angeles, CA, 90080	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-109355	ENR	Rogar Jackson	1949-04-16	—	2054284245	1992 Hillcrest Rd, Orlando, FL, 32843	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-138965	ENR	Robert Walker	1988-05-09	UHC-76321-65	6718262407	1063 Mesa Dr, San Antonio, TX, 78249	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
CLM-431553	CLM	Rebecca Payne	1939-03-10	—	—	1740 Union St, Nashville, TN, 37257	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-133730	ENR	Waltr Alexander	1973-02-12	UHC-88465-66	4545886205	7153 Lincoln Way, Gilbert, AZ, 85245	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-112897	ENR	Aisha Q Stewart	1943-12-10	UHC-59590-49	6523857271	2865 Apache Blvd, Chandler, AZ, 85291	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-126399	ENR	Mark U Lewis	1995-06-14	UHC-34718-55	3903113806	1859 Indian School Rd, Austin, TX, 78766	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
CLM-410933	CLM	Jesse D Warren	2008-11-17	UHC-51170-46	—	7100 Hillcrest Rd, Gilbert, AZ, 85243	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed

8,263 rows, page 158 of 166Previous Next