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

All ENR CLM TPA PRV

Junk onlyFlagName re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-112610	ENR	Dylan C Chavez	2008-12-20	UHC-14686-27	2919792579	816 Broadway, Plano, TX, 75096	0.66	Name re-cased Two-digit birth year Phone reformatted Gender normalised+1 more
ENR-126997	ENR	Bradley J Foster	1992-10-12	UHC-61179-72	3692183356	7079 Washington St Apt 1, Los Angeles, CA, 90063	0.66	Name re-cased Phone reformatted Unit split from street Street suffix standardised+1 more
ENR-142585	ENR	Grace McDonald	1987-08-11	UHC-33009-48	2779075625	5506 Maple Ave, Tucson, AZ, 85742	0.66	Name re-cased Two-digit birth year Member ID reformatted Street suffix standardised+1 more
ENR-120410	ENR	Lisa Wang	1961-01-10	UHC-01264-90	3148895342	5726 Indian School Rd Apt 14, Scottsdale, AZ, 85282	0.66	Name re-cased Phone reformatted Unit split from street ZIP+4 trimmed+1 more
ENR-119311	ENR	Frank Q Walker	1952-01-25	UHC-33096-95	7333134220	9876 Spring St, Mesa, AZ, 85228	0.66	Middle initial moved out of first name Name re-cased Street suffix standardised Address re-cased+1 more
ENR-116926	ENR	Judy Ortega	1964-10-09	UHC-01762-01	9313430829	75 Union St, Denver, CO, 80241	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-142747	ENR	Mark V Vazquez	1989-09-24	UHC-24042-15	—	1533 Mesa Dr, Atlanta, GA, 30358	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
ENR-129691	ENR	Sean I Watkins	1968-09-15	UHC-94342-84	—	3719 Lake View Rd # 288, Plano, TX	0.66	Name re-cased Unit split from street ZIP missing Whitespace trimmed+1 more
ENR-123760	ENR	Doris McCoy	1981-04-13	UHC-54370-10	9705001581	2699 Central Ave, Nashville, TN, 37205	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-105316	ENR	Danielle P Lynch	2000-02-09	UHC-65454-97	3177249878	1905 Elm St, Minneapolis, MN, 55432	0.66	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
ENR-119027	ENR	Katherine Burns	2004-08-23	UHC-07667-23	3633841347	2972 Palm Dr, Orlando, FL, 32874	0.66	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+1 more
ENR-117491	ENR	Michael Anderson	1946-08-12	UHC-73052-29	9392107782	1918 Palm Dr, Phoenix, AZ, 85056	0.68	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed
ENR-100881	ENR	Ruuth Miller	—	UHC-03583-56	5207015238	1269 Canyon Rd, Sacramento, CA, 95879	0.68	Name re-cased Date of birth missing Street suffix standardised Address re-cased
ENR-126599	ENR	Melissa I Gibson	1965-07-09	UHC-50376-45	—	9252 Mesa Dr, Mesa, AZ, 85294	0.68	Name re-cased Date of birth reformatted Phone missing area code ZIP+4 trimmed
ENR-141084	ENR	Stephanie Brown	1980-11-02	UHC-58523-40	6625605636	7753 Desert Sky Blvd Apt 1, Jacksonville, FL, 32297	0.68	Name re-cased Phone reformatted Unit split from street Gender normalised
ENR-136012	ENR	Bryan N Jenkins	1970-10-13	UHC-92838-28	—	8592 Grand Ave, Miami, FL, 33197	0.68	Name re-cased Phone missing area code Street suffix standardised Address re-cased
ENR-140006	ENR	Morrison Hannah	1983-07-12	UHC-56979-48	4438803052	3111 Grand Ave, Austin, TX, 78728	0.68	Name re-cased Street suffix standardised Address re-cased State name converted to code
ENR-134685	ENR	Margaret F Weaver	1989-04-17	UHC-13952-43	—	3370 Mountain View Dr, Phoenix, AZ, 85092	0.68	Name re-cased Two-digit birth year Gender normalised Placeholder values cleared
ENR-122467	ENR	Keeith Reyonlds	1952-02-17	UHC-80661-55	—	1564 Broadway, Seattle, WA, 98136	0.68	Name re-cased Phone missing area code City re-cased Gender normalised
ENR-128969	ENR	Diana J Mendoza	1952-07-10	UHC-79001-77	7218582406	8300 Central Ave, Tampa, FL, 33661	0.68	Name re-cased Two-digit birth year Gender normalised Placeholder values cleared
ENR-139696	ENR	Sara Alvarado	1979-12-04	UHC-63467-49	—	1897 Ocean Ave, Minneapolis, MN, 55407	0.68	Name re-cased Phone missing area code Street suffix standardised Address re-cased
ENR-121388	ENR	Keith Henry	—	UHC-86871-50	—	—	0.68	Name re-cased Date of birth unreadable Gender normalised Placeholder values cleared
ENR-119048	ENR	Mateo E Richardson	—	UHC-51642-12	5469099864	1205 Mesa Dr, Tampa, FL	0.68	Name re-cased Date of birth missing Phone reformatted ZIP missing
ENR-136247	ENR	Debra X Rivera	—	UHC-98238-44	5794231734	8273 Camelback Rd, Atlanta, GA, 30345	0.68	Name re-cased Date of birth missing Phone reformatted State name converted to code
ENR-137711	ENR	Elizabeth Chapman	—	UHC-53911-66	—	3446 Elm St, Gilbert, AZ	0.68	Name re-cased Date of birth unreadable ZIP missing Placeholder values cleared
ENR-125894	ENR	Bryan Jenkins	1945-05-18	UHC-40066-17	7804210538	5150 Cedar Ln, San Diego, CA, 92139	0.68	Name re-cased Two-digit birth year Phone reformatted Gender normalised
ENR-142128	ENR	Deborah Q Murray	1968-11-04	UHC-16104-34	6824204405	1166 Park Pl, Las Vegas, NV	0.68	Name re-cased Street suffix standardised Address re-cased ZIP missing
ENR-118662	ENR	William Q Shaw	1996-04-14	UHC-04735-42	8937442699	6955 Park Pl, Los Angeles, CA, 90062	0.68	Name re-cased Two-digit birth year Street suffix standardised Address re-cased
ENR-109142	ENR	Carol R Clark	—	UHC-30064-04	8272257839	6078 Lincoln Way, Columbus, OH, 43226	0.68	Name re-cased Date of birth missing Street suffix standardised Address re-cased
ENR-112820	ENR	Isabellla Stephens	1976-12-10	UHC-72948-48	—	3799 Jefferson Ave, Denver, CO, 80234	0.68	Name re-cased Two-digit birth year Phone missing area code Whitespace trimmed
ENR-127950	ENR	Bobby Chapman	2004-02-20	UHC-80403-78	4188720773	5157 Lake View Rd, Dallas, TX, 75274	0.68	Name re-cased Street suffix standardised Address re-cased State name converted to code
ENR-123330	ENR	Lori Contreras	1964-02-14	UHC-34891-72	8594720235	5981 Maple Ave, Dallas, TX, 75273	0.68	Name re-cased Two-digit birth year Street suffix standardised Address re-cased
ENR-131968	ENR	Mark Roberts	1966-05-01	UHC-52293-76	9263666913	1099 Lincoln Way, Tempe, AZ, 85208	0.68	Name re-cased Two-digit birth year ZIP+4 trimmed Email lower-cased
ENR-129113	ENR	Kevin V Reyes	1938-04-09	UHC-54672-04	5716478007	172 Sage Ct, Seattle, WA	0.68	Name re-cased State name converted to code ZIP missing Whitespace trimmed
ENR-128585	ENR	Matthew R Barnes	2004-04-04	UHC-95482-22	6406141421	5668 Jefferson Ave, Miami, FL, 33191	0.68	Name re-cased Street suffix standardised Address re-cased Gender normalised
ENR-127150	ENR	Grace F Nunez	1978-02-13	UHC-46022-88	3572996240	7396 Forest Ave, Nashville, TN, 37265	0.68	Name re-cased SSN last four extracted Gender normalised Whitespace trimmed
ENR-128549	ENR	Vincent W Padilla	1986-01-12	UHC-44861-15	8579745210	1843 Central Ave, San Diego, CA	0.68	Name re-cased Street suffix standardised Address re-cased ZIP missing
ENR-128112	ENR	Roger F Slulivan	1941-01-21	UHC-76081-48	3587989838	9235 Hillcrest Rd, Glendale, AZ, 85385	0.68	Name re-cased Two-digit birth year State name converted to code Whitespace trimmed
ENR-134429	ENR	Lisa Soto	1998-05-16	UHC-01708-96	3686857257	8715 Central Ave Apt 26, Minneapolis, MN, 55414	0.68	Name re-cased Phone reformatted Unit split from street Gender normalised
ENR-134535	ENR	Joshua White	1941-04-09	UHC-26246-17	2104142977	7062 Elm St, Miami, FL, 33175	0.68	Name re-cased Two-digit birth year State name converted to code Email lower-cased
ENR-121711	ENR	Angela G Franklin	1977-10-14	UHC-52034-94	4588998048	2488 Mountain View Dr, Eden Prairie, MN, 55362	0.68	Name re-cased Street suffix standardised Address re-cased Gender normalised
ENR-137052	ENR	Nciole I Vega	1965-06-28	UHC-90651-35	3172299941	7571 Palm Dr, Mesa, AZ, 85244	0.68	Middle initial moved out of first name Name re-cased Phone reformatted State name converted to code
ENR-137051	ENR	Nciole I Vega	1965-06-28	UHC-90651-35	3172299941	7571 Palm Dr, Mesa, AZ, 85244	0.68	Middle initial moved out of first name Name re-cased Phone reformatted State name converted to code
ENR-136094	ENR	John H Alvarez	1946-04-19	UHC-74179-09	3626012524	910 Sunset Blvd, Gilbert, AZ, 85216	0.68	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed
ENR-135525	ENR	Catherine Marshall	1991-03-26	UHC-96098-86	5308472517	8858 Grand Ave, Sacramento, CA	0.68	Name re-cased Phone reformatted ZIP missing Gender normalised
ENR-109840	ENR	Daniel Le	1973-04-26	UHC-39813-91	—	7309 Oak St, Tucson, AZ, 85782	0.68	Name re-cased Phone missing area code Street suffix standardised Address re-cased
ENR-132469	ENR	Theresa A Padilla	1944-12-07	UHC-76628-92	—	5793 Hillcrest Rd Apt 3, Columbus, OH	0.68	Name re-cased Unit split from street ZIP missing Placeholder values cleared
ENR-110367	ENR	Nicholas Oliver	1954-11-23	UHC-24004-12	3185514214	270 Palm Dr, Austin, TX, 78719	0.68	Name re-cased Phone reformatted ZIP+4 trimmed Gender normalised
ENR-116506	ENR	Sean D Freeman	1966-03-08	UHC-70386-67	3606138729	9782 Grand Ave, Seattle, WA, 98171	0.68	Name re-cased Phone reformatted State name converted to code ZIP+4 trimmed
ENR-142003	ENR	Virginia T Gordon	—	UHC-62470-62	—	3974 Willow Ct, Gilbert, AZ, 85245	0.68	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased

17,310 rows, page 128 of 347Previous Next