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

Enrollment, flag “Date of birth reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagDate of birth reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-140589	ENR	Elizabeth C Gomez	1971-01-28	UHC-07240-65	2184320491	3059 Sunset Blvd Apt 10, Nashville, TN, 37297	0.68	Name split from “Last, First”Date of birth reformatted Unit split from street Whitespace trimmed
ENR-128225	ENR	James P Stewart	2004-09-23	UHC-71459-23	3744402053	1520 Lincoln Way, Scottsdale, AZ, 85268	0.68	Date of birth reformatted State name converted to code Gender normalised Whitespace trimmed
ENR-109853	ENR	Ethan Le	1952-01-02	UHC-08015-26	2903571411	6633 Pine Dr, Houston, TX, 77068	0.68	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased
ENR-108279	ENR	Philyp S Martin	1967-11-27	UHC-03773-94	—	2138 Sage Ct, Eden Prairie, MN, 55343	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-112787	ENR	Betty M Scott	1944-11-23	UHC-27281-70	7135934391	9323 Lake View Rd, Dallas, TX, 75299	0.68	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased
ENR-120846	ENR	Heather Hanson	1952-03-09	UHC-65991-97	5955203259	5705 Harbor Blvd, Denver, CO, 80218	0.68	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased
ENR-117749	ENR	Parker Brian	1983-03-04	UHC-69055-38	4525864470	5116 Ocean Ave, Minneapolis, MN, 55460	0.68	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code
ENR-104966	ENR	Stephaine G Carlson	1977-04-16	UHC-71608-01	4889817882	9790 Cedar Ln, Gilbert, AZ, 85205	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted SSN last four extracted
ENR-117862	ENR	Justin H Franklin	1985-09-14	UHC-39521-81	8747210120	1730 Sage Ct, Atlanta, GA	0.68	Name re-cased Date of birth reformatted ZIP missing Gender normalised
ENR-140519	ENR	Michael A Padilla	1982-03-20	UHC-55203-13	9507622111	8386 Pine Dr, Miami, FL, 33136	0.68	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased
ENR-107591	ENR	Carl C Silva	1973-05-06	UHC-81611-01	—	7969 Lincoln Way, Denver, CO, 80293	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Whitespace trimmed
ENR-116849	ENR	Priya Marquez	1979-07-08	UHC-15525-70	4506653889	5769 Church St, Scottsdale, AZ, 85250	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-124199	ENR	Michelle O Hill	1945-11-05	UHC-12950-32	2195916327	7958 Park Pl, Sacramento, CA, 95860	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted State name converted to code
ENR-141351	ENR	Keith T Black	1995-06-07	UHC-03770-61	—	6161 Church St, Miami, FL	0.68	Date of birth reformatted State name converted to code ZIP missing Whitespace trimmed
ENR-132957	ENR	Andrea Q Hudson	1960-02-22	UHC-74064-92	—	2166 Lake View Rd, Los Angeles, CA, 90067	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-138131	ENR	Thomas I Snyder	1999-07-18	UHC-50742-28	—	2100 Baseline Rd, Las Vegas, NV, 89116	0.68	Date of birth reformatted State name converted to code ZIP+4 trimmed Placeholder values cleared
ENR-117555	ENR	Luis O Peters	2000-12-01	UHC-99143-52	—	4568 Cedar Ln, Austin, TX, 78737	0.68	Date of birth reformatted Phone missing area code Email lower-cased Gender normalised
ENR-119502	ENR	Ronald X Reid	1978-09-11	UHC-15374-37	8807949813	3966 Mountain View Dr, Austin, TX, 78799	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised
ENR-126991	ENR	Mariana Z Cooper	1991-01-18	UHC-00105-56	4358986576	3910 Willow Ct, Seattle, WA, 98127	0.68	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased
ENR-116105	ENR	Ahmed Matthews	1947-05-11	UHC-67757-69	—	2473 Oak St, Tampa, FL, 33649	0.68	Name split from “Last, First”Date of birth reformatted ZIP+4 trimmed Whitespace trimmed
ENR-106565	ENR	Diego O Turner	1949-06-20	UHC-55844-12	5127468412	6968 Harbor Blvd, Dallas, TX, 75279	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised
ENR-103650	ENR	Lawrence J Morgan	1970-05-27	UHC-08471-65	5498685276	3458 Forest Ave, Tempe, AZ, 85258	0.68	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased
ENR-140019	ENR	Lucia P Welch	1987-03-03	UHC-60974-69	—	7565 Maple Ave, Plano, TX, 75030	0.68	Date of birth reformatted Phone missing area code Street suffix standardised Address re-cased
ENR-130566	ENR	Jacob A Cruz	1964-06-27	UHC-34873-65	—	9286 Desert Sky Blvd, Denver, CO, 80267	0.68	Date of birth reformatted Phone missing area code Street suffix standardised Address re-cased
ENR-126524	ENR	Roy X Marquez	2003-02-27	UHC-81106-25	7443027218	5519 Meadow Ln, Orlando, FL, 32852	0.68	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased
ENR-104790	ENR	Amber X Tucker	1973-08-10	UHC-54636-28	7297232396	5701 Lake View Rd, Minneapolis, MN, 55470	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-100924	ENR	Gerald N Foster	1939-04-09	UHC-60650-85	9776198827	3721 Indian School Rd, Atlanta, GA, 30352	0.68	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased
ENR-113233	ENR	Bruce Campbell	1972-08-02	UHC-19587-40	2915001758	—	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Whitespace trimmed
ENR-141178	ENR	Dylan P Morrison	1948-06-26	UHC-76007-54	6839591610	368 Apache Blvd, Columbus, OH, 43231	0.68	Date of birth reformatted State name converted to code Gender normalised Whitespace trimmed
ENR-137583	ENR	Dennis Y Reed	1992-08-11	UHC-52472-31	4118886498	2870 Ridge Rd, Tucson, AZ, 85742	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-142086	ENR	Thomas N Meeyr	2001-10-01	UHC-55702-01	7506869766	1824 Canyon Rd, Gilbert, AZ, 85206	0.68	Date of birth reformatted State name converted to code ZIP+4 trimmed Placeholder values cleared
ENR-142085	ENR	Thomas N Meeyr	2001-10-01	UHC-55702-01	7506869766	1824 Canyon Rd, Gilbert, AZ, 85206	0.68	Date of birth reformatted State name converted to code ZIP+4 trimmed Placeholder values cleared
ENR-107788	ENR	Beverly S Burns	1959-10-10	UHC-82374-33	—	2251 Lincoln Way, Tempe, AZ, 85276	0.68	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased
ENR-106171	ENR	Karen Perez	2004-08-20	UHC-19309-60	7508465667	7831 Park Pl, Las Vegas, NV, 89130	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised
ENR-125518	ENR	Kathryn Q Riley	1973-02-12	UHC-37171-83	3385952273	9716 Market St # 960, Las Vegas, NV, 89143	0.68	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased
ENR-109975	ENR	Brian S Patterrson	1992-09-23	UHC-33502-60	8368938815	6786 Pine Dr, Scottsdale, AZ, 85266	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-124587	ENR	Aisha A Snyder	1967-03-11	UHC-55261-40	8303202486	7756 Hillcrest Rd, Atlanta, GA, 30333	0.68	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code
ENR-107082	ENR	Andrew C Burke	1989-01-28	—	—	7038 Bayshore Dr, Austin, TX, 78708	0.68	Date of birth reformatted Phone missing area code Street suffix standardised Address re-cased
ENR-129337	ENR	Diane C Evans	1960-08-13	UHC-63208-52	3978918720	3144 Church St Apt 16, Austin, TX, 78731	0.68	Date of birth reformatted Phone reformatted SSN last four extracted Unit split from street
ENR-119776	ENR	Thomas Perez	1975-05-23	UHC-80680-30	—	2001 Park Pl # 105, Glendale, AZ, 85314	0.68	Name re-cased Date of birth reformatted Phone missing area code Unit split from street
ENR-105846	ENR	Roger Tucker	2005-07-26	UHC-54789-43	7398496372	7631 Maple Ave, Plano, TX, 75075	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted State name converted to code
ENR-107509	ENR	Sandra Z Baker	1972-10-10	UHC-47885-43	—	8323 Sage Ct # 293, Sacramento, CA, 95804	0.68	Date of birth reformatted Phone missing area code Member ID reformatted Unit split from street
ENR-105829	ENR	Lisa Campbell	1965-10-22	UHC-87281-93	—	1629 Pine Dr, Denver, CO, 80275	0.68	Date of birth reformatted Phone missing area code Street suffix standardised Address re-cased
ENR-115543	ENR	Arjun Jackson	1988-01-06	UHC-19640-97	8265469652	5869 Market St, Plano, TX, 75061	0.68	Date of birth reformatted Phone reformatted ZIP+4 trimmed Gender normalised
ENR-139355	ENR	Mason Santiago	1989-12-06	UHC-44962-59	6545214348	3907 Sage Ct # 608, Denver, CO, 80231	0.68	Date of birth reformatted Phone reformatted Unit split from street Gender normalised
ENR-122879	ENR	Elijah L Burke	1994-03-26	UHC-30110-62	—	6133 Washington St, Gilbert, AZ, 85221	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-102997	ENR	Arjun S Howard	1965-06-21	UHC-44648-22	—	4229 Ridge Rd, Glendale, AZ, 85369	0.68	Name re-cased Date of birth reformatted Phone missing area code ZIP+4 trimmed
ENR-122756	ENR	Samantha Jacobs	1952-10-26	UHC-57057-69	4304091805	1353 Meadow Ln, Mesa, AZ, 85238	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised
ENR-122755	ENR	Samantha Jacobs	1952-10-26	UHC-57057-69	4304091805	1353 Meadow Ln, Mesa, AZ, 85238	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised
ENR-122225	ENR	Brandon K Cooper	1978-08-20	UHC-88471-15	—	5881 Camelback Rd, Tempe, AZ, 85239	0.68	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased

13,989 rows, page 106 of 280Previous Next