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

Enrollment, flag “ZIP+4 trimmed”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP+4 trimmedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-111070	ENR	Natalie Hudson	2002-11-14	UHC-07480-19	6038664902	2089 Ocean Ave Apt 6, Plano, TX, 75072	0.64	Name re-cased Phone reformatted Unit split from street ZIP+4 trimmed+2 more
ENR-129320	ENR	Brian O Barnes	1984-10-09	UHC-48426-89	3054498682	1011 Meadow Ln, San Antonio, TX, 78281	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-106855	ENR	Evelyn Riley	1986-12-18	UHC-04663-24	5263498308	2147 Desert Sky Blvd, Mesa, AZ, 85284	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-131906	ENR	Megan L Nunez	1967-08-04	UHC-57892-81	—	143 Park Pl, Atlanta, GA, 30391	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-119775	ENR	Russell J Delgado	1992-08-23	UHC-92143-65	—	403 Apache Blvd, Tucson, AZ, 85766	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-122991	ENR	Diana Morales	1957-12-27	UHC-23661-33	6607107124	7398 Washington St, Los Angeles, CA, 90084	0.64	Street suffix standardised Address re-cased City re-cased ZIP+4 trimmed+2 more
ENR-113549	ENR	Judy Castillo	1984-08-08	UHC-07136-97	8293027152	8966 Mountain View Dr, Sacramento, CA, 95851	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-124114	ENR	Gloria F Bishop	1940-08-04	UHC-59408-54	5223822332	58 Mountain View Dr, San Antonio, TX, 78297	0.64	Name re-cased Date of birth reformatted City re-cased State name converted to code+2 more
ENR-137773	ENR	Mari Harper	1995-05-08	UHC-72350-71	2496435498	7783 Spring St, Sacramento, CA, 95804	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-102556	ENR	Stephanie W Berry	1945-05-06	UHC-73453-17	6064404132	7425 Main St, Tucson, AZ, 85748	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-131001	ENR	Alexis V Brown	2000-11-14	UHC-94763-21	4445339038	17 Harbor Blvd, Miami, FL, 33101	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-107064	ENR	Anthony Ryan	1984-06-28	UHC-95677-68	4217189564	4877 Mesa Dr, Atlanta, GA, 30369	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-120624	ENR	Vincent T Crawford	1963-08-06	UHC-57217-84	2935395650	2574 Oak St, Charlotte, NC, 28234	0.64	Phone reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
ENR-128144	ENR	Joshua Andrews	1993-02-11	UHC-24660-45	—	9516 Sunset Blvd, Minneapolis, MN, 55457	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-118671	ENR	Michelle W Rivera	1989-06-02	UHC-89576-64	3225737826	6134 Hillcrest Rd, Tampa, FL, 33667	0.64	Date of birth reformatted Phone reformatted State name converted to code ZIP+4 trimmed+2 more
ENR-138798	ENR	Denise Gray	2001-03-07	UHC-88527-68	9734819759	6142 Indian School Rd, Columbus, OH, 43203	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-134073	ENR	Cheryyl D Evans	1952-07-22	UHC-85677-77	7913998857	2276 Canyon Rd, Chandler, AZ, 85266	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-122248	ENR	Philip T Thomas	2003-05-05	UHC-21836-23	4322716466	7967 Meadow Ln, Mesa, AZ, 85248	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-130055	ENR	Barbarra X Brooks	1996-11-13	UHC-35893-48	7256006505	455 Main St, Tampa, FL, 33655	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-132422	ENR	Ethan Welch	1941-06-23	UHC-61196-41	6982498220	9226 Lake View Rd, Minneapolis, MN, 55409	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-135289	ENR	Ralph Mason	1989-09-28	UHC-17648-75	2048223500	8473 Union St, Plano, TX, 75085	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-119931	ENR	Janice G Reed	1957-03-01	UHC-32316-34	4714628912	3152 Harbor Blvd, Seattle, WA, 98129	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-104377	ENR	Christine J Ruiz	1966-08-16	UHC-81783-99	2557844055	3332 Willow Ct, Las Vegas, NV, 89104	0.64	Phone reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
ENR-134028	ENR	Debra L Marshall	2003-04-13	UHC-06922-26	6456655717	5514 Canyon Rd, Seattle, WA, 98135	0.64	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed+2 more
ENR-123421	ENR	Heather Dean	1963-05-10	UHC-96804-42	8834148938	5664 Canyon Rd, Fresno, CA, 93760	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-105320	ENR	Kenneth Pane	1973-10-27	UHC-66838-75	3633446374	4077 Grand Ave, Chandler, AZ, 85223	0.64	Phone reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
ENR-134107	ENR	Angela Andrews	1978-05-04	UHC-57110-63	8127878094	6304 Spring St, Denver, CO, 80236	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-113357	ENR	Isabella Le	1954-04-14	UHC-22656-20	9298176639	7791 Desert Sky Blvd, Orlando, FL, 32846	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-132277	ENR	Sara K Ellis	1940-08-10	UHC-10984-95	9067557792	2507 Sunset Blvd, Minneapolis, MN, 55417	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-137764	ENR	Billy Vargas	1955-10-23	UHC-55865-83	3144192218	4649 Sage Ct, San Antonio, TX, 78278	0.64	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-132882	ENR	Randy C Jensen	2008-05-28	UHC-83435-92	4107448684	7270 Ridge Rd, Austin, TX, 78717	0.64	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+2 more
ENR-109173	ENR	Anna T Turner	1974-02-09	UHC-90002-73	4577574672	6074 Willow Ct, Nashville, TN, 37250	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-120559	ENR	Timothy Q Berry	—	UHC-15965-49	2184037704	3376 Spring St, Dallas, TX, 75284	0.64	Name re-cased Date of birth unreadable Phone reformatted City re-cased+2 more
ENR-111776	ENR	Samantha Fields	2007-03-12	UHC-67440-52	4534841470	3019 Baseline Rd, Scottsdale, AZ, 85279	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-116038	ENR	Kathryn X Lopez	2001-01-08	UHC-90925-97	9363317270	2249 Valley View Dr, Scottsdale, AZ, 85265	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-122269	ENR	Lori P Henry	1974-04-27	UHC-32973-91	8059033696	5680 Hillcrest Rd, Tempe, AZ, 85237	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-110161	ENR	Laura C Hunt	1988-07-01	UHC-09969-91	—	8070 Market St, Tampa, FL, 33681	0.64	Name re-cased Member ID reformatted ZIP+4 trimmed Gender normalised+2 more
ENR-106047	ENR	Sera Grannt	1940-11-27	UHC-49131-62	8536737571	5360 Spring St, Denver, CO, 80288	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-139645	ENR	Julia R Hanson	2007-05-01	UHC-74657-99	3277539320	6216 Lincoln Way, Minneapolis, MN, 55479	0.64	Date of birth reformatted Phone reformatted SSN last four extracted ZIP+4 trimmed+2 more
ENR-133812	ENR	Alan V Gordon	1982-10-20	UHC-56291-44	5662652030	1254 Baseline Rd, Sacramento, CA, 95894	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-108777	ENR	Anna Adams	2003-09-24	UHC-72517-80	6932030709	504 Ridge Rd, Minneapolis, MN, 55488	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-141530	ENR	Samantha R Meyer	1994-09-03	UHC-62039-46	4275526247	5138 Market St, Tucson, AZ, 85774	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-108804	ENR	Joseph Schultz	1955-04-28	UHC-56387-51	9543192616	8741 Hillcrest Rd, Seattle, WA, 98142	0.64	Date of birth reformatted Phone reformatted ZIP+4 trimmed Gender normalised+2 more
ENR-102327	ENR	Bobby P Kelly	1975-04-25	UHC-98988-55	3875832552	7032 Mesa Dr, Plano, TX, 75090	0.64	Name re-cased Phone reformatted City re-cased ZIP+4 trimmed+2 more
ENR-122438	ENR	Cynthia G Wells	1959-08-17	UHC-58875-36	6892883120	4680 Desert Sky Blvd, Eden Prairie, MN, 55352	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-102591	ENR	Andrew J Munoz	1991-03-07	UHC-13020-18	8024952729	5572 Ridge Rd, Orlando, FL, 32811	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-121915	ENR	Nathan Ried	2008-12-27	UHC-64789-70	7248086884	7259 Mesa Dr, Glendale, AZ, 85373	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-124190	ENR	Rebecca Fuller	1939-08-19	UHC-58010-49	—	3291 Valley View Dr, Las Vegas, NV, 89143	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-116955	ENR	Mark K Foster	2008-06-21	UHC-60889-94	9626956927	1935 Baseline Rd, Jacksonville, FL, 32264	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-101333	ENR	Frances S Williamson	1987-05-23	UHC-65634-96	5116349753	128 Desert Sky Blvd, Miami, FL, 33180	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more

3,951 rows, page 44 of 80Previous Next