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

Third-party administrator, 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
TPA-60583	TPA	Yuki Evans	1984-12-08	UHC-57726-03	8113363207	8031 Broadway, San Antonio, TX, 78227	0.78	Phone reformatted Member ID reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-60235	TPA	Katherine W Carpenter	1977-08-22	—	—	2630 Harbor Blvd, Tampa, FL, 33659	0.78	Name re-cased Date of birth reformatted City re-cased ZIP+4 trimmed+1 more
TPA-59593	TPA	Philip Owens	2004-08-19	—	8437819909	391 Sunset Blvd, Fresno, CA, 93797	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-55855	TPA	Ambber Brown	1948-01-04	—	7732869431	5547 Hillcrest Rd, Tucson, AZ, 85743	0.78	Date of birth reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
TPA-60004	TPA	Michelle Burns	1938-06-03	—	—	4095 Park Pl, Dallas, TX, 75205	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-54294	TPA	Olivia Bradley	1969-04-23	—	—	3185 Apache Blvd, Las Vegas, NV, 89116	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-60367	TPA	David Brooks	1939-05-06	—	—	5972 Jefferson Ave, Jacksonville, FL, 32262	0.78	Name re-cased ZIP+4 trimmed Plan code upper-cased Whitespace trimmed+1 more
TPA-57655	TPA	Judy Z Pierce	1991-02-15	—	7106410167	2875 Maple Ave, San Antonio, TX, 78239	0.78	Phone reformatted ZIP+4 trimmed Plan code upper-cased Whitespace trimmed+1 more
TPA-56099	TPA	Jan Welch	1959-01-05	—	—	4917 Park Pl, San Antonio, TX, 78227	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-58342	TPA	Kayla Garrett	1993-01-02	—	—	3765 Desert Sky Blvd, Fresno, CA, 93773	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-58851	TPA	Thomas Holmes	1997-12-19	—	6828810217	2283 Broadway, Eden Prairie, MN, 55363	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-59837	TPA	Stephanie Williamson	1961-09-28	—	—	9825 Mesa Dr, Las Vegas, NV, 89103	0.78	Date of birth reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
TPA-51901	TPA	Zachary Gibson	1951-08-11	—	—	4400 Church St, Atlanta, GA, 30373	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-51335	TPA	Sean Howard	2003-03-02	—	7965650732	1024 Lincoln Way, Gilbert, AZ, 85274	0.78	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
TPA-61734	TPA	Russell Jenkins	1965-02-11	—	—	7939 Park Pl, Tempe, AZ, 85257	0.78	Name re-cased Date of birth reformatted City re-cased ZIP+4 trimmed+1 more
TPA-60076	TPA	Douglas Kim	1940-07-09	—	6217564649	5295 Market St, Fresno, CA, 93711	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-56016	TPA	Kelly Perez	1990-08-15	—	2277078162	1759 Mountain View Dr, Los Angeles, CA, 90000	0.78	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 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
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
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
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
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
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
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
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
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
TPA-50022	TPA	Andrea Murphy	1945-01-09	—	—	3741 Spring St, Atlanta, GA, 30350	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-51274	TPA	Mary Wilson	1988-12-11	UHC-70575-82	—	7940 Ocean Ave, Atlanta, GA, 30390	0.78	Member ID reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
TPA-62042	TPA	Olivia Lynch	1991-07-18	—	—	4811 Central Ave, Dallas, TX, 75243	0.78	Name re-cased City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
TPA-63036	TPA	Carol Turner	1988-06-04	—	8674376699	834 Highland Ave, Eden Prairie, MN, 55325	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-60856	TPA	Ann O Sims	2003-11-13	UHC-16272-69	6726657957	4580 Lincoln Way, Scottsdale, AZ, 85243	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-59272	TPA	Elizabeth M Dean	1989-06-12	—	6935047284	4310 Church St, Austin, TX, 78747	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-55539	TPA	Kathy Brown	1994-08-14	UHC-43169-47	7469228012	3092 Sage Ct, Orlando, FL, 32854	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Email lower-cased+1 more
TPA-63085	TPA	Dylan Fernandez	2006-08-09	—	—	467 Indian School Rd, Denver, CO, 80234	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-51710	TPA	Laura Hunt	1976-05-20	UHC-71086-48	—	8673 River Rd, Atlanta, GA, 30339	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-60533	TPA	Lori Yang	1974-08-09	—	7174754465	5415 Forest Ave, Dallas, TX, 75273	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-62676	TPA	Adam P Hicks	1979-05-03	—	—	5348 Mountain View Dr, Denver, CO, 80282	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-52098	TPA	Larry Reid	1955-09-02	UHC-25768-96	5346119525	6846 Main St, Charlotte, NC, 28259	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-61369	TPA	Judith Banks	1949-01-10	—	9692258400	3720 Main St, Orlando, FL, 32890	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
TPA-53034	TPA	Priya Barnes	2006-09-24	—	—	7208 Indian School Rd, Austin, TX, 78709	0.80	Date of birth reformatted ZIP+4 trimmed Email lower-cased Placeholder values cleared
TPA-54403	TPA	Michelle Owens	2006-04-18	—	—	3887 Church St, Atlanta, GA, 30389	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-63644	TPA	Nicholas Morales	1978-01-24	—	—	7526 Broadway, Fresno, CA, 93710	0.80	City re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-52824	TPA	Philip Bradley	1945-06-28	—	—	2457 Hillcrest Rd, Minneapolis, MN, 55448	0.80	Name re-cased Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
TPA-54790	TPA	Timothy Y Ward	1976-11-04	—	—	2898 Broadway, Austin, TX, 78769	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-63370	TPA	Helen Ellis	2008-02-12	—	—	2899 Broadway, Denver, CO, 80259	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-55071	TPA	Mary Martin	1983-10-15	—	—	9709 Union St, Orlando, FL, 32850	0.80	Name re-cased Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
TPA-55070	TPA	Mary Martin	1983-10-15	—	—	9709 Union St, Orlando, FL, 32850	0.80	Name re-cased Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
TPA-56332	TPA	Parker William	1968-06-08	—	—	4856 Mountain View Dr, Nashville, TN, 37213	0.80	Name re-cased Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
TPA-61306	TPA	Edward Alvarado	1960-06-18	UHC-97144-40	—	6451 Sage Ct, San Antonio, TX, 78244	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-55207	TPA	Zachary Holmes	1960-05-10	—	6985379094	5767 Broadway, Sacramento, CA, 95856	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed

1,145 rows, page 20 of 23Previous Next