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

All ENR CLM TPA PRV

Junk onlyFlagPhone reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-417211	CLM	Charlotte Hansen	1997-03-05	UHC-81644-64	6304078301	2692 Palm Dr, Scottsdale, AZ, 85271	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-410571	CLM	Anna T King	1969-06-24	UHC-06699-58	5614772383	6659 Highland Ave, Los Angeles, CA, 90028	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-421827	CLM	Matthew Marquez	1963-03-11	UHC-91418-75	3106503184	3974 Harbor Blvd, Sacramento, CA, 95824	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-410247	CLM	Lisa Morales	1946-10-19	UHC-21468-84	6047265391	2095 Washington St, San Diego, CA, 92193	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-432251	CLM	Catherine Romero	1952-02-09	—	9445379019	9615 Camelback Rd, Tempe, AZ, 85263	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-426526	CLM	Ray Carpenter	1968-04-14	UHC-37527-46	9809553635	64 Palm Dr, Tucson, AZ, 85720	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-414176	CLM	Ralph Wang	1957-12-03	UHC-14239-31	9104336575	5835 Washington St, Chandler, AZ, 85295	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-406294	CLM	Owens Albert	1942-03-01	UHC-26507-26	7425190776	367 Central Ave, Charlotte, NC, 28236	0.78	Name re-cased Two-digit birth year Phone reformatted Email lower-cased+1 more
CLM-423451	CLM	Calr T Cook	2004-02-25	UHC-49730-21	4118118381	9307 Camelback Rd, Plano, TX, 75022	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-402366	CLM	Rogeer Crawfford	1966-01-21	—	3098485055	—	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
CLM-418063	CLM	Santiago Martinez	1959-06-09	UHC-34421-47	9322157494	225 Harbor Blvd, Minneapolis, MN, 55433	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-416769	CLM	Samuel H Montgomery	1946-10-24	UHC-58307-57	3413630104	1004 Pine Dr, Sacramento, CA, 95879	0.78	Name re-cased Phone reformatted State code upper-cased Gender normalised+1 more
CLM-412899	CLM	Maria Flores	1956-05-10	UHC-60594-77	3234916534	8247 River Rd, Charlotte, NC, 28285	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-410146	CLM	Theresa Diaz	1940-08-20	—	6303533211	5033 Oak St, Mesa, AZ, 85293	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-422845	CLM	Ana Gilbert	1979-03-17	UHC-96425-46	3386953263	3101 Ridge Rd, Houston, TX, 77068	0.78	Name re-cased Phone reformatted State name converted to code Whitespace trimmed+1 more
CLM-406524	CLM	Cynthia Torres	1978-03-02	UHC-94028-02	6349455581	7270 Park Pl, Gilbert, AZ, 85256	0.78	Name re-cased Two-digit birth year Phone reformatted City re-cased+1 more
CLM-429253	CLM	Mei Mliler	1981-04-16	UHC-86504-87	8232901643	8901 Indian School Rd, Austin, TX, 78766	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-426933	CLM	Michael Olson	1938-05-19	—	8234826775	995 Camelback Rd, Tucson, AZ, 85794	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-422140	CLM	Joan Edwards	1956-07-06	UHC-88614-34	4917616897	4205 Union St, Dallas, TX, 75293	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-402583	CLM	Philip Crawford	1964-08-16	UHC-09959-89	3057207867	—	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
CLM-406137	CLM	Diana Berry	1978-03-11	—	6816581324	8859 Spring St, Miami, FL, 33197	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-414608	CLM	Rachel Perez	1996-09-20	—	4264143253	6993 Mountain View Dr, Chandler, AZ, 85206	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-430630	CLM	Jesse H Hanson	1956-05-19	UHC-23601-51	7014751587	712 Spring St, Nashville, TN, 37211	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-404021	CLM	Ethan Rios	1992-05-13	UHC-98500-33	2722856719	143 Lake View Rd, Orlando, FL, 32828	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-419001	CLM	Daniel Johnson	1941-03-27	—	2854810846	3104 Oak St, Mesa, AZ, 85237	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-425043	CLM	Patrick Jordan	1948-08-20	UHC-27638-29	9009636389	5088 Mesa Dr, San Antonio, TX, 78269	0.78	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+1 more
CLM-423250	CLM	Nicole Ray	1991-05-02	UHC-64218-26	9488690466	4464 Sunset Blvd, Minneapolis, MN, 55465	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-422063	CLM	Janet W Aguilar	1959-11-13	UHC-58854-62	3556563331	—	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
CLM-400590	CLM	Kathleen Le	1997-11-22	—	7797794064	4502 Pine Dr, Jacksonville, FL	0.78	Name re-cased Phone reformatted ZIP missing Whitespace trimmed+1 more
CLM-410179	CLM	Brian Richardson	2007-07-09	—	5084159103	—	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
CLM-431816	CLM	Camila F Fuller	1989-01-15	—	6003770152	5726 Church St, Sacramento, CA, 95831	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-407186	CLM	Linda Obrien	1944-04-01	UHC-52970-96	5585792710	—	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
CLM-401083	CLM	Jimmy Bryant	2000-12-16	UHC-67105-34	7935418540	8331 Mesa Dr, Glendale, AZ, 85377	0.78	Name re-cased Phone reformatted City re-cased ZIP+4 trimmed+1 more
CLM-427366	CLM	Mary Carroll	2002-08-18	UHC-52050-46	8658569274	—	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
CLM-406064	CLM	Debra E Weaver	1985-11-18	UHC-01924-45	8038909258	7368 Washington St, Scottsdale, AZ, 85261	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-406722	CLM	Kathleen Bailay	1983-04-15	UHC-81568-33	9575049058	6841 Park Pl, Eden Prairie, MN, 55334	0.78	Phone reformatted Street suffix standardised Address re-cased State code upper-cased+1 more
CLM-411285	CLM	Willie Reynolds	1947-10-04	UHC-78768-85	6115980362	2369 Mesa Dr, Austin, TX, 78791	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-413864	CLM	Lucia Fox	2001-05-26	UHC-54071-15	6522938424	7938 Ridge Rd, Los Angeles, CA, 90052	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-410067	CLM	Natalie McCoy	2001-10-02	UHC-26564-74	2496150304	7730 Hillcrest Rd, Charlotte, NC, 28237	0.78	Phone reformatted State code upper-cased Gender normalised Whitespace trimmed+1 more
CLM-415502	CLM	Ryan Mendez	1950-05-28	UHC-79204-52	5159522857	—	0.78	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+1 more
CLM-419999	CLM	Turner Steven	1940-04-27	—	5749051761	7023 River Rd, Gilbert, AZ, 85239	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-412761	CLM	Sofia Fields	1992-11-05	UHC-87225-68	4844312014	—	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
CLM-425599	CLM	Carol Stevens	1965-12-10	UHC-68436-17	5304496444	8238 Indian School Rd, Eden Prairie, MN, 55343	0.78	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+1 more
CLM-408559	CLM	Cynthia Chen	2008-03-08	UHC-28065-94	4309762568	7374 Lake View Rd, Charlotte, NC	0.78	Date of birth reformatted Phone reformatted ZIP missing Whitespace trimmed+1 more
CLM-422642	CLM	Deborah Willis	1975-02-17	UHC-78282-13	2116727261	2399 Harbor Blvd, Miami, FL, 33157	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-431592	CLM	Mary V Hudson	1995-01-14	—	7754797193	9385 Mesa Dr, San Diego, CA, 92171	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-400920	CLM	Catherine Hoffman	1949-01-28	—	4744385613	5813 Indian School Rd, San Diego, CA, 92113	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-414458	CLM	Ashley Reed	2002-09-19	UHC-81438-97	6046028141	418 Ridge Rd, Charlotte, NC, 28289	0.78	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-419766	CLM	Chris Washington	1996-03-01	UHC-95770-57	8908868216	6603 Cedar Ln, Charlotte, NC, 28218	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-417882	CLM	Gregory O Taylor	1975-03-06	UHC-40403-19	8789534201	3415 Washington St, Gilbert, AZ, 85212	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more

11,960 rows, page 134 of 240Previous Next