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
ENR-130625	ENR	Jacqueline V Ramirez	1995-07-09	UHC-42889-92	—	1601 Washington St, Tempe, AZ, 85247	0.92	Member ID reformatted City re-cased Whitespace trimmed Placeholder values cleared
ENR-112560	ENR	Beverly Bailey	1986-04-20	UHC-10812-76	4562964355	5723 Spring St, Gilbert, AZ, 85222	0.92	Date of birth reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-426832	CLM	Anthony L Nguyen	1975-01-21	UHC-17522-25	4299488608	9455 Jefferson Ave, Tucson, AZ, 85762	0.92	Phone reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
ENR-114082	ENR	Denise G Castro	1977-02-14	UHC-82855-46	2615750378	7730 Highland Ave, Denver, CO, 80294	0.92	Name re-cased Phone reformatted Member ID reformatted Whitespace trimmed
ENR-125426	ENR	Raymond J Hart	1979-12-20	UHC-33095-55	9427347814	2696 Baseline Rd, Tampa, FL, 33650	0.92	Name re-cased Phone reformatted Member ID reformatted Whitespace trimmed
ENR-107942	ENR	Hiroshi G Rogers	1942-10-18	UHC-61691-81	4925206998	—	0.92	Name re-cased Phone reformatted Member ID reformatted Placeholder values cleared
ENR-114930	ENR	Valentina Young	1949-12-11	UHC-34397-05	4905894663	3093 Hillcrest Rd, Tucson, AZ, 85746	0.92	Phone reformatted Member ID reformatted State code upper-cased Email lower-cased
ENR-136510	ENR	Joshua Maldonado	1983-06-18	UHC-40498-61	9868314055	2040 Forest Ave, Las Vegas, NV, 89169	0.92	Date of birth reformatted Phone reformatted Member ID reformatted Whitespace trimmed
ENR-110401	ENR	Stephen L Morrison	1955-04-04	UHC-13609-37	9488273150	8567 Spring St, San Diego, CA, 92111	0.92	Phone reformatted Member ID reformatted Email lower-cased Whitespace trimmed
CLM-408097	CLM	Ryna Richards	1980-05-09	UHC-91216-27	7378308796	—	0.92	Date of birth reformatted Phone reformatted Member ID reformatted Placeholder values cleared
CLM-419950	CLM	Evelyn L Le	1993-12-09	UHC-70727-05	—	1620 Central Ave, Glendale, AZ, 85349	0.92	Name re-cased Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-419246	CLM	Mariana Munoz	1971-04-24	UHC-53160-14	2672304254	8127 Desert Sky Blvd, Los Angeles, CA, 90086	0.92	Name re-cased Date of birth reformatted Member ID reformatted Placeholder values cleared
ENR-104497	ENR	Ana S Guerrero	1998-07-17	UHC-11911-99	—	3235 Park Pl, Seattle, WA, 98137	0.92	Name re-cased Member ID reformatted Email lower-cased Whitespace trimmed
PRV-24215	PRV	Samuel Hall	1969-07-09	UHC-98058-91	7723416986	2021 Spring St, Fresno, CA, 93792	0.92	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted
CLM-411105	CLM	Hannah Silva	1987-12-06	UHC-05848-56	—	—	0.92	Name re-cased Member ID reformatted Whitespace trimmed Placeholder values cleared
ENR-101954	ENR	Mei D Ramirez	1989-05-22	UHC-74961-83	8944753515	2737 Jefferson Ave, Miami, FL, 33160	0.92	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted
ENR-113819	ENR	Bradley Perkins	2003-08-26	UHC-98736-97	—	616 Lincoln Way, Sacramento, CA, 95898	0.92	Date of birth reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
ENR-107901	ENR	Heather X Ray	1948-11-20	UHC-06792-81	7579919575	8379 Central Ave, Sacramento, CA, 95828	0.92	Phone reformatted Member ID reformatted Email lower-cased Whitespace trimmed
ENR-101515	ENR	Dennis V Cooper	1995-04-18	UHC-06106-57	4008593520	9776 Park Pl, Orlando, FL, 32804	0.92	Phone reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
ENR-132093	ENR	Lawrence Z Fox	1961-10-21	UHC-64414-56	5589896044	179 Pine Dr, Miami, FL, 33179	0.92	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted
CLM-423930	CLM	Lori Yang	1974-08-09	UHC-40678-20	7174754465	—	0.92	Date of birth reformatted Phone reformatted Member ID reformatted Placeholder values cleared
ENR-100215	ENR	Jennifer H Cole	1962-10-12	UHC-45106-70	—	5396 Elm St, Charlotte, NC, 28231	0.92	Name re-cased Member ID reformatted Email lower-cased Placeholder values cleared
ENR-130139	ENR	Kyle K Smith	1983-12-24	UHC-64566-52	6344357057	1315 Park Pl, San Diego, CA, 92104	0.92	Phone reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
ENR-130186	ENR	Judy U Goordon	1970-11-01	UHC-42219-38	4996647707	6485 Market St, San Antonio, TX, 78232	0.92	Date of birth reformatted Phone reformatted Member ID reformatted Whitespace trimmed
CLM-403300	CLM	Daniel Santiago	1998-07-24	UHC-56034-99	—	—	0.92	Name re-cased Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-416876	CLM	Kevin Reid	1942-06-13	UHC-59417-37	—	—	0.92	Date of birth reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
ENR-102146	ENR	Mike Armstrong	1959-12-05	UHC-81160-47	7123054002	9055 Bayshore Dr, Austin, TX, 78730	0.92	Name re-cased Date of birth reformatted Member ID reformatted Email lower-cased
ENR-136946	ENR	Nancy Rose	1975-02-25	UHC-86077-24	9398093254	7834 Broadway, Austin, TX, 78776	0.92	Name re-cased Phone reformatted Member ID reformatted Email lower-cased
ENR-130392	ENR	Nicole Mitchell	1993-06-03	UHC-23875-61	4124848918	5297 Broadway, Scottsdale, AZ, 85288	0.92	Member ID reformatted Address re-cased City re-cased Email lower-cased
PRV-22614	PRV	James Park	2008-04-11	UHC-67554-44	8294995123	5255 Church St, Seattle, WA, 98113	0.92	Phone reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
ENR-139872	ENR	Karen N Mitchell	1949-09-02	UHC-80730-37	7896356262	5453 Spring St, Los Angeles, CA, 90075	0.92	Date of birth reformatted Phone reformatted Member ID reformatted City re-cased
PRV-21001	PRV	Thomas Fowler	1998-02-20	UHC-84561-07	3234559978	4295 Lincoln Way, Chandler, AZ, 85237	0.92	Phone reformatted Member ID reformatted City re-cased Whitespace trimmed
ENR-126445	ENR	Jason A Powell	1964-02-12	UHC-18174-80	4646937878	5736 Meadow Ln, Miami, FL, 33152	0.92	Name re-cased Member ID reformatted State code upper-cased Placeholder values cleared
CLM-430021	CLM	Mason Santaigo	1989-12-06	UHC-44962-59	—	—	0.92	Date of birth reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
ENR-104561	ENR	Tyler W Jackson	1948-07-16	UHC-45708-12	9297363562	7548 Baseline Rd, Atlanta, GA, 30326	0.92	Phone reformatted Member ID reformatted State code upper-cased Whitespace trimmed
ENR-133502	ENR	Elijah Wilson	1945-03-07	UHC-92642-82	3272767470	8213 River Rd, Denver, CO, 80231	0.92	Date of birth reformatted Phone reformatted Member ID reformatted Placeholder values cleared
ENR-113748	ENR	Nicole L Munoz	2006-06-19	UHC-35202-88	4447610655	9023 Church St, Nashville, TN, 37248	0.92	Name re-cased Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-428005	CLM	Wiillie Hughes	2007-11-19	UHC-36867-98	2805821410	7719 Broadway, Chandler, AZ, 85201	0.92	Name re-cased Phone reformatted Member ID reformatted Whitespace trimmed
ENR-123115	ENR	Russell Moreno	2005-07-27	UHC-08496-11	8428694390	8906 Broadway, Plano, TX, 75023	0.92	Member ID reformatted Address re-cased Whitespace trimmed Placeholder values cleared
CLM-400023	CLM	Donald R Cole	2002-06-28	UHC-90325-35	—	—	0.92	Date of birth reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-406909	CLM	Emily Greeen	1972-11-07	UHC-54979-01	—	4133 Willow Ct, Chandler, AZ, 85286	0.92	Date of birth reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-406910	CLM	Emily Greeen	1972-11-07	UHC-54979-01	—	4133 Willow Ct, Chandler, AZ, 85286	0.92	Date of birth reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-415794	CLM	Ryan Gordon	2000-09-19	UHC-72790-66	5988345854	—	0.92	Phone reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-402293	CLM	Timothy Bryant	1965-02-15	UHC-19534-28	—	4738 Park Pl, Phoenix, AZ, 85034	0.92	Name re-cased Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-431328	CLM	Mihcelle Lynch	1967-09-11	UHC-07856-55	6046847334	3435 Meadow Ln, Plano, TX, 75021	0.92	Name re-cased Phone reformatted Member ID reformatted Placeholder values cleared
ENR-123925	ENR	Keith Smith	1977-06-17	UHC-21002-67	8836321756	9690 Pine Dr, Jacksonville, FL, 32293	0.92	Phone reformatted Member ID reformatted Plan code upper-cased Whitespace trimmed
ENR-100836	ENR	Harold E Martin	1989-10-04	UHC-22020-09	8902671945	1613 Highland Ave, Seattle, WA, 98125	0.92	Phone reformatted Member ID reformatted State code upper-cased Email lower-cased
CLM-417099	CLM	Mei Wilson	1978-03-11	UHC-28950-12	8524687102	3147 Lincoln Way, Charlotte, NC, 28240	0.92	Date of birth reformatted Phone reformatted Member ID reformatted Placeholder values cleared
ENR-112796	ENR	Cheryl Mason	1962-07-13	UHC-55711-40	—	4400 Camelback Rd, Columbus, OH, 43212	0.92	Member ID reformatted Email lower-cased Whitespace trimmed Placeholder values cleared
CLM-426942	CLM	James Gardner	1993-12-01	UHC-18662-01	5738737689	4528 Desert Sky Blvd, Nashville, TN, 37280	0.92	Date of birth reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared

7,723 rows, page 135 of 155Previous Next