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 re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagName re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-109180	ENR	Helen Jacobs	1969-05-28	UHC-51998-52	5237834036	3461 Grand Ave, Austin, TX, 78792	0.64	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-143007	ENR	Denie Miller	—	UHC-85977-64	7893864561	4710 Oak St, Nashville, TN, 37241	0.64	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+2 more
ENR-112289	ENR	Arthur Ryan	1946-06-09	UHC-65502-89	—	8034 Spring St Apt 40, Plano, TX, 75097	0.64	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
ENR-140919	ENR	Shirley Lee	1955-01-13	UHC-46809-42	—	429 Camelback Rd, Chandler, AZ, 85230	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-108077	ENR	Justin Parker	1994-05-17	UHC-60302-08	6417797965	2669 Highland Ave, Glendale, AZ, 85327	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-128482	ENR	Jean Ramirez	2005-03-05	UHC-02634-12	5376725919	6452 Pine Dr, Houston, TX, 77072	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
ENR-117377	ENR	Gary Willis	1986-10-12	UHC-53072-60	9279383372	48 Pine Dr, Tampa, FL, 33663	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-125847	ENR	Timothy Pery	2008-05-20	UHC-32260-32	—	7814 Highland Ave, Miami, FL	0.64	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
ENR-141392	ENR	Lisa Castro	1991-01-19	UHC-96067-72	7119064904	11 Elm St, Sacramento, CA	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-139860	ENR	Burns Arthur	1985-09-27	UHC-86304-70	6458777364	3021 Main St, Tucson, AZ, 85714	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-119423	ENR	Carlos U Ramos	—	UHC-80608-77	6347624987	2238 Indian School Rd, Tempe, AZ, 85255	0.64	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+2 more
ENR-105486	ENR	Evelyn Owens	1998-10-28	UHC-89236-21	4152009356	5691 Apache Blvd, Tempe, AZ, 85216	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-100475	ENR	Rachel E Knight	1954-09-26	UHC-26205-18	9432327255	2999 Canyon Rd, Minneapolis, MN, 55423	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-123414	ENR	Debra V Oliver	2005-11-05	UHC-96451-85	7474998161	676 Washington St, Columbus, OH, 43236	0.64	Name re-cased Two-digit birth year Phone reformatted State name converted to code+2 more
ENR-134269	ENR	Ashley Daniels	1960-02-25	UHC-77365-77	2274140055	9072 Bayshore Dr, Atlanta, GA, 30364	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
ENR-121798	ENR	Robert E Ramirez	1995-04-20	UHC-10947-38	8244246056	7520 Meadow Ln, Nashville, TN, 37292	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
ENR-142752	ENR	Nicholas Q Fisher	1996-04-28	UHC-15949-50	—	7457 Meadow Ln, Sacramento, CA, 95802	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-142753	ENR	Nicholas Q Fisher	1996-04-28	UHC-15949-50	—	7457 Meadow Ln, Sacramento, CA, 95802	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-123108	ENR	Kelly Edwards	2004-12-24	UHC-92632-23	9095066660	150 Lincoln Way, Eden Prairie, MN	0.64	Name re-cased Phone reformatted Member ID reformatted State name converted to code+2 more
ENR-125378	ENR	Jose Flores	1941-03-05	UHC-21719-50	4846711010	7684 Ridge Rd Apt 17, Dallas, TX, 75273	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-134356	ENR	Matthew Snyder	1965-02-08	UHC-80600-14	4953355630	4075 Hillcrest Rd, Seattle, WA, 98197	0.64	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+2 more
ENR-110153	ENR	Luis X Oliver	1999-04-15	UHC-83023-09	6433737907	6924 Oak St, Tucson, AZ, 85772	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-103519	ENR	Benjamin T Webb	2003-01-07	UHC-05050-82	8286860774	6081 Camelback Rd, Jacksonville, FL, 32277	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-135847	ENR	Ruth Garrett	2003-10-09	UHC-34655-43	9529143682	3904 Baseline Rd, Orlando, FL, 32882	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-108027	ENR	Gregory X Hanson	1957-04-03	UHC-91278-40	4199122202	5058 Mesa Dr, Mesa, AZ, 85249	0.64	Middle initial moved out of first name Name re-cased Phone reformatted Street suffix standardised+2 more
ENR-123196	ENR	Garrett X Jason	1978-04-08	UHC-04664-80	6574036234	7286 Baseline Rd, Phoenix, AZ, 85081	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-119707	ENR	Diego M Fox	2002-12-07	UHC-18151-08	6462926769	9433 Elm St # 608, Plano, TX	0.64	Name re-cased Phone reformatted Member ID reformatted Unit split from street+2 more
ENR-124679	ENR	Robert B Washington	1969-04-03	UHC-52616-95	9322149169	5496 Spring St, Atlanta, GA, 30365	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-133054	ENR	Donna Scott	1986-12-11	UHC-62612-35	—	1923 Ocean Ave, Nashville, TN, 37221	0.64	Name re-cased Date of birth reformatted ZIP+4 trimmed Gender normalised+2 more
ENR-116362	ENR	Carl Elliott	1956-07-18	UHC-86856-88	6795155685	7197 Market St, Jacksonville, FL, 32296	0.64	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-141138	ENR	James Lopez	—	UHC-89242-84	2859791022	8157 Spring St, Atlanta, GA, 30372	0.64	Name re-cased Date of birth unreadable Phone reformatted Member ID reformatted+2 more
ENR-131297	ENR	Karen Z Fields	2003-11-24	UHC-86759-11	9598548617	3684 Camelback Rd Apt 16, Chandler, AZ, 85260	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-100080	ENR	Andrea V Murphy	1945-01-09	UHC-07528-87	—	4717 Grand Ave, Austin, TX, 78760	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-119614	ENR	Dennis Hamilton	1938-08-11	UHC-89766-39	—	3844 Forest Ave, Los Angeles, CA, 90079	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-125213	ENR	Sara Austin	1988-09-26	—	4124953250	1712 Bayshore Dr, Dallas, TX, 75283	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-140657	ENR	Sean Brown	—	UHC-14347-49	3644051614	9064 Jefferson Ave, Fresno, CA, 93735	0.64	Name re-cased Date of birth unreadable Phone reformatted Email lower-cased+2 more
ENR-140768	ENR	Madison Ortega	2005-08-14	UHC-04560-91	6087088136	689 Lincoln Way, San Antonio, TX, 78232	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-125591	ENR	Dylan W Morgan	1981-01-19	UHC-86195-65	3859932206	790 Broadway, Seattle, WA, 98119	0.64	Name re-cased Date of birth reformatted Phone reformatted State name converted to code+2 more
ENR-111968	ENR	Danielle Ward	2003-09-25	UHC-81974-47	8778395229	8315 Central Ave, Scottsdale, AZ, 85262	0.64	Name re-cased Phone reformatted SSN last four extracted City re-cased+2 more
ENR-123584	ENR	Kevin F Medina	1956-06-26	UHC-95181-03	4146825677	9682 Bayshore Dr, Las Vegas, NV, 89131	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-131568	ENR	Fatima E Fisher	1971-07-19	UHC-13643-76	—	6660 Spring St, Tucson, AZ, 85733	0.64	Middle initial moved out of first name Name re-cased Date of birth reformatted Street suffix standardised+2 more
ENR-126099	ENR	Arhur Munoz	1956-01-04	UHC-55142-03	5238035252	4160 Sage Ct, Tampa, FL, 33691	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-115063	ENR	Padilla Q Carol	1956-09-09	UHC-29340-50	4758588554	7172 Washington St, Plano, TX, 75014	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-132409	ENR	Justin HJunk	1988-03-01	UHC-82612-26	3783913676	2293 Union St, Denver, CO, 80284	0.64	Name re-cased Street suffix standardised Address re-cased Plan code upper-cased+2 more
ENR-100875	ENR	Douglas L Russell	—	UHC-97092-57	9354339844	2814 Washington St, Denver, CO, 80237	0.64	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+2 more
ENR-121312	ENR	Carlos S Ryan	1989-06-02	UHC-94370-95	2713289946	814 Meadow Ln Apt 30, Mesa, AZ, 85290	0.64	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-127421	ENR	Olivia Rojas	1938-02-03	UHC-14325-16	7802156731	8531 Ocean Ave, Las Vegas, NV, 89191	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-117716	ENR	Tyyler E Allen	1971-09-22	UHC-93667-86	6758426337	6556 Apache Blvd, Plano, TX, 75082	0.64	Middle initial moved out of first name Name re-cased Date of birth reformatted Street suffix standardised+2 more
ENR-133293	ENR	Bobby I Martin	1957-07-06	UHC-94655-70	8695876767	2580 Apache Blvd, Chandler, AZ, 85263	0.64	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-115592	ENR	Vincent Jones	1975-09-01	UHC-15101-05	—	3540 Jefferson Ave Apt 25, Nashville, TN, 37295	0.64	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more

17,310 rows, page 109 of 347Previous Next