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-418140	CLM	Bennett Henry	1952-01-06	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-407521	CLM	Keith Nguyen	1947-11-24	—	—	6118 Harbor Blvd, Phoenix, AZ, 85078	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-432531	CLM	Joe Martin	2008-02-18	UHC-97135-53	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-426049	CLM	Sarah Li	1946-03-24	UHC-49550-89	—	4849 Mesa Dr, Chandler, AZ, 85232	0.94	Name re-cased Date of birth reformatted Whitespace trimmed
CLM-420504	CLM	Murphy Charlotte	1944-06-28	—	4147956146	5478 Main St, Phoenix, AZ, 85035	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-426871	CLM	Wei Garza	1973-05-16	UHC-65237-74	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-408355	CLM	Camila M Lucas	1959-11-09	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-427063	CLM	Angela Ellis	1999-03-03	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-414313	CLM	Carolyn Harrison	1998-09-18	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-403447	CLM	Mateo Johnson	1986-09-05	UHC-24566-34	9848169043	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-400525	CLM	Don Owens	1975-08-15	UHC-44374-68	—	4305 Ridge Rd, Nashville, TN, 37203	0.94	Date of birth reformatted State code upper-cased Placeholder values cleared
CLM-423502	CLM	David Montomery	1974-08-16	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-423006	CLM	John Vasquez	1977-10-25	UHC-12628-50	6315223474	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-413565	CLM	Sophia Roberts	1977-02-18	UHC-64051-25	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-421274	CLM	Janet Brown	1939-08-23	—	6197299720	1614 Washington St, Dallas, TX, 75288	0.94	Date of birth reformatted Phone reformatted Whitespace trimmed
CLM-411450	CLM	Olivia I Coleman	1967-06-19	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-411478	CLM	Michelle Riley	1939-03-18	UHC-95909-02	3256413894	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-418804	CLM	Melissa Moreno	1988-04-02	—	—	5025 Oak St, Chandler, AZ, 85295	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-428022	CLM	Anthony D Guerrero	1953-12-24	—	3567785681	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-408390	CLM	Evelyn Oliver	1968-04-04	UHC-48468-84	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-405055	CLM	Richard Bailey	2001-07-09	—	—	5843 Church St, Charlotte, NC, 28244	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-414551	CLM	Gloria Bailey	1959-02-20	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-419199	CLM	Mei West	1967-06-26	UHC-89424-95	6868852208	9560 Lincoln Way, Austin, TX, 78729	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-419841	CLM	Nicole Welch	1975-05-01	UHC-08156-10	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-415055	CLM	Raymond Kim	2002-05-10	UHC-89856-22	7678130137	1535 Main St, Tempe, AZ, 85297	0.94	Date of birth reformatted Phone reformatted Whitespace trimmed
CLM-423249	CLM	Daniel Crawford	1971-10-07	—	—	6419 Meadow Ln, Mesa, AZ, 85245	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-401782	CLM	Jeremy Bailey	1956-06-22	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-415670	CLM	Brian Cunningham	1968-01-05	UHC-12586-89	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-400455	CLM	Nicole Chen	1978-03-01	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-428181	CLM	Samuel Warren	2003-06-02	UHC-67401-51	—	4561 Pine Dr, Mesa, AZ, 85246	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-424894	CLM	Frank Roberts	1982-06-11	—	3555231096	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-413423	CLM	Russell S Bailey	1987-04-01	UHC-87909-52	4224240293	4758 Maple Ave, Chandler, AZ, 85276	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-425093	CLM	Paul G Luna	1974-05-11	UHC-71549-96	—	9143 Union St, Glendale, AZ, 85333	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-418808	CLM	Timothy J Dean	1973-10-26	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-401251	CLM	Carlos Scott	1943-08-20	UHC-29310-13	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-432131	CLM	George N Berry	2006-06-25	UHC-53417-41	—	2479 Broadway, San Diego, CA, 92135	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-401995	CLM	Vincent Salazar	1995-11-20	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-426177	CLM	Jose J Jordan	1947-12-06	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-413216	CLM	Allbert Mendez	1972-10-21	—	—	1232 Desert Sky Blvd, Houston, TX, 77004	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
CLM-431798	CLM	Sam Gibson	1957-09-02	UHC-11351-96	8212015556	—	0.94	Date of birth reformatted Phone reformatted Member ID reformatted
CLM-405634	CLM	Mason Morales	1942-02-27	UHC-35536-56	5784132648	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-403256	CLM	Gary Palmer	1948-08-24	UHC-85894-33	7318882464	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-424467	CLM	Ronald Rodriguez	1997-08-28	UHC-68443-56	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-430863	CLM	Donna Lucas	1972-08-05	UHC-67714-84	3549613361	2603 Camelback Rd, Sacramento, CA, 95831	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-411979	CLM	Hiroshi J Lawrence	1943-01-16	—	—	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-419878	CLM	Mariana Nguyen	1974-09-10	UHC-30578-85	—	789 Highland Ave, Glendale, AZ, 85338	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-422650	CLM	Danielle I Duncan	2008-05-08	UHC-27925-26	—	—	0.94	Name re-cased Date of birth reformatted Whitespace trimmed
CLM-414137	CLM	Betty Russell	1946-01-04	UHC-61120-67	3286897236	—	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-418865	CLM	Alice Sims	1996-12-15	UHC-33070-12	6664276654	3652 Washington St, Dallas, TX, 75282	0.94	Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-431065	CLM	Madison Johnson	1985-03-26	—	—	1279 Broadway, Tucson, AZ, 85702	0.94	Name re-cased Date of birth reformatted Placeholder values cleared

10,559 rows, page 187 of 212Previous Next