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-110672	ENR	Brian T Bowwman	1984-09-11	UHC-31217-11	8886229670	7279 Bayshore Dr, Tucson, AZ, 85771	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-127817	ENR	Kathleen S Santiago	1943-10-11	—	5027555551	3108 Apache Blvd, Las Vegas, NV, 89163	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-134803	ENR	Mark H Stone	1942-06-25	UHC-66031-67	9622879264	2896 Willow Ct, Eden Prairie, MN, 55331	0.82	Name re-cased Date of birth reformatted ZIP+4 trimmed
ENR-132954	ENR	Lori X Stawart	1983-03-27	UHC-48584-19	—	8167 Desert Sky Blvd, Charlotte, NC, 28236	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-109334	ENR	Sophia Diaz	1944-07-10	UHC-97392-72	—	5031 Meadow Ln, Miami, FL, 33116	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-129668	ENR	Danielle I Duncan	2008-05-08	UHC-27925-26	9545299043	4624 Central Ave, Jacksonville, FL, 32294	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
ENR-137860	ENR	Alexis U Bell	1984-08-28	UHC-85769-60	3424554742	6876 Hillcrest Rd, Tampa, FL, 33631	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
ENR-111211	ENR	Katherine Berry	2006-10-09	UHC-71526-34	8987284309	1941 Lincoln Way, Denver, CO, 80233	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-132075	ENR	Kathleen Crawford	2005-06-27	UHC-14435-71	4605129180	5152 Market St, Seattle, WA, 98167	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-136904	ENR	Seven Z Banks	1996-02-04	UHC-07451-51	3894330654	3470 Bayshore Dr, Eden Prairie, MN, 55348	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-120487	ENR	Kenneth Morgan	1969-05-17	UHC-50444-71	8816254260	4960 Bayshore Dr, Denver, CO, 80278	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-124538	ENR	Robert W Murray	1948-06-28	UHC-13082-33	4407333002	5402 Mesa Dr, Eden Prairie, MN, 55367	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-137626	ENR	Anthony Clark	1986-08-14	UHC-44110-59	9246514107	8696 Forest Ave, San Antonio, TX, 78208	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-112137	ENR	Jacob Ward	1989-03-20	UHC-58162-21	9415002414	8456 Mountain View Dr, Charlotte, NC, 28266	0.82	Phone reformatted ZIP+4 trimmed Email lower-cased
ENR-100825	ENR	Julie Evans	1952-10-11	UHC-54569-15	3968237514	2563 Desert Sky Blvd, Las Vegas, NV, 89150	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-126735	ENR	Radny R Hernandez	1982-09-03	UHC-12377-86	4076940357	5210 Canyon Rd, Atlanta, GA, 30333	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-138494	ENR	Bryan Rose	1991-01-28	UHC-56998-94	4813886338	3255 Broadway, Chandler, AZ, 85255	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
ENR-142353	ENR	Victoria Dunn	2001-10-11	UHC-06859-93	3727656233	8891 Canyon Rd, Tampa, FL, 33620	0.82	Date of birth reformatted ZIP+4 trimmed Email lower-cased
ENR-138691	ENR	Pat Wilson	1962-09-25	UHC-11066-40	—	7558 Mesa Dr, Columbus, OH, 43220	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-115255	ENR	Jessica T Rice	1954-10-24	UHC-70139-88	5643506673	2355 Harbor Blvd, Austin, TX, 78776	0.82	Phone reformatted ZIP+4 trimmed Plan code upper-cased
ENR-128927	ENR	Joyce I Duncan	1994-06-08	UHC-27486-99	8044194490	1676 Baseline Rd, Seattle, WA, 98139	0.82	ZIP+4 trimmed Email lower-cased Whitespace trimmed
ENR-130888	ENR	Peters H Viictoria	1988-06-28	UHC-84860-96	7487952139	1271 Harbor Blvd, Tucson, AZ, 85715	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-108129	ENR	Jose Robinson	2007-04-05	UHC-39115-68	6814206975	4998 Sunset Blvd, Las Vegas, NV, 89115	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
ENR-135712	ENR	Kimberly Larson	2003-08-24	UHC-41371-87	8117587713	2152 Desert Sky Blvd, Glendale, AZ, 85361	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
ENR-139798	ENR	Diego Larson	1949-01-03	UHC-46239-88	7693426294	2883 Maple Ave, Chandler, AZ, 85206	0.82	Name re-cased ZIP+4 trimmed Email lower-cased
ENR-102703	ENR	Wayne Martinez	1986-02-07	UHC-41171-17	5455774282	8799 Central Ave, Gilbert, AZ, 85293	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-137942	ENR	Pamela N Baekr	1947-03-10	UHC-97391-25	7973204641	8610 Baseline Rd, Dallas, TX, 75212	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-102325	ENR	Elijah K Ross	1971-11-17	UHC-43383-31	6468162965	6360 Mesa Dr, Tampa, FL, 33632	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
ENR-142884	ENR	Victoria Dean	2000-08-10	UHC-13426-12	7497948447	969 Lincoln Way, Sacramento, CA, 95884	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-108700	ENR	Ronald C Collins	1949-05-08	UHC-97895-99	8446571260	4782 Mountain View Dr, Los Angeles, CA, 90002	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-141926	ENR	Madison Q Wilson	1946-10-13	UHC-30657-32	—	1800 Lake View Rd, Atlanta, GA, 30366	0.82	Name re-cased State code upper-cased ZIP+4 trimmed
ENR-142685	ENR	Jerry Marquez	1946-08-18	UHC-22532-24	2458358922	5862 Highland Ave, Fresno, CA, 93756	0.82	Date of birth reformatted Member ID reformatted ZIP+4 trimmed
ENR-100401	ENR	David O Murray	1945-08-01	UHC-38623-43	8377336787	4943 Canyon Rd, Dallas, TX, 75262	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-124817	ENR	Douglas McDonald	1959-11-11	UHC-18708-72	—	6907 Valley View Dr, Austin, TX, 78704	0.82	Member ID reformatted ZIP+4 trimmed Placeholder values cleared
ENR-129068	ENR	Austin Tucker	1954-08-12	UHC-47758-36	8103027616	2721 Camelback Rd, Nashville, TN, 37206	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-117858	ENR	Amy Sandoval	1978-01-28	UHC-15452-48	4882054874	7809 Sunset Blvd, Charlotte, NC, 28235	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-134915	ENR	Charlotte I Rogers	1996-03-20	UHC-33731-33	9723574202	7069 Cedar Ln, Houston, TX, 77038	0.84	ZIP+4 trimmed Placeholder values cleared
ENR-121425	ENR	Emily A Brown	1943-12-10	UHC-53245-33	—	8526 Valley View Dr, Eden Prairie, MN, 55332	0.84	Date of birth reformatted ZIP+4 trimmed
ENR-140360	ENR	Olivia W Park	1963-12-28	UHC-31493-58	4017480711	4340 Sunset Blvd, Los Angeles, CA, 90090	0.84	Phone reformatted ZIP+4 trimmed
ENR-126775	ENR	Mateo Thomas	1952-06-21	UHC-30713-28	6338039110	5508 Mountain View Dr, Austin, TX, 78763	0.84	Phone reformatted ZIP+4 trimmed
ENR-136712	ENR	Willie Z Hughes	2007-11-19	—	2805821410	7719 Broadway, Chandler, AZ, 85201	0.84	Phone reformatted ZIP+4 trimmed
ENR-102152	ENR	Christopher Hudson	1979-05-01	UHC-86142-38	9717511794	5010 Lincoln Way, Nashville, TN, 37283	0.84	ZIP+4 trimmed Email lower-cased
ENR-100686	ENR	Mariana Shwa	1952-02-14	UHC-69035-21	—	1064 Oak St, Denver, CO, 80287	0.84	ZIP+4 trimmed Placeholder values cleared
ENR-111092	ENR	Luis T Peterson	1981-09-10	UHC-91715-29	—	807 Canyon Rd, Los Angeles, CA, 90047	0.84	Name re-cased ZIP+4 trimmed
ENR-135726	ENR	Charles M Wang	1994-02-03	UHC-35113-59	8512337972	9780 Willow Ct, Los Angeles, CA, 90031	0.84	ZIP+4 trimmed Email lower-cased
ENR-121704	ENR	Janet U Dean	1989-12-07	UHC-20557-72	9548175249	8717 Palm Dr, Phoenix, AZ, 85037	0.84	Name re-cased ZIP+4 trimmed
ENR-115034	ENR	Olivia Wright	1949-07-26	UHC-55221-95	4502946841	3681 Baseline Rd, Tucson, AZ, 85786	0.84	Name re-cased ZIP+4 trimmed
ENR-130791	ENR	Rachel Wallace	1957-10-01	UHC-75491-56	7753004993	6492 Lincoln Way, Houston, TX, 77002	0.84	Phone reformatted ZIP+4 trimmed
ENR-138874	ENR	Sue Williams	2000-06-23	UHC-46672-95	3679071705	4391 Lincoln Way, Dallas, TX, 75284	0.84	Name re-cased ZIP+4 trimmed
ENR-140455	ENR	Gary Walsh	1981-08-23	UHC-49344-04	2243017533	3763 Church St, Tampa, FL, 33670	0.84	ZIP+4 trimmed Whitespace trimmed

3,951 rows, page 78 of 80Previous Next