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-426919	CLM	Omar Li	1952-06-27	—	—	2889 Central Ave, Mesa, AZ, 85299	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-401371	CLM	Mason Guzman	1965-07-26	UHC-84830-23	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-401370	CLM	Mason Guzman	1965-07-26	UHC-84830-23	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-415319	CLM	Andrea Black	1997-08-28	—	—	7581 Mesa Dr, Dallas, TX, 75287	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-412111	CLM	Patricia Ford	1988-03-04	UHC-44592-27	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-416875	CLM	Vega Ralph	1993-05-04	UHC-28916-39	—	627 Ridge Rd, Phoenix, AZ, 85094	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-405721	CLM	Roy Cook	1997-05-23	UHC-10849-81	7689751122	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-414898	CLM	Sandra Singh	1975-10-23	—	—	1491 Jefferson Ave, Gilbert, AZ, 85269	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-423157	CLM	Natalie Alvarez	1989-01-26	UHC-06309-97	—	7256 Harbor Blvd, Houston, TX, 77095	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-415930	CLM	Lucia Hawkins	2008-01-14	UHC-18251-37	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-411024	CLM	Olivia Ramirez	2002-09-06	—	—	3487 Oak St, Austin, TX, 78763	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-418015	CLM	Mei Ward	1984-01-23	UHC-21084-45	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-412461	CLM	Joyce Guzman	1969-10-22	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-413185	CLM	Charlotte Gomez	1939-09-12	UHC-76519-38	—	7981 River Rd, Sacramento, CA, 95862	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-411127	CLM	Ann Garrett	1995-08-12	UHC-09859-50	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-426417	CLM	Ahmed Gardner	1977-11-09	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-422808	CLM	Carlos Daniels	1974-11-06	UHC-27376-91	7292072607	4075 Maple Ave, Denver, CO, 80206	0.94	Date of birth reformatted Phone reformatted State code upper-cased
CLM-407079	CLM	Andrew Fisher	1976-09-27	UHC-49611-17	—	6348 Bayshore Dr, Tampa, FL, 33622	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-421786	CLM	Roger Dominguez	1944-05-15	UHC-71838-89	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-408654	CLM	Donald Chavez	1993-03-06	UHC-23736-75	9114512278	4398 Sage Ct, Eden Prairie, MN, 55382	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-402443	CLM	Joshua Turnr	1948-07-10	—	2783506599	8193 Harbor Blvd, Mesa, AZ, 85203	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-403784	CLM	Heather Walsh	1942-10-11	UHC-45163-98	9213022278	6927 Oak St, Eden Prairie, MN, 55365	0.94	Date of birth reformatted Phone reformatted City re-cased
CLM-426480	CLM	Mike Chavez	1945-04-06	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-420197	CLM	Maria Petterson	1961-12-26	UHC-50763-19	—	—	0.94	Date of birth reformatted Email lower-cased Placeholder values cleared
CLM-431977	CLM	Samuel Ray	1998-10-01	UHC-71219-67	3219583527	9124 Spring St, Charlotte, NC, 28299	0.94	Name re-cased Date of birth reformatted Whitespace trimmed
CLM-406841	CLM	Mariana Burns	1973-11-05	UHC-10019-94	2997196774	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-416748	CLM	Lauren Riley	1952-01-08	—	6992803224	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-426393	CLM	Teresa Hernandez	1946-09-11	UHC-82755-81	7528363324	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-418429	CLM	Diego T Snyder	1949-08-27	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-412773	CLM	Logan Adams	1981-05-16	UHC-54756-51	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-427995	CLM	Daniel Herrera	1938-05-23	UHC-13669-27	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-403863	CLM	Arjun Vargas	2006-03-09	UHC-30971-89	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-420815	CLM	Alexander Harris	1999-05-11	—	—	7680 Apache Blvd, Scottsdale, AZ, 85247	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-409241	CLM	Brian Contreras	1961-03-10	—	—	—	0.94	Date of birth reformatted Email lower-cased Placeholder values cleared
CLM-407305	CLM	Judith U Mills	1952-01-10	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-405939	CLM	Frances Anderson	1976-02-05	—	3248346442	7806 Market St, Dallas, TX, 75260	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-414852	CLM	Peter Gilbert	1961-12-23	UHC-05029-61	3182530104	4458 Canyon Rd, Tucson, AZ, 85775	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-408396	CLM	Jacqueline Grant	1978-12-02	—	—	9887 Spring St, Charlotte, NC, 28269	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-401224	CLM	Karen Morgan	1965-04-19	UHC-24048-52	5573360097	5824 Highland Ave, Minneapolis, MN, 55425	0.94	Name re-cased Date of birth reformatted Phone reformatted
CLM-427533	CLM	Christian Meyer	2007-04-25	UHC-81174-40	4834553818	2940 Indian School Rd, Dallas, TX, 75216	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-422858	CLM	Logan Richards	1975-05-13	UHC-43988-10	7493810582	9883 Mountain View Dr, Denver, CO, 80266	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-416839	CLM	Diego Bradley	1938-08-04	UHC-84812-31	8483218084	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-404238	CLM	Evelyn Goez	1964-11-10	—	7547276835	9527 Broadway, Orlando, FL, 32876	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-409020	CLM	Mei Mejia	1987-08-02	—	6409461791	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-406911	CLM	Pamela Perry	1948-11-24	UHC-99271-74	8473171023	5465 Maple Ave, Nashville, TN, 37232	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-400386	CLM	Mari Dominguez	1997-08-23	UHC-24070-78	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-411017	CLM	Keith Palmer	1984-02-21	UHC-38493-61	—	7266 Meadow Ln, Columbus, OH, 43211	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-400119	CLM	Kyle Carr	1978-09-07	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-406611	CLM	Brenda Bradley	1954-10-17	UHC-06264-52	—	5192 Meadow Ln, Jacksonville, FL, 32242	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-421658	CLM	Kathleen Lynch	1979-09-21	—	—	7652 Sage Ct, Austin, TX, 78794	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared

10,559 rows, page 189 of 212Previous Next