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

Enrollment, 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-112393	ENR	Stephanie J Freeman	1997-07-08	UHC-23974-43	4435742466	8960 Spring St, Chandler, AZ, 85294	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-118557	ENR	Jessca J Barnes	1985-08-04	UHC-72934-50	5478143272	2452 Oak St, Dallas, TX, 75209	0.82	Name re-cased State code upper-cased ZIP+4 trimmed
ENR-108441	ENR	Kyle A Grant	1997-06-08	UHC-70626-34	3268478840	9500 Ridge Rd, Nashville, TN, 37211	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-134344	ENR	Relph T Murpy	2001-05-06	UHC-70362-84	7227116748	5314 Palm Dr, Seattle, WA, 98110	0.82	Phone reformatted City re-cased ZIP+4 trimmed
ENR-123718	ENR	Alan R Duncan	1974-03-18	UHC-33937-60	6054312076	5209 Sunset Blvd, Nashville, TN, 37222	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-123719	ENR	Alan R Duncan	1974-03-18	UHC-33937-60	6054312076	5209 Sunset Blvd, Nashville, TN, 37222	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-113024	ENR	Jeremy James	1956-12-08	UHC-33338-98	3452840548	4486 Union St, Eden Prairie, MN, 55334	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
ENR-138550	ENR	Donna Cook	1944-02-16	UHC-09751-96	2563339851	599 Washington St, Fresno, CA, 93712	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-134929	ENR	Keith Jones	2001-01-08	UHC-44557-83	6936533210	3729 Broadway, Seattle, WA, 98141	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-138787	ENR	Alexis N Armstrong	2004-09-05	UHC-43400-99	4566033923	9668 Lincoln Way, Scottsdale, AZ, 85212	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-142861	ENR	Patricia Medina	1951-08-01	UHC-86701-57	6242505102	1703 Bayshore Dr, Gilbert, AZ, 85211	0.82	Phone reformatted City re-cased ZIP+4 trimmed
ENR-104088	ENR	Diego K Jones	1981-07-13	UHC-95688-46	4194872571	3014 Valley View Dr, Fresno, CA, 93746	0.82	Phone reformatted ZIP+4 trimmed Email lower-cased
ENR-110040	ENR	Jakob U Mills	1971-01-05	UHC-03929-94	6163873521	4896 Mountain View Dr, Houston, TX, 77034	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-105331	ENR	Mry B Washington	2007-02-22	UHC-15348-87	6513331242	6707 Willow Ct, Sacramento, CA, 95848	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-106110	ENR	Arjun F Auztin	1962-11-21	UHC-47172-58	7974787148	1298 Union St, Charlotte, NC, 28274	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-109547	ENR	Paul C Rayn	1986-03-27	UHC-46263-95	8749126902	1573 Lake View Rd, Glendale, AZ, 85328	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-123772	ENR	Kenneth Y Marshall	1977-11-20	UHC-46864-77	3942199966	1786 Willow Ct, Columbus, OH, 43226	0.82	Phone reformatted State code upper-cased ZIP+4 trimmed
ENR-126448	ENR	Luis T Kelley	2000-06-18	UHC-29471-91	5329500163	2091 Pine Dr, Eden Prairie, MN, 55377	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-105877	ENR	Wei Gardner	1971-04-01	UHC-94736-96	6495336650	7039 Apache Blvd, Columbus, OH, 43244	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-116562	ENR	Emma Baker	1968-04-15	UHC-96233-40	6517014956	4927 Cedar Ln, Minneapolis, MN, 55446	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
ENR-118053	ENR	Philip P Perkins	1985-11-14	UHC-26799-26	3898382283	1318 Spring St, Eden Prairie, MN, 55341	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-139576	ENR	Jose H Santos	1955-02-12	UHC-79188-27	—	7544 Apache Blvd, Seattle, WA, 98120	0.82	ZIP+4 trimmed Email lower-cased Whitespace trimmed
ENR-135277	ENR	Andrea Harper	1989-01-06	UHC-76420-19	5717521596	8990 Spring St, Fresno, CA, 93771	0.82	Name re-cased ZIP+4 trimmed Email lower-cased
ENR-122079	ENR	Lori J Cruz	1990-04-25	UHC-87156-17	9102112334	6582 Sage Ct, Eden Prairie, MN, 55387	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-114764	ENR	Donald V Russell	1974-02-22	UHC-63213-46	7492927220	5913 Maple Ave, Houston, TX, 77046	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed

3,951 rows, page 76 of 80Previous Next