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-128751	ENR	Samuel R Fisher	1970-06-03	UHC-59857-84	3586546233	2380 Highland Ave, Seattle, WA, 98111	0.92	Date of birth reformatted Phone reformatted City re-cased Placeholder values cleared
ENR-135228	ENR	Kathryn J Thompson	1988-02-25	UHC-66658-75	3849909239	9214 Forest Ave, Minneapolis, MN, 55416	0.92	Date of birth reformatted Member ID reformatted City re-cased Whitespace trimmed
ENR-112885	ENR	Grace I Ray	1945-11-08	UHC-29887-60	—	3885 Market St, Nashville, TN, 37295	0.92	City re-cased Email lower-cased Whitespace trimmed Placeholder values cleared
ENR-139185	ENR	Ann Garrett	1938-12-18	UHC-63615-33	2218085199	5563 Lincoln Way, Houston, TX, 77073	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
ENR-112467	ENR	Betty Ramirez	1972-05-27	UHC-44743-71	8528076595	594 Mountain View Dr, Dallas, TX, 75253	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
ENR-104654	ENR	Bradley J Gilbert	2005-03-24	UHC-38201-09	8854311016	600 Maple Ave, Las Vegas, NV, 89123	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
ENR-131269	ENR	Maria A Nguyen	2004-10-13	UHC-52881-07	—	5263 Lincoln Way, San Antonio, TX, 78236	0.92	City re-cased State code upper-cased Email lower-cased Placeholder values cleared
ENR-140149	ENR	Arthur Robertson	1990-05-18	UHC-01568-37	2265306934	1090 River Rd, Glendale, AZ, 85315	0.92	Name re-cased Phone reformatted City re-cased Whitespace trimmed
ENR-125864	ENR	Elizabeth U Moreno	1965-12-24	UHC-58804-83	7747650251	1996 Park Pl, Seattle, WA, 98130	0.92	Name re-cased Phone reformatted City re-cased State code upper-cased
ENR-132597	ENR	Kayla E Simmons	2003-07-15	UHC-11502-95	—	6651 Jefferson Ave, Tampa, FL, 33686	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
ENR-119448	ENR	Olivia Ruuiz	1961-01-18	UHC-84232-34	7194439614	9419 Apache Blvd, Austin, TX, 78793	0.92	Phone reformatted City re-cased Email lower-cased Placeholder values cleared
ENR-103333	ENR	Gerald Q Howell	1941-04-08	UHC-70632-75	7184039371	2627 Baseline Rd, Minneapolis, MN, 55423	0.92	Phone reformatted Member ID reformatted City re-cased Email lower-cased
ENR-108058	ENR	Beverly H Castro	1979-07-15	UHC-58154-60	3343950262	7982 Willow Ct, Nashville, TN, 37256	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
ENR-101331	ENR	Kimberly Mejia	1977-11-19	UHC-56315-91	—	4850 Indian School Rd, Mesa, AZ, 85252	0.92	Name re-cased City re-cased Email lower-cased Placeholder values cleared
ENR-126880	ENR	Samuel V Morris	1971-02-24	UHC-21937-98	8757774622	6701 Valley View Dr, San Diego, CA, 92157	0.92	Date of birth reformatted Phone reformatted City re-cased Whitespace trimmed
ENR-122238	ENR	Jcob X Hughes	1979-12-21	UHC-24664-28	6844144837	7401 Washington St, Atlanta, GA, 30391	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
ENR-119199	ENR	Austin U Murray	1950-07-01	UHC-81322-23	7429658532	9188 Jefferson Ave, Tempe, AZ, 85207	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
ENR-107621	ENR	Jacob J Reed	1945-12-18	UHC-01120-63	5806639194	9349 Meadow Ln, Columbus, OH, 43261	0.92	Date of birth reformatted Phone reformatted City re-cased Whitespace trimmed
ENR-133138	ENR	Diego Z Castro	1991-08-10	UHC-19074-97	7284760478	126 Central Ave, Los Angeles, CA, 90070	0.92	Name re-cased Phone reformatted City re-cased Whitespace trimmed
ENR-111970	ENR	Donna Gutierrez	1958-05-06	UHC-64677-45	3575054347	3046 Indian School Rd, Gilbert, AZ, 85240	0.92	Name re-cased Phone reformatted City re-cased Whitespace trimmed
ENR-125306	ENR	Deborah Gonzalez	1956-03-13	UHC-37519-72	7353587608	2641 Highland Ave, Tampa, FL, 33602	0.92	Name re-cased City re-cased Email lower-cased Placeholder values cleared
ENR-118804	ENR	Arhur R Wagner	1938-09-25	UHC-67545-55	4162532653	9144 Desert Sky Blvd, Orlando, FL, 32860	0.92	Date of birth reformatted City re-cased Email lower-cased Whitespace trimmed
ENR-128688	ENR	Justin Howard	1977-06-18	UHC-53437-72	6199645964	9252 Highland Ave, Minneapolis, MN, 55433	0.92	Phone reformatted Member ID reformatted City re-cased Email lower-cased
ENR-131581	ENR	Luri X Palemr	2008-02-25	UHC-28624-57	6044713237	2112 Union St, Orlando, FL, 32854	0.92	Name re-cased Member ID reformatted City re-cased Whitespace trimmed
ENR-117317	ENR	Sara W Stewart	1945-02-20	UHC-69080-55	7667114993	2687 Camelback Rd, Tampa, FL, 33651	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
ENR-120934	ENR	Sharon N Medina	1975-09-03	UHC-06352-41	4172083189	4548 Canyon Rd, Tampa, FL, 33663	0.92	Name re-cased Phone reformatted City re-cased Email lower-cased
ENR-104138	ENR	Sarah U Crawford	1996-06-24	UHC-03646-77	5948358126	8210 Cedar Ln, Columbus, OH, 43297	0.92	Date of birth reformatted Phone reformatted City re-cased Whitespace trimmed
ENR-136333	ENR	Gerald J Cole	1991-12-21	UHC-56705-90	3633755047	3808 Highland Ave, Houston, TX, 77030	0.92	Phone reformatted Member ID reformatted City re-cased State code upper-cased
ENR-136389	ENR	Andrea A Wagner	1940-02-15	UHC-53110-13	—	7893 Cedar Ln, Glendale, AZ, 85332	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
ENR-102394	ENR	Madison Wood	1998-01-25	UHC-82152-40	9047880823	7666 Sunset Blvd, Minneapolis, MN, 55460	0.92	Name re-cased Phone reformatted City re-cased Whitespace trimmed
ENR-141374	ENR	Klye N Gonzalez	1940-12-07	UHC-63081-75	8606172136	7257 Highland Ave, Las Vegas, NV, 89149	0.92	Name re-cased Phone reformatted City re-cased Email lower-cased
ENR-126332	ENR	Peter M Young	1940-08-21	UHC-34177-25	9543074188	8731 Hillcrest Rd, Las Vegas, NV, 89198	0.92	Phone reformatted Member ID reformatted City re-cased Whitespace trimmed
ENR-134094	ENR	Roy Ortega	1952-09-11	UHC-49200-73	8275698113	5579 Baseline Rd, Phoenix, AZ, 85054	0.92	Phone reformatted City re-cased Email lower-cased Whitespace trimmed
ENR-110286	ENR	Linda Spencer	1972-12-17	UHC-89705-09	5978799495	5065 Mesa Dr, Chandler, AZ, 85246	0.92	Date of birth reformatted Phone reformatted City re-cased Whitespace trimmed
ENR-115119	ENR	Amanda G Robinson	1973-08-11	UHC-11070-64	6956248304	1167 Park Pl, Gilbert, AZ, 85250	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
ENR-128503	ENR	Deennis Y Morris	1992-03-10	UHC-83204-10	5093429408	1592 Cedar Ln, Seattle, WA, 98162	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
ENR-124697	ENR	Juan Lane	1965-04-02	UHC-46484-18	7112893968	7809 Lake View Rd, Mesa, AZ, 85200	0.92	Date of birth reformatted Phone reformatted City re-cased Whitespace trimmed
ENR-132723	ENR	Noah O McCoy	1995-05-21	UHC-18268-27	5162809733	8371 Pine Dr, Glendale, AZ, 85397	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
ENR-129175	ENR	Christina N Payne	1944-11-02	UHC-39880-08	4604242324	6552 Baseline Rd, Denver, CO, 80209	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
ENR-102076	ENR	Alice Milelr	1984-01-08	UHC-81130-30	6707582223	2028 Lincoln Way, Glendale, AZ, 85311	0.92	Date of birth reformatted Phone reformatted City re-cased Whitespace trimmed
ENR-114669	ENR	Andrea E Jacobs	1953-10-23	UHC-76822-98	9576020665	3518 Union St, Nashville, TN, 37225	0.92	Date of birth reformatted Phone reformatted City re-cased Whitespace trimmed
ENR-139888	ENR	Ryan Spencer	1980-01-09	UHC-24015-36	2955750337	324 Sage Ct, Eden Prairie, MN, 55313	0.92	Name re-cased Date of birth reformatted Phone reformatted City re-cased
ENR-118463	ENR	Evelyn Nguyen	2003-06-09	UHC-50829-41	2067358821	5532 Union St, Tucson, AZ, 85739	0.92	Name re-cased Phone reformatted City re-cased Whitespace trimmed
ENR-112447	ENR	Christian X Rojas	2002-10-10	UHC-82285-28	7739920381	2152 Oak St, Phoenix, AZ, 85074	0.92	Phone reformatted City re-cased Email lower-cased Whitespace trimmed
ENR-122164	ENR	Brenda U Ortiz	1973-05-20	UHC-96228-35	6006619747	4107 Palm Dr, Fresno, CA, 93701	0.92	Name re-cased Phone reformatted City re-cased Whitespace trimmed
ENR-136854	ENR	Daniels Q Arjun	2005-04-09	UHC-55649-52	9433481131	6637 River Rd, Eden Prairie, MN, 55352	0.92	Date of birth reformatted Phone reformatted City re-cased Whitespace trimmed
ENR-133538	ENR	Joyce Williams	1955-08-15	UHC-83998-13	4099440757	7046 Oak St, Dallas, TX, 75243	0.92	Name re-cased Phone reformatted City re-cased Whitespace trimmed
ENR-141299	ENR	Nathan Shaw	2003-08-10	UHC-44338-93	3854216165	9411 Willow Ct, Miami, FL, 33164	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
ENR-113809	ENR	Charlotte Patel	2008-08-11	UHC-45528-19	4982581341	2247 Mountain View Dr, Los Angeles, CA, 90024	0.92	Name re-cased Phone reformatted City re-cased Whitespace trimmed
ENR-115061	ENR	Deborah Nguyyen	1963-07-07	UHC-67100-98	5326620016	2946 Hillcrest Rd, Gilbert, AZ, 85202	0.92	Name re-cased Phone reformatted City re-cased Whitespace trimmed

8,423 rows, page 156 of 169Previous Next