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 “Placeholder values cleared”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagPlaceholder values clearedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-133817	ENR	Albert Fisher	1981-06-04	—	3059760699	9784 Harbor Blvd # 537, Gilbert, AZ, 85212	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-123541	ENR	Thomas Hamilton	1948-05-17	UHC-56407-31	8888782186	3220 Bayshore Dr, Eden Prairie, MN, 55323	0.64	Phone reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
ENR-123338	ENR	Diane Meyer	1984-01-08	UHC-37316-71	8974579450	6924 Apache Blvd, Las Vegas, NV, 89182	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-134246	ENR	PJunk	1951-01-25	UHC-89486-51	6054189476	695 Oak St, Scottsdale, AZ, 85291	0.64	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed+2 more
ENR-133898	ENR	Christopher C Thomas	2003-09-08	UHC-20607-60	3424954941	2590 Ocean Ave, Chandler, AZ, 85296	0.64	Name split from “Last, First”Date of birth reformatted Member ID reformatted State name converted to code+2 more
ENR-101013	ENR	Priya Collins	—	UHC-14575-37	2173713753	2440 Sage Ct, Houston, TX, 77014	0.64	Name re-cased Date of birth unreadable Phone reformatted State name converted to code+2 more
ENR-108457	ENR	Samantha Hicks	1955-07-24	UHC-27558-25	—	3610 Valley View Dr, Eden Prairie, MN, 55346	0.64	Name split from “Last, First”Member ID reformatted City re-cased ZIP+4 trimmed+2 more
ENR-116402	ENR	Samuel V Wong	1946-11-23	UHC-13804-81	5925918015	3726 Hillcrest Rd, Fresno, CA, 93740	0.64	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-108119	ENR	Betty Rmirez	1972-05-04	UHC-87818-53	8738369970	4761 Desert Sky Blvd, Gilbert, AZ, 85204	0.64	Name split from “Last, First”Street suffix standardised Address re-cased Email lower-cased+2 more
ENR-129212	ENR	Martha Z Parker	1991-09-26	UHC-73620-42	—	236 Market St, Glendale, AZ, 85347	0.64	Street suffix standardised Address re-cased City re-cased Gender normalised+2 more
ENR-135811	ENR	Lisa Obrien	2004-01-24	UHC-77989-41	—	3140 Lake View Rd, Tucson, AZ	0.64	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
ENR-122748	ENR	Patrcik Ellis	1975-04-06	UHC-52459-13	7134396493	1833 Ridge Rd, Eden Prairie, MN, 55326	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-116027	ENR	Nancy Burton	1983-05-02	UHC-12094-80	7357737778	3984 Lake View Rd, Scottsdale, AZ, 85221	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-106151	ENR	Natalie L Adams	1980-11-12	UHC-15911-63	3315723361	6511 Pine Dr, San Diego, CA, 92159	0.64	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-139458	ENR	Eugene Stewart	1971-08-05	UHC-98811-01	8689815464	9429 Mountain View Dr, San Antonio, TX, 78244	0.64	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-119157	ENR	Grace R Stone	1991-10-07	UHC-67144-84	—	8990 Elm St, San Antonio, TX	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-141916	ENR	Ruth V Foler	1993-07-10	UHC-12243-12	4293891465	6716 Sage Ct, Columbus, OH, 43267	0.64	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-107455	ENR	Barbara U Hanson	1969-12-18	UHC-36092-77	—	4769 Spring St, Austin, TX, 78752	0.64	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-118112	ENR	Mei U Lee	1978-11-25	UHC-02340-97	7928350936	4010 Central Ave, Denver, CO	0.64	Street suffix standardised Address re-cased ZIP missing Email lower-cased+2 more
ENR-110735	ENR	Sofia I Porter	2002-07-04	UHC-53417-68	2304349910	1396 Apache Blvd, Austin, TX, 78708	0.64	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-132776	ENR	Joan Fowler	1983-10-14	UHC-85183-78	7126109526	7025 Sage Ct, Fresno, CA, 93722	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-108862	ENR	Robert H Murphy	1999-04-24	UHC-28931-58	4718085102	7979 Apache Blvd, Charlotte, NC	0.64	Member ID reformatted Street suffix standardised Address re-cased ZIP missing+2 more
ENR-100767	ENR	Janice P Kelley	1961-05-25	UHC-15572-90	4836541592	5743 Pine Dr, Los Angeles, CA, 90036	0.64	Phone reformatted Street suffix standardised Address re-cased Gender normalised+2 more
ENR-111620	ENR	Elijah Peters	1908-03-01	UHC-48945-36	2229525268	5869 Harbor Blvd # 714, Tampa, FL, 33696	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-114409	ENR	Patrick P Henderson	1943-04-08	UHC-99656-49	—	7023 Lake View Rd, Tampa, FL, 33661	0.64	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-141181	ENR	Kimberly Delgado	1961-12-14	UHC-27985-96	5075514343	5493 River Rd, Dallas, TX	0.64	Phone reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
ENR-101180	ENR	Amber C Johnston	1946-08-06	UHC-11140-30	2523126659	1914 Maple Ave, Atlanta, GA, 30303	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-103582	ENR	Charles M Fernandez	1944-01-10	UHC-62270-60	3236828782	8171 Canyon Rd, Tampa, FL, 33653	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-117806	ENR	Gloria N Burke	1981-11-07	UHC-56404-96	3933439367	8287 Valley View Dr, Tucson, AZ	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+2 more
ENR-105836	ENR	Janet Willis	—	UHC-24401-43	—	1913 Mountain View Dr, Orlando, FL, 32874	0.64	Date of birth unreadable Street suffix standardised Address re-cased City re-cased+2 more
ENR-142404	ENR	Amy Bowman	2001-08-19	UHC-43285-35	3054408132	6542 Valley View Dr, Eden Prairie, MN, 55368	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-124948	ENR	Eugene P Fuller	1947-08-22	UHC-17261-98	4076674723	738 Market St, Minneapolis, MN, 55473	0.64	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-129328	ENR	Rios Ralph	1958-09-16	UHC-33129-05	2778450487	9132 Desert Sky Blvd, Gilbert, AZ, 85299	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-142647	ENR	Lucia J Castilol	1989-12-02	UHC-03398-73	9229647888	413 Ocean Ave, Miami, FL	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-109340	ENR	Janice L Harvy	1968-12-21	UHC-19715-72	4693479054	6297 Sage Ct, Dallas, TX, 75297	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-121077	ENR	Aaron B Hoffman	2008-10-12	UHC-55595-67	—	9350 Market St, Tucson, AZ, 85758	0.64	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-131979	ENR	Sarah Oliver	1992-12-26	UHC-68141-22	6979669245	8057 Cedar Ln Apt 10, Columbus, OH, 43217	0.64	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-115761	ENR	Sophia O Dixon	1938-03-10	UHC-10387-52	5022621731	3158 Spring St, Mesa, AZ, 85256	0.64	SSN last four extracted Street suffix standardised Address re-cased Email lower-cased+2 more
ENR-137526	ENR	Ben Hcks	1968-09-17	UHC-96945-10	9892746054	3782 Jefferson Ave, Tucson, AZ, 85701	0.64	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-119954	ENR	Linda C McDonald	1987-03-12	UHC-89393-86	—	3863 Broadway, San Antonio, TX, 78286	0.64	Name re-cased Phone missing area code City re-cased ZIP+4 trimmed+2 more
ENR-117563	ENR	Aaron N Larson	1963-12-24	UHC-22371-27	8713711158	6922 Grand Ave, Glendale, AZ, 85321	0.64	Phone reformatted Street suffix standardised Address re-cased Gender normalised+2 more
ENR-112456	ENR	Laura S Dunn	1976-02-22	UHC-44881-02	6166557095	8838 Park Pl # 999, Mesa, AZ, 85200	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-105775	ENR	Anthony B Kennedy	1982-05-09	UHC-68806-30	6745269662	621 Forest Ave, Fresno, CA, 93749	0.64	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-122447	ENR	Andrea E Beell	1940-01-26	UHC-37247-96	5179991466	9349 Lake View Rd, Gilbert, AZ, 85250	0.64	Name re-cased Phone reformatted City re-cased State name converted to code+2 more
ENR-105406	ENR	Joseph C Boyd	1954-03-20	UHC-23225-22	—	1006 Park Pl, Houston, TX, 77056	0.64	Name re-cased Date of birth reformatted SSN last four extracted Street suffix standardised+2 more
ENR-105405	ENR	Joseph C Boyd	1954-03-20	UHC-23225-22	—	1006 Park Pl, Houston, TX, 77056	0.64	Name re-cased Date of birth reformatted SSN last four extracted Street suffix standardised+2 more
ENR-113529	ENR	Jesse Cox	1947-11-19	UHC-86746-72	9643631563	123 Valley View Dr, Phoenix, AZ, 85009	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-129751	ENR	Charlotte X Matthews	1971-06-22	UHC-36853-49	7967298025	4334 Pine Dr, Atlanta, GA, 30366	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-135292	ENR	Aaron K Vazquez	2004-03-06	UHC-28889-32	6893100538	1357 Maple Ave, Columbus, OH, 43230	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-137371	ENR	Wayne W Sullivan	1986-09-16	UHC-70561-67	7336574046	3620 Sage Ct, Gilbert, AZ, 85289	0.64	Street suffix standardised Address re-cased ZIP+4 trimmed Email lower-cased+2 more

16,916 rows, page 105 of 339Previous Next