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 “Name split from “Last, First””, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagName split from “Last, First”Clear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-133595	ENR	Bryan I Ray	1958-11-20	UHC-15231-85	8976852507	9671 Indian School Rd, Tucson, AZ, 85765	0.82	Name split from “Last, First”Date of birth reformatted Phone reformatted
ENR-108363	ENR	Omar Collins	2001-09-13	UHC-17620-38	2292227324	9690 Hillcrest Rd, Atlanta, GA, 30341	0.82	Name split from “Last, First”Member ID reformatted Email lower-cased
ENR-126188	ENR	Jessiac B Reid	1980-05-01	UHC-65268-22	9197703926	5218 Washington St, Seattle, WA, 98167	0.82	Name split from “Last, First”Phone reformatted Whitespace trimmed
ENR-129510	ENR	Camila Dominguez	1960-10-25	UHC-58481-29	3329738707	9100 Grand Ave, Houston, TX, 77079	0.82	Name split from “Last, First”Date of birth reformatted Whitespace trimmed
ENR-127737	ENR	Stephen Vega	1962-12-18	UHC-77318-20	4164206004	4621 Park Pl, Dallas, TX, 75293	0.82	Name split from “Last, First”Date of birth reformatted Whitespace trimmed
ENR-121619	ENR	Henry W Le	2005-03-22	UHC-67222-58	2296078696	2816 Lincoln Way, Minneapolis, MN, 55471	0.82	Name split from “Last, First”Phone reformatted Placeholder values cleared
ENR-104902	ENR	Robert P Rihardson	1979-01-15	UHC-08428-93	6862379601	2701 Meadow Ln, Los Angeles, CA, 90048	0.82	Name split from “Last, First”Phone reformatted Placeholder values cleared
ENR-120711	ENR	Madison K Castro	1952-02-01	UHC-96414-21	2234675536	8120 Main St, Jacksonville, FL, 32223	0.82	Name split from “Last, First”Phone reformatted Placeholder values cleared
ENR-119284	ENR	Justin Robinson	1958-03-27	UHC-19573-04	3958550310	6820 Broadway, Tempe, AZ, 85213	0.82	Name split from “Last, First”Date of birth reformatted Phone reformatted
ENR-142418	ENR	Yuki Jacobs	1940-04-28	UHC-65496-76	6542597164	4067 Meadow Ln, Dallas, TX, 75282	0.82	Name split from “Last, First”Phone reformatted Whitespace trimmed
ENR-132613	ENR	Kelly Hicks	1952-05-07	UHC-88193-38	7312444539	3726 Baseline Rd, Gilbert, AZ, 85225	0.82	Name split from “Last, First”Phone reformatted Whitespace trimmed
ENR-104170	ENR	Carl Chavez	1973-09-25	UHC-14542-94	8836732841	9462 Sunset Blvd, Gilbert, AZ, 85253	0.82	Name split from “Last, First”Email lower-cased Whitespace trimmed
ENR-130616	ENR	Hannah O Brown	1943-07-08	UHC-97609-23	2948110191	8925 Church St, Nashville, TN, 37299	0.82	Name split from “Last, First”Phone reformatted Whitespace trimmed
ENR-100581	ENR	Dennis Warren	2007-05-11	UHC-29646-24	7352396322	4604 Washington St, Eden Prairie, MN, 55305	0.82	Name split from “Last, First”Phone reformatted Whitespace trimmed
ENR-122719	ENR	Joyce Santtiago	2000-08-25	UHC-78000-99	2348295751	832 Highland Ave, Los Angeles, CA, 90008	0.82	Name split from “Last, First”Date of birth reformatted Whitespace trimmed
ENR-109523	ENR	Theresa P Stevens	1954-10-25	UHC-14306-89	2544469666	9388 Church St, Eden Prairie, MN, 55377	0.82	Name split from “Last, First”Email lower-cased Whitespace trimmed
ENR-142505	ENR	Cheryl A Scott	1951-12-10	UHC-54074-36	4853403148	9579 Jefferson Ave, Atlanta, GA, 30331	0.82	Name split from “Last, First”Date of birth reformatted Phone reformatted
ENR-116694	ENR	Lisa V Roberts	1956-08-22	UHC-99682-09	3233552077	3778 Cedar Ln, Minneapolis, MN, 55433	0.82	Name split from “Last, First”Phone reformatted Placeholder values cleared
ENR-133878	ENR	Linda I Stewart	1976-03-11	UHC-40910-55	2859938775	3321 Valley View Dr, Minneapolis, MN, 55411	0.82	Name split from “Last, First”Phone reformatted Whitespace trimmed
ENR-142836	ENR	Martha Q Salazar	1964-01-07	UHC-02417-94	7228801439	3257 Broadway, Tempe, AZ, 85257	0.82	Name split from “Last, First”Whitespace trimmed Placeholder values cleared
ENR-130058	ENR	Arjun Hansen	2008-12-22	UHC-24319-70	8946064469	8163 Apache Blvd, Phoenix, AZ, 85006	0.82	Name split from “Last, First”Phone reformatted City re-cased
ENR-100616	ENR	Mei Q Bennett	1978-06-19	UHC-99084-44	2346979705	3424 Mountain View Dr, Las Vegas, NV, 89132	0.82	Name split from “Last, First”Phone reformatted Whitespace trimmed
ENR-116496	ENR	Gabriel J Setwart	2001-05-26	UHC-98340-36	9252878598	6498 Palm Dr, Denver, CO, 80274	0.82	Name split from “Last, First”Phone reformatted Whitespace trimmed
ENR-131511	ENR	Doris Y Thomas	1984-12-15	UHC-73006-67	—	1951 Union St, San Diego, CA, 92188	0.82	Name split from “Last, First”Date of birth reformatted Placeholder values cleared
ENR-141813	ENR	Natalie K Daniels	1951-11-18	UHC-67354-43	6543049510	1690 Pine Dr, Eden Prairie, MN, 55375	0.82	Name split from “Last, First”Phone reformatted Member ID reformatted
ENR-106358	ENR	Heather S Myers	1958-01-04	UHC-23811-98	4379955558	—	0.82	Name split from “Last, First”Whitespace trimmed Placeholder values cleared
ENR-131075	ENR	Bradley N Hughes	1996-05-25	UHC-90029-18	6623825604	6130 Lincoln Way, San Antonio, TX, 78234	0.82	Name split from “Last, First”Date of birth reformatted Whitespace trimmed
ENR-104255	ENR	Sean Stone	1999-07-28	UHC-06362-01	2987545594	9859 Palm Dr, Fresno, CA, 93792	0.82	Name split from “Last, First”Phone reformatted Whitespace trimmed
ENR-137870	ENR	Diane J George	1994-09-26	UHC-41609-92	4503834466	6546 Spring St, Houston, TX, 77077	0.82	Name split from “Last, First”Phone reformatted City re-cased
ENR-130590	ENR	Grace A Palmer	1973-05-10	UHC-09736-93	7643312034	8603 Church St, Mesa, AZ, 85290	0.82	Name split from “Last, First”Phone reformatted Whitespace trimmed
ENR-133760	ENR	Samuel R Warren	1965-09-26	UHC-54831-03	9117608602	6255 Ridge Rd, Scottsdale, AZ, 85220	0.82	Name split from “Last, First”Date of birth reformatted Whitespace trimmed
ENR-115788	ENR	Eugene T Ryan	1938-10-12	UHC-31719-62	6568533992	8037 Valley View Dr, San Diego, CA, 92133	0.82	Name split from “Last, First”Phone reformatted Email lower-cased
ENR-129659	ENR	Juan Banks	1967-11-12	UHC-97584-08	4882326431	9425 Mesa Dr, Fresno, CA, 93762	0.82	Name split from “Last, First”Phone reformatted Whitespace trimmed
ENR-127752	ENR	Vincent Collins	1954-10-20	UHC-86875-59	7862419694	2477 Elm St, Glendale, AZ, 85323	0.82	Name split from “Last, First”City re-cased Email lower-cased
ENR-141735	ENR	Christine B Cooper	1963-04-27	UHC-90180-01	8366767236	4649 Camelback Rd, Tampa, FL, 33646	0.82	Name split from “Last, First”Date of birth reformatted Phone reformatted
ENR-131971	ENR	Walter Estrada	1962-09-16	UHC-05781-54	4915212092	1013 Lincoln Way, Chandler, AZ, 85277	0.82	Name split from “Last, First”Phone reformatted Whitespace trimmed
ENR-119252	ENR	Gabriel Tran	1990-06-12	UHC-30468-31	9403547946	3390 Meadow Ln, Houston, TX, 77026	0.82	Name split from “Last, First”Phone reformatted Email lower-cased
ENR-131480	ENR	Lucia E Padilla	1998-10-19	UHC-90643-40	7774201493	1051 Maple Ave, Columbus, OH, 43298	0.82	Name split from “Last, First”Phone reformatted Placeholder values cleared
ENR-136130	ENR	Kim Wood	1984-10-03	UHC-47559-10	3287675498	6099 Cedar Ln, Tucson, AZ, 85708	0.82	Name split from “Last, First”Date of birth reformatted State code upper-cased
ENR-102727	ENR	Justin U Carr	1939-05-17	UHC-98318-07	7478188871	2297 Church St, Houston, TX, 77093	0.82	Name split from “Last, First”Whitespace trimmed Placeholder values cleared
ENR-101909	ENR	Jerry Pierce	2005-02-27	UHC-01827-46	2753735096	—	0.82	Name split from “Last, First”Phone reformatted Placeholder values cleared
ENR-138683	ENR	Denise F Obrien	1947-05-13	UHC-16406-79	5878516671	9137 Indian School Rd, Nashville, TN, 37280	0.82	Name split from “Last, First”Name re-cased Email lower-cased
ENR-138682	ENR	Denise F Obrien	1947-05-13	UHC-16406-79	5878516671	9137 Indian School Rd, Nashville, TN, 37280	0.82	Name split from “Last, First”Name re-cased Email lower-cased
ENR-137616	ENR	Douglas Patterson	2000-08-26	UHC-20741-40	2382075071	4786 Sage Ct, Los Angeles, CA, 90052	0.82	Name split from “Last, First”Phone reformatted Placeholder values cleared
ENR-134294	ENR	Kenneth R Garza	1982-07-11	UHC-59034-04	7796882350	9788 Spring St, Orlando, FL, 32821	0.82	Name split from “Last, First”City re-cased Whitespace trimmed
ENR-125871	ENR	Stephanie V Ross	1990-12-11	UHC-04168-70	3362998489	1376 Ridge Rd, Jacksonville, FL, 32239	0.82	Name split from “Last, First”Member ID reformatted Whitespace trimmed
ENR-133794	ENR	Denise Perry	1957-06-25	UHC-72358-97	9299768570	7200 Forest Ave, Orlando, FL, 32862	0.82	Name split from “Last, First”Whitespace trimmed Placeholder values cleared
ENR-114886	ENR	James Wood	1986-08-04	UHC-66277-67	2803038224	6080 Broadway, Austin, TX, 78713	0.82	Name split from “Last, First”Whitespace trimmed Placeholder values cleared
ENR-136384	ENR	Jduith Brown	1949-05-01	UHC-78195-69	—	4374 Pine Dr, Fresno, CA, 93704	0.82	Name split from “Last, First”Whitespace trimmed Placeholder values cleared
ENR-130466	ENR	Mary Schulttz	1960-04-26	UHC-67375-85	6972365550	—	0.82	Name split from “Last, First”Email lower-cased Whitespace trimmed

4,309 rows, page 83 of 87Previous Next