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

Claims, 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-407969	CLM	Samantha Weaver	—	—	8098140489	419 Oak St, Scottsdale, AZ, 85236	0.60	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+4 more
CLM-417977	CLM	Park Hiroshi	—	—	5464354921	4378 Apache Blvd, Gilbert, AZ, 85241	0.60	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+4 more
CLM-416568	CLM	Stephanie Lane	—	UHC-25162-84	4474942332	7072 Baseline Rd, Atlanta, GA, 30315	0.62	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-412183	CLM	Kathryn Hart	—	—	6156147128	1868 Park Pl, Jacksonville, FL, 32215	0.62	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+3 more
CLM-417005	CLM	Joshua Crawford	—	UHC-22291-10	2445474690	1591 Bayshore Dr, Glendale, AZ, 85314	0.62	Name re-cased Date of birth missing Phone reformatted City re-cased+3 more
CLM-424079	CLM	Lucia E Padilla	—	—	7774201493	1051 Maple Ave, Columbus, OH, 43298	0.62	Name re-cased Date of birth missing Street suffix standardised Address re-cased+3 more
CLM-422661	CLM	Sara Duncan	—	UHC-26231-77	2686028171	2909 Pine Dr, Gilbert, AZ, 85202	0.62	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+3 more
CLM-419079	CLM	Randy Harrison	—	UHC-87479-89	2592509132	7261 Hillcrest Rd, Denver, CO, 80221	0.62	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+3 more
CLM-401070	CLM	Eric Jimenez	—	—	—	3062 Meadow Ln, Chandler, AZ, 85250	0.62	Name re-cased Date of birth missing Street suffix standardised Address re-cased+3 more
CLM-400924	CLM	Peter Carter	—	—	5982547530	8215 Market St, Fresno, CA, 93755	0.62	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+3 more
CLM-409551	CLM	Angela Ray	—	—	7735085024	7226 Sage Ct, Tampa, FL, 33616	0.62	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+3 more
CLM-412282	CLM	Christopher Rivera	—	UHC-38401-49	7849409167	7584 Grand Ave, Tucson, AZ, 85787	0.62	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-426777	CLM	Roy Ellis	—	UHC-97344-04	2135606666	2423 Central Ave, Mesa, AZ, 85234	0.62	Name re-cased Date of birth missing Phone reformatted Member ID reformatted+3 more
CLM-408771	CLM	Joyce Gibson	—	UHC-76784-79	6918799287	9321 Mesa Dr, Atlanta, GA, 30381	0.62	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-405262	CLM	Helen Simmmons	—	—	4919270856	711 Oak St, Eden Prairie, MN, 55377	0.62	Name re-cased Date of birth missing Street suffix standardised Address re-cased+3 more
CLM-414173	CLM	Eric Freeman	—	UHC-11481-11	—	533 Highland Ave, Dallas, TX, 75252	0.62	Date of birth missing Member ID reformatted Street suffix standardised Address re-cased+3 more
CLM-422113	CLM	Gloria Brooks	—	—	3253953961	9448 Cedar Ln, Orlando, FL, 32813	0.62	Name re-cased Date of birth missing Street suffix standardised Address re-cased+3 more
CLM-431213	CLM	Sophia Daniiels	—	UHC-50502-80	—	9788 Jefferson Ave, Denver, CO, 80275	0.62	Name re-cased Date of birth missing Street suffix standardised Address re-cased+3 more
CLM-403285	CLM	Judith Gilbert	—	—	—	7478 Market St, Austin, TX, 78715	0.62	Date of birth missing Street suffix standardised Address re-cased City re-cased+3 more
CLM-400910	CLM	Terry L Gibson	—	—	2212555050	5213 Spring St, Seattle, WA, 98159	0.64	Date of birth missing Street suffix standardised Address re-cased City re-cased+2 more
CLM-429433	CLM	Jack Smith	—	—	—	742 Bayshore Dr, Las Vegas, NV, 89189	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
CLM-419371	CLM	Mateo A Nichols	—	—	3852589739	8569 Sunset Blvd, Miami, FL, 33183	0.64	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-424948	CLM	Deborah Luna	—	UHC-71000-23	9327912460	5251 Camelback Rd, Gilbert, AZ, 85233	0.64	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-417361	CLM	Emily Harris	—	UHC-11654-18	9854768765	5568 Apache Blvd, Orlando, FL, 32860	0.64	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-418338	CLM	Dorothy Griffin	—	UHC-53734-03	—	3855 Spring St, Orlando, FL, 32886	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
CLM-418337	CLM	Dorothy Griffin	—	UHC-53734-03	—	3855 Spring St, Orlando, FL, 32886	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
CLM-424986	CLM	Lawrence Klly	—	UHC-38369-92	—	9622 Central Ave, Fresno, CA, 93798	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
CLM-426025	CLM	Valentina Welch	—	—	8166164652	6400 Sunset Blvd, Denver, CO, 80289	0.64	Date of birth missing Street suffix standardised Address re-cased City re-cased+2 more
CLM-422799	CLM	Terry Duncan	—	UHC-48122-41	4503059619	3045 Highland Ave, Plano, TX, 75088	0.64	Name split from “Last, First”Date of birth missing Phone reformatted Member ID reformatted+2 more
CLM-414362	CLM	Barbara Oliver	—	UHC-71536-77	—	2343 Sunset Blvd, Austin, TX, 78778	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
CLM-401555	CLM	Ed Baker	—	—	—	5237 Jefferson Ave, Denver, CO, 80253	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
CLM-410755	CLM	Mateo Cook	—	UHC-41125-17	—	—	0.64	Name re-cased Date of birth missing Phone missing area code Member ID reformatted+2 more
CLM-427922	CLM	Walter Duncaan	—	—	7473988264	4410 Apache Blvd, Chandler, AZ, 85233	0.64	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-432297	CLM	Sara Wood	—	UHC-68954-87	7834411944	3466 Oak St, Austin, TX, 78722	0.64	Date of birth missing Member ID reformatted Street suffix standardised Address re-cased+2 more
CLM-427037	CLM	Kyle Cuok	—	UHC-80562-19	9472163495	8422 Hillcrest Rd, Tampa, FL, 33671	0.64	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-422764	CLM	Fatima U Alvarado	—	UHC-94101-36	—	2711 Desert Sky Blvd, Chandler, AZ, 85277	0.64	Date of birth missing Street suffix standardised Address re-cased City re-cased+2 more
CLM-407197	CLM	Brandon Murpphy	—	UHC-35997-95	8619763609	5643 Valley View Dr, Houston, TX, 77069	0.64	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+2 more
CLM-402454	CLM	Miller Kellly	—	UHC-25101-70	7846563919	8861 Sage Ct, Plano, TX, 75073	0.64	Name re-cased Date of birth missing Member ID reformatted Street suffix standardised+2 more
CLM-410292	CLM	Kimberly Lopez	—	—	—	8071 Church St, Phoenix, AZ	0.64	Name re-cased Date of birth missing City re-cased ZIP missing+2 more
CLM-413093	CLM	Cynthia Mejia	—	UHC-80006-11	—	8021 Spring St, Austin, TX, 78792	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
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
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
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
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
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
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
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
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

320 rows, page 3 of 7Previous Next