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 “City re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagCity re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-119910	ENR	Mark Ramirez	1959-05-03	UHC-99276-30	7456974660	4317 Lake View Rd, Seattle, WA, 98109	0.76	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-119997	ENR	Peter Alexander	1956-02-21	UHC-59069-95	—	4354 Spring St, Scottsdale, AZ, 85259	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-132550	ENR	Lawrence King	1965-02-16	UHC-50289-20	2628417769	8299 Maple Ave, Glendale, AZ	0.76	Name re-cased City re-cased State code upper-cased ZIP missing+2 more
ENR-140041	ENR	Roger Wallace	2006-10-20	UHC-81010-87	—	9216 Lake View Rd, Las Vegas, NV, 89131	0.76	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-107989	ENR	Sharon Q Chen	1944-12-17	UHC-70082-42	6273412951	7510 Maple Ave, Nashville, TN, 37208	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-109622	ENR	George K Mruphy	1998-10-14	UHC-12080-51	9648052507	707 Apache Blvd, Sacramento, CA, 95898	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-104926	ENR	Julei X Bowman	2002-09-10	UHC-06316-83	8434821286	3620 Harbor Blvd, Glendale, AZ, 85349	0.76	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-119102	ENR	Eric Davis	1993-07-03	UHC-71634-23	7304239708	6609 Elm St, Las Vegas, NV, 89134	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-103535	ENR	Patrick Martin	1999-03-11	UHC-72447-31	8724437999	4775 Spring St, Dallas, TX, 75216	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-132340	ENR	Martha Knight	1949-02-09	UHC-46240-42	3038509698	9616 Valley View Dr, Denver, CO, 80276	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-103941	ENR	Mason R Lawrence	1980-03-04	UHC-24473-72	8498936797	7666 Baseline Rd, Scottsdale, AZ, 85206	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-113274	ENR	Martha V Walker	1956-04-23	UHC-20345-09	—	5551 Highland Ave, Phoenix, AZ, 85011	0.76	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-117303	ENR	Nathan Fernandez	1993-03-22	UHC-35679-26	5919923960	5278 River Rd, Jacksonville, FL, 32247	0.76	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+2 more
ENR-114238	ENR	Katherine R Perkins	1982-11-04	UHC-47698-99	6237925680	2958 Valley View Dr, San Diego, CA, 92173	0.76	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-107639	ENR	Mark X Valdez	2008-09-01	UHC-57968-08	5977878941	858 Indian School Rd, Glendale, AZ, 85372	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-134007	ENR	Pul Murphy	1954-11-21	UHC-93980-80	—	1988 Mesa Dr, Atlanta, GA, 30321	0.76	Date of birth reformatted Member ID reformatted City re-cased Gender normalised+2 more
ENR-112432	ENR	Teresa U Greene	1966-10-05	UHC-09192-11	8096719727	6237 Oak St, San Diego, CA, 92178	0.76	Phone reformatted City re-cased State code upper-cased Gender normalised+2 more
ENR-101373	ENR	Sophia R Henry	1981-11-04	UHC-79809-95	—	8262 Valley View Dr, San Antonio, TX, 78238	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-101140	ENR	Brenda K Mitchell	1973-10-13	UHC-31490-89	7375024807	194 Willow Ct, Minneapolis, MN, 55439	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-109513	ENR	Carol Mendoza	1946-05-19	UHC-73382-64	8912186104	7006 Harbor Blvd, Jacksonville, FL, 32220	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-130340	ENR	Betty Watson	1943-11-22	UHC-75010-07	4205068403	1523 Indian School Rd, Austin, TX, 78750	0.76	Name re-cased Phone reformatted City re-cased State name converted to code+2 more
ENR-124572	ENR	Patrica Silva	2005-12-22	UHC-24196-87	—	5391 Harbor Blvd, Las Vegas, NV, 89117	0.76	Name re-cased Date of birth reformatted Phone missing area code City re-cased+2 more
ENR-134765	ENR	Eward Mejia	2000-01-19	UHC-69138-47	3816780640	4542 Jefferson Ave, Miami, FL, 33161	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-116983	ENR	Logan Singh	1959-09-11	UHC-20844-84	7132657129	7977 Sunset Blvd, San Diego, CA, 92116	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-142476	ENR	Dylan M Alvarez	1990-06-08	UHC-79741-17	6355834105	8506 Bayshore Dr, Phoenix, AZ, 85072	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-102500	ENR	Arjun S Estrada	1939-06-10	UHC-68251-75	4596356290	1178 Meadow Ln, Charlotte, NC, 28218	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-134808	ENR	Adam Singh	1948-02-03	UHC-56507-16	6747573941	1814 Broadway, Tucson, AZ, 85761	0.76	Name re-cased Phone reformatted SSN last four extracted City re-cased+2 more
ENR-110526	ENR	Samantha Weaver	2007-11-02	UHC-78349-47	8098140489	419 Oak St, Scottsdale, AZ, 85236	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-126983	ENR	Billy C Chapman	1976-03-28	UHC-39604-11	6288740578	1773 Washington St, San Diego, CA, 92178	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-101471	ENR	Scott Fields	1974-08-26	UHC-87012-94	7827974507	2940 Pine Dr, Seattle, WA, 98188	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-101470	ENR	Scott Fields	1974-08-26	UHC-87012-94	7827974507	2940 Pine Dr, Seattle, WA, 98188	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-110897	ENR	Judith Hall	1956-02-10	UHC-93719-29	9185581715	8291 Pine Dr, Atlanta, GA, 30324	0.76	Name re-cased Phone reformatted City re-cased ZIP+4 trimmed+2 more
ENR-130758	ENR	Mariana Y Maritnez	1973-02-25	UHC-91751-31	4526045419	29 Sage Ct, San Antonio, TX, 78274	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-119148	ENR	Diana S Mendez	1998-04-20	UHC-96329-81	3518197282	9376 Pine Dr, Jacksonville, FL, 32260	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-131788	ENR	Alan Powell	1998-03-04	UHC-25780-72	9346054319	3127 Washington St, Phoenix, AZ, 85083	0.76	Name split from “Last, First”Phone reformatted City re-cased Email lower-cased+2 more
ENR-135719	ENR	Stephen X Carter	1945-09-16	UHC-47675-96	4782268064	8200 Pine Dr, Tempe, AZ, 85245	0.76	Name split from “Last, First”Phone reformatted Member ID reformatted City re-cased+2 more
ENR-128444	ENR	Eric Reed	1986-07-19	UHC-40907-39	4795893221	9178 Sunset Blvd, Austin, TX, 78728	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-104188	ENR	Dorothy R Dunn	1981-01-05	UHC-29454-55	8804964462	6422 Highland Ave, Atlanta, GA, 30333	0.76	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-121258	ENR	Doris T Jackson	1964-10-17	UHC-46932-02	3072851734	7288 Ocean Ave, Glendale, AZ, 85348	0.76	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-134498	ENR	Frank Fernandez	1987-09-07	UHC-26756-01	4216293411	2613 Oak St, Chandler, AZ, 85215	0.76	Street suffix standardised Address re-cased City re-cased Email lower-cased+2 more
ENR-117081	ENR	Henry R Campbell	2001-08-15	UHC-45214-87	8038862277	5329 Camelback Rd, Columbus, OH, 43298	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-140878	ENR	Eric Garcia	1963-07-22	UHC-51240-13	7555115847	4281 Grand Ave, Minneapolis, MN, 55483	0.76	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-105795	ENR	Arthur K Meyer	1985-07-06	UHC-06599-74	—	1047 Mountain View Dr, Houston, TX, 77050	0.76	Name re-cased City re-cased ZIP+4 trimmed Email lower-cased+2 more
ENR-100970	ENR	Anna Ward	1948-12-10	UHC-23557-50	9636611272	5148 Broadway, Austin, TX, 78724	0.76	Name re-cased Address re-cased City re-cased Email lower-cased+2 more
ENR-100015	ENR	Betty L Hall	1942-12-11	UHC-11261-09	6962864241	9814 Lake View Rd, Eden Prairie, MN, 55337	0.76	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-118528	ENR	Michelle Wong	1995-11-14	UHC-62600-52	6462542770	9654 Central Ave, Chandler, AZ, 85215	0.76	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-127920	ENR	Christina Armsstrong	2005-06-12	UHC-11516-24	4533964612	8993 Jefferson Ave, Houston, TX, 77061	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-109753	ENR	Carol Martinez	1972-05-11	UHC-93836-27	9649427273	3394 River Rd # 101, Mesa, AZ, 85253	0.76	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
ENR-124792	ENR	Katherine S Chapman	1942-08-10	UHC-91355-21	8488191160	220 Highland Ave, Houston, TX, 77082	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-115718	ENR	Alexander Anderson	1950-05-14	UHC-79887-28	4783200973	1045 Ocean Ave, Orlando, FL, 32883	0.76	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+2 more

8,423 rows, page 106 of 169Previous Next