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 “Unit split from street”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagUnit split from streetClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-126152	ENR	Rachel Dunn	1979-12-14	UHC-82112-42	2856842607	3862 Desert Sky Blvd Apt 13, Nashville, TN, 37225	0.80	Phone reformatted Member ID reformatted Unit split from street Email lower-cased
ENR-137695	ENR	Diana M Maldonado	1979-10-19	UHC-96293-40	6018294529	5458 Jefferson Ave # 918, Columbus, OH, 43235	0.80	Phone reformatted Unit split from street Email lower-cased Whitespace trimmed
ENR-101730	ENR	Becky Sims	1938-07-04	UHC-17441-60	6638467326	9430 Broadway Apt 5, Seattle, WA, 98110	0.80	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed
ENR-123366	ENR	Charles A Rihardson	1963-11-23	UHC-92117-87	3346248187	6611 Ridge Rd Apt 6, Los Angeles, CA, 90036	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
ENR-100610	ENR	Joseph A Silva	1979-05-07	UHC-84565-25	7105982586	2092 Spring St # 620, Mesa, AZ, 85285	0.80	Name re-cased Date of birth reformatted Unit split from street City re-cased
ENR-138325	ENR	Ashley E Wallace	1961-07-08	UHC-63741-58	8478064359	2406 Church St # 727, Tucson, AZ, 85772	0.80	Phone reformatted Unit split from street Plan code upper-cased Whitespace trimmed
ENR-115957	ENR	Willie E Gutierrez	1947-12-01	UHC-12049-96	8719335215	2585 Union St # 491, Orlando, FL, 32827	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
ENR-104039	ENR	Maria J Perez	2000-02-01	UHC-43747-20	5874100049	4692 Grand Ave Apt 38, Denver, CO, 80296	0.80	Name re-cased Phone reformatted Unit split from street State code upper-cased
ENR-111623	ENR	Gerald Mendez	1938-07-14	UHC-57711-14	4643516517	6822 Baseline Rd # 316, Columbus, OH, 43244	0.80	Date of birth reformatted Phone reformatted Unit split from street Placeholder values cleared
ENR-108827	ENR	Christian L Morrison	1969-06-28	UHC-39410-53	5332752929	556 Apache Blvd Apt 34, Fresno, CA, 93731	0.80	Phone reformatted Unit split from street City re-cased Whitespace trimmed
ENR-101682	ENR	Santiago Howell	1972-04-14	UHC-67277-92	6365021524	8827 Grand Ave # 355, Austin, TX, 78775	0.80	Date of birth reformatted Phone reformatted Unit split from street City re-cased
ENR-124654	ENR	Rendy Z Fisher	1984-01-26	UHC-09845-24	—	772 Harbor Blvd # 945, Atlanta, GA, 30393	0.80	Date of birth reformatted Unit split from street Whitespace trimmed Placeholder values cleared
ENR-132530	ENR	Gerald Carroll	1969-08-11	UHC-87192-04	2765170952	7456 Ridge Rd # 312, Sacramento, CA, 95891	0.80	Name re-cased Phone reformatted Unit split from street City re-cased
ENR-133740	ENR	Lucia V Weaver	2000-08-24	UHC-36651-05	7242569505	4920 Lake View Rd Apt 18, Columbus, OH, 43296	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
ENR-142803	ENR	Christina F Williams	1996-12-21	UHC-25299-76	4427525175	9383 Ocean Ave Apt 17, Tucson, AZ, 85705	0.80	Name re-cased Date of birth reformatted Unit split from street Email lower-cased
ENR-108942	ENR	Deborah Goemz	1947-08-07	UHC-89041-13	7958628445	7243 Lincoln Way # 186, Las Vegas, NV, 89129	0.80	Date of birth reformatted Phone reformatted Unit split from street Placeholder values cleared
ENR-106704	ENR	Marilyn W Romero	1954-08-02	UHC-22595-40	5559000569	2973 Main St # 159, Eden Prairie, MN, 55338	0.80	Phone reformatted Unit split from street Email lower-cased Whitespace trimmed
ENR-141749	ENR	Abigail W Nikhols	1965-08-26	UHC-64302-30	2518440057	1380 Forest Ave Apt 19, Orlando, FL, 32896	0.80	Date of birth reformatted Unit split from street Email lower-cased Whitespace trimmed
ENR-137378	ENR	Lori F Stewart	1945-01-20	UHC-49995-63	8175708003	5044 Broadway # 614, Atlanta, GA, 30309	0.80	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed
ENR-105136	ENR	Yuki X Fox	1944-10-15	UHC-24074-48	9358892383	3744 Park Pl # 656, Denver, CO, 80247	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
ENR-128342	ENR	Brenda Smith	1940-04-14	UHC-93863-72	4149561765	4140 Ocean Ave Apt 6, San Diego, CA, 92153	0.80	Name re-cased Unit split from street City re-cased Whitespace trimmed
ENR-128212	ENR	Logan Moreno	1945-09-17	UHC-03115-61	5305361980	4844 Valley View Dr Apt 21, Atlanta, GA, 30398	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
ENR-117047	ENR	Ruth Vazquez	2006-09-08	UHC-11615-56	2439617794	3458 Oak St Apt 38, San Antonio, TX, 78282	0.80	Phone reformatted Member ID reformatted Unit split from street Placeholder values cleared
ENR-107519	ENR	Mary Schmidt	1977-05-21	UHC-12590-72	3866601828	6452 Harbor Blvd # 878, Miami, FL, 33132	0.80	Name re-cased Date of birth reformatted Unit split from street Whitespace trimmed
ENR-128495	ENR	Aisha C Reyes	1984-07-28	UHC-90663-56	2303783321	6076 Pine Dr Apt 9, Eden Prairie, MN, 55358	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
ENR-113868	ENR	Jessica Mattthews	1962-01-06	UHC-00779-91	7459959603	479 Willow Ct # 835, Scottsdale, AZ, 85210	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
ENR-138467	ENR	Betty Wright	1996-05-07	UHC-97501-96	6076640120	6345 Desert Sky Blvd # 933, Miami, FL, 33102	0.80	Name re-cased Unit split from street State code upper-cased Placeholder values cleared
ENR-110305	ENR	Emily Simpson	2006-08-20	UHC-45607-98	8723790283	7381 Canyon Rd Apt 19, Jacksonville, FL, 32293	0.80	Date of birth reformatted Unit split from street City re-cased Whitespace trimmed
ENR-119574	ENR	Dennis H Murphy	1962-08-12	UHC-72122-15	3272899178	1093 Baseline Rd # 643, Plano, TX, 75094	0.80	Name re-cased Date of birth reformatted Unit split from street Placeholder values cleared
ENR-127806	ENR	Billy Gilbert	1980-06-11	UHC-53996-82	9006612715	7244 Lincoln Way # 763, Tampa, FL, 33683	0.80	Name re-cased Date of birth reformatted Phone reformatted Unit split from street
ENR-139512	ENR	Megan F Hawkins	1951-05-16	—	8192644561	667 River Rd # 894, Sacramento, CA, 95812	0.80	Unit split from street City re-cased Email lower-cased Placeholder values cleared
ENR-139513	ENR	Megan F Hawkins	1951-05-16	—	8192644561	667 River Rd # 894, Sacramento, CA, 95812	0.80	Unit split from street City re-cased Email lower-cased Placeholder values cleared
ENR-123441	ENR	Sarah George	1951-04-09	UHC-16226-95	2195482501	1849 Harbor Blvd Apt 23, Phoenix, AZ, 85024	0.80	Phone reformatted Unit split from street Email lower-cased Whitespace trimmed
ENR-126464	ENR	Dunn B Santiago	2004-09-12	UHC-83977-58	4945241192	8384 Park Pl Apt 12, Glendale, AZ, 85349	0.80	Date of birth reformatted Phone reformatted Unit split from street Email lower-cased
ENR-119205	ENR	Maria Wheler	1978-02-11	UHC-63171-78	2863458013	6718 Broadway Apt 10, Austin, TX, 78778	0.80	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed
ENR-123949	ENR	Steven Taylor	2003-03-25	UHC-20151-78	8447533790	9165 Palm Dr Apt 29, Gilbert, AZ, 85258	0.80	Date of birth reformatted Phone reformatted Unit split from street Plan code upper-cased
ENR-122989	ENR	Victoria Gardner	1968-10-13	UHC-97247-28	2696145925	7811 Valley View Dr # 338, Tempe, AZ, 85249	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
ENR-121956	ENR	Donna Riley	1995-08-28	UHC-34358-22	6839647626	4358 Forest Ave Apt 3, Tucson, AZ, 85763	0.80	Phone reformatted Unit split from street Whitespace trimmed Placeholder values cleared
ENR-127004	ENR	Frances Q Brown	2004-12-05	UHC-25113-79	4687767432	3236 Washington St # 549, Atlanta, GA, 30318	0.80	Name re-cased Unit split from street City re-cased Whitespace trimmed
ENR-124616	ENR	Russell Luna	1991-11-16	UHC-49314-26	4494539858	3367 Elm St # 402, Columbus, OH, 43218	0.80	Date of birth reformatted Phone reformatted Unit split from street Placeholder values cleared
ENR-102494	ENR	Kyle Guzman	1996-03-24	UHC-29349-66	2119363478	9740 Valley View Dr # 302, Denver, CO, 80268	0.80	Phone reformatted Unit split from street City re-cased Email lower-cased
ENR-138896	ENR	Austin O Gordon	1964-09-27	UHC-50210-62	3875910563	2936 Grand Ave # 570, Tempe, AZ, 85241	0.80	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed
ENR-141332	ENR	Carl Carpenter	1968-09-17	UHC-97558-87	6048136335	9581 Broadway # 486, Houston, TX, 77089	0.80	Date of birth reformatted Phone reformatted Member ID reformatted Unit split from street
ENR-109972	ENR	Jacob Rojas	1939-08-27	UHC-05156-98	7598530750	3308 Bayshore Dr # 222, Columbus, OH, 43219	0.80	Phone reformatted Unit split from street Email lower-cased Whitespace trimmed
ENR-109666	ENR	Betty L Luna	1955-11-20	UHC-59042-26	9149883606	1157 Mountain View Dr # 549, Los Angeles, CA, 90016	0.80	Name re-cased Phone reformatted Unit split from street Placeholder values cleared
ENR-113313	ENR	Rachel C Hughes	1963-04-07	UHC-54765-40	8495526274	6194 Willow Ct # 973, Austin, TX, 78713	0.80	Phone reformatted Unit split from street City re-cased Placeholder values cleared
ENR-117043	ENR	Christopher N Lopez	1955-01-21	UHC-80979-42	2499506477	6420 Valley View Dr Apt 32, Scottsdale, AZ, 85217	0.80	Phone reformatted Member ID reformatted Unit split from street Whitespace trimmed
ENR-113814	ENR	Melissa P Patterson	1964-03-08	UHC-28496-26	3085738275	64 Elm St # 866, Sacramento, CA, 95845	0.80	Phone reformatted Unit split from street Whitespace trimmed Placeholder values cleared
ENR-113095	ENR	Arjun James	1983-11-06	UHC-46049-75	7398992941	9490 Lake View Rd # 624, Tempe, AZ, 85270	0.80	Phone reformatted Unit split from street Plan code upper-cased Placeholder values cleared
ENR-136955	ENR	Bryan Miller	2005-03-13	UHC-66194-53	2492407213	9132 Spring St # 525, Charlotte, NC, 28290	0.80	Date of birth reformatted Phone reformatted Member ID reformatted Unit split from street

3,345 rows, page 63 of 67Previous Next