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 “City re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagCity re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-104121	ENR	Gabriel Yang	1960-04-14	UHC-81771-20	8706604064	1130 Elm St, Columbus, OH, 43210	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-129785	ENR	Julie Weaver	1977-09-06	UHC-93830-13	6393797090	5059 Meadow Ln, Nashville, TN, 37215	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
ENR-133838	ENR	Raymond Jensen	1941-11-21	UHC-82400-68	3189681233	8761 Spring St, San Antonio, TX, 78215	0.78	Name re-cased Two-digit birth year Phone reformatted City re-cased+1 more
ENR-122597	ENR	Kimberly Gilbert	1966-09-27	UHC-95289-73	7165795307	5501 Baseline Rd, Phoenix, AZ, 85013	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
ENR-124289	ENR	Sean B Hill	1983-04-06	UHC-68299-26	9823463161	6891 Camelback Rd, Gilbert, AZ, 85282	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-142230	ENR	Benjamin Cooper	1968-06-14	UHC-69545-33	4894411550	5419 Market St, Houston, TX, 77041	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-141705	ENR	Dennis Hart	1980-01-06	UHC-45131-07	2576984525	8743 Maple Ave, Mesa, AZ, 85254	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-110656	ENR	Nancy Moralees	2004-10-22	UHC-83703-84	8393092767	6401 Ridge Rd, Dallas, TX, 75268	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
ENR-104295	ENR	Harvey Judy	1961-05-25	UHC-36773-55	9042981881	6205 Highland Ave, San Antonio, TX, 78210	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-116379	ENR	Elizabeth Shaw	1951-01-16	UHC-97264-88	3456900956	4539 Oak St, Gilbert, AZ, 85281	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
ENR-114276	ENR	Roy Castro	1971-05-21	UHC-85114-63	6319293569	5710 Union St Apt 27, Tempe, AZ, 85274	0.78	Phone reformatted Unit split from street City re-cased Whitespace trimmed+1 more
ENR-105334	ENR	Jacqueline G Black	1989-08-17	UHC-52048-14	—	3673 Apache Blvd, Tucson, AZ, 85721	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
ENR-114507	ENR	Pamela Jaocbs	1988-02-02	UHC-33484-83	2092684970	3967 Highland Ave, Atlanta, GA, 30382	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
ENR-103654	ENR	Laura D Castro	1938-03-14	UHC-77112-55	5952297186	5820 Ridge Rd, Fresno, CA, 93740	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-121424	ENR	Hannah Porter	2007-10-26	UHC-06283-41	6189332176	2195 Mesa Dr, Eden Prairie, MN, 55380	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-108316	ENR	Frank Guzman	2006-10-09	UHC-66444-28	4383180685	1500 Spring St, Fresno, CA, 93723	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-132077	ENR	Brdley Q Barnes	1986-01-18	UHC-02728-80	6305500274	1932 Spring St, Glendale, AZ, 85338	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-120572	ENR	Cheryl K Nunez	1974-03-17	UHC-63912-51	8004872922	3118 Elm St, Scottsdale, AZ, 85255	0.78	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-140961	ENR	Terry Y Williams	1939-10-17	UHC-02175-32	—	2679 Ocean Ave, Glendale, AZ, 85377	0.78	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-102400	ENR	Madison T Greene	1958-03-25	UHC-55189-28	2765843345	6827 Ridge Rd, Jacksonville, FL, 32217	0.78	Street suffix standardised Address re-cased City re-cased State code upper-cased+1 more
ENR-134919	ENR	Anthoyn Martin	1979-08-27	UHC-09874-88	6805453420	1285 Desert Sky Blvd, Denver, CO, 80230	0.78	Member ID reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-110667	ENR	Ryan G Richards	1980-05-09	UHC-91216-27	7378308796	8087 Mesa Dr, Seattle, WA, 98141	0.78	Name re-cased Phone reformatted SSN last four extracted City re-cased+1 more
ENR-103105	ENR	Zachary K Ryan	1986-02-13	UHC-70445-91	—	9018 Forest Ave, Sacramento, CA, 95803	0.78	Middle initial moved out of first name Name re-cased City re-cased State code upper-cased+1 more
ENR-108120	ENR	Amanda Robertson	1964-07-04	UHC-15760-50	—	3885 Mountain View Dr, Fresno, CA, 93769	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-122360	ENR	Ruth P Ross	1973-06-03	UHC-15276-51	7468187777	4968 Lincoln Way, Chandler, AZ, 85285	0.78	Name re-cased Phone reformatted City re-cased Email lower-cased+1 more
ENR-116472	ENR	Brittany Wagner	1999-02-15	UHC-40956-45	7233111566	4872 Spring St, Eden Prairie, MN, 55334	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
ENR-126568	ENR	Marcus N Scott	—	UHC-30501-14	4264386988	2335 Lincoln Way, Minneapolis, MN, 55428	0.78	Date of birth unreadable Phone reformatted City re-cased Email lower-cased+1 more
ENR-133827	ENR	Peter Salazar	1947-05-03	UHC-64006-03	5023945347	4304 Palm Dr Apt 26, Fresno, CA, 93767	0.78	Name re-cased Phone reformatted Unit split from street City re-cased+1 more
ENR-143060	ENR	Mary T Mejia	1954-04-14	UHC-11103-64	—	685 Apache Blvd, Fresno, CA, 93757	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
ENR-122732	ENR	Martha Foster	1963-04-15	UHC-91764-99	2094991159	539 Church St, Nashville, TN, 37292	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-139672	ENR	Sofiia W Cox	1940-12-01	UHC-15827-26	—	3326 Apache Blvd, Orlando, FL, 32877	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
ENR-128187	ENR	Brittany O Medina	1995-11-10	UHC-89886-23	—	8502 Baseline Rd, Glendale, AZ, 85311	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
ENR-114253	ENR	Thomas Luna	1986-04-10	UHC-64102-71	8902543970	3916 Bayshore Dr, Houston, TX, 77025	0.78	Name re-cased Phone reformatted City re-cased Gender normalised+1 more
ENR-132181	ENR	Cynthia Ortiz	1955-08-07	UHC-34269-99	4795593902	572 Church St, Austin, TX, 78767	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-119384	ENR	Angela A Perkins	1940-06-04	UHC-30106-31	2719971511	4170 Oak St, Plano, TX, 75017	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-113162	ENR	Stephen W McCoy	1976-03-10	UHC-00347-08	4637524888	8878 Market St, Scottsdale, AZ, 85260	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-135946	ENR	Rachel Y Li	1938-12-01	UHC-49940-99	6579301489	4340 Sunset Blvd, Austin, TX, 78782	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-109199	ENR	Danielle P Elliott	1987-11-06	UHC-10138-47	4158089417	5017 Indian School Rd # 665, Miami, FL, 33123	0.78	Name re-cased Phone reformatted Unit split from street City re-cased+1 more
ENR-121935	ENR	Douglas A Vargas	1955-09-10	UHC-95650-14	6314164479	750 Broadway, Minneapolis, MN, 55459	0.78	Two-digit birth year Phone reformatted Member ID reformatted City re-cased+1 more
ENR-132320	ENR	Harold M Rios	—	UHC-13868-34	4829563325	2214 Harbor Blvd, Minneapolis, MN, 55447	0.78	Name re-cased Date of birth missing Phone reformatted City re-cased+1 more
ENR-116491	ENR	Jonathan B Parker	1952-09-07	UHC-53297-26	6466498212	8769 Lincoln Way, Seattle, WA	0.78	Date of birth reformatted Phone reformatted City re-cased ZIP missing+1 more
ENR-124507	ENR	Anthony T Fields	2004-11-14	UHC-31856-02	—	5227 Highland Ave, Jacksonville, FL, 32263	0.78	Date of birth reformatted Phone missing area code City re-cased Email lower-cased+1 more
ENR-122933	ENR	Barbara Garza	1956-04-08	UHC-78040-18	7346384799	8705 Ocean Ave, Atlanta, GA, 30306	0.78	Street suffix standardised Address re-cased City re-cased Email lower-cased+1 more
ENR-101549	ENR	Denise Walker	1955-11-04	UHC-80410-94	—	8205 Baseline Rd, Jacksonville, FL, 32273	0.78	Name re-cased Date of birth reformatted Phone missing area code City re-cased+1 more
ENR-117110	ENR	Rachel Black	1956-03-05	UHC-66404-42	2892199884	1861 Elm St, Tempe, AZ, 85218	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-132182	ENR	Stephen E Soto	1957-10-24	UHC-38096-98	3472630417	422 Indian School Rd, Austin, TX, 78749	0.78	Name re-cased City re-cased State name converted to code Whitespace trimmed+1 more
ENR-120760	ENR	Carlos D Aguilar	1938-04-25	UHC-69492-79	5543671973	9373 Maple Ave, Nashville, TN, 37250	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-107297	ENR	Wlter M Chavez	1969-02-03	UHC-84604-12	8527157445	4549 Market St, Gilbert, AZ, 85204	0.78	Phone reformatted City re-cased State name converted to code Whitespace trimmed+1 more
ENR-110860	ENR	Arjun Myers	2000-10-19	UHC-91783-29	4728916029	8649 Meadow Ln, Mesa, AZ, 85290	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-134927	ENR	Lawrence Wallace	1975-10-13	UHC-34334-90	8466865142	9318 Elm St # 726, Nashville, TN, 37237	0.78	Name re-cased Phone reformatted Unit split from street City re-cased+1 more

8,423 rows, page 117 of 169Previous Next