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 “City re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagCity re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-409968	CLM	Hnery T Espinoza	1959-07-26	—	—	1745 Church St, Austin, TX, 78795	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-418739	CLM	Alice Herrera	1980-06-25	—	7517554693	4802 Camelback Rd, Tucson, AZ, 85783	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-428174	CLM	Denise Hughes	1997-09-03	UHC-60626-12	—	8318 Central Ave, Denver, CO, 80219	0.94	Member ID reformatted City re-cased Placeholder values cleared
CLM-410646	CLM	Logan Myers	1982-04-28	UHC-72669-14	—	7043 Pine Dr, Sacramento, CA, 95890	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-406150	CLM	Lori T Wright	1942-05-04	—	6514142846	815 Sunset Blvd, Columbus, OH, 43200	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-409495	CLM	Justin Russell	1972-06-26	—	—	2618 Church St, Nashville, TN, 37221	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-412935	CLM	Carl Lewis	1984-10-22	UHC-93843-37	—	1821 Bayshore Dr, Orlando, FL, 32879	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-428769	CLM	Kyle Delgado	1997-02-18	—	6677743819	8719 Maple Ave, Columbus, OH, 43297	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-410251	CLM	David Wheeler	1979-07-27	—	—	4607 Cedar Ln, Orlando, FL, 32806	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-421173	CLM	Carolyn Walker	1997-04-28	UHC-69841-87	—	911 Mountain View Dr, Minneapolis, MN, 55471	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-429688	CLM	Charlas McDonald	1943-08-24	UHC-75613-83	—	841 Spring St, Orlando, FL, 32851	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-429789	CLM	Nancy Marshall	1961-03-10	UHC-91729-28	—	9776 Main St, Phoenix, AZ, 85073	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-415936	CLM	Blly Fuller	1961-03-05	—	2473987039	4442 Ocean Ave, Eden Prairie, MN, 55326	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-415009	CLM	Sofa Rice	1966-12-03	—	—	7745 Meadow Ln, Charlotte, NC, 28250	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-421332	CLM	Marcus I Riley	1963-12-07	UHC-91091-69	8256558062	7986 Union St, Los Angeles, CA, 90099	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-406439	CLM	Mason Little	1947-02-26	UHC-15343-10	—	840 Market St, Gilbert, AZ, 85204	0.94	Member ID reformatted City re-cased Placeholder values cleared
CLM-413967	CLM	Jesse Q Snyder	1964-04-22	UHC-29952-88	—	7932 Palm Dr, Phoenix, AZ, 85097	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-426190	CLM	Rebecca Hoffman	1965-07-25	UHC-89652-89	—	218 Apache Blvd, Las Vegas, NV, 89176	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-400273	CLM	Ralph Barnes	1989-04-10	UHC-25693-03	3719487057	1252 Palm Dr, Denver, CO, 80224	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-429173	CLM	Judy Moore	2007-06-13	—	—	357 Willow Ct, Chandler, AZ, 85279	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-403948	CLM	John Perkins	1943-11-03	UHC-89638-37	—	9781 Harbor Blvd, Houston, TX, 77059	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-419040	CLM	Douglas Watkins	1967-08-01	UHC-70402-53	—	672 Central Ave, San Diego, CA, 92170	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-407916	CLM	Gabriel Y Castro	1938-06-04	—	—	7898 Union St, Atlanta, GA, 30397	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-412201	CLM	Sam Santos	2005-03-04	UHC-42300-84	—	7827 Church St, Seattle, WA, 98147	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-429701	CLM	Karen Li	1996-10-06	—	—	9765 Palm Dr, Seattle, WA, 98103	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-430191	CLM	Barbara Flores	1961-03-06	UHC-29272-09	—	5681 Washington St, Las Vegas, NV, 89129	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-418517	CLM	Virginia Hudson	1994-02-07	—	2086577829	5068 Ocean Ave, Dallas, TX, 75218	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-403657	CLM	Dot E Mejia	1939-07-16	UHC-42359-64	—	347 Lincoln Way, Glendale, AZ, 85354	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-406742	CLM	Ruth Mason	1990-01-14	UHC-21344-69	—	2577 Maple Ave, Eden Prairie, MN, 55381	0.94	Name re-cased City re-cased Whitespace trimmed
CLM-422085	CLM	Joyce I Duncen	1994-06-08	UHC-27486-99	8044194490	1676 Baseline Rd, Seattle, WA, 98139	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-430893	CLM	Samuel Gardner	1995-12-10	UHC-22256-29	9828686692	2570 Mountain View Dr, Dallas, TX, 75238	0.94	Name re-cased City re-cased Whitespace trimmed
CLM-416440	CLM	Nicholas Sullivan	2004-02-02	UHC-92592-07	—	6528 River Rd, Scottsdale, AZ, 85259	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-419803	CLM	Frances Henry	2001-02-07	—	9734465938	9019 Valley View Dr, Columbus, OH, 43278	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-430066	CLM	Kyle Meyer	1976-10-28	—	7879715728	5213 Lake View Rd, Tampa, FL, 33615	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-401804	CLM	Sara Ortega	1954-09-16	UHC-33453-03	—	8418 Lake View Rd, Scottsdale, AZ, 85269	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-422094	CLM	Mary N Reid	1967-09-18	UHC-42415-03	—	8889 Bayshore Dr, Dallas, TX, 75201	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-400069	CLM	Vincent Armstrong	1980-04-15	UHC-92198-01	—	2765 Bayshore Dr, Fresno, CA, 93752	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-428082	CLM	Ethn C Brown	1998-04-02	—	—	5273 Palm Dr, Dallas, TX, 75239	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-413798	CLM	Dylan Andrews	1961-11-08	UHC-71889-19	8068906466	7202 Washington St, Sacramento, CA, 95879	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-419997	CLM	Keith Meyer	1964-07-02	—	—	3607 Desert Sky Blvd, Mesa, AZ, 85222	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-422896	CLM	Jean Boyd	1986-07-09	UHC-11424-61	—	3545 Oak St, Las Vegas, NV, 89160	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-430811	CLM	Jordan P Evans	1991-12-13	UHC-87973-57	—	6438 Sage Ct, Columbus, OH, 43256	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-417657	CLM	Matthew Rice	1999-03-22	UHC-07938-13	—	6058 Apache Blvd, Houston, TX, 77066	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-423406	CLM	Philip Arnold	1969-03-11	—	—	1292 Highland Ave, Tampa, FL, 33679	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-413428	CLM	Kyle Richards	1981-02-28	UHC-09435-37	—	1539 Indian School Rd, Minneapolis, MN, 55433	0.94	City re-cased State code upper-cased Placeholder values cleared
CLM-427665	CLM	Alexis Bennett	1968-06-04	—	—	8577 Broadway, Sacramento, CA, 95882	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-420119	CLM	Steven Rios	1985-12-12	—	3214859684	7197 Desert Sky Blvd, Los Angeles, CA, 90050	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-430291	CLM	Daina Ran	1955-01-07	—	—	8473 Meadow Ln, Gilbert, AZ, 85209	0.94	City re-cased Email lower-cased Placeholder values cleared
CLM-425416	CLM	Willie L Roberts	1980-05-25	UHC-15064-57	—	5222 Ridge Rd, Miami, FL, 33107	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-406115	CLM	Juan S Banks	1979-05-19	—	—	7773 Forest Ave, Las Vegas, NV, 89164	0.94	Date of birth reformatted City re-cased Placeholder values cleared

5,235 rows, page 103 of 105Previous Next