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

All sources, flag “Name split from “Last, First””, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagName split from “Last, First”Clear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-123367	ENR	Diane O Duncan	1981-04-20	UHC-60853-78	3076160908	2684 Lake View Rd, Jacksonville, FL, 32225	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-24537	PRV	Joshua Bishop	1944-01-16	UHC-15066-21	7934058502	9490 Desert Sky Blvd, Chandler, AZ, 85202	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-121073	ENR	Terry T Meyer	1989-09-11	UHC-08100-59	6599944418	8620 Ridge Rd, Eden Prairie, MN, 55361	0.66	Name split from “Last, First”Phone reformatted State name converted to code Whitespace trimmed+1 more
TPA-62098	TPA	Dnona Reynolds	1941-10-22	UHC-84859-74	9634313099	6169 Elm St, Chandler, AZ, 85251	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-136127	ENR	Anthony Oliver	1962-09-24	UHC-51791-98	5877572903	697 Meadow Ln, Phoenix, AZ, 85026	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted Member ID reformatted+1 more
ENR-118761	ENR	Ftaima I Armstrong	1995-10-30	UHC-67007-59	—	790 Bayshore Dr, Austin, TX, 78706	0.66	Name split from “Last, First”Phone missing area code State code upper-cased Email lower-cased+1 more
CLM-409546	CLM	Douglas Tucker	1992-08-22	UHC-89410-87	—	5520 Desert Sky Blvd, Glendale, AZ, 85372	0.66	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+1 more
PRV-25546	PRV	George Shaw	1984-10-02	UHC-36004-77	7996539568	6572 Bayshore Dr, Tucson, AZ, 85780	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-138718	ENR	Susan S Boyd	1977-11-01	UHC-70334-03	—	1420 Elm St, Orlando, FL, 32820	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-115333	ENR	Catherine W Haarvey	1960-07-11	—	3574388239	5638 Indian School Rd, Orlando, FL	0.66	Name split from “Last, First”Date of birth reformatted ZIP missing Whitespace trimmed+1 more
ENR-105869	ENR	Benjamin C Bowman	1992-05-21	UHC-41086-49	4765240260	8468 Willow Ct, Columbus, OH, 43269	0.66	Name split from “Last, First”Two-digit birth year Phone reformatted Whitespace trimmed+1 more
TPA-54656	TPA	Fatima McDonald	1941-06-09	—	—	4487 Washington St, Los Angeles, CA, 90056	0.66	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+1 more
TPA-54125	TPA	Becky Campbell	1953-05-09	—	7623964285	—	0.66	Name split from “Last, First”Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-422781	CLM	Judy Wang	1985-04-05	UHC-93720-28	3718682486	6688 Washington St, Houston, TX	0.66	Name split from “Last, First”Phone reformatted ZIP missing Whitespace trimmed+1 more
CLM-416486	CLM	Olivia W Maldonado	1959-04-02	UHC-73748-47	—	3376 Washington St, Gilbert, AZ, 85285	0.66	Name split from “Last, First”Date of birth reformatted Gender normalised Whitespace trimmed+1 more
ENR-121680	ENR	Rebecca K Alvarado	1950-03-18	UHC-43885-93	—	6838 River Rd, Las Vegas, NV, 89112	0.66	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+1 more
ENR-123141	ENR	Barbara F Hansen	1998-05-22	UHC-46053-84	8727913356	1050 Grand Ave, Tampa, FL, 33676	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+1 more
ENR-123142	ENR	Barbara F Hansen	1998-05-22	UHC-46053-84	8727913356	1050 Grand Ave, Tampa, FL, 33676	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+1 more
TPA-59784	TPA	Janet Morgan	1968-04-24	—	—	2596 Sunset Blvd, Chandler, AZ	0.66	Name split from “Last, First”Date of birth reformatted ZIP missing Whitespace trimmed+1 more
TPA-54003	TPA	Kyle Day	—	—	—	1724 Jefferson Ave, San Diego, CA, 92188	0.66	Name split from “Last, First”Date of birth unreadable City re-cased Whitespace trimmed+1 more
PRV-26527	PRV	Franecs G Hicks	1963-04-27	—	8352650587	2571 Desert Sky Blvd, Chandler, AZ, 85225	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
TPA-55620	TPA	Jack P Wells	1996-07-24	—	—	3646 Sunset Blvd, Tempe, AZ, 85249	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
TPA-59685	TPA	Michael Patterson	—	—	7988501642	1907 Lincoln Way, Los Angeles, CA, 90083	0.66	Name split from “Last, First”Date of birth unreadable City re-cased Whitespace trimmed+1 more
ENR-100025	ENR	Margaret Bell	2006-07-25	UHC-39574-66	9864893045	4859 Elm St, Tampa, FL, 33618	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+1 more
CLM-418834	CLM	Jacob King	1999-06-22	UHC-05410-78	—	6356 Washington St, Tempe, AZ, 85272	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Email lower-cased+1 more
CLM-407192	CLM	Andrea T Gilbert	2000-09-22	UHC-60971-03	7399354219	2744 Valley View Dr, Los Angeles, CA, 90037	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-423043	CLM	Emily Hicks	2002-10-01	UHC-24836-71	8646049923	1755 Willow Ct, Plano, TX, 75051	0.66	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-432101	CLM	Jason Rogers	1955-10-21	UHC-81029-91	7383966102	3757 Pine Dr, Minneapolis, MN, 55414	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-142364	ENR	David P Garrett	2002-11-27	UHC-37765-78	2938423482	3962 Market St, Seattle, WA, 98158	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+1 more
ENR-108370	ENR	Ajun Contreras	1953-10-11	UHC-84795-06	4613548235	7886 Willow Ct, Fresno, CA, 93758	0.66	Name split from “Last, First”Two-digit birth year Email lower-cased Plan code upper-cased+1 more
TPA-62998	TPA	Theresa Carter	1968-12-13	UHC-04988-64	—	4683 Palm Dr, Chandler, AZ, 85262	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-109558	ENR	Megan Chavez	1992-11-03	UHC-87398-86	8858132860	6723 Grand Ave, Dallas, TX, 75245	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-24612	PRV	Timothy Berry	1963-09-08	—	2184037704	3376 Spring St, Dallas, TX, 75284	0.66	Name split from “Last, First”Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-408056	CLM	Ruth Harper	1949-07-03	UHC-27779-17	9407456612	—	0.66	Name split from “Last, First”Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-407211	CLM	Christopher N Webb	1988-01-17	UHC-62698-47	—	3164 Union St, Houston, TX, 77068	0.66	Name split from “Last, First”Date of birth reformatted Gender normalised Whitespace trimmed+1 more
ENR-100844	ENR	Lauren N Spencer	1956-03-13	UHC-15892-51	2393257247	9516 Valley View Dr, Mesa, AZ, 85280	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted Member ID reformatted+1 more
ENR-124709	ENR	Luis B Nichols	1947-03-14	UHC-85196-78	6354756215	5706 Lincoln Way, Atlanta, GA	0.66	Name split from “Last, First”Phone reformatted ZIP missing Whitespace trimmed+1 more
ENR-121275	ENR	Ed Collins	1977-05-16	UHC-24133-24	3272722093	2911 Apache Blvd, Glendale, AZ	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted City re-cased+1 more
PRV-26857	PRV	Camila Kelly	1962-06-14	—	8273197244	9580 Canyon Rd, Mesa, AZ, 85248	0.66	Name split from “Last, First”Street suffix standardised Address re-cased City re-cased+1 more
CLM-401760	CLM	Katherine T Russell	1954-11-01	UHC-43937-93	—	1701 Washington St, Las Vegas, NV, 89176	0.66	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+1 more
PRV-20619	PRV	Anthony Gray	1947-05-21	UHC-32028-55	4984169169	3721 Park Pl, Miami, FL, 33102	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-426613	CLM	Stephanie Pierce	1981-10-12	UHC-32289-79	—	7115 Camelback Rd, San Antonio, TX, 78293	0.66	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+1 more
ENR-104189	ENR	Gabriel Welch	1959-07-06	UHC-11795-17	4316963094	9743 River Rd, Charlotte, NC, 28272	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised+1 more
ENR-118834	ENR	Andrew K Dean	1943-03-23	UHC-47206-76	3585817310	5529 Church St, Houston, TX, 77018	0.66	Name split from “Last, First”Two-digit birth year Phone reformatted Email lower-cased+1 more
ENR-109185	ENR	Janet McDonald	—	UHC-29446-60	3975337165	5152 Sunset Blvd, Tempe, AZ, 85297	0.66	Name split from “Last, First”Date of birth reformatted Date of birth unreadable Phone reformatted+1 more
PRV-22663	PRV	Donna Schmidt	1983-02-23	UHC-88832-04	—	6092 Meadow Ln, San Antonio, TX, 78250	0.66	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+1 more
ENR-134843	ENR	Peter X Olson	1976-02-17	UHC-64174-06	2984146526	1042 Sunset Blvd, Chandler, AZ, 85207	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-107884	ENR	Linda L Fernandez	1982-04-06	UHC-01221-98	—	4335 Desert Sky Blvd Apt 7, Mesa, AZ, 85248	0.66	Name split from “Last, First”Unit split from street City re-cased Whitespace trimmed+1 more
CLM-424396	CLM	Randy Porter	1939-08-26	—	—	5279 Washington St, Fresno, CA, 93705	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-135485	ENR	Emily R Parker	2008-12-12	UHC-78781-60	5744718767	4293 Lake View Rd, Jacksonville, FL, 32200	0.66	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+1 more

9,980 rows, page 108 of 200Previous Next