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

All ENR CLM TPA PRV

Junk onlyFlagZIP missingClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-423118	CLM	Barbara Reed	1968-01-07	—	4662319638	3533 Ridge Rd, Miami, FL	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-407358	CLM	Eric L Palmer	1964-11-24	UHC-87376-84	7423225171	7424 Palm Dr, Los Angeles, CA	0.60	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-409346	CLM	Timothy X Weber	2004-08-09	UHC-38193-02	8485910817	2356 Meadow Ln, Minneapolis, MN	0.60	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+4 more
CLM-420758	CLM	Mark Chen	1961-09-23	—	3624185539	5207 Maple Ave, Dallas, TX	0.60	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-404600	CLM	Deborah Vazquez	2002-04-08	—	—	7172 Bayshore Dr, Tucson, AZ	0.60	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+4 more
CLM-412302	CLM	Mei Flores	1961-10-21	UHC-84637-68	4044486579	8565 Park Pl, Austin, TX	0.60	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+4 more
CLM-427707	CLM	Natalie Ruiz	1955-01-02	UHC-88246-04	9158124870	5510 Grand Ave, Tucson, AZ	0.60	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-424479	CLM	Bryan Romero	1993-02-04	—	9345225271	6621 Baseline Rd, Gilbert, AZ	0.60	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-423292	CLM	Robert Moore	1975-11-08	—	—	3363 Meadow Ln, Tucson, AZ	0.60	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+4 more
CLM-430923	CLM	Baker Emma	1995-06-15	UHC-19416-16	9808306226	2129 Market St, Chandler, AZ	0.60	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-422918	CLM	Alexis W Parker	1988-11-26	UHC-53530-87	4048602689	2479 Harbor Blvd, Austin, TX	0.60	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-408828	CLM	Grace Jacksson	1997-02-25	UHC-37567-28	—	6072 Meadow Ln, Houston, TX	0.60	Name re-cased Street suffix standardised Address re-cased City re-cased+4 more
CLM-418465	CLM	Brittany Rios	1946-01-13	UHC-10619-92	2496124145	5474 Hillcrest Rd, Dallas, TX	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-418466	CLM	Brittany Rios	1946-01-13	UHC-10619-92	2496124145	5474 Hillcrest Rd, Dallas, TX	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-403376	CLM	Cheryl Q Henry	1955-08-19	UHC-97793-44	5987324108	4304 Canyon Rd, Tucson, AZ	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-403507	CLM	Ruth Carr	2006-04-27	—	9594544279	692 Bayshore Dr, Dallas, TX	0.60	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-408530	CLM	Judith Dean	1998-06-17	UHC-47353-96	9897444303	7492 Market St, Mesa, AZ	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-415811	CLM	Joshua Simmons	1974-12-28	UHC-19558-30	5789115047	1213 Main St, Seattle, WA	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-419870	CLM	Sofia Kelley	1956-01-22	UHC-11034-93	4126428121	7324 Sage Ct, Tampa, FL	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-410515	CLM	Kayla Bailey	1981-10-10	UHC-99784-06	6419740117	9032 Sunset Blvd, Tempe, AZ	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-429553	CLM	Anna Harvey	1968-10-09	UHC-53608-54	7775745458	3429 Forest Ave, Chandler, AZ	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-429554	CLM	Anna Harvey	1968-10-09	UHC-53608-54	7775745458	3429 Forest Ave, Chandler, AZ	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-427317	CLM	Larry Lee	2005-12-19	UHC-32257-04	—	3908 Canyon Rd, Nashville, TN	0.60	Name re-cased Street suffix standardised Address re-cased City re-cased+4 more
CLM-426991	CLM	Martha Jenkins	1987-01-15	—	2944769082	8650 Apache Blvd, Sacramento, CA	0.60	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-416593	CLM	John Larson	1979-08-14	UHC-27245-80	—	6872 Palm Dr, Phoenix, AZ	0.60	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+4 more
CLM-406592	CLM	Mateo B Castro	1969-09-04	UHC-93344-27	—	9205 Apache Blvd, Phoenix, AZ	0.60	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+4 more
CLM-409471	CLM	Betty Mendez	1998-09-03	UHC-07773-92	—	5766 Spring St, Dallas, TX	0.60	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+4 more
CLM-422368	CLM	Diane Evans	1960-08-13	UHC-63208-52	3978918720	3144 Church St, Austin, TX	0.60	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-415633	CLM	Mei Wallace	2005-01-01	—	5749701826	4583 Cedar Ln, Seattle, WA	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-417151	CLM	Maria T Hansen	1977-08-11	UHC-09268-60	4477645750	7203 Central Ave, Los Angeles, CA	0.60	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-418820	CLM	Marilyn Garrett	1941-06-07	—	2395611866	2901 Cedar Ln, San Diego, CA	0.60	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+4 more
CLM-423765	CLM	Margaret Stevens	1981-12-12	—	5066262864	7419 Baseline Rd, Atlanta, GA	0.60	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-410141	CLM	Kayla Jenkins	1941-11-12	—	9663585153	8645 Hillcrest Rd, Fresno, CA	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-418112	CLM	Arthur Oliver	1995-04-22	—	5062102612	8600 Union St, Houston, TX	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-418113	CLM	Arthur Oliver	1995-04-22	—	5062102612	8600 Union St, Houston, TX	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-407480	CLM	William Harrison	1956-07-19	UHC-32299-78	7804022643	586 River Rd, Glendale, AZ	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-429627	CLM	Ruth H Carpenter	1944-07-27	—	9015545220	7473 Meadow Ln, Dallas, TX	0.60	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-400716	CLM	Lori Meyer	1959-11-17	UHC-13791-29	3623758366	9738 Canyon Rd, Charlotte, NC	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-426129	CLM	James Ortiz	1940-06-28	—	5575874242	7211 Desert Sky Blvd, Phoenix, AZ	0.60	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+4 more
CLM-403834	CLM	Amanda Hunt	1954-01-17	UHC-86125-97	5332318767	6446 Cedar Ln, Austin, TX	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-420440	CLM	Noah Cook	1982-04-09	UHC-47414-31	—	496 Market St, Tempe, AZ	0.60	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+4 more
CLM-400528	CLM	Boby Alexander	2000-12-16	UHC-78998-29	3163077428	3251 Highland Ave, Dallas, TX	0.60	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-416975	CLM	Benjamin Franklin	1976-05-28	UHC-88306-24	—	6093 Central Ave, Eden Prairie, MN	0.60	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+4 more
CLM-405258	CLM	Frak Padilla	1964-02-14	UHC-18739-54	—	3588 River Rd, Minneapolis, MN	0.60	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+4 more
CLM-418892	CLM	Emily Young	1977-01-26	UHC-47480-60	8583436208	8117 Apache Blvd, Mesa, AZ	0.60	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+4 more
CLM-408389	CLM	Karen Wells	1989-06-21	UHC-15913-51	—	3908 Sunset Blvd, Nashville, TN	0.60	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+4 more
CLM-401812	CLM	Jacqueline Willsi	2003-09-05	UHC-69078-97	8716036630	5661 Sage Ct, San Diego, CA	0.60	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-417174	CLM	Carolyn L Coleman	1991-03-16	—	2417098567	8911 Oak St, Chandler, AZ	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-428778	CLM	Anna Bowman	2007-03-24	UHC-89187-82	5295762468	3232 Spring St, Orlando, FL	0.60	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
CLM-417525	CLM	Marilyn S King	1970-10-14	—	8824665571	7092 Pine Dr, Houston, TX	0.60	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+4 more

2,072 rows, page 15 of 42Previous Next