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

Enrollment, 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
ENR-142450	ENR	Olivia H Richards	1954-07-12	UHC-88327-04	6018556690	303 Ocean Ave, Tempe, AZ, 85256	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-126050	ENR	Lucia E Parker	1955-11-12	UHC-17810-44	3165746391	5680 Elm St, Austin, TX, 78704	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-123664	ENR	Christine C Delgado	1941-08-20	UHC-74487-51	4209125213	6732 Elm St, Jacksonville, FL, 32237	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-132668	ENR	Alice F Gomez	1939-01-07	UHC-92278-25	6478136003	5999 Sage Ct, Fresno, CA, 93711	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-122888	ENR	Patricia I Austin	1974-08-10	UHC-85341-11	6975094085	829 Broadway, Columbus, OH, 43210	0.76	Name re-cased Two-digit birth year Phone reformatted Address re-cased+2 more
ENR-112880	ENR	Ashley Lopez	1944-08-15	UHC-75234-83	6934061650	1743 Sage Ct, Denver, CO, 80272	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-101125	ENR	Ryan Kelly	1969-12-07	UHC-98387-34	2216232833	2586 Oak St, Minneapolis, MN, 55492	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-128867	ENR	Alexander E Snyder	1992-07-21	UHC-73516-09	3486850678	9767 Union St, Atlanta, GA, 30313	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-128601	ENR	Doris Dominguez	2006-04-06	UHC-59186-32	5869387659	2312 Canyon Rd, Los Angeles, CA, 90011	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-133580	ENR	Valentina N Gibson	1938-01-16	UHC-61258-49	6228942862	7698 Mountain View Dr, Gilbert, AZ, 85235	0.76	Name re-cased Street suffix standardised Address re-cased Plan code upper-cased+2 more
ENR-106764	ENR	Sophia M Anderson	1944-05-23	UHC-17148-98	7069163760	2387 Sage Ct, Houston, TX, 77074	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-113070	ENR	Sandra A Hoffman	1968-03-22	UHC-72456-92	9244791907	8251 Willow Ct, Orlando, FL, 32825	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-114052	ENR	Espinoza P Dylan	1955-06-26	UHC-01683-02	2739147317	2999 Lincoln Way, Denver, CO, 80210	0.76	Name re-cased Phone reformatted City re-cased State name converted to code+2 more
ENR-119501	ENR	John Salazar	1994-07-01	UHC-24125-50	5549680666	141 Valley View Dr, Minneapolis, MN, 55466	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-114890	ENR	Ann Alvarado	2008-10-07	UHC-66118-84	2808854764	2696 Cedar Ln, Sacramento, CA, 95837	0.76	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+2 more
ENR-103856	ENR	Zachary Torres	1984-04-20	UHC-93213-04	—	9727 Mesa Dr, Seattle, WA, 98194	0.76	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-140442	ENR	Wayne G Robertson	1964-03-04	UHC-43788-24	4017897430	3463 Palm Dr, Tampa, FL, 33601	0.76	Name re-cased Street suffix standardised Address re-cased Email lower-cased+2 more
ENR-121381	ENR	Henry G Olson	1999-05-16	UHC-70655-47	3983088282	3416 Pine Dr, Miami, FL, 33112	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-129706	ENR	Frank Y Patel	1973-03-24	UHC-81497-86	2786052891	2646 Sunset Blvd # 194, San Diego, CA, 92126	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-101441	ENR	Kathryn W Holmes	1939-02-10	UHC-21580-23	2069501377	1223 Canyon Rd, Austin, TX, 78717	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-115548	ENR	Carol Phillipps	1962-03-25	UHC-67396-37	—	9443 Elm St, Fresno, CA, 93795	0.76	Name re-cased Street suffix standardised Address re-cased Email lower-cased+2 more
ENR-114736	ENR	David Guerrero	1982-06-12	UHC-69352-30	4496359369	4573 Main St, Scottsdale, AZ, 85289	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-124282	ENR	Michelle Dominguez	1991-02-15	UHC-10153-41	6547692431	1652 Willow Ct, Jacksonville, FL, 32208	0.76	Name re-cased Phone reformatted Gender normalised Plan code upper-cased+2 more
ENR-141782	ENR	Doris K Martinez	1969-08-11	UHC-96353-84	8837165670	788 Maple Ave, Plano, TX, 75029	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-101946	ENR	Angela Hawkins	1945-03-25	UHC-87699-01	5728977358	6764 Ocean Ave, Los Angeles, CA, 90095	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-138810	ENR	Ashley O Mason	2006-01-05	UHC-58320-28	6706363011	6569 Park Pl, Chandler, AZ, 85271	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-113282	ENR	Martha Z Gibert	1977-02-08	UHC-54491-74	3542060608	3940 Oak St, Tampa, FL, 33608	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-115211	ENR	Simmons Samantha	1997-02-10	UHC-59590-89	6204684948	1931 Mesa Dr, Glendale, AZ, 85369	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-138612	ENR	Debra O Obrien	1971-06-16	UHC-31731-46	6933298041	3034 Park Pl, Glendale, AZ, 85337	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-135602	ENR	Philip T Burke	1967-07-13	UHC-11730-46	7784888532	5182 Apache Blvd, Plano, TX, 75068	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-129839	ENR	Terry W Bakns	1941-08-25	UHC-16965-86	9348945014	9173 Lake View Rd, Plano, TX, 75064	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-108479	ENR	Kenneth Roberts	1976-01-07	UHC-87369-79	6313018862	2936 Hillcrest Rd, Chandler, AZ, 85268	0.76	Phone reformatted Street suffix standardised Address re-cased Email lower-cased+2 more
ENR-100299	ENR	Kelly U Rudriguez	1976-02-12	UHC-32227-18	8068634436	1765 Cedar Ln, Jacksonville, FL, 32298	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-109125	ENR	Mary Salazar	1994-01-28	UHC-00239-37	2948340725	470 Apache Blvd, Phoenix, AZ, 85077	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-100452	ENR	Edward A Howell	1950-12-13	UHC-47701-51	7084587377	4793 Main St, Atlanta, GA, 30345	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-131301	ENR	Marcus R Fuller	1967-12-11	UHC-34181-47	9129912279	9406 Indian School Rd, Scottsdale, AZ, 85291	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-131926	ENR	Grace Payne	1973-11-25	UHC-34652-72	5048748926	4276 Desert Sky Blvd, San Antonio, TX, 78287	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-101590	ENR	Julia Hall	1968-12-07	UHC-88062-97	5428766473	4168 Oak St, Denver, CO, 80215	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-113348	ENR	QJunk	1994-11-06	UHC-15235-11	6353217120	4333 Spring St, Atlanta, GA, 30351	0.76	Date of birth reformatted Phone reformatted City re-cased Whitespace trimmed+2 more
ENR-140508	ENR	Sophia Kennedy	1974-02-17	UHC-66172-51	4258701258	7941 Cedar Ln, Los Angeles, CA, 90068	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-137743	ENR	Mark Harper	1948-01-14	UHC-36602-12	8607653113	2277 Lincoln Way Apt 20, Seattle, WA, 98189	0.76	Name re-cased Phone reformatted Unit split from street Email lower-cased+2 more
ENR-119589	ENR	Lisa H Nunez	1998-11-13	UHC-01376-40	6524929615	1373 Lake View Rd, Charlotte, NC, 28214	0.76	Name re-cased Two-digit birth year Phone reformatted Member ID reformatted+2 more
ENR-119023	ENR	Eric Coleman	2007-04-20	UHC-65472-35	6735916329	2114 Main St, Charlotte, NC, 28252	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-110797	ENR	Larry N Patterson	1993-11-15	UHC-30933-70	7129873032	8912 Ocean Ave, San Antonio, TX, 78220	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-125571	ENR	Brandon Patterson	1949-02-27	UHC-78874-42	3364399188	1273 Apache Blvd, Tempe, AZ, 85208	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-116936	ENR	Tyler J Barnes	1950-09-02	UHC-07520-05	8109063689	2150 Indian School Rd, Seattle, WA, 98177	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-139783	ENR	Cynthia B Lopez	1988-04-24	UHC-82886-31	8703083589	6647 Union St, Plano, TX, 75070	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-116357	ENR	Marta E Jaes	1995-10-20	UHC-42778-78	—	3614 Camelback Rd, Sacramento, CA, 95862	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-122472	ENR	Theresa Y Price	2003-04-02	UHC-56837-21	7467300503	3040 Main St, Jacksonville, FL	0.76	Name re-cased Phone reformatted ZIP missing Email lower-cased+2 more
ENR-131516	ENR	Janice Ortega	1989-12-12	UHC-16709-37	2542846424	7739 Canyon Rd, Orlando, FL, 32849	0.76	Phone reformatted Street suffix standardised Address re-cased State code upper-cased+2 more

16,916 rows, page 166 of 339Previous Next