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 “Gender normalised”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagGender normalisedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-58752	TPA	Doris Hoffman	1938-11-04	—	—	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-50570	TPA	Helen K Morris	2002-02-12	—	—	2782 Park Pl, Denver, CO, 80293	0.80	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed
TPA-51463	TPA	Rachle Hughes	1969-06-06	—	—	3782 Meadow Ln, Glendale, AZ, 85328	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
TPA-64034	TPA	Cahrles Burke	1944-01-12	—	6746496741	7974 Meadow Ln, Austin, TX, 78770	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
TPA-51521	TPA	Betty Alvarez	1972-04-14	—	—	5477 Mountain View Dr, Scottsdale, AZ, 85223	0.80	City re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-55013	TPA	Billy Alexander	1946-04-05	UHC-77283-87	4814817040	1182 Central Ave, Tampa, FL, 33694	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
TPA-51053	TPA	Peter Roberts	1988-04-11	UHC-41456-86	4076290973	—	0.80	Name re-cased Email lower-cased Gender normalised Placeholder values cleared
TPA-60245	TPA	Richard Hansen	1959-10-08	—	3505892402	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-59222	TPA	Stephanie Harper	1964-06-15	—	—	—	0.80	Name re-cased Date of birth reformatted Gender normalised Placeholder values cleared
TPA-56802	TPA	William Wright	1999-12-01	—	—	5224 Apache Blvd, Fresno, CA, 93732	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-58182	TPA	Mei Cunningham	1985-07-19	—	—	6528 Meadow Ln, Charlotte, NC, 28215	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-55214	TPA	Sean Campblel	1961-07-27	—	—	—	0.80	Date of birth reformatted Email lower-cased Gender normalised Placeholder values cleared
TPA-57894	TPA	Ryan Wright	1953-03-20	—	—	—	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
TPA-57657	TPA	Jerry Ramos	1974-10-07	—	3894092273	5136 Elm St, Sacramento, CA, 95880	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
TPA-63496	TPA	Albert Stephens	1990-04-16	—	—	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-50983	TPA	Noah Cox	1963-08-03	UHC-36111-12	—	—	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
TPA-58115	TPA	Jack Williamson	1973-01-11	—	—	—	0.80	Name re-cased Date of birth reformatted Gender normalised Placeholder values cleared
TPA-54721	TPA	Lauren Perry	1954-10-27	—	9664326969	1166 Camelback Rd, Eden Prairie, MN, 55300	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
TPA-50098	TPA	Deboarh Murry	2003-04-24	—	—	—	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
TPA-64249	TPA	Amber Ruiz	1947-11-07	—	8288418858	9109 Union St, Scottsdale, AZ, 85281	0.80	Phone reformatted City re-cased Gender normalised Placeholder values cleared
TPA-56703	TPA	Martha P Ferguson	1990-08-18	—	—	6568 Broadway, San Antonio, TX, 78288	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
TPA-57984	TPA	Denise Padilla	1970-09-21	—	—	5052 Church St, Phoenix, AZ, 85080	0.80	Name re-cased Date of birth reformatted Gender normalised Placeholder values cleared
TPA-59979	TPA	Frank Banks	1981-05-15	—	5343609093	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-64413	TPA	Benjamin Olson	1977-02-25	—	—	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-50096	TPA	Deborah T Murray	2003-04-24	—	—	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-58455	TPA	Ethan Morris	2002-06-13	—	—	1385 Mountain View Dr, Mesa, AZ, 85269	0.80	City re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-59010	TPA	Christina Armstrong	1977-06-05	—	6675606643	—	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
TPA-50544	TPA	Karen Martinez	1972-11-01	—	4828590805	—	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
TPA-51003	TPA	Natalie Luuna	1943-03-22	—	9408938025	9853 River Rd, Glendale, AZ, 85323	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
TPA-57770	TPA	Fatima Daniels	2007-06-08	—	—	500 Desert Sky Blvd, Plano, TX, 75014	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-59620	TPA	Stephanie Campbell	1952-03-26	—	—	—	0.80	Date of birth reformatted Email lower-cased Gender normalised Placeholder values cleared
TPA-57231	TPA	Olyvia Maldonado	1959-04-02	—	—	—	0.80	Name re-cased Date of birth reformatted Gender normalised Placeholder values cleared
TPA-60714	TPA	Lucia Castro	1956-03-02	—	5676591519	7981 Broadway, Scottsdale, AZ, 85251	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
TPA-60713	TPA	Lucia Castro	1956-03-02	—	5676591519	7981 Broadway, Scottsdale, AZ, 85251	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
TPA-54046	TPA	Russell Johnson	1965-07-17	—	4803964351	7387 Oak St, Los Angeles, CA, 90052	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
TPA-53587	TPA	Philip Bleck	1955-02-06	UHC-68692-47	8183431032	1873 Forest Ave, Houston, TX, 77015	0.80	Phone reformatted Member ID reformatted City re-cased Gender normalised
TPA-51029	TPA	James Chen	1961-02-13	—	—	2201 River Rd, Tucson, AZ, 85704	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-52137	TPA	Samantha Gonzalez	1939-04-09	—	—	9765 Meadow Ln, San Antonio, TX, 78275	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-53147	TPA	Keren Howard	1980-09-03	—	—	9621 Broadway, San Antonio, TX, 78225	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-50431	TPA	Brandon Gonzales	1966-05-07	—	—	1764 Ocean Ave, Plano, TX, 75060	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-57091	TPA	Rebecca Collins	1972-06-13	—	—	—	0.80	Email lower-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-61050	TPA	Amy Simpson	1969-02-17	—	—	8176 Bayshore Dr, Las Vegas, NV, 89144	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-63914	TPA	Kathryn Campbell	1983-12-01	—	6057720741	3280 Valley View Dr, Los Angeles, CA, 90059	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-52196	TPA	Willie Cole	1985-09-21	—	5026621678	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-54636	TPA	Priya Bailey	1992-03-10	—	—	—	0.80	Name re-cased Date of birth reformatted Gender normalised Placeholder values cleared
TPA-63149	TPA	Arthur Watkins	1939-08-05	—	7128919772	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
TPA-61911	TPA	Jack Henry	2007-09-06	—	2535758250	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
TPA-55974	TPA	Jacqueline Padilla	1984-07-25	—	—	8450 Cedar Ln, Fresno, CA, 93782	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
TPA-51716	TPA	Ahmed V Bowman	1944-07-28	UHC-82494-64	—	—	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
TPA-50260	TPA	Katherine Sanders	1987-01-25	UHC-96221-61	—	7744 Sage Ct, Los Angeles, CA, 90044	0.80	Member ID reformatted Gender normalised Whitespace trimmed Placeholder values cleared

2,435 rows, page 41 of 49Previous Next