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 “Gender normalised”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagGender normalisedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-100718	ENR	Adam Turner	1942-05-16	UHC-96098-12	8332131506	—	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-110917	ENR	Hiroshi F Santiago	2001-09-03	UHC-57449-30	9706256458	9412 Lincoln Way, Tucson, AZ, 85704	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-133068	ENR	Noah A Olson	2001-05-14	UHC-28379-03	2795817329	7807 Palm Dr, Scottsdale, AZ, 85228	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-100989	ENR	Carolyn Hanson	2008-08-09	UHC-95340-58	5937236006	300 Indian School Rd, Houston, TX, 77016	0.82	Name re-cased City re-cased Gender normalised
ENR-106990	ENR	Laura J Bowman	2002-12-23	UHC-16543-14	5077262586	4517 Church St, Fresno, CA, 93702	0.82	Name re-cased Phone reformatted Gender normalised
ENR-124671	ENR	Brittany Lucas	1951-04-16	UHC-00279-10	7084933770	495 Washington St, San Antonio, TX, 78269	0.82	Name re-cased Phone reformatted Gender normalised
ENR-106126	ENR	Kelly L Matthews	1997-08-28	UHC-58062-54	—	2441 Highland Ave, Columbus, OH, 43284	0.82	Name re-cased Gender normalised Whitespace trimmed
ENR-130051	ENR	Julie Dixon	1947-05-03	UHC-54209-32	8718050839	8661 Bayshore Dr, Gilbert, AZ, 85249	0.82	State code upper-cased Gender normalised Whitespace trimmed
ENR-131711	ENR	Gregory Z Franklin	1967-11-25	UHC-33832-35	—	4010 Mesa Dr, Los Angeles, CA, 90097	0.82	Name re-cased Date of birth reformatted Gender normalised
ENR-104054	ENR	Jose E Richardson	1960-08-27	UHC-61622-11	6046186708	9388 Cedar Ln, Nashville, TN, 37275	0.82	Date of birth reformatted Phone reformatted Gender normalised
ENR-114622	ENR	Ethan Griffin	1999-10-13	UHC-23197-88	3033574813	8239 Willow Ct, Minneapolis, MN, 55423	0.82	Date of birth reformatted Gender normalised Whitespace trimmed
ENR-127413	ENR	Noah X Hall	1967-05-02	UHC-82083-48	7247522715	5769 Bayshore Dr, Tampa, FL, 33635	0.82	Name re-cased Gender normalised Placeholder values cleared
ENR-126119	ENR	Sandra P Rios	1991-06-06	UHC-53803-79	5724614710	6026 Hillcrest Rd, Plano, TX, 75052	0.82	Phone reformatted Gender normalised Placeholder values cleared
ENR-124305	ENR	Tyler P Perez	2008-08-23	UHC-99222-11	6839772929	5578 Bayshore Dr, Atlanta, GA, 30305	0.82	Phone reformatted City re-cased Gender normalised
ENR-115525	ENR	Andrea Mendoza	1947-01-19	UHC-04670-09	5504911933	5208 Palm Dr, Jacksonville, FL, 32284	0.82	Name re-cased Date of birth reformatted Gender normalised
ENR-104213	ENR	Carlos Hunt	1989-08-24	UHC-62413-34	5447511054	5041 Park Pl, Sacramento, CA, 95801	0.82	Name re-cased Gender normalised Whitespace trimmed
ENR-124700	ENR	Joe Fox	1969-04-05	UHC-72012-65	5587681049	62 Broadway, Mesa, AZ, 85295	0.82	City re-cased Email lower-cased Gender normalised
ENR-116015	ENR	Michelle Hayes	1957-04-13	UHC-81661-07	8642641798	4123 Park Pl, Denver, CO, 80208	0.82	Phone reformatted Gender normalised Placeholder values cleared
ENR-138779	ENR	Olivia Shaw	1957-04-28	UHC-50891-73	2169564424	6872 Jefferson Ave, Dallas, TX, 75259	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-115402	ENR	Jaan Oliver	1943-02-20	UHC-69298-44	—	—	0.82	Date of birth reformatted Gender normalised Placeholder values cleared
ENR-122735	ENR	Martha A Henderson	2008-10-26	UHC-24638-57	3896377268	6710 Washington St, Minneapolis, MN, 55437	0.82	Name re-cased Gender normalised Whitespace trimmed
ENR-114096	ENR	Carol K Banks	1999-02-17	UHC-53162-58	6282900092	7354 Mesa Dr, Scottsdale, AZ, 85253	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-137637	ENR	Francs A Fowler	1938-07-07	UHC-89235-68	2659490434	7935 Pine Dr, Plano, TX, 75095	0.82	Name re-cased City re-cased Gender normalised
ENR-125986	ENR	Christina W Lewis	1955-08-23	UHC-10969-44	—	8303 Indian School Rd, Chandler, AZ, 85219	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
ENR-116031	ENR	Juan S Reyes	1996-09-28	UHC-34305-07	—	5876 Camelback Rd, Tucson, AZ, 85759	0.82	Name re-cased Gender normalised Placeholder values cleared
ENR-114085	ENR	Henry G Mejia	1952-07-19	UHC-77875-90	7222379746	2554 Union St, Jacksonville, FL, 32237	0.82	Name re-cased Gender normalised Whitespace trimmed
ENR-131506	ENR	Edward George	1983-06-17	UHC-36356-27	9256549706	3180 Elm St, Austin, TX, 78742	0.82	Date of birth reformatted Gender normalised Placeholder values cleared
ENR-107321	ENR	Wayne F Hernandez	1989-12-21	UHC-61866-64	6002473628	7317 Oak St, Seattle, WA, 98128	0.82	Phone reformatted Email lower-cased Gender normalised
ENR-102714	ENR	Aaron F Reyes	1978-03-17	UHC-11041-58	5257134253	8629 Indian School Rd, Denver, CO, 80225	0.82	Member ID reformatted Gender normalised Whitespace trimmed
ENR-130907	ENR	Diane Ramos	1951-10-02	UHC-44594-97	6556412449	131 Willow Ct, Glendale, AZ, 85350	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-120432	ENR	Stephen P Mills	2000-10-19	UHC-08024-69	—	—	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
ENR-127230	ENR	Grace West	1982-01-10	UHC-44294-55	4716160270	179 Lincoln Way, Orlando, FL, 32864	0.82	Date of birth reformatted Phone reformatted Gender normalised
ENR-120008	ENR	Carter X Walter	2003-10-18	UHC-65203-16	7006404970	2950 Bayshore Dr, Austin, TX, 78708	0.82	Email lower-cased Gender normalised Whitespace trimmed
ENR-132974	ENR	Kimberly X Harris	1969-04-21	UHC-91348-73	3795143964	5289 Valley View Dr, San Diego, CA, 92102	0.82	Phone reformatted Gender normalised Plan code upper-cased
ENR-132975	ENR	Kimberly X Harris	1969-04-21	UHC-91348-73	3795143964	5289 Valley View Dr, San Diego, CA, 92102	0.82	Phone reformatted Gender normalised Plan code upper-cased
ENR-137848	ENR	Richard Parker	1959-09-01	UHC-64387-14	7939705952	5240 Hillcrest Rd, Fresno, CA, 93784	0.82	Date of birth reformatted Phone reformatted Gender normalised
ENR-140012	ENR	Edward Brown	1982-07-07	UHC-82800-08	7992775205	8002 Bayshore Dr, Denver, CO, 80218	0.82	City re-cased Gender normalised Placeholder values cleared
ENR-126641	ENR	Arjun Stone	1987-03-17	UHC-35646-80	—	5322 Maple Ave, Columbus, OH, 43203	0.82	Name re-cased Gender normalised Whitespace trimmed
ENR-142810	ENR	Stephanie Q Patterson	1994-11-07	UHC-56178-98	9466348808	9021 Highland Ave, Houston, TX, 77009	0.82	Phone reformatted Email lower-cased Gender normalised
ENR-138304	ENR	Valentina Wells	1965-05-12	UHC-09581-70	7877473756	8706 Broadway, Dallas, TX, 75247	0.82	Name re-cased Phone reformatted Gender normalised
ENR-135868	ENR	Keith L Wheeler	1952-02-22	UHC-48227-16	9336086302	1930 Park Pl, Scottsdale, AZ, 85289	0.82	Member ID reformatted City re-cased Gender normalised
ENR-135583	ENR	Ktae Jenkins	1953-12-20	UHC-31660-94	3325695376	7593 Mesa Dr, Tampa, FL, 33624	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-129015	ENR	Jennifer X Alvarez	2004-01-23	UHC-80421-38	5552219998	8706 Desert Sky Blvd, Los Angeles, CA, 90056	0.82	Name re-cased Phone reformatted Gender normalised
ENR-122273	ENR	Diane G Rogers	2004-10-08	UHC-26032-76	9448180415	7771 Maple Ave, Gilbert, AZ, 85215	0.82	Name re-cased Phone reformatted Gender normalised
ENR-133238	ENR	Lawrence T Howard	1942-08-21	UHC-03154-60	8766934112	6413 Union St, Tempe, AZ, 85221	0.82	Phone reformatted Email lower-cased Gender normalised
ENR-106935	ENR	Jonathan Howard	1953-12-05	UHC-92491-49	8308482836	5939 Desert Sky Blvd, Scottsdale, AZ, 85209	0.82	Phone reformatted Gender normalised Placeholder values cleared
ENR-103913	ENR	Paul Fisheer	1946-10-26	UHC-29098-94	6037062710	4494 Lake View Rd, Minneapolis, MN, 55458	0.82	Date of birth reformatted Email lower-cased Gender normalised
ENR-113867	ENR	Marilyn I Patterson	1997-01-05	UHC-43471-66	5688744256	—	0.82	Name re-cased Gender normalised Placeholder values cleared
ENR-120322	ENR	Angela J Castillo	1941-03-21	UHC-62876-52	—	—	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
ENR-120321	ENR	Angela J Castillo	1941-03-21	UHC-62876-52	—	—	0.82	Gender normalised Whitespace trimmed Placeholder values cleared

7,326 rows, page 142 of 147Previous Next