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-131330	ENR	Nicholas D Martin	1999-10-26	UHC-37556-62	3462622258	8440 Broadway, Tucson, AZ, 85783	0.78	Name split from “Last, First”Phone reformatted Member ID reformatted Email lower-cased+1 more
ENR-123977	ENR	Edward C Peterson	1965-05-18	UHC-86064-90	—	1428 Maple Ave, Orlando, FL, 32889	0.78	Date of birth reformatted Member ID reformatted ZIP+4 trimmed Email lower-cased+1 more
CLM-415942	CLM	Abigail Olson	1944-07-07	UHC-32653-35	—	—	0.78	Name re-cased Two-digit birth year Member ID reformatted Whitespace trimmed+1 more
ENR-108487	ENR	Carolyn U Crter	1950-11-24	UHC-48342-14	3942135420	3394 Park Pl, Tampa, FL	0.78	Phone reformatted Member ID reformatted ZIP missing Whitespace trimmed+1 more
ENR-140421	ENR	Wayne P Woods	1940-12-04	UHC-32079-05	3512143066	89 Central Ave, Scottsdale, AZ, 85218	0.78	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-115047	ENR	Arthur N George	2000-07-02	UHC-37062-38	—	3309 Sunset Blvd, Las Vegas, NV, 89177	0.78	Date of birth reformatted Member ID reformatted State name converted to code Email lower-cased+1 more
ENR-109577	ENR	Patrick C Carroll	1986-01-15	UHC-51293-59	5106489849	9191 Meadow Ln, San Antonio, TX, 78280	0.78	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-114707	ENR	Keith B Jones	1956-01-16	UHC-84478-19	—	4325 Church St, Gilbert, AZ, 85296	0.78	Name re-cased Date of birth reformatted Member ID reformatted Gender normalised+1 more
ENR-142562	ENR	Hannah Dominguez	1942-05-23	UHC-10928-36	9067238081	2610 Maple Ave, Gilbert, AZ, 85234	0.78	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-132725	ENR	Bryan Holmes	2010-07-09	UHC-32802-07	6852048159	4649 Broadway, Seattle, WA, 98139	0.78	Name re-cased Phone reformatted Member ID reformatted Address re-cased+1 more
ENR-124899	ENR	Gabriel J Wong	1950-02-27	UHC-32961-30	—	3548 Harbor Blvd, Tampa, FL, 33636	0.78	Date of birth reformatted Member ID reformatted State name converted to code Whitespace trimmed+1 more
CLM-421511	CLM	Jeffrey Y Elliott	1948-03-01	UHC-79071-32	—	—	0.78	Middle initial moved out of first name Name re-cased Member ID reformatted Whitespace trimmed+1 more
CLM-421166	CLM	Frances Diaz	1972-11-19	UHC-60722-75	6888686172	—	0.78	Name re-cased Phone reformatted Member ID reformatted Gender normalised+1 more
PRV-23470	PRV	Lisa O Walker	1960-01-24	UHC-66353-78	—	3284 Mesa Dr, Atlanta, GA, 30361	0.78	Name re-cased Member ID reformatted State name converted to code Whitespace trimmed+1 more
ENR-113442	ENR	Sarah V Hansen	1991-12-08	UHC-41536-07	5992233279	8339 Bayshore Dr, Minneapolis, MN, 55496	0.78	Name re-cased Phone reformatted Member ID reformatted ZIP+4 trimmed+1 more
ENR-107698	ENR	Alan Crawford	1956-04-06	UHC-06502-47	—	7719 Jefferson Ave, Plano, TX, 75014	0.78	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
PRV-28754	PRV	Laura Washington	1987-02-21	UHC-91264-39	—	6061 Camelback Rd, Miami, FL, 33108	0.78	Member ID reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-118079	ENR	Sean Wright	1959-09-12	UHC-23006-08	5697834276	3748 Church St, Tempe, AZ, 85297	0.78	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+1 more
ENR-105668	ENR	Megan Q Fox	1971-06-23	UHC-06501-28	3982561019	7489 Union St, Glendale, AZ	0.78	Name re-cased Phone reformatted Member ID reformatted ZIP missing+1 more
CLM-427261	CLM	John Freeman	1946-07-23	UHC-26724-61	7047446923	2736 Lake View Rd, San Antonio, TX, 78294	0.78	Member ID reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-136369	ENR	Lucia Hughes	1939-07-22	UHC-07805-06	3725976654	3294 Lake View Rd, Atlanta, GA, 30345	0.78	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-122254	ENR	Jeremy Reed	1948-03-21	UHC-59517-34	3464800666	8795 Valley View Dr, Nashville, TN, 37237	0.78	Name re-cased Phone reformatted Member ID reformatted Email lower-cased+1 more
ENR-130746	ENR	Rebecca S Buter	1972-12-26	UHC-82111-65	3346167738	6189 Desert Sky Blvd, Gilbert, AZ, 85294	0.78	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+1 more
CLM-432782	CLM	Mateo V Simpson	1998-02-15	UHC-48188-73	—	9683 Canyon Rd, Minneapolis, MN, 55409	0.78	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
CLM-432783	CLM	Mateo V Simpson	1998-02-15	UHC-48188-73	—	9683 Canyon Rd, Minneapolis, MN, 55409	0.78	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
CLM-406038	CLM	Larry Y Barnes	1958-04-09	UHC-76599-05	—	—	0.78	Name re-cased Two-digit birth year Member ID reformatted Whitespace trimmed+1 more
ENR-141975	ENR	Russell Scott	2006-07-06	UHC-62068-74	5822157597	—	0.78	Name re-cased Phone reformatted Member ID reformatted Gender normalised+1 more
CLM-407473	CLM	Brenda Stephens	1965-07-27	UHC-83061-21	5736872252	3910 Forest Ave, Phoenix, AZ, 85033	0.78	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
CLM-428505	CLM	Sam Pierce	2004-03-28	UHC-33483-59	—	4847 Valley View Dr, Houston, TX, 77001	0.78	Name split from “Last, First”Date of birth reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-100851	ENR	Brian W Hughes	1973-09-07	UHC-74866-18	4678898577	2261 Mesa Dr # 130, Dallas, TX, 75287	0.78	Phone reformatted Member ID reformatted Unit split from street Plan code upper-cased+1 more
ENR-132026	ENR	Heather S Santiago	1984-05-12	UHC-96448-79	9216274151	6619 Spring St, Minneapolis, MN, 55444	0.78	Date of birth reformatted Phone reformatted Member ID reformatted SSN last four extracted+1 more
CLM-417974	CLM	Douglas Z Gonzales	1991-07-21	UHC-51488-52	7442195854	1017 Apache Blvd, Dallas, TX, 75218	0.78	Phone reformatted Member ID reformatted ZIP+4 trimmed Plan code upper-cased+1 more
ENR-138111	ENR	Kayla Medina	1970-01-22	UHC-26070-66	2286310482	1870 Grand Ave Apt 11, Nashville, TN, 37243	0.78	Phone reformatted Member ID reformatted Unit split from street City re-cased+1 more
CLM-424193	CLM	Beverly Grant	2001-05-07	UHC-75207-50	8055355676	6197 River Rd, Minneapolis, MN, 55477	0.78	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
CLM-409541	CLM	Mari Park	1979-04-01	UHC-74024-31	—	1510 Grand Ave, Phoenix, AZ, 85034	0.78	Member ID reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-418075	CLM	Kelly Powell	1984-05-14	UHC-57639-35	6033866345	1647 Oak St, Gilbert, AZ, 85212	0.78	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-117403	ENR	Dennis Brooks	1956-10-04	UHC-34952-16	2699782765	4878 Camelback Rd, Austin, TX, 78767	0.78	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-120300	ENR	Bryan Q Harrison	2007-11-10	UHC-33879-78	7333506085	2725 Indian School Rd, Dallas, TX, 75215	0.78	Date of birth reformatted Phone reformatted Member ID reformatted Gender normalised+1 more
ENR-139757	ENR	Joshua Schultz	1985-01-13	UHC-64250-33	5116978845	4046 Union St, Jacksonville, FL, 32297	0.78	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-111008	ENR	Bredna N Stephens	1963-11-26	UHC-21755-58	8336563455	6011 Grand Ave, Orlando, FL, 32849	0.78	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+1 more
ENR-102790	ENR	Isabella Guzman	1969-01-19	UHC-21266-76	—	1156 Elm St, Orlando, FL, 32890	0.78	Member ID reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-432415	CLM	Jacob Rojas	1988-12-24	UHC-35325-16	—	4083 Elm St, Plano, TX, 75028	0.78	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+1 more
PRV-25552	PRV	Austin Smith	2006-09-13	UHC-95971-84	—	8639 Lincoln Way, Jacksonville, FL, 32272	0.78	Member ID reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-25551	PRV	Austin Smith	2006-09-13	UHC-95971-84	—	8639 Lincoln Way, Jacksonville, FL, 32272	0.78	Member ID reformatted Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-427787	CLM	Jennifer T Padilla	1943-06-20	UHC-90521-32	—	8407 Highland Ave Apt 26, Gilbert, AZ, 85213	0.78	Name re-cased Date of birth reformatted Member ID reformatted Unit split from street+1 more
ENR-113107	ENR	Cheryl Z Lawrence	1980-03-17	UHC-30888-91	8297099511	667 Forest Ave, Gilbert, AZ, 85241	0.78	Member ID reformatted Street suffix standardised Address re-cased Plan code upper-cased+1 more
ENR-117325	ENR	Christine Carter	1939-10-14	UHC-65972-85	4859587300	4747 Mountain View Dr, Scottsdale, AZ, 85229	0.78	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
CLM-416534	CLM	Yuki Ward	1948-12-23	UHC-49692-58	—	4400 Central Ave, Miami, FL, 33132	0.78	Name split from “Last, First”Member ID reformatted City re-cased Whitespace trimmed+1 more
CLM-409424	CLM	Harold Bishop	2006-05-25	UHC-58284-64	5956972075	1322 Willow Ct, Seattle, WA, 98103	0.78	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-109133	ENR	Ran X Diaz	1947-08-10	UHC-91892-26	8143745111	6942 Union St, Nashville, TN, 37207	0.78	Name re-cased Phone reformatted Member ID reformatted SSN last four extracted+1 more

7,723 rows, page 109 of 155Previous Next