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-110876	ENR	Jeffrey E Bishop	1993-10-15	UHC-13468-44	—	1127 Apache Blvd, Phoenix, AZ, 85052	0.70	Name re-cased Phone missing area code ZIP+4 trimmed
CLM-424716	CLM	Daniel Jordan	1970-02-07	—	—	2166 Mountain View Dr, Plano, TX, 75015	0.70	State name converted to code ZIP+4 trimmed Placeholder values cleared
CLM-412702	CLM	Abby U Alexander	1940-03-04	—	—	6190 Indian School Rd, Atlanta, GA, 30392	0.70	Name split from “Last, First”ZIP+4 trimmed Whitespace trimmed
PRV-21153	PRV	Ryan Jimenez	1955-06-10	—	—	2708 Forest Ave, Denver, CO, 80294	0.70	ZIP+4 trimmed Gender normalised Placeholder values cleared
ENR-118089	ENR	Sean Andrews	1961-10-20	UHC-41599-44	5742116430	6743 Highland Ave, Denver, CO, 80239	0.70	Name split from “Last, First”ZIP+4 trimmed Whitespace trimmed
ENR-109973	ENR	Lori Washington	—	UHC-14542-78	8363052813	5031 Hillcrest Rd, Nashville, TN, 37269	0.70	Date of birth unreadable Phone reformatted ZIP+4 trimmed
ENR-110561	ENR	Ahmed S Valdez	1960-03-02	UHC-83725-88	3514082872	4339 Elm St, Seattle, WA, 98159	0.70	Name split from “Last, First”ZIP+4 trimmed Placeholder values cleared
CLM-431598	CLM	Beverly Q Schultz	1981-07-09	UHC-83728-87	—	627 Highland Ave, Dallas, TX, 75261	0.70	Name re-cased Two-digit birth year ZIP+4 trimmed
ENR-130940	ENR	Mei Gaorge	1968-04-10	UHC-01431-93	—	9607 Pine Dr, Plano, TX, 75050	0.70	Street suffix standardised Address re-cased ZIP+4 trimmed
CLM-415810	CLM	Steven Boyd	1944-08-08	—	9865662211	3000 Mesa Dr, San Diego, CA, 92100	0.70	Name split from “Last, First”ZIP+4 trimmed Placeholder values cleared
TPA-50616	TPA	Yuki Green	1907-08-13	—	—	6180 Jefferson Ave, San Antonio, TX, 78223	0.70	Name split from “Last, First”ZIP+4 trimmed Placeholder values cleared
ENR-112362	ENR	Theresa F Ferguson	1971-08-02	UHC-72869-72	8169818524	4160 Harbor Blvd, Dallas, TX, 75223	0.70	Phone reformatted ZIP+4 trimmed Gender normalised
CLM-418714	CLM	Austin S Smmith	2007-09-13	UHC-95971-84	—	8639 Lincoln Way, Jacksonville, FL, 32272	0.70	Name split from “Last, First”ZIP+4 trimmed Placeholder values cleared
ENR-124774	ENR	Bruce Nichols	1996-11-06	UHC-20624-46	4215011526	7232 Forest Ave, Mesa, AZ, 85236	0.70	Name split from “Last, First”Phone reformatted ZIP+4 trimmed
ENR-117572	ENR	Sara Hicks	1993-01-17	UHC-61863-88	8347243767	9732 Forest Ave, Minneapolis, MN, 55485	0.70	Name split from “Last, First”ZIP+4 trimmed Whitespace trimmed
CLM-411750	CLM	Jessica Jones	1976-11-17	—	—	371 Meadow Ln, Glendale, AZ, 85346	0.70	Name split from “Last, First”ZIP+4 trimmed Placeholder values cleared
ENR-131520	ENR	Judy W Watkins	1973-04-08	UHC-12017-24	7947686283	5633 Market St, Columbus, OH, 43270	0.70	Street suffix standardised Address re-cased ZIP+4 trimmed
ENR-128122	ENR	Lauren Contreras	1939-12-12	UHC-26709-23	8176600218	1656 Sage Ct, Eden Prairie, MN, 55363	0.70	Name split from “Last, First”City re-cased ZIP+4 trimmed
ENR-121838	ENR	Ronald Mejia	2006-03-14	UHC-87089-23	—	7266 Union St, Minneapolis, MN, 55464	0.70	Phone missing area code State code upper-cased ZIP+4 trimmed
ENR-139353	ENR	Judy U Gilbert	1953-02-10	UHC-46353-24	8299543068	5640 Apache Blvd, Glendale, AZ, 85352	0.70	Street suffix standardised Address re-cased ZIP+4 trimmed
ENR-137545	ENR	Donald V Gomez	1938-04-07	UHC-17486-80	6138443660	6300 Ocean Ave, Plano, TX, 75011	0.70	Street suffix standardised Address re-cased ZIP+4 trimmed
ENR-115982	ENR	Santiago W Kalley	1984-08-10	UHC-71672-31	5854394556	7157 Grand Ave, Denver, CO, 80205	0.70	Street suffix standardised Address re-cased ZIP+4 trimmed
TPA-54456	TPA	Nancy Lynch	1970-02-10	—	—	1365 Spring St, Denver, CO, 80289	0.70	Name split from “Last, First”ZIP+4 trimmed Placeholder values cleared
CLM-431954	CLM	Maria Davis	1980-04-07	UHC-91962-84	—	7357 Apache Blvd, Mesa, AZ, 85275	0.70	Name split from “Last, First”ZIP+4 trimmed Placeholder values cleared
ENR-141233	ENR	Gabriel Y Arnold	1960-03-04	UHC-31163-02	—	1148 Canyon Rd, San Antonio, TX, 78263	0.70	Name split from “Last, First”Member ID reformatted ZIP+4 trimmed
TPA-59963	TPA	Wei Morris	1970-02-14	—	—	9555 Central Ave, Mesa, AZ, 85253	0.70	Name split from “Last, First”ZIP+4 trimmed Placeholder values cleared
CLM-411036	CLM	Arjun C Schmidt	1992-12-03	UHC-24941-46	—	1003 Indian School Rd, Mesa, AZ, 85221	0.70	Street suffix standardised Address re-cased ZIP+4 trimmed
ENR-114187	ENR	Donald Harper	1986-05-26	UHC-09895-90	—	2871 Market St, Dallas, TX, 75290	0.70	SSN last four extracted ZIP+4 trimmed Placeholder values cleared
ENR-117159	ENR	Tim I Davis	1974-07-13	UHC-35325-43	6834310841	3754 Meadow Ln, Nashville, TN, 37260	0.70	Phone reformatted ZIP+4 trimmed Gender normalised
ENR-117160	ENR	Tim I Davis	1974-07-13	UHC-35325-43	6834310841	3754 Meadow Ln, Nashville, TN, 37260	0.70	Phone reformatted ZIP+4 trimmed Gender normalised
ENR-110246	ENR	Dorothy Larson	1974-12-22	UHC-60255-14	7487780027	554 Market St, Miami, FL, 33164	0.70	Name re-cased ZIP+4 trimmed Gender normalised
PRV-22368	PRV	Yuki Dominguez	1982-09-13	—	5733552265	2794 Camelback Rd, Nashville, TN, 37291	0.70	ZIP+4 trimmed Gender normalised Placeholder values cleared
CLM-431358	CLM	Dylan Morrison	1948-06-26	UHC-76007-54	6839591610	368 Apache Blvd, Columbus, OH, 43231	0.70	Street suffix standardised Address re-cased ZIP+4 trimmed
TPA-59235	TPA	Ruth Mills	2005-05-13	—	—	6713 Market St, Tampa, FL, 33618	0.70	Two-digit birth year ZIP+4 trimmed Placeholder values cleared
ENR-103141	ENR	Natalie Howell	1950-03-28	UHC-74422-60	6915246600	5416 Jefferson Ave, Tempe, AZ, 85207	0.70	Date of birth reformatted ZIP+4 trimmed Gender normalised
ENR-113589	ENR	Debra G Green	2007-10-20	UHC-25289-02	3599133461	4502 Spring St, Miami, FL, 33199	0.70	Phone reformatted ZIP+4 trimmed Gender normalised
ENR-112515	ENR	Adam Garrett	1986-12-01	UHC-27878-40	—	1633 Palm Dr, Los Angeles, CA, 90078	0.70	Name split from “Last, First”Date of birth reformatted ZIP+4 trimmed
TPA-51580	TPA	Elijah Stephens	1960-12-16	—	—	6193 Cedar Ln Apt 5, Eden Prairie, MN, 55393	0.70	Unit split from street ZIP+4 trimmed Placeholder values cleared
ENR-129856	ENR	Terry Walsh	1960-07-19	UHC-43582-43	8695095746	1234 Desert Sky Blvd Apt 22, Los Angeles, CA, 90071	0.70	Phone reformatted Unit split from street ZIP+4 trimmed
ENR-108950	ENR	Abby T Mason	2003-07-27	UHC-12071-84	2627423699	851 Baseline Rd, Charlotte, NC, 28284	0.70	Phone reformatted ZIP+4 trimmed Gender normalised
CLM-402004	CLM	YJunk	1982-06-16	UHC-02972-27	—	2654 Cedar Ln, Minneapolis, MN, 55448	0.70	ZIP+4 trimmed Placeholder values cleared No usable name (quarantined)
ENR-119527	ENR	George M Bell	2008-02-09	UHC-61073-83	2425028549	3580 Spring St, Seattle, WA, 98150	0.70	City re-cased ZIP+4 trimmed Gender normalised
TPA-62573	TPA	Jessica Welch	1952-01-27	—	—	1213 Apache Blvd Apt 9, Dallas, TX, 75284	0.70	Unit split from street ZIP+4 trimmed Placeholder values cleared
ENR-102148	ENR	Mariana Y Hill	1943-09-18	UHC-13011-56	6812160391	9584 Forest Ave # 979, Fresno, CA, 93735	0.70	Phone reformatted Unit split from street ZIP+4 trimmed
CLM-424777	CLM	Arjun Meyer	2002-05-20	UHC-42340-66	6435950351	5146 Valley View Dr, Mesa, AZ, 85235	0.70	ZIP+4 trimmed Gender normalised Placeholder values cleared
ENR-138174	ENR	Santiago Stone	2008-06-10	UHC-50353-26	3094994208	1723 Cedar Ln, Houston, TX, 77084	0.70	Phone reformatted ZIP+4 trimmed Gender normalised
ENR-112944	ENR	Sophia Gonzalez	1998-01-12	UHC-90248-76	5418341547	4231 Highland Ave Apt 31, Scottsdale, AZ, 85227	0.70	Phone reformatted Unit split from street ZIP+4 trimmed
ENR-131883	ENR	Mariana V Stewart	1984-05-09	UHC-55215-31	6614925969	4958 Indian School Rd, Houston, TX, 77056	0.70	Middle initial moved out of first name Name re-cased ZIP+4 trimmed
ENR-101094	ENR	Adaam Z Stone	1969-12-25	UHC-32837-02	9523393032	4674 Ridge Rd, Charlotte, NC, 28272	0.70	Two-digit birth year ZIP+4 trimmed Placeholder values cleared
ENR-128670	ENR	Catherine Peterson	1954-08-10	UHC-33326-02	6258836765	4080 Canyon Rd, Phoenix, AZ, 85057	0.70	Two-digit birth year ZIP+4 trimmed Whitespace trimmed

8,263 rows, page 132 of 166Previous Next