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 “Name re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagName re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-131857	ENR	Cynthia Ray	1952-08-09	UHC-95030-16	2423345231	5099 Ocean Ave, Sacramento, CA, 95899	0.64	Name re-cased Street suffix standardised Address re-cased State name converted to code+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-121527	ENR	Zachary K Evans	1960-01-17	UHC-55762-90	3896581725	1240 Palm Dr, Miami, FL, 33182	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-129854	ENR	Bruce W Wells	1978-11-17	UHC-75374-68	5457998325	7373 Pine Dr Apt 23, Charlotte, NC, 28233	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-102914	ENR	Vazquez Ana	1950-08-01	UHC-27900-79	—	9588 Highland Ave, Gilbert, AZ, 85295	0.64	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-125922	ENR	Dorothy Lwarence	1966-04-11	UHC-04711-59	4442115814	1167 Canyon Rd, Los Angeles, CA, 90087	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-139616	ENR	Philip Olson	2007-09-07	UHC-22797-90	8858086728	4297 Indian School Rd, Nashville, TN, 37257	0.64	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+2 more
ENR-108254	ENR	Donald W Walsh	1951-05-07	UHC-49555-07	8584013690	7131 Spring St, Denver, CO, 80243	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-124566	ENR	Pamela Syms	2003-07-07	UHC-11226-34	6417452159	6354 Bayshore Dr, Los Angeles, CA, 90064	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-105028	ENR	Donald Garrett	1953-09-19	UHC-03929-65	—	6376 Washington St, Tampa, FL, 33656	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-120915	ENR	Beverly M Williams	1970-08-09	UHC-94161-98	7144683368	2802 Canyon Rd, Scottsdale, AZ, 85251	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-118259	ENR	Julie K Moragn	1943-06-26	UHC-64210-57	5436177281	1606 Baseline Rd, Gilbert, AZ, 85223	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-120483	ENR	Douglas R Marshall	1970-08-19	UHC-48557-75	9879326371	534 Market St, Columbus, OH, 43252	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-111105	ENR	Jacqueline F Adams	1996-06-09	UHC-65215-45	4517223182	5404 Spring St, Houston, TX, 77067	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-119649	ENR	Jessica Cook	2004-07-07	UHC-84109-26	9496370799	2137 Camelback Rd, Glendale, AZ, 85348	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-129362	ENR	Abigail E Sanders	1975-03-11	UHC-08668-77	—	9314 Baseline Rd, Tucson, AZ, 85746	0.64	Name re-cased Phone missing area code Street suffix standardised Address re-cased+2 more
ENR-111493	ENR	Yuki Y Miller	1954-04-26	—	6075205023	1468 Apache Blvd # 946, Miami, FL, 33139	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-100829	ENR	Gary J Gutierrez	1993-12-06	UHC-65560-71	3813418968	3140 Canyon Rd, Sacramento, CA, 95894	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-142846	ENR	Maria K Santos	1979-04-06	UHC-67746-83	3485020959	3088 Desert Sky Blvd, Tampa, FL, 33621	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-131934	ENR	Rebecca H Sanchez	1967-12-12	UHC-93661-89	6468231472	2536 Indian School Rd, Atlanta, GA, 30378	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+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-124355	ENR	Brittany Estrada	1947-09-22	UHC-93844-26	3337863966	2434 Desert Sky Blvd, Fresno, CA, 93733	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
ENR-137746	ENR	Adam Estrada	2007-09-23	UHC-32692-40	6159754445	6239 Canyon Rd # 901, Scottsdale, AZ, 85260	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-116860	ENR	Abigail Johnson	1969-11-17	UHC-27991-80	7167919653	1190 Park Pl Apt 18, Minneapolis, MN, 55469	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-140272	ENR	Lugan Silva	1957-07-14	UHC-62864-84	7015343193	8826 Church St, Seattle, WA, 98183	0.64	Name re-cased Street suffix standardised Address re-cased State name converted to code+2 more
ENR-140463	ENR	Camila Russell	2008-11-10	UHC-48176-69	9417743586	535 Indian School Rd, Gilbert, AZ, 85227	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+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-141858	ENR	Timothy Gonzales	1992-10-25	UHC-54402-04	2468541764	6157 Market St, Houston, TX, 77065	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-140008	ENR	Vincent F Delgado	1960-02-12	UHC-58815-25	7402126774	5442 Sunset Blvd, Miami, FL, 33162	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-104507	ENR	Ryamond V Riley	1973-12-25	UHC-77200-05	—	375 Market St, Scottsdale, AZ, 85269	0.64	Name re-cased Phone missing area code Street suffix standardised Address re-cased+2 more
ENR-124713	ENR	Ronald V Pierce	1938-09-25	UHC-99616-62	5944009129	861 Sunset Blvd, Phoenix, AZ, 85034	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-100154	ENR	Fatima P Stone	1988-08-09	UHC-34812-21	3158149513	7374 Washington St, Charlotte, NC, 28297	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-139431	ENR	Justin B Sntiago	1989-04-04	UHC-11375-98	3587236085	8313 Spring St, Phoenix, AZ, 85010	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-106656	ENR	Gregory C Willis	1942-12-18	UHC-82628-22	5737313955	7682 Main St, Mesa, AZ	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-102617	ENR	Scott Z Shaw	1943-09-25	UHC-47109-16	5699184977	663 Market St Apt 17, Dallas, TX, 75296	0.64	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-139341	ENR	Larry Garcia	1952-09-11	UHC-62291-99	2833899872	3651 Harbor Blvd, Fresno, CA, 93741	0.64	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-132375	ENR	Camila Q Coleman	—	UHC-30287-02	—	2961 Cedar Ln, Tampa, FL, 33609	0.64	Middle initial moved out of first name Name re-cased Date of birth unreadable City re-cased+2 more
ENR-132374	ENR	Camila Q Coleman	—	UHC-30287-02	—	2961 Cedar Ln, Tampa, FL, 33609	0.64	Middle initial moved out of first name Name re-cased Date of birth unreadable City re-cased+2 more
ENR-121695	ENR	Brittany Gilbert	2002-02-15	UHC-09613-64	3667725534	4053 Ridge Rd, Atlanta, GA, 30382	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-106323	ENR	Jason Gomez	1945-04-03	UHC-68046-13	—	6458 Park Pl, Denver, CO	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-140401	ENR	Stephanie Collins	1978-09-02	UHC-66946-05	4836074739	5460 Baseline Rd, Mesa, AZ	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-103115	ENR	Laura Bowman	1941-07-02	UHC-28497-28	—	6430 Ocean Ave, Jacksonville, FL, 32216	0.64	Name re-cased Phone missing area code Street suffix standardised Address re-cased+2 more
ENR-129109	ENR	Jennifer N Lopez	1953-04-17	UHC-10266-57	—	9814 Ridge Rd, Chandler, AZ, 85250	0.64	Name re-cased Date of birth reformatted Phone missing area code Member ID reformatted+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-134856	ENR	Ralph Q Kelley	1975-09-22	UHC-28952-82	8395879904	1320 Pine Dr, Tempe, AZ, 85273	0.64	Middle initial moved out of first name Name re-cased Phone reformatted Street suffix standardised+2 more
ENR-117282	ENR	Zachery P Morales	1995-08-08	UHC-95210-09	5612126194	9060 Washington St, Tampa, FL, 33656	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-139767	ENR	Helen X Ellis	2008-02-12	UHC-73490-52	6389703302	2899 Broadway, Denver, CO, 80259	0.64	Name re-cased Phone reformatted ZIP+4 trimmed Gender normalised+2 more
ENR-117009	ENR	Nick V Fuller	—	UHC-33001-85	9536415809	9706 Broadway, Austin, TX, 78708	0.64	Name re-cased Date of birth unreadable Phone reformatted Member ID reformatted+2 more
ENR-111768	ENR	Jose D Crawford	1991-06-13	UHC-88067-96	8108166307	2181 Willow Ct, Chandler, AZ, 85241	0.64	Name re-cased Street suffix standardised Address re-cased Email lower-cased+2 more
ENR-102878	ENR	Jason Medina	1983-10-28	UHC-26945-97	9517626420	9662 Maple Ave, San Antonio, TX, 78252	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more

17,310 rows, page 103 of 347Previous Next