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-112822	ENR	Juaan I Patterson	—	UHC-85494-38	—	6790 Lake View Rd, Dallas, TX, 75208	0.52	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+2 more
ENR-137439	ENR	Rick Tran	—	UHC-09404-57	—	7877 Oak St, Plano, TX, 75003	0.52	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
ENR-117138	ENR	Amy Bryant	1950-02-10	UHC-84464-07	—	2882 Oak St, Fresno, CA, 93709	0.52	Name split from “Last, First”Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-103006	ENR	Camila Y Hunt	1977-03-09	UHC-86053-10	8228142755	6537 Hillcrest Rd, Scottsdale, AZ, 85266	0.52	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-120474	ENR	Laura Q Ramos	1995-07-22	UHC-35531-48	—	9515 Jefferson Ave, Tucson, AZ, 85754	0.52	Name re-cased Phone missing area code Street suffix standardised Address re-cased+2 more
ENR-130010	ENR	Zachary Black	1942-11-02	UHC-41546-11	—	292 Hillcrest Rd Apt 16, Denver, CO, 80278	0.52	Unit split from street Street suffix standardised Address re-cased Gender normalised+2 more
ENR-111373	ENR	Kayla S Scott	1952-09-07	UHC-27673-03	—	4856 Willow Ct Apt 38, Chandler, AZ, 85256	0.52	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-119347	ENR	Cynthia M King	1956-04-22	UHC-47003-55	2809904207	1946 Jefferson Ave, Austin, TX, 78775	0.52	Street suffix standardised Address re-cased ZIP+4 trimmed Gender normalised+2 more
ENR-107745	ENR	Stephanie Hunt	1938-10-16	UHC-49424-93	4562020786	1688 Grand Ave, San Diego, CA, 92143	0.52	Name split from “Last, First”Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-104856	ENR	Adam V Snigh	2002-01-12	UHC-60218-20	9593836872	5610 Camelback Rd # 457, Nashville, TN, 37217	0.52	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+8 more
ENR-117148	ENR	Willie Y Moore	1998-03-23	UHC-93388-11	3167599553	6226 Ocean Ave, Eden Prairie, MN	0.52	Street suffix standardised Address re-cased ZIP missing Gender normalised+2 more
ENR-104887	ENR	Gloria Fox	1957-08-02	UHC-63442-75	5716247551	1475 Lake View Rd, Sacramento, CA	0.52	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-139205	ENR	Timothy J Tucker	1952-07-12	UHC-58261-21	9278573919	6457 Hillcrest Rd, Nashville, TN, 37266	0.52	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-136328	ENR	Peter Y West	1975-01-06	UHC-81086-81	6986086364	9360 Elm St, Los Angeles, CA, 90076	0.52	Name split from “Last, First”Street suffix standardised Address re-cased State name converted to code+2 more
ENR-137262	ENR	Waltre B Bowman	1971-04-16	UHC-06407-48	8293895963	9491 Apache Blvd, Houston, TX, 77035	0.52	Middle initial moved out of first name Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-119862	ENR	—Junk	1970-03-25	UHC-26068-29	4725175080	6252 Valley View Dr, Minneapolis, MN, 55448	0.52	Phone reformatted Street suffix standardised Address re-cased Gender normalised+2 more
ENR-108250	ENR	YJunk	1949-11-20	UHC-71270-80	3344736083	9156 Church St, Tucson, AZ, 85792	0.52	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+2 more
ENR-102575	ENR	Alan Moreno	—	UHC-82912-03	—	5285 Ocean Ave, San Diego, CA, 92140	0.52	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+2 more
ENR-133405	ENR	Stephen Y Webb	1950-06-21	UHC-02013-78	7028641262	3827 Camelback Rd # 983, Mesa, AZ, 85215	0.52	Two-digit birth year Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-110956	ENR	Diego D Nguyen	1985-12-09	UHC-13195-60	3068492793	7290 Hillcrest Rd, Tempe, AZ, 85278	0.52	Name split from “Last, First”Phone reformatted State name converted to code Gender normalised+2 more
ENR-124425	ENR	Noah S Rodriguez	1988-05-14	UHC-97176-02	7836976438	8528 Harbor Blvd # 702, Los Angeles, CA, 90082	0.52	Unit split from street Street suffix standardised Address re-cased State name converted to code+2 more
ENR-130122	ENR	Natalie Payne	1972-03-19	UHC-54535-12	5883360794	3159 Maple Ave, Columbus, OH, 43268	0.52	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-107215	ENR	Roger D Porter	1992-03-10	UHC-61167-62	3457276244	5095 Ridge Rd, Chandler, AZ, 85256	0.52	Name split from “Last, First”Middle initial moved out of first name Street suffix standardised Address re-cased+2 more
ENR-139026	ENR	Betty Henderson	1979-05-25	UHC-12907-68	7637816917	5407 Willow Ct, Fresno, CA, 93724	0.52	Two-digit birth year Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-135645	ENR	Ahmed G Harrison	1977-06-08	UHC-65862-40	—	1572 Palm Dr, Minneapolis, MN, 55485	0.52	Name re-cased SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-119899	ENR	Kyle Payne	1959-08-12	UHC-34802-47	5037025706	6422 Forest Ave, Gilbert, AZ, 85239	0.52	SSN last four extracted Street suffix standardised Address re-cased City re-cased+2 more
ENR-118770	ENR	Ralph Reed	1978-06-03	UHC-28797-29	3289065305	6164 Main St, Nashville, TN, 37205	0.52	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-112819	ENR	Yuki Lynch	1963-06-01	UHC-60388-32	—	1153 Canyon Rd Apt 20, Gilbert, AZ, 85223	0.52	Unit split from street Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-115534	ENR	Beverly Walker	—	UHC-69135-96	—	588 Baseline Rd, Orlando, FL	0.52	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
ENR-117737	ENR	Eugene T Hanson	1955-06-03	UHC-51392-83	7994356982	4699 Washington St, Atlanta, GA, 30324	0.52	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-121215	ENR	Sara Lee	1949-02-03	UHC-92684-75	—	7622 Desert Sky Blvd, Denver, CO, 80298	0.52	Two-digit birth year Street suffix standardised Address re-cased City re-cased+2 more
ENR-123404	ENR	Susan Y Herrera	—	UHC-06139-07	6624850951	1060 Meadow Ln, Las Vegas, NV, 89156	0.52	Date of birth missing Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-114586	ENR	King Sofia	1959-10-18	UHC-08034-30	4546029507	1813 Valley View Dr Apt 31, Scottsdale, AZ, 85248	0.52	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-101409	ENR	Olivia I Carrr	1950-07-25	—	6778441730	3834 Forest Ave Apt 20, Jacksonville, FL, 32222	0.52	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-102972	ENR	Sean K Jenkins	1946-04-18	—	9796543950	2326 Desert Sky Blvd, Chandler, AZ, 85263	0.52	Name split from “Last, First”SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-122321	ENR	Sara C Burton	—	UHC-23295-30	4926145177	9018 Bayshore Dr, Gilbert, AZ, 85285	0.52	Name split from “Last, First”Date of birth unreadable Phone reformatted Street suffix standardised+2 more
ENR-105083	ENR	Dorothy T Clakr	1989-03-13	UHC-97273-05	—	9671 Sunset Blvd, San Antonio, TX	0.52	SSN last four extracted Street suffix standardised Address re-cased ZIP missing+2 more
ENR-136287	ENR	Bradley E Lawrence	1991-06-06	UHC-86126-65	8235323645	4747 Desert Sky Blvd, Jacksonville, FL	0.52	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-137572	ENR	Christopher Young	1993-07-09	UHC-27607-79	—	1866 Church St, Chandler, AZ, 85269	0.52	Name split from “Last, First”Date of birth reformatted SSN last four extracted Street suffix standardised+2 more
ENR-140720	ENR	Jose H Sims	1986-01-20	UHC-00961-23	6822478518	3700 Park Pl, Las Vegas, NV, 89101	0.52	Middle initial moved out of first name Name re-cased Street suffix standardised Address re-cased+2 more
ENR-138527	ENR	Deborah Y Waard	1989-10-07	UHC-37082-41	6374497703	817 Willow Ct, Minneapolis, MN, 55447	0.52	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-133431	ENR	Kelly Wallace	2001-09-05	UHC-98623-51	—	9436 Oak St, Scottsdale, AZ, 85287	0.52	Name split from “Last, First”Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-127021	ENR	Carolyn Z Porter	1995-04-15	UHC-44477-87	—	5268 Church St, Seattle, WA, 98188	0.52	Name split from “Last, First”Middle initial moved out of first name Street suffix standardised Address re-cased+2 more
ENR-121198	ENR	George C Sanchez	1970-05-24	UHC-75107-90	2257196452	1944 Park Pl Apt 15, Seattle, WA	0.52	Date of birth reformatted Phone reformatted Unit split from street State name converted to code+2 more
ENR-121170	ENR	Donald OJunk	1999-01-19	UHC-13344-80	4376913779	5902 Broadway # 844, Eden Prairie, MN, 55322	0.52	Name re-cased Date of birth reformatted Unit split from street Gender normalised+2 more
ENR-134254	ENR	Jese P Park	1950-02-11	UHC-31353-24	9487225676	5096 Valley View Dr, Charlotte, NC	0.52	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-139045	ENR	Don Hudson	1964-02-07	UHC-48273-26	—	6118 Lake View Rd, Minneapolis, MN, 55444	0.52	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-106085	ENR	Eugene Perkins	1991-05-21	UHC-74376-09	4092640195	8300 Canyon Rd, San Antonio, TX, 78243	0.52	Name split from “Last, First”Two-digit birth year Phone reformatted Member ID reformatted+2 more
ENR-124089	ENR	Denise S Ward	1959-07-06	UHC-58871-56	—	8358 Lake View Rd, Miami, FL, 33113	0.52	Name split from “Last, First”Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-103198	ENR	Sandra Morris	1976-08-19	UHC-98911-16	6228348788	8039 Valley View Dr, Minneapolis, MN, 55428	0.52	Name split from “Last, First”Two-digit birth year Phone reformatted ZIP+4 trimmed+2 more

16,916 rows, page 33 of 339Previous Next