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 “Street suffix standardised”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagStreet suffix standardisedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-402729	CLM	Ana I Coleman	1941-03-12	—	—	4247 Grand Ave, Los Angeles, CA, 90003	0.50	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+3 more
ENR-123761	ENR	Donna Q Marquez	1942-02-24	UHC-23095-78	3948879379	6518 Cedar Ln, Miami, FL, 33163	0.50	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+3 more
CLM-404642	CLM	Billy Tucker	1987-12-20	UHC-60679-14	5508771851	6369 Indian School Rd, Tampa, FL	0.50	Phone reformatted Street suffix standardised Address re-cased State name converted to code+3 more
PRV-20656	PRV	Stephanie Harvey	1990-03-05	UHC-11287-52	7583184520	6362 Union St, Eden Prairie, MN, 55338	0.50	Name split from “Last, First”Two-digit birth year Phone reformatted Street suffix standardised+3 more
PRV-27640	PRV	Christine Fernandez	1973-04-23	—	9493379792	9101 Washington St, Atlanta, GA, 30381	0.50	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+3 more
TPA-58181	TPA	Ashley Thompsson	1999-11-22	—	—	8765 Central Ave, Eden Prairie, MN, 55320	0.50	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+3 more
PRV-23881	PRV	Brandon Rojas	1940-05-16	UHC-05735-97	3353194071	5141 Union St # 419, Seattle, WA, 98127	0.50	Phone reformatted Unit split from street Street suffix standardised Address re-cased+3 more
PRV-23882	PRV	Brandon Rojas	1940-05-16	UHC-05735-97	3353194071	5141 Union St # 419, Seattle, WA, 98127	0.50	Phone reformatted Unit split from street Street suffix standardised Address re-cased+3 more
ENR-135296	ENR	Jessica Y Mejia	2002-10-23	UHC-87470-48	6846784659	7277 Meadow Ln Apt 37, Los Angeles, CA	0.50	Member ID reformatted Unit split from street Street suffix standardised Address re-cased+3 more
TPA-62471	TPA	Kenneth Medina	1967-10-03	UHC-58954-97	8256422353	817 Hillcrest Rd, Houston, TX, 77090	0.50	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+3 more
ENR-129963	ENR	Angela D Carlson	1968-09-22	UHC-78453-72	7955642339	4333 Church St # 900, Seattle, WA, 98134	0.50	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+3 more
ENR-117404	ENR	Keren Morrison	2000-06-28	UHC-23765-47	4764116775	5196 Cedar Ln, Miami, FL, 33141	0.50	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+3 more
CLM-419288	CLM	Madison Knight	1984-02-05	UHC-85507-79	—	8677 Baseline Rd Apt 18, Atlanta, GA, 30319	0.50	Name re-cased Unit split from street Street suffix standardised Address re-cased+3 more
ENR-102122	ENR	Lori E Carlson	1945-09-28	UHC-83409-06	8613804519	2001 Elm St, Scottsdale, AZ, 85270	0.50	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+3 more
ENR-135110	ENR	Debra A Andrews	1971-11-10	UHC-51903-21	8489119182	9658 River Rd, Dallas, TX	0.50	Phone reformatted Street suffix standardised Address re-cased ZIP missing+3 more
CLM-418497	CLM	Isabella P McDonald	1967-08-02	UHC-60298-72	4816262445	7667 Pine Dr Apt 20, Columbus, OH, 43247	0.50	Name split from “Last, First”Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-414141	CLM	Ray Banks	1966-04-28	UHC-72994-01	—	3219 Grand Ave, Eden Prairie, MN, 55344	0.50	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+3 more
ENR-110822	ENR	Tony L Torres	1940-10-14	UHC-59591-76	8453167535	6430 Palm Dr, Sacramento, CA, 95812	0.50	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
TPA-53497	TPA	Jeremy Daniels	1961-02-21	UHC-81515-12	—	6850 Sage Ct, Las Vegas, NV	0.50	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code+3 more
CLM-420839	CLM	Raymond X Muunoz	1976-05-13	UHC-91631-69	—	8454 Apache Blvd, Scottsdale, AZ, 85248	0.50	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+3 more
CLM-429692	CLM	Ashely O Ryan	1981-05-26	—	2359843599	5777 Grand Ave, Fresno, CA, 93780	0.50	Middle initial moved out of first name Name re-cased Phone reformatted Street suffix standardised+3 more
TPA-60597	TPA	Christopher Willis	1980-03-14	—	7679142678	788 Willow Ct, Las Vegas, NV, 89153	0.50	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+3 more
CLM-412958	CLM	Dylan Ross	1942-02-11	—	—	8779 Forest Ave, Orlando, FL, 32869	0.50	Name re-cased Street suffix standardised Address re-cased State name converted to code+3 more
TPA-60447	TPA	Brenda Munoz	1979-05-11	—	3998985380	6309 Park Pl, San Antonio, TX	0.50	Name split from “Last, First”Street suffix standardised Address re-cased City re-cased+3 more
CLM-421448	CLM	Emma L Carroll	1984-04-25	UHC-47807-89	—	8499 Indian School Rd, Fresno, CA, 93735	0.50	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+3 more
CLM-409956	CLM	Kayla Flores	1951-06-13	UHC-94241-41	—	1387 Main St, Mesa, AZ	0.50	Date of birth reformatted Phone missing area code Street suffix standardised Address re-cased+3 more
ENR-117347	ENR	Ann X Fields	1946-01-03	UHC-32591-81	2802824556	5259 Valley View Dr Apt 22, Tempe, AZ, 85241	0.50	Phone reformatted Unit split from street Street suffix standardised Address re-cased+3 more
ENR-125215	ENR	Angela E Murray	2004-11-25	UHC-17948-28	9422472957	53 Elm St, Nashville, TN, 37215	0.50	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-417090	CLM	Wilson Maison	1993-07-06	UHC-64072-59	—	1284 Mesa Dr, Jacksonville, FL	0.50	Name re-cased Phone missing area code Street suffix standardised Address re-cased+3 more
ENR-100995	ENR	Shirley Q Wiliamson	1962-04-25	UHC-89515-83	9466380048	4586 Church St, Tampa, FL, 33619	0.50	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-121280	ENR	Thomas E Harvey	1977-10-25	UHC-55914-02	9672293694	6330 Cedar Ln, Plano, TX, 75096	0.50	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+3 more
ENR-112772	ENR	Ralph T Mitchell	1990-02-21	UHC-17638-14	6095253763	3670 Spring St, Minneapolis, MN, 55402	0.50	Name re-cased Two-digit birth year Phone reformatted SSN last four extracted+3 more
TPA-61057	TPA	Rogers Ruszell	1989-10-26	—	4227611220	2184 Grand Ave # 413, Nashville, TN, 37248	0.50	Name re-cased Two-digit birth year Phone reformatted Unit split from street+3 more
PRV-28992	PRV	Timothy Carter	1941-02-01	UHC-21773-28	9864805461	405 Sage Ct, Sacramento, CA, 95803	0.50	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+3 more
PRV-27376	PRV	Teresa Rivera	1967-12-18	—	6133745860	9292 Forest Ave, Fresno, CA	0.50	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-106670	ENR	Sarah E Park	1964-06-27	UHC-57297-32	2248538438	1654 Church St, Atlanta, GA, 30343	0.50	Name re-cased Two-digit birth year Phone reformatted SSN last four extracted+3 more
ENR-139046	ENR	Kathryn I Wallace	1991-04-10	UHC-49905-75	6103310650	8278 Canyon Rd # 197, Jacksonville, FL, 32271	0.50	Date of birth reformatted Phone reformatted SSN last four extracted Unit split from street+3 more
CLM-405923	CLM	Rios Harold	—	—	—	6491 Highland Ave Apt 38, Jacksonville, FL, 32262	0.50	Name re-cased Date of birth unreadable Unit split from street Street suffix standardised+3 more
TPA-53404	TPA	Ronald Moore	1995-01-08	—	—	2050 Palm Dr, Fresno, CA, 93799	0.50	Name re-cased Date of birth reformatted Phone missing area code Street suffix standardised+3 more
ENR-136587	ENR	Kyle L Weber	1987-08-09	UHC-48005-03	9683645938	9279 Forest Ave, San Diego, CA, 92182	0.50	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+3 more
CLM-413684	CLM	Janice Robinson	—	UHC-21270-03	7003879475	5220 River Rd, Columbus, OH, 43244	0.50	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+3 more
CLM-431916	CLM	Amy H Pena	1939-08-28	UHC-89660-26	3843460863	9258 Hillcrest Rd # 611, Houston, TX, 77040	0.50	Name split from “Last, First”Phone reformatted Unit split from street Street suffix standardised+3 more
TPA-50427	TPA	Ann Campbell	2008-12-18	—	—	223 Indian School Rd, Denver, CO, 80250	0.50	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased+3 more
ENR-135532	ENR	Priya Little	1949-11-22	UHC-53505-69	7528168242	9710 Desert Sky Blvd, Columbus, OH, 43213	0.50	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-411917	CLM	Olivia Anderson	1990-05-17	UHC-15283-69	9216922501	4847 Bayshore Dr # 745, Tucson, AZ	0.50	Phone reformatted Unit split from street Street suffix standardised Address re-cased+3 more
ENR-129025	ENR	Kenneth H Kelley	2002-12-13	UHC-23045-77	9177800729	6639 Harbor Blvd, Tempe, AZ	0.50	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+3 more
TPA-59848	TPA	Judy Carroll	—	UHC-24401-98	9048292620	2492 Mountain View Dr, San Diego, CA, 92157	0.50	Name split from “Last, First”Date of birth unreadable Phone reformatted Street suffix standardised+3 more
CLM-414541	CLM	Bobby Carroll	1998-09-03	UHC-56827-60	4596140892	8355 Palm Dr Apt 24, Chandler, AZ, 85254	0.50	Phone reformatted Member ID reformatted Unit split from street Street suffix standardised+3 more
ENR-128976	ENR	Lucia Stone	1995-04-04	UHC-78323-14	8965624143	2092 Bayshore Dr, Tempe, AZ, 85240	0.50	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-113426	ENR	Jennifer J Nunez	1981-07-17	UHC-84002-20	4029078641	2821 Grand Ave, Eden Prairie, MN	0.50	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+3 more

55,824 rows, page 109 of 1,117Previous Next