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-138473	ENR	Jose Day	2004-10-04	UHC-65678-01	3284162887	3940 Desert Sky Blvd, Plano, TX, 75035	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-137281	ENR	Diana V Ellis	1985-05-03	UHC-22463-20	3943315576	2713 Maple Ave, Phoenix, AZ, 85047	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-126400	ENR	Lawrencce Andrews	1988-02-02	UHC-58841-32	7195200865	3743 Canyon Rd, Seattle, WA, 98123	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-121247	ENR	Omar I Williamson	1954-08-11	UHC-55168-93	3753342692	3803 Willow Ct, Scottsdale, AZ, 85267	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-103916	ENR	Nancy V Eans	1963-04-21	UHC-04487-12	—	7133 Apache Blvd, Scottsdale, AZ, 85277	0.76	Name re-cased Member ID reformatted City re-cased State name converted to code+2 more
ENR-100329	ENR	Josseph U Nguyen	1989-09-23	UHC-74993-05	8932313780	7348 Sunset Blvd, Gilbert, AZ, 85246	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-122422	ENR	Aisha K Perkins	2005-09-27	UHC-76762-71	4737924798	6394 Sunset Blvd, Mesa, AZ, 85288	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-129249	ENR	Samantha X Gibson	1977-09-18	UHC-78095-11	6908579553	8088 Washington St, San Diego, CA, 92153	0.76	Street suffix standardised Address re-cased City re-cased Email lower-cased+2 more
ENR-126752	ENR	Sean R Padilla	1952-08-23	UHC-71398-04	2802396017	1293 Harbor Blvd, Eden Prairie, MN, 55346	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-126751	ENR	Sean R Padilla	1952-08-23	UHC-71398-04	2802396017	1293 Harbor Blvd, Eden Prairie, MN, 55346	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-103806	ENR	Katherine Hudson	1980-02-02	UHC-30420-12	5756020543	4697 Sunset Blvd, San Antonio, TX, 78269	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-139580	ENR	Ethan E Gardner	1961-03-01	UHC-07381-68	7583811982	8361 Indian School Rd, Nashville, TN, 37248	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-126440	ENR	Laura Cooper	2007-11-04	UHC-29692-11	3596564023	1831 Willow Ct, San Diego, CA, 92106	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-110018	ENR	Alan Shaw	1997-07-21	UHC-21401-15	9359132370	5641 River Rd, Columbus, OH, 43287	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-131216	ENR	Brittany D Oliver	1996-12-26	UHC-41802-34	9774439005	1002 Willow Ct, Orlando, FL, 32867	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-131765	ENR	Omar Obrien	1953-12-16	UHC-62805-80	5724386322	8422 Washington St, San Diego, CA, 92135	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-112732	ENR	Bruce Richardson	1953-03-23	UHC-31294-01	6782775236	8100 Mesa Dr, Minneapolis, MN, 55476	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-122516	ENR	Jeffrey L Maldonado	1987-04-25	UHC-80273-31	2566266696	2986 Church St, Austin, TX, 78770	0.76	Name re-cased Phone reformatted City re-cased State name converted to code+2 more
ENR-110714	ENR	Ashley Z Edwards	2007-11-06	UHC-56900-20	6653368369	4435 Lincoln Way, Seattle, WA, 98114	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-116407	ENR	Ruth P Park	2008-08-27	UHC-59146-28	9796729537	9034 Main St, Glendale, AZ, 85328	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-123685	ENR	Janet W Dixon	2002-09-08	UHC-87234-89	3676740820	6173 Jefferson Ave, Jacksonville, FL, 32229	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-115986	ENR	Roger A Rodriguez	1956-03-28	UHC-43606-52	8667400237	7531 Valley View Dr, Fresno, CA, 93740	0.76	Name re-cased Two-digit birth year Phone reformatted City re-cased+2 more
ENR-132384	ENR	Michael Lynch	1950-05-28	UHC-69525-11	6508210993	7691 Washington St, Glendale, AZ, 85374	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-128169	ENR	Dylan Burns	1947-12-02	UHC-47416-37	7704238373	8794 Harbor Blvd, Nashville, TN, 37273	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-141442	ENR	Jerry A Torres	1947-01-12	UHC-90769-88	3712961543	6118 Elm St, Houston, TX, 77099	0.76	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-117334	ENR	Jeffrey X Black	1992-05-01	UHC-17754-36	—	4422 Palm Dr, Eden Prairie, MN, 55307	0.76	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-132128	ENR	Amy Collins	1970-09-28	UHC-11297-50	9135650175	4997 Maple Ave, Minneapolis, MN, 55493	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-104726	ENR	Btty S Gutierrez	1976-01-26	UHC-29030-63	7045050150	6971 Union St, Plano, TX, 75024	0.76	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-105167	ENR	Philip F Price	1999-11-07	UHC-90654-46	5548342963	1953 Hillcrest Rd, Gilbert, AZ, 85296	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-133615	ENR	Isabella U Miller	1992-03-22	UHC-79792-35	—	7287 Lincoln Way, Mesa, AZ, 85294	0.76	Name re-cased Date of birth reformatted Phone missing area code City re-cased+2 more
ENR-121588	ENR	Alexander K Olson	2000-04-14	UHC-16284-40	—	4633 Desert Sky Blvd, Dallas, TX, 75284	0.76	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-130619	ENR	Donna Vasquez	1969-04-04	UHC-84667-17	6943561892	8394 Apache Blvd, Minneapolis, MN, 55494	0.76	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-117927	ENR	Carol Owens	1976-05-19	UHC-59852-07	5239866108	2011 Camelback Rd, Phoenix, AZ, 85006	0.76	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-123061	ENR	Mark Larson	1998-03-09	UHC-26773-88	—	7442 Indian School Rd, Scottsdale, AZ, 85223	0.76	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-107083	ENR	Rachel Reyes	1983-10-25	UHC-60809-53	9707026382	8901 Union St, Minneapolis, MN, 55499	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-115272	ENR	Justin I Crawford	1964-09-16	UHC-08752-14	2812150397	7767 Bayshore Dr, Miami, FL, 33169	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-120625	ENR	Theresa Young	1940-01-10	UHC-74149-85	2378236056	97 Broadway, Sacramento, CA, 95843	0.76	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-132020	ENR	Charles T Nguyen	1981-01-23	UHC-11107-77	6186847915	7463 Forest Ave, Sacramento, CA	0.76	Date of birth reformatted Phone reformatted City re-cased ZIP missing+2 more
ENR-107966	ENR	Wei S Daniels	2007-10-20	UHC-15768-48	9564522329	9066 Market St, San Diego, CA, 92195	0.76	Phone reformatted City re-cased ZIP+4 trimmed Email lower-cased+2 more
ENR-112613	ENR	Bradley G Austin	1983-05-07	UHC-84381-58	4116753479	7207 Washington St, Fresno, CA, 93738	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-120027	ENR	Carl Ruiz	1986-10-20	UHC-13349-63	2197927560	9542 Sunset Blvd, Tampa, FL, 33667	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-124133	ENR	James N Jacobs	1938-03-16	UHC-49160-18	9065985684	3229 Park Pl, Seattle, WA, 98131	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-121458	ENR	Emily C Dunn	2005-06-10	UHC-10434-99	8518520136	2401 Union St, Tempe, AZ, 85251	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-132138	ENR	Bruce Munoz	1993-08-13	UHC-93815-58	4465388925	5523 Harbor Blvd, Tampa, FL, 33606	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-135807	ENR	Eugene J Patterson	2000-12-14	UHC-13111-90	7058214243	7809 Meadow Ln, Minneapolis, MN, 55488	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-128076	ENR	Martha Medina	1958-10-18	UHC-68694-09	5597957478	7446 Central Ave, Atlanta, GA	0.76	Name re-cased Phone reformatted City re-cased ZIP missing+2 more
ENR-122951	ENR	Robert M Soto	1978-02-19	UHC-74389-69	5966517237	1690 Church St, Miami, FL, 33132	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-129382	ENR	Gary Castro	2007-09-26	UHC-63097-90	3245197176	8365 Baseline Rd, Glendale, AZ, 85369	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-100804	ENR	Russell J Carlson	1972-11-07	UHC-54250-93	2932613023	1405 Valley View Dr, Orlando, FL	0.76	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-138303	ENR	Martha H Jacobs	1985-12-16	UHC-57381-01	9062861168	5562 Canyon Rd, San Diego, CA, 92133	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more

8,423 rows, page 107 of 169Previous Next