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 “SSN last four extracted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagSSN last four extractedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-117385	ENR	Joseph Moore	1979-07-15	UHC-56193-25	3568914993	9013 Oak St, Tempe, AZ, 85281	0.64	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-105552	ENR	Donna B Williams	1984-06-25	UHC-10270-99	4252314592	5938 Ridge Rd, Glendale, AZ, 85390	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-112168	ENR	Evelyn P Tran	1960-04-17	UHC-24151-63	3892116436	2554 Park Pl, Seattle, WA, 98165	0.64	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-106911	ENR	Sophia Rojas	1998-07-08	UHC-02551-98	—	2983 Canyon Rd, Columbus, OH, 43274	0.64	Name re-cased SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-109249	ENR	Danielle N Pierce	1956-11-16	UHC-91432-68	7716846961	5592 Ocean Ave, Atlanta, GA, 30328	0.64	Phone reformatted SSN last four extracted ZIP+4 trimmed Email lower-cased+2 more
ENR-119018	ENR	Logan O Bailey	1976-05-22	UHC-29079-85	7702634606	9114 Grand Ave, San Diego, CA, 92136	0.64	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-119080	ENR	Aisha R Wright	1949-02-26	UHC-95172-81	—	3424 Spring St, Plano, TX	0.64	Date of birth reformatted Member ID reformatted SSN last four extracted ZIP missing+2 more
ENR-112301	ENR	Ryan Webb	1948-09-17	UHC-74733-63	9635849000	1242 Main St, Tempe, AZ, 85274	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-141397	ENR	Victoria Y Jimenez	2004-10-13	UHC-81928-43	4733961226	4112 Baseline Rd, Scottsdale, AZ, 85275	0.64	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-140616	ENR	Megan I Montgomery	1958-12-25	UHC-67886-41	3756610109	3088 Ocean Ave, Tempe, AZ, 85264	0.64	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-132267	ENR	Hannah Cooper	1945-03-20	UHC-05330-12	8547649675	6186 Ocean Ave, Denver, CO, 80205	0.64	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-130808	ENR	Scott Marshall	1985-02-16	UHC-57608-82	7816414872	—	0.64	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+2 more
ENR-120066	ENR	Philip A Grant	1990-09-27	UHC-64888-16	2138635170	5762 Main St, Mesa, AZ, 85227	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-110753	ENR	Ryan Graham	1972-07-09	UHC-26938-57	3389643307	2179 River Rd, Denver, CO, 80267	0.64	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-120112	ENR	Teresa Y Soto	1938-09-08	UHC-48969-60	4187460156	5777 Hillcrest Rd, San Diego, CA, 92113	0.64	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-103502	ENR	Fox S Christopher	1950-04-28	UHC-01934-28	3226692546	3691 Hillcrest Rd Apt 21, Atlanta, GA, 30320	0.64	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+2 more
ENR-123237	ENR	Nancy T Williams	1983-09-13	UHC-38414-77	3487983527	4029 Harbor Blvd, Dallas, TX, 75225	0.64	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+2 more
ENR-102292	ENR	Sofia Huunt	2008-11-28	UHC-72477-47	3799944854	7726 Lake View Rd, Scottsdale, AZ, 85228	0.64	Name re-cased Phone reformatted SSN last four extracted State name converted to code+2 more
ENR-128004	ENR	Virginia Clark	1956-11-05	UHC-07844-60	3832297394	8280 Forest Ave, Phoenix, AZ, 85031	0.64	Name re-cased Phone reformatted SSN last four extracted State name converted to code+2 more
ENR-131898	ENR	Harold Maldonado	2006-01-22	UHC-69610-54	4697438061	3571 Market St, Eden Prairie, MN, 55329	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-109177	ENR	Judith Hamilton	1971-03-26	UHC-67396-73	8609681024	7220 Spring St, Phoenix, AZ, 85024	0.64	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-123642	ENR	Aisha R Foster	1969-01-06	UHC-20002-70	2402028566	4862 Hillcrest Rd, Phoenix, AZ, 85007	0.64	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-128888	ENR	George R Mason	1966-06-26	UHC-26062-32	9454153720	4247 Desert Sky Blvd, Charlotte, NC, 28235	0.64	Name re-cased Date of birth reformatted SSN last four extracted Street suffix standardised+2 more
ENR-135309	ENR	Janice P Deen	1946-09-22	UHC-65929-04	8505789091	2334 Desert Sky Blvd, Seattle, WA, 98127	0.64	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-107995	ENR	Katherine Z Oliver	1946-05-24	UHC-76825-62	6787616686	348 Jefferson Ave, Denver, CO, 80297	0.64	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-135875	ENR	Dennis Dean	1939-08-27	UHC-16691-43	4809281198	7382 River Rd, Tampa, FL, 33684	0.64	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-130868	ENR	Olivia F Day	1963-05-16	UHC-80025-41	9422536990	364 Spring St, Dallas, TX, 75295	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-103703	ENR	Luuis Payne	1986-12-14	UHC-63005-41	—	8681 Park Pl, Fresno, CA, 93788	0.64	Name re-cased Date of birth reformatted SSN last four extracted Street suffix standardised+2 more
ENR-127259	ENR	Jack Ray	1955-10-24	UHC-59604-32	—	7181 Cedar Ln, Plano, TX, 75096	0.64	Name re-cased SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-118267	ENR	Frances Q Ellis	2003-10-12	UHC-18452-31	4442219244	4293 Highland Ave, Denver, CO, 80201	0.64	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-135153	ENR	George Ford	1991-12-01	UHC-72353-72	4648132727	8138 Spring St, Scottsdale, AZ, 85280	0.64	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-126640	ENR	Diane I Ray	1967-12-16	UHC-21870-71	4374194994	5152 Forest Ave, Mesa, AZ, 85261	0.64	Name split from “Last, First”Phone reformatted SSN last four extracted Plan code upper-cased+2 more
ENR-130023	ENR	Mei Cole	1984-05-17	UHC-63014-89	2417814083	5267 Park Pl, Scottsdale, AZ, 85271	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-119903	ENR	Ana L Webb	2002-09-28	UHC-90823-82	—	6431 Desert Sky Blvd, Tampa, FL, 33641	0.64	Name re-cased Date of birth reformatted SSN last four extracted Street suffix standardised+2 more
ENR-122512	ENR	Hannah N Graham	2005-01-26	UHC-42390-49	9195974421	3757 Meadow Ln, Eden Prairie, MN, 55364	0.64	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-101096	ENR	Alexis Carlson	1947-08-07	UHC-56124-47	5384146927	9327 Camelback Rd, Eden Prairie, MN, 55328	0.64	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+2 more
ENR-128734	ENR	Larry Patel	1955-07-27	UHC-83681-38	2774072746	8603 Meadow Ln, Tampa, FL, 33643	0.64	Name re-cased Two-digit birth year Phone reformatted SSN last four extracted+2 more
ENR-107833	ENR	Mary F Garrett	1997-05-15	UHC-41408-06	3553547487	5195 Maple Ave, Tempe, AZ, 85265	0.64	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-125196	ENR	Jacob A Espinoza	1942-06-20	UHC-07841-77	5704838208	2984 Desert Sky Blvd, Tempe, AZ, 85233	0.64	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-117287	ENR	Luis Herrera	1979-04-01	UHC-39380-74	2793768068	1179 Cedar Ln, Orlando, FL, 32876	0.64	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-104897	ENR	Bryan A Guerrero	1988-06-06	UHC-91293-76	3005780486	7948 Ridge Rd, Sacramento, CA, 95888	0.64	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+2 more
ENR-100869	ENR	Juan X Medina	1982-03-10	UHC-23688-32	9688417232	612 Ridge Rd, Denver, CO, 80207	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-111285	ENR	Robetr V Greene	1992-07-26	UHC-26139-06	7046929979	6881 Meadow Ln, Tampa, FL, 33641	0.64	Name re-cased Member ID reformatted SSN last four extracted Street suffix standardised+2 more
ENR-115900	ENR	Arthur G Warren	1957-09-17	UHC-86622-12	5265263860	952 Broadway, Chandler, AZ, 85296	0.64	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+2 more
ENR-101888	ENR	Amanda Marshall	1952-06-22	UHC-03865-31	9524022435	1064 Ocean Ave, Gilbert, AZ, 85283	0.64	Name re-cased SSN last four extracted City re-cased State name converted to code+2 more
ENR-113058	ENR	Diane Burtton	1938-03-23	UHC-07727-34	3157840228	9214 Central Ave, Plano, TX, 75046	0.64	Phone reformatted Member ID reformatted SSN last four extracted Street suffix standardised+2 more
ENR-105138	ENR	Ralph W Garza	1947-08-28	UHC-69417-14	9834411893	3855 Jefferson Ave, Charlotte, NC, 28271	0.64	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-132776	ENR	Joan Fowler	1983-10-14	UHC-85183-78	7126109526	7025 Sage Ct, Fresno, CA, 93722	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-134647	ENR	Sara Kim	1961-11-19	UHC-68327-33	7987848136	4384 Meadow Ln, Tempe, AZ, 85239	0.64	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+2 more
ENR-110425	ENR	Christine L Porter	1938-01-27	UHC-26384-27	5587700292	1809 Desert Sky Blvd, Tempe, AZ, 85242	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more

1,767 rows, page 22 of 36Previous Next