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 “Middle initial moved out of first name”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagMiddle initial moved out of first nameClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-114875	ENR	Alan Z Perry	1964-05-05	UHC-32955-34	7476040363	2477 Lake View Rd, Scottsdale, AZ, 85238	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
ENR-123806	ENR	Lawrence O Roberts	1982-07-10	UHC-89575-55	2407025915	8451 Jefferson Ave, Nashville, TN, 37239	0.78	Middle initial moved out of first name Date of birth reformatted Phone reformatted Email lower-cased+1 more
ENR-107334	ENR	Steven V Silva	1976-05-11	UHC-27793-12	6584081788	636 Maple Ave, Austin, TX, 78765	0.78	Middle initial moved out of first name Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-103105	ENR	Zachary K Ryan	1986-02-13	UHC-70445-91	—	9018 Forest Ave, Sacramento, CA, 95803	0.78	Middle initial moved out of first name Name re-cased City re-cased State code upper-cased+1 more
ENR-103250	ENR	Fracnes C Sanders	1995-12-19	UHC-30460-10	5564345258	9272 Meadow Ln, Miami, FL, 33150	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
ENR-102456	ENR	Terry B Ruiz	1973-02-25	UHC-41911-95	7406985487	1220 Camelback Rd, Los Angeles, CA, 90053	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
ENR-141918	ENR	Helen R Martin	1996-04-09	UHC-66521-88	7377639489	8841 Market St, Minneapolis, MN, 55498	0.78	Middle initial moved out of first name Name re-cased Phone reformatted City re-cased+1 more
ENR-115796	ENR	Jason G Webb	2003-03-03	UHC-63348-73	8732769099	7904 Maple Ave, Houston, TX, 77000	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Member ID reformatted+1 more
ENR-132140	ENR	Ann O Sims	2003-11-13	UHC-16272-69	6726657957	4580 Lincoln Way, Scottsdale, AZ, 85243	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
ENR-142150	ENR	Ana V Hall	1956-08-16	UHC-72084-69	6015819177	7725 Elm St, Gilbert, AZ, 85203	0.78	Middle initial moved out of first name Name re-cased Phone reformatted State code upper-cased+1 more
ENR-116429	ENR	Samuel C Kelley	1955-07-10	UHC-55006-25	7046110385	5846 Mountain View Dr, Phoenix, AZ, 85012	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
ENR-117470	ENR	Lori X Montgomery	1976-03-03	UHC-68087-17	3637335680	—	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
ENR-130001	ENR	Linda O Nelson	1995-02-14	UHC-41466-73	3775554084	1516 Mountain View Dr, Los Angeles, CA, 90028	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
ENR-100780	ENR	Ralph J Lych	2004-10-24	UHC-06478-38	6814901654	4819 Valley View Dr, Las Vegas, NV, 89131	0.78	Middle initial moved out of first name Name re-cased Phone reformatted State code upper-cased+1 more
ENR-116244	ENR	Vlentina O Daniels	1994-04-20	UHC-13186-78	4535849433	8688 Palm Dr, Seattle, WA, 98108	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
ENR-138624	ENR	Jerry E Morrison	1988-09-22	UHC-74169-30	6067495667	95 Harbor Blvd, Gilbert, AZ, 85262	0.78	Middle initial moved out of first name Date of birth reformatted Phone reformatted Email lower-cased+1 more
ENR-129184	ENR	Becky D Miller	1939-04-16	UHC-49419-41	8552958875	5542 Harbor Blvd, Miami, FL, 33192	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Email lower-cased+1 more
ENR-137911	ENR	Frank K Woods	1986-01-20	UHC-50088-36	9313555987	8774 Mountain View Dr, Gilbert, AZ, 85208	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
ENR-135226	ENR	Nancy F Castillo	1966-04-13	UHC-74758-26	9096105832	2712 Jefferson Ave, Tucson, AZ, 85759	0.78	Middle initial moved out of first name Phone reformatted Email lower-cased Whitespace trimmed+1 more
ENR-135225	ENR	Nancy F Castillo	1966-04-13	UHC-74758-26	9096105832	2712 Jefferson Ave, Tucson, AZ, 85759	0.78	Middle initial moved out of first name Phone reformatted Email lower-cased Whitespace trimmed+1 more
ENR-106269	ENR	Robert B Perkins	1968-11-24	UHC-38217-24	6955273693	7520 Ocean Ave, Jacksonville, FL, 32240	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
ENR-135120	ENR	Ahmed D Russell	1951-03-24	UHC-99350-68	2914949633	9679 Hillcrest Rd, Los Angeles, CA, 90087	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
ENR-142038	ENR	William L Edwards	1941-01-11	UHC-20643-74	5536383529	4598 Church St, Scottsdale, AZ, 85291	0.80	Middle initial moved out of first name Phone reformatted Plan code upper-cased Whitespace trimmed
ENR-101812	ENR	Bryan H Hunter	1966-01-25	UHC-75918-34	4079295859	4283 Mesa Dr, Denver, CO, 80253	0.80	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed
ENR-115905	ENR	Elizbeth H Munoz	1946-03-11	UHC-50406-95	3638607662	4796 Spring St, Columbus, OH, 43205	0.80	Middle initial moved out of first name Date of birth reformatted Phone reformatted Whitespace trimmed
ENR-125790	ENR	David S Wilson	1975-04-10	UHC-64729-88	4184249732	9608 Highland Ave, Miami, FL, 33190	0.80	Middle initial moved out of first name Date of birth reformatted Phone reformatted Email lower-cased
ENR-128525	ENR	Chris E Ortega	1942-02-14	UHC-20181-23	8234727392	2376 Jefferson Ave, Tampa, FL, 33697	0.80	Middle initial moved out of first name Phone reformatted Whitespace trimmed Placeholder values cleared
ENR-127283	ENR	Cheryl A Owens	1976-10-12	UHC-97448-63	4679141075	9579 Lincoln Way, Phoenix, AZ, 85022	0.80	Middle initial moved out of first name Date of birth reformatted Phone reformatted City re-cased
ENR-123316	ENR	Caimla N Andrews	1983-02-08	UHC-90086-43	7636097465	6518 Mesa Dr, Houston, TX, 77024	0.80	Middle initial moved out of first name City re-cased Whitespace trimmed Placeholder values cleared
ENR-136848	ENR	Rcihard H Walker	1985-12-18	UHC-48206-84	7058402548	8826 Jefferson Ave, Tucson, AZ, 85704	0.80	Middle initial moved out of first name Date of birth reformatted Phone reformatted Whitespace trimmed
ENR-102021	ENR	Santiago X Ford	1994-12-11	UHC-19531-20	8246440751	179 Apache Blvd, Tucson, AZ, 85720	0.80	Middle initial moved out of first name Name re-cased Email lower-cased Whitespace trimmed
ENR-142711	ENR	Omar K Brown	1955-11-02	UHC-34550-71	6379314123	1789 Highland Ave, Sacramento, CA, 95819	0.80	Middle initial moved out of first name Name re-cased Date of birth reformatted Email lower-cased
ENR-122710	ENR	Anggela Z Watkins	1959-11-08	UHC-59656-73	3539147433	3595 Mountain View Dr, Jacksonville, FL, 32281	0.80	Middle initial moved out of first name Phone reformatted Email lower-cased Placeholder values cleared
ENR-102814	ENR	Bryan I Mills	1951-02-23	UHC-37502-79	5378880359	978 Harbor Blvd, Tempe, AZ, 85244	0.80	Middle initial moved out of first name Name re-cased Phone reformatted Email lower-cased
ENR-136624	ENR	Cynthia K Pierce	1943-11-01	UHC-83180-92	9458987523	7470 Bayshore Dr, Scottsdale, AZ, 85255	0.80	Middle initial moved out of first name Name re-cased Member ID reformatted Whitespace trimmed
ENR-100268	ENR	Timmothy I Hyll	1972-11-13	UHC-84728-25	2065131588	8169 Main St, Miami, FL, 33171	0.80	Middle initial moved out of first name Name re-cased Phone reformatted Email lower-cased
ENR-128379	ENR	Yuki V Gonzales	1983-06-23	UHC-45856-82	8599703479	7979 Pine Dr, Charlotte, NC, 28244	0.80	Middle initial moved out of first name Date of birth reformatted Phone reformatted City re-cased
ENR-137485	ENR	Juan Q Gutierrez	1998-08-06	UHC-79291-18	8548798762	7584 Mesa Dr, Denver, CO, 80257	0.80	Middle initial moved out of first name Date of birth reformatted Phone reformatted Placeholder values cleared
ENR-124805	ENR	Charles S Ramos	1960-11-01	UHC-32017-70	6774239370	5609 Camelback Rd, Glendale, AZ, 85309	0.80	Middle initial moved out of first name Name re-cased Phone reformatted Placeholder values cleared
ENR-122859	ENR	Jeaan K Crawford	1989-05-19	UHC-16855-50	5029130457	8063 Mountain View Dr, San Diego, CA, 92184	0.80	Middle initial moved out of first name Phone reformatted Email lower-cased Whitespace trimmed
ENR-104914	ENR	Wei W Gardner	2000-01-27	UHC-63664-85	9166691649	4864 Main St, Tampa, FL, 33614	0.80	Middle initial moved out of first name Name re-cased Phone reformatted Placeholder values cleared
ENR-131833	ENR	Maria V Lawson	1976-05-24	UHC-70296-83	3904353332	1902 Broadway, Los Angeles, CA, 90020	0.80	Middle initial moved out of first name Name re-cased Phone reformatted State code upper-cased
ENR-105661	ENR	Ana U Espinoza	1996-11-19	UHC-35329-82	9093355723	9821 Ridge Rd, Phoenix, AZ, 85045	0.80	Middle initial moved out of first name Phone reformatted Whitespace trimmed Placeholder values cleared
ENR-105662	ENR	Ana U Espinoza	1996-11-19	UHC-35329-82	9093355723	9821 Ridge Rd, Phoenix, AZ, 85045	0.80	Middle initial moved out of first name Phone reformatted Whitespace trimmed Placeholder values cleared
ENR-108841	ENR	Marcus Q Romero	1990-03-08	UHC-49692-40	3902103346	7791 Indian School Rd, Denver, CO, 80232	0.80	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed
ENR-116468	ENR	Hiroshi R Padilla	2004-06-07	UHC-81437-39	3352722116	1931 Main St, Austin, TX, 78750	0.80	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted
ENR-124749	ENR	Joran L Greene	1986-10-12	UHC-15739-92	6226699163	7289 Palm Dr, Minneapolis, MN, 55428	0.80	Middle initial moved out of first name Phone reformatted Member ID reformatted Whitespace trimmed
ENR-140837	ENR	Bradley U Brown	1998-07-08	UHC-00137-34	2758195938	9530 Grand Ave, Tampa, FL, 33683	0.80	Middle initial moved out of first name Phone reformatted State code upper-cased Placeholder values cleared
ENR-128072	ENR	Maria X Delgado	1996-06-14	UHC-95248-22	2465913779	9693 Highland Ave, Nashville, TN, 37285	0.80	Middle initial moved out of first name Name re-cased Phone reformatted Placeholder values cleared
ENR-113053	ENR	Alan H Nunez	2003-08-05	UHC-53813-83	9433305822	6551 Maple Ave, Tampa, FL, 33644	0.80	Middle initial moved out of first name Phone reformatted Email lower-cased Whitespace trimmed

756 rows, page 14 of 16Previous Next