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 “Plan code upper-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagPlan code upper-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-425239	CLM	Isabella Garrett	1940-11-15	UHC-46454-70	—	—	0.90	Name re-cased Date of birth reformatted Plan code upper-cased Whitespace trimmed+1 more
CLM-416384	CLM	Denise E Hamilton	1988-06-25	UHC-25159-90	7014016989	9833 Sage Ct, Minneapolis, MN, 55441	0.90	Date of birth reformatted Phone reformatted State code upper-cased Plan code upper-cased+1 more
CLM-419156	CLM	Hannah V James	2007-07-04	UHC-64914-03	—	3210 Oak St, Plano, TX, 75086	0.90	Date of birth reformatted City re-cased Plan code upper-cased Whitespace trimmed+1 more
CLM-424063	CLM	Jessica Dean	1966-03-14	UHC-39196-24	—	—	0.90	Name re-cased Date of birth reformatted Plan code upper-cased Whitespace trimmed+1 more
CLM-415922	CLM	Marcus B Alexander	1987-11-15	—	4999021320	—	0.90	Name re-cased Phone reformatted Plan code upper-cased Whitespace trimmed+1 more
ENR-138578	ENR	Amber C Bishop	1950-04-19	—	2052293003	5736 Sage Ct, Dallas, TX, 75236	0.90	Phone reformatted Email lower-cased Plan code upper-cased Whitespace trimmed+1 more
ENR-129102	ENR	Brandon A James	1955-10-27	UHC-78135-14	3366459875	9899 Central Ave, Chandler, AZ, 85263	0.90	Name re-cased Phone reformatted Plan code upper-cased Whitespace trimmed+1 more
ENR-123443	ENR	Hannah Porter	1991-06-15	UHC-63800-64	3564612216	5730 Palm Dr, Miami, FL, 33199	0.90	Date of birth reformatted Phone reformatted Plan code upper-cased Whitespace trimmed+1 more
CLM-418859	CLM	Lawrence Burke	1981-07-17	UHC-67527-35	2342414823	—	0.90	Name re-cased Phone reformatted Plan code upper-cased Whitespace trimmed+1 more
ENR-121562	ENR	Arjun Robertson	1980-11-11	UHC-87084-84	4112212069	4498 Washington St, Jacksonville, FL, 32242	0.90	Name re-cased Phone reformatted State code upper-cased Plan code upper-cased+1 more
ENR-122745	ENR	Carolyn H Gutierrez	1948-06-25	UHC-61047-79	8753951746	4424 Church St, Seattle, WA, 98189	0.90	Date of birth reformatted Phone reformatted Plan code upper-cased Whitespace trimmed+1 more
ENR-137195	ENR	Denise Dominguez	1972-05-01	UHC-13081-73	8045114895	2833 Palm Dr, Jacksonville, FL, 32276	0.90	Phone reformatted State code upper-cased Plan code upper-cased Whitespace trimmed+1 more
CLM-413999	CLM	Nicholas Jackson	1951-02-03	UHC-39004-12	7286235202	849 Cedar Ln, Fresno, CA, 93766	0.90	Name re-cased Phone reformatted Plan code upper-cased Whitespace trimmed+1 more
CLM-408161	CLM	Vincent I Hayes	1945-11-04	—	4099895608	1652 Washington St, Phoenix, AZ, 85099	0.90	Name re-cased Phone reformatted Plan code upper-cased Whitespace trimmed+1 more
TPA-51107	TPA	Albert Myers	1959-03-01	UHC-39005-14	7528889110	2650 Mountain View Dr, Denver, CO, 80224	0.90	Date of birth reformatted Phone reformatted Plan code upper-cased Whitespace trimmed+1 more
ENR-133497	ENR	Madison Martin	1960-07-24	UHC-79970-57	2893706386	1902 Camelback Rd, Denver, CO, 80218	0.92	Name re-cased Phone reformatted City re-cased Plan code upper-cased
CLM-419648	CLM	Lucai V Graham	1950-04-07	UHC-22262-48	4639036935	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
PRV-22909	PRV	Mariana T Green	1989-08-17	UHC-41515-80	—	9052 Grand Ave, Denver, CO, 80222	0.92	City re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
ENR-111282	ENR	Angela Valdez	1994-12-28	UHC-70844-46	9305551834	6996 Jefferson Ave, Minneapolis, MN, 55494	0.92	Name re-cased Date of birth reformatted City re-cased Plan code upper-cased
ENR-136313	ENR	Beverly G Murray	2005-04-24	UHC-14487-15	5837468046	1121 Apache Blvd, Glendale, AZ, 85359	0.92	Email lower-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-413611	CLM	Gloria Burke	1981-11-07	UHC-56404-96	3933439367	8287 Valley View Dr, Tucson, AZ, 85728	0.92	Name re-cased Phone reformatted Plan code upper-cased Placeholder values cleared
ENR-125476	ENR	Cheryl M Garcia	1989-11-19	UHC-54283-43	4237356103	210 Mesa Dr, Orlando, FL, 32829	0.92	Name re-cased Date of birth reformatted City re-cased Plan code upper-cased
ENR-120193	ENR	Daniel Patterson	1983-06-22	UHC-32182-09	9893376478	6795 Ridge Rd, San Antonio, TX, 78279	0.92	Name re-cased State code upper-cased Email lower-cased Plan code upper-cased
TPA-57667	TPA	Paul Woods	2007-09-24	—	—	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-432492	CLM	Roger Martinez	1990-03-15	UHC-40330-54	5044255946	6998 Cedar Ln, Phoenix, AZ, 85049	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
ENR-114480	ENR	Wayne H Sullivan	1953-07-27	UHC-90724-98	5195588843	2836 Apache Blvd, Atlanta, GA, 30345	0.92	Date of birth reformatted Phone reformatted Plan code upper-cased Whitespace trimmed
CLM-416841	CLM	Kimberly Henry	1990-03-27	—	—	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-426044	CLM	Russell Mendoza	1990-07-06	—	—	—	0.92	Date of birth reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-400664	CLM	Nicole Hamilton	1968-10-20	UHC-21000-52	—	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
TPA-52895	TPA	Eugene Cox	1983-02-14	—	—	28 Spring St, Miami, FL, 33105	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-408634	CLM	Susen D Reynolds	1966-09-20	UHC-74764-44	9374251094	2323 Camelback Rd, Las Vegas, NV, 89115	0.92	Phone reformatted City re-cased Plan code upper-cased Placeholder values cleared
CLM-423678	CLM	Adam B Griffin	1984-03-08	—	2058315730	—	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
ENR-137151	ENR	Bryan Wheeler	1958-07-14	UHC-77912-63	7467854283	6051 Broadway, Atlanta, GA, 30338	0.92	Date of birth reformatted Phone reformatted Plan code upper-cased Whitespace trimmed
CLM-411147	CLM	Noah Burns	2000-03-03	—	5035800367	7504 Broadway, Tampa, FL, 33687	0.92	Email lower-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
TPA-54350	TPA	Heather Cox	1991-04-26	—	—	5992 Apache Blvd, Las Vegas, NV, 89143	0.92	City re-cased State code upper-cased Plan code upper-cased Placeholder values cleared
ENR-118647	ENR	Margaret Alvarado	1965-07-03	UHC-91537-16	8415241752	1344 Willow Ct, Columbus, OH, 43221	0.92	Date of birth reformatted Phone reformatted Plan code upper-cased Whitespace trimmed
CLM-405169	CLM	Terry Williams	1974-12-27	—	—	—	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
ENR-135874	ENR	Roger Davis	1994-04-28	UHC-30457-09	2114195514	4491 Elm St, Miami, FL, 33168	0.92	Date of birth reformatted Phone reformatted Email lower-cased Plan code upper-cased
ENR-128881	ENR	Sandra Guerrero	1970-08-18	UHC-39611-40	9158851119	4202 Spring St, Glendale, AZ, 85326	0.92	Name re-cased Phone reformatted Plan code upper-cased Whitespace trimmed
CLM-416475	CLM	Roger Z Gutierrez	1975-02-25	UHC-01201-48	—	5417 Sunset Blvd, Los Angeles, CA, 90080	0.92	Name re-cased Date of birth reformatted Plan code upper-cased Placeholder values cleared
CLM-430797	CLM	Jacqueline Reyes	1961-02-08	UHC-83183-03	3416776370	—	0.92	Name re-cased Phone reformatted Plan code upper-cased Placeholder values cleared
ENR-105996	ENR	Rachel P White	1942-04-06	UHC-15447-80	6953056272	7519 Broadway, Charlotte, NC, 28223	0.92	Name re-cased Phone reformatted Plan code upper-cased Whitespace trimmed
CLM-409284	CLM	Janice Montgomery	2005-11-28	UHC-33646-35	—	5292 Union St, Jacksonville, FL, 32272	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-409288	CLM	Skott Johnston	1991-06-01	UHC-09585-03	—	8261 Pine Dr, San Diego, CA, 92181	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
ENR-106168	ENR	Beveryl Lewis	1941-01-11	UHC-00003-91	5805101835	—	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-425597	CLM	Kimberly Bryant	1999-01-19	UHC-33003-66	—	1902 Willow Ct, Dallas, TX, 75298	0.92	City re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-421933	CLM	Maria J Wells	2005-07-01	UHC-83588-76	—	2693 Highland Ave, Eden Prairie, MN, 55364	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-414941	CLM	Benjamin I Contreras	1980-06-23	—	9464555695	—	0.92	Phone reformatted Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-418796	CLM	Anna Hawkins	1960-01-26	UHC-90995-47	3525018254	—	0.92	Date of birth reformatted Phone reformatted Plan code upper-cased Placeholder values cleared
TPA-53221	TPA	Daiel Garcia	1961-06-10	—	—	7755 Washington St, Mesa, AZ, 85270	0.92	Name re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared

3,278 rows, page 57 of 66Previous Next