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-108492	ENR	Julia L Alexander	1952-09-16	UHC-32113-93	6082393444	6675 Palm Dr, Tempe, AZ, 85218	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-140041	ENR	Roger Wallace	2006-10-20	UHC-81010-87	—	9216 Lake View Rd, Las Vegas, NV, 89131	0.76	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
CLM-402057	CLM	Randy Barnes	2000-03-03	UHC-19730-93	2408991504	429 Union St, Houston, TX, 77094	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-137125	ENR	Jonathan Z Kennedy	1961-12-02	UHC-96291-49	2624883407	2767 Grand Ave, Tampa, FL, 33605	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-119497	ENR	Jeremy Mejia	1951-09-14	UHC-91734-57	4168711896	7721 Camelback Rd, Las Vegas, NV, 89187	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-106081	ENR	Kyle Williamson	1988-10-24	UHC-08473-58	9493935064	5641 Meadow Ln, Gilbert, AZ, 85226	0.76	Phone reformatted Member ID reformatted ZIP+4 trimmed Plan code upper-cased+2 more
ENR-113317	ENR	Joseph Herrera	1959-04-21	UHC-09369-39	6884295943	5215 Indian School Rd, Las Vegas, NV, 89149	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-103535	ENR	Patrick Martin	1999-03-11	UHC-72447-31	8724437999	4775 Spring St, Dallas, TX, 75216	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-405127	CLM	Elizabeth Mitchell	2003-08-22	UHC-66315-76	—	6083 Ridge Rd, Nashville, TN, 37221	0.76	Member ID reformatted Street suffix standardised Address re-cased City re-cased+2 more
CLM-410402	CLM	Brian Hall	1946-06-06	UHC-70681-11	7728331312	7724 Ridge Rd, Dallas, TX	0.76	Name re-cased Phone reformatted Member ID reformatted ZIP missing+2 more
CLM-415784	CLM	Jeff Cruz	1971-02-10	UHC-77455-14	—	452 Elm St, Nashville, TN, 37285	0.76	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-137242	ENR	Evelyn Simpson	1979-01-11	UHC-33527-89	3386129001	3388 Lake View Rd, Tucson, AZ, 85727	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-134007	ENR	Pul Murphy	1954-11-21	UHC-93980-80	—	1988 Mesa Dr, Atlanta, GA, 30321	0.76	Date of birth reformatted Member ID reformatted City re-cased Gender normalised+2 more
ENR-139870	ENR	Kyle D Ray	1993-08-17	UHC-93921-70	2446127525	2370 River Rd, Mesa, AZ, 85269	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-121896	ENR	Benjamin Y Yang	1944-10-04	UHC-43975-07	7059092295	—	0.76	Name split from “Last, First”Phone reformatted Member ID reformatted Email lower-cased+2 more
ENR-106941	ENR	Arthur R McCoy	1992-06-08	UHC-19480-10	8473742581	5703 Pine Dr, Plano, TX, 75095	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-118206	ENR	Anthony E Silva	1950-03-01	UHC-11042-41	8558861705	7986 Bayshore Dr, Jacksonville, FL, 32287	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-428104	CLM	William V Hamilton	1950-11-11	UHC-67843-67	2453429974	3320 Meadow Ln, Fresno, CA, 93739	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
CLM-426863	CLM	Eugene Crawford	1954-05-05	UHC-66706-90	9867989533	6267 Broadway # 435, Scottsdale, AZ, 85277	0.76	Name re-cased Date of birth reformatted Member ID reformatted Unit split from street+2 more
ENR-142476	ENR	Dylan M Alvarez	1990-06-08	UHC-79741-17	6355834105	8506 Bayshore Dr, Phoenix, AZ, 85072	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
CLM-405862	CLM	James Barnes	1989-12-07	UHC-76680-76	4695387610	5095 Meadow Ln, Eden Prairie, MN, 55362	0.76	Member ID reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-141544	ENR	Roy W Coel	1963-09-07	UHC-58095-91	6172792682	5514 Union St, Las Vegas, NV, 89125	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-421762	CLM	Anna Ortiz	1964-08-20	UHC-88523-20	—	1887 Central Ave, Charlotte, NC, 28209	0.76	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-135562	ENR	Arjun X Dean	1991-02-16	UHC-66226-50	9658999050	5986 Apache Blvd, Charlotte, NC, 28273	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-114325	ENR	Valentina U Etrada	1994-07-25	UHC-11269-95	7093776562	2900 Baseline Rd, Charlotte, NC, 28228	0.76	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
ENR-117300	ENR	Donald Harrison	1975-04-20	UHC-92558-79	6916291152	9259 Lincoln Way, Sacramento, CA, 95875	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-135719	ENR	Stephen X Carter	1945-09-16	UHC-47675-96	4782268064	8200 Pine Dr, Tempe, AZ, 85245	0.76	Name split from “Last, First”Phone reformatted Member ID reformatted City re-cased+2 more
ENR-126579	ENR	Benjamin K Boyd	1939-02-06	UHC-43747-98	4527770904	8631 Sage Ct, Jacksonville, FL, 32269	0.76	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
CLM-431103	CLM	Stephanie F Lopez	1943-10-18	UHC-95228-95	—	1921 Washington St, Gilbert, AZ, 85201	0.76	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-126456	ENR	Nathan R Matthews	1963-08-12	UHC-14644-12	5337738996	2293 Elm St, Jacksonville, FL, 32293	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-411845	CLM	Kim Lee	1997-06-28	UHC-22171-88	—	4083 Pine Dr, Sacramento, CA, 95899	0.76	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+2 more
ENR-140288	ENR	Camila A Casttillo	2000-07-24	UHC-26142-58	3084750346	7096 Central Ave, Tampa, FL	0.76	Name re-cased Phone reformatted Member ID reformatted ZIP missing+2 more
ENR-102275	ENR	Arjnu P Palmer	1989-03-27	UHC-13468-70	9487823154	8775 Elm St, Mesa, AZ	0.76	Name re-cased Phone reformatted Member ID reformatted ZIP missing+2 more
CLM-424959	CLM	Jesse J Weaver	1958-11-12	UHC-76848-80	7494927515	4153 Valley View Dr, Fresno, CA, 93784	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-142751	ENR	Madison Ramus	2002-07-03	UHC-00591-88	2994708267	5080 Bayshore Dr, Las Vegas, NV, 89195	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-406608	CLM	Ralph Torres	1945-09-17	UHC-44307-15	—	7823 Lincoln Way, Phoenix, AZ, 85014	0.76	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-100892	ENR	Lawrence Garrett	1982-07-27	UHC-83755-59	8606774695	6007 Broadway, Tampa, FL, 33687	0.76	Name re-cased Two-digit birth year Phone reformatted Member ID reformatted+2 more
CLM-423713	CLM	Steven Carroll	1948-01-03	UHC-89841-95	—	7881 Highland Ave, Houston, TX, 77080	0.76	Member ID reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-125721	ENR	Matthew E Ferandez	1972-12-05	UHC-02863-27	5174944163	9514 Indian School Rd, Mesa, AZ, 85270	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
CLM-425079	CLM	Joseph Day	1968-04-14	UHC-62916-46	5583799198	8532 Palm Dr, Los Angeles, CA, 90076	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-134840	ENR	Paul Luna	1961-02-24	UHC-71994-41	3796504133	9527 Grand Ave, Fresno, CA, 93765	0.76	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+2 more
PRV-28651	PRV	Dylan R Fuller	1938-03-20	UHC-49709-97	6133801722	9644 Indian School Rd, Miami, FL	0.76	Phone reformatted Member ID reformatted State code upper-cased ZIP missing+2 more
ENR-109753	ENR	Carol Martinez	1972-05-11	UHC-93836-27	9649427273	3394 River Rd # 101, Mesa, AZ, 85253	0.76	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
ENR-115718	ENR	Alexander Anderson	1950-05-14	UHC-79887-28	4783200973	1045 Ocean Ave, Orlando, FL, 32883	0.76	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+2 more
PRV-23998	PRV	Sarah I Oliver	1996-07-24	UHC-32902-31	2285136446	4779 Union St, Minneapolis, MN, 55405	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
PRV-23997	PRV	Sarah I Oliver	1996-07-24	UHC-32902-31	2285136446	4779 Union St, Minneapolis, MN, 55405	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-135929	ENR	Grace P Watkins	1979-12-27	UHC-95747-72	8873437962	9798 Central Ave, Los Angeles, CA, 90038	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-103916	ENR	Nancy V Eans	1963-04-21	UHC-04487-12	—	7133 Apache Blvd, Scottsdale, AZ, 85277	0.76	Name re-cased Member ID reformatted City re-cased State name converted to code+2 more
CLM-419641	CLM	Andy Wilson	2007-05-24	UHC-56200-26	5893697622	—	0.76	Name re-cased Phone reformatted Member ID reformatted Gender normalised+2 more
CLM-413169	CLM	Bryan Silva	1955-11-05	UHC-56626-27	—	612 Church St, San Antonio, TX, 78223	0.76	Member ID reformatted Street suffix standardised Address re-cased Email lower-cased+2 more

7,723 rows, page 91 of 155Previous Next