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-404727	CLM	Jesse Hernandez	1989-02-19	UHC-29195-03	7966025148	2786 Spring St, Fresno, CA, 93736	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-402278	CLM	Doris Harper	1948-12-14	—	—	9289 Washington St, Denver, CO, 80215	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-423454	CLM	Diego Cunningham	1995-01-24	UHC-87978-96	8898050217	1083 Camelback Rd, Houston, TX, 77014	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-414227	CLM	Jesse Reyes	2006-02-10	—	2722119943	5187 Grand Ave, Chandler, AZ, 85293	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-422121	CLM	Lisa Stewart	1976-12-24	UHC-90359-21	6087795089	8323 Harbor Blvd, Houston, TX, 77005	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
CLM-403471	CLM	Andrea Scott	1947-02-12	UHC-70977-09	5432865021	4760 Mesa Dr, Glendale, AZ, 85348	0.92	Name re-cased Phone reformatted City re-cased Whitespace trimmed
CLM-425048	CLM	Mark Johnson	1989-09-14	UHC-68075-73	8887023078	3957 Willow Ct, Scottsdale, AZ, 85265	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-407457	CLM	Gary Boyd	1971-06-20	UHC-06620-65	—	5162 Jefferson Ave, Miami, FL, 33179	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-431324	CLM	Jack Jordan	1968-12-26	UHC-46514-85	—	7965 Washington St, Houston, TX, 77007	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-406177	CLM	Amanda Robertson	1964-07-04	UHC-15760-50	6689975161	3885 Mountain View Dr, Fresno, CA, 93769	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-422822	CLM	Terry Olson	1945-01-20	—	—	423 Elm St, Los Angeles, CA, 90058	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-424588	CLM	Janice Jordan	1966-03-24	UHC-98712-15	3608398659	774 Washington St, Nashville, TN, 37275	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
CLM-422148	CLM	Kieth Jordan	1998-05-23	UHC-51305-30	—	2390 Ridge Rd, Mesa, AZ, 85264	0.92	Date of birth reformatted Member ID reformatted City re-cased Placeholder values cleared
CLM-412690	CLM	Ralph Weaver	1944-03-16	UHC-96928-89	—	2447 Washington St, Orlando, FL, 32886	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-411026	CLM	Sara Andrews	1961-11-02	UHC-45537-10	—	6849 Pine Dr, Orlando, FL, 32867	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-425725	CLM	Kraen Warren	1955-07-06	UHC-82850-96	—	8255 Sunset Blvd, Tucson, AZ, 85723	0.92	Name re-cased Member ID reformatted City re-cased Placeholder values cleared
CLM-408193	CLM	Larry N Patterson	1993-11-15	—	7129873032	8912 Ocean Ave, San Antonio, TX, 78220	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
CLM-409763	CLM	Daniel E Flores	1959-12-17	UHC-10911-11	—	4711 Mesa Dr, Mesa, AZ, 85281	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
CLM-428163	CLM	Brandon Collins	1981-07-08	—	—	1704 Desert Sky Blvd, Tampa, FL, 33665	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-413747	CLM	Pamela Gutierrez	2005-08-08	UHC-39290-28	—	6224 Meadow Ln, Las Vegas, NV, 89191	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-412505	CLM	Donna Rivera	1975-08-12	UHC-91295-74	—	8277 Camelback Rd, Tempe, AZ, 85237	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-405931	CLM	Ken Turner	1956-10-21	UHC-72749-51	—	2587 Main St, Glendale, AZ, 85309	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
CLM-403976	CLM	Hannah Nguyen	1972-05-08	UHC-20168-56	—	8201 Meadow Ln, Dallas, TX, 75293	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-419361	CLM	Wallace Sofia	1989-07-10	—	—	1093 Ocean Ave, Orlando, FL, 32845	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-428565	CLM	Camila Roberts	1962-10-08	UHC-00540-94	—	6271 Spring St, Atlanta, GA, 30315	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-431173	CLM	Virginia Fernandez	1973-06-03	—	8542792861	3072 Ocean Ave, Jacksonville, FL, 32215	0.92	Date of birth reformatted Phone reformatted City re-cased Placeholder values cleared
CLM-408322	CLM	Valentina Hunter	1996-08-09	—	7874606518	6551 Oak St, Chandler, AZ, 85291	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
CLM-422415	CLM	Gary Espinoza	1942-02-25	UHC-09582-44	4234665072	1967 Union St, Scottsdale, AZ, 85237	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-410003	CLM	Denise Y Davis	1976-01-20	—	3135887336	8266 Oak St, Seattle, WA, 98149	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
CLM-408073	CLM	James Rodriguez	2001-03-20	—	2049632593	44 Meadow Ln, Charlotte, NC, 28289	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-410954	CLM	Noah Roberts	1962-03-21	—	—	3264 Sunset Blvd, Houston, TX, 77093	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-417934	CLM	Julie Myers	1971-06-16	UHC-98913-91	6525140597	2119 Apache Blvd, Fresno, CA, 93706	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
CLM-425746	CLM	Hannah Gilbert	1939-08-14	UHC-12376-13	—	1246 Ocean Ave, Dallas, TX, 75217	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-430701	CLM	Angela I Nelson	1947-08-01	UHC-42015-33	3872735798	2170 Apache Blvd, Gilbert, AZ, 85235	0.92	Date of birth reformatted Phone reformatted City re-cased Placeholder values cleared
CLM-413614	CLM	Gerald Gordon	1986-02-23	—	—	3242 Washington St, Orlando, FL, 32807	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-423966	CLM	Chris Phillisp	2005-12-25	—	—	5907 Ridge Rd, Phoenix, AZ, 85060	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-429412	CLM	Ray Day	1984-07-02	—	8372569229	8570 Main St, Miami, FL, 33153	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-427952	CLM	Katherine Santiago	1963-12-21	UHC-57983-34	—	2026 Sunset Blvd, Denver, CO, 80221	0.92	Member ID reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-414652	CLM	Noah Riley	1953-11-04	UHC-02806-19	3243538225	3332 Apache Blvd, Eden Prairie, MN, 55326	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
CLM-415172	CLM	Lori Matthews	2000-11-13	UHC-03231-10	—	6793 Market St, Mesa, AZ, 85218	0.92	City re-cased Plan code upper-cased Whitespace trimmed Placeholder values cleared
CLM-400120	CLM	Jason A Alexander	1980-11-03	UHC-25888-14	—	5105 Grand Ave, Glendale, AZ, 85382	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
CLM-420349	CLM	Evelyn Ramos	1989-05-05	—	6395603325	8644 Elm St, Plano, TX, 75019	0.92	Date of birth reformatted Phone reformatted City re-cased Placeholder values cleared
CLM-411177	CLM	Victoria K Padilla	1952-10-26	—	5064162948	5959 Canyon Rd, Las Vegas, NV, 89122	0.92	Date of birth reformatted Phone reformatted City re-cased Placeholder values cleared
CLM-400648	CLM	Christine Cook	1958-02-12	—	—	2663 Union St, Columbus, OH, 43298	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
CLM-404158	CLM	Priya Chavez	1999-09-07	—	4273622084	9749 Hillcrest Rd, Glendale, AZ, 85339	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
CLM-421071	CLM	Paul P Kelley	1997-01-22	UHC-55115-85	—	8971 Ocean Ave, Tucson, AZ, 85763	0.92	City re-cased Email lower-cased Whitespace trimmed Placeholder values cleared
CLM-401240	CLM	Virgnia Salazar	1954-12-03	UHC-82869-94	8316600224	3707 Ridge Rd, Sacramento, CA, 95832	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-401978	CLM	Tyler Guerrero	1989-03-25	—	2558771204	3570 Park Pl, Phoenix, AZ, 85026	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-421535	CLM	Mateo Q Oliver	1973-09-12	UHC-31496-33	—	3573 Grand Ave, Scottsdale, AZ, 85283	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-407517	CLM	Lawrence Maldonado	1994-07-20	—	—	7498 Main St, Glendale, AZ, 85367	0.94	Date of birth reformatted City re-cased Placeholder values cleared

5,235 rows, page 98 of 105Previous Next