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 “State name converted to code”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagState name converted to codeClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-102826	ENR	Noah Morris	1981-10-14	UHC-64103-84	2394662279	6769 Park Pl, Glendale, AZ, 85301	0.64	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-123496	ENR	Bryan Sandoval	1971-04-14	UHC-04047-70	3945181348	1005 Bayshore Dr, Seattle, WA, 98195	0.64	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-108052	ENR	Anna L Yang	1985-06-26	UHC-14522-23	9366818769	2243 Baseline Rd, Dallas, TX, 75213	0.64	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-109204	ENR	Larry J Myers	2001-02-11	UHC-76370-95	9599045305	6114 Church St, Atlanta, GA, 30327	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-115766	ENR	Jesse Contreras	1998-12-20	UHC-26604-40	4163750386	1322 Mountain View Dr, Columbus, OH	0.64	Date of birth reformatted Phone reformatted Member ID reformatted State name converted to code+2 more
ENR-106154	ENR	Ralph E Welch	1942-04-08	UHC-09436-99	—	1308 Mountain View Dr, Gilbert, AZ, 85267	0.64	Name re-cased Street suffix standardised Address re-cased State name converted to code+2 more
ENR-103671	ENR	Ronald Smith	2003-07-06	UHC-43052-53	5284117287	9385 Park Pl, Atlanta, GA, 30332	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-123917	ENR	Brandon Reyd	1968-11-07	UHC-76294-19	5535939403	4052 Indian School Rd, Glendale, AZ, 85388	0.64	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-119204	ENR	Joshua Ford	1972-09-26	UHC-98156-24	4774364619	7167 Camelback Rd, Tampa, FL, 33641	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-137186	ENR	Sean Watson	1938-06-28	UHC-41450-94	6948803628	9535 Grand Ave, Los Angeles, CA, 90051	0.64	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-114481	ENR	Susan Hayes	1957-09-13	UHC-57014-25	2287570186	2422 Sunset Blvd, Phoenix, AZ, 85053	0.64	Name re-cased Date of birth reformatted Phone reformatted State name converted to code+2 more
ENR-105200	ENR	Cynthia Burton	1960-07-26	UHC-26454-12	5116006211	7275 Apache Blvd, Charlotte, NC, 28216	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-107238	ENR	Frances Z Bryent	1985-09-19	UHC-76409-62	8812749355	2264 Meadow Ln, Las Vegas, NV, 89121	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-107526	ENR	Megan P Luna	1944-03-28	UHC-29621-49	6682034810	79 Baseline Rd, Nashville, TN, 37205	0.64	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-103178	ENR	Betty V Hicks	1975-11-21	UHC-76630-64	5922356190	2413 Grand Ave, Tucson, AZ, 85747	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-118704	ENR	Logan R Jensen	1965-06-18	UHC-93744-90	6865464230	2423 Cedar Ln, Plano, TX, 75061	0.64	Name re-cased Two-digit birth year Phone reformatted City re-cased+2 more
ENR-110388	ENR	Helen Anderson	1998-12-21	UHC-20220-42	7563174037	581 Meadow Ln, Charlotte, NC, 28245	0.64	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-138333	ENR	Samuel Allen	1941-06-13	UHC-12876-11	8054020204	6831 Meadow Ln, Houston, TX, 77081	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-127532	ENR	Hiroshi Montgomery	—	UHC-28875-07	7828558376	1778 Ridge Rd, Miami, FL, 33123	0.64	Name re-cased Date of birth unreadable City re-cased State name converted to code+2 more
ENR-110890	ENR	Andrea V Watson	1950-09-10	UHC-73165-75	7375795304	8190 Apache Blvd, Plano, TX, 75029	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-139252	ENR	Charlotte X Ramos	1996-05-05	UHC-26786-04	8714727455	3625 Ocean Ave, Denver, CO, 80249	0.64	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-124091	ENR	Lawrence I Diaz	1998-01-18	UHC-88531-91	5457081027	6361 Lincoln Way, Austin, TX, 78751	0.64	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-114535	ENR	Eric V Mejia	1942-05-17	UHC-15564-26	3602878877	6702 Desert Sky Blvd, San Antonio, TX, 78255	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-106937	ENR	Deborah Z Torres	1955-03-14	UHC-39822-20	3832279156	9173 Ridge Rd, Gilbert, AZ, 85284	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-131464	ENR	George Schmidt	1938-02-14	UHC-87968-01	—	4919 Washington St, Las Vegas, NV, 89112	0.64	Name re-cased Street suffix standardised Address re-cased State name converted to code+2 more
ENR-133336	ENR	Emily Warren	1946-02-20	—	8193325044	4996 Maple Ave, Atlanta, GA, 30381	0.64	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-113353	ENR	Roger U Ray	1977-08-03	UHC-43599-50	7875008643	4127 Apache Blvd, Mesa, AZ, 85214	0.64	Name re-cased Date of birth reformatted Phone reformatted State name converted to code+2 more
ENR-128173	ENR	Victoria R Carroll	1948-01-02	UHC-24385-84	—	8671 Central Ave, Gilbert, AZ, 85273	0.64	Name re-cased SSN last four extracted State name converted to code Plan code upper-cased+2 more
ENR-131311	ENR	David L Adams	1944-10-08	UHC-00993-52	8316997194	5254 Canyon Rd, Jacksonville, FL, 32296	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-108553	ENR	Linda I Myers	1975-11-06	UHC-19783-34	2465836521	8146 Church St, Phoenix, AZ, 85039	0.64	Middle initial moved out of first name Date of birth reformatted Phone reformatted State name converted to code+2 more
ENR-117026	ENR	Kevin Q Rivera	1943-08-09	UHC-07697-20	3653984769	881 Spring St, Eden Prairie, MN, 55386	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-112936	ENR	Nathan Morgan	1969-04-07	UHC-41203-84	9762874685	811 Jefferson Ave, Miami, FL, 33143	0.64	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-114735	ENR	Mason R Wagner	1966-04-13	UHC-90831-50	2297681839	6319 Jefferson Ave, Miami, FL, 33175	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-135293	ENR	Frank Garcia	1940-07-01	UHC-99822-51	7367514389	9059 Market St, Denver, CO	0.64	Name re-cased Phone reformatted State name converted to code ZIP missing+2 more
ENR-128831	ENR	Sarah Brown	1973-01-21	UHC-49452-97	7378659813	1396 Apache Blvd, Fresno, CA, 93743	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-138817	ENR	Maria V Burns	1994-09-09	UHC-15438-40	3188643368	8057 Baseline Rd, San Antonio, TX, 78226	0.64	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-130124	ENR	Hiroshi R Peterson	1968-09-04	UHC-61159-02	4675183509	2708 Oak St, Miami, FL, 33131	0.64	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-123406	ENR	Logna King	1950-04-20	UHC-67632-43	5358279707	7641 Sage Ct, Glendale, AZ, 85316	0.64	Date of birth reformatted Phone reformatted Member ID reformatted State name converted to code+2 more
ENR-123624	ENR	Wayne Q Silva	2005-02-18	UHC-07518-90	2374504670	3386 Union St, Orlando, FL, 32817	0.64	Two-digit birth year Phone reformatted City re-cased State name converted to code+2 more
ENR-115571	ENR	Doris Q Garza	1984-03-09	UHC-21021-96	9645202486	6498 Market St, Tempe, AZ, 85264	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-141352	ENR	Tricia Robertson	1972-02-10	UHC-63151-88	8342676995	523 Desert Sky Blvd, Eden Prairie, MN, 55365	0.64	Name re-cased Two-digit birth year Phone reformatted State name converted to code+2 more
ENR-129202	ENR	Richard N Castillo	1980-07-01	UHC-32013-85	2463512371	6073 Apache Blvd, Glendale, AZ, 85373	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-104235	ENR	Logan Z Estrada	1945-06-01	UHC-51402-46	—	7129 Harbor Blvd, Miami, FL, 33199	0.64	Date of birth reformatted Member ID reformatted SSN last four extracted State name converted to code+2 more
ENR-140653	ENR	Doris Anderson	1980-11-24	UHC-03249-14	—	4851 Canyon Rd, Glendale, AZ, 85309	0.64	Name re-cased Street suffix standardised Address re-cased State name converted to code+2 more
ENR-102035	ENR	John Graham	1982-06-14	UHC-03219-23	3267854971	719 Central Ave, Tampa, FL, 33657	0.64	Member ID reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-113161	ENR	Wei Bradley	1962-09-24	UHC-76357-55	3147219949	2524 Baseline Rd, Columbus, OH, 43297	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-108460	ENR	Heather O Estrada	1964-12-10	UHC-14837-83	9808767200	7177 River Rd, Tucson, AZ, 85755	0.64	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-104468	ENR	Ryan Armstrong	1961-12-15	UHC-91572-43	6582708039	608 Spring St, Tampa, FL, 33687	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-136321	ENR	Sharon Maldonado	1982-05-27	UHC-48917-93	4786993618	7013 Meadow Ln, Tucson, AZ, 85755	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-132653	ENR	Linda Dixon	1999-10-15	UHC-04438-58	8506574803	705 Washington St, Fresno, CA, 93773	0.64	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more

4,296 rows, page 48 of 86Previous Next