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 “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-136349	ENR	Ronald C Hernandez	1963-12-28	UHC-59399-26	8649458497	1684 Union St, Tempe, AZ, 85252	0.66	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-114044	ENR	Sarah Bowman	1983-04-27	UHC-65972-52	3436679817	3180 Apache Blvd, Los Angeles, CA, 90041	0.66	Name re-cased Phone reformatted State name converted to code ZIP+4 trimmed+1 more
ENR-115659	ENR	Donald O Lynch	1999-02-27	UHC-41325-80	—	2835 Lake View Rd, Mesa, AZ, 85265	0.66	Name re-cased Two-digit birth year State code upper-cased ZIP+4 trimmed+1 more
CLM-417473	CLM	Grace Coleman	1983-09-28	UHC-12992-59	7408669557	9679 Meadow Ln, Tucson, AZ, 85711	0.66	Date of birth reformatted Phone reformatted ZIP+4 trimmed Gender normalised+1 more
TPA-55310	TPA	Billy Lawson	1989-05-13	—	—	2366 Oak St, Columbus, OH, 43203	0.66	Street suffix standardised Address re-cased City re-cased ZIP+4 trimmed+1 more
CLM-410926	CLM	Rachel Willis	1975-12-03	UHC-19492-19	—	12 Ocean Ave, Charlotte, NC, 28279	0.66	Date of birth reformatted State code upper-cased ZIP+4 trimmed Gender normalised+1 more
PRV-20064	PRV	Deborah T Murray	2003-04-24	UHC-81038-07	—	3737 Baseline Rd, Scottsdale, AZ, 85253	0.66	Name re-cased Date of birth reformatted State name converted to code ZIP+4 trimmed+1 more
PRV-20065	PRV	Deborah T Murray	2003-04-24	UHC-81038-07	—	3737 Baseline Rd, Scottsdale, AZ, 85253	0.66	Name re-cased Date of birth reformatted State name converted to code ZIP+4 trimmed+1 more
TPA-60786	TPA	Ana P Burns	2008-04-14	—	—	5119 Willow Ct, Dallas, TX, 75272	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
PRV-26875	PRV	Robert H Stone	1972-01-08	UHC-11766-70	3274236988	4545 Cedar Ln, Eden Prairie, MN, 55319	0.66	Name split from “Last, First”Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-104522	ENR	Willie R Torres	1979-07-09	UHC-44435-18	5303858684	3439 Valley View Dr, Tampa, FL, 33603	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
CLM-415595	CLM	Jackie Wang	1977-10-24	UHC-85294-14	—	6566 Indian School Rd, Tempe, AZ, 85266	0.66	Two-digit birth year City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
ENR-129250	ENR	Lauren Vasquez	1969-06-01	UHC-16499-87	4536605087	6717 Pine Dr, Los Angeles, CA, 90049	0.66	Name split from “Last, First”Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-52343	TPA	Edward Herrera	1942-04-27	—	7516314351	8620 Harbor Blvd, Tampa, FL, 33676	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
TPA-57773	TPA	David Andrews	1950-09-02	UHC-01919-18	6954009348	3567 Sunset Blvd, Jacksonville, FL, 32215	0.66	Phone reformatted State name converted to code ZIP+4 trimmed Whitespace trimmed+1 more
ENR-118854	ENR	Priya W Franklin	1985-01-04	UHC-46621-29	6724324548	3923 Sunset Blvd, Mesa, AZ, 85291	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
CLM-425169	CLM	Bety D Miller	1965-05-22	UHC-10655-76	5808533523	4060 Indian School Rd, Tampa, FL, 33671	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
TPA-59343	TPA	Juan Dean	1978-07-12	—	9192093811	7400 Church St, Glendale, AZ, 85376	0.66	Phone reformatted State name converted to code ZIP+4 trimmed Whitespace trimmed+1 more
CLM-402049	CLM	Stephanie Allen	1995-11-20	UHC-51810-47	—	8645 Apache Blvd, Tempe, AZ, 85210	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-403762	CLM	Aliec Robinson	1955-12-26	UHC-97366-44	—	8625 Spring St, Eden Prairie, MN, 55365	0.66	Street suffix standardised Address re-cased City re-cased ZIP+4 trimmed+1 more
ENR-101497	ENR	Dorothy Jackson	2008-11-10	UHC-09214-53	9759369494	6142 Lake View Rd, Denver, CO, 80268	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
CLM-422261	CLM	Omar C Obiren	1976-06-22	—	5864108616	3990 Meadow Ln, Chandler, AZ, 85245	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-132787	ENR	Rachel Soto	2000-09-28	UHC-26861-94	6369522000	865 Oak St, Tampa, FL, 33681	0.66	Phone reformatted ZIP+4 trimmed Gender normalised Plan code upper-cased+1 more
ENR-132786	ENR	Rachel Soto	2000-09-28	UHC-26861-94	6369522000	865 Oak St, Tampa, FL, 33681	0.66	Phone reformatted ZIP+4 trimmed Gender normalised Plan code upper-cased+1 more
ENR-126481	ENR	Randy Medina	1973-05-25	UHC-46897-05	8387381476	2559 Washington St, San Antonio, TX, 78292	0.66	Phone reformatted State name converted to code ZIP+4 trimmed Email lower-cased+1 more
PRV-26952	PRV	Bruce Hart	—	—	8842144282	2479 Mesa Dr, Tucson, AZ, 85786	0.66	Date of birth unreadable City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-415835	CLM	Kenneth Thompson	1952-02-21	—	—	2624 Central Ave, San Antonio, TX, 78270	0.66	Name re-cased Date of birth reformatted ZIP+4 trimmed Gender normalised+1 more
CLM-422794	CLM	Vincent Russell	1998-07-01	UHC-99059-22	—	1656 Maple Ave, Eden Prairie, MN, 55319	0.66	Street suffix standardised Address re-cased State code upper-cased ZIP+4 trimmed+1 more
PRV-26294	PRV	Virginia Clark	1956-11-05	UHC-07844-60	3832297394	8280 Forest Ave, Phoenix, AZ, 85031	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-425384	CLM	Joan Santos	1978-01-04	—	5335437294	9445 Park Pl, Scottsdale, AZ, 85216	0.66	Phone reformatted ZIP+4 trimmed Gender normalised Whitespace trimmed+1 more
ENR-114457	ENR	Amanda D Allen	1938-10-14	UHC-08169-97	5872179484	8015 Bayshore Dr, San Antonio, TX, 78213	0.66	Street suffix standardised Address re-cased City re-cased ZIP+4 trimmed+1 more
ENR-133386	ENR	Yuki S Bradley	1968-03-18	UHC-33277-67	4419526572	7211 Jefferson Ave, Eden Prairie, MN, 55360	0.66	Date of birth reformatted Phone reformatted ZIP+4 trimmed Gender normalised+1 more
PRV-21629	PRV	Joshua Johnston	2000-11-19	—	7685883071	6768 Jefferson Ave, Eden Prairie, MN, 55369	0.66	Name re-cased Date of birth reformatted ZIP+4 trimmed Gender normalised+1 more
ENR-122813	ENR	Kimebrly Q Gardner	1968-11-23	UHC-05701-79	—	1126 Washington St, Columbus, OH, 43247	0.66	Name re-cased Date of birth reformatted State name converted to code ZIP+4 trimmed+1 more
CLM-421564	CLM	Julie M Singh	1975-08-19	UHC-47477-34	8257944127	4749 Maple Ave, Fresno, CA, 93721	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-116058	ENR	Edward H Myers	—	UHC-95659-89	4238847530	4250 Grand Ave, Tempe, AZ, 85203	0.66	Date of birth unreadable Phone reformatted City re-cased ZIP+4 trimmed+1 more
ENR-128906	ENR	Mason Mitcheell	1970-02-12	UHC-65663-44	5912815733	3286 Cedar Ln, Houston, TX, 77009	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
TPA-52414	TPA	Ann Simpson	1975-01-13	—	4268308851	63 Indian School Rd, Tempe, AZ, 85297	0.66	Date of birth reformatted Phone reformatted ZIP+4 trimmed Gender normalised+1 more
CLM-407095	CLM	Ahmed Ortiz	1963-02-05	—	—	210 Maple Ave, San Antonio, TX, 78245	0.66	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
TPA-52535	TPA	Rebecca Burton	1945-09-24	—	—	4816 Central Ave, Orlando, FL, 32873	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
PRV-28045	PRV	Daavid Henry	1938-09-08	UHC-00305-08	—	7188 Broadway, San Diego, CA, 92109	0.66	Address re-cased State name converted to code ZIP+4 trimmed Whitespace trimmed+1 more
PRV-28046	PRV	Daavid Henry	1938-09-08	UHC-00305-08	—	7188 Broadway, San Diego, CA, 92109	0.66	Address re-cased State name converted to code ZIP+4 trimmed Whitespace trimmed+1 more
ENR-104932	ENR	Jeffrey O Allen	1990-01-02	UHC-29346-52	6203934513	3685 Sunset Blvd, Chandler, AZ, 85287	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
CLM-422679	CLM	Kathryn Berry	1945-05-22	UHC-89770-54	8813003887	6986 Washington St, Houston, TX, 77052	0.66	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
CLM-407386	CLM	Katherine James	2001-09-14	UHC-01774-66	—	6636 Highland Ave, Miami, FL, 33180	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
ENR-128981	ENR	Kelly Welch	1949-07-22	UHC-86290-81	9232145248	3905 Valley View Dr, Austin, TX, 78756	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Whitespace trimmed+1 more
TPA-59822	TPA	Barbara Howadr	1979-03-23	—	—	3433 Highland Ave, Fresno, CA, 93736	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-101030	ENR	Denny Lynch	1951-08-21	UHC-81258-19	—	4357 Cedar Ln, Atlanta, GA, 30378	0.66	Member ID reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
CLM-429370	CLM	Logan P Sanders	1962-11-27	UHC-91805-80	—	5114 Forest Ave, Fresno, CA, 93769	0.66	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-126295	ENR	Gregory S Wagner	1968-04-22	UHC-10634-98	9892776402	3175 Mesa Dr, Scottsdale, AZ, 85228	0.66	Name split from “Last, First”Date of birth reformatted State code upper-cased ZIP+4 trimmed+1 more

8,263 rows, page 107 of 166Previous Next