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 “Phone missing area code”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagPhone missing area codeClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-429139	CLM	Fatima Payne	1984-11-02	—	—	—	0.82	Name re-cased Phone missing area code Placeholder values cleared
ENR-124747	ENR	Arthur W Morgan	1960-10-08	UHC-67883-75	—	166 Broadway, Houston, TX, 77045	0.82	Phone missing area code Member ID reformatted Whitespace trimmed
TPA-63536	TPA	Lisa Y Larson	1984-07-02	—	—	6402 Sage Ct, Orlando, FL, 32890	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
PRV-28729	PRV	Samuel Daniels	1977-11-16	—	—	—	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
ENR-111229	ENR	Larry Spencer	1961-04-01	UHC-08518-76	—	3145 Sunset Blvd, Austin, TX, 78795	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
CLM-418079	CLM	Ann Webb	1950-10-01	UHC-30929-91	—	6699 Lincoln Way, Los Angeles, CA, 90022	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
CLM-401359	CLM	Barb Taylor	1976-03-10	—	—	2598 Lincoln Way, Chandler, AZ, 85217	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
ENR-130821	ENR	Janet Bradley	1942-06-19	UHC-27276-25	—	5772 Harbor Blvd, Tucson, AZ, 85791	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
CLM-405234	CLM	Vicky Hawkins	1973-05-10	—	—	—	0.82	Name re-cased Phone missing area code Placeholder values cleared
ENR-106220	ENR	Kathy Wilson	1996-07-18	UHC-91837-53	—	5507 Pine Dr, Tampa, FL, 33611	0.82	Name re-cased Phone missing area code Placeholder values cleared
CLM-414070	CLM	Jordan Jenkins	1957-12-17	—	—	—	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
CLM-430190	CLM	Julia Carroll	1966-01-08	UHC-78156-75	—	5514 Palm Dr, Minneapolis, MN, 55414	0.82	Name re-cased Phone missing area code Placeholder values cleared
CLM-403069	CLM	Philip Reynolds	1954-06-13	—	—	—	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
ENR-100102	ENR	Joseph R Williamson	1987-02-24	UHC-66377-79	—	5362 Union St, Houston, TX, 77041	0.82	Name re-cased Phone missing area code Email lower-cased
CLM-418276	CLM	Karen Aguilar	1960-01-06	UHC-80528-02	—	552 Hillcrest Rd, Atlanta, GA, 30384	0.82	Phone missing area code Member ID reformatted Placeholder values cleared
ENR-141184	ENR	Bruce Powell	1978-03-31	UHC-34913-07	—	5287 Broadway, Phoenix, AZ, 85045	0.82	Phone missing area code Address re-cased Whitespace trimmed
ENR-115312	ENR	Larry Q Morrison	1999-12-14	UHC-07583-42	—	1961 Lincoln Way, Sacramento, CA, 95856	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
ENR-119073	ENR	Diane Sims	1961-03-12	UHC-36638-27	—	7991 Central Ave, Orlando, FL, 32836	0.82	Date of birth reformatted Phone missing area code Whitespace trimmed
ENR-122727	ENR	Kimberly A Flores	1976-05-10	UHC-66093-90	—	4412 Desert Sky Blvd, Columbus, OH, 43259	0.82	Phone missing area code City re-cased Whitespace trimmed
PRV-23828	PRV	Christine Carter	1939-10-14	—	—	—	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
CLM-430149	CLM	Samantha N Howard	1955-11-11	UHC-54388-27	—	—	0.82	Name re-cased Phone missing area code Placeholder values cleared
TPA-53726	TPA	Donald Fields	1981-05-24	—	—	7784 Broadway, Houston, TX, 77076	0.82	Phone missing area code City re-cased Placeholder values cleared
CLM-427223	CLM	Teresa V Sims	1981-01-25	—	—	—	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
CLM-428821	CLM	Eric Shaw	1996-01-06	UHC-14709-71	—	5021 Indian School Rd, Charlotte, NC, 28276	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
CLM-420512	CLM	Mason McDonald	1986-08-05	UHC-00884-35	—	2917 Central Ave, Sacramento, CA, 95867	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
ENR-106671	ENR	Dorothy X Hicks	1941-08-16	UHC-59594-14	—	4823 Main St, Minneapolis, MN, 55435	0.82	Phone missing area code Email lower-cased Whitespace trimmed
ENR-106146	ENR	Albert Ray	1963-01-25	UHC-24942-04	—	4063 Elm St, Denver, CO, 80232	0.82	Phone missing area code Email lower-cased Whitespace trimmed
PRV-27075	PRV	Vicky Schmidt	1993-04-02	—	—	82 Canyon Rd, Orlando, FL, 32861	0.82	Phone missing area code City re-cased Placeholder values cleared
ENR-101498	ENR	Bryan Hansen	1945-11-13	UHC-58991-88	—	8403 Palm Dr, Scottsdale, AZ, 85226	0.82	Date of birth reformatted Phone missing area code Whitespace trimmed
CLM-422949	CLM	Betty Evans	1998-04-26	—	—	—	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
CLM-410503	CLM	Amber Salazar	1962-12-17	UHC-68878-86	—	—	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
CLM-424817	CLM	Justin Gordon	1988-03-01	UHC-82612-26	—	2293 Union St, Denver, CO, 80284	0.82	Name re-cased Phone missing area code City re-cased
ENR-136720	ENR	Amy Carter	1974-11-08	UHC-60876-16	—	5782 Jefferson Ave, Seattle, WA, 98132	0.82	Phone missing area code City re-cased Email lower-cased
ENR-117344	ENR	Deborah J Garza	1955-12-05	UHC-75382-34	—	8782 Indian School Rd, Phoenix, AZ, 85078	0.82	Name re-cased Phone missing area code Whitespace trimmed
ENR-122094	ENR	Arjun R Powell	1962-04-16	UHC-79018-17	—	3746 Spring St, Atlanta, GA, 30369	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
CLM-420389	CLM	Daniel Ortiz	1946-03-06	UHC-95981-27	—	—	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
PRV-21942	PRV	Rachel Lopez	1939-02-07	UHC-36747-79	—	8989 Valley View Dr, Chandler, AZ, 85236	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
CLM-429225	CLM	Steve Wheeler	1999-03-01	—	—	6745 Camelback Rd, Orlando, FL, 32819	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-56803	TPA	Paul Lewis	1972-03-11	—	—	8134 Harbor Blvd, Houston, TX, 77003	0.82	Name re-cased Phone missing area code Placeholder values cleared
CLM-428281	CLM	Emily Montgomery	2004-03-03	UHC-51886-82	—	—	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
ENR-113636	ENR	Aaron M Larson	1995-06-15	UHC-25525-72	—	7090 Union St, Minneapolis, MN, 55418	0.82	Name re-cased Phone missing area code Email lower-cased
PRV-23257	PRV	Frannk Lawrence	1979-09-09	UHC-94025-69	—	8715 Grand Ave, Atlanta, GA, 30364	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
ENR-115045	ENR	Andrew Edwards	1957-06-19	UHC-43496-82	—	—	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
CLM-426123	CLM	Christopher Harris	1948-11-20	UHC-90418-51	—	3241 Valley View Dr, Tucson, AZ, 85782	0.82	Name re-cased Phone missing area code Placeholder values cleared
ENR-107409	ENR	Mason Morales	1942-02-27	UHC-35536-56	—	9675 Indian School Rd, Tempe, AZ, 85270	0.82	Phone missing area code Plan code upper-cased Whitespace trimmed
CLM-408823	CLM	Zachary Bryant	2006-07-04	UHC-87908-27	—	1840 Sage Ct, Charlotte, NC, 28253	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
CLM-403195	CLM	Dennis Hunt	1993-03-07	—	—	9777 Mountain View Dr, Columbus, OH, 43245	0.82	Phone missing area code City re-cased Placeholder values cleared
ENR-106254	ENR	Russell M Coleman	1944-12-09	UHC-61125-89	—	805 Apache Blvd, Columbus, OH, 43274	0.82	Date of birth reformatted Phone missing area code Whitespace trimmed
CLM-415458	CLM	Noah Bryant	1949-03-15	—	—	—	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
ENR-134697	ENR	Cynthia D Carlson	1997-07-15	UHC-39422-61	—	4545 Park Pl, Chandler, AZ, 85297	0.82	Name re-cased Phone missing area code State code upper-cased

2,021 rows, page 39 of 41Previous Next