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 “Member ID reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagMember ID reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-27279	PRV	Jose Tucker	2004-12-21	UHC-36863-60	3314349662	4862 Sage Ct, Las Vegas, NV, 89113	0.90	Name re-cased Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-131855	ENR	Lucya Peters	1947-02-01	UHC-69227-68	9894148857	8035 Canyon Rd, Houston, TX, 77032	0.90	Name re-cased Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-110769	ENR	Billy I Welch	2008-02-08	UHC-84428-82	5888079051	1255 Spring St, Tucson, AZ, 85721	0.90	Date of birth reformatted Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-110770	ENR	Billy I Welch	2008-02-08	UHC-84428-82	5888079051	1255 Spring St, Tucson, AZ, 85721	0.90	Date of birth reformatted Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-136473	ENR	Carl G Morales	1997-11-09	UHC-82150-87	7313941344	6273 Washington St, Las Vegas, NV, 89135	0.90	Name re-cased Member ID reformatted Email lower-cased Whitespace trimmed+1 more
PRV-22752	PRV	Betty Mendoza	1951-07-26	UHC-65583-73	6337960987	9797 Valley View Dr, Mesa, AZ, 85231	0.90	Name re-cased Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-141594	ENR	Dorothy Russell	1990-09-17	UHC-99625-04	—	9373 Spring St, Mesa, AZ, 85208	0.90	Name re-cased Member ID reformatted Plan code upper-cased Whitespace trimmed+1 more
CLM-425094	CLM	Paul Luna	1974-05-11	UHC-71549-96	9529945118	—	0.90	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+1 more
ENR-140426	ENR	Elisabeth K Oliver	1980-04-09	UHC-97903-39	2493152944	8761 Bayshore Dr, Minneapolis, MN, 55405	0.90	Name re-cased Date of birth reformatted Member ID reformatted Email lower-cased+1 more
CLM-409252	CLM	Pat Carpenter	1953-12-18	UHC-50496-96	—	4022 Grand Ave, Atlanta, GA, 30354	0.90	Name re-cased Date of birth reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-138952	ENR	Ashley O Ryan	1982-05-26	UHC-70178-05	—	5777 Grand Ave, Fresno, CA, 93780	0.90	Date of birth reformatted Member ID reformatted City re-cased Whitespace trimmed+1 more
PRV-23865	PRV	Walter E Mitchell	1938-07-02	UHC-47670-92	3999909734	7108 Washington St, San Diego, CA, 92160	0.90	Date of birth reformatted Phone reformatted Member ID reformatted Whitespace trimmed+1 more
CLM-427844	CLM	Ruht Montgomery	1968-10-18	UHC-83646-29	—	—	0.90	Name re-cased Date of birth reformatted Member ID reformatted Whitespace trimmed+1 more
PRV-23723	PRV	Nancy Johnson	1956-08-03	UHC-08685-37	7753400220	7906 Broadway, Tucson, AZ, 85789	0.90	Date of birth reformatted Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-137515	ENR	Mariana K Henry	1946-04-24	UHC-62911-98	2368291588	5769 Desert Sky Blvd, Glendale, AZ, 85360	0.90	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+1 more
TPA-58858	TPA	Kimberly Reynolds	1995-06-10	UHC-53253-11	8079070095	5724 Elm St, Austin, TX, 78741	0.90	Name re-cased Phone reformatted Member ID reformatted City re-cased+1 more
PRV-25864	PRV	Theresa Garcia	1940-11-08	UHC-73103-71	9435629635	2889 Camelback Rd, Fresno, CA, 93725	0.90	Name re-cased Phone reformatted Member ID reformatted City re-cased+1 more
CLM-404118	CLM	Ray Wood	1977-12-17	UHC-43430-18	4136458907	409 Cedar Ln, Las Vegas, NV, 89148	0.90	Date of birth reformatted Phone reformatted Member ID reformatted City re-cased+1 more
ENR-114654	ENR	David Harvey	1944-12-03	UHC-88824-68	2118671094	9718 Harbor Blvd, Denver, CO, 80218	0.90	Name re-cased Phone reformatted Member ID reformatted Plan code upper-cased+1 more
ENR-115406	ENR	Marilyn Russell	1982-09-16	UHC-23287-69	—	4316 Main St, Atlanta, GA, 30342	0.90	Date of birth reformatted Member ID reformatted City re-cased Whitespace trimmed+1 more
ENR-114180	ENR	Brenda C Obrien	1980-09-01	UHC-47194-70	3733695594	8901 Hillcrest Rd, Charlotte, NC, 28284	0.90	Name re-cased Phone reformatted Member ID reformatted City re-cased+1 more
ENR-140471	ENR	Matthew Harper	2001-06-03	UHC-43987-44	9164789371	3125 Union St, Los Angeles, CA, 90067	0.90	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+1 more
ENR-133362	ENR	Russell Hudson	1962-10-13	UHC-66326-40	2028984755	8985 Hillcrest Rd, Columbus, OH, 43252	0.90	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+1 more
ENR-125184	ENR	Andrew Marquez	1997-07-22	UHC-66250-40	6105242161	6343 Willow Ct, Orlando, FL, 32838	0.90	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+1 more
ENR-136379	ENR	Bradley Crawford	1960-03-11	UHC-16738-82	5214569303	4699 Union St, Glendale, AZ, 85393	0.90	Name re-cased Phone reformatted Member ID reformatted City re-cased+1 more
ENR-135612	ENR	Harold Mrphy	1948-08-24	UHC-22265-13	3436309579	—	0.90	Name re-cased Phone reformatted Member ID reformatted Whitespace trimmed+1 more
CLM-410662	CLM	Carolyn King	1957-07-13	UHC-08940-62	—	2064 Park Pl, San Antonio, TX, 78271	0.90	Name re-cased Member ID reformatted City re-cased Whitespace trimmed+1 more
CLM-412892	CLM	Kathryn Tucker	2006-06-26	UHC-29928-51	5537032967	7904 Bayshore Dr, Sacramento, CA, 95875	0.90	Date of birth reformatted Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-128993	ENR	Kayla X Lewis	1978-06-27	UHC-29423-32	7166857720	8719 Ocean Ave, Gilbert, AZ, 85269	0.90	Phone reformatted Member ID reformatted State code upper-cased Whitespace trimmed+1 more
CLM-428887	CLM	Judith Carlson	1962-08-13	UHC-82292-64	6369555002	9441 Canyon Rd, San Diego, CA, 92110	0.90	Name re-cased Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-105264	ENR	George Hoffman	1962-10-01	UHC-52151-87	5593117743	1238 Palm Dr, Houston, TX, 77012	0.90	Name re-cased Phone reformatted Member ID reformatted City re-cased+1 more
ENR-139879	ENR	Gerald Holmes	1966-11-23	UHC-88431-73	8224905375	—	0.90	Phone reformatted Member ID reformatted Email lower-cased Whitespace trimmed+1 more
ENR-117126	ENR	Deborah O Gordon	1941-05-26	UHC-25069-01	3398306272	6829 Ridge Rd, Houston, TX, 77007	0.90	Name re-cased Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-132088	ENR	Bobby T Richardson	1986-07-10	UHC-04340-73	—	7364 Spring St, Las Vegas, NV, 89111	0.90	Date of birth reformatted Member ID reformatted Email lower-cased Whitespace trimmed+1 more
ENR-101670	ENR	Geore Medina	1973-04-16	UHC-11140-35	3594854403	8947 Spring St, Minneapolis, MN, 55478	0.90	Phone reformatted Member ID reformatted State code upper-cased Whitespace trimmed+1 more
PRV-21644	PRV	Lori Li	1994-08-08	UHC-27086-42	4574607825	4073 Camelback Rd, Tucson, AZ, 85784	0.90	Date of birth reformatted Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-103686	ENR	Marilyn I Carpneter	1948-02-24	UHC-24915-15	3055276415	7572 Spring St, Miami, FL, 33193	0.90	Name re-cased Phone reformatted Member ID reformatted Whitespace trimmed+1 more
CLM-404483	CLM	Henry I Anderson	1953-11-06	UHC-79339-20	5592831672	—	0.90	Date of birth reformatted Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-109713	ENR	Santiago Day	1988-10-04	UHC-57224-60	9723907417	1074 Mountain View Dr, Miami, FL, 33166	0.90	Date of birth reformatted Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-113823	ENR	Joshua G Powell	2004-11-10	UHC-44869-16	8142274678	5876 Mountain View Dr, Tampa, FL, 33699	0.90	Phone reformatted Member ID reformatted Email lower-cased Whitespace trimmed+1 more
ENR-120780	ENR	Dylan B Harrison	1999-12-28	UHC-94146-35	8672463765	6084 Mountain View Dr, Orlando, FL, 32821	0.90	Name re-cased Phone reformatted Member ID reformatted Whitespace trimmed+1 more
CLM-432764	CLM	Brenda Elliott	1954-10-24	UHC-48551-68	8424556271	2647 Ridge Rd, Columbus, OH, 43272	0.90	Date of birth reformatted Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-131065	ENR	Martha Bradley	1969-09-03	UHC-66043-35	8084765256	385 Market St, Houston, TX, 77051	0.90	Date of birth reformatted Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-116906	ENR	Bobby Powell	1965-12-22	UHC-79003-10	6014179192	5887 Ocean Ave, Phoenix, AZ, 85091	0.90	Phone reformatted Member ID reformatted State code upper-cased Email lower-cased+1 more
ENR-115258	ENR	Heather Mendoza	1954-04-14	UHC-79519-71	—	4930 Baseline Rd, Minneapolis, MN, 55455	0.90	Name re-cased Member ID reformatted Email lower-cased Plan code upper-cased+1 more
CLM-401159	CLM	Terry Fox	2007-08-14	UHC-25927-17	—	—	0.90	Name re-cased Date of birth reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-137531	ENR	Dick Z Yang	1946-12-11	UHC-75841-28	9445424951	1269 Lincoln Way, Houston, TX, 77029	0.90	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+1 more
CLM-421770	CLM	Henry Allen	1971-08-01	UHC-76663-03	—	3966 Ocean Ave, Gilbert, AZ, 85252	0.90	Name re-cased Date of birth reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-119195	ENR	Diane H Pena	1979-01-02	UHC-23311-52	6652689330	9508 Lake View Rd, Phoenix, AZ, 85030	0.90	Name re-cased Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-108867	ENR	Joyce S Gomez	1991-03-28	UHC-09424-21	3884117607	9674 Meadow Ln, Orlando, FL, 32802	0.90	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+1 more

7,723 rows, page 129 of 155Previous Next