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 “Date of birth reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagDate of birth reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-409750	CLM	Isabella Stephens	1976-12-10	UHC-72948-48	—	8454 Park Pl, Sacramento, CA, 95809	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-415915	CLM	Julie R Rios	1994-08-06	—	8954299276	—	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-418545	CLM	Jean Wang	1965-07-21	UHC-49440-91	—	2348 Elm St, Glendale, AZ, 85368	0.92	Name re-cased Date of birth reformatted Member ID reformatted Placeholder values cleared
CLM-428551	CLM	Doris Reynolds	1992-03-28	UHC-16338-92	9422925042	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-417255	CLM	Jerry Adams	1969-04-08	UHC-89076-74	3582723830	5849 Maple Ave, Scottsdale, AZ, 85289	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-403212	CLM	Russell Tucker	1953-03-14	UHC-79982-50	—	7821 Central Ave, Scottsdale, AZ, 85262	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-415989	CLM	Nancy T Burton	1996-06-19	UHC-61653-51	—	2337 Desert Sky Blvd, Houston, TX, 77068	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-432193	CLM	Joe Herrera	1993-11-14	UHC-92339-35	—	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-409683	CLM	Allice Foster	1950-02-28	—	3505449710	61 Lake View Rd, Columbus, OH, 43274	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-414020	CLM	Fatima Boyd	1985-07-28	UHC-18372-48	—	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-429596	CLM	Adam Yonug	1999-03-16	—	—	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-431034	CLM	Lauren Snyder	1956-08-01	UHC-29407-99	—	4984 Lincoln Way, Chandler, AZ, 85266	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
CLM-412779	CLM	Joshua Moreno	1994-08-02	UHC-31320-52	—	5782 Market St, Mesa, AZ, 85262	0.92	Date of birth reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-413444	CLM	Amber Murphy	1987-03-06	UHC-67086-87	9599301050	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-426885	CLM	John Warren	1949-09-03	—	5816515165	6498 Sage Ct, Fresno, CA, 93700	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-426558	CLM	Ruth B Spencer	2002-07-12	UHC-50944-63	—	1966 Main St, Tempe, AZ, 85241	0.92	Date of birth reformatted Email lower-cased Whitespace trimmed Placeholder values cleared
CLM-409574	CLM	Heather T Welch	1979-04-06	—	2082019606	4656 Pine Dr, Fresno, CA, 93790	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-429206	CLM	Eric Martin	1956-08-28	UHC-27656-65	9554440435	2962 Jefferson Ave, Miami, FL, 33197	0.92	Date of birth reformatted Phone reformatted Member ID reformatted Placeholder values cleared
CLM-427550	CLM	Ronald D Masson	1991-06-18	UHC-98035-99	—	655 Hillcrest Rd, Chandler, AZ, 85231	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-408894	CLM	Gerald Munoz	1949-12-16	UHC-69213-94	—	—	0.92	Name re-cased Date of birth reformatted Member ID reformatted Placeholder values cleared
CLM-404287	CLM	Alex Morrison	1945-12-23	UHC-72453-69	—	7056 Cedar Ln, Chandler, AZ, 85200	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-403467	CLM	Dorothy Murphy	2007-02-08	—	9012272654	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-421899	CLM	Alexis Price	1958-09-09	—	9034940566	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-403328	CLM	Robert Mathtews	2003-08-17	UHC-95918-52	—	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-426588	CLM	Jacoob Jimenez	1983-11-07	—	7103017058	1086 Ocean Ave, Houston, TX, 77041	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-423838	CLM	Noah Ortiz	1988-06-04	UHC-65429-19	6593427028	3793 Park Pl, Minneapolis, MN, 55435	0.92	Name re-cased Date of birth reformatted Member ID reformatted Whitespace trimmed
CLM-403158	CLM	Judith Rivera	1968-04-15	UHC-20415-76	9057262201	5604 Ridge Rd, Los Angeles, CA, 90005	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-416227	CLM	Gabriel Z Jenkins	2006-12-21	UHC-85992-41	—	3483 Willow Ct, Plano, TX, 75041	0.92	Date of birth reformatted Email lower-cased Whitespace trimmed Placeholder values cleared
CLM-406660	CLM	Joyce Perry	1972-09-08	—	4637818286	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-428327	CLM	Valentina Greene	1961-04-03	—	5088957041	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-408432	CLM	Denise Gordon	1992-06-04	—	9232226495	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-412680	CLM	Billy V Nunez	1974-06-02	—	—	4507 Mesa Dr, Jacksonville, FL, 32295	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-410786	CLM	Justin Castro	1943-10-26	UHC-41901-62	3366027995	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Whitespace trimmed
CLM-414807	CLM	William Nelson	1969-02-23	UHC-40816-54	4174585752	3672 Main St, San Antonio, TX, 78268	0.92	Date of birth reformatted Phone reformatted City re-cased Placeholder values cleared
CLM-405324	CLM	Bobby I Gonzalz	2007-05-01	UHC-49663-87	—	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-400487	CLM	Evelyn Nguyen	1967-08-18	—	3925464089	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-409307	CLM	Emma Q Estrada	1978-03-01	—	4696908266	7700 Sage Ct, Charlotte, NC, 28269	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-429940	CLM	Lauren Johnson	1991-06-20	—	2182276792	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-411417	CLM	Ashley Ryan	1968-11-18	UHC-36732-55	5507050464	—	0.92	Name re-cased Date of birth reformatted Plan code upper-cased Placeholder values cleared
CLM-423917	CLM	Lisa Wong	1966-09-13	—	—	6788 Oak St, Tucson, AZ, 85722	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-425237	CLM	Nicole Moore	1958-11-01	UHC-21710-41	8595155433	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-424975	CLM	Teressa Bishop	1961-04-10	UHC-34907-30	—	314 Church St, Tampa, FL, 33601	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-411186	CLM	Alan G Hoffman	1983-06-23	UHC-11329-12	6496540688	3527 Bayshore Dr, Fresno, CA, 93778	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-426657	CLM	Denise Carroll	1969-10-11	UHC-30539-11	5527330564	—	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-430266	CLM	Anna K Knight	1952-02-05	—	—	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-402394	CLM	Randy Harrison	1985-11-20	UHC-93922-74	—	5559 Sage Ct, Chandler, AZ, 85226	0.92	Date of birth reformatted City re-cased Plan code upper-cased Placeholder values cleared
CLM-407680	CLM	Valentina A Price	2004-04-24	UHC-82856-79	6477209931	9812 Meadow Ln, Phoenix, AZ, 85032	0.92	Name re-cased Date of birth reformatted Phone reformatted Whitespace trimmed
CLM-401986	CLM	Stephanie W Berry	1945-05-06	—	6064404132	7425 Main St, Tucson, AZ, 85748	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-423253	CLM	Juan E Mills	1949-05-25	UHC-33516-52	—	—	0.92	Name re-cased Date of birth reformatted Email lower-cased Placeholder values cleared
CLM-426444	CLM	Doris Rivera	1969-02-21	UHC-42495-13	2635246876	—	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared

10,559 rows, page 175 of 212Previous Next