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
CLM-411707	CLM	Adnrea Guerrero	1953-09-12	—	4084500877	345 Hillcrest Rd Apt 22, Jacksonville, FL, 32217	0.78	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed+1 more
ENR-109337	ENR	Arthur R Ortiz	1968-05-06	UHC-41253-19	2183641233	4506 Valley View Dr Apt 1, Glendale, AZ, 85370	0.78	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+1 more
ENR-123651	ENR	Pual G Herrera	1994-07-28	UHC-71796-43	9452659708	248 Palm Dr Apt 7, Los Angeles, CA, 90072	0.78	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed+1 more
ENR-120450	ENR	Brandon A Richards	2002-07-18	UHC-38095-71	4727738498	9566 Union St # 628, Los Angeles, CA, 90049	0.78	Name re-cased Phone reformatted Unit split from street Email lower-cased+1 more
ENR-133316	ENR	Vldez Mary	1944-04-02	UHC-99876-88	2917274599	4738 Maple Ave Apt 10, Chandler, AZ, 85268	0.78	Name re-cased Phone reformatted Unit split from street City re-cased+1 more
ENR-136060	ENR	Lawrence W Hayes	1966-03-25	UHC-29287-75	7369976447	6554 Indian School Rd # 444, Atlanta, GA, 30349	0.78	Phone reformatted Unit split from street Email lower-cased Whitespace trimmed+1 more
ENR-136171	ENR	Santiago Moreno	1987-05-16	UHC-69964-04	8257591822	4391 Broadway Apt 40, Sacramento, CA, 95863	0.78	Phone reformatted Unit split from street Email lower-cased Whitespace trimmed+1 more
ENR-137105	ENR	Jessica Carroll	1942-06-12	UHC-09268-29	5033331504	9859 Sage Ct Apt 29, Jacksonville, FL, 32206	0.78	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+1 more
ENR-137106	ENR	Jessica Carroll	1942-06-12	UHC-09268-29	5033331504	9859 Sage Ct Apt 29, Jacksonville, FL, 32206	0.78	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+1 more
CLM-430166	CLM	Joseph Daniels	1941-05-21	—	2814425825	2421 Meadow Ln Apt 8, Sacramento, CA, 95890	0.78	Name re-cased Phone reformatted Unit split from street Whitespace trimmed+1 more
ENR-120220	ENR	Natalie X Hughes	1940-07-03	UHC-87123-66	6842252901	4686 Sage Ct # 702, Chandler, AZ, 85237	0.78	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+1 more
ENR-140786	ENR	Fox Z Alexander	1953-08-07	UHC-20029-98	7748467195	1534 Forest Ave Apt 28, Glendale, AZ, 85304	0.78	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+1 more
CLM-425995	CLM	Diego K Daniels	1994-11-01	—	7765732386	1463 Maple Ave # 609, Seattle, WA, 98121	0.78	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed+1 more
CLM-430546	CLM	Maria Ryan	1955-01-17	UHC-03334-11	—	7797 Cedar Ln # 742, Sacramento, CA, 95853	0.78	Name re-cased Date of birth reformatted Unit split from street City re-cased+1 more
TPA-61412	TPA	Alexis Mitchell	1973-02-06	—	4337115977	1919 Park Pl Apt 13, Jacksonville, FL, 32209	0.78	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+1 more
PRV-25400	PRV	Jean K Singh	1951-03-25	UHC-61363-09	4426005971	6624 Hillcrest Rd # 875, Phoenix, AZ, 85054	0.78	Name re-cased Unit split from street City re-cased Whitespace trimmed+1 more
ENR-125144	ENR	Christine Banks	1957-10-20	—	2462499743	1950 Valley View Dr Apt 16, Tempe, AZ, 85220	0.78	Name re-cased Phone reformatted Unit split from street Whitespace trimmed+1 more
ENR-104918	ENR	Mateo V Myers	1976-07-16	UHC-90347-43	6369344236	5802 Ridge Rd # 179, Glendale, AZ, 85308	0.78	Name re-cased Phone reformatted Unit split from street Whitespace trimmed+1 more
TPA-64384	TPA	Denise C Sullivan	1965-08-05	—	8377944492	7428 Lincoln Way Apt 36, Chandler, AZ, 85272	0.78	Name re-cased Phone reformatted Unit split from street Whitespace trimmed+1 more
ENR-131306	ENR	Aaron Hill	1954-01-22	UHC-43515-39	9204761283	6660 Willow Ct Apt 37, Nashville, TN, 37256	0.78	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+1 more
PRV-25982	PRV	Arthur I Espinoza	1991-10-23	—	5154727968	2783 Market St # 919, Gilbert, AZ, 85284	0.78	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed+1 more
ENR-109884	ENR	Christian G Yang	1963-01-02	UHC-46342-52	3044413721	518 Bayshore Dr Apt 8, Houston, TX, 77010	0.78	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+1 more
CLM-427994	CLM	Jose Williams	1949-06-05	—	8537316600	4096 Oak St Apt 21, Las Vegas, NV, 89125	0.78	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed+1 more
TPA-55450	TPA	Steven Mason	1965-11-06	—	—	6665 Pine Dr Apt 33, Miami, FL, 33184	0.78	Unit split from street City re-cased Plan code upper-cased Whitespace trimmed+1 more
ENR-122766	ENR	Christina Sanchez	2006-06-01	UHC-05882-67	4455399844	28 Sunset Blvd Apt 1, Houston, TX, 77052	0.78	Name re-cased Phone reformatted Unit split from street State code upper-cased+1 more
ENR-139654	ENR	Adam Sanders	1948-02-04	UHC-93095-79	7132416022	1697 Broadway Apt 11, Tempe, AZ, 85279	0.78	Name re-cased Date of birth reformatted Unit split from street Address re-cased+1 more
TPA-55474	TPA	Susan Clark	1983-12-06	—	—	9001 River Rd # 391, Houston, TX, 77035	0.78	Name re-cased Date of birth reformatted Unit split from street Whitespace trimmed+1 more
TPA-59105	TPA	Virginia Anderson	2004-06-06	—	7256440054	9727 Baseline Rd # 447, Tampa, FL, 33684	0.78	Date of birth reformatted Unit split from street Email lower-cased Whitespace trimmed+1 more
PRV-27028	PRV	Aissha Brooks	1951-06-13	—	2563247034	3747 Canyon Rd # 880, Jacksonville, FL, 32260	0.78	Phone reformatted Unit split from street State code upper-cased Whitespace trimmed+1 more
CLM-421349	CLM	Aisha P Morgan	1988-12-27	UHC-38996-14	8469496565	7101 Lincoln Way Apt 21, Tempe, AZ, 85215	0.78	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed+1 more
ENR-125293	ENR	Gloria Q Ross	1983-08-24	UHC-95778-74	—	4616 Forest Ave # 308, Minneapolis, MN, 55498	0.78	Name re-cased Date of birth reformatted Unit split from street Whitespace trimmed+1 more
CLM-420403	CLM	Carol Ortega	1996-01-15	—	—	5241 Central Ave # 820, Tampa, FL, 33612	0.78	Date of birth reformatted Unit split from street City re-cased State code upper-cased+1 more
ENR-104304	ENR	Thomas B Andrews	1973-06-27	UHC-99387-81	—	6067 Church St # 692, Phoenix, AZ, 85028	0.78	Name re-cased Date of birth reformatted Unit split from street Whitespace trimmed+1 more
ENR-101831	ENR	Heather H Le	1960-09-15	UHC-10593-35	6595486190	5299 Desert Sky Blvd # 844, Austin, TX, 78740	0.78	Name re-cased Phone reformatted Unit split from street Email lower-cased+1 more
ENR-115926	ENR	Rachel Rios	2003-09-09	UHC-86721-94	7695340062	8449 Park Pl Apt 6, Austin, TX, 78799	0.78	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+1 more
ENR-129593	ENR	Jerry V Howward	1964-11-01	UHC-23716-07	7605309171	7324 Meadow Ln # 345, Los Angeles, CA, 90066	0.78	Phone reformatted Unit split from street City re-cased State code upper-cased+1 more
CLM-432254	CLM	James Thompson	1980-11-03	UHC-35914-01	8407961407	6516 Park Pl # 660, Sacramento, CA, 95829	0.78	Unit split from street City re-cased Email lower-cased Whitespace trimmed+1 more
ENR-142642	ENR	Dylan Hansen	2006-12-04	UHC-66853-55	4332691893	4894 Union St Apt 37, Tempe, AZ, 85246	0.78	Date of birth reformatted Unit split from street State code upper-cased Email lower-cased+1 more
CLM-431896	CLM	Melissa Medina	1972-12-23	—	—	670 Sage Ct # 324, Glendale, AZ, 85359	0.78	Name re-cased Unit split from street Plan code upper-cased Whitespace trimmed+1 more
CLM-413537	CLM	Betty Bennett	1972-12-08	UHC-09862-50	2777843314	1451 Main St # 491, Tampa, FL, 33605	0.78	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed+1 more
CLM-410553	CLM	Vincent Day	1994-01-23	UHC-43106-96	5384793763	815 Highland Ave Apt 15, Eden Prairie, MN, 55386	0.78	Phone reformatted Unit split from street City re-cased Whitespace trimmed+1 more
CLM-428164	CLM	Dyllan King	1938-09-20	UHC-53344-87	—	2534 Market St Apt 24, Columbus, OH, 43275	0.78	Name re-cased Date of birth reformatted Unit split from street Whitespace trimmed+1 more
TPA-58388	TPA	Hiroshi Espinoza	1997-12-09	—	9258495433	2482 Mesa Dr # 998, Tempe, AZ, 85226	0.78	Date of birth reformatted Phone reformatted Unit split from street City re-cased+1 more
CLM-421477	CLM	Betty Cooper	2000-08-23	UHC-83087-08	8498672884	2201 Broadway # 600, Miami, FL, 33145	0.78	Phone reformatted Unit split from street Address re-cased Whitespace trimmed+1 more
CLM-425418	CLM	Samantha R Palmar	2008-02-16	UHC-09047-81	—	523 Lake View Rd Apt 16, Los Angeles, CA, 90049	0.78	Name re-cased Date of birth reformatted Unit split from street Email lower-cased+1 more
CLM-408724	CLM	Wei Walsh	1983-12-11	UHC-26657-53	—	4054 Willow Ct Apt 21, Chandler, AZ, 85210	0.78	Name re-cased Unit split from street City re-cased Whitespace trimmed+1 more
CLM-416485	CLM	Martha C Black	1995-03-02	—	—	2104 Lake View Rd # 376, Mesa, AZ, 85247	0.78	Name re-cased Date of birth reformatted Unit split from street Whitespace trimmed+1 more
ENR-115888	ENR	Emily Schultz	1940-12-09	UHC-08393-09	9132528725	8124 Park Pl # 190, Denver, CO, 80268	0.78	Phone reformatted Member ID reformatted Unit split from street Email lower-cased+1 more
ENR-106813	ENR	Emma W Smith	1968-07-13	UHC-75488-97	9276871215	7591 Highland Ave # 424, Orlando, FL, 32888	0.78	Name re-cased Phone reformatted Unit split from street Email lower-cased+1 more
CLM-406393	CLM	Margaret Marshall	1960-09-25	UHC-55401-63	7563809209	420 Forest Ave # 776, Minneapolis, MN, 55420	0.78	Date of birth reformatted Phone reformatted Unit split from street Whitespace trimmed+1 more

6,994 rows, page 119 of 140Previous Next