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 “Member ID reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagMember ID reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-427289	CLM	Jack Martin	1991-09-05	UHC-42073-29	—	3818 Maple Ave, Las Vegas, NV, 89153	0.96	Member ID reformatted Placeholder values cleared
CLM-427630	CLM	Jordan Banks	1980-04-06	UHC-52328-19	—	8932 Elm St, Charlotte, NC, 28211	0.96	Member ID reformatted Placeholder values cleared
CLM-413606	CLM	Kevin Price	1988-06-23	UHC-67536-71	—	8595 Broadway, Austin, TX, 78786	0.96	Member ID reformatted Address re-cased
CLM-418432	CLM	Ronald O Crawford	1985-12-25	UHC-84729-70	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-417922	CLM	Danielle Martinez	1968-05-07	UHC-20534-65	—	2953 Valley View Dr, Plano, TX, 75095	0.96	Member ID reformatted Placeholder values cleared
CLM-427383	CLM	Lori Armstrong	1939-08-17	UHC-85173-78	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-416231	CLM	Larry Richardson	1968-09-23	UHC-86546-97	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-424215	CLM	Jessica Hart	1995-11-11	UHC-59133-55	4195358510	3161 Meadow Ln, Tampa, FL, 33677	0.96	Member ID reformatted Placeholder values cleared
CLM-431818	CLM	Maria D Moreno	1993-02-20	UHC-55990-89	5878269971	—	0.96	Member ID reformatted Placeholder values cleared
CLM-427810	CLM	Samuel Yang	1982-10-08	UHC-03605-29	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-406754	CLM	Wayne Turner	1948-09-01	UHC-74124-29	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-401316	CLM	Marilyn E Miller	1955-01-17	UHC-47254-57	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-421570	CLM	George X Robinson	1999-01-11	UHC-33174-40	9589138536	—	0.96	Member ID reformatted Placeholder values cleared
CLM-426918	CLM	Camila E Rodriguez	1945-09-18	UHC-63430-90	2476351402	4784 Baseline Rd, Phoenix, AZ, 85088	0.96	Member ID reformatted Placeholder values cleared
CLM-425318	CLM	Jennifer Payne	1968-12-18	UHC-43113-49	—	8320 Willow Ct, Glendale, AZ, 85338	0.96	Member ID reformatted Placeholder values cleared
CLM-408495	CLM	Virginia Jenkins	1985-02-17	UHC-21056-21	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-415925	CLM	Gary Hudson	1964-04-24	UHC-84393-87	2688594049	—	0.96	Member ID reformatted Placeholder values cleared
CLM-414895	CLM	Lisa Nunez	1998-11-13	UHC-01376-40	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-410256	CLM	Jessica Banks	1957-06-23	UHC-19304-45	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-425611	CLM	Timothy Lawrence	1973-06-15	UHC-34368-51	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-411992	CLM	Valentina Q Ortiz	1953-05-05	UHC-17863-08	—	6321 Mesa Dr, Nashville, TN, 37256	0.96	Member ID reformatted Placeholder values cleared
CLM-401247	CLM	Kevin A Gray	1944-07-03	UHC-41944-42	9134016009	—	0.96	Member ID reformatted Placeholder values cleared
CLM-425857	CLM	Priya Estrada	1960-06-09	UHC-24843-71	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-406377	CLM	Margaret Lawrence	1965-05-19	UHC-37511-76	7947442603	—	0.96	Phone reformatted Member ID reformatted
CLM-412304	CLM	Walter Cunningham	1943-01-05	UHC-39378-75	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-418127	CLM	Shirley Le	2002-03-28	UHC-24005-09	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-417468	CLM	Bobby Mendez	1987-11-04	UHC-62846-21	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-415261	CLM	Keith Vazquez	1987-09-27	UHC-45575-16	—	6693 Union St, Las Vegas, NV, 89126	0.96	Member ID reformatted Placeholder values cleared
CLM-412208	CLM	Jason Holmes	1944-04-09	UHC-86982-57	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-418970	CLM	Keith Robinson	1981-11-05	UHC-40022-20	—	7321 Baseline Rd, Los Angeles, CA, 90066	0.96	Member ID reformatted Placeholder values cleared
CLM-408015	CLM	Cheryl Daniels	1966-01-28	UHC-21002-42	2489555445	1820 Jefferson Ave, Phoenix, AZ, 85091	0.96	Phone reformatted Member ID reformatted
CLM-415705	CLM	Juan O Williams	1950-11-24	UHC-25722-63	2572871449	8198 Lincoln Way, Scottsdale, AZ, 85279	0.96	Member ID reformatted Placeholder values cleared
CLM-431763	CLM	Dylan Alexander	2003-08-15	UHC-29580-17	5559234313	—	0.96	Member ID reformatted Placeholder values cleared
CLM-401557	CLM	Santiago Rivera	1951-02-05	UHC-93168-85	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-402852	CLM	Santiago M Nunez	1954-08-27	UHC-42554-30	6593579338	8018 Union St, Chandler, AZ, 85236	0.96	Member ID reformatted Whitespace trimmed
CLM-418026	CLM	Mariana Henderson	1975-11-21	UHC-66782-51	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-422451	CLM	Roger Lawson	1955-03-01	UHC-72270-43	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-405018	CLM	Richard Washington	1988-08-26	UHC-88068-66	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-427070	CLM	Michelle P Baker	1989-05-27	UHC-65872-85	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-409154	CLM	Steven Gilbert	1963-10-24	UHC-22739-27	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-409155	CLM	Steven Gilbert	1963-10-24	UHC-22739-27	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-418525	CLM	Hiroshi Powell	1951-07-05	UHC-87923-96	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-413800	CLM	Angela Mitchell	1938-07-05	UHC-96967-57	—	2710 Valley View Dr, San Diego, CA, 92105	0.98	Member ID reformatted

2,293 rows, page 46 of 46Previous Next