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 “Two-digit birth year”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagTwo-digit birth yearClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-429010	CLM	Andrea Powell	1943-09-24	—	7045051700	7729 Ocean Ave, Dallas, TX, 75267	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-127074	ENR	Samuel Franklin	1992-05-03	UHC-56314-59	5207116506	2707 Washington St, Gilbert, AZ, 85241	0.66	Two-digit birth year Phone reformatted Gender normalised Whitespace trimmed+1 more
PRV-22002	PRV	Bradley Tailor	1977-02-24	UHC-96928-98	6317958677	4774 Meadow Ln, Plano, TX, 75045	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
ENR-131395	ENR	Randy A Washington	2008-03-22	UHC-15953-69	6715731701	3155 Sunset Blvd, Minneapolis, MN, 55489	0.66	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+1 more
ENR-134110	ENR	Margaret I Wright	1950-05-07	UHC-58142-21	6668678621	6152 Central Ave, Minneapolis, MN, 55493	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
CLM-419041	CLM	Martha Moore	2008-06-02	UHC-35380-55	9028019585	511 Baseline Rd, Denver, CO, 80297	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-29436	PRV	Daniel X Pena	1971-01-08	UHC-54987-16	—	7245 Camelback Rd, Miami, FL, 33108	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-425453	CLM	Scott Gibson	2004-06-02	—	—	5853 Lake View Rd, Miami, FL, 33153	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-135423	ENR	Doris Delgado	2008-02-23	UHC-53156-32	8088131526	—	0.66	Name re-cased Two-digit birth year Phone reformatted Gender normalised+1 more
PRV-22281	PRV	Mary M Waver	1981-06-07	—	2983848412	5061 Maple Ave, San Antonio, TX, 78281	0.66	Name re-cased Two-digit birth year State code upper-cased ZIP+4 trimmed+1 more
CLM-424537	CLM	Ben Thomas	2000-07-14	UHC-38480-29	6203420690	1402 Hillcrest Rd, Tempe, AZ, 85248	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-410375	CLM	Arjun Larson	1991-01-24	UHC-89929-24	9854405454	1443 Mesa Dr, Plano, TX	0.66	Two-digit birth year Phone reformatted City re-cased State code upper-cased+1 more
ENR-135184	ENR	Rebecca Castillo	1951-09-27	UHC-84696-29	3837443559	5565 Grand Ave, Los Angeles, CA, 90011	0.66	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+1 more
ENR-122465	ENR	Kayla D Kelly	1939-10-19	UHC-96340-54	8818797443	1673 Harbor Blvd, Fresno, CA, 93741	0.66	Name re-cased Two-digit birth year Phone reformatted State name converted to code+1 more
ENR-104608	ENR	Anna Grant	2008-03-24	UHC-40421-16	7807735515	982 Canyon Rd, Mesa, AZ, 85249	0.66	Name re-cased Two-digit birth year Phone reformatted ZIP+4 trimmed+1 more
ENR-134264	ENR	Kimberly Black	1991-04-16	UHC-70100-89	5787705024	8087 Pine Dr, Tempe, AZ, 85257	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-413841	CLM	Austin Nelson	1974-06-14	—	4704537163	9886 Park Pl, Nashville, TN, 37261	0.66	Name re-cased Two-digit birth year Phone reformatted State name converted to code+1 more
ENR-107030	ENR	Aaron E Pierce	1967-07-04	UHC-65101-06	7818060558	9338 Spring St, Columbus, OH, 43288	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-416100	CLM	Yuki A Marquez	1975-11-13	UHC-38069-86	—	5165 Mountain View Dr, Houston, TX, 77077	0.66	Two-digit birth year City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
ENR-125257	ENR	Sofia G McCoy	1939-12-21	UHC-59505-87	2519864935	5584 Palm Dr, Los Angeles, CA, 90095	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
ENR-141144	ENR	Alice Ross	1947-03-08	UHC-93309-28	9642526427	3281 Church St, Plano, TX, 75020	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-101956	ENR	Brian Q Hansen	1985-12-21	UHC-10706-35	8674125308	2266 Ridge Rd, Glendale, AZ, 85316	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
CLM-425575	CLM	Elijah Lynch	1952-11-08	UHC-37755-50	7864843683	3236 Camelback Rd, Austin, TX, 78748	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-109774	ENR	Amy J Vasuez	1951-04-14	UHC-05827-31	4327580267	5795 Maple Ave, Glendale, AZ, 85335	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
TPA-58848	TPA	Roberts W Henry	1947-04-05	—	—	709 Camelback Rd, Phoenix, AZ, 85059	0.66	Two-digit birth year Street suffix standardised Address re-cased Email lower-cased+1 more
ENR-136337	ENR	Grace Johnston	2008-02-14	UHC-06724-33	3084562016	5768 Jefferson Ave, Fresno, CA, 93759	0.66	Name re-cased Two-digit birth year Phone reformatted State name converted to code+1 more
TPA-53631	TPA	Isabella Williams	2005-12-04	—	—	1402 Maple Ave, Mesa, AZ, 85261	0.66	Name split from “Last, First”Two-digit birth year City re-cased Whitespace trimmed+1 more
CLM-410462	CLM	Joe Lane	1974-01-10	UHC-01685-47	2367518115	1430 Camelback Rd, Austin, TX, 78797	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
ENR-126855	ENR	Jessica Miller	1952-02-08	UHC-28040-04	5825465213	8223 Jefferson Ave, Jacksonville, FL	0.66	Two-digit birth year State code upper-cased ZIP missing Whitespace trimmed+1 more
PRV-28669	PRV	Diane Robinson	1989-02-15	UHC-99457-09	5445453060	6755 Park Pl, Atlanta, GA, 30379	0.66	Two-digit birth year Phone reformatted State name converted to code Whitespace trimmed+1 more
ENR-121103	ENR	Marcus J Tucker	2000-11-21	UHC-60936-79	6069159266	6343 Palm Dr, Austin, TX, 78799	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-120893	ENR	Judy Lawrence	1948-09-20	—	2638051207	5573 Palm Dr, Orlando, FL, 32828	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-105792	ENR	Joyce Q Ran	2008-06-13	UHC-02549-23	3578641578	4345 Pine Dr, Tampa, FL, 33652	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
TPA-53129	TPA	Stephen Ortega	1981-12-09	UHC-46040-53	—	6922 Meadow Ln, Gilbert, AZ, 85224	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
TPA-52435	TPA	Judith Riley	1985-11-28	—	—	2484 Valley View Dr, Columbus, OH, 43247	0.66	Two-digit birth year ZIP+4 trimmed Email lower-cased Whitespace trimmed+1 more
ENR-113344	ENR	Frances J Ramirez	1973-08-18	UHC-00741-74	7795811097	5692 Union St, Charlotte, NC, 28232	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-140465	ENR	Billy X Simpson	1991-09-14	UHC-92126-89	6964475250	3088 Main St, Charlotte, NC, 28242	0.66	Two-digit birth year Member ID reformatted Street suffix standardised Address re-cased+1 more
CLM-400794	CLM	Brittany X Estrada	1967-02-12	—	4737247689	—	0.66	Name re-cased Two-digit birth year Phone reformatted SSN last four extracted+1 more
TPA-63864	TPA	Steve Mason	1947-02-10	—	—	5786 Church St, Austin, TX, 78721	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
ENR-108290	ENR	Santiago Oliver	2001-09-27	UHC-67432-85	7523633157	2408 Church St, Orlando, FL, 32861	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
CLM-431022	CLM	Roneld Yang	1996-10-20	UHC-10472-88	5305122765	3499 Oak St, Phoenix, AZ, 85063	0.66	Name re-cased Two-digit birth year Phone reformatted State name converted to code+1 more
CLM-417265	CLM	Jack Alexaander	1971-04-20	UHC-89498-08	7237404966	—	0.66	Name split from “Last, First”Two-digit birth year Phone reformatted Whitespace trimmed+1 more
ENR-118254	ENR	Harold N Peterson	1991-07-04	UHC-57880-32	5329140412	9190 Camelback Rd, Chandler, AZ, 85275	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-130275	ENR	Cynthia King	1981-07-10	UHC-15784-43	3084654069	386 Mesa Dr, Fresno, CA, 93754	0.66	Two-digit birth year Street suffix standardised Address re-cased Email lower-cased+1 more
PRV-28121	PRV	Barbara Z Barnes	2006-09-12	—	4883656405	—	0.66	Name split from “Last, First”Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-28120	PRV	Barbara Z Barnes	2006-09-12	—	4883656405	—	0.66	Name split from “Last, First”Two-digit birth year Phone reformatted Whitespace trimmed+1 more
ENR-141444	ENR	Roger S Montgomery	1992-03-13	UHC-21317-32	—	7291 Washington St, Denver, CO, 80289	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
PRV-20000	PRV	Laura Alvarado	1939-03-06	—	2082046344	4347 Church St, Plano, TX, 75086	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-26524	PRV	Isabella Kelly	1959-02-25	—	4505933422	2733 Sunset Blvd, Dallas, TX, 75215	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-133736	ENR	Prriya G Jenkins	1953-05-23	UHC-26584-85	2576456307	5771 Hillcrest Rd, Nashville, TN, 37294	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more

6,661 rows, page 85 of 134Previous Next