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

Provider network, flag “Name re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagName re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-28795	PRV	Mei Walsh	1980-04-15	UHC-98864-36	—	6193 Church St, Orlando, FL, 32806	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-25586	PRV	Elijah B Ruiz	1981-01-18	—	2414150805	1368 Grand Ave, Mesa, AZ, 85249	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-21265	PRV	Alan Torres	1966-05-03	—	7945164440	2033 Maple Ave, Nashville, TN, 37205	0.78	Name re-cased Phone reformatted State name converted to code Whitespace trimmed+1 more
PRV-27215	PRV	James Y Delgdo	1967-08-17	—	5082635398	3875 Mountain View Dr, Orlando, FL, 32838	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-26874	PRV	Robert Moore	1975-11-08	—	2354729736	3363 Meadow Ln, Tucson, AZ, 85725	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-24403	PRV	Arjun X Rojas	1996-08-22	—	—	1443 Lake View Rd, Sacramento, CA, 95853	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
PRV-21548	PRV	Robert Hoffman	1985-03-22	—	5276517126	17 Palm Dr, Mesa, AZ, 85243	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-20540	PRV	Diane A Lopez	2008-02-15	UHC-47129-97	8182588640	4270 Lincoln Way, Seattle, WA, 98111	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-23526	PRV	Sean Fuller	1986-08-24	UHC-36745-76	—	1395 Grand Ave, Chandler, AZ, 85201	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
PRV-29246	PRV	Jack Gray	1966-11-25	UHC-88547-19	9105895781	6736 Church St, Sacramento, CA, 95837	0.78	Name re-cased Two-digit birth year City re-cased Whitespace trimmed+1 more
PRV-20672	PRV	Denny Sandeers	1982-03-12	—	—	—	0.78	Name re-cased Email lower-cased Gender normalised Whitespace trimmed+1 more
PRV-25650	PRV	Sara P Ford	2005-12-04	UHC-92388-04	7542256746	2123 Indian School Rd, Charlotte, NC, 28221	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-22519	PRV	Judith M Dean	1998-06-17	—	9897444303	7492 Market St, Mesa, AZ, 85270	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-21856	PRV	Jordan K Richards	1964-04-15	—	—	4417 Market St, Charlotte, NC, 28204	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-23387	PRV	Alice Freeman	—	UHC-80293-63	8738938397	—	0.78	Name re-cased Date of birth unreadable Phone reformatted Whitespace trimmed+1 more
PRV-20514	PRV	Doorothy Jacobs	1942-02-04	UHC-33416-55	—	2626 River Rd, Fresno, CA, 93771	0.78	Name re-cased Street suffix standardised Address re-cased Email lower-cased+1 more
PRV-23538	PRV	Ashley Thompson	2003-06-17	UHC-02035-47	8348385087	5416 Lincoln Way, Sacramento, CA, 95875	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
PRV-23158	PRV	Joyce A Herrera	1942-06-21	UHC-61035-88	5757403081	2531 Ridge Rd, Dallas, TX, 75219	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-29396	PRV	James Ruiz	1987-07-19	UHC-92430-95	3378820309	—	0.78	Name re-cased Date of birth reformatted Member ID reformatted Gender normalised+1 more
PRV-21170	PRV	Helen Hicks	1962-07-12	UHC-81077-42	7554680846	6150 Cedar Ln, Dallas, TX, 75280	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
PRV-22455	PRV	Cheryl Little	1951-06-21	—	2967803744	8771 Meadow Ln, Eden Prairie, MN, 55382	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-20023	PRV	Vincent Hansen	1953-05-26	—	7005908077	2218 Park Pl, Las Vegas, NV, 89138	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
PRV-25540	PRV	Yuki Hanson	1981-03-04	UHC-02203-04	5829358898	—	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-25191	PRV	Elizabeth R Fisher	—	—	3406818983	8427 Main St, Jacksonville, FL, 32260	0.78	Name re-cased Date of birth unreadable City re-cased Whitespace trimmed+1 more
PRV-23664	PRV	Frank West	2008-07-19	—	3652722280	9071 Cedar Ln Apt 4, Tempe, AZ, 85266	0.78	Name re-cased Date of birth reformatted Unit split from street Plan code upper-cased+1 more
PRV-23618	PRV	Adam Gibson	1991-01-08	—	9115456638	7686 Sunset Blvd, Sacramento, CA, 95867	0.78	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
PRV-24548	PRV	Carolyn Jordan	1952-10-12	—	9293703365	3878 Market St, Charlotte, NC, 28245	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
PRV-23958	PRV	Justin Franklin	1985-09-14	UHC-39521-81	—	1730 Sage Ct, Atlanta, GA, 30378	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
PRV-25890	PRV	Adam Hughes	1974-04-05	—	7572253575	4667 Sunset Blvd, Sacramento, CA, 95821	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-21511	PRV	Ryan Warren	1981-09-17	—	8912743852	8565 Desert Sky Blvd, Las Vegas, NV, 89165	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-25994	PRV	Raymond Elliott	1956-04-25	UHC-34636-62	8403759083	8816 Forest Ave, Denver, CO	0.78	Name re-cased Phone reformatted ZIP missing Whitespace trimmed+1 more
PRV-26391	PRV	Marcus Bell	1956-07-02	UHC-55171-32	—	4720 Park Pl, Dallas, TX, 75237	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
PRV-29422	PRV	Julie N Knight	1989-05-17	—	7629966026	9298 Lake View Rd, Tucson, AZ, 85745	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-25151	PRV	Gary Hunt	1959-05-19	UHC-01749-02	3153862451	9561 Lincoln Way # 196, Miami, FL, 33112	0.78	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+1 more
PRV-22415	PRV	Sufia Smith	1978-12-13	—	8097645285	7046 Market St, Las Vegas, NV, 89158	0.78	Name re-cased Phone reformatted Gender normalised Whitespace trimmed+1 more
PRV-20201	PRV	Paul Jimenez	1977-10-17	—	—	1194 Pine Dr, Tempe, AZ, 85257	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
PRV-28906	PRV	Daniel J Robertson	1966-08-04	—	3075974977	2584 Sunset Blvd, Chandler, AZ, 85259	0.78	Name re-cased Phone reformatted Gender normalised Whitespace trimmed+1 more
PRV-29207	PRV	Lerry Hunt	2006-04-09	—	5292811209	7696 Desert Sky Blvd, San Antonio, TX, 78273	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-29206	PRV	Lerry Hunt	2006-04-09	—	5292811209	7696 Desert Sky Blvd, San Antonio, TX, 78273	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-20860	PRV	Noah M Morales	1958-04-26	UHC-68816-49	3374582516	8322 Maple Ave, San Antonio, TX, 78212	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-22812	PRV	Donna Coleman	1942-10-15	UHC-56324-15	6245065244	7430 Palm Dr, Sacramento, CA, 95848	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-25338	PRV	Austin Thomas	2004-05-28	UHC-15598-86	2043320144	9416 Ocean Ave, Sacramento, CA, 95859	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-23041	PRV	Ethan Morrison	1978-12-19	UHC-86725-04	4174832668	8293 Harbor Blvd, Fresno, CA, 93715	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-25997	PRV	Nancy George	1979-06-04	UHC-95306-31	4115147965	436 Bayshore Dr, San Antonio, TX, 78234	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-22635	PRV	Jean W Carr	1969-06-27	—	9024075205	901 Central Ave, Los Angeles, CA, 90095	0.78	Name re-cased Phone reformatted Gender normalised Whitespace trimmed+1 more
PRV-21895	PRV	Helen Webb	1971-02-27	—	2317395609	8349 Broadway # 599, Los Angeles, CA, 90035	0.78	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+1 more
PRV-22753	PRV	Olivia Campbell	1986-10-04	—	6424320170	5315 Indian School Rd, Glendale, AZ, 85319	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-20879	PRV	Maria J Perez	2000-02-01	—	5874100049	4692 Grand Ave, Denver, CO, 80296	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
PRV-25451	PRV	Jerry I Patel	1984-07-01	UHC-16622-15	5747010969	3705 Washington St, Miami, FL, 33171	0.78	Name re-cased Phone reformatted Gender normalised Whitespace trimmed+1 more
PRV-21816	PRV	Jessica Mendez	1958-11-24	UHC-94335-21	2742227518	1455 Meadow Ln, Phoenix, AZ, 85016	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more

3,816 rows, page 52 of 77Previous Next