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 “ZIP+4 trimmed”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP+4 trimmedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-27338	PRV	Brenda Garrett	1979-12-19	UHC-41748-23	—	5080 Mountain View Dr, Chandler, AZ, 85279	0.82	City re-cased ZIP+4 trimmed Placeholder values cleared
PRV-23233	PRV	Keith B Jones	1956-01-16	—	6736730358	4325 Church St, Gilbert, AZ, 85296	0.82	ZIP+4 trimmed Email lower-cased Placeholder values cleared
ENR-111918	ENR	Amanda B Hason	1950-08-17	UHC-77297-50	9585075580	1274 Apache Blvd, Phoenix, AZ, 85068	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
CLM-409493	CLM	Nathan Cunningham	1938-05-08	—	—	8203 Lake View Rd, Atlanta, GA, 30399	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-402971	CLM	Yuki White	1954-11-15	UHC-76332-15	—	4932 Maple Ave, Denver, CO, 80255	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
PRV-24908	PRV	Aisha Rogers	1957-09-18	—	9487764138	3115 Mountain View Dr, Sacramento, CA, 95801	0.82	City re-cased ZIP+4 trimmed Placeholder values cleared
CLM-424814	CLM	Zachary Wright	2006-12-17	UHC-82374-48	—	1489 Broadway, Gilbert, AZ, 85278	0.82	City re-cased ZIP+4 trimmed Placeholder values cleared
ENR-114970	ENR	Jdy Miller	1994-05-09	UHC-09658-23	5378318756	9313 River Rd, Tampa, FL, 33660	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
CLM-407518	CLM	Melissa P Walsh	1987-08-13	UHC-81070-15	6585928689	9218 Bayshore Dr, Phoenix, AZ, 85051	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
TPA-64170	TPA	Brenda Black	1961-12-20	—	9799341476	5314 Church St, Tempe, AZ, 85266	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-432182	CLM	Madison Allen	1995-10-23	UHC-41395-61	—	8889 Ocean Ave, Sacramento, CA, 95893	0.82	Member ID reformatted ZIP+4 trimmed Placeholder values cleared
PRV-25661	PRV	Carl Q White	1943-02-06	—	—	8984 Ridge Rd, Orlando, FL, 32863	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-119404	ENR	Lucia P Padilla	1976-10-15	UHC-86094-50	2872020051	1425 Broadway, Gilbert, AZ, 85229	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-104285	ENR	Diego Willis	1976-12-04	UHC-87330-63	3998853867	5065 Ocean Ave, Chandler, AZ, 85274	0.82	Name re-cased City re-cased ZIP+4 trimmed
TPA-52645	TPA	Zachary Harris	1972-03-02	—	—	6872 Sage Ct, Miami, FL, 33103	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-107553	ENR	Sara R Santos	1974-01-28	UHC-39856-07	3576252802	3763 Broadway, Los Angeles, CA, 90091	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-130189	ENR	Hannah R Santos	1999-07-04	UHC-76256-41	6293963219	6379 Camelback Rd, Eden Prairie, MN, 55382	0.82	ZIP+4 trimmed Email lower-cased Placeholder values cleared
PRV-28210	PRV	Raymond Q Reed	1997-07-04	—	—	8798 Lincoln Way, Orlando, FL, 32856	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
TPA-62813	TPA	Albert Wallace	1972-07-12	UHC-61755-91	—	553 Park Pl, Chandler, AZ, 85209	0.82	Name re-cased Date of birth reformatted ZIP+4 trimmed
TPA-57352	TPA	Camila Romero	1941-04-20	—	—	6264 Forest Ave, Tampa, FL, 33674	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-420051	CLM	Joyce Garza	1970-06-04	UHC-40324-56	—	750 Forest Ave, Nashville, TN, 37243	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-136850	ENR	Barbara W Knight	1964-05-08	UHC-15726-60	4469167701	2181 Harbor Blvd, Fresno, CA, 93760	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
ENR-132238	ENR	Ann Berry	2003-05-28	UHC-79552-37	5994548114	7288 Broadway, Eden Prairie, MN, 55364	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-25163	PRV	Caimla K Robertson	1939-04-07	UHC-95495-01	9267903067	7795 Elm St, Plano, TX, 75010	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-101134	ENR	Bruce Evans	1996-03-05	UHC-53530-21	3156012190	5968 River Rd, Austin, TX, 78749	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
CLM-406737	CLM	Barb Warren	1979-06-15	UHC-54834-89	—	9804 Ocean Ave, Austin, TX, 78763	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-128916	ENR	Soto W Nicole	1997-03-04	UHC-13755-91	8676571276	7646 Lincoln Way, Minneapolis, MN, 55478	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-125713	ENR	Marcus K Banks	1986-08-14	UHC-82234-18	6522931767	6292 Mesa Dr, Plano, TX, 75055	0.82	Phone reformatted Member ID reformatted ZIP+4 trimmed
TPA-55841	TPA	Jonathan Wang	1939-08-09	—	—	4103 Mountain View Dr, Orlando, FL, 32857	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-410490	CLM	Nathan Haall	1939-08-26	UHC-65209-99	—	7748 Bayshore Dr, Austin, TX, 78735	0.82	City re-cased ZIP+4 trimmed Placeholder values cleared
CLM-430304	CLM	Mariana T Gordon	2002-12-27	UHC-48651-30	—	8499 Broadway, Nashville, TN, 37243	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-106097	ENR	Luis Torres	2003-12-09	UHC-28329-05	6293903873	4391 Palm Dr, Scottsdale, AZ, 85203	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
CLM-420940	CLM	Alexander F Ellis	1979-08-14	UHC-09595-15	—	219 Lincoln Way, Denver, CO, 80234	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-128074	ENR	Gloria C Watkins	1998-11-22	UHC-68547-42	9334284680	572 Bayshore Dr, Plano, TX, 75018	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
ENR-103986	ENR	Lawrence Lawson	1947-11-27	UHC-89452-36	5579213346	3465 Park Pl, Phoenix, AZ, 85011	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-139646	ENR	Virginia Hansen	1944-07-06	UHC-14278-08	8386718672	3692 Sunset Blvd, Jacksonville, FL, 32220	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
TPA-63602	TPA	Douglas Sanders	1958-07-23	—	4699400251	7638 Bayshore Dr, Atlanta, GA, 30371	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-141255	ENR	Victoria Clark	1992-04-16	UHC-78240-28	—	5078 Forest Ave, Mesa, AZ, 85297	0.82	Name re-cased Member ID reformatted ZIP+4 trimmed
CLM-416781	CLM	Karen Meyer	1970-12-09	UHC-87829-83	6386826572	211 Ridge Rd, Atlanta, GA, 30338	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
CLM-402438	CLM	Billy Armstrong	1954-11-20	—	—	2707 Lincoln Way, Charlotte, NC, 28217	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
CLM-426074	CLM	Emily Ward	1981-03-05	—	—	789 Valley View Dr, Austin, TX, 78718	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-106278	ENR	Eric Ross	1989-03-20	UHC-65059-83	3503746694	2705 Broadway, Gilbert, AZ, 85237	0.82	Phone reformatted ZIP+4 trimmed Plan code upper-cased
ENR-129605	ENR	Charles Z Boyd	1950-09-14	UHC-87605-29	8107142846	2449 Ocean Ave, Gilbert, AZ, 85239	0.82	City re-cased ZIP+4 trimmed Email lower-cased
ENR-130917	ENR	Anthony P Median	1995-02-12	UHC-86103-32	8203975478	7982 Park Pl, Orlando, FL, 32864	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-130918	ENR	Anthony P Median	1995-02-12	UHC-86103-32	8203975478	7982 Park Pl, Orlando, FL, 32864	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
CLM-415003	CLM	James Grey	1952-01-18	UHC-36465-69	—	5047 Union St, Charlotte, NC, 28266	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
PRV-26652	PRV	Bobby L Payne	1987-08-17	UHC-54861-76	2315860318	7432 Palm Dr, Columbus, OH, 43248	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-402311	CLM	Christine Andrews	1951-11-11	UHC-52132-50	—	5495 Willow Ct, Mesa, AZ, 85224	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-122080	ENR	Brandon W Hawkins	1968-06-07	UHC-66347-19	6984350617	140 Sunset Blvd, Plano, TX, 75062	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-129437	ENR	Diana E Cooper	1992-02-21	UHC-93659-24	8206167600	855 Pine Dr, Phoenix, AZ, 85047	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared

8,263 rows, page 156 of 166Previous Next