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

Claims, flag “Name re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagName re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-403004	CLM	Ethan Alexander	1973-07-04	UHC-55550-61	—	4421 Baseline Rd, Glendale, AZ, 85387	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-405605	CLM	Adam Vasquez	1978-12-15	UHC-91157-09	3974287745	9625 Hillcrest Rd, Charlotte, NC, 28263	0.78	Name re-cased Phone reformatted City re-cased Gender normalised+1 more
CLM-411867	CLM	Helen West	1953-01-09	UHC-20637-25	—	5497 Lincoln Way, Mesa, AZ, 85289	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-429339	CLM	Eric Gonzales	2001-08-13	UHC-63564-60	—	2240 Park Pl # 738, Mesa, AZ, 85226	0.78	Name re-cased Date of birth reformatted Unit split from street Whitespace trimmed+1 more
CLM-400969	CLM	Megan N Fields	2000-05-15	—	—	1242 Spring St, Columbus, OH, 43212	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-402977	CLM	Mason E Santos	1964-03-21	UHC-10432-64	4643040276	8308 Canyon Rd, Glendale, AZ, 85385	0.78	Name re-cased Date of birth reformatted State name converted to code Whitespace trimmed+1 more
CLM-400822	CLM	Carl Obrien	1976-10-12	UHC-87879-70	3207359504	3482 Jefferson Ave, Minneapolis, MN, 55456	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-431875	CLM	Patricia Rice	1951-11-26	—	9116215964	8745 Mesa Dr, Los Angeles, CA, 90086	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-425480	CLM	Bobby Nelson	1951-02-11	UHC-69366-19	—	1327 Willow Ct, Los Angeles, CA, 90060	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-415655	CLM	Jack A Garza	1965-12-27	UHC-07484-53	—	5373 Apache Blvd, Tempe, AZ, 85203	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-422857	CLM	Jose Wagner	2000-01-15	UHC-77119-28	4139683862	2135 Spring St, Scottsdale, AZ, 85211	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-404599	CLM	Andrwe Arnod	1988-09-26	—	4315869218	3704 Spring St, Tampa, FL, 33606	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-418440	CLM	Megan Ford	2008-05-18	—	7163555354	1688 Bayshore Dr, Columbus, OH, 43231	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-422066	CLM	Nancy Deean	1947-05-23	UHC-88622-29	8347463387	3690 Union St, Glendale, AZ, 85359	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-411791	CLM	Donald Vazquez	2006-12-21	UHC-90411-84	4253503136	4164 Palm Dr, Chandler, AZ, 85266	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-409234	CLM	Logan Hamilton	1972-01-12	UHC-20469-91	—	—	0.78	Name re-cased Date of birth reformatted Phone missing area code Whitespace trimmed+1 more
CLM-430457	CLM	Benjamin Ferguson	1948-02-20	—	—	6269 Willow Ct, Eden Prairie, MN, 55325	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-412312	CLM	Barbara Schultz	1997-02-25	—	7303432627	1266 Spring St, Dallas, TX, 75294	0.78	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+1 more
CLM-425610	CLM	Nicole Evans	1960-04-28	—	4706640162	2462 Maple Ave, Tucson, AZ, 85720	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-400277	CLM	Amber Soto	2001-06-04	UHC-45707-34	—	1088 Hillcrest Rd, Denver, CO, 80282	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-409117	CLM	Mary Lee	1950-04-12	—	—	9630 Elm St, Glendale, AZ, 85390	0.78	Name re-cased City re-cased Gender normalised Whitespace trimmed+1 more
CLM-405021	CLM	Camila V Cook	1965-08-06	—	—	—	0.78	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed+1 more
CLM-428952	CLM	Lori Miller	1942-02-11	—	—	138 Harbor Blvd, Nashville, TN, 37242	0.78	Name re-cased State name converted to code Plan code upper-cased Whitespace trimmed+1 more
CLM-421475	CLM	Marcus Howell	1997-01-01	UHC-94996-60	—	337 Mesa Dr, San Antonio, TX, 78216	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-418687	CLM	Samuel J Oliver	1968-03-01	—	5809294918	3743 Church St, Houston, TX, 77089	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-418907	CLM	Austin M Li	1962-04-04	UHC-41620-28	—	3597 Spring St, Plano, TX, 75029	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-404892	CLM	John Howard	1961-10-08	UHC-27071-31	3454797241	5582 Lake View Rd, Las Vegas, NV, 89141	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-428066	CLM	Jasun Hunt	1963-12-08	UHC-16244-46	—	3113 Park Pl, Tempe, AZ, 85216	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-406030	CLM	Joaan B Weaver	1968-11-18	UHC-44176-53	6462763604	1111 Ocean Ave, San Antonio, TX, 78242	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-402435	CLM	Karen Little	1959-03-03	UHC-06105-79	—	—	0.78	Name re-cased Date of birth reformatted Phone missing area code Member ID reformatted+1 more
CLM-423192	CLM	Nicholas T Jenkins	1953-07-18	—	—	6227 Spring St, Tucson, AZ, 85788	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-427889	CLM	Aaron R West	—	UHC-59920-60	3736760892	8485 Hillcrest Rd, Charlotte, NC, 28223	0.78	Name re-cased Date of birth missing Phone reformatted Whitespace trimmed+1 more
CLM-403316	CLM	Scott Barnes	1999-01-19	—	6877396692	8037 Forest Ave, Chandler, AZ, 85280	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-428638	CLM	Christina Mitchell	1960-10-28	UHC-77759-59	5852691353	228 Union St, Jacksonville, FL, 32216	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-425790	CLM	Zachary U Morris	1985-09-28	UHC-13938-46	7708862801	6131 Central Ave, San Antonio, TX, 78221	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-402306	CLM	Steven Griffin	1964-06-03	—	9233736481	—	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
CLM-408190	CLM	Gregory Wang	1960-03-23	UHC-40108-70	7148345056	934 Ocean Ave # 632, Columbus, OH, 43248	0.78	Name re-cased Phone reformatted Member ID reformatted Unit split from street+1 more
CLM-417695	CLM	Lawrnce Dixon	1944-10-03	UHC-77814-35	4038637607	2001 Grand Ave, Scottsdale, AZ, 85281	0.78	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed+1 more
CLM-402197	CLM	Susan Morris	1958-03-10	—	8002943029	6814 Baseline Rd, Jacksonville, FL, 32291	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-422999	CLM	Kathleen Richardsno	1967-09-20	—	—	2828 Mountain View Dr, Glendale, AZ, 85364	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-410763	CLM	Diane Henderson	1946-12-20	UHC-09074-03	3942601676	6357 Oak St, Phoenix, AZ, 85000	0.78	Name re-cased Phone reformatted State name converted to code Whitespace trimmed+1 more
CLM-415592	CLM	Kyle L Paters	2007-09-05	UHC-11956-50	5007224761	4340 Union St, Jacksonville, FL, 32267	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-412065	CLM	Shirley Lane	1952-07-02	—	—	3295 Pine Dr, Las Vegas, NV, 89189	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-420460	CLM	Janet Mendoza	1998-11-26	UHC-13188-27	—	5780 Mountain View Dr, San Diego, CA, 92101	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-404664	CLM	Roger Payne	2005-04-06	UHC-87094-74	—	2210 Ridge Rd, Chandler, AZ, 85210	0.78	Name re-cased Street suffix standardised Address re-cased Plan code upper-cased+1 more
CLM-423940	CLM	Marc I Myers	1949-12-23	UHC-16071-16	—	—	0.78	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed+1 more
CLM-404711	CLM	Charles Rice	1968-08-21	—	—	7601 Spring St, Tampa, FL, 33662	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-406076	CLM	Lisa Foter	1995-08-24	UHC-72634-68	—	1012 Broadway, Houston, TX, 77058	0.78	Name re-cased City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-400992	CLM	Amber N Greene	1942-05-19	—	2484631948	7738 Market St, Denver, CO, 80286	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-426472	CLM	Deborah Castro	1938-01-23	UHC-96293-49	—	3560 Church St, Gilbert, AZ, 85256	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more

13,120 rows, page 138 of 263Previous Next