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-431260	CLM	Steve Medina	1945-08-08	—	7716492005	4508 Pine Dr, San Diego, CA, 92110	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-413247	CLM	Kimberly Lawson	1977-01-25	—	—	4007 River Rd, Denver, CO, 80298	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-402005	CLM	Kathleen Roberts	1979-08-12	UHC-60959-76	—	9030 Ocean Ave, Tampa, FL, 33636	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-420553	CLM	Joyce Andrews	2003-04-05	—	—	4125 Indian School Rd, Denver, CO, 80243	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-418878	CLM	Ethan Mitchell	1954-08-17	UHC-64818-21	—	4533 Valley View Dr, Atlanta, GA, 30372	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-422369	CLM	Bruce Dean	1983-05-07	UHC-92761-61	4503754132	1899 Oak St, Houston, TX, 77033	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-428238	CLM	Catherine Dean	1969-09-17	—	8727311589	7856 Highland Ave, Mesa, AZ, 85214	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-402501	CLM	Lauren L Nunez	1976-04-15	—	—	8700 Oak St, Sacramento, CA, 95864	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-410382	CLM	Roy Torres	1994-07-03	UHC-49244-99	—	9744 Hillcrest Rd, Las Vegas, NV, 89146	0.94	City re-cased Plan code upper-cased Placeholder values cleared
CLM-409439	CLM	Emily Stewart	2005-11-05	—	—	4286 Forest Ave, Atlanta, GA, 30366	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-404105	CLM	Zachay Carpenter	1946-09-12	—	—	4234 Central Ave, Phoenix, AZ, 85025	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-417037	CLM	Olivia Bradley	1950-11-05	UHC-21842-25	—	293 Grand Ave, Sacramento, CA, 95873	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-420580	CLM	Sandra Long	1985-01-27	—	—	4841 Broadway, Miami, FL, 33167	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-422295	CLM	Jacob Anderson	1939-07-06	UHC-85935-92	—	2590 Maple Ave, Seattle, WA, 98194	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-405339	CLM	Luis Hill	1942-10-27	UHC-27600-40	—	7828 Meadow Ln, Gilbert, AZ, 85271	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-422014	CLM	Sofia Lawrence	2001-04-24	UHC-25799-28	—	3103 Apache Blvd, Los Angeles, CA, 90044	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-429178	CLM	Jake Collins	1994-02-26	UHC-37345-24	—	879 Willow Ct, Jacksonville, FL, 32270	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-415007	CLM	Charles Burke	1991-05-15	UHC-82580-99	—	3100 Lake View Rd, Atlanta, GA, 30302	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-413094	CLM	Aisha Perez	1985-06-02	UHC-74165-04	—	9553 Elm St, Tampa, FL, 33622	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-405190	CLM	Benjamin Hunt	1993-07-05	UHC-46402-70	4923271607	8179 Indian School Rd, Atlanta, GA, 30372	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-430087	CLM	Amy Butler	1959-06-20	—	—	1003 Harbor Blvd, Tucson, AZ, 85753	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-401923	CLM	Teresa Harvey	1995-07-24	UHC-30222-34	3347836443	4064 Palm Dr, Mesa, AZ, 85261	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-430252	CLM	Ashley Mejia	1969-02-05	UHC-53643-77	—	4736 Desert Sky Blvd, Scottsdale, AZ, 85286	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-412910	CLM	Virginia Foster	1940-02-10	—	—	8712 Central Ave, Gilbert, AZ, 85221	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-417309	CLM	Isabella Cook	2003-12-09	UHC-20907-19	4063223680	1808 Elm St, Eden Prairie, MN, 55386	0.94	Date of birth reformatted City re-cased Whitespace trimmed
CLM-418660	CLM	Luis Martin	1977-08-21	UHC-11583-17	—	4379 Elm St, Jacksonville, FL, 32260	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-414175	CLM	Ralph Wang	1957-12-03	—	—	5835 Washington St, Chandler, AZ, 85295	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-427441	CLM	Philip Valdez	2002-07-04	UHC-98601-37	—	2007 Mountain View Dr, Eden Prairie, MN, 55320	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-429686	CLM	Arjun Martinez	1977-04-11	UHC-00639-60	6263650166	4739 Baseline Rd, Atlanta, GA, 30364	0.94	Phone reformatted City re-cased Whitespace trimmed
CLM-422514	CLM	Zachary Lawrence	2004-01-13	UHC-98739-62	—	607 Jefferson Ave, Phoenix, AZ, 85099	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-418662	CLM	Ralph T Marshall	1975-02-01	UHC-99444-67	—	2360 Park Pl, Eden Prairie, MN, 55308	0.94	City re-cased Plan code upper-cased Placeholder values cleared
CLM-423335	CLM	Lauren Porter	1962-08-04	UHC-47113-19	4033406949	1731 Harbor Blvd, Orlando, FL, 32892	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-417635	CLM	Brian Jones	1959-10-24	—	2994734601	2328 Pine Dr, San Antonio, TX, 78267	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-422419	CLM	Christian Little	1980-06-27	—	—	5811 Church St, Orlando, FL, 32888	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-413392	CLM	Paul Li	2002-09-16	UHC-71953-24	—	1720 Market St, Seattle, WA, 98123	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-403122	CLM	Thomas M Harper	1963-08-11	UHC-63183-48	—	1758 Elm St, Jacksonville, FL, 32212	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-408707	CLM	Emily Martin	2000-10-02	UHC-21382-50	—	7853 Valley View Dr, Tucson, AZ, 85746	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-408299	CLM	Lisa Morris	1996-08-12	—	—	9708 Market St, Eden Prairie, MN, 55384	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-401283	CLM	Mei Y Wallace	1983-07-04	UHC-65492-93	—	6462 Central Ave, Plano, TX, 75075	0.94	Member ID reformatted City re-cased Placeholder values cleared
CLM-409174	CLM	Martha Sims	1958-08-11	UHC-77509-15	—	8579 Mountain View Dr, Sacramento, CA, 95879	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-402588	CLM	Eric W Wright	1939-06-11	UHC-72315-78	—	5338 Main St, Mesa, AZ, 85239	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-402993	CLM	Gregory Lee	1971-11-13	UHC-72345-25	7274827948	3487 Ocean Ave, Atlanta, GA, 30326	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-410356	CLM	Pamela Richards	1991-07-24	UHC-61406-34	—	4676 Mountain View Dr, San Diego, CA, 92173	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-414766	CLM	Amber Brown	1983-07-08	UHC-31542-62	—	2625 Bayshore Dr, Charlotte, NC, 28214	0.94	City re-cased State code upper-cased Placeholder values cleared
CLM-406304	CLM	Jeremy Cooper	1953-06-19	UHC-58280-15	—	6598 Union St, Charlotte, NC, 28251	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-400377	CLM	Debra Jensen	1953-08-27	—	—	3112 Highland Ave, Las Vegas, NV, 89182	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-425203	CLM	Mary Smith	1945-07-09	UHC-90352-19	—	1344 Apache Blvd, Austin, TX, 78704	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-432722	CLM	Jacob X Wagner	1987-08-08	—	—	6552 Cedar Ln, Denver, CO, 80239	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-420200	CLM	Mateo Alvarez	1994-06-14	—	2563989739	8301 Lake View Rd, Denver, CO, 80212	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-420201	CLM	Mateo Alvarez	1994-06-14	—	2563989739	8301 Lake View Rd, Denver, CO, 80212	0.94	Phone reformatted City re-cased Placeholder values cleared

5,235 rows, page 101 of 105Previous Next