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 “Member ID reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagMember ID reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-134406	ENR	Ashley Watson	1960-12-22	UHC-02090-65	9388858091	4523 Maple Ave, Phoenix, AZ, 85064	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-104233	ENR	Alexis A Torres	1980-08-07	UHC-19949-26	2607408084	1336 Maple Ave, Minneapolis, MN, 55440	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-123937	ENR	Dylan C Reed	2005-08-19	UHC-39800-75	3157449919	4465 Desert Sky Blvd, Austin, TX, 78735	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-417462	CLM	Danielle Gomez	1962-01-04	UHC-89338-09	4966169025	9496 Cedar Ln, Jacksonville, FL, 32223	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-424612	CLM	Peter Patel	1945-04-20	UHC-99963-63	—	981 Union St, Chandler, AZ, 85264	0.74	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-135509	ENR	Adam Owens	1978-03-17	UHC-17433-17	6078451338	2497 Valley View Dr, Gilbert, AZ, 85288	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
CLM-418975	CLM	Juan C Powell	1986-03-20	UHC-26955-36	7077265948	3389 Pine Dr, Fresno, CA, 93736	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-100778	ENR	Kyle Williams	1938-03-12	UHC-29313-67	8139807261	4352 Indian School Rd, Tampa, FL, 33682	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-134500	ENR	Nancy T Fields	1987-10-18	UHC-70642-29	2605291394	4160 Cedar Ln, Glendale, AZ, 85373	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-130734	ENR	Joe Salazra	1994-01-16	UHC-89970-58	8732759175	2559 Mountain View Dr, Dallas, TX, 75260	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-105389	ENR	Mendoza Angela	1959-05-04	UHC-25015-53	8474816353	4483 Spring St, Charlotte, NC, 28248	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-414634	CLM	Rebecca Bennnett	1948-04-27	UHC-21274-89	8297418145	5990 Camelback Rd, Gilbert, AZ, 85268	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
PRV-27902	PRV	Henry Watson	1964-01-03	UHC-95535-50	9256767420	2496 Valley View Dr, Charlotte, NC, 28279	0.74	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-114713	ENR	Dorothy T Richardson	1948-07-07	UHC-54546-12	9286337116	9509 Indian School Rd, Charlotte, NC, 28278	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-112614	ENR	Lucia Cook	1950-10-17	UHC-56273-97	—	4149 Indian School Rd, Mesa, AZ, 85271	0.74	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-100926	ENR	Lauren Freeman	1958-04-09	UHC-00648-13	4195094219	2778 Bayshore Dr, Eden Prairie, MN, 55388	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-407310	CLM	Christopher B Cooper	1968-04-23	UHC-06864-83	2415390900	3094 Willow Ct, Columbus, OH, 43264	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-124088	ENR	Lawrence W Lane	2006-08-09	UHC-10400-82	9502398303	2237 Camelback Rd, Los Angeles, CA, 90083	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-133486	ENR	Aisha U Wallace	1971-05-21	UHC-59041-99	5727424896	7738 Highland Ave, Tucson, AZ, 85742	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
CLM-412015	CLM	Jerry Price	1957-10-17	UHC-62204-46	—	563 Desert Sky Blvd, Glendale, AZ, 85340	0.74	Name re-cased Date of birth reformatted Member ID reformatted City re-cased+3 more
CLM-412990	CLM	Jeremy Castillo	1981-09-28	UHC-29703-02	6125163836	3847 Grand Ave, Tempe, AZ, 85235	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-137683	ENR	Mary Barnes	1997-03-28	UHC-67765-67	5086306579	8184 Park Pl, Miami, FL, 33148	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
ENR-102031	ENR	Stephnie Tucker	1986-12-12	UHC-85763-40	8037058241	5732 Meadow Ln, Chandler, AZ, 85288	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
CLM-411744	CLM	Ashley U Perry	1987-02-07	UHC-75552-09	—	3205 Ridge Rd, Atlanta, GA, 30359	0.74	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
ENR-108408	ENR	Stephen Turner	1984-04-16	UHC-09124-02	8955412142	3780 Grand Ave, San Diego, CA, 92138	0.74	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-114745	ENR	Rebecca Wagner	2004-11-21	UHC-74793-23	9286205033	451 Mountain View Dr, Mesa, AZ, 85270	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-402585	CLM	Russell Le	1941-05-10	UHC-19416-53	7007392456	—	0.74	Name re-cased Phone reformatted Member ID reformatted Gender normalised+3 more
ENR-114449	ENR	Teresa Richards	1985-08-22	UHC-83111-34	2689870712	808 Canyon Rd, Tampa, FL, 33661	0.74	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-142326	ENR	Carl Z West	1992-01-06	UHC-42112-04	6097489464	3663 Grand Ave, Glendale, AZ, 85353	0.74	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
ENR-142327	ENR	Carl Z West	1992-01-06	UHC-42112-04	6097489464	3663 Grand Ave, Glendale, AZ, 85353	0.74	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
ENR-122798	ENR	Theresa K Burns	1961-08-13	UHC-49456-91	8677651239	6374 River Rd, Miami, FL, 33146	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
TPA-59464	TPA	Christopher I Jackson	1959-04-13	UHC-69793-47	—	4347 Meadow Ln, Austin, TX, 78768	0.74	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-129285	ENR	Marrgaret Black	1989-04-01	UHC-80087-49	4244240490	2392 Spring St, Dallas, TX, 75262	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-105801	ENR	Andrea F Ryan	1960-10-18	UHC-97624-63	3838101763	612 Main St, Phoenix, AZ, 85050	0.74	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
ENR-130922	ENR	Ryan P Hill	1997-08-08	UHC-00515-59	8083423056	2145 Ocean Ave, Scottsdale, AZ, 85259	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
PRV-22544	PRV	DorisJunk	1939-12-09	UHC-24341-03	5302894016	9597 Camelback Rd, Tempe, AZ, 85259	0.74	Name re-cased Phone reformatted Member ID reformatted State code upper-cased+3 more
ENR-105837	ENR	Alan Torres	1966-05-03	UHC-34937-60	7945164440	2033 Maple Ave, Nashville, TN, 37205	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-114840	ENR	Amy P Salazar	1945-03-10	UHC-32557-38	—	354 Oak St, San Diego, CA, 92158	0.74	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+3 more
CLM-425942	CLM	Ralph Andrews	1953-09-20	UHC-85599-20	2122278055	8747 Desert Sky Blvd, Miami, FL, 33144	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-116151	ENR	Jerry J Jensen	1955-08-28	UHC-63050-35	2679586582	4916 Sunset Blvd, Nashville, TN, 37255	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
TPA-53462	TPA	Bobby L Dxion	1958-01-25	UHC-60044-90	6504333180	2777 Washington St, Dallas, TX, 75278	0.74	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
CLM-417839	CLM	Nathan Prker	1951-06-24	UHC-11779-61	—	2088 Desert Sky Blvd, Chandler, AZ, 85288	0.74	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
ENR-105055	ENR	Ryan M Walker	1966-07-12	UHC-64702-79	6195048849	6093 Ocean Ave, Chandler, AZ, 85269	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-132808	ENR	Hiroshi Greene	1953-06-26	UHC-26275-01	8784622437	4815 Ridge Rd, Los Angeles, CA, 90009	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-423390	CLM	Hiroshi Greene	1999-03-25	UHC-44535-99	7598521273	2623 Maple Ave, Las Vegas, NV, 89176	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-122009	ENR	Emma Turrner	1944-02-08	UHC-72911-16	8713525971	6871 Mountain View Dr, Gilbert, AZ, 85242	0.74	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-138098	ENR	Frank M Sanchez	1993-06-22	UHC-65332-50	3205769379	3489 Ridge Rd, Miami, FL	0.74	Name re-cased Phone reformatted Member ID reformatted City re-cased+3 more
PRV-22908	PRV	Timothy O Lucas	1939-02-26	UHC-65767-08	7953580222	6117 Grand Ave, Las Vegas, NV, 89171	0.74	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
CLM-427587	CLM	Bruce C Vazquez	1951-05-17	UHC-72856-87	8319669136	504 Elm St, Las Vegas, NV, 89169	0.74	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+3 more
CLM-421566	CLM	Julie Singh	1975-08-19	UHC-47477-34	8257944127	4749 Maple Ave, Fresno, CA, 93721	0.74	Name re-cased Phone reformatted Member ID reformatted City re-cased+3 more

7,723 rows, page 70 of 155Previous Next