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-428067	CLM	Jason Hunt	1963-12-08	—	—	3113 Park Pl, Tempe, AZ, 85216	0.82	Two-digit birth year Email lower-cased Placeholder values cleared
PRV-26813	PRV	Judy Gordon	1970-11-01	UHC-42219-38	4996647707	6485 Market St, San Antonio, TX, 78232	0.84	Two-digit birth year Placeholder values cleared
CLM-417994	CLM	Adam Lewis	1977-05-17	UHC-06334-32	—	—	0.84	Two-digit birth year Placeholder values cleared
ENR-108470	ENR	Henry A Dixon	2006-04-03	UHC-32289-04	9067851505	6125 Broadway, Charlotte, NC, 28258	0.84	Two-digit birth year Phone reformatted
CLM-410716	CLM	Ahmed D Jacobs	1982-06-07	UHC-99057-32	—	1326 Lincoln Way, Plano, TX, 75070	0.84	Two-digit birth year Placeholder values cleared
TPA-55629	TPA	Matthew Phillips	1974-09-16	—	—	—	0.84	Two-digit birth year Placeholder values cleared
TPA-63440	TPA	Matthew Ellis	1967-12-06	—	—	—	0.84	Two-digit birth year Placeholder values cleared
CLM-430009	CLM	Tyler G Moreno	1992-10-28	—	—	—	0.84	Two-digit birth year Placeholder values cleared
CLM-405759	CLM	Diego Hanson	2000-08-03	UHC-59842-53	—	3400 Broadway, Mesa, AZ, 85275	0.84	Two-digit birth year Placeholder values cleared
CLM-414908	CLM	Maria Warren	1939-08-17	UHC-52031-57	—	7583 Market St, Plano, TX, 75028	0.84	Two-digit birth year Placeholder values cleared
TPA-58698	TPA	Virginia Delgado	1965-02-23	—	6779327801	7260 Union St, Sacramento, CA, 95836	0.84	Two-digit birth year Placeholder values cleared
CLM-419435	CLM	Jon Q Silva	2006-05-10	—	—	8190 Cedar Ln, Fresno, CA, 93752	0.84	Two-digit birth year Placeholder values cleared
CLM-413953	CLM	Joyce Reyes	2008-12-04	—	5382203546	1156 Broadway, Dallas, TX, 75299	0.84	Two-digit birth year Placeholder values cleared
CLM-426185	CLM	Alexander Chavez	1961-04-07	—	6903660817	—	0.84	Two-digit birth year Placeholder values cleared
CLM-415883	CLM	Zachary Rogers	1980-11-20	UHC-85497-87	—	4290 Ridge Rd, Eden Prairie, MN, 55310	0.84	Name re-cased Two-digit birth year
ENR-100938	ENR	Elizabeth Wilson	1957-02-10	UHC-61515-34	9185026324	3145 Desert Sky Blvd, Phoenix, AZ, 85002	0.84	Two-digit birth year Phone reformatted
CLM-420727	CLM	Cynthia Hill	2006-08-21	UHC-85055-61	2036047667	3680 Indian School Rd, Tucson, AZ, 85754	0.84	Two-digit birth year Placeholder values cleared
ENR-133119	ENR	Ana Warren	1963-01-25	UHC-07289-96	8985272346	4132 Hillcrest Rd, Chandler, AZ, 85225	0.84	Two-digit birth year Email lower-cased
TPA-62236	TPA	Peter R Brooks	1989-05-13	—	2624929134	—	0.84	Two-digit birth year Placeholder values cleared
CLM-424656	CLM	Frank Washington	1978-07-08	UHC-91228-72	—	—	0.84	Two-digit birth year Placeholder values cleared
TPA-51916	TPA	Denise Phillips	1994-05-27	—	—	8538 Spring St, Dallas, TX, 75212	0.84	Two-digit birth year Placeholder values cleared
ENR-130398	ENR	Jorddan Harrizon	1955-07-07	UHC-94211-97	6967032824	9049 Grand Ave, Minneapolis, MN, 55416	0.84	Two-digit birth year Phone reformatted
TPA-60103	TPA	Brittany Alexander	1988-01-14	—	—	7028 Lincoln Way, Glendale, AZ, 85361	0.84	Two-digit birth year Placeholder values cleared
CLM-427090	CLM	Jim Banks	1999-03-22	UHC-39366-98	—	5022 Baseline Rd, Atlanta, GA, 30342	0.84	Two-digit birth year Placeholder values cleared
CLM-427091	CLM	Jim Banks	1999-03-22	UHC-39366-98	—	5022 Baseline Rd, Atlanta, GA, 30342	0.84	Two-digit birth year Placeholder values cleared
ENR-138934	ENR	Madison U Franklin	1975-01-16	UHC-89354-81	2728366963	6733 Oak St, Tucson, AZ, 85711	0.84	Two-digit birth year Phone reformatted
ENR-106829	ENR	Kimberly N Oliver	2008-04-05	UHC-97879-20	6694709487	1498 Hillcrest Rd, San Antonio, TX, 78244	0.84	Two-digit birth year Phone reformatted
CLM-413612	CLM	Beverly Elliott	1993-12-28	UHC-59781-23	—	4808 Lincoln Way, Minneapolis, MN, 55464	0.84	Two-digit birth year Placeholder values cleared
ENR-130531	ENR	Samantha I Medina	1972-06-18	UHC-82189-05	7447157679	2419 Camelback Rd, Fresno, CA, 93767	0.84	Two-digit birth year Whitespace trimmed
CLM-409499	CLM	Russell Larson	1983-05-13	—	—	2777 Desert Sky Blvd, Orlando, FL, 32876	0.84	Two-digit birth year Placeholder values cleared
TPA-58309	TPA	Billy Austin	1992-05-22	—	8977240676	—	0.84	Two-digit birth year Placeholder values cleared
TPA-58308	TPA	Billy Austin	1992-05-22	—	8977240676	—	0.84	Two-digit birth year Placeholder values cleared
CLM-430152	CLM	Joe Rojas	1982-01-06	UHC-25331-20	8514202582	—	0.84	Two-digit birth year Placeholder values cleared
TPA-59184	TPA	Dennis Rivera	1996-06-18	—	—	—	0.84	Two-digit birth year Placeholder values cleared
TPA-59185	TPA	Dennis Rivera	1996-06-18	—	—	—	0.84	Two-digit birth year Placeholder values cleared
TPA-54390	TPA	Fatima Simmons	1999-03-09	UHC-08560-99	—	388 Church St, Columbus, OH, 43239	0.84	Two-digit birth year Placeholder values cleared
TPA-54300	TPA	Christian Lynch	1948-12-03	UHC-37248-01	—	8524 Bayshore Dr, Austin, TX, 78716	0.84	Two-digit birth year Placeholder values cleared
CLM-410249	CLM	Virginia Hayes	1943-10-14	UHC-15953-18	—	—	0.84	Two-digit birth year Placeholder values cleared
CLM-422901	CLM	Dorothy C Price	2007-01-05	—	—	1418 Sunset Blvd, San Diego, CA, 92153	0.84	Two-digit birth year Placeholder values cleared
CLM-429046	CLM	Martha N Herrera	1956-06-01	UHC-70389-89	—	—	0.84	Two-digit birth year Placeholder values cleared
ENR-110638	ENR	Thomas Espinoza	1980-07-04	UHC-83698-81	—	8979 Market St, Eden Prairie, MN, 55302	0.84	Name re-cased Two-digit birth year
PRV-27734	PRV	Nicholas Arnold	1982-05-18	UHC-60710-65	—	6306 Indian School Rd, Gilbert, AZ, 85226	0.84	Two-digit birth year Placeholder values cleared
ENR-101982	ENR	Christine Snyder	1989-08-27	UHC-44691-78	5494319437	4544 Park Pl, Minneapolis, MN, 55485	0.84	Two-digit birth year Placeholder values cleared
CLM-425002	CLM	Victoria Graham	1950-09-24	UHC-99148-14	—	—	0.84	Two-digit birth year Placeholder values cleared
TPA-54177	TPA	Ryan Evans	1974-02-07	—	6479882680	1580 Sunset Blvd, San Diego, CA, 92191	0.84	Two-digit birth year Placeholder values cleared
CLM-412811	CLM	Mei Jordan	1986-12-06	UHC-15729-08	3086820790	—	0.84	Two-digit birth year Placeholder values cleared
TPA-53226	TPA	Debra Bryant	1997-02-27	UHC-21572-64	7429382378	2076 Ocean Ave, Dallas, TX, 75226	0.84	Two-digit birth year Placeholder values cleared
ENR-120249	ENR	Jennifer Hansen	1966-04-08	UHC-70639-44	9743715662	5187 Main St, Atlanta, GA, 30345	0.84	Two-digit birth year Phone reformatted
ENR-137278	ENR	Camila X Hill	1967-06-27	UHC-12011-96	4043415428	8268 Broadway, Los Angeles, CA, 90079	0.84	Two-digit birth year Phone reformatted
PRV-20225	PRV	Ronald Perez	1980-01-07	—	—	3180 Elm St, Charlotte, NC, 28284	0.84	Two-digit birth year Placeholder values cleared

6,661 rows, page 130 of 134Previous Next