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
PRV-27247	PRV	Bradley Russell	1976-02-07	—	5219562117	3277 Bayshore Dr, Sacramento, CA, 95833	0.64	Street suffix standardised Address re-cased City re-cased ZIP+4 trimmed+2 more
CLM-426372	CLM	Sharon Salazar	1961-01-18	—	3908660416	1694 Mesa Dr, Atlanta, GA, 30393	0.64	Phone reformatted City re-cased ZIP+4 trimmed Gender normalised+2 more
CLM-419558	CLM	Rachel Wagner	1967-02-28	—	6884301702	3551 Palm Dr, Columbus, OH, 43210	0.64	Name re-cased Phone reformatted 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-138829	ENR	Priya F Garza	2001-10-23	UHC-03357-72	8125617921	396 Meadow Ln, Orlando, FL, 32864	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-22580	PRV	Judith H Lopez	1955-12-23	UHC-71589-82	8656504963	7203 Market St, Columbus, OH, 43283	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-26950	PRV	Paul T Morgan	1948-09-10	—	—	4504 Lake View Rd, Phoenix, AZ, 85044	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+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
PRV-27830	PRV	Ruth Spencer	2002-07-12	—	4788432334	1966 Main St, Tempe, AZ, 85241	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-121565	ENR	Richard Wheeler	1994-02-10	UHC-23903-73	4053733770	5088 Baseline Rd, Las Vegas, NV, 89168	0.64	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-111928	ENR	Michelle Kennedy	1967-01-05	UHC-59953-53	2385631911	4335 Sunset Blvd, Miami, FL, 33141	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+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
CLM-421066	CLM	Don Daniels	2001-05-01	UHC-99841-01	—	6814 Valley View Dr, Dallas, TX, 75290	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-115016	ENR	Carol C Ellis	1954-09-16	UHC-90522-90	7588088652	3810 Mountain View Dr, Dallas, TX, 75240	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
TPA-55927	TPA	Melissa Palmer	1959-06-18	—	—	1888 Cedar Ln, Denver, CO, 80267	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-121098	ENR	John H Lopez	2007-10-26	UHC-22836-21	9405873671	8776 Harbor Blvd # 374, Tucson, AZ, 85767	0.64	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-139517	ENR	Ken H Austin	1999-05-12	UHC-79067-76	2295598320	9530 Forest Ave, Miami, FL, 33121	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
CLM-432105	CLM	Margaret Stone	1939-12-20	UHC-82602-39	9749293907	854 River Rd, Phoenix, AZ, 85041	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-427736	CLM	Lucia Hughes	1939-07-22	—	3725976654	3294 Lake View Rd, Atlanta, GA, 30345	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+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-104594	ENR	Betty J Jimennez	1944-05-06	UHC-61044-73	3315717754	5946 Mountain View Dr, Austin, TX, 78707	0.64	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
CLM-406807	CLM	Patricia Hart	1974-05-14	UHC-97214-71	—	6473 Jefferson Ave, Phoenix, AZ, 85018	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-120755	ENR	William Y Carlson	1991-12-18	UHC-03108-32	2307520205	4889 Willow Ct, Seattle, WA, 98148	0.64	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-419212	CLM	Jason X Herrera	1956-10-03	UHC-87054-06	6032629224	6182 Baseline Rd, Gilbert, AZ, 85252	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
CLM-401485	CLM	Natalie Simpson	1940-11-11	—	4947090529	4332 Maple Ave, Jacksonville, FL, 32207	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+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
CLM-427459	CLM	Donna Graham	1976-06-12	UHC-00728-71	7767305430	1770 Oak St, Miami, FL, 33104	0.64	Date of birth reformatted Phone reformatted ZIP+4 trimmed Gender normalised+2 more
CLM-417523	CLM	Michelle Green	1975-07-07	—	9615165351	9862 Maple Ave, Gilbert, AZ, 85250	0.64	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+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
CLM-429186	CLM	Eric P Williamson	1998-05-13	—	4115165851	6793 Hillcrest Rd, Tampa, FL, 33651	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
CLM-432799	CLM	Sara Baker	1998-08-02	UHC-05605-66	—	9166 Market St, Atlanta, GA, 30331	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+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-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
ENR-115176	ENR	George Bishop	1962-11-25	UHC-42128-42	5026511949	6104 Highland Ave, Columbus, OH, 43275	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-142023	ENR	Ashley T Gordon	1943-03-21	UHC-37593-82	6533033312	478 Central Ave, Austin, TX, 78792	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-126384	ENR	Daniel Morrison	1967-01-20	UHC-57254-08	6179700274	2317 Baseline Rd, Phoenix, AZ, 85098	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-105893	ENR	Jesse Santos	1981-06-19	UHC-21978-49	3377739768	8431 Palm Dr, Phoenix, AZ, 85086	0.64	Name split from “Last, First”Phone reformatted Member ID reformatted ZIP+4 trimmed+2 more
ENR-130243	ENR	Raymond Collins	1971-03-26	UHC-04176-72	3534901244	6254 Forest Ave, Seattle, WA, 98140	0.64	Name re-cased Date of birth reformatted ZIP+4 trimmed Email lower-cased+2 more
ENR-128868	ENR	Sean U Tucker	1942-02-27	UHC-15420-32	6769874210	4803 Canyon Rd, Minneapolis, MN, 55433	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-128869	ENR	Sean U Tucker	1942-02-27	UHC-15420-32	6769874210	4803 Canyon Rd, Minneapolis, MN, 55433	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
PRV-21982	PRV	Gloria Stone	1965-04-03	UHC-46016-18	4863376974	2107 Park Pl, Charlotte, NC, 28202	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-127719	ENR	Stephhen U Elliott	1993-12-09	UHC-16349-63	7068913399	209 Maple Ave, Columbus, OH, 43232	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-117594	ENR	Jordan Alvarado	1984-03-12	UHC-21426-35	—	4827 Lake View Rd, Fresno, CA, 93725	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-406832	CLM	Philpi Woods	2001-02-24	—	9877177326	8935 Valley View Dr, Eden Prairie, MN, 55320	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
TPA-62164	TPA	Kimberly Elliott	1980-04-02	UHC-63437-77	—	5434 Hillcrest Rd, Seattle, WA, 98157	0.64	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
TPA-59862	TPA	Edward Z Sims	1993-02-01	—	—	1338 Hillcrest Rd, Houston, TX, 77051	0.64	Name re-cased Two-digit birth year State code upper-cased ZIP+4 trimmed+2 more
TPA-60766	TPA	Dennis Ford	1939-10-12	—	—	8159 Desert Sky Blvd, Fresno, CA, 93752	0.64	Date of birth reformatted ZIP+4 trimmed Email lower-cased Gender normalised+2 more
CLM-413253	CLM	Jason Larson	1960-12-28	—	7958266992	1155 Broadway, Mesa, AZ, 85203	0.64	Name re-cased Phone reformatted ZIP+4 trimmed Gender normalised+2 more
CLM-414407	CLM	George Torres	1964-05-20	UHC-42020-09	—	4804 Market St, Mesa, AZ, 85267	0.64	Name re-cased Date of birth reformatted City re-cased State name converted to code+2 more
ENR-131897	ENR	Catherine U Bowman	1993-08-01	UHC-34034-90	—	2325 Lake View Rd, Columbus, OH, 43299	0.64	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more

8,263 rows, page 99 of 166Previous Next