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 “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
CLM-407699	CLM	Angela Cunningham	1966-05-09	UHC-40509-23	9455797915	4347 Lincoln Way, Columbus, OH, 43222	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-100054	ENR	Logn S Grnat	1997-08-14	UHC-46420-56	9118378831	3270 Ocean Ave, Gilbert, AZ, 85205	0.78	Phone reformatted ZIP+4 trimmed Email lower-cased Whitespace trimmed+1 more
TPA-64057	TPA	Gabriel Rammos	1968-12-09	—	—	8943 Hillcrest Rd, Las Vegas, NV, 89186	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-115593	ENR	Bobby Hudson	1995-06-08	UHC-14302-71	6406376896	6175 Lincoln Way, Nashville, TN, 37211	0.78	Name re-cased State code upper-cased ZIP+4 trimmed Whitespace trimmed+1 more
ENR-104269	ENR	Shirley Harvey	1994-12-25	UHC-81817-78	3044152492	7830 Pine Dr, Chandler, AZ, 85217	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Email lower-cased+1 more
TPA-52422	TPA	Thomas Powell	1965-12-19	—	—	1837 Palm Dr, Atlanta, GA, 30397	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-416672	CLM	Benjamin Yang	1944-10-04	UHC-43975-07	7059092295	5389 Desert Sky Blvd, Mesa, AZ, 85265	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-126813	ENR	Threesa Wagner	1942-07-27	UHC-18014-03	7304881951	8816 Valley View Dr, Eden Prairie, MN, 55387	0.78	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed+1 more
ENR-105686	ENR	Ana Banks	1968-01-12	UHC-34703-52	5547536159	5264 Elm St, Minneapolis, MN, 55474	0.78	Name re-cased Member ID reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-103699	ENR	Ann J Alexandre	1950-08-21	UHC-97453-82	5913132629	5026 Harbor Blvd, Chandler, AZ, 85211	0.78	Phone reformatted Member ID reformatted State code upper-cased ZIP+4 trimmed+1 more
ENR-129282	ENR	Christian Carroll	1962-11-16	UHC-95958-18	3155656706	6351 Canyon Rd, San Antonio, TX, 78291	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Email lower-cased+1 more
ENR-108017	ENR	Adam R Collins	1975-06-08	UHC-14438-70	3995848023	2667 Canyon Rd, Tucson, AZ, 85765	0.78	Phone reformatted Member ID reformatted ZIP+4 trimmed Email lower-cased+1 more
CLM-425743	CLM	Yuki Perez	1986-01-19	UHC-27080-83	6265875624	5798 Elm St, Sacramento, CA, 95846	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-418971	CLM	Logan Luna	1942-09-06	UHC-90592-70	—	8848 Cedar Ln, Scottsdale, AZ, 85297	0.78	Name re-cased Member ID reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-132571	ENR	Emily George	1944-05-10	UHC-15517-57	5803135977	5095 Oak St, Columbus, OH, 43201	0.78	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed+1 more
TPA-54952	TPA	Stephanie Hayes	1982-06-25	—	4904101885	6718 Elm St, Scottsdale, AZ, 85232	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-27575	PRV	Brenda Wells	1961-07-12	UHC-70706-56	6507345717	5623 Maple Ave, Mesa, AZ, 85251	0.78	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-417871	CLM	Danielle Carter	1959-10-04	UHC-75129-77	—	8020 Highland Ave, Atlanta, GA, 30358	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-119174	ENR	Mason Y Weaver	1946-08-27	UHC-94503-02	3287084598	248 Palm Dr, Fresno, CA, 93706	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Email lower-cased+1 more
ENR-119175	ENR	Mason Y Weaver	1946-08-27	UHC-94503-02	3287084598	248 Palm Dr, Fresno, CA, 93706	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Email lower-cased+1 more
CLM-403959	CLM	Donald Bishop	1944-01-26	UHC-63974-50	4717731791	9402 Maple Ave, Charlotte, NC, 28262	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-51228	TPA	Wayne McDonald	1994-06-22	—	—	7309 Baseline Rd, Eden Prairie, MN, 55300	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-112319	ENR	Susan Scott	1971-09-12	UHC-34135-53	—	6472 Main St, San Diego, CA, 92167	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-432343	CLM	Ethan Mejia	1972-03-07	—	5592507804	5630 Church St, Tempe, AZ, 85292	0.78	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
TPA-55210	TPA	Willie Black	2001-09-22	UHC-22972-70	5414831637	4399 Sunset Blvd, Tucson, AZ, 85789	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-402660	CLM	Cheryl F Vasquez	1997-07-02	—	8685691985	6164 Jefferson Ave, Houston, TX, 77061	0.78	Name re-cased Date of birth reformatted Phone reformatted City re-cased+1 more
ENR-103694	ENR	Mariana Alvarado	1988-05-19	UHC-74798-45	3708083444	24 Lake View Rd, Austin, TX, 78795	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-103693	ENR	Mariana Alvarado	1988-05-19	UHC-74798-45	3708083444	24 Lake View Rd, Austin, TX, 78795	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-139878	ENR	Christine U Young	1955-03-09	UHC-33275-29	7144246288	4686 Broadway, Tucson, AZ, 85741	0.78	Name re-cased Phone reformatted Address re-cased ZIP+4 trimmed+1 more
CLM-431590	CLM	Linda Morris	1955-08-06	UHC-71276-86	4099501312	691 Broadway, Columbus, OH, 43270	0.78	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
TPA-62605	TPA	Jordan Moore	1991-03-02	—	8302500727	8323 Union St, Tampa, FL, 33690	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-122656	ENR	Laura Cox	1997-05-22	UHC-81407-92	8783946263	3151 Highland Ave, Miami, FL, 33102	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-55208	TPA	Zachary Holmes	1960-05-10	UHC-72648-91	6985379094	5767 Broadway, Sacramento, CA, 95856	0.78	Date of birth reformatted State code upper-cased ZIP+4 trimmed Whitespace trimmed+1 more
PRV-23618	PRV	Adam Gibson	1991-01-08	—	9115456638	7686 Sunset Blvd, Sacramento, CA, 95867	0.78	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
ENR-105524	ENR	Jean Gonzales	1989-11-19	UHC-38360-46	5892822104	6660 Lake View Rd, Sacramento, CA, 95853	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Email lower-cased+1 more
CLM-426658	CLM	Hannah Ortiz	1957-10-10	UHC-87191-37	—	6790 Harbor Blvd, San Diego, CA, 92126	0.78	Name re-cased City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
TPA-62982	TPA	Kyle Diaz	1947-01-21	—	—	7281 Ridge Rd, Dallas, TX, 75274	0.78	Name re-cased ZIP+4 trimmed Email lower-cased Whitespace trimmed+1 more
ENR-115140	ENR	Judith R Castillo	1984-08-12	UHC-17837-26	4316528624	5562 Pine Dr, Tucson, AZ, 85793	0.78	Name re-cased Phone reformatted City re-cased ZIP+4 trimmed+1 more
ENR-111639	ENR	Sarah Henderson	1972-04-16	UHC-24133-93	5716900431	8426 Cedar Ln, Mesa, AZ, 85238	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-25890	PRV	Adam Hughes	1974-04-05	—	7572253575	4667 Sunset Blvd, Sacramento, CA, 95821	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-409613	CLM	Marcus Jacobs	2004-09-07	UHC-04044-52	3787405430	3489 Church St, Phoenix, AZ, 85072	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-101000	ENR	Aisha Q Auilar	1978-01-06	UHC-50504-70	5908319425	1025 Ridge Rd, Tucson, AZ, 85752	0.78	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-411219	CLM	Kevin Mills	1976-08-28	UHC-48283-04	7234116514	8930 Mesa Dr, Orlando, FL, 32899	0.78	Name re-cased City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
ENR-122231	ENR	Liz Gordon	1967-02-14	UHC-31740-79	3406277333	4061 Camelback Rd, Miami, FL, 33161	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Email lower-cased+1 more
ENR-126772	ENR	Kayla Pnea	1969-01-04	UHC-82931-02	3687610808	6436 Ridge Rd, Atlanta, GA, 30308	0.78	Date of birth reformatted Phone reformatted Member ID reformatted ZIP+4 trimmed+1 more
CLM-419575	CLM	Dylan Robinson	2007-07-15	UHC-25806-40	—	3396 Maple Ave, Orlando, FL, 32819	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-22956	PRV	Kyle Dominguez	1954-02-12	UHC-43293-68	7332068412	2026 Elm St, Minneapolis, MN, 55438	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-423701	CLM	Kathleen Day	1982-02-23	UHC-81831-31	7488355174	5003 Ocean Ave, Glendale, AZ, 85390	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-56729	TPA	Albert Gray	1946-07-15	—	—	3904 Valley View Dr, Dallas, TX, 75273	0.78	Date of birth reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
PRV-20275	PRV	Wayne Diaz	1974-08-03	—	8103819715	7786 Highland Ave, Minneapolis, MN, 55484	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more

8,263 rows, page 144 of 166Previous Next