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 “Date of birth missing”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagDate of birth missingClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-411181	CLM	Beverly Wilson	—	UHC-95133-67	—	554 Pine Dr, Atlanta, GA, 30349	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
ENR-138981	ENR	Samantha H Armstrong	—	UHC-46849-18	4226324549	6687 Elm St, Denver, CO, 80297	0.64	Name re-cased Date of birth missing Member ID reformatted Street suffix standardised+2 more
PRV-21750	PRV	Shirley Hal	—	—	—	8151 Jefferson Ave, Sacramento, CA, 95837	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
ENR-103933	ENR	Helen Watson	—	UHC-33900-83	5723727918	1344 Lake View Rd, Scottsdale, AZ, 85218	0.64	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+2 more
ENR-103932	ENR	Helen Watson	—	UHC-33900-83	5723727918	1344 Lake View Rd, Scottsdale, AZ, 85218	0.64	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+2 more
ENR-141282	ENR	Stephen A Lee	—	UHC-61986-10	6817270581	2563 Grand Ave, Atlanta, GA, 30306	0.64	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+2 more
TPA-62759	TPA	Diane George	—	—	—	6546 Spring St, Houston, TX, 77077	0.64	Date of birth missing Street suffix standardised Address re-cased City re-cased+2 more
PRV-26925	PRV	Vicky Clark	—	UHC-04405-72	7023078648	7958 Indian School Rd, Scottsdale, AZ, 85247	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
ENR-134283	ENR	Gloria Salazar	—	UHC-26663-56	4742442329	944 Forest Ave, Orlando, FL, 32805	0.64	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-112999	ENR	Andrea G Sanchez	—	UHC-83436-90	4354443128	4587 Lake View Rd, Houston, TX, 77087	0.64	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+2 more
CLM-429134	CLM	Juan Murray	—	UHC-76789-10	—	9062 Park Pl, Gilbert, AZ, 85263	0.64	Date of birth missing Street suffix standardised Address re-cased State code upper-cased+2 more
ENR-106729	ENR	Kimberly Harvey	—	UHC-92279-14	8504993068	8206 Cedar Ln, Fresno, CA, 93766	0.64	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-414205	CLM	Heather Simpson	—	UHC-44129-07	7052744371	4087 Apache Blvd, Plano, TX, 75005	0.64	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-123137	ENR	Mei L James	—	UHC-58231-15	2762007389	911 Oak St Apt 1, Orlando, FL, 32883	0.64	Date of birth missing Phone reformatted Member ID reformatted Unit split from street+2 more
PRV-27431	PRV	Douglas Yang	—	UHC-45248-33	—	6930 Lincoln Way, Fresno, CA, 93790	0.64	Name re-cased Date of birth missing Member ID reformatted Street suffix standardised+2 more
ENR-123755	ENR	Denise D Padilla	—	UHC-91088-69	9065685160	3946 Union St, San Antonio, TX, 78296	0.64	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+2 more
CLM-416578	CLM	Deb Price	—	UHC-27304-07	—	6605 Highland Ave, Phoenix, AZ, 85095	0.64	Date of birth missing Street suffix standardised Address re-cased City re-cased+2 more
ENR-114575	ENR	Gary Ford	—	UHC-22231-75	—	6247 Grand Ave, Miami, FL, 33122	0.64	Date of birth missing Street suffix standardised Address re-cased City re-cased+2 more
TPA-56845	TPA	Lgoan Lawson	—	UHC-11101-95	2836807393	9216 Mesa Dr, Atlanta, GA, 30313	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
PRV-25358	PRV	Jaack N Burns	—	—	3045836899	4753 Apache Blvd, San Diego, CA, 92197	0.64	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-421752	CLM	Linda T Johnon	—	—	8787245719	3980 Baseline Rd, Columbus, OH, 43215	0.64	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+2 more
CLM-421442	CLM	Austin Burton	—	UHC-94455-39	—	—	0.64	Date of birth missing Member ID reformatted Email lower-cased Gender normalised+2 more
CLM-429504	CLM	Susan S Boyd	—	UHC-70334-03	—	8404 Elm St, Gilbert, AZ, 85207	0.64	Date of birth missing Street suffix standardised Address re-cased City re-cased+2 more
ENR-135432	ENR	Kimberly D Vargas	—	UHC-25104-42	9419986597	5780 Sage Ct, Tampa, FL, 33695	0.64	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-418890	CLM	Emily Young	—	UHC-47480-60	8583436208	8117 Apache Blvd, Mesa, AZ, 85237	0.64	Date of birth missing Phone reformatted City re-cased Gender normalised+2 more
ENR-113270	ENR	Janet B Bailey	—	UHC-68660-89	7978285678	4559 Bayshore Dr, Orlando, FL, 32861	0.64	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+2 more
PRV-27227	PRV	Melissa Hawkins	—	UHC-47276-80	7004380328	4053 Forest Ave, San Diego, CA, 92140	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
CLM-408325	CLM	Lary R Jones	—	UHC-94064-39	—	6613 Jefferson Ave, Plano, TX, 75089	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
ENR-137372	ENR	Sue Jimenez	—	UHC-77826-79	—	4500 Meadow Ln, Charlotte, NC, 28215	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
CLM-402252	CLM	Nancy Bennett	—	—	4122555921	7655 Bayshore Dr, Denver, CO, 80244	0.64	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-420190	CLM	Maria Gonzales	—	UHC-94421-13	—	1366 Lincoln Way, Atlanta, GA, 30321	0.64	Date of birth missing Street suffix standardised Address re-cased Plan code upper-cased+2 more
CLM-414348	CLM	Kayla Knight	—	UHC-65232-63	—	3353 Highland Ave, Mesa, AZ, 85246	0.64	Date of birth missing Street suffix standardised Address re-cased City re-cased+2 more
PRV-23033	PRV	Kayla Bailey	—	—	6419740117	5758 Pine Dr, Columbus, OH, 43256	0.64	Date of birth missing Phone reformatted State name converted to code Email lower-cased+2 more
ENR-141882	ENR	Benjamin I Taylor	—	UHC-57790-84	6475953149	1330 Forest Ave, Tampa, FL, 33652	0.64	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
TPA-64115	TPA	Kevin Mitchell	—	—	3749794017	661 Valley View Dr, Dallas, TX, 75223	0.64	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+2 more
TPA-61600	TPA	Ruth Dixon	—	—	—	4358 Park Pl, Glendale, AZ, 85349	0.64	Date of birth missing Street suffix standardised Address re-cased City re-cased+2 more
CLM-414838	CLM	Lawrence T Owens	—	—	—	2445 Grand Ave, Scottsdale, AZ, 85205	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
CLM-429616	CLM	Kevin Patel	—	UHC-81454-64	—	6854 Park Pl, Seattle, WA, 98140	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
CLM-416725	CLM	Joyce Cole	—	—	4583720955	2045 Oak St, Fresno, CA, 93728	0.64	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+2 more
CLM-425967	CLM	Sophia Walker	—	—	9819677772	—	0.66	Date of birth missing Phone reformatted Gender normalised Whitespace trimmed+1 more
TPA-58350	TPA	Willie Perez	—	—	—	5735 Park Pl, Sacramento, CA, 95810	0.66	Name re-cased Date of birth missing Street suffix standardised Address re-cased+1 more
PRV-26961	PRV	Lary Cox	—	UHC-25922-95	9553706658	4973 Grand Ave, Tampa, FL, 33619	0.66	Name split from “Last, First”Date of birth missing Phone reformatted Whitespace trimmed+1 more
CLM-406184	CLM	Laura Anderson	—	UHC-07846-02	—	5977 River Rd, Nashville, TN, 37214	0.66	Name re-cased Date of birth missing Gender normalised Whitespace trimmed+1 more
ENR-119064	ENR	Joan I Torres	—	UHC-36583-04	5434484675	7239 Ridge Rd, Orlando, FL, 32894	0.66	Date of birth missing Member ID reformatted Street suffix standardised Address re-cased+1 more
PRV-24746	PRV	Patrick Fisher	—	—	7773295953	—	0.66	Name re-cased Date of birth missing Gender normalised Whitespace trimmed+1 more
ENR-139132	ENR	Joyce W Scott	—	UHC-87147-54	4197247468	256 Mountain View Dr, Houston, TX, 77090	0.66	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-403034	CLM	Noah M Morales	—	—	—	8322 Maple Ave, San Antonio, TX, 78212	0.66	Date of birth missing Street suffix standardised Address re-cased Whitespace trimmed+1 more
TPA-57791	TPA	Willie Reynolds	—	—	2803612670	5688 Ridge Rd, Charlotte, NC, 28293	0.66	Name re-cased Date of birth missing State name converted to code Whitespace trimmed+1 more
ENR-124521	ENR	Natalie O Hoffman	—	UHC-91848-90	8585642442	4436 Highland Ave, Mesa, AZ, 85217	0.66	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+1 more
CLM-412911	CLM	Virginia Foster	—	—	—	8712 Central Ave, Gilbert, AZ, 85221	0.66	Date of birth missing Street suffix standardised Address re-cased Whitespace trimmed+1 more

990 rows, page 11 of 20Previous Next