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 “ZIP+4 trimmed”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP+4 trimmedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-138144	ENR	Jonathan O Mendoza	1997-01-20	UHC-18541-92	6033249527	5911 Meadow Ln, Dallas, TX, 75203	0.80	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
ENR-111756	ENR	Michael S Murphy	1985-10-03	UHC-63081-80	—	4930 Central Ave, Plano, TX, 75039	0.80	Name re-cased Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-139253	ENR	Lauren I Johnson	1991-06-20	UHC-39409-51	2182276792	1441 Central Ave, Tempe, AZ, 85200	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-139186	ENR	Julie Aguilar	1960-04-02	UHC-30259-35	6234465131	626 Cedar Ln, San Diego, CA, 92148	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-127019	ENR	Larry Burton	2005-06-17	UHC-70176-42	5655182697	1949 Cedar Ln, Tucson, AZ, 85722	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-116610	ENR	Janet J Younng	1976-05-24	UHC-69097-81	2425705194	3328 Oak St, Nashville, TN, 37280	0.80	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-142151	ENR	Julia Hicks	1983-05-13	UHC-00561-02	3713527640	4145 Elm St, Phoenix, AZ, 85010	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-108214	ENR	Grace G Gonzalez	1947-09-26	UHC-40635-52	8004806268	1884 Union St, Las Vegas, NV, 89154	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-118578	ENR	Henry Foster	1990-02-24	UHC-02130-07	2919267600	4824 Mountain View Dr, Dallas, TX, 75285	0.80	ZIP+4 trimmed Plan code upper-cased Whitespace trimmed Placeholder values cleared
ENR-134575	ENR	Ahmed Z Stephens	1978-07-19	UHC-19963-67	3339586757	3566 Oak St, Los Angeles, CA, 90022	0.80	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed
ENR-115284	ENR	Deborah C Howard	1958-08-08	UHC-46791-90	4137536810	6384 Maple Ave, Eden Prairie, MN, 55305	0.80	Phone reformatted ZIP+4 trimmed Email lower-cased Whitespace trimmed
ENR-107824	ENR	Joyce Bryant	1992-05-05	UHC-62977-32	8362955748	1486 Forest Ave, San Diego, CA, 92119	0.80	Date of birth reformatted ZIP+4 trimmed Email lower-cased Placeholder values cleared
ENR-104085	ENR	Rivera T Christian	2000-04-11	UHC-95771-57	5122835725	2617 Sage Ct, Seattle, WA, 98158	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-121114	ENR	Jerry O Riley	1951-11-24	UHC-85363-70	6112421163	9066 Park Pl, Miami, FL, 33170	0.80	Date of birth reformatted City re-cased ZIP+4 trimmed Email lower-cased
ENR-128140	ENR	John X Fox	1942-08-28	UHC-40679-15	7197997533	9468 Palm Dr, Dallas, TX, 75204	0.80	Name re-cased ZIP+4 trimmed Email lower-cased Whitespace trimmed
ENR-129385	ENR	Danielle A Peterson	1969-08-08	UHC-46987-02	7116132232	6178 Ridge Rd, Las Vegas, NV, 89152	0.80	Name re-cased Date of birth reformatted ZIP+4 trimmed Email lower-cased
ENR-131535	ENR	Wei B Stevens	1957-09-24	UHC-61657-92	2593872084	526 Sage Ct, Austin, TX, 78788	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Plan code upper-cased
ENR-107963	ENR	Kathleen K Daniels	1939-03-11	UHC-48830-22	—	5667 Lake View Rd, Mesa, AZ, 85201	0.80	State code upper-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-110962	ENR	Linda Lopez	1984-05-27	UHC-66609-08	9573082904	5877 Washington St, Tucson, AZ, 85724	0.80	Phone reformatted Member ID reformatted ZIP+4 trimmed Whitespace trimmed
ENR-133349	ENR	Gregory T Tucker	1959-01-20	UHC-79367-81	—	5215 Mountain View Dr, Columbus, OH, 43294	0.80	Member ID reformatted ZIP+4 trimmed Email lower-cased Whitespace trimmed
ENR-103716	ENR	Dylan I Taylor	1946-10-06	UHC-33407-72	8737763810	8606 Park Pl, Atlanta, GA, 30366	0.80	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed
ENR-138464	ENR	Ryan Henderson	1988-02-26	UHC-25992-50	4565937328	2700 Maple Ave, Orlando, FL, 32870	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Email lower-cased
ENR-139784	ENR	Gloria C Ferguson	1971-01-27	—	2657068945	2709 Broadway, Minneapolis, MN, 55427	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-112760	ENR	Gary Stewart	1979-12-12	UHC-82371-38	3799574039	2034 Valley View Dr, Tempe, AZ, 85273	0.80	Name re-cased ZIP+4 trimmed Plan code upper-cased Whitespace trimmed
ENR-117528	ENR	Ashley N Griffin	1996-03-05	UHC-30684-46	—	7288 Market St, Houston, TX, 77062	0.80	City re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-127865	ENR	Mark Schmidt	1966-10-14	UHC-60593-83	2096465528	953 Meadow Ln, Mesa, AZ, 85287	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-141447	ENR	Lawrence J Davis	1987-06-12	UHC-14304-43	5052901117	9021 Highland Ave, Plano, TX, 75027	0.80	Date of birth reformatted City re-cased ZIP+4 trimmed Plan code upper-cased
ENR-124154	ENR	Kyle Padilla	1983-10-02	UHC-83600-99	9539413714	9353 Valley View Dr, San Antonio, TX, 78227	0.80	Phone reformatted ZIP+4 trimmed Email lower-cased Whitespace trimmed
ENR-116507	ENR	Debra Powell	1945-02-07	UHC-90874-75	7948101299	4358 Forest Ave, Tampa, FL, 33622	0.80	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed
ENR-112262	ENR	Jordan Baker	1990-11-22	UHC-78101-68	8214934284	4551 Broadway, Tucson, AZ, 85779	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-125994	ENR	Steven Weaver	1963-06-02	UHC-01879-06	6462546354	4330 Harbor Blvd, Houston, TX, 77080	0.80	Name re-cased ZIP+4 trimmed Plan code upper-cased Placeholder values cleared
ENR-130537	ENR	Billy X Fisher	1981-08-20	UHC-80053-21	9354351554	696 Union St, Nashville, TN, 37259	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-142635	ENR	Cheryl C Oliver	1950-08-04	UHC-04381-26	—	6848 Sage Ct, Gilbert, AZ, 85234	0.80	ZIP+4 trimmed Email lower-cased Whitespace trimmed Placeholder values cleared
ENR-126543	ENR	Roger H Wallace	1956-04-21	UHC-00433-86	2352284162	8177 Broadway, Houston, TX, 77034	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-117610	ENR	Russell S Bailey	1987-04-01	UHC-87909-52	4224240293	4758 Maple Ave, Chandler, AZ, 85276	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-139461	ENR	Harold Watkins	1962-09-01	UHC-53948-51	8545818765	9214 Lake View Rd, San Diego, CA, 92105	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-112175	ENR	Pamela L Simpson	1987-12-16	UHC-42045-03	2748896114	8409 Ridge Rd, Glendale, AZ, 85358	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-136790	ENR	Wei L Vega	1997-12-07	UHC-47177-97	4972338463	6344 Forest Ave, Sacramento, CA, 95827	0.80	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed
ENR-127548	ENR	Melissa Marshall	1998-06-13	UHC-73960-39	6002771530	4529 Grand Ave, Minneapolis, MN, 55492	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-118172	ENR	Alexis F Peterson	1971-06-13	UHC-41655-03	2862788240	7289 River Rd, Orlando, FL, 32849	0.80	Phone reformatted Member ID reformatted ZIP+4 trimmed Placeholder values cleared
ENR-120698	ENR	Kathy M Duncan	1957-06-27	UHC-88906-54	5183115046	4883 Desert Sky Blvd, Las Vegas, NV, 89149	0.80	Name re-cased City re-cased ZIP+4 trimmed Whitespace trimmed
ENR-121884	ENR	Joseph Payne	1983-10-10	UHC-48006-84	9685451234	5057 Central Ave, Tampa, FL, 33620	0.80	Phone reformatted City re-cased ZIP+4 trimmed Placeholder values cleared
ENR-117670	ENR	Anna M Carr	1972-11-13	UHC-48919-48	4513187275	5510 Elm St, Dallas, TX, 75282	0.80	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-117671	ENR	Anna M Carr	1972-11-13	UHC-48919-48	4513187275	5510 Elm St, Dallas, TX, 75282	0.80	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-109407	ENR	Murphy O Brandon	1969-03-05	UHC-35997-95	8619763609	5643 Valley View Dr, Houston, TX, 77069	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-127571	ENR	Christian Salazar	1972-06-19	UHC-51574-82	5026391812	7422 Camelback Rd, Miami, FL, 33146	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-136025	ENR	Emily Duncan	1995-02-28	UHC-52565-95	3099604838	9117 Harbor Blvd, Sacramento, CA, 95818	0.80	Phone reformatted City re-cased ZIP+4 trimmed Placeholder values cleared
ENR-111764	ENR	Gerald Maldonaod	1995-11-12	UHC-91427-57	5104425109	1415 Indian School Rd, Las Vegas, NV, 89111	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-109595	ENR	Josua E Ferguson	1949-10-20	UHC-04256-92	2696900357	6972 Indian School Rd, Dallas, TX, 75270	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-131479	ENR	Hannah U Bradley	1971-09-11	UHC-85847-31	4387238248	3317 Elm St, Houston, TX, 77060	0.80	Phone reformatted Member ID reformatted ZIP+4 trimmed Placeholder values cleared

3,951 rows, page 74 of 80Previous Next