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

Third-party administrator, flag “Date of birth reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagDate of birth reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-57347	TPA	Matthew Munoz	1999-05-08	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-58250	TPA	Christian Jamees	1977-10-08	—	—	9378 Oak St, Tempe, AZ, 85242	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-63348	TPA	Jaan R Knight	1961-04-01	—	—	9744 Jefferson Ave, Fresno, CA, 93744	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-63095	TPA	Scott Mason	1974-04-01	—	—	6312 Grand Ave, Columbus, OH, 43228	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
TPA-50102	TPA	Angela Ezpinoza	1979-07-09	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-54176	TPA	Ryan Evans	1974-02-07	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-55704	TPA	Arjun Owens	1962-06-08	—	—	7641 Broadway, Eden Prairie, MN, 55380	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-57723	TPA	Christopher Guerrero	1990-08-04	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-57524	TPA	Campbell Amanda	1940-10-01	—	5622652929	8762 Indian School Rd, Orlando, FL, 32834	0.94	Date of birth reformatted Email lower-cased Placeholder values cleared
TPA-55705	TPA	Gregory Schulz	1969-02-25	UHC-14832-94	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-53455	TPA	Lauren Sanchez	2008-04-04	—	—	9759 Highland Ave, Columbus, OH, 43200	0.96	Date of birth reformatted Placeholder values cleared
TPA-55716	TPA	Luca Young	1942-11-09	UHC-46362-85	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-53781	TPA	Ann Murphy	1974-11-17	—	—	4819 Church St, Charlotte, NC, 28266	0.96	Date of birth reformatted Placeholder values cleared
TPA-63193	TPA	Jacob Perez	1971-06-12	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-59828	TPA	Douglas Meyer	1959-04-10	—	9713337835	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-64267	TPA	Olivia Richards	1954-07-12	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-63786	TPA	Allexis Elliott	1965-02-04	—	—	9576 Cedar Ln, Atlanta, GA, 30344	0.96	Date of birth reformatted Placeholder values cleared
TPA-53843	TPA	Dennis Lawrence	1953-09-10	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-61364	TPA	James Li	2003-12-03	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-62379	TPA	Mary Brown	2006-08-18	—	—	5961 Ridge Rd, Mesa, AZ, 85268	0.96	Date of birth reformatted Email lower-cased
TPA-52528	TPA	Lauren Henry	1957-01-25	UHC-78612-29	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-52594	TPA	James Barnes	1989-12-07	—	—	5095 Meadow Ln, Eden Prairie, MN, 55362	0.96	Date of birth reformatted Placeholder values cleared
TPA-57429	TPA	Janet Cruz	1942-09-25	UHC-97798-27	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-60989	TPA	Bradley Martinez	1970-07-23	—	—	6301 Park Pl, Minneapolis, MN, 55404	0.96	Date of birth reformatted Placeholder values cleared
TPA-59791	TPA	Heather Watson	1999-02-19	UHC-13281-28	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-61494	TPA	David Jacobs	1999-01-03	UHC-26875-93	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-59996	TPA	Julie Weaver	1977-09-06	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-59420	TPA	Yuki Contreras	1997-03-01	—	—	4549 Broadway, Phoenix, AZ, 85046	0.96	Date of birth reformatted Placeholder values cleared
TPA-56318	TPA	Deborrah Yag	1976-08-28	—	—	4152 Lincoln Way, Orlando, FL, 32843	0.96	Date of birth reformatted Placeholder values cleared
TPA-58725	TPA	Jose Chavez	1960-04-27	—	—	8383 Sage Ct, Scottsdale, AZ, 85277	0.96	Date of birth reformatted Placeholder values cleared
TPA-53938	TPA	Brittany Wheeler	1971-09-05	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-52052	TPA	Margaret Miller	1941-01-12	UHC-71305-12	3995753322	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-59853	TPA	Stephen Dominguez	1997-02-23	UHC-14104-16	5108078448	2598 Jefferson Ave, Phoenix, AZ, 85058	0.96	Date of birth reformatted Placeholder values cleared
TPA-57765	TPA	Henry Graham	1969-04-04	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-57764	TPA	Henry Graham	1969-04-04	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-55256	TPA	Christine Scott	1955-07-27	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-61759	TPA	Lori Allen	1938-12-02	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-63130	TPA	Noah Hudson	1970-10-06	—	—	8252 Washington St, Sacramento, CA, 95820	0.96	Date of birth reformatted Placeholder values cleared
TPA-63131	TPA	Noah Hudson	1970-10-06	—	—	8252 Washington St, Sacramento, CA, 95820	0.96	Date of birth reformatted Placeholder values cleared
TPA-62853	TPA	Diana Hunter	1979-08-04	—	—	5523 Central Ave, Tampa, FL, 33646	0.96	Date of birth reformatted Placeholder values cleared
TPA-54452	TPA	Austin Schmidt	1973-01-04	—	—	6057 Palm Dr, Gilbert, AZ, 85286	0.96	Date of birth reformatted Placeholder values cleared
TPA-63154	TPA	Julia Chapman	2008-09-26	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-50437	TPA	Heather Spencer	1971-03-24	—	—	7133 Church St, Los Angeles, CA, 90065	0.96	Date of birth reformatted Placeholder values cleared
TPA-64181	TPA	Anthony Ramos	1970-08-25	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-55775	TPA	Jonathan Q Ruiz	1954-10-10	—	—	5460 Broadway, Plano, TX, 75096	0.96	Date of birth reformatted Placeholder values cleared
TPA-63281	TPA	Linda Gray	1991-05-06	UHC-75175-37	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-50663	TPA	Ralh Gonzalez	1994-03-16	—	—	7003 Jefferson Ave, Las Vegas, NV, 89189	0.96	Date of birth reformatted Placeholder values cleared
TPA-51574	TPA	Jacqueline Fowler	1991-02-11	—	8907417379	9633 Central Ave, Los Angeles, CA, 90086	0.96	Date of birth reformatted Placeholder values cleared
TPA-61200	TPA	Andrew Berry	2003-04-08	—	—	—	0.96	Date of birth reformatted Placeholder values cleared
TPA-58613	TPA	Kayla S Vasquez	1949-12-04	UHC-56091-77	—	9411 Elm St, Jacksonville, FL, 32264	0.96	Date of birth reformatted Placeholder values cleared

4,728 rows, page 92 of 95Previous Next