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 “Placeholder values cleared”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagPlaceholder values clearedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-126850	ENR	Camila Richardson	1972-05-10	UHC-85070-52	7402265247	1818 Sage Ct, Sacramento, CA, 95879	0.46	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+5 more
ENR-139967	ENR	Gordon Natalie	1981-08-11	UHC-02756-89	9143118304	3906 Oak St # 102, Orlando, FL, 32814	0.46	Name re-cased Phone reformatted Member ID reformatted SSN last four extracted+5 more
ENR-113921	ENR	Brittany Dean	1956-10-08	UHC-88757-02	8323029322	579 Ridge Rd, Denver, CO, 80204	0.46	Name split from “Last, First”Phone reformatted Member ID reformatted Street suffix standardised+5 more
ENR-125233	ENR	Cynthia H Lopez	2003-11-17	UHC-81064-96	3319725403	4377 Washington St Apt 1, Austin, TX, 78715	0.46	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+5 more
ENR-103228	ENR	Ethan K Estrada	1966-04-28	UHC-68529-89	2913627424	5007 Apache Blvd, Chandler, AZ, 85229	0.46	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-117285	ENR	Kevin Le	1955-05-21	UHC-36777-51	—	37 Park Pl, Austin, TX	0.46	Name re-cased Phone missing area code Street suffix standardised Address re-cased+5 more
ENR-131465	ENR	Charles G Perry	1953-09-03	UHC-24528-85	8819610904	3200 Mesa Dr, Glendale, AZ, 85307	0.46	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-132091	ENR	—Junk	1954-10-10	UHC-35421-78	9599179021	8938 Union St, Gilbert, AZ, 85212	0.46	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+5 more
ENR-110645	ENR	Randy Wood	1981-05-19	UHC-10379-19	7357520739	4592 Desert Sky Blvd, Glendale, AZ	0.46	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-106713	ENR	AJunk	1961-10-25	UHC-64703-56	4732937664	870 Market St, Orlando, FL, 32832	0.46	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+5 more
ENR-109862	ENR	Carlos Hudson	1945-12-01	UHC-71677-01	9866245949	4734 Ocean Ave Apt 18, Las Vegas, NV	0.46	Name re-cased Phone reformatted Unit split from street Street suffix standardised+5 more
ENR-122403	ENR	Amy V Espinoza	1996-03-02	UHC-22324-60	6385586027	3957 Sage Ct Apt 21, Dallas, TX, 75233	0.46	Name re-cased Two-digit birth year Phone reformatted Unit split from street+5 more
ENR-103805	ENR	Tony B Gilbert	1968-05-02	UHC-97232-04	8368966269	6768 Church St, Los Angeles, CA, 90038	0.46	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-112479	ENR	Jacqueline S Gonzales	1967-01-28	UHC-45582-20	5388382389	6288 Sage Ct # 111, Mesa, AZ, 85282	0.46	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+5 more
ENR-138995	ENR	Barbara A Rodriguez	1954-04-20	UHC-58424-93	7292017508	8259 Sage Ct, Phoenix, AZ, 85014	0.46	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-116199	ENR	Mdaison Padilla	1963-07-01	UHC-08831-32	5458405782	409 Bayshore Dr, Fresno, CA, 93733	0.46	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-139175	ENR	Keith Adams	1965-02-05	—	3974342422	1984 Church St, San Antonio, TX, 78298	0.46	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-127529	ENR	Virginia M Jordan	1974-06-18	UHC-40489-77	3566574341	585 Ocean Ave, Fresno, CA, 93792	0.46	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+5 more
ENR-105949	ENR	Kathryn Perez	1986-11-13	UHC-05255-47	4134831790	1011 Indian School Rd # 420, Seattle, WA, 98117	0.46	Name re-cased Phone reformatted Unit split from street Street suffix standardised+5 more
ENR-106312	ENR	Bradley Schmidt	1954-04-16	UHC-91040-77	9573535031	7492 Camelback Rd, Eden Prairie, MN, 55395	0.46	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-106313	ENR	Bradley Schmidt	1954-04-16	UHC-91040-77	9573535031	7492 Camelback Rd, Eden Prairie, MN, 55395	0.46	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-141106	ENR	Ana T Rodriguez	1950-02-13	UHC-52673-18	3977060063	7984 Palm Dr, San Diego, CA, 92126	0.46	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-133292	ENR	Ahmed G Li	—	UHC-22067-18	8592720573	754 Elm St, Seattle, WA, 98104	0.48	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+4 more
ENR-125901	ENR	Denise Byd	1943-06-25	UHC-49446-36	8582052390	3478 Bayshore Dr Apt 6, Tampa, FL, 33645	0.48	Phone reformatted Unit split from street Street suffix standardised Address re-cased+4 more
ENR-142680	ENR	Evelyn Frnaklin	1956-10-02	UHC-47615-63	7313852638	5532 Cedar Ln, Mesa, AZ, 85268	0.48	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-114365	ENR	Jacqueline B Cox	1978-10-27	UHC-39035-76	5398218201	521 Union St, Scottsdale, AZ, 85277	0.48	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-112926	ENR	Priya Roberts	1949-04-22	UHC-42307-61	5755388631	7499 Market St, Las Vegas, NV, 89101	0.48	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-141547	ENR	Andrew Hoffman	—	UHC-49164-75	5524392270	8112 Meadow Ln # 918, Tampa, FL, 33690	0.48	Date of birth missing Phone reformatted Unit split from street Street suffix standardised+4 more
ENR-133964	ENR	Carol H Day	1965-09-01	UHC-08350-05	7899428724	4642 Lake View Rd # 217, Sacramento, CA, 95856	0.48	Member ID reformatted Unit split from street Street suffix standardised Address re-cased+4 more
ENR-117665	ENR	Adam I McCoy	—	UHC-56750-62	2552709479	6072 Canyon Rd, San Antonio, TX, 78263	0.48	Name split from “Last, First”Date of birth unreadable Phone reformatted Street suffix standardised+4 more
ENR-104454	ENR	Jessica G Brns	2007-05-20	UHC-28147-73	4863633735	8189 Sage Ct, Seattle, WA	0.48	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-131942	ENR	Jeffrey Watson	1977-11-28	UHC-56766-49	3715467483	1332 Central Ave, Tempe, AZ, 85236	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-131734	ENR	Janet Knight	—	UHC-89314-66	5265465202	8349 Forest Ave, Seattle, WA, 98153	0.48	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+4 more
ENR-131044	ENR	Alan T Thompson	1972-10-05	UHC-77689-96	5816288126	2288 Sunset Blvd, Eden Prairie, MN	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-138757	ENR	Arthur Vassquez	2002-12-15	UHC-91248-73	—	2169 Baseline Rd, Mesa, AZ, 85271	0.48	Name re-cased Date of birth reformatted Phone missing area code Street suffix standardised+4 more
ENR-127017	ENR	Soofia Peters	2001-05-16	UHC-73843-80	7665877977	4433 Camelback Rd Apt 33, Glendale, AZ, 85384	0.48	Name split from “Last, First”Date of birth reformatted Phone reformatted Unit split from street+4 more
ENR-120426	ENR	Joshua Gardner	1941-01-10	UHC-87871-01	2466967449	8336 Bayshore Dr, Tucson, AZ, 85774	0.48	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+4 more
ENR-123105	ENR	Jose S Ryan	1948-06-08	UHC-19407-98	—	5976 Market St, Gilbert, AZ, 85281	0.48	Name re-cased Two-digit birth year Phone missing area code Street suffix standardised+4 more
ENR-124981	ENR	Ann Martinez	2006-09-21	UHC-19690-85	2039082871	3769 Highland Ave Apt 39, Houston, TX, 77030	0.48	Name re-cased Unit split from street Street suffix standardised Address re-cased+4 more
ENR-138305	ENR	Emma R Black	1975-09-27	UHC-75057-97	3044807996	9463 Sage Ct, Los Angeles, CA, 90001	0.48	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+4 more
ENR-114106	ENR	Ashley N Hayes	1970-03-20	UHC-08753-09	4842802916	2850 Valley View Dr Apt 38, Chandler, AZ	0.48	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+4 more
ENR-133958	ENR	Brandon U Hart	1982-04-10	UHC-55080-97	6422779496	2303 Indian School Rd Apt 33, Columbus, OH, 43218	0.48	Name split from “Last, First”Middle initial moved out of first name Date of birth reformatted Phone reformatted+4 more
ENR-140219	ENR	Edward Hicks	1989-04-06	UHC-50339-17	6545484363	3192 Mesa Dr, Columbus, OH	0.48	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-112207	ENR	Brenda Coleman	1992-11-18	UHC-20384-71	6625946961	7077 Sunset Blvd, Denver, CO, 80293	0.48	Name split from “Last, First”Date of birth reformatted SSN last four extracted Street suffix standardised+4 more
ENR-122862	ENR	Sean F Price	1952-05-18	—	6433590619	469 Apache Blvd, Chandler, AZ, 85296	0.48	Phone reformatted Street suffix standardised Address re-cased State name converted to code+4 more
ENR-141386	ENR	Bran O Fox	1940-05-21	UHC-71539-25	5779045222	4990 Highland Ave, Denver, CO, 80230	0.48	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-122010	ENR	Virginia Lynch	1988-09-10	UHC-88578-38	—	9775 Willow Ct, San Antonio, TX	0.48	Name re-cased Date of birth reformatted Phone missing area code Street suffix standardised+4 more
ENR-122446	ENR	Lauren C Montgomery	1983-02-01	UHC-75031-08	6044000336	3614 Canyon Rd, Fresno, CA	0.48	Phone reformatted Street suffix standardised Address re-cased ZIP missing+4 more
ENR-140499	ENR	Ana E King	—	UHC-25436-16	3803949632	5915 Park Pl # 766, Orlando, FL, 32850	0.48	Date of birth unreadable Phone reformatted Unit split from street Street suffix standardised+4 more
ENR-138534	ENR	Nancy Sims	1976-06-23	UHC-57979-93	7655250239	9620 Hillcrest Rd, Atlanta, GA	0.48	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more

16,916 rows, page 11 of 339Previous Next