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

All sources, flag “ZIP+4 trimmed”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP+4 trimmedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-127817	ENR	Kathleen S Santiago	1943-10-11	—	5027555551	3108 Apache Blvd, Las Vegas, NV, 89163	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-427834	CLM	Arthur Santos	1994-07-02	UHC-64643-18	—	9820 Market St, Fresno, CA, 93776	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-400275	CLM	Alexander Medina	1962-10-09	—	7598484612	3388 Forest Ave, Atlanta, GA, 30372	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-134803	ENR	Mark H Stone	1942-06-25	UHC-66031-67	9622879264	2896 Willow Ct, Eden Prairie, MN, 55331	0.82	Name re-cased Date of birth reformatted ZIP+4 trimmed
ENR-132954	ENR	Lori X Stawart	1983-03-27	UHC-48584-19	—	8167 Desert Sky Blvd, Charlotte, NC, 28236	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-410387	CLM	Jeeremy Cook	1948-08-19	UHC-20902-98	5055715690	7234 Indian School Rd, Columbus, OH, 43239	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-410386	CLM	Jeeremy Cook	1948-08-19	UHC-20902-98	5055715690	7234 Indian School Rd, Columbus, OH, 43239	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-109334	ENR	Sophia Diaz	1944-07-10	UHC-97392-72	—	5031 Meadow Ln, Miami, FL, 33116	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
CLM-427672	CLM	Jonathan Flores	1972-09-19	UHC-29582-45	—	9441 Canyon Rd, Eden Prairie, MN, 55360	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-129668	ENR	Danielle I Duncan	2008-05-08	UHC-27925-26	9545299043	4624 Central Ave, Jacksonville, FL, 32294	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
ENR-137860	ENR	Alexis U Bell	1984-08-28	UHC-85769-60	3424554742	6876 Hillcrest Rd, Tampa, FL, 33631	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
ENR-111211	ENR	Katherine Berry	2006-10-09	UHC-71526-34	8987284309	1941 Lincoln Way, Denver, CO, 80233	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-132075	ENR	Kathleen Crawford	2005-06-27	UHC-14435-71	4605129180	5152 Market St, Seattle, WA, 98167	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-136904	ENR	Seven Z Banks	1996-02-04	UHC-07451-51	3894330654	3470 Bayshore Dr, Eden Prairie, MN, 55348	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-409841	CLM	Ralph Johnson	1939-11-02	—	9712294403	9079 Maple Ave, Austin, TX, 78750	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-401777	CLM	Elijah Ross	1971-11-17	UHC-43383-31	6468162965	6360 Mesa Dr, Tampa, FL, 33632	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-120487	ENR	Kenneth Morgan	1969-05-17	UHC-50444-71	8816254260	4960 Bayshore Dr, Denver, CO, 80278	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-124538	ENR	Robert W Murray	1948-06-28	UHC-13082-33	4407333002	5402 Mesa Dr, Eden Prairie, MN, 55367	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
TPA-57055	TPA	Noah Y Hughes	1954-12-24	—	—	7724 Bayshore Dr, Tempe, AZ, 85246	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-401895	CLM	Emma P Lopez	1982-07-16	UHC-06552-13	—	932 Harbor Blvd, Tampa, FL, 33652	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-429537	CLM	Jeffrey Phillips	1977-06-27	UHC-08341-30	—	8994 Highland Ave, Phoenix, AZ, 85065	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-137626	ENR	Anthony Clark	1986-08-14	UHC-44110-59	9246514107	8696 Forest Ave, San Antonio, TX, 78208	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-112137	ENR	Jacob Ward	1989-03-20	UHC-58162-21	9415002414	8456 Mountain View Dr, Charlotte, NC, 28266	0.82	Phone reformatted ZIP+4 trimmed Email lower-cased
ENR-100825	ENR	Julie Evans	1952-10-11	UHC-54569-15	3968237514	2563 Desert Sky Blvd, Las Vegas, NV, 89150	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-126735	ENR	Radny R Hernandez	1982-09-03	UHC-12377-86	4076940357	5210 Canyon Rd, Atlanta, GA, 30333	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-138494	ENR	Bryan Rose	1991-01-28	UHC-56998-94	4813886338	3255 Broadway, Chandler, AZ, 85255	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
CLM-419366	CLM	Julia Le	1972-12-15	UHC-13063-97	2789404205	9364 Market St, Tucson, AZ, 85750	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-142353	ENR	Victoria Dunn	2001-10-11	UHC-06859-93	3727656233	8891 Canyon Rd, Tampa, FL, 33620	0.82	Date of birth reformatted ZIP+4 trimmed Email lower-cased
TPA-61404	TPA	Lucia Edwards	1957-07-22	—	—	8838 Forest Ave, Phoenix, AZ, 85040	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-138691	ENR	Pat Wilson	1962-09-25	UHC-11066-40	—	7558 Mesa Dr, Columbus, OH, 43220	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
TPA-63487	TPA	Janet Hawkins	1947-06-21	—	7834554394	2446 Indian School Rd, Seattle, WA, 98147	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
TPA-63486	TPA	Janet Hawkins	1947-06-21	—	7834554394	2446 Indian School Rd, Seattle, WA, 98147	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-422774	CLM	Jesse D Cunningham	1993-09-09	UHC-75159-17	—	9591 Palm Dr, Tempe, AZ, 85211	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-423032	CLM	Kathryn Johnston	1982-05-14	—	—	1217 Pine Dr, Mesa, AZ, 85255	0.82	City re-cased ZIP+4 trimmed Placeholder values cleared
TPA-60634	TPA	Ann Sims	1960-10-04	—	—	7084 Elm St, Nashville, TN, 37232	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-24257	PRV	Mariana Walker	1961-05-06	—	7009690386	9604 River Rd, Charlotte, NC, 28243	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-430918	CLM	Doris Carlson	1955-11-08	UHC-77177-25	4104881839	4649 Meadow Ln, Nashville, TN, 37216	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
ENR-115255	ENR	Jessica T Rice	1954-10-24	UHC-70139-88	5643506673	2355 Harbor Blvd, Austin, TX, 78776	0.82	Phone reformatted ZIP+4 trimmed Plan code upper-cased
ENR-128927	ENR	Joyce I Duncan	1994-06-08	UHC-27486-99	8044194490	1676 Baseline Rd, Seattle, WA, 98139	0.82	ZIP+4 trimmed Email lower-cased Whitespace trimmed
ENR-130888	ENR	Peters H Viictoria	1988-06-28	UHC-84860-96	7487952139	1271 Harbor Blvd, Tucson, AZ, 85715	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
CLM-427283	CLM	Mdaison Adams	1977-04-24	UHC-85490-31	6136132644	7892 Maple Ave, Mesa, AZ, 85280	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-108129	ENR	Jose Robinson	2007-04-05	UHC-39115-68	6814206975	4998 Sunset Blvd, Las Vegas, NV, 89115	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
CLM-429865	CLM	Aisha Salazar	1953-11-10	UHC-40656-73	—	2129 Jefferson Ave, Nashville, TN, 37292	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-135712	ENR	Kimberly Larson	2003-08-24	UHC-41371-87	8117587713	2152 Desert Sky Blvd, Glendale, AZ, 85361	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
ENR-139798	ENR	Diego Larson	1949-01-03	UHC-46239-88	7693426294	2883 Maple Ave, Chandler, AZ, 85206	0.82	Name re-cased ZIP+4 trimmed Email lower-cased
TPA-56709	TPA	Barbara Carter	1941-08-17	—	—	5676 Ridge Rd, Chandler, AZ, 85290	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-408588	CLM	Joshua Gordon	1983-11-03	—	—	7170 Willow Ct, Sacramento, CA, 95817	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-102703	ENR	Wayne Martinez	1986-02-07	UHC-41171-17	5455774282	8799 Central Ave, Gilbert, AZ, 85293	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-137942	ENR	Pamela N Baekr	1947-03-10	UHC-97391-25	7973204641	8610 Baseline Rd, Dallas, TX, 75212	0.82	Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-102325	ENR	Elijah K Ross	1971-11-17	UHC-43383-31	6468162965	6360 Mesa Dr, Tampa, FL, 33632	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed

8,263 rows, page 162 of 166Previous Next