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 reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagDate of birth reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-424846	CLM	Michelle R Gutierrez	1998-01-28	—	—	6253 Grand Ave, Orlando, FL, 32870	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-429638	CLM	Ashley Brooks	1960-03-11	—	3555061917	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-408008	CLM	Joe G Coleman	1952-07-16	UHC-89912-98	—	5241 Cedar Ln, Mesa, AZ, 85208	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-422286	CLM	Dorothy P Knnedy	2007-11-23	—	8514585428	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-400761	CLM	Ruth Taylor	1947-06-13	—	—	5620 Jefferson Ave, Columbus, OH, 43228	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-430743	CLM	Larry Hansen	1999-08-13	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-404321	CLM	Gerald Robertson	2008-07-13	UHC-67430-52	6175138326	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-408042	CLM	Heather A Hernandez	1977-03-19	—	—	9822 Park Pl, Seattle, WA, 98183	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-405576	CLM	Steve Silva	1976-05-11	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-423533	CLM	Eugene Harper	1961-01-04	UHC-85086-86	—	787 Baseline Rd, Dallas, TX, 75286	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-403682	CLM	Sean U Watkins	2006-06-01	UHC-29684-80	2899082366	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-421940	CLM	Diane Collins	1938-01-18	UHC-37162-48	9784235205	1129 Lake View Rd, Scottsdale, AZ, 85263	0.94	Date of birth reformatted Phone reformatted Whitespace trimmed
CLM-421941	CLM	Diane Collins	1938-01-18	UHC-37162-48	9784235205	1129 Lake View Rd, Scottsdale, AZ, 85263	0.94	Date of birth reformatted Phone reformatted Whitespace trimmed
CLM-420935	CLM	Timothy Vasquez	1946-08-16	UHC-40176-50	8972271401	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-417515	CLM	Gloria J Simpson	1956-08-27	—	—	4897 Oak St, Atlanta, GA, 30301	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-403903	CLM	Abigail Z Ross	1995-08-04	UHC-71602-30	—	6230 Mesa Dr, Glendale, AZ, 85314	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-426022	CLM	Christopher Mendoza	1986-01-10	UHC-51445-02	—	1970 Central Ave, Nashville, TN, 37268	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-405795	CLM	Eugene Barnes	1983-07-09	—	3544877383	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-403205	CLM	Mariana C Collins	1966-09-24	UHC-57189-74	7359498191	9011 Pine Dr, Jacksonville, FL, 32277	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-420986	CLM	Gerald Larson	1986-02-15	UHC-81528-16	4435153502	8163 Valley View Dr, Atlanta, GA, 30381	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-426977	CLM	Peter U Vega	2002-04-06	UHC-80214-61	7925911289	3312 Ridge Rd, Fresno, CA, 93788	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-429707	CLM	Stephen Harris	1981-05-01	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-427907	CLM	Emma Clarrk	2005-11-07	UHC-74207-75	—	8762 River Rd, Phoenix, AZ, 85083	0.94	Date of birth reformatted Email lower-cased Placeholder values cleared
CLM-403921	CLM	Zachary Carlson	2003-10-23	UHC-05862-91	—	6475 Jefferson Ave, Denver, CO, 80273	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-404778	CLM	Stephen Padilla	1944-08-13	UHC-17049-24	—	5987 River Rd, Eden Prairie, MN, 55306	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-403320	CLM	Steven Fox	1996-08-10	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-429846	CLM	Keith T Herrera	1956-03-18	UHC-35510-37	—	1213 Palm Dr, Plano, TX, 75043	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-409494	CLM	Nathan Cunningham	1938-05-08	—	5242251717	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-409293	CLM	Stephanie Hamilton	1963-09-04	UHC-40363-22	—	6214 Baseline Rd, Columbus, OH, 43244	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-431572	CLM	Catherine Q Wright	1952-12-03	UHC-46069-48	—	4260 Lake View Rd, Jacksonville, FL, 32256	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-428008	CLM	Sophia E Johnston	1970-05-28	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-418928	CLM	Cheryl Bradley	1963-04-03	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-423063	CLM	Beverly Valdez	1989-10-24	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-430994	CLM	Sofia Wbb	1960-12-02	UHC-18146-96	—	265 Ridge Rd, Tampa, FL, 33645	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-428682	CLM	Gary K Perkins	1960-01-03	UHC-08811-48	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-427779	CLM	Daniels Abigail	1969-05-18	UHC-73907-78	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-418567	CLM	Yuki Walsh	1964-08-04	UHC-48388-19	2464445493	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-425984	CLM	Donna Ramirez	1978-07-06	UHC-71663-58	3333590613	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-429860	CLM	Jeffrey Cox	1998-05-27	UHC-10954-72	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-422791	CLM	Juan Porter	1948-09-03	UHC-58014-34	—	650 Church St, Minneapolis, MN, 55428	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-424318	CLM	Hiroshi Phillips	1988-06-09	UHC-74919-73	3133688048	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-404136	CLM	Emiyl Valdez	1942-11-17	UHC-53364-70	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-405345	CLM	Gregory Delgado	1967-06-02	—	3102115531	4663 Harbor Blvd, Seattle, WA, 98178	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-408136	CLM	Joseph K Scott	1975-08-21	UHC-72343-79	—	7502 Desert Sky Blvd, Austin, TX, 78761	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-421203	CLM	Kathleen Santiago	1943-10-11	—	5027555551	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-427539	CLM	Mei Lane	1968-03-21	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-403077	CLM	Roy Howell	1951-03-05	UHC-50013-23	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-417304	CLM	Theresa Burns	1961-08-13	UHC-49456-91	8677651239	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-418477	CLM	Theresa Grray	1968-05-05	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-400839	CLM	Sara Daniels	1961-03-27	UHC-86981-74	—	8035 Jefferson Ave, Charlotte, NC, 28267	0.94	Name re-cased Date of birth reformatted Placeholder values cleared

10,559 rows, page 191 of 212Previous Next