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-143066	ENR	Patricia J Yang	1991-10-21	UHC-62514-96	9267806728	3279 Cedar Ln, Tucson, AZ, 85792	0.80	State code upper-cased Gender normalised Plan code upper-cased Whitespace trimmed
ENR-130057	ENR	Arjun Hansen	2008-12-22	UHC-24319-70	8946064469	8163 Apache Blvd, Phoenix, AZ, 85006	0.80	Date of birth reformatted City re-cased State code upper-cased Gender normalised
ENR-131153	ENR	Samantha Lawson	1981-03-03	UHC-59223-01	5205576135	2429 Indian School Rd, Miami, FL, 33151	0.80	Name re-cased Phone reformatted Email lower-cased Gender normalised
ENR-102584	ENR	Dylan Q Webb	1948-09-10	UHC-43714-69	9082099559	2965 Camelback Rd, Tampa, FL, 33687	0.80	Phone reformatted State code upper-cased Email lower-cased Gender normalised
ENR-117797	ENR	Alexis Larson	1979-11-17	UHC-76318-95	7545813289	8456 Union St, Miami, FL, 33123	0.80	Phone reformatted Member ID reformatted Gender normalised Plan code upper-cased
ENR-138943	ENR	Jacob Knight	1990-08-28	UHC-87545-68	7144005082	831 Oak St, Chandler, AZ, 85270	0.80	State code upper-cased Email lower-cased Gender normalised Whitespace trimmed
ENR-109578	ENR	Powell F Lisa	1963-10-19	UHC-05707-34	6445209309	4384 Meadow Ln, Seattle, WA, 98122	0.80	Date of birth reformatted Member ID reformatted Gender normalised Whitespace trimmed
ENR-125937	ENR	Helen X Green	1999-08-15	UHC-50605-47	5909581699	7403 Valley View Dr, Chandler, AZ, 85296	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-120608	ENR	Cynthia B Fisher	1969-12-04	UHC-20590-78	4372426494	6306 River Rd, Miami, FL, 33137	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-140903	ENR	Ryan Herrera	1974-12-14	—	8178893455	530 Maple Ave, Dallas, TX, 75234	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
ENR-137185	ENR	Angela Greene	2003-03-06	UHC-76070-73	5664497496	7462 Harbor Blvd, Sacramento, CA, 95896	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-104788	ENR	Sean Clark	1973-12-09	UHC-83360-30	7267108289	6639 Mountain View Dr, Sacramento, CA, 95813	0.80	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed
ENR-115681	ENR	Nathan W Robertson	1995-01-26	UHC-43232-11	8576542564	1798 Desert Sky Blvd, Fresno, CA, 93744	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
ENR-133984	ENR	Jordan Y Black	1968-06-13	UHC-64391-75	9009461368	3127 Desert Sky Blvd, Plano, TX, 75063	0.80	Phone reformatted Member ID reformatted Gender normalised Whitespace trimmed
ENR-111828	ENR	Sara O Reid	1982-03-24	UHC-31750-93	—	4927 Jefferson Ave, Chandler, AZ, 85224	0.80	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed
ENR-104812	ENR	Michelle Lane	1940-12-15	UHC-28177-51	5816174089	7817 Lake View Rd, Phoenix, AZ, 85050	0.80	Name re-cased Email lower-cased Gender normalised Whitespace trimmed
ENR-121892	ENR	Brandon N Walsh	1982-12-28	UHC-90629-75	4052542136	6172 Broadway, Austin, TX, 78780	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
ENR-122883	ENR	Alan Y Hansen	1962-04-07	UHC-04697-25	7868477231	5734 Sunset Blvd, Fresno, CA, 93713	0.80	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed
ENR-114522	ENR	Zachary J Crawford	1968-04-24	UHC-19313-14	8926529815	2766 Sage Ct, Glendale, AZ, 85342	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-139856	ENR	Janet N Reed	1958-05-16	UHC-76562-94	7635444301	95 Valley View Dr, Tempe, AZ, 85284	0.80	Name re-cased City re-cased Gender normalised Placeholder values cleared
ENR-115698	ENR	Kayla X Wheeler	1959-05-28	UHC-93146-81	7315514621	3581 Palm Dr, Glendale, AZ, 85361	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
ENR-113792	ENR	Carl Allen	1981-08-05	UHC-10011-76	4626636251	4161 Sage Ct, Tampa, FL, 33674	0.80	Name re-cased City re-cased Gender normalised Whitespace trimmed
ENR-111519	ENR	Bryan C Wheeler	2000-01-22	UHC-07444-96	7307510835	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
ENR-124913	ENR	Emma A Cooper	1995-10-07	UHC-88969-36	2245180837	8811 Sage Ct, Los Angeles, CA, 90074	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-134278	ENR	Joan K Long	1997-04-21	UHC-83158-92	7489419596	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-107469	ENR	Logaan O Miller	2007-09-09	UHC-64416-47	5173895683	1524 Cedar Ln, Eden Prairie, MN, 55325	0.80	Phone reformatted Member ID reformatted Gender normalised Whitespace trimmed
ENR-125911	ENR	Linda Nguyen	1979-08-01	UHC-88212-50	4378165038	2371 Sage Ct, Seattle, WA, 98112	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-133640	ENR	Ray Grant	1998-01-11	UHC-10097-39	6375756524	5570 Ocean Ave, Miami, FL, 33120	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
ENR-102155	ENR	Adam Perry	1975-04-07	UHC-90942-83	4999029612	1177 Union St, San Antonio, TX, 78233	0.80	Member ID reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-114291	ENR	Richard Stevens	1965-01-13	UHC-95792-02	2038449025	5115 Desert Sky Blvd, Columbus, OH, 43254	0.80	Phone reformatted Email lower-cased Gender normalised Whitespace trimmed
ENR-130324	ENR	Dennis I Guerrero	1999-02-16	—	2174740533	6401 Mountain View Dr, Mesa, AZ, 85229	0.80	Name re-cased Date of birth reformatted Phone reformatted Gender normalised
ENR-111071	ENR	Logan G Cox	1948-02-15	UHC-10803-30	3356793748	8242 Valley View Dr, Atlanta, GA, 30314	0.80	Phone reformatted Email lower-cased Gender normalised Whitespace trimmed
ENR-119321	ENR	Alan E Campbell	1965-07-15	UHC-71512-79	2403857639	1178 Central Ave, Los Angeles, CA, 90018	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
ENR-115196	ENR	Martha B Washington	1951-06-12	UHC-94243-99	2173951112	8382 Palm Dr, Glendale, AZ, 85394	0.80	Name re-cased City re-cased Gender normalised Whitespace trimmed
ENR-111371	ENR	Betty Le	1953-07-25	UHC-26618-68	6077473424	9800 Mesa Dr, Houston, TX, 77009	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
ENR-137755	ENR	Cristina Z Dominnguez	1985-09-15	UHC-80528-85	8428256560	949 Pine Dr, Dallas, TX, 75251	0.80	Name re-cased City re-cased Gender normalised Whitespace trimmed
ENR-111857	ENR	Cheryl Dunn	1987-12-14	UHC-78434-31	—	6313 Highland Ave, Eden Prairie, MN, 55363	0.80	Name re-cased Date of birth reformatted Gender normalised Placeholder values cleared
ENR-120596	ENR	Marhta R Campbell	2007-12-27	UHC-49054-08	3533336055	2352 Broadway, Mesa, AZ, 85287	0.80	Name re-cased Phone reformatted City re-cased Gender normalised
ENR-112405	ENR	Jack Marquez	1993-03-02	UHC-68011-38	4083412206	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-122150	ENR	Wayne K Rice	1995-09-22	UHC-12262-91	9835266630	429 Park Pl, San Antonio, TX, 78225	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-125691	ENR	Larry K Banks	1947-05-21	UHC-47014-15	5708945326	7288 Mesa Dr, Sacramento, CA, 95840	0.80	Name re-cased Email lower-cased Gender normalised Whitespace trimmed
ENR-123952	ENR	Judith G Cunningham	1986-06-05	UHC-73518-90	7135194974	244 Broadway, Sacramento, CA, 95828	0.80	Phone reformatted Email lower-cased Gender normalised Whitespace trimmed
ENR-137083	ENR	Nancy B Arnold	1956-01-19	UHC-27742-29	9242397837	1624 Camelback Rd, Tucson, AZ, 85719	0.80	Phone reformatted City re-cased Gender normalised Whitespace trimmed
ENR-107695	ENR	Sandra H Guzman	2006-03-20	UHC-67011-38	2384782927	9335 Ocean Ave, Glendale, AZ, 85305	0.80	Phone reformatted City re-cased Gender normalised Whitespace trimmed
ENR-125376	ENR	Jason M Padilla	1988-02-28	UHC-49335-51	4783002660	3237 Cedar Ln, Plano, TX, 75037	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
ENR-116266	ENR	Heather Ford	1975-04-01	UHC-37815-80	3083940982	2692 Lincoln Way, Glendale, AZ, 85323	0.80	Phone reformatted Email lower-cased Gender normalised Whitespace trimmed
ENR-127949	ENR	Anthony Y Parker	1987-01-26	UHC-91210-46	—	6120 River Rd, Denver, CO, 80262	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
ENR-119927	ENR	Lisa Cruz	2000-07-10	UHC-30282-97	2583181027	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
ENR-120989	ENR	Tony T Berry	1987-07-08	UHC-24604-43	8022196146	6486 Palm Dr, Tucson, AZ, 85775	0.80	Phone reformatted Member ID reformatted Gender normalised Placeholder values cleared
ENR-114242	ENR	Aelxis W Freeman	1938-02-06	UHC-84619-94	7013294433	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared

7,326 rows, page 136 of 147Previous Next