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 “Unit split from street”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagUnit split from streetClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-123137	ENR	Mei L James	—	UHC-58231-15	2762007389	911 Oak St Apt 1, Orlando, FL, 32883	0.64	Date of birth missing Phone reformatted Member ID reformatted Unit split from street+2 more
ENR-103502	ENR	Fox S Christopher	1950-04-28	UHC-01934-28	3226692546	3691 Hillcrest Rd Apt 21, Atlanta, GA, 30320	0.64	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+2 more
ENR-137682	ENR	Zachary P Guerrero	1961-10-11	UHC-59045-42	9617256423	9075 Desert Sky Blvd Apt 18, Chandler, AZ, 85287	0.64	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-105616	ENR	Benjamin Romero	1978-11-02	UHC-88365-92	2784441378	614 Main St Apt 8, Los Angeles, CA, 90017	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-123535	ENR	Justin P Tran	1941-03-07	UHC-17587-12	4994592312	3195 Market St # 222, Mesa, AZ, 85232	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-116704	ENR	Janice K Patel	1993-06-11	UHC-60883-65	5658649043	2290 Central Ave Apt 13, Phoenix, AZ, 85052	0.64	Member ID reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-120468	ENR	Jacob Young	2000-11-25	UHC-81162-01	9792463169	8831 Grand Ave Apt 34, Atlanta, GA, 30339	0.64	Phone reformatted Member ID reformatted Unit split from street Street suffix standardised+2 more
ENR-137694	ENR	Gloria Wright	1947-04-09	UHC-54573-38	5523810019	8500 Indian School Rd Apt 31, Tucson, AZ, 85773	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-129854	ENR	Bruce W Wells	1978-11-17	UHC-75374-68	5457998325	7373 Pine Dr Apt 23, Charlotte, NC, 28233	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-134876	ENR	Ethan Contreras	1958-01-25	UHC-15291-50	5659145136	2575 Ocean Ave Apt 26, Las Vegas, NV, 89191	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-111493	ENR	Yuki Y Miller	1954-04-26	—	6075205023	1468 Apache Blvd # 946, Miami, FL, 33139	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-137746	ENR	Adam Estrada	2007-09-23	UHC-32692-40	6159754445	6239 Canyon Rd # 901, Scottsdale, AZ, 85260	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-116860	ENR	Abigail Johnson	1969-11-17	UHC-27991-80	7167919653	1190 Park Pl Apt 18, Minneapolis, MN, 55469	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-137661	ENR	Betty U Mendoza	2008-05-14	UHC-11236-54	8687408613	4088 Grand Ave # 517, Sacramento, CA, 95876	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-102617	ENR	Scott Z Shaw	1943-09-25	UHC-47109-16	5699184977	663 Market St Apt 17, Dallas, TX, 75296	0.64	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-112054	ENR	Nicole Wells	2008-03-11	UHC-66998-22	3504818198	3543 Central Ave Apt 19, Atlanta, GA	0.64	Date of birth reformatted Phone reformatted Unit split from street City re-cased+2 more
ENR-103207	ENR	Natalie Z Romero	1970-11-09	UHC-05876-88	2439531214	1511 Baseline Rd # 535, Glendale, AZ, 85339	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-135252	ENR	Andrea Mendosa	1939-05-07	UHC-86485-66	4854877644	3886 Sunset Blvd Apt 23, Scottsdale, AZ, 85234	0.64	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-104191	ENR	Philip Gray	1948-10-06	UHC-41519-25	8574170224	9035 Willow Ct # 251, Seattle, WA, 98164	0.64	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+2 more
ENR-135974	ENR	Kathryn M Hart	1947-01-10	UHC-34576-96	4636167714	1306 Pine Dr Apt 24, Atlanta, GA	0.64	Date of birth reformatted Phone reformatted Member ID reformatted Unit split from street+2 more
ENR-138687	ENR	Gloria Lopez	1942-12-10	UHC-27080-04	6634113864	1893 Central Ave Apt 9, Tempe, AZ, 85223	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-109305	ENR	Sandra D Guzman	2007-11-26	UHC-35500-64	3963470860	7954 Desert Sky Blvd Apt 10, Houston, TX, 77083	0.64	Name re-cased Phone reformatted Unit split from street ZIP+4 trimmed+2 more
ENR-123010	ENR	Brittany M Kennedy	1981-03-19	UHC-32345-17	6388178975	7007 River Rd Apt 39, Nashville, TN, 37259	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-129259	ENR	Hiroshi W Morgan	1994-04-16	UHC-20795-47	9135564881	1282 Sunset Blvd # 577, Atlanta, GA, 30361	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-106222	ENR	Daniel O Fernandez	1960-11-15	UHC-20537-71	8793437255	9880 Forest Ave Apt 17, Charlotte, NC, 28257	0.64	Name re-cased Phone reformatted Unit split from street ZIP+4 trimmed+2 more
ENR-137095	ENR	Chhristian Z Carroll	1979-11-01	UHC-52814-08	4364853360	6134 Oak St # 279, Nashville, TN, 37283	0.64	Date of birth reformatted Phone reformatted Unit split from street ZIP+4 trimmed+2 more
ENR-137094	ENR	Chhristian Z Carroll	1979-11-01	UHC-52814-08	4364853360	6134 Oak St # 279, Nashville, TN, 37283	0.64	Date of birth reformatted Phone reformatted Unit split from street ZIP+4 trimmed+2 more
ENR-121613	ENR	Mary Alvarado	1938-10-26	UHC-45054-41	2634016797	7921 Mesa Dr Apt 23, Columbus, OH, 43220	0.64	Name re-cased Phone reformatted Member ID reformatted Unit split from street+2 more
ENR-141284	ENR	Denise D Pena	2001-09-06	UHC-12515-52	6838444648	5007 Pine Dr # 754, Miami, FL, 33107	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-142183	ENR	Peggy A Sullivan	2005-04-17	UHC-11975-47	2349254587	6599 Valley View Dr Apt 6, Chandler, AZ, 85267	0.64	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-133495	ENR	Barbara T Johnston	1990-12-20	UHC-77608-21	2573931456	6135 Ridge Rd # 254, Glendale, AZ, 85389	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-109257	ENR	Christian Burke	1965-03-07	UHC-53263-58	7704580115	1128 Canyon Rd # 361, Tampa, FL, 33655	0.64	Two-digit birth year Phone reformatted Unit split from street Email lower-cased+2 more
ENR-121548	ENR	John L Anderson	1967-04-13	UHC-74807-02	5188578800	9872 Ocean Ave # 161, Phoenix, AZ, 85087	0.64	Date of birth reformatted Phone reformatted Unit split from street Gender normalised+2 more
ENR-119667	ENR	Randy F Singh	1989-05-12	UHC-68184-37	9439908407	9754 Central Ave # 436, Phoenix, AZ, 85000	0.64	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+2 more
ENR-103185	ENR	Sara T Wber	2000-05-06	UHC-98824-97	7399993431	6301 Central Ave # 181, San Diego, CA, 92184	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-133208	ENR	Victoria G Wallace	1984-12-10	UHC-87769-83	6806108558	2975 Cedar Ln Apt 26, Denver, CO, 80204	0.64	Unit split from street Street suffix standardised Address re-cased City re-cased+2 more
ENR-118487	ENR	Lawrence Schmidt	1990-05-09	UHC-90678-16	7047864533	7922 Oak St # 485, Seattle, WA, 98106	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-105250	ENR	Sandra G Scott	1962-04-20	UHC-95286-62	4676828569	3181 Lake View Rd # 968, Tempe, AZ, 85294	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-112093	ENR	Ronald D Armstrong	1966-05-10	UHC-28796-71	8932135891	9818 Washington St Apt 12, Columbus, OH, 43262	0.64	Name re-cased Member ID reformatted Unit split from street Street suffix standardised+2 more
ENR-142766	ENR	Melissa R Allen	1954-02-25	UHC-41301-70	8376521130	9662 Main St Apt 12, Chandler, AZ, 85284	0.64	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-102491	ENR	Arthur Z Ford	1951-11-04	UHC-94934-50	7696039290	784 Meadow Ln Apt 18, Tucson, AZ, 85780	0.64	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+2 more
ENR-124101	ENR	Pamela Bryant	1960-03-17	UHC-85849-44	6159289513	609 Lake View Rd # 154, Los Angeles, CA, 90019	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-138453	ENR	Katheine Powell	1977-11-09	UHC-75290-93	9776280274	187 Washington St # 962, Los Angeles, CA, 90069	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-137314	ENR	Virginia Maldonado	1970-11-25	UHC-65188-99	6377741635	2323 Lincoln Way # 370, Eden Prairie, MN, 55388	0.64	Name re-cased Phone reformatted Unit split from street Email lower-cased+2 more
ENR-134272	ENR	Albert V Dominguez	1961-08-27	UHC-16125-24	3893227612	3883 Canyon Rd # 141, Sacramento, CA, 95819	0.64	Phone reformatted Member ID reformatted Unit split from street City re-cased+2 more
ENR-127673	ENR	Brittany Rose	1989-10-15	UHC-94836-79	5692397338	4135 Hillcrest Rd # 507, Eden Prairie, MN, 55392	0.64	Name re-cased Date of birth reformatted Member ID reformatted Unit split from street+2 more
ENR-142158	ENR	Andrew P Jacobs	1990-12-11	UHC-94590-96	—	5166 Highland Ave Apt 24, Austin, TX, 78720	0.64	Unit split from street Street suffix standardised Address re-cased City re-cased+2 more
ENR-122372	ENR	Daniel X Jimenez	1959-01-18	UHC-38087-84	2503385724	5471 Sage Ct # 324, Eden Prairie, MN, 55340	0.64	Name split from “Last, First”Phone reformatted Unit split from street City re-cased+2 more
ENR-102578	ENR	Julia D Banks	1999-05-12	UHC-28147-69	—	2452 Canyon Rd # 356, Fresno, CA, 93763	0.64	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
ENR-131752	ENR	Julia H Ryan	1955-06-12	UHC-35022-68	7693142904	5279 Canyon Rd Apt 19, Mesa, AZ, 85202	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more

3,345 rows, page 41 of 67Previous Next