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 “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
CLM-406737	CLM	Barb Warren	1979-06-15	UHC-54834-89	—	9804 Ocean Ave, Austin, TX, 78763	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-410490	CLM	Nathan Haall	1939-08-26	UHC-65209-99	—	7748 Bayshore Dr, Austin, TX, 78735	0.82	City re-cased ZIP+4 trimmed Placeholder values cleared
CLM-430304	CLM	Mariana T Gordon	2002-12-27	UHC-48651-30	—	8499 Broadway, Nashville, TN, 37243	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-420940	CLM	Alexander F Ellis	1979-08-14	UHC-09595-15	—	219 Lincoln Way, Denver, CO, 80234	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-416781	CLM	Karen Meyer	1970-12-09	UHC-87829-83	6386826572	211 Ridge Rd, Atlanta, GA, 30338	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
CLM-402438	CLM	Billy Armstrong	1954-11-20	—	—	2707 Lincoln Way, Charlotte, NC, 28217	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
CLM-426074	CLM	Emily Ward	1981-03-05	—	—	789 Valley View Dr, Austin, TX, 78718	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-415003	CLM	James Grey	1952-01-18	UHC-36465-69	—	5047 Union St, Charlotte, NC, 28266	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-402311	CLM	Christine Andrews	1951-11-11	UHC-52132-50	—	5495 Willow Ct, Mesa, AZ, 85224	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-414795	CLM	Pamela K Btler	1995-11-10	—	9757403631	8619 Spring St, Miami, FL, 33198	0.82	City re-cased ZIP+4 trimmed Placeholder values cleared
CLM-413574	CLM	Christopher Willis	1971-11-03	UHC-00681-59	—	6655 Cedar Ln, Miami, FL, 33189	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-426852	CLM	Aaron Scott	1982-12-27	—	7855170650	4438 Lincoln Way, Seattle, WA, 98129	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-420783	CLM	Gary Jenkins	1989-05-08	—	—	5509 Palm Dr, Jacksonville, FL, 32273	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-421882	CLM	Ruth White	1966-07-16	UHC-31890-56	8156371465	262 Washington St, Los Angeles, CA, 90041	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-421881	CLM	Ruth White	1966-07-16	UHC-31890-56	8156371465	262 Washington St, Los Angeles, CA, 90041	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-408481	CLM	Richard Oliver	1966-04-09	—	—	4100 Valley View Dr, Charlotte, NC, 28285	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-415780	CLM	Emma Rojas	2008-10-11	UHC-27356-85	6893282164	1920 Spring St, Las Vegas, NV, 89105	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-406756	CLM	Eugene Elliott	1945-03-11	UHC-77796-83	7748269784	3781 Lincoln Way, Columbus, OH, 43244	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-422788	CLM	Joseph Walsh	1997-05-25	UHC-54154-91	2296377020	7920 Indian School Rd, Las Vegas, NV, 89108	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-413126	CLM	Frank Howard	1971-07-01	—	—	5872 Jefferson Ave, Nashville, TN, 37253	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-400320	CLM	Edward Wilson	2006-07-10	—	—	8344 Bayshore Dr, Denver, CO, 80215	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-405443	CLM	Jason Mills	1948-12-08	UHC-87174-74	—	1493 Sage Ct, Columbus, OH, 43203	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
CLM-421852	CLM	Eric Watson	2005-01-05	—	—	6608 Elm St, Fresno, CA, 93767	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
CLM-409237	CLM	Philip L White	1972-02-13	UHC-46377-93	4058227289	7194 Ocean Ave, Chandler, AZ, 85239	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-423972	CLM	Isabella Edwards	1948-09-23	—	—	2003 Washington St, Tucson, AZ, 85704	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
CLM-404866	CLM	Elizabeth Hawkins	1999-04-14	—	9709534215	8844 Maple Ave, Eden Prairie, MN, 55350	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-407219	CLM	Bobby Wang	1988-10-27	UHC-78541-97	8244797281	8463 Central Ave, Mesa, AZ, 85277	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-423091	CLM	Amber N Watkins	1976-10-16	—	—	9383 Baseline Rd, Tempe, AZ, 85292	0.82	ZIP+4 trimmed Email lower-cased Placeholder values cleared
CLM-421392	CLM	Mariana Vasquez	1978-07-23	UHC-43094-42	—	3090 Canyon Rd, Dallas, TX, 75208	0.82	City re-cased ZIP+4 trimmed Placeholder values cleared
CLM-405981	CLM	Luis K Reynolds	1946-04-03	UHC-81820-65	—	5142 Baseline Rd, Tucson, AZ, 85705	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-420869	CLM	Don N Hernandez	1976-04-09	UHC-18780-96	7905633254	8741 Union St, Orlando, FL, 32802	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-410501	CLM	Christian Y Gibson	1999-04-16	—	7906028534	564 Bayshore Dr, Phoenix, AZ, 85088	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-419174	CLM	Russell C Cunningham	1971-02-19	—	—	4697 Sage Ct, Eden Prairie, MN, 55356	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-432372	CLM	Ana Mendoza	1983-03-07	—	—	2702 Lake View Rd, Atlanta, GA, 30307	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-405655	CLM	Victoria Evans	1994-03-26	—	—	9661 Forest Ave, Houston, TX, 77068	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-423844	CLM	Marcus Coleman	1964-04-27	UHC-67091-76	6195191216	9477 Highland Ave, Sacramento, CA, 95820	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-428841	CLM	Samantha Bell	1970-12-02	—	—	5505 Church St, Tampa, FL, 33695	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-417750	CLM	Gerald Sandoval	1994-01-28	UHC-41043-56	—	1877 Mesa Dr, Mesa, AZ, 85212	0.82	Member ID reformatted ZIP+4 trimmed Placeholder values cleared
CLM-431553	CLM	Rebecca Payne	1939-03-10	—	—	1740 Union St, Nashville, TN, 37257	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-410933	CLM	Jesse D Warren	2008-11-17	UHC-51170-46	—	7100 Hillcrest Rd, Gilbert, AZ, 85243	0.82	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
CLM-415014	CLM	Jacob Y Burns	1948-11-14	UHC-30689-30	5763835286	3973 Canyon Rd, Atlanta, GA, 30328	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-414065	CLM	Joshua Griffin	1983-10-16	UHC-65735-65	7497250019	4411 Apache Blvd, Phoenix, AZ, 85006	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-402295	CLM	Julie Fernandez	1978-03-03	UHC-84577-80	—	1216 Desert Sky Blvd, Atlanta, GA, 30382	0.82	Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
CLM-403287	CLM	Frances Alvarez	1963-10-24	—	7766880620	9208 Central Ave, Miami, FL, 33130	0.82	Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-407322	CLM	Black Jean	2006-07-24	UHC-16293-86	—	7087 Lincoln Way, Nashville, TN, 37274	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-418484	CLM	Ruth B Bell	1991-06-20	UHC-51877-99	6492200725	5894 Central Ave, Scottsdale, AZ, 85240	0.82	Phone reformatted ZIP+4 trimmed Whitespace trimmed
CLM-401682	CLM	Abigail Coleman	1951-01-12	—	—	6206 Ridge Rd, Denver, CO, 80291	0.82	City re-cased ZIP+4 trimmed Placeholder values cleared
CLM-420400	CLM	Paul Brooks	1952-10-21	—	—	5911 Lake View Rd, Tucson, AZ, 85762	0.82	State code upper-cased ZIP+4 trimmed Placeholder values cleared
CLM-410972	CLM	Sadra X Peterson	1970-06-24	UHC-01975-42	—	9822 Washington St, Los Angeles, CA, 90097	0.82	Name re-cased ZIP+4 trimmed Placeholder values cleared
CLM-414949	CLM	Randy Singh	1989-05-12	UHC-68184-37	—	9754 Central Ave, Phoenix, AZ, 85000	0.82	ZIP+4 trimmed Whitespace trimmed Placeholder values cleared

2,352 rows, page 45 of 48Previous Next