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 “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-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
CLM-405734	CLM	Beverly Hughes	1988-06-28	—	—	3148 Cedar Ln, Plano, TX, 75003	0.64	Name re-cased SSN last four extracted Street suffix standardised Address re-cased+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
PRV-23490	PRV	Andrew Lee	1991-10-06	—	—	9648 Grand Ave, Eden Prairie, MN, 55342	0.64	Name re-cased SSN last four extracted Street suffix standardised Address re-cased+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
CLM-420564	CLM	Vincent Gutieerrez	1950-01-08	—	8202806153	5152 Washington St, Orlando, FL, 32829	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+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
TPA-58720	TPA	Sofia Wood	1956-04-13	—	4432864696	297 Oak St, Sacramento, CA, 95841	0.64	Name re-cased 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
CLM-418038	CLM	Brandun Gilbert	1979-12-13	UHC-89487-07	4802218044	2482 Market St, Phoenix, AZ, 85021	0.64	Name split from “Last, First”Phone reformatted Member ID reformatted SSN last four extracted+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
CLM-418074	CLM	Kelly Powell	1984-05-14	UHC-57639-35	—	1647 Oak St, Gilbert, AZ, 85212	0.64	Date of birth reformatted Member ID reformatted SSN last four extracted Street suffix standardised+2 more
TPA-59068	TPA	Scott Thomas	1970-07-24	—	7134747562	2385 Park Pl, Eden Prairie, MN, 55374	0.64	SSN last four extracted Street suffix standardised Address re-cased City re-cased+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
PRV-29217	PRV	Jusitn Coleman	1977-12-02	—	8784173750	6753 Baseline Rd, San Diego, CA, 92138	0.64	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+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
CLM-405306	CLM	Denise Sandoval	1990-02-16	—	—	7820 Jefferson Ave, Houston, TX, 77097	0.64	SSN last four extracted Street suffix standardised Address re-cased City re-cased+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
CLM-403911	CLM	Donna Griffin	1944-10-13	—	4248572041	9479 Pine Dr, Chandler, AZ, 85257	0.64	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+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
CLM-426249	CLM	Wayne Hunt	1959-02-25	UHC-34787-44	6206361503	8367 Willow Ct, Tucson, AZ, 85769	0.64	Phone reformatted SSN last four extracted City re-cased State name converted to code+2 more
TPA-58183	TPA	Kayla Cunningham	1964-01-07	—	—	8778 Cedar Ln, Atlanta, GA, 30356	0.64	SSN last four extracted Street suffix standardised Address re-cased Email lower-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
TPA-60449	TPA	Wei Powell	1941-11-23	—	7154287219	4263 Cedar Ln, Glendale, AZ, 85343	0.64	Name re-cased Phone reformatted SSN last four extracted Gender normalised+2 more
CLM-418280	CLM	Beerly Moreno	1956-04-28	—	2828058561	—	0.64	Name split from “Last, First”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
CLM-414892	CLM	Fatima S Soto	1993-08-20	UHC-71122-66	—	8728 Sage Ct, Columbus, OH, 43230	0.64	SSN last four extracted Street suffix standardised Address re-cased Plan code upper-cased+2 more
PRV-24419	PRV	Gerald Tucker	1941-04-21	UHC-93483-60	—	3156 Canyon Rd, Tucson, AZ, 85768	0.64	Name re-cased SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-130607	ENR	Nicole Arnold	1979-05-10	UHC-18919-15	5623336184	—	0.64	Date of birth reformatted Phone reformatted SSN last four extracted Email lower-cased+2 more
ENR-115761	ENR	Sophia O Dixon	1938-03-10	UHC-10387-52	5022621731	3158 Spring St, Mesa, AZ, 85256	0.64	SSN last four extracted Street suffix standardised Address re-cased Email lower-cased+2 more
CLM-416313	CLM	Kathy W Johnston	1964-01-05	—	6596069361	5071 Elm St, Miami, FL, 33109	0.64	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+2 more

2,817 rows, page 33 of 57Previous Next