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-128711	ENR	Diana A Fox	2007-04-15	UHC-41347-77	—	6924 Church St, Tampa, FL, 33606	0.76	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+2 more
PRV-29010	PRV	Katherine Q Wheeler	1982-06-17	UHC-14259-82	9459171020	5094 Maple Ave, Las Vegas, NV, 89196	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-131317	ENR	Sandra U Reed	1985-04-05	UHC-49852-21	4217610275	4807 Central Ave, Columbus, OH, 43264	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-419906	CLM	Lisa Harrison	1982-07-19	UHC-17341-10	8183417523	2224 Ocean Ave, Minneapolis, MN, 55431	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
PRV-23439	PRV	Jose Rodriguez	1972-10-11	UHC-49925-88	3472183963	385 Market St, Dallas, TX, 75261	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
CLM-425267	CLM	Diane S Moore	1940-11-02	UHC-33475-05	4906470638	3407 Desert Sky Blvd, Chandler, AZ, 85296	0.76	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
ENR-143036	ENR	Valentina S Santos	1950-03-18	UHC-96022-74	6806528938	5497 Broadway, Eden Prairie, MN, 55316	0.76	Name re-cased Phone reformatted Member ID reformatted SSN last four extracted+2 more
ENR-114110	ENR	Wei U Estrada	1987-08-21	UHC-45426-98	3574269615	5179 Pine Dr, Los Angeles, CA, 90075	0.76	Name split from “Last, First”Phone reformatted Member ID reformatted City re-cased+2 more
ENR-132782	ENR	Ashley Cox	1942-04-15	UHC-52514-87	6327020065	7781 Mountain View Dr, Miami, FL, 33180	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-426174	CLM	Russell L Nelson	1967-07-07	UHC-16363-20	5063453009	8563 Ridge Rd, San Diego, CA, 92144	0.76	Name split from “Last, First”Date of birth reformatted Member ID reformatted City re-cased+2 more
CLM-423802	CLM	Doris King	1976-07-06	UHC-76651-46	—	1377 Indian School Rd, Tampa, FL, 33644	0.76	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
CLM-418716	CLM	Jason Watson	1999-06-27	UHC-31272-97	—	8344 Harbor Blvd, Columbus, OH, 43282	0.76	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-112259	ENR	Carl W Peterson	1955-02-24	UHC-56366-27	4335390980	1835 Lincoln Way, Houston, TX, 77088	0.76	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
ENR-112258	ENR	Carl W Peterson	1955-02-24	UHC-56366-27	4335390980	1835 Lincoln Way, Houston, TX, 77088	0.76	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
CLM-430838	CLM	Scott Fowler	1950-02-03	UHC-57615-89	3366539256	2210 River Rd, Jacksonville, FL, 32264	0.76	Name split from “Last, First”Phone reformatted Member ID reformatted City re-cased+2 more
ENR-129940	ENR	Jean U Boyd	1986-07-09	UHC-11424-61	8223767575	3545 Oak St, Las Vegas, NV, 89160	0.76	Phone reformatted Member ID reformatted City re-cased Email lower-cased+2 more
PRV-28085	PRV	Ralph Peterson	1995-08-04	UHC-53260-05	4588571984	1958 Market St, Sacramento, CA, 95883	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-427445	CLM	Michelle N Carr	1968-12-25	UHC-88441-75	3277298800	3407 Mountain View Dr, Glendale, AZ, 85366	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-135879	ENR	Juaan Y Hughes	1994-10-24	UHC-86709-92	3206404193	9070 Bayshore Dr, Minneapolis, MN, 55486	0.76	Name re-cased Phone reformatted Member ID reformatted State code upper-cased+2 more
ENR-105629	ENR	Andrea T Vazquez	1978-06-12	UHC-22645-45	7957729916	8128 Park Pl, Sacramento, CA, 95825	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-134966	ENR	Randy R Aguilar	1946-08-28	UHC-91205-10	8813527675	3928 Maple Ave, Austin, TX, 78768	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-431127	CLM	Joshua Watson	1989-01-28	UHC-57517-29	7273853678	5300 Lake View Rd, Atlanta, GA, 30366	0.76	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
ENR-113622	ENR	Sophia A Riey	1997-09-13	UHC-71413-86	—	6447 Union St, Gilbert, AZ, 85206	0.76	Name re-cased Date of birth reformatted Member ID reformatted City re-cased+2 more
PRV-24919	PRV	Deeborah Price	1940-11-15	UHC-27304-07	3907276725	6605 Highland Ave, Phoenix, AZ, 85095	0.76	Member ID reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-113147	ENR	Peter Wong	1965-05-19	UHC-38466-49	3798657689	1640 Ocean Ave, Seattle, WA, 98130	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-411770	CLM	Alexander Gibson	1959-10-11	UHC-75982-61	—	5157 Cedar Ln, Atlanta, GA, 30383	0.76	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-119823	ENR	Theresa E Harris	1958-09-18	UHC-49222-72	3047336906	7303 Valley View Dr, Miami, FL, 33145	0.76	Member ID reformatted Street suffix standardised Address re-cased Email lower-cased+2 more
CLM-425009	CLM	Denny Elliott	1944-08-12	UHC-36167-23	8989955409	2860 Ocean Ave, Eden Prairie, MN, 55387	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
CLM-405680	CLM	Lucia Henderson	1978-09-11	UHC-15058-21	9705990017	7600 Ocean Ave, Nashville, TN, 37295	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
CLM-432001	CLM	Jack L Wang	1974-08-11	UHC-20925-04	—	470 Sage Ct, Las Vegas, NV, 89183	0.76	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-127939	ENR	Valentina Q Ellis	1949-10-14	UHC-32094-69	4586968896	3256 Market St, Tucson, AZ, 85710	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-128579	ENR	Diego C Robertson	1998-01-12	UHC-11231-23	8518085815	4317 Desert Sky Blvd, Eden Prairie, MN, 55320	0.76	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
ENR-113635	ENR	Austin Lopez	—	UHC-86703-24	4909447386	7836 Harbor Blvd, San Diego, CA, 92168	0.76	Name re-cased Date of birth unreadable Phone reformatted Member ID reformatted+2 more
CLM-428096	CLM	Melissa Hawkins	1975-06-26	UHC-87638-87	—	9255 Harbor Blvd, Chandler, AZ, 85225	0.76	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-107176	ENR	Keith J Marshall	1990-04-01	UHC-06379-96	4777835742	2852 Main St, Atlanta, GA, 30380	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-134161	ENR	Natalie Obrien	1969-07-27	UHC-10176-82	5435550647	5256 Apache Blvd, Plano, TX, 75024	0.76	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-135298	ENR	Patricia Hicks	1966-10-27	UHC-31171-67	3523526443	3016 Palm Dr, Minneapolis, MN, 55461	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-119609	ENR	Maria Warren	1939-08-17	UHC-52031-57	6095269464	7583 Market St, Plano, TX, 75028	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-137448	ENR	Mei W Gibson	2002-06-10	UHC-65121-63	4002333692	8059 Meadow Ln, Orlando, FL, 32899	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-425787	CLM	Danielle Bradley	1998-02-18	UHC-78142-72	—	670 Pine Dr, Denver, CO, 80201	0.76	Member ID reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-130972	ENR	Samuel F Collins	1943-03-02	UHC-44660-05	7217608699	3152 Valley View Dr Apt 30, Charlotte, NC, 28264	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Unit split from street+2 more
ENR-102904	ENR	Nicole Torres	1982-01-12	UHC-96313-13	6313922199	6945 Market St, San Diego, CA, 92103	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-120246	ENR	Samantha Clark	1944-06-24	UHC-89552-08	6052837949	9047 Sunset Blvd, Scottsdale, AZ, 85234	0.76	Name split from “Last, First”Date of birth reformatted Phone reformatted Member ID reformatted+2 more
ENR-100272	ENR	Richard Kelley	1961-01-10	UHC-55573-18	7543617207	1539 Spring St, Atlanta, GA, 30307	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
PRV-22411	PRV	Alice P Wang	1938-03-05	UHC-19783-63	7666882633	9104 River Rd, Austin, TX, 78739	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-131729	ENR	Gabriel W Wong	1949-01-25	UHC-34506-34	9473317288	875 Cedar Ln, San Antonio, TX, 78250	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
PRV-27219	PRV	Alexander V Silva	1984-08-10	UHC-70392-45	3258510146	5783 Pine Dr, Phoenix, AZ, 85008	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-412040	CLM	Brenda Banks	1954-12-08	UHC-05819-20	—	2233 Broadway, Orlando, FL	0.76	Name re-cased Date of birth reformatted Member ID reformatted Address re-cased+2 more
CLM-402539	CLM	Frances C Sanders	1995-12-19	UHC-30460-10	—	9272 Meadow Ln, Miami, FL, 33150	0.76	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-126147	ENR	Roy Mills	1963-12-12	UHC-46354-30	9657058183	5385 Elm St, Minneapolis, MN, 55473	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more

7,723 rows, page 78 of 155Previous Next