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 “Placeholder values cleared”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagPlaceholder values clearedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-57978	TPA	Sharon Ortiz	—	—	—	8541 Main St, Miami, FL, 33150	0.62	Name re-cased Date of birth missing Street suffix standardised Address re-cased+3 more
PRV-21664	PRV	Maggie Obrien	1985-05-03	UHC-19518-51	2982673659	1406 Elm St, Nashville, TN, 37286	0.62	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+3 more
CLM-411636	CLM	Suan Coleman	1952-10-13	UHC-57625-86	3484770801	355 Mountain View Dr, Tempe, AZ, 85208	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-418192	CLM	Brandon Reid	1968-11-07	UHC-76294-19	5535939403	4052 Indian School Rd, Glendale, AZ, 85388	0.62	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+3 more
TPA-60944	TPA	Liz Nunez	2008-08-01	—	4068718195	5625 Washington St, Sacramento, CA, 95832	0.62	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+3 more
ENR-108601	ENR	Gerald P Lopez	—	UHC-58085-71	—	3691 Jefferson Ave, Jacksonville, FL, 32288	0.62	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+3 more
PRV-27895	PRV	Joe G Bishop	1967-10-04	UHC-26419-88	6258259436	3979 Elm St Apt 38, Gilbert, AZ, 85264	0.62	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+3 more
ENR-133751	ENR	Pamela Garza	1997-11-02	UHC-24284-08	7784506236	3571 Cedar Ln, Columbus, OH	0.62	Phone reformatted Street suffix standardised Address re-cased ZIP missing+3 more
CLM-418110	CLM	Betty X Valdez	2006-06-04	UHC-98999-61	8094397470	6270 Oak St, Minneapolis, MN, 55462	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-429110	CLM	Christopher Stevens	1992-09-21	—	—	6186 Elm St, Plano, TX, 75006	0.62	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+3 more
TPA-53661	TPA	Brandon Johnston	1993-03-05	—	—	5819 Jefferson Ave, Minneapolis, MN, 55479	0.62	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+3 more
PRV-23083	PRV	Bobby Henderson	1995-04-15	UHC-70285-55	5709873670	9539 Mesa Dr, Los Angeles, CA, 90027	0.62	Name re-cased Street suffix standardised Address re-cased City re-cased+3 more
TPA-61606	TPA	Camila Chen	1977-01-12	UHC-66437-32	4166840302	130 Harbor Blvd Apt 23, Glendale, AZ, 85327	0.62	Name re-cased Phone reformatted Member ID reformatted Unit split from street+3 more
CLM-409211	CLM	Jeffrey P Clark	1962-10-22	—	—	353 Elm St, Sacramento, CA, 95821	0.62	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+3 more
CLM-427227	CLM	Michelle Soto	1948-06-18	—	4596715037	4713 Lincoln Way, Scottsdale, AZ	0.62	Name re-cased Phone reformatted City re-cased State name converted to code+3 more
CLM-415692	CLM	Bryan K Scott	1969-06-16	UHC-62566-01	2898924315	7540 Jefferson Ave, Chandler, AZ, 85242	0.62	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+3 more
CLM-406186	CLM	Eugene Sanchez	2000-07-06	—	8858148913	2820 Palm Dr, Fresno, CA, 93729	0.62	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+3 more
ENR-127265	ENR	Sara Carpenter	1950-10-24	UHC-95596-44	4195231041	5046 Mesa Dr, Columbus, OH, 43252	0.62	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-121373	ENR	Gloria V Weber	1955-05-05	UHC-93543-01	7097026501	9287 Oak St, Dallas, TX	0.62	Name re-cased Phone reformatted Member ID reformatted City re-cased+3 more
PRV-28664	PRV	Andy Ford	1967-04-18	—	2557190087	4446 Bayshore Dr, Scottsdale, AZ, 85266	0.62	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+3 more
CLM-431306	CLM	Amber Milsl	1988-04-07	UHC-83923-02	4644549085	6809 River Rd, San Diego, CA, 92182	0.62	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-124870	ENR	Emily R Young	1977-01-26	UHC-47480-60	8583436208	8117 Apache Blvd, Mesa, AZ, 85237	0.62	Name re-cased Two-digit birth year Phone reformatted Member ID reformatted+3 more
CLM-416496	CLM	Aisha Gibson	1942-12-19	—	8773634795	3743 Church St, Atlanta, GA, 30359	0.62	Phone reformatted Street suffix standardised Address re-cased City re-cased+3 more
ENR-130929	ENR	Eugene A Morales	1976-03-11	UHC-18419-70	—	7390 Bayshore Dr, Austin, TX, 78766	0.62	Name re-cased Street suffix standardised Address re-cased City re-cased+3 more
CLM-419897	CLM	Linda Hill	1999-06-21	UHC-06589-71	—	1446 Bayshore Dr, Denver, CO, 80222	0.62	Name re-cased Date of birth reformatted Phone missing area code Street suffix standardised+3 more
ENR-140516	ENR	Gonzalez Katherine	1958-10-26	—	—	3627 Highland Ave, Tampa, FL, 33637	0.62	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+3 more
CLM-413608	CLM	Lucia N Castillo	2001-02-21	—	—	769 Hillcrest Rd, Minneapolis, MN, 55443	0.62	Name re-cased Street suffix standardised Address re-cased City re-cased+3 more
PRV-21040	PRV	Janice Ramirez	1973-02-17	UHC-60736-65	2633376732	4673 Sunset Blvd, Eden Prairie, MN, 55358	0.62	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+3 more
PRV-21039	PRV	Janice Ramirez	1973-02-17	UHC-60736-65	2633376732	4673 Sunset Blvd, Eden Prairie, MN, 55358	0.62	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+3 more
CLM-402745	CLM	Yuki Collins	1983-01-13	UHC-91200-07	3597975966	1167 Camelback Rd, Jacksonville, FL, 32248	0.62	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-403157	CLM	Edward X King	1959-11-13	UHC-04608-19	6485705403	183 Grand Ave, Sacramento, CA, 95860	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
TPA-62831	TPA	Emily Nichols	1955-03-08	UHC-42390-85	9622022755	9636 Union St, Scottsdale, AZ, 85257	0.62	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
TPA-58094	TPA	Theresa Cooper	1955-01-21	—	4055367414	5258 Lake View Rd Apt 21, Tempe, AZ, 85221	0.62	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-426507	CLM	Jordan Walker	1988-02-19	—	2524509237	3465 Union St, Columbus, OH	0.62	Phone reformatted Street suffix standardised Address re-cased City re-cased+3 more
TPA-61852	TPA	Jacob Harris	1938-07-16	—	5079545295	3560 Indian School Rd, Tempe, AZ, 85226	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
PRV-26131	PRV	Carolyn Kennedy	1948-08-06	UHC-02309-97	5397528324	5655 Main St, Glendale, AZ, 85336	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-403326	CLM	Helen C Snyder	1982-06-03	—	6307396842	455 Grand Ave, Jacksonville, FL, 32276	0.62	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed+3 more
CLM-400752	CLM	Julie Larson	1947-06-08	UHC-11789-96	—	8499 Meadow Ln, Columbus, OH, 43219	0.62	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+3 more
CLM-405197	CLM	Victoria McCoy	1998-05-22	UHC-62971-33	7018455061	8234 Oak St, Seattle, WA, 98100	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
TPA-55656	TPA	Carol Russell	2000-08-10	—	6803131019	1060 Apache Blvd, Nashville, TN, 37221	0.62	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-408434	CLM	Ryan Diaz	1991-04-01	—	—	1621 Willow Ct, Columbus, OH, 43295	0.62	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+3 more
CLM-416017	CLM	Fatima Butler	1972-06-01	UHC-49073-83	—	5607 Church St, Charlotte, NC, 28203	0.62	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+3 more
CLM-418586	CLM	Raymond Powell	1994-09-10	UHC-91897-10	—	9283 Washington St, San Antonio, TX, 78234	0.62	Name re-cased Two-digit birth year Member ID reformatted Street suffix standardised+3 more
ENR-120947	ENR	Margaret R Lane	1979-04-20	UHC-85163-67	—	2784 Spring St, Plano, TX, 75015	0.62	Name re-cased Date of birth reformatted Phone missing area code Street suffix standardised+3 more
ENR-115728	ENR	Andrea Cunninhgam	2002-03-21	UHC-76946-30	3855062175	8232 Palm Dr, Glendale, AZ, 85388	0.62	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-412945	CLM	Kyle Phillips	1999-01-04	—	2357494646	2516 Harbor Blvd, Austin, TX, 78735	0.62	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+3 more
ENR-111555	ENR	Nathan Rose	1964-05-05	UHC-57831-42	9882545271	439 Baseline Rd, Denver, CO, 80269	0.62	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+3 more
TPA-58864	TPA	Nicholas Hughes	1972-12-17	UHC-36357-55	3169836417	4572 Maple Ave, Eden Prairie, MN, 55315	0.62	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-424682	CLM	William Rivera	1971-03-13	UHC-47674-88	—	3566 Willow Ct, San Diego, CA	0.62	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
CLM-403811	CLM	Willie Lawrence	1981-01-26	—	—	2641 Forest Ave, Gilbert, AZ, 85290	0.62	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+3 more

71,257 rows, page 194 of 1,426Previous Next