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
CLM-415014	CLM	Jacob Y Burns	1948-11-14	UHC-30689-30	5763835286	3973 Canyon Rd, Atlanta, GA, 30328	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-414065	CLM	Joshua Griffin	1983-10-16	UHC-65735-65	7497250019	4411 Apache Blvd, Phoenix, AZ, 85006	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-138550	ENR	Donna Cook	1944-02-16	UHC-09751-96	2563339851	599 Washington St, Fresno, CA, 93712	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
CLM-402295	CLM	Julie Fernandez	1978-03-03	UHC-84577-80	—	1216 Desert Sky Blvd, Atlanta, GA, 30382	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
TPA-62035	TPA	Alexander W King	1974-02-01	—	—	2968 Main St, Phoenix, AZ, 85071	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-134929	ENR	Keith Jones	2001-01-08	UHC-44557-83	6936533210	3729 Broadway, Seattle, WA, 98141	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
PRV-28750	PRV	Kyle Contreras	1962-06-10	UHC-17396-44	5368965463	7575 Canyon Rd, Denver, CO, 80251	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-138787	ENR	Alexis N Armstrong	2004-09-05	UHC-43400-99	4566033923	9668 Lincoln Way, Scottsdale, AZ, 85212	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
PRV-23260	PRV	Bruce R Morgan	2006-11-24	UHC-19389-24	3497162438	5416 Camelback Rd, Gilbert, AZ, 85252	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-142861	ENR	Patricia Medina	1951-08-01	UHC-86701-57	6242505102	1703 Bayshore Dr, Gilbert, AZ, 85211	0.82	Phone reformatted City re-cased ZIP+4 trimmed
CLM-403287	CLM	Frances Alvarez	1963-10-24	—	7766880620	9208 Central Ave, Miami, FL, 33130	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-407322	CLM	Black Jean	2006-07-24	UHC-16293-86	—	7087 Lincoln Way, Nashville, TN, 37274	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-104088	ENR	Diego K Jones	1981-07-13	UHC-95688-46	4194872571	3014 Valley View Dr, Fresno, CA, 93746	0.82	Phone reformatted ZIP+4 trimmed Email lower-cased
ENR-110040	ENR	Jakob U Mills	1971-01-05	UHC-03929-94	6163873521	4896 Mountain View Dr, Houston, TX, 77034	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
CLM-418484	CLM	Ruth B Bell	1991-06-20	UHC-51877-99	6492200725	5894 Central Ave, Scottsdale, AZ, 85240	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
CLM-401682	CLM	Abigail Coleman	1951-01-12	—	—	6206 Ridge Rd, Denver, CO, 80291	0.82	City re-cased ZIP+4 trimmed Placeholder values cleared
CLM-420400	CLM	Paul Brooks	1952-10-21	—	—	5911 Lake View Rd, Tucson, AZ, 85762	0.82	State code upper-cased ZIP+4 trimmed Placeholder values cleared
ENR-105331	ENR	Mry B Washington	2007-02-22	UHC-15348-87	6513331242	6707 Willow Ct, Sacramento, CA, 95848	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
CLM-410972	CLM	Sadra X Peterson	1970-06-24	UHC-01975-42	—	9822 Washington St, Los Angeles, CA, 90097	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
TPA-59175	TPA	Diana Burns	2006-11-17	UHC-40188-10	9317421158	2843 Jefferson Ave, Miami, FL, 33120	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-414949	CLM	Randy Singh	1989-05-12	UHC-68184-37	—	9754 Central Ave, Phoenix, AZ, 85000	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-106110	ENR	Arjun F Auztin	1962-11-21	UHC-47172-58	7974787148	1298 Union St, Charlotte, NC, 28274	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-109547	ENR	Paul C Rayn	1986-03-27	UHC-46263-95	8749126902	1573 Lake View Rd, Glendale, AZ, 85328	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-123772	ENR	Kenneth Y Marshall	1977-11-20	UHC-46864-77	3942199966	1786 Willow Ct, Columbus, OH, 43226	0.82	Phone reformatted State code upper-cased ZIP+4 trimmed
CLM-409924	CLM	Russell Marquez	1962-03-11	UHC-20668-29	—	2146 Mesa Dr, Scottsdale, AZ, 85285	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-400732	CLM	Gerald McDonald	1968-02-01	UHC-64585-32	—	4413 Maple Ave, Fresno, CA, 93789	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-126448	ENR	Luis T Kelley	2000-06-18	UHC-29471-91	5329500163	2091 Pine Dr, Eden Prairie, MN, 55377	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-105877	ENR	Wei Gardner	1971-04-01	UHC-94736-96	6495336650	7039 Apache Blvd, Columbus, OH, 43244	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
PRV-29446	PRV	Richard X Hal	1968-05-21	UHC-80730-48	3653793998	1642 Mountain View Dr, Dallas, TX, 75294	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-116562	ENR	Emma Baker	1968-04-15	UHC-96233-40	6517014956	4927 Cedar Ln, Minneapolis, MN, 55446	0.82	Name re-cased ZIP+4 trimmed Whitespace trimmed
ENR-118053	ENR	Philip P Perkins	1985-11-14	UHC-26799-26	3898382283	1318 Spring St, Eden Prairie, MN, 55341	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
ENR-139576	ENR	Jose H Santos	1955-02-12	UHC-79188-27	—	7544 Apache Blvd, Seattle, WA, 98120	0.82	ZIP+4 trimmed Email lower-cased Whitespace trimmed
CLM-432471	CLM	Kyle Medina	1968-11-28	UHC-64058-26	—	2454 Canyon Rd, Dallas, TX, 75246	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-135277	ENR	Andrea Harper	1989-01-06	UHC-76420-19	5717521596	8990 Spring St, Fresno, CA, 93771	0.82	Name re-cased ZIP+4 trimmed Email lower-cased
ENR-122079	ENR	Lori J Cruz	1990-04-25	UHC-87156-17	9102112334	6582 Sage Ct, Eden Prairie, MN, 55387	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-114764	ENR	Donald V Russell	1974-02-22	UHC-63213-46	7492927220	5913 Maple Ave, Houston, TX, 77046	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
CLM-429141	CLM	Carl Gibson	1986-02-04	UHC-12791-74	3082058233	1931 Camelback Rd, Jacksonville, FL, 32236	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-117554	ENR	Jesse R Richards	1969-03-05	UHC-63467-74	7083178157	1959 Lincoln Way, Las Vegas, NV, 89135	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-112728	ENR	Roy N Hall	1952-10-16	—	9535140397	6334 Apache Blvd, San Antonio, TX, 78254	0.82	City re-cased ZIP+4 trimmed Whitespace trimmed
CLM-416263	CLM	Brandon R Garcia	1945-12-04	UHC-75549-84	—	3377 Lincoln Way, San Antonio, TX, 78271	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-128978	ENR	Eric Q Hudson	2008-12-03	UHC-87974-59	7305204618	8745 Church St, Minneapolis, MN, 55422	0.82	Name re-cased Date of birth reformatted ZIP+4 trimmed
PRV-25960	PRV	Bryan King	1960-11-11	UHC-04101-99	—	3073 Canyon Rd, Fresno, CA, 93761	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-408294	CLM	Deborah Alverado	2006-02-04	UHC-58614-80	4996656349	5707 Oak St, Nashville, TN, 37245	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-414170	CLM	Mateo Wight	1949-05-26	UHC-17285-52	7998977123	4302 Harbor Blvd, Columbus, OH, 43234	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-414242	CLM	Gabriel Roberts	1981-03-20	UHC-70715-12	—	5611 Maple Ave, Nashville, TN, 37233	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-133686	ENR	Douglas Stewart	2006-06-14	UHC-18830-70	5327393624	7629 Church St, Glendale, AZ, 85353	0.82	Name re-cased ZIP+4 trimmed Email lower-cased
ENR-110360	ENR	Yuki Rojjas	1960-01-25	UHC-45614-98	2382544713	3162 Grand Ave, Seattle, WA, 98181	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
CLM-424750	CLM	Julia Murphy	2005-01-03	UHC-12257-62	6847912313	752 Palm Dr, Scottsdale, AZ, 85274	0.82	Name re-cased Phone reformatted ZIP+4 trimmed
ENR-142343	ENR	Linda Moore	1987-03-21	UHC-02600-33	2973162996	4891 Lincoln Way, San Antonio, TX, 78230	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-135191	ENR	Kathryn Payne	1988-12-19	UHC-12324-03	8638248181	7108 Canyon Rd, Mesa, AZ, 85289	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed

8,263 rows, page 159 of 166Previous Next