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

All ENR CLM TPA PRV

Junk onlyFlagCity re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-107605	ENR	Emma Fernandze	1989-02-15	UHC-03907-18	—	5873 Bayshore Dr, Phoenix, AZ, 85030	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-116539	ENR	Shirley E Sanchez	1948-12-12	UHC-11667-88	2574594279	5839 Apache Blvd, Fresno, CA, 93740	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-120791	ENR	Karen L Hamilton	1974-06-06	UHC-95239-45	5744034837	4324 Maple Ave, Glendale, AZ, 85396	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-121817	ENR	Euugene M Singh	1945-07-21	UHC-27220-84	2883794777	806 Mesa Dr, Nashville, TN, 37275	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-131076	ENR	Donald O Jones	1995-03-24	UHC-48424-87	—	9272 Sage Ct, San Antonio, TX, 78283	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
ENR-112495	ENR	Helen Sandoval	2004-07-09	UHC-92868-84	3598914051	1348 Jefferson Ave, Charlotte, NC	0.78	Name re-cased Phone reformatted City re-cased State code upper-cased+1 more
ENR-139279	ENR	Julia L Boyd	1948-03-02	UHC-64928-95	9887337836	4048 Union St, Dallas, TX, 75264	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-133747	ENR	Alice Bryant	1946-01-19	UHC-87701-23	—	9633 Apache Blvd, Las Vegas, NV, 89174	0.78	Name split from “Last, First”Member ID reformatted City re-cased Whitespace trimmed+1 more
ENR-142232	ENR	Karen Sandoval	1999-01-13	UHC-53330-56	5698005640	2055 Market St, Columbus, OH, 43202	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
ENR-108267	ENR	Kayla L Franklin	1997-12-15	UHC-54119-79	8419148797	2458 Sunset Blvd, Tucson, AZ, 85779	0.78	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-100665	ENR	Karen Freeman	1962-03-05	UHC-66327-96	2663043265	1843 Willow Ct, Sacramento, CA, 95848	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-139460	ENR	Bryan Scott	1997-04-17	UHC-20605-49	4626331275	7741 Cedar Ln, Chandler, AZ, 85202	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-136211	ENR	Sarah G Flores	1964-11-11	UHC-49651-19	6725712423	5323 Elm St, Eden Prairie, MN, 55326	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-130385	ENR	Yuki Mitchell	1949-10-22	UHC-96258-27	7582604838	4916 River Rd, Nashville, TN, 37251	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-112976	ENR	Emma Pena	1947-04-06	UHC-88943-09	4212570652	8350 Oak St, Columbus, OH, 43242	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-142537	ENR	Peter Marshall	1968-10-23	UHC-35606-34	3417412237	6560 Camelback Rd, Tampa, FL, 33646	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
ENR-106841	ENR	Carol Davis	1951-10-03	UHC-80110-73	9155348032	8959 Cedar Ln, Nashville, TN, 37233	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-106308	ENR	Wayne N Li	1992-06-22	UHC-86865-49	5826435374	5284 Apache Blvd, Glendale, AZ, 85353	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-127619	ENR	Lori Ruiz	2004-02-12	UHC-96459-94	8166844985	5235 Forest Ave, Miami, FL, 33117	0.78	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-135322	ENR	Michael Olson	1938-05-19	UHC-99283-82	8234826775	995 Camelback Rd, Tucson, AZ, 85794	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-135321	ENR	Michael Olson	1938-05-19	UHC-99283-82	8234826775	995 Camelback Rd, Tucson, AZ, 85794	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-110068	ENR	Michelle X Kelley	1996-03-02	UHC-11382-60	6954920437	2898 Baseline Rd, San Antonio, TX, 78244	0.78	Name re-cased Phone reformatted City re-cased ZIP+4 trimmed+1 more
ENR-128113	ENR	Roger Sullivan	1941-01-21	UHC-76081-48	3587989838	9235 Hillcrest Rd, Glendale, AZ, 85385	0.78	Name re-cased Two-digit birth year Phone reformatted City re-cased+1 more
ENR-141009	ENR	Niocle B Morales	2002-02-15	UHC-15042-40	5277563759	9553 Broadway, Fresno, CA, 93763	0.78	Date of birth reformatted Phone reformatted City re-cased State name converted to code+1 more
ENR-106145	ENR	Margaret Smith	1976-01-15	UHC-25071-63	3342591824	1446 Ridge Rd, Chandler, AZ, 85248	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
ENR-138420	ENR	Larson Z Lori	1949-02-19	UHC-47017-38	8457174188	195 Cedar Ln # 842, Gilbert, AZ, 85274	0.78	Name re-cased Phone reformatted Unit split from street City re-cased+1 more
ENR-133890	ENR	Stephanie P Vasquez	1949-05-18	UHC-25440-72	—	6735 Central Ave, Seattle, WA, 98131	0.78	Name re-cased Date of birth reformatted City re-cased Email lower-cased+1 more
ENR-115443	ENR	Laura J Jensne	2003-06-19	UHC-27362-06	7623889708	6137 Indian School Rd, Sacramento, CA, 95876	0.78	Phone reformatted City re-cased Email lower-cased Gender normalised+1 more
ENR-105068	ENR	Jonathan H Castillo	1988-02-03	UHC-91832-33	9455909882	7014 Willow Ct, San Diego, CA, 92161	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-114086	ENR	Virginia P Harris	1946-05-03	UHC-29216-24	5835318645	1383 Apache Blvd, Eden Prairie, MN, 55324	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-111357	ENR	Daniel A Alvarado	1966-11-03	UHC-97254-55	9399303761	4108 Hillcrest Rd, Nashville, TN, 37234	0.78	Name split from “Last, First”Date of birth reformatted Phone reformatted City re-cased+1 more
ENR-121082	ENR	BrianJunk	1978-07-12	UHC-08980-11	2268288279	7222 Spring St, Columbus, OH, 43233	0.78	Name re-cased Phone reformatted City re-cased Plan code upper-cased+1 more
ENR-125850	ENR	Maria Y Woods	2000-05-04	UHC-74123-21	3539181128	8856 Central Ave, Fresno, CA, 93747	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
ENR-110238	ENR	Carol C Garrett	1971-02-27	UHC-98913-03	4409755259	5161 Valley View Dr, Fresno, CA, 93785	0.78	Two-digit birth year Phone reformatted City re-cased Whitespace trimmed+1 more
ENR-112330	ENR	Douglas G Cooper	1977-09-17	UHC-28409-19	8447769461	7523 Oak St, Nashville, TN, 37206	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-110819	ENR	Brenda Murphy	1945-08-12	UHC-42123-95	3853061442	8362 River Rd, Fresno, CA, 93776	0.78	Name re-cased Two-digit birth year Phone reformatted City re-cased+1 more
ENR-138831	ENR	Eugene O Riley	1974-08-10	UHC-89913-50	6343960999	8621 Baseline Rd, Dallas, TX, 75259	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-113769	ENR	Angela A Kelley	1943-06-07	UHC-14545-01	8595078274	7785 Apache Blvd, Houston, TX, 77092	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-102750	ENR	Justin Vazquez	1965-05-05	UHC-39870-95	9224894138	742 River Rd, Nashville, TN, 37228	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-133796	ENR	Evelyn A Myers	1999-12-15	UHC-26261-29	5382073515	1062 Washington St, Fresno, CA, 93705	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-100862	ENR	Sofia T Wood	1948-02-07	UHC-13185-65	—	5469 Sage Ct, Chandler, AZ, 85242	0.78	Street suffix standardised Address re-cased City re-cased Plan code upper-cased+1 more
ENR-120131	ENR	Kimberly E Marquez	1942-05-15	UHC-94929-40	9042302544	1432 Valley View Dr, Las Vegas, NV, 89170	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
ENR-118683	ENR	Danielle J Medina	1981-09-18	UHC-43796-14	5922304421	5700 Jefferson Ave, Houston, TX, 77031	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-122627	ENR	Albert U Schultz	1939-12-06	—	9186930633	8850 Hillcrest Rd, Columbus, OH, 43219	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
ENR-111962	ENR	Ralph F Simpson	1938-03-20	UHC-13940-20	7717103832	4591 Park Pl, Phoenix, AZ, 85087	0.78	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed+1 more
ENR-108999	ENR	Donald G Hnry	1949-09-05	UHC-70069-58	8372262225	446 Ridge Rd, Tampa, FL, 33695	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-123152	ENR	Cynthia W Holmes	1948-01-19	UHC-39175-85	2474617215	7520 Lincoln Way Apt 17, Chandler, AZ, 85228	0.78	Date of birth reformatted Phone reformatted Unit split from street City re-cased+1 more
ENR-111188	ENR	Mei I Jackson	2020-05-19	UHC-85457-92	4315822065	3669 Market St, Mesa, AZ, 85225	0.78	Phone reformatted City re-cased State name converted to code Whitespace trimmed+1 more
ENR-118820	ENR	Christopher A Boyd	1972-04-20	UHC-26068-26	4836584612	5629 Indian School Rd, Eden Prairie, MN, 55397	0.78	Date of birth reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
ENR-111195	ENR	Martha N Dean	1983-08-15	UHC-45430-60	9266341985	2239 Washington St, Charlotte, NC	0.78	Name re-cased Phone reformatted City re-cased ZIP missing+1 more

8,423 rows, page 120 of 169Previous Next