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 “Unit split from street”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagUnit split from streetClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-124654	ENR	Rendy Z Fisher	1984-01-26	UHC-09845-24	—	772 Harbor Blvd # 945, Atlanta, GA, 30393	0.80	Date of birth reformatted Unit split from street Whitespace trimmed Placeholder values cleared
ENR-132530	ENR	Gerald Carroll	1969-08-11	UHC-87192-04	2765170952	7456 Ridge Rd # 312, Sacramento, CA, 95891	0.80	Name re-cased Phone reformatted Unit split from street City re-cased
CLM-418742	CLM	Ronald Long	1972-07-10	—	—	3301 Oak St Apt 33, Charlotte, NC, 28270	0.80	Name re-cased Unit split from street City re-cased Placeholder values cleared
ENR-133740	ENR	Lucia V Weaver	2000-08-24	UHC-36651-05	7242569505	4920 Lake View Rd Apt 18, Columbus, OH, 43296	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
CLM-402259	CLM	Andrea Gonzales	1995-10-14	—	7945796537	6530 Lake View Rd Apt 32, San Diego, CA, 92149	0.80	Phone reformatted Unit split from street Email lower-cased Placeholder values cleared
ENR-142803	ENR	Christina F Williams	1996-12-21	UHC-25299-76	4427525175	9383 Ocean Ave Apt 17, Tucson, AZ, 85705	0.80	Name re-cased Date of birth reformatted Unit split from street Email lower-cased
CLM-418344	CLM	Carol Kelly	1939-10-17	—	—	1796 Maple Ave # 529, Seattle, WA, 98114	0.80	Unit split from street State code upper-cased Whitespace trimmed Placeholder values cleared
CLM-410289	CLM	Aisha Butler	1971-04-13	—	—	181 Maple Ave # 771, Denver, CO, 80237	0.80	Name re-cased Date of birth reformatted Unit split from street Placeholder values cleared
CLM-413893	CLM	Anna Ellis	1967-11-23	UHC-86115-09	8544600979	4372 Lake View Rd # 123, Sacramento, CA, 95841	0.80	Name re-cased Phone reformatted Unit split from street Placeholder values cleared
ENR-108942	ENR	Deborah Goemz	1947-08-07	UHC-89041-13	7958628445	7243 Lincoln Way # 186, Las Vegas, NV, 89129	0.80	Date of birth reformatted Phone reformatted Unit split from street Placeholder values cleared
PRV-29194	PRV	Walter Munoz	2002-05-12	—	5025352140	6152 Sage Ct Apt 24, Seattle, WA, 98156	0.80	Name re-cased Phone reformatted Unit split from street Placeholder values cleared
ENR-106704	ENR	Marilyn W Romero	1954-08-02	UHC-22595-40	5559000569	2973 Main St # 159, Eden Prairie, MN, 55338	0.80	Phone reformatted Unit split from street Email lower-cased Whitespace trimmed
PRV-23022	PRV	Heather Q Crawford	1966-01-27	—	—	5137 Ridge Rd Apt 5, Chandler, AZ, 85286	0.80	Name re-cased Unit split from street Whitespace trimmed Placeholder values cleared
CLM-416541	CLM	Virgiia Watkins	1948-06-01	—	9754714819	1208 Forest Ave Apt 37, Scottsdale, AZ, 85294	0.80	Name re-cased Unit split from street Whitespace trimmed Placeholder values cleared
TPA-54633	TPA	Margaret Spencer	1955-02-23	—	—	4242 Baseline Rd # 886, Plano, TX, 75047	0.80	Date of birth reformatted Unit split from street Email lower-cased Placeholder values cleared
TPA-55187	TPA	Barbara Yang	2003-08-06	UHC-42370-87	8353525565	2610 Palm Dr # 461, Sacramento, CA, 95809	0.80	Name re-cased Phone reformatted Unit split from street Placeholder values cleared
CLM-425201	CLM	Jean Gonzales	1941-09-26	—	3584757496	6416 Canyon Rd Apt 9, San Antonio, TX, 78277	0.80	Name re-cased Phone reformatted Unit split from street Placeholder values cleared
ENR-141749	ENR	Abigail W Nikhols	1965-08-26	UHC-64302-30	2518440057	1380 Forest Ave Apt 19, Orlando, FL, 32896	0.80	Date of birth reformatted Unit split from street Email lower-cased Whitespace trimmed
CLM-400541	CLM	Santiago Bennett	1988-09-19	UHC-00928-23	—	5393 Palm Dr # 357, San Diego, CA, 92142	0.80	Date of birth reformatted Unit split from street Whitespace trimmed Placeholder values cleared
ENR-137378	ENR	Lori F Stewart	1945-01-20	UHC-49995-63	8175708003	5044 Broadway # 614, Atlanta, GA, 30309	0.80	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed
ENR-105136	ENR	Yuki X Fox	1944-10-15	UHC-24074-48	9358892383	3744 Park Pl # 656, Denver, CO, 80247	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
ENR-128342	ENR	Brenda Smith	1940-04-14	UHC-93863-72	4149561765	4140 Ocean Ave Apt 6, San Diego, CA, 92153	0.80	Name re-cased Unit split from street City re-cased Whitespace trimmed
CLM-405028	CLM	George Jensen	1941-11-06	UHC-11856-62	5812019278	5394 Forest Ave Apt 11, Plano, TX, 75074	0.80	Date of birth reformatted Phone reformatted Unit split from street Placeholder values cleared
PRV-27959	PRV	Jordan Padilla	2000-03-12	—	3954694704	1639 Baseline Rd Apt 29, Phoenix, AZ, 85032	0.80	Phone reformatted Unit split from street Email lower-cased Whitespace trimmed
ENR-128212	ENR	Logan Moreno	1945-09-17	UHC-03115-61	5305361980	4844 Valley View Dr Apt 21, Atlanta, GA, 30398	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
TPA-62557	TPA	Nicholas Santos	1973-05-25	—	—	6211 Main St Apt 5, Mesa, AZ, 85237	0.80	Name re-cased Unit split from street Whitespace trimmed Placeholder values cleared
ENR-117047	ENR	Ruth Vazquez	2006-09-08	UHC-11615-56	2439617794	3458 Oak St Apt 38, San Antonio, TX, 78282	0.80	Phone reformatted Member ID reformatted Unit split from street Placeholder values cleared
CLM-431919	CLM	Ann Perez	1993-08-11	UHC-58834-40	—	2559 Baseline Rd # 496, Phoenix, AZ, 85046	0.80	Date of birth reformatted Unit split from street City re-cased Placeholder values cleared
CLM-416376	CLM	Timothy Y Aguilar	1996-11-08	—	5002713314	1629 River Rd Apt 10, Las Vegas, NV, 89123	0.80	Date of birth reformatted Phone reformatted Unit split from street Placeholder values cleared
ENR-107519	ENR	Mary Schmidt	1977-05-21	UHC-12590-72	3866601828	6452 Harbor Blvd # 878, Miami, FL, 33132	0.80	Name re-cased Date of birth reformatted Unit split from street Whitespace trimmed
CLM-424401	CLM	Gregory W Kelley	1970-06-12	UHC-38186-66	8648333370	4795 Maple Ave Apt 35, Houston, TX, 77030	0.80	Phone reformatted Unit split from street Whitespace trimmed Placeholder values cleared
TPA-63516	TPA	Tricia Dunn	1939-09-19	—	4929915295	9685 Camelback Rd Apt 30, Miami, FL, 33169	0.80	Name re-cased Unit split from street Whitespace trimmed Placeholder values cleared
TPA-51452	TPA	Ana Santos	1940-10-17	UHC-93279-73	—	7064 Indian School Rd # 292, Tucson, AZ, 85779	0.80	Name re-cased Unit split from street Whitespace trimmed Placeholder values cleared
CLM-407986	CLM	Jacqueline Rice	1972-10-10	UHC-38010-76	6709639202	4571 Lake View Rd # 826, Las Vegas, NV, 89128	0.80	Name re-cased Phone reformatted Unit split from street Placeholder values cleared
ENR-128495	ENR	Aisha C Reyes	1984-07-28	UHC-90663-56	2303783321	6076 Pine Dr Apt 9, Eden Prairie, MN, 55358	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
ENR-113868	ENR	Jessica Mattthews	1962-01-06	UHC-00779-91	7459959603	479 Willow Ct # 835, Scottsdale, AZ, 85210	0.80	Name re-cased Phone reformatted Unit split from street Whitespace trimmed
TPA-51833	TPA	Daniel Matthews	1943-11-06	—	—	6458 Washington St Apt 22, Miami, FL, 33190	0.80	Unit split from street State code upper-cased Whitespace trimmed Placeholder values cleared
ENR-138467	ENR	Betty Wright	1996-05-07	UHC-97501-96	6076640120	6345 Desert Sky Blvd # 933, Miami, FL, 33102	0.80	Name re-cased Unit split from street State code upper-cased Placeholder values cleared
TPA-57078	TPA	Kayla Riley	2004-02-12	—	5012211052	2261 River Rd # 713, Dallas, TX, 75285	0.80	Phone reformatted Unit split from street Whitespace trimmed Placeholder values cleared
ENR-110305	ENR	Emily Simpson	2006-08-20	UHC-45607-98	8723790283	7381 Canyon Rd Apt 19, Jacksonville, FL, 32293	0.80	Date of birth reformatted Unit split from street City re-cased Whitespace trimmed
CLM-416656	CLM	Judith G Simpson	1986-04-27	—	9284809622	2933 Pine Dr Apt 20, Tempe, AZ, 85207	0.80	Phone reformatted Unit split from street Email lower-cased Placeholder values cleared
PRV-21940	PRV	Sean Bradley	1941-10-28	—	4213129259	8159 Ridge Rd # 853, San Diego, CA, 92168	0.80	Date of birth reformatted Phone reformatted Unit split from street Placeholder values cleared
CLM-412799	CLM	Aguilar Amanda	1999-07-14	UHC-57660-55	6564890302	4164 Broadway # 934, Tampa, FL, 33658	0.80	Name re-cased Date of birth reformatted Phone reformatted Unit split from street
ENR-119574	ENR	Dennis H Murphy	1962-08-12	UHC-72122-15	3272899178	1093 Baseline Rd # 643, Plano, TX, 75094	0.80	Name re-cased Date of birth reformatted Unit split from street Placeholder values cleared
ENR-127806	ENR	Billy Gilbert	1980-06-11	UHC-53996-82	9006612715	7244 Lincoln Way # 763, Tampa, FL, 33683	0.80	Name re-cased Date of birth reformatted Phone reformatted Unit split from street
PRV-26802	PRV	David A Singh	1940-09-12	UHC-97681-49	7966927775	6257 Canyon Rd # 356, Houston, TX, 77051	0.80	Name re-cased Unit split from street Whitespace trimmed Placeholder values cleared
ENR-139512	ENR	Megan F Hawkins	1951-05-16	—	8192644561	667 River Rd # 894, Sacramento, CA, 95812	0.80	Unit split from street City re-cased Email lower-cased Placeholder values cleared
ENR-139513	ENR	Megan F Hawkins	1951-05-16	—	8192644561	667 River Rd # 894, Sacramento, CA, 95812	0.80	Unit split from street City re-cased Email lower-cased Placeholder values cleared
ENR-123441	ENR	Sarah George	1951-04-09	UHC-16226-95	2195482501	1849 Harbor Blvd Apt 23, Phoenix, AZ, 85024	0.80	Phone reformatted Unit split from street Email lower-cased Whitespace trimmed
TPA-53612	TPA	Jacqueline Moore	1995-03-14	—	—	9435 Broadway # 231, Houston, TX, 77087	0.80	Name re-cased Unit split from street State code upper-cased Placeholder values cleared

6,994 rows, page 131 of 140Previous Next