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 “Gender normalised”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagGender normalisedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-107392	ENR	Diego Bradley	1978-04-22	UHC-19523-90	2595188420	1851 Ridge Rd, Plano, TX, 75001	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
ENR-120262	ENR	Brian D Hamilton	1988-11-07	UHC-98413-48	3634696624	—	0.78	Phone reformatted Member ID reformatted Gender normalised Whitespace trimmed+1 more
ENR-127772	ENR	Mary D Shaw	1949-10-03	UHC-02636-81	4666966525	8227 Jefferson Ave, Eden Prairie, MN, 55310	0.78	Name re-cased City re-cased Gender normalised Plan code upper-cased+1 more
ENR-117753	ENR	Elijah H Fields	1969-09-06	UHC-92583-42	3756687460	6735 Cedar Ln, Jacksonville, FL, 32294	0.78	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed+1 more
ENR-132702	ENR	Susan D Garcia	1993-04-02	UHC-95016-09	7128042400	5840 Oak St, Nashville, TN, 37270	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
ENR-142914	ENR	Roger Knight	1977-11-15	UHC-48816-54	—	6386 River Rd, Chandler, AZ, 85280	0.78	Name re-cased City re-cased Gender normalised Whitespace trimmed+1 more
ENR-114290	ENR	Charles Dunn	1993-10-24	UHC-26801-85	9608153372	4956 Meadow Ln, Columbus, OH, 43288	0.78	Name re-cased Phone reformatted City re-cased Gender normalised+1 more
ENR-123943	ENR	Grace Rodriguez	1946-08-20	UHC-14421-97	2326465879	6215 Lake View Rd, Houston, TX, 77026	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
ENR-128239	ENR	Juan U Thomas	1987-02-21	UHC-43427-14	8797184660	3861 Central Ave, Phoenix, AZ, 85037	0.78	Phone reformatted City re-cased Email lower-cased Gender normalised+1 more
ENR-120115	ENR	Cynthia S Chavez	1957-05-17	UHC-34928-29	9865221446	2401 Palm Dr, Columbus, OH, 43228	0.78	Phone reformatted State code upper-cased Email lower-cased Gender normalised+1 more
ENR-120116	ENR	Cynthia S Chavez	1957-05-17	UHC-34928-29	9865221446	2401 Palm Dr, Columbus, OH, 43228	0.78	Phone reformatted State code upper-cased Email lower-cased Gender normalised+1 more
ENR-120988	ENR	Hiroshi Allen	1983-12-13	UHC-48482-25	5049851021	7321 Broadway, Columbus, OH, 43212	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
ENR-137511	ENR	Sean A Guzman	1988-01-01	UHC-09112-57	—	3119 Lake View Rd, Fresno, CA, 93771	0.78	Name re-cased Email lower-cased Gender normalised Whitespace trimmed+1 more
ENR-112213	ENR	Michelle Z Johnston	1942-12-25	UHC-85823-47	4697144456	5869 Oak St, Chandler, AZ, 85232	0.78	Name re-cased Date of birth reformatted Phone reformatted Email lower-cased+1 more
ENR-129345	ENR	Kathleen Santos	1950-10-05	UHC-55877-69	2379202441	8956 Grand Ave, Atlanta, GA, 30398	0.78	Date of birth reformatted Phone reformatted City re-cased Gender normalised+1 more
ENR-121571	ENR	Diego Willis	1990-01-22	UHC-27057-09	8019955325	9873 Hillcrest Rd, Jacksonville, FL, 32253	0.78	Name re-cased Phone reformatted Member ID reformatted Gender normalised+1 more
ENR-121572	ENR	Diego Willis	1990-01-22	UHC-27057-09	8019955325	9873 Hillcrest Rd, Jacksonville, FL, 32253	0.78	Name re-cased Phone reformatted Member ID reformatted Gender normalised+1 more
ENR-118835	ENR	Stephanie Z Mejia	1984-11-12	UHC-10286-01	5648476984	—	0.78	Phone reformatted Member ID reformatted Gender normalised Whitespace trimmed+1 more
ENR-110456	ENR	Mason Wilson	1976-06-14	UHC-73791-85	5758140280	6344 Sage Ct, Los Angeles, CA, 90042	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
ENR-123454	ENR	Carolyn K James	1946-10-12	—	7113435050	6177 Ridge Rd, Los Angeles, CA, 90001	0.78	Phone reformatted Gender normalised Plan code upper-cased Whitespace trimmed+1 more
ENR-119009	ENR	Wei Washington	1938-12-18	UHC-27182-89	2287229709	1983 Central Ave, Jacksonville, FL, 32221	0.78	Name re-cased Phone reformatted Member ID reformatted Gender normalised+1 more
ENR-126031	ENR	Chris Palmer	1944-11-16	UHC-03068-81	2858744553	3457 Lincoln Way, Atlanta, GA, 30308	0.78	Phone reformatted State code upper-cased Gender normalised Whitespace trimmed+1 more
ENR-128603	ENR	Olivia G Duncan	1978-10-22	UHC-53978-39	—	5226 Baseline Rd, Tampa, FL, 33646	0.78	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed+1 more
ENR-139113	ENR	Kelly T Rivera	1941-09-27	UHC-23051-08	—	7314 Baseline Rd, Phoenix, AZ, 85041	0.78	Date of birth reformatted Member ID reformatted Gender normalised Whitespace trimmed+1 more
ENR-109816	ENR	Doris G Murphy	1953-03-22	UHC-18676-02	7239138186	9130 Lincoln Way, Tampa, FL, 33687	0.78	Phone reformatted Email lower-cased Gender normalised Whitespace trimmed+1 more
ENR-119753	ENR	Linda Porter	1964-02-27	UHC-19421-30	9083964665	3017 Valley View Dr, Dallas, TX, 75281	0.78	Name re-cased Phone reformatted Member ID reformatted Gender normalised+1 more
ENR-117722	ENR	Noah Padilla	1984-09-20	UHC-55448-80	4128831061	5201 Highland Ave, Austin, TX, 78774	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
ENR-109022	ENR	Jonathan A Johnson	1946-02-08	UHC-35364-89	4428586235	2808 Broadway, Dallas, TX, 75208	0.78	Name re-cased Phone reformatted Gender normalised Whitespace trimmed+1 more
ENR-107239	ENR	Julia J Hernandez	1946-03-08	UHC-51565-68	5248883653	1160 Church St, Jacksonville, FL, 32228	0.78	Name re-cased Phone reformatted Email lower-cased Gender normalised+1 more
ENR-135265	ENR	Alice Hansen	1987-07-08	—	2717673974	8804 Forest Ave, Charlotte, NC, 28225	0.78	Name re-cased Date of birth reformatted Email lower-cased Gender normalised+1 more
ENR-106682	ENR	Luis Ramos	1965-11-22	UHC-28626-89	7892327072	—	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
ENR-130879	ENR	Pamela Johnston	1979-07-12	UHC-19171-30	9436996818	4813 Oak St, Orlando, FL, 32822	0.78	Name re-cased Date of birth reformatted Phone reformatted City re-cased+1 more
ENR-136077	ENR	Sara Howard	1955-06-10	UHC-08810-14	5664897154	47 Forest Ave, Glendale, AZ, 85367	0.78	Name re-cased Phone reformatted State code upper-cased Gender normalised+1 more
ENR-104280	ENR	Vincent F Hansoon	1943-12-03	UHC-95245-95	8997101664	6526 Camelback Rd, Atlanta, GA, 30302	0.78	Phone reformatted Email lower-cased Gender normalised Whitespace trimmed+1 more
ENR-114029	ENR	David G Woods	2007-12-12	UHC-84665-74	5716753261	9773 Washington St, San Antonio, TX, 78283	0.78	Phone reformatted Email lower-cased Gender normalised Whitespace trimmed+1 more
ENR-114710	ENR	Kelly W Obrien	1988-04-21	UHC-81903-21	8092781764	3449 Camelback Rd, Columbus, OH, 43266	0.78	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+1 more
ENR-100997	ENR	Hannah Gonzalez	1978-03-24	UHC-49007-82	—	3987 Maple Ave, Phoenix, AZ, 85048	0.78	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed+1 more
ENR-136800	ENR	Stephen X Rios	1965-11-22	UHC-56771-75	7603756452	—	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
ENR-140911	ENR	Christopher Meyer	1997-06-28	UHC-42589-19	—	4989 Sage Ct, Mesa, AZ, 85216	0.78	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed+1 more
ENR-133890	ENR	Stephanie P Vasquez	1949-05-18	UHC-25440-72	—	6735 Central Ave, Seattle, WA, 98131	0.78	Name re-cased Date of birth reformatted City re-cased Email lower-cased+1 more
ENR-115443	ENR	Laura J Jensne	2003-06-19	UHC-27362-06	7623889708	6137 Indian School Rd, Sacramento, CA, 95876	0.78	Phone reformatted City re-cased Email lower-cased Gender normalised+1 more
ENR-139328	ENR	Danielle X Wagner	1991-08-23	UHC-66464-67	7199400785	1644 Valley View Dr, Glendale, AZ, 85399	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
ENR-138344	ENR	Aisha Larson	1949-09-22	UHC-69901-39	2269639602	3250 Broadway, Eden Prairie, MN, 55381	0.78	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed+1 more
ENR-140526	ENR	Melissa Gardner	1985-09-04	UHC-50355-56	2136210689	9792 Broadway, Jacksonville, FL, 32207	0.78	Phone reformatted Address re-cased City re-cased Email lower-cased+1 more
ENR-139845	ENR	Raymond Dixon	1970-08-21	UHC-79273-76	7096924889	4161 Spring St, Dallas, TX, 75294	0.78	Date of birth reformatted Phone reformatted Gender normalised Plan code upper-cased+1 more
ENR-139844	ENR	Raymond Dixon	1970-08-21	UHC-79273-76	7096924889	4161 Spring St, Dallas, TX, 75294	0.78	Date of birth reformatted Phone reformatted Gender normalised Plan code upper-cased+1 more
ENR-127787	ENR	Jeffrey W Jensen	1982-04-16	UHC-43496-38	2345734792	6214 Meadow Ln, Jacksonville, FL, 32215	0.78	Name re-cased Phone reformatted Gender normalised Whitespace trimmed+1 more
ENR-132220	ENR	Angela Schmidt	1954-10-27	UHC-44104-53	5445080270	7539 Canyon Rd, Tempe, AZ, 85245	0.78	Name re-cased City re-cased Gender normalised Whitespace trimmed+1 more
ENR-127596	ENR	Marcus G Parker	2004-07-08	UHC-18040-88	2462355190	9631 River Rd, Mesa, AZ, 85238	0.78	Phone reformatted Member ID reformatted Email lower-cased Gender normalised+1 more
ENR-133583	ENR	Christian X Meyer	1978-02-01	UHC-44347-43	6459699520	5646 Mesa Dr, Dallas, TX, 75260	0.78	Name re-cased Date of birth reformatted Phone reformatted City re-cased+1 more

7,326 rows, page 125 of 147Previous Next