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 “Member ID reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagMember ID reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-122757	ENR	Andrew Jimenez	1966-02-28	UHC-47325-45	—	3408 Spring St, Dallas, TX, 75209	0.66	Phone missing area code Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-129887	ENR	Brenda G Willis	1953-12-11	UHC-15928-05	8959258544	9873 Union St Apt 17, Plano, TX, 75022	0.66	Phone reformatted Member ID reformatted SSN last four extracted Unit split from street+1 more
ENR-123540	ENR	Burns I Alice	—	UHC-66412-77	—	1416 Pine Dr, Scottsdale, AZ, 85252	0.66	Name re-cased Date of birth unreadable Member ID reformatted State name converted to code+1 more
ENR-124258	ENR	Kathryn O Hunter	1987-09-21	UHC-93530-79	—	6677 Harbor Blvd # 287, Scottsdale, AZ, 85234	0.66	Member ID reformatted Unit split from street City re-cased Gender normalised+1 more
CLM-413586	CLM	Christian Gonzalez	1979-07-21	UHC-05076-98	—	8471 Sage Ct, Tucson, AZ, 85735	0.66	Member ID reformatted Street suffix standardised Address re-cased Gender normalised+1 more
ENR-133071	ENR	Sara M Gonzzales	1967-04-26	UHC-46404-09	2488782688	17 Market St, Fresno, CA, 93781	0.66	Name split from “Last, First”Phone reformatted Member ID reformatted Street suffix standardised+1 more
ENR-109815	ENR	Timothy Nichols	1989-07-13	UHC-96375-54	7635111728	8409 Bayshore Dr, San Antonio, TX, 78268	0.66	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-114094	ENR	Christian Gutierrez	2005-07-02	UHC-21146-73	2999744287	2694 Cedar Ln, Seattle, WA, 98122	0.66	Name split from “Last, First”Phone reformatted Member ID reformatted Street suffix standardised+1 more
ENR-114093	ENR	Christian Gutierrez	2005-07-02	UHC-21146-73	2999744287	2694 Cedar Ln, Seattle, WA, 98122	0.66	Name split from “Last, First”Phone reformatted Member ID reformatted Street suffix standardised+1 more
ENR-125514	ENR	Rebecca O Tucker	1993-04-25	UHC-83247-80	3319960397	5279 Elm St, Los Angeles, CA, 90000	0.66	Member ID reformatted Street suffix standardised Address re-cased State name converted to code+1 more
ENR-141776	ENR	Carlos O Payne	1954-12-22	UHC-37293-70	2235059051	6927 Camelback Rd, Tucson, AZ, 85772	0.66	Phone reformatted Member ID reformatted ZIP+4 trimmed Gender normalised+1 more
ENR-126097	ENR	Doris Elliott	1948-06-26	UHC-77204-58	7652149371	7824 Lake View Rd, Chandler, AZ, 85222	0.66	Two-digit birth year Member ID reformatted State name converted to code Email lower-cased+1 more
ENR-113496	ENR	Danielle Jenkins	1949-07-28	UHC-41018-56	5528471477	3093 Lake View Rd, Plano, TX, 75078	0.66	Phone reformatted Member ID reformatted State name converted to code Gender normalised+1 more
ENR-105514	ENR	Janet B Ross	2007-08-11	UHC-36044-21	5112243354	4119 Bayshore Dr, Charlotte, NC, 28251	0.66	Member ID reformatted Street suffix standardised Address re-cased Gender normalised+1 more
ENR-107272	ENR	Cheryl N Munoz	1946-05-05	UHC-39247-46	8498714888	9140 Lake View Rd, Tempe, AZ, 85297	0.66	Name split from “Last, First”Date of birth reformatted Member ID reformatted SSN last four extracted+1 more
ENR-108319	ENR	Sophia I Wells	1943-05-10	UHC-08021-89	9594122567	7097 Park Pl, San Diego, CA, 92147	0.66	Name split from “Last, First”Phone reformatted Member ID reformatted Street suffix standardised+1 more
ENR-135414	ENR	Nathan V Gutierrez	1953-07-17	UHC-89336-04	2223653337	8953 Sunset Blvd, Seattle, WA, 98198	0.66	Name split from “Last, First”Phone reformatted Member ID reformatted Street suffix standardised+1 more
ENR-142585	ENR	Grace McDonald	1987-08-11	UHC-33009-48	2779075625	5506 Maple Ave, Tucson, AZ, 85742	0.66	Name re-cased Two-digit birth year Member ID reformatted Street suffix standardised+1 more
ENR-120247	ENR	Melissa E Deelgado	1976-06-01	UHC-32529-49	2166353244	2076 Camelback Rd, Tampa, FL, 33621	0.66	Middle initial moved out of first name Phone reformatted Member ID reformatted ZIP+4 trimmed+1 more
CLM-422662	CLM	Carlos Nelson	—	UHC-50499-80	—	—	0.68	Date of birth unreadable Phone missing area code Member ID reformatted Placeholder values cleared
ENR-112934	ENR	Randy Lucas	1949-01-12	UHC-47089-57	3757401136	9552 Ocean Ave, Miami, FL, 33163	0.68	Name split from “Last, First”Phone reformatted Member ID reformatted SSN last four extracted
CLM-412031	CLM	Keith Lopez	1954-12-07	UHC-85819-38	4926077912	—	0.68	Name split from “Last, First”Member ID reformatted Gender normalised Placeholder values cleared
ENR-121104	ENR	Mateo A Chen	1988-05-15	UHC-76735-60	3164790384	738 Broadway, Tampa, FL, 33686	0.68	Phone reformatted Member ID reformatted SSN last four extracted State name converted to code
CLM-427784	CLM	Shirley Vasquez	1997-08-15	UHC-77814-68	7012862573	—	0.68	Name split from “Last, First”Member ID reformatted Gender normalised Placeholder values cleared
ENR-129219	ENR	Noah Armstrong	1955-08-18	UHC-54510-49	2826507388	1551 Desert Sky Blvd, Chandler, AZ, 85211	0.68	Two-digit birth year Member ID reformatted Street suffix standardised Address re-cased
PRV-27727	PRV	Hannah Munoz	1942-11-28	UHC-67975-18	—	9778 Ridge Rd, Plano, TX	0.68	Phone missing area code Member ID reformatted ZIP missing Placeholder values cleared
ENR-125145	ENR	Wei D Dunn	1939-03-08	UHC-66942-45	—	1020 Oak St, Glendale, AZ	0.68	Phone missing area code Member ID reformatted ZIP missing Placeholder values cleared
ENR-104687	ENR	Gregory E Austin	1953-06-11	UHC-05709-73	3376217953	1550 Market St # 538, Orlando, FL, 32863	0.68	Two-digit birth year Member ID reformatted Unit split from street Whitespace trimmed
ENR-142586	ENR	Jennifer Oliver	1974-10-28	UHC-26072-74	4158569070	7835 Oak St, Denver, CO, 80273	0.68	Name split from “Last, First”Member ID reformatted State name converted to code Whitespace trimmed
CLM-425741	CLM	Luis Dominguez	1955-05-24	UHC-85052-29	—	42 Washington St, Los Angeles, CA, 90034	0.68	Member ID reformatted Street suffix standardised Address re-cased Gender normalised
ENR-106157	ENR	Kathyn Lucas	1962-12-14	UHC-16010-27	—	1802 Lake View Rd, Denver, CO, 80234	0.68	Phone missing area code Member ID reformatted Street suffix standardised Address re-cased
ENR-102441	ENR	Lucia Campbell	1947-06-23	UHC-88386-26	—	3984 Broadway, Glendale, AZ, 85382	0.68	Name split from “Last, First”Phone missing area code Member ID reformatted Address re-cased
ENR-135985	ENR	Aaron Q Munoz	1973-07-01	UHC-89337-67	4904978412	7523 Maple Ave, Eden Prairie, MN, 55399	0.68	Two-digit birth year Member ID reformatted Street suffix standardised Address re-cased
ENR-108917	ENR	Grace C Kelly	1992-06-04	UHC-21222-79	7665060494	5725 Maple Ave, San Diego, CA	0.68	Two-digit birth year Phone reformatted Member ID reformatted ZIP missing
CLM-414705	CLM	Cynthia Green	1979-06-21	UHC-66762-67	—	1316 Jefferson Ave Apt 29, Orlando, FL, 32883	0.68	Member ID reformatted Unit split from street State name converted to code Placeholder values cleared
ENR-120736	ENR	Nicole Z Daniels	2002-09-27	UHC-34186-32	2206392988	6952 Central Ave Apt 38, Tampa, FL, 33627	0.68	Two-digit birth year Phone reformatted Member ID reformatted Unit split from street
CLM-421774	CLM	Luis McDonald	1940-06-07	UHC-12314-12	8712962148	4096 Main St, Glendale, AZ	0.68	Phone reformatted Member ID reformatted SSN last four extracted ZIP missing
TPA-51546	TPA	Teresa Wilson	1977-09-18	UHC-45385-63	—	456 Canyon Rd, Tucson, AZ, 85775	0.68	Name split from “Last, First”Member ID reformatted State name converted to code Placeholder values cleared
ENR-117345	ENR	Luis C Weaver	1970-06-07	UHC-64638-57	—	—	0.68	Name split from “Last, First”Phone missing area code Member ID reformatted Placeholder values cleared
ENR-104063	ENR	Wei Simmons	1960-12-13	UHC-53875-63	3679410501	9728 Broadway, Austin, TX, 78782	0.68	Name split from “Last, First”Two-digit birth year Member ID reformatted Whitespace trimmed
ENR-128691	ENR	Alexis R Price	—	UHC-80433-48	—	9366 Indian School Rd, Charlotte, NC, 28204	0.68	Date of birth missing Member ID reformatted State name converted to code Placeholder values cleared
CLM-418403	CLM	Omar Evans	1971-06-08	UHC-04207-13	—	—	0.68	Name split from “Last, First”Member ID reformatted Gender normalised Placeholder values cleared
ENR-141717	ENR	Ronald Morales	1966-10-19	UHC-25860-33	3797617079	3264 Willow Ct, Plano, TX, 75010	0.68	Two-digit birth year Phone reformatted Member ID reformatted Gender normalised
CLM-418793	CLM	Larry Chapman	1981-11-16	UHC-75031-60	—	3349 Union St Apt 29, Eden Prairie, MN, 55390	0.68	Member ID reformatted Unit split from street ZIP+4 trimmed Placeholder values cleared
ENR-142254	ENR	Rachel N Holmes	1982-08-28	UHC-72535-35	—	9194 Desert Sky Blvd, Los Angeles, CA, 90001	0.68	Phone missing area code Member ID reformatted Street suffix standardised Address re-cased
ENR-139374	ENR	Carolyn Patel	1948-08-01	UHC-70506-50	4277477862	9476 Jefferson Ave, Jacksonville, FL, 32221	0.68	Name split from “Last, First”Member ID reformatted ZIP+4 trimmed Placeholder values cleared
ENR-134883	ENR	Theresa Y Rios	2008-07-20	UHC-59751-66	7099412606	3083 Sage Ct, Houston, TX, 77063	0.68	Member ID reformatted ZIP+4 trimmed Gender normalised Whitespace trimmed
ENR-107886	ENR	Kenneth K Ellis	1945-06-12	UHC-91252-46	5884796031	5467 Apache Blvd, Austin, TX	0.68	Name split from “Last, First”Member ID reformatted ZIP missing Whitespace trimmed
ENR-137831	ENR	Alan Z Nelson	1978-07-11	UHC-35440-27	7365152908	1155 Lincoln Way # 321, Charlotte, NC, 28209	0.68	Phone reformatted Member ID reformatted Unit split from street Gender normalised
ENR-107509	ENR	Sandra Z Baker	1972-10-10	UHC-47885-43	—	8323 Sage Ct # 293, Sacramento, CA, 95804	0.68	Date of birth reformatted Phone missing area code Member ID reformatted Unit split from street

7,723 rows, page 61 of 155Previous Next