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 missing”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP missingClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-103255	ENR	Alexis Duncan	1974-05-28	UHC-03463-23	8952710364	2572 Union St, San Diego, CA	0.80	Phone reformatted City re-cased ZIP missing Whitespace trimmed
CLM-416082	CLM	Priya Howarrd	1977-10-20	UHC-63338-41	—	269 Desert Sky Blvd, Chandler, AZ	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
ENR-100993	ENR	Carolyn D Anderson	1946-03-07	UHC-16813-73	5865068640	2764 Market St, Plano, TX	0.80	Name re-cased City re-cased State code upper-cased ZIP missing
TPA-56898	TPA	Aisha Gordon	1975-06-12	UHC-01782-66	—	1950 Canyon Rd, Chandler, AZ	0.80	Name re-cased Date of birth reformatted ZIP missing Placeholder values cleared
TPA-60776	TPA	James Burke	2001-04-16	—	3938204845	1454 Elm St, Phoenix, AZ	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-128409	ENR	Luis Q Dominguez	1998-11-25	UHC-35367-03	9026851946	5547 Baseline Rd, Plano, TX	0.80	Name re-cased Date of birth reformatted Phone reformatted ZIP missing
ENR-111411	ENR	Ana Ray	2008-03-10	UHC-26901-32	7314391317	467 Harbor Blvd, Atlanta, GA	0.80	Name re-cased Date of birth reformatted ZIP missing Whitespace trimmed
CLM-416987	CLM	Diane Maldonado	1965-07-17	UHC-17511-15	—	8807 Broadway, Minneapolis, MN	0.80	Address re-cased ZIP missing Whitespace trimmed Placeholder values cleared
ENR-135935	ENR	Scott Z Mitchell	1975-02-20	UHC-11269-08	7735492511	9701 Main St, Scottsdale, AZ	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-126887	ENR	Maria R Marshall	1961-02-19	UHC-73511-04	2403423474	5013 Forest Ave, Las Vegas, NV	0.80	Phone reformatted Member ID reformatted ZIP missing Placeholder values cleared
TPA-59985	TPA	Edward Jenkins	1970-06-11	—	6214437611	7960 River Rd, Minneapolis, MN	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared
ENR-118698	ENR	Gabriel B Roberts	1981-03-20	UHC-70715-12	8414750467	5611 Maple Ave, Nashville, TN	0.80	Name re-cased Phone reformatted ZIP missing Whitespace trimmed
CLM-416502	CLM	Jesse Barnes	1969-03-23	UHC-14334-26	—	2923 Church St, Miami, FL	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-113111	ENR	Randy Aguilar	1947-01-25	UHC-67444-11	4056816139	6009 Elm St, Tucson, AZ	0.80	Date of birth reformatted Phone reformatted ZIP missing Whitespace trimmed
ENR-100177	ENR	Betty Weaver	1963-08-01	UHC-27224-84	—	662 Palm Dr, Glendale, AZ	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
CLM-404839	CLM	Barbara Waaver	2006-11-02	UHC-82682-70	—	9677 Lincoln Way, Fresno, CA	0.80	Name re-cased City re-cased ZIP missing Placeholder values cleared
CLM-430702	CLM	Angela Nelson	1947-08-01	UHC-42015-33	3872735798	2170 Apache Blvd, Gilbert, AZ	0.80	Date of birth reformatted Phone reformatted ZIP missing Placeholder values cleared
ENR-119370	ENR	Justin D Harris	1976-01-19	UHC-17656-83	6038781759	7587 Maple Ave, Tampa, FL	0.80	Date of birth reformatted Phone reformatted ZIP missing Whitespace trimmed
CLM-411190	CLM	Brandon Bennnett	1950-02-23	—	6732208340	3332 Bayshore Dr, Sacramento, CA	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
TPA-57562	TPA	Dorothy Sanders	1947-07-13	—	8784319401	5954 Bayshore Dr, Orlando, FL	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared
PRV-21800	PRV	Terry A Berry	1992-11-05	UHC-47331-48	6527557565	7774 Maple Ave, Houston, TX	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
ENR-110089	ENR	Virginia A Bryant	1985-11-05	UHC-43467-44	4594609924	9360 Apache Blvd, Atlanta, GA	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared
TPA-53770	TPA	Janet V Carroll	1980-01-11	—	—	4277 Elm St, Tucson, AZ	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
PRV-27776	PRV	Anna Boyd	1965-11-09	UHC-73892-28	5442414118	6021 Broadway, Dallas, TX	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared
TPA-59287	TPA	Eric Castillo	1941-01-03	—	—	3675 Broadway, Austin, TX	0.80	Date of birth reformatted Address re-cased ZIP missing Placeholder values cleared
PRV-28115	PRV	Frank Q Hansen	1998-04-09	UHC-07640-62	9218993113	1390 Mesa Dr, Los Angeles, CA	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
TPA-61679	TPA	Randy Clark	1989-05-14	—	—	4099 Camelback Rd, Miami, FL	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
ENR-121573	ENR	Diego A Willis	1990-01-22	UHC-27057-09	—	9873 Hillcrest Rd, Jacksonville, FL	0.80	Member ID reformatted ZIP missing Whitespace trimmed Placeholder values cleared
PRV-20774	PRV	Aaron Harvey	2001-07-05	UHC-57296-51	8199599752	5852 Apache Blvd, Glendale, AZ	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared
CLM-408799	CLM	Isabella Watkins	1961-04-24	UHC-33271-44	9135964825	5608 Meadow Ln, Los Angeles, CA	0.80	Name re-cased Date of birth reformatted ZIP missing Placeholder values cleared
ENR-137181	ENR	Danielle C Grant	1943-09-06	UHC-38072-86	7436538896	9196 Harbor Blvd, Charlotte, NC	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-128741	ENR	Andrew Lucas	2003-07-01	UHC-59856-86	3644582804	2216 Palm Dr, Fresno, CA	0.80	Name re-cased Phone reformatted ZIP missing Whitespace trimmed
ENR-141237	ENR	Christine Z Dixon	1964-08-18	UHC-34283-65	8512489796	361 Mountain View Dr, San Antonio, TX	0.80	Date of birth reformatted Phone reformatted ZIP missing Whitespace trimmed
ENR-108386	ENR	Ann Rid	1989-06-25	UHC-69943-35	3755488751	8701 Hillcrest Rd, Nashville, TN	0.80	Date of birth reformatted Phone reformatted ZIP missing Whitespace trimmed
ENR-121435	ENR	Carlos C Kennedy	1976-02-05	UHC-61491-38	9014896388	6234 Highland Ave, Phoenix, AZ	0.80	Name re-cased City re-cased ZIP missing Whitespace trimmed
ENR-142052	ENR	Brittany D Shaw	1961-08-04	UHC-43130-16	5076170562	6327 Ridge Rd, Denver, CO	0.80	Phone reformatted Member ID reformatted ZIP missing Email lower-cased
CLM-421968	CLM	Jonathan Gibson	1978-02-08	UHC-88509-08	6126597893	3380 Lake View Rd, Seattle, WA	0.80	Name re-cased City re-cased ZIP missing Placeholder values cleared
PRV-26958	PRV	Larry Cox	1983-06-01	UHC-25922-95	9553706658	4973 Grand Ave, Tampa, FL	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared
PRV-28816	PRV	Joshua Stewart	1988-02-15	—	6618979534	1223 Sunset Blvd, Seattle, WA	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-134667	ENR	Pauul X Willis	1949-10-17	UHC-36011-62	8018506508	5603 Lincoln Way, Nashville, TN	0.80	Name re-cased Phone reformatted ZIP missing Whitespace trimmed
TPA-53184	TPA	Katherine Banks	1965-10-15	—	—	914 Willow Ct, Tucson, AZ	0.80	State code upper-cased ZIP missing Whitespace trimmed Placeholder values cleared
ENR-111385	ENR	Jonathan Henry	1991-01-24	UHC-20836-85	2863956427	2476 Harbor Blvd, Mesa, AZ	0.80	Name re-cased ZIP missing Email lower-cased Placeholder values cleared
PRV-26421	PRV	Barb T Martniez	1961-08-20	—	3094428887	3302 Sunset Blvd, Fresno, CA	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared
ENR-105161	ENR	Joyce O Duncan	1982-09-14	UHC-07860-94	9555856598	3519 Ridge Rd, Dallas, TX	0.80	Date of birth reformatted City re-cased ZIP missing Placeholder values cleared
ENR-105162	ENR	Joyce O Duncan	1982-09-14	UHC-07860-94	9555856598	3519 Ridge Rd, Dallas, TX	0.80	Date of birth reformatted City re-cased ZIP missing Placeholder values cleared
CLM-412997	CLM	Jesse Diaz	1959-10-26	UHC-17665-61	5079615018	5728 Lincoln Way, Dallas, TX	0.80	Name re-cased Date of birth reformatted ZIP missing Placeholder values cleared
ENR-124694	ENR	Sean Q Reynolds	1989-10-25	UHC-33152-78	5782881671	7232 Broadway, Charlotte, NC	0.80	Name re-cased Phone reformatted Address re-cased ZIP missing
TPA-60794	TPA	Abigail Luna	1940-11-08	UHC-74464-69	—	4651 Hillcrest Rd, Jacksonville, FL	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
ENR-132158	ENR	Rallph Harper	1985-02-13	UHC-98460-09	9482440110	4273 Maple Ave, Glendale, AZ	0.80	Date of birth reformatted ZIP missing Email lower-cased Whitespace trimmed
ENR-102117	ENR	Jeff X Rojas	1965-12-20	UHC-39663-17	6877818213	3040 Apache Blvd, Seattle, WA	0.80	Name re-cased Date of birth reformatted Phone reformatted ZIP missing

7,146 rows, page 130 of 143Previous Next