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

All sources, 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-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
PRV-24426	PRV	Cheryl Henderson	1993-07-27	UHC-31875-96	8965456508	—	0.96	Member ID reformatted Placeholder values cleared
TPA-51428	TPA	Jacob Larson	1956-04-26	UHC-52805-48	4215827082	—	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
ENR-123680	ENR	Betty Y Martinez	1968-04-26	UHC-57515-46	—	3912 Central Ave, Los Angeles, CA, 90010	0.96	Member ID reformatted Whitespace trimmed
ENR-124230	ENR	Deborah Vargas	1982-08-06	UHC-83336-39	6229138079	1445 Bayshore Dr, Charlotte, NC, 28287	0.96	Member ID reformatted Whitespace trimmed
CLM-416231	CLM	Larry Richardson	1968-09-23	UHC-86546-97	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-104578	ENR	Shirley Jimenez	1969-11-13	UHC-69587-45	8715617419	103 Park Pl, Scottsdale, AZ, 85227	0.96	Date of birth reformatted Member ID reformatted
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
ENR-135163	ENR	Alexis L Howard	1982-01-11	UHC-61648-73	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-100674	ENR	Michael P Berry	1992-08-04	UHC-59279-12	3706219605	7385 Canyon Rd, Orlando, FL, 32858	0.96	Date of birth reformatted Member ID reformatted
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
ENR-121953	ENR	Alexander T Ross	1957-08-23	UHC-09946-39	9546289856	2466 Harbor Blvd, Seattle, WA, 98176	0.96	Phone reformatted Member ID reformatted
CLM-406754	CLM	Wayne Turner	1948-09-01	UHC-74124-29	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-122054	ENR	Marcus McDonald	2001-09-22	UHC-77150-32	6898090179	6411 Broadway, Houston, TX, 77085	0.96	Member ID reformatted Whitespace trimmed
ENR-103750	ENR	Cheryl Perez	1941-09-13	UHC-08438-30	9824885903	6038 Main St, Jacksonville, FL, 32260	0.96	Phone reformatted Member ID reformatted
ENR-102051	ENR	Tommy Stewart	1960-06-23	UHC-08537-44	9397965846	7193 Sage Ct, Charlotte, NC, 28227	0.96	Phone reformatted Member ID reformatted
ENR-140124	ENR	Valentina Johnston	1981-12-19	UHC-79512-66	4665431792	8285 Apache Blvd, Dallas, TX, 75245	0.96	Member ID reformatted City re-cased
ENR-121577	ENR	Diego Hamilton	1956-03-22	UHC-02423-88	2739568412	—	0.96	Name re-cased Member ID reformatted
ENR-128480	ENR	Mei Thompson	1939-08-02	UHC-95512-03	2675761969	2488 Church St, Orlando, FL, 32806	0.96	Phone reformatted Member ID reformatted
CLM-401316	CLM	Marilyn E Miller	1955-01-17	UHC-47254-57	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-126854	ENR	Bruce Flores	1966-11-27	UHC-16437-41	4078173894	8234 Market St, Nashville, TN, 37212	0.96	Member ID reformatted Whitespace trimmed
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
ENR-121599	ENR	Beverly V Aguilar	1992-04-15	UHC-96753-34	8893726618	5561 Main St, Minneapolis, MN, 55480	0.96	Member ID reformatted Whitespace trimmed
ENR-122052	ENR	Mason Garcia	2005-05-04	UHC-90864-72	7774349539	4991 Park Pl, Miami, FL, 33170	0.96	Phone reformatted Member ID reformatted
CLM-408495	CLM	Virginia Jenkins	1985-02-17	UHC-21056-21	—	—	0.96	Member ID reformatted Placeholder values cleared
TPA-59471	TPA	Christian Mendez	1983-12-11	UHC-32156-74	—	9346 Market St, Tucson, AZ, 85710	0.96	Member ID reformatted Placeholder values cleared
ENR-112745	ENR	Terry Y Holmes	1973-09-04	UHC-16727-88	—	7082 Bayshore Dr, Austin, TX, 78721	0.96	Name re-cased Member ID reformatted
ENR-112746	ENR	Terry Y Holmes	1973-09-04	UHC-16727-88	—	7082 Bayshore Dr, Austin, TX, 78721	0.96	Name re-cased Member ID reformatted
ENR-130909	ENR	Cynthia V Medina	2004-08-19	UHC-10029-27	—	6001 Desert Sky Blvd, Scottsdale, AZ, 85221	0.96	Member ID reformatted Placeholder values cleared
ENR-141662	ENR	Rebecca Espinoza	1954-12-27	UHC-91958-97	9055432749	8352 Main St, Phoenix, AZ, 85042	0.96	Name re-cased Member ID reformatted
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
ENR-141371	ENR	Dylan Carlson	1946-10-01	UHC-36771-69	9885922765	6138 Baseline Rd, Nashville, TN, 37216	0.96	Member ID reformatted City re-cased
CLM-401247	CLM	Kevin A Gray	1944-07-03	UHC-41944-42	9134016009	—	0.96	Member ID reformatted Placeholder values cleared
ENR-129261	ENR	Cheryl Espinoza	2006-10-26	UHC-58785-36	6474917682	7082 Sage Ct, Los Angeles, CA, 90030	0.96	Name re-cased Member ID reformatted
ENR-142547	ENR	Lauren D Carlson	1975-06-01	UHC-17703-79	3048734417	8583 Cedar Ln, Tampa, FL, 33627	0.96	Date of birth reformatted Member ID reformatted
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
ENR-131333	ENR	Nicole F Vasquez	1964-02-26	UHC-77798-87	—	1098 Grand Ave, Tampa, FL, 33670	0.96	Member ID reformatted Placeholder values cleared
CLM-412304	CLM	Walter Cunningham	1943-01-05	UHC-39378-75	—	—	0.96	Member ID reformatted Placeholder values cleared
TPA-51781	TPA	Sean Allen	1993-09-14	UHC-37430-07	—	1226 Willow Ct, Los Angeles, CA, 90091	0.96	Member ID reformatted Email lower-cased

7,723 rows, page 153 of 155Previous Next