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-411879	CLM	Amanda Richards	1978-03-09	UHC-87362-49	6905462200	1062 River Rd, Chandler, AZ, 85203	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-427156	CLM	Catherine Alvaez	1954-01-09	UHC-96515-31	9515467186	3719 Market St, Tucson, AZ, 85730	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-410652	CLM	Kathryn Porter	1976-03-17	UHC-28907-23	6793382184	1943 Broadway, Tucson, AZ, 85774	0.94	Name re-cased City re-cased Whitespace trimmed
CLM-427628	CLM	Frances Morrison	2003-12-12	UHC-80015-75	—	2791 Sunset Blvd, Tucson, AZ, 85737	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-400619	CLM	Gary D Thompson	2003-12-24	UHC-81856-96	—	7150 Main St, Miami, FL, 33116	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-411796	CLM	Samantha Walker	1979-07-04	UHC-63264-85	7909878375	1903 Baseline Rd, Denver, CO, 80237	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-431829	CLM	Russell Rojas	1966-11-19	UHC-09549-19	—	1584 Broadway, Houston, TX, 77069	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-421604	CLM	Andrew Henry	1966-11-20	—	—	2072 Maple Ave, Las Vegas, NV, 89105	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-404791	CLM	Roy Q Bennett	1950-11-23	UHC-17845-80	4639217582	4687 Central Ave, Scottsdale, AZ, 85270	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-427226	CLM	Kimberly Lucas	1954-06-01	—	2512450596	3323 Bayshore Dr, Tucson, AZ, 85737	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-408532	CLM	Brandon Day	1947-03-12	—	2109082186	5903 Maple Ave, Los Angeles, CA, 90046	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-409336	CLM	Sctot Jacobs	1954-07-22	—	—	9154 Cedar Ln, Seattle, WA, 98102	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-430365	CLM	Andrea Ortiz	1980-09-18	—	—	662 Union St, Tucson, AZ, 85792	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-430345	CLM	Mararet Fowler	1959-12-03	UHC-04517-23	—	3661 Main St, Austin, TX, 78721	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-432368	CLM	Teresa Woods	1968-09-17	UHC-42550-05	7654510728	4912 Hillcrest Rd, Chandler, AZ, 85221	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-432179	CLM	Amber Clark	1992-01-21	—	—	7558 Apache Blvd, Mesa, AZ, 85236	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-427331	CLM	Camila Phillips	1977-11-17	—	3873790587	3465 Hillcrest Rd, Atlanta, GA, 30305	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-411138	CLM	Vincent Larson	1988-05-15	UHC-73026-62	8854984227	2120 Church St, Dallas, TX, 75240	0.94	Member ID reformatted City re-cased Placeholder values cleared
CLM-412517	CLM	Kahtleen Munoz	1961-07-25	—	—	699 River Rd, Minneapolis, MN, 55486	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-404953	CLM	Stephen T Peterson	1980-01-06	UHC-33520-06	—	9687 Central Ave, Dallas, TX, 75221	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-400326	CLM	Jacqueline Joohnston	1999-08-07	UHC-56323-70	9353383997	568 Jefferson Ave, Plano, TX, 75077	0.94	Name re-cased Phone reformatted City re-cased
CLM-400728	CLM	Carlos Perkins	1998-11-01	—	—	5027 Willow Ct, San Antonio, TX, 78247	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-410837	CLM	Samueel Marshall	2008-01-11	UHC-42128-45	—	185 Union St, Columbus, OH, 43242	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-412628	CLM	Patricia Z Wheeler	1939-05-13	UHC-82575-80	—	3054 Oak St, San Diego, CA, 92195	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-424947	CLM	Daborah Luna	1953-12-05	UHC-71000-23	9327912460	5251 Camelback Rd, Gilbert, AZ, 85233	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-409971	CLM	Dylan K Foster	1970-07-22	—	4096537108	2855 Washington St, Minneapolis, MN, 55491	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-428394	CLM	Arrthur Rivera	1966-04-15	UHC-43347-56	—	8948 Apache Blvd, Houston, TX, 77054	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-425363	CLM	Betty Ortega	1952-05-09	UHC-77561-91	—	4966 Highland Ave, Dallas, TX, 75208	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-428147	CLM	Jerry A Williamson	1992-08-09	UHC-31382-25	3624722123	4925 Jefferson Ave, Chandler, AZ, 85233	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-406234	CLM	Victoria Z Schmidt	1988-06-12	UHC-00189-24	—	4939 Church St, Gilbert, AZ, 85276	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-412936	CLM	Carl Lewis	1984-10-22	—	—	1821 Bayshore Dr, Orlando, FL, 32879	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-411904	CLM	Sarah Dean	1997-09-15	UHC-11137-94	9206799707	510 Ocean Ave, Fresno, CA, 93730	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-400279	CLM	Heather Foster	2000-04-09	UHC-18247-46	—	7943 Central Ave, Miami, FL, 33108	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-427633	CLM	Justin Barnes	1967-11-25	UHC-19542-78	7253477336	7470 Valley View Dr, Seattle, WA, 98115	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-426377	CLM	Megan Pena	1972-03-24	UHC-99425-15	—	5555 River Rd, Nashville, TN, 37285	0.94	Date of birth reformatted City re-cased Plan code upper-cased
CLM-420680	CLM	Emma Hunt	1984-02-17	UHC-70237-17	—	3835 Central Ave, Miami, FL, 33161	0.94	Member ID reformatted City re-cased Placeholder values cleared
CLM-408676	CLM	Logan Ford	1989-11-18	—	—	1144 Meadow Ln, Miami, FL, 33133	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-405437	CLM	Stephen Z Nguyen	1998-12-10	UHC-57883-51	—	8406 Park Pl, Glendale, AZ, 85382	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-428808	CLM	Ryan Washington	1986-04-02	UHC-71334-44	—	7264 Lincoln Way, Glendale, AZ, 85361	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-401110	CLM	Timothy Harnandez	1991-07-06	—	—	3939 Pine Dr, Dallas, TX, 75204	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-428986	CLM	Becky Crawford	1957-08-12	UHC-35312-46	—	6408 Hillcrest Rd, Tempe, AZ, 85231	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-409760	CLM	Bryan Martinez	2008-10-21	UHC-39860-37	8102198850	4682 Washington St, Orlando, FL, 32825	0.94	Date of birth reformatted City re-cased Whitespace trimmed
CLM-411597	CLM	Austyn Morales	1992-04-08	UHC-73946-07	3978119293	898 Broadway, Charlotte, NC, 28266	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-419828	CLM	Cheryl Harper	1996-10-02	UHC-35989-19	—	404 Lincoln Way, San Antonio, TX, 78233	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-432270	CLM	Judy Morrison	1965-06-15	UHC-54028-49	7017695054	9692 Main St, Austin, TX, 78753	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-415205	CLM	Eugene Myers	1955-06-28	UHC-56385-29	7419021836	2739 Main St, Phoenix, AZ, 85016	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-411396	CLM	Jacob G Kelly	1990-05-14	UHC-64102-34	2818663241	9005 Hillcrest Rd, Austin, TX, 78705	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-407414	CLM	Diego Rose	1964-09-02	—	—	6107 Jefferson Ave, Tucson, AZ, 85795	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-416632	CLM	Dylan Butler	1971-06-18	UHC-67243-29	—	5807 Church St, Houston, TX, 77095	0.94	City re-cased Email lower-cased Whitespace trimmed
CLM-409967	CLM	Hnery T Espinoza	1959-07-26	—	—	1745 Church St, Austin, TX, 78795	0.94	City re-cased Whitespace trimmed Placeholder values cleared

5,235 rows, page 102 of 105Previous Next