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-132281	ENR	Lauren Stone	1960-12-08	UHC-98414-49	7566275581	7831 Lincoln Way Apt 37, Mesa, AZ, 85283	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-117999	ENR	Nathan L Smith	1967-01-13	—	6572394061	7425 Ridge Rd Apt 30, Mesa, AZ, 85215	0.76	Date of birth reformatted Phone reformatted Unit split from street City re-cased+2 more
ENR-109105	ENR	Austin Walsh	2006-10-21	UHC-77688-70	6914855247	8506 Bayshore Dr Apt 16, Charlotte, NC, 28227	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-108268	ENR	Judy Q Alexander	1990-09-12	UHC-75403-09	6615096490	6007 Grand Ave Apt 2, Dallas, TX, 75261	0.76	Member ID reformatted Unit split from street State code upper-cased Email lower-cased+2 more
ENR-117443	ENR	Kim M Margaret	1992-02-11	UHC-98896-19	5956287335	4922 Lake View Rd Apt 4, Mesa, AZ, 85241	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
PRV-20536	PRV	Walter Peters	1966-02-13	UHC-02548-52	6118204274	5060 Highland Ave Apt 22, Minneapolis, MN, 55434	0.76	Date of birth reformatted Phone reformatted Unit split from street Plan code upper-cased+2 more
CLM-424424	CLM	Jacob N Gunzales	2003-01-01	UHC-27782-30	3134028045	3611 Jefferson Ave # 163, Dallas, TX, 75220	0.76	Name re-cased Phone reformatted Unit split from street City re-cased+2 more
TPA-50588	TPA	Zachary Rdoriguez	1941-10-09	UHC-03456-11	5736490451	7339 Jefferson Ave # 523, Los Angeles, CA, 90091	0.76	Date of birth reformatted Phone reformatted Unit split from street City re-cased+2 more
TPA-60463	TPA	Patrick Ferguson	1970-05-01	—	—	3806 Valley View Dr # 577, Orlando, FL, 32810	0.76	Name re-cased Date of birth reformatted Unit split from street City re-cased+2 more
ENR-100417	ENR	Thomas Holmes	1959-01-24	UHC-61592-18	4305092185	9118 Elm St # 591, Nashville, TN, 37233	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
TPA-64184	TPA	Melissa Fox	1979-10-28	—	3326363708	7882 Baseline Rd Apt 33, Atlanta, GA, 30393	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-129706	ENR	Frank Y Patel	1973-03-24	UHC-81497-86	2786052891	2646 Sunset Blvd # 194, San Diego, CA, 92126	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
CLM-415526	CLM	Philip Garrett	1960-12-03	UHC-23280-93	8445091395	5689 Cedar Ln Apt 18, Tucson, AZ, 85792	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
CLM-413194	CLM	Jacqueline Watson	2005-05-22	UHC-06280-11	—	1973 Cedar Ln # 584, Tucson, AZ, 85733	0.76	Name re-cased Date of birth reformatted Unit split from street City re-cased+2 more
ENR-137743	ENR	Mark Harper	1948-01-14	UHC-36602-12	8607653113	2277 Lincoln Way Apt 20, Seattle, WA, 98189	0.76	Name re-cased Phone reformatted Unit split from street Email lower-cased+2 more
ENR-101856	ENR	Debra Lawson	2001-04-13	UHC-41075-73	2994987521	3889 Park Pl Apt 8, Atlanta, GA, 30308	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Unit split from street+2 more
CLM-423131	CLM	Charles Nelson	1939-03-01	UHC-63194-22	9185057537	1880 Pine Dr Apt 4, Eden Prairie, MN, 55394	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-111457	ENR	Shirley D Hunt	1958-09-01	UHC-53979-10	5092460501	1390 Indian School Rd # 987, Fresno, CA, 93789	0.76	Date of birth reformatted Phone reformatted Unit split from street Email lower-cased+2 more
CLM-427687	CLM	Lisa Ryan	1966-02-22	UHC-00454-84	8385383270	7544 Jefferson Ave Apt 10, Tempe, AZ, 85279	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Unit split from street+2 more
ENR-116525	ENR	Jordan N Burton	1994-05-09	UHC-01579-36	2104226562	9072 Forest Ave Apt 8, Las Vegas, NV, 89101	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
CLM-407402	CLM	Pamela Matthews	1990-07-12	UHC-37090-99	3643573993	7195 Sage Ct # 397, Houston, TX, 77026	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
PRV-23678	PRV	Eugene Richardson	1956-02-08	UHC-44774-84	6603350643	2383 Camelback Rd Apt 1, Tucson, AZ, 85770	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-138897	ENR	Austiin O Gordon	1964-09-27	UHC-50210-62	3875910563	9313 Highland Ave # 115, Jacksonville, FL, 32240	0.76	Name re-cased Phone reformatted Unit split from street City re-cased+2 more
ENR-124084	ENR	Becky R Yuung	1958-07-26	UHC-29880-99	6486063900	2166 Camelback Rd Apt 22, Austin, TX, 78701	0.76	Date of birth reformatted Phone reformatted Unit split from street City re-cased+2 more
ENR-122893	ENR	Jeremy X Austin	1956-05-06	UHC-43876-06	5155425207	9368 River Rd # 918, Minneapolis, MN, 55418	0.76	Date of birth reformatted Phone reformatted Unit split from street State code upper-cased+2 more
ENR-113974	ENR	Kathryn Porter	1976-03-17	UHC-28907-23	6793382184	1943 Broadway # 930, Tucson, AZ, 85774	0.76	Date of birth reformatted Phone reformatted Unit split from street Email lower-cased+2 more
TPA-62652	TPA	Diana Mills	1972-11-19	—	8517641826	7835 Broadway Apt 25, Atlanta, GA, 30342	0.76	Date of birth reformatted Phone reformatted Unit split from street City re-cased+2 more
ENR-125418	ENR	Kelly Y Espinoza	1988-05-10	UHC-51195-87	8586021424	9183 Central Ave Apt 3, Jacksonville, FL, 32286	0.76	Name re-cased Phone reformatted Unit split from street City re-cased+2 more
PRV-24948	PRV	Luis Delgado	1999-05-08	—	5032223372	6453 Grand Ave Apt 30, Las Vegas, NV, 89193	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-108503	ENR	Laura Ryan	1993-01-22	UHC-44301-74	3507482025	9430 Sunset Blvd Apt 13, Charlotte, NC, 28259	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-128968	ENR	Nicole Q Weaver	1999-01-17	UHC-34479-78	3859994986	4012 Broadway Apt 7, San Antonio, TX, 78252	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
CLM-410746	CLM	Joan Vega	1975-02-05	UHC-39122-29	7459971291	2744 Market St Apt 17, Glendale, AZ, 85331	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
TPA-63710	TPA	Deniel Mejia	1965-07-17	UHC-18153-42	8766420344	7763 Ocean Ave # 518, Columbus, OH, 43222	0.76	Name re-cased Phone reformatted Member ID reformatted Unit split from street+2 more
PRV-24279	PRV	Santiago M Woods	1999-07-20	—	6578935566	8090 Lake View Rd # 730, Chandler, AZ, 85278	0.76	Date of birth reformatted Phone reformatted Unit split from street City re-cased+2 more
CLM-417098	CLM	Mei Wilson	1978-03-11	UHC-28950-12	8524687102	3147 Lincoln Way Apt 12, Charlotte, NC, 28240	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-134480	ENR	Jacob G King	1993-03-27	UHC-51250-43	2788117964	8330 Indian School Rd Apt 11, Jacksonville, FL, 32272	0.76	Date of birth reformatted Phone reformatted Unit split from street City re-cased+2 more
ENR-124259	ENR	Evelyn Rodriguaz	1963-06-17	UHC-44393-75	9769376282	2236 Camelback Rd Apt 4, Denver, CO, 80231	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-125633	ENR	Robert Myerrs	1983-02-02	UHC-48943-31	2696268781	4724 Broadway # 449, San Diego, CA, 92161	0.76	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
CLM-408044	CLM	Raymond Wang	1998-06-20	UHC-11893-72	9377401464	3527 Union St Apt 19, Plano, TX, 75061	0.76	Date of birth reformatted Phone reformatted Unit split from street State code upper-cased+2 more
ENR-141893	ENR	Christina T Ruiz	2005-02-21	UHC-49090-52	3672244425	9270 Park Pl # 467, Charlotte, NC, 28271	0.76	Name re-cased Phone reformatted Unit split from street City re-cased+2 more
ENR-100937	ENR	Abby H Simmons	1953-06-10	UHC-39038-39	8013629545	749 Canyon Rd # 918, Jacksonville, FL, 32209	0.76	Name re-cased Date of birth reformatted Member ID reformatted Unit split from street+2 more
TPA-60334	TPA	Ralph Bailey	1968-01-10	—	—	9827 Elm St # 317, Houston, TX, 77097	0.76	Name re-cased Date of birth reformatted Unit split from street Email lower-cased+2 more
CLM-407244	CLM	Debbie Jackson	1951-07-21	—	6517170507	8786 Jefferson Ave # 194, Las Vegas, NV, 89108	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-128128	ENR	Betty Cooper	2000-08-23	UHC-83087-08	8498672884	2201 Broadway Apt 29, Miami, FL, 33145	0.76	Name re-cased Phone reformatted Unit split from street Address re-cased+2 more
PRV-26650	PRV	Pamela Tran	1947-06-05	—	7449348201	4889 Spring St # 189, Sacramento, CA, 95828	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
PRV-22164	PRV	Peter Elliott	1976-10-08	—	4098608284	6020 River Rd Apt 8, Charlotte, NC, 28247	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-140836	ENR	Theresa H Yang	1991-04-03	UHC-56920-82	3749490510	6217 Bayshore Dr # 271, Plano, TX, 75085	0.76	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
ENR-136241	ENR	Helen A Wells	1941-07-08	UHC-78515-93	9417059857	4905 Union St Apt 4, Denver, CO, 80242	0.76	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+2 more
ENR-102789	ENR	Charles Hanson	1953-01-15	UHC-69559-08	8133306069	9658 Camelback Rd # 369, San Diego, CA, 92183	0.76	Name re-cased Phone reformatted Unit split from street City re-cased+2 more
ENR-122571	ENR	Lucia S White	1991-07-18	—	8294112742	4563 Lincoln Way # 449, Sacramento, CA, 95853	0.76	Date of birth reformatted Phone reformatted Unit split from street State code upper-cased+2 more

6,994 rows, page 117 of 140Previous Next