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

All sources, flag “ZIP+4 trimmed”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP+4 trimmedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-133349	ENR	Gregory T Tucker	1959-01-20	UHC-79367-81	—	5215 Mountain View Dr, Columbus, OH, 43294	0.80	Member ID reformatted ZIP+4 trimmed Email lower-cased Whitespace trimmed
ENR-103716	ENR	Dylan I Taylor	1946-10-06	UHC-33407-72	8737763810	8606 Park Pl, Atlanta, GA, 30366	0.80	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed
CLM-409838	CLM	Raymond Payne	1976-06-01	UHC-06240-95	3808478937	7626 Broadway, Denver, CO, 80272	0.80	Address re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-138464	ENR	Ryan Henderson	1988-02-26	UHC-25992-50	4565937328	2700 Maple Ave, Orlando, FL, 32870	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Email lower-cased
ENR-139784	ENR	Gloria C Ferguson	1971-01-27	—	2657068945	2709 Broadway, Minneapolis, MN, 55427	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-112760	ENR	Gary Stewart	1979-12-12	UHC-82371-38	3799574039	2034 Valley View Dr, Tempe, AZ, 85273	0.80	Name re-cased ZIP+4 trimmed Plan code upper-cased Whitespace trimmed
PRV-24727	PRV	Lucia Hawkins	2008-01-14	UHC-18251-37	4345373950	6889 Ocean Ave, Tempe, AZ, 85218	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-117528	ENR	Ashley N Griffin	1996-03-05	UHC-30684-46	—	7288 Market St, Houston, TX, 77062	0.80	City re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-127865	ENR	Mark Schmidt	1966-10-14	UHC-60593-83	2096465528	953 Meadow Ln, Mesa, AZ, 85287	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-141447	ENR	Lawrence J Davis	1987-06-12	UHC-14304-43	5052901117	9021 Highland Ave, Plano, TX, 75027	0.80	Date of birth reformatted City re-cased ZIP+4 trimmed Plan code upper-cased
PRV-27396	PRV	Tim Clark	1948-06-25	—	7048975860	1128 Broadway, Phoenix, AZ, 85074	0.80	Phone reformatted City re-cased ZIP+4 trimmed Placeholder values cleared
TPA-53107	TPA	Henry Rodriguez	1938-05-03	—	—	5598 Jefferson Ave, Jacksonville, FL, 32243	0.80	Name re-cased Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
CLM-403853	CLM	Margaret M Torres	1995-06-22	UHC-34210-05	8554497827	1549 Ridge Rd, Jacksonville, FL, 32292	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-124154	ENR	Kyle Padilla	1983-10-02	UHC-83600-99	9539413714	9353 Valley View Dr, San Antonio, TX, 78227	0.80	Phone reformatted ZIP+4 trimmed Email lower-cased Whitespace trimmed
CLM-430052	CLM	Julia Coleman	1958-12-01	—	—	5276 Meadow Ln, Austin, TX, 78780	0.80	Name re-cased City re-cased ZIP+4 trimmed Placeholder values cleared
ENR-116507	ENR	Debra Powell	1945-02-07	UHC-90874-75	7948101299	4358 Forest Ave, Tampa, FL, 33622	0.80	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed
TPA-58203	TPA	Gloria Bery	2008-08-04	—	7644499555	5979 Sage Ct, Mesa, AZ, 85216	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-112262	ENR	Jordan Baker	1990-11-22	UHC-78101-68	8214934284	4551 Broadway, Tucson, AZ, 85779	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-59956	TPA	Brian Gray	1996-10-24	—	—	6673 Valley View Dr, Seattle, WA, 98113	0.80	Name re-cased Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-125994	ENR	Steven Weaver	1963-06-02	UHC-01879-06	6462546354	4330 Harbor Blvd, Houston, TX, 77080	0.80	Name re-cased ZIP+4 trimmed Plan code upper-cased Placeholder values cleared
CLM-404980	CLM	Linda Sanchez	1970-03-22	UHC-89911-60	—	1796 Baseline Rd, Fresno, CA, 93732	0.80	Name re-cased City re-cased ZIP+4 trimmed Placeholder values cleared
ENR-130537	ENR	Billy X Fisher	1981-08-20	UHC-80053-21	9354351554	696 Union St, Nashville, TN, 37259	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-142635	ENR	Cheryl C Oliver	1950-08-04	UHC-04381-26	—	6848 Sage Ct, Gilbert, AZ, 85234	0.80	ZIP+4 trimmed Email lower-cased Whitespace trimmed Placeholder values cleared
CLM-412386	CLM	Kyle Park	1987-07-17	UHC-98992-53	6656685396	1344 Central Ave, Tempe, AZ, 85221	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-62712	TPA	George C Hicks	1998-07-23	—	—	2519 Forest Ave, Sacramento, CA, 95868	0.80	State code upper-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-63937	TPA	Patricia Parker	1956-07-15	—	—	2919 Lake View Rd, Tucson, AZ, 85743	0.80	Name re-cased Date of birth reformatted ZIP+4 trimmed Placeholder values cleared
ENR-126543	ENR	Roger H Wallace	1956-04-21	UHC-00433-86	2352284162	8177 Broadway, Houston, TX, 77034	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed
CLM-400015	CLM	Bell K Margaret	2007-07-25	UHC-39574-66	9864893045	4859 Elm St, Tampa, FL, 33618	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-117610	ENR	Russell S Bailey	1987-04-01	UHC-87909-52	4224240293	4758 Maple Ave, Chandler, AZ, 85276	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-415082	CLM	Jordan Ellis	2004-09-04	UHC-92342-99	—	9877 Mesa Dr, Houston, TX, 77026	0.80	Date of birth reformatted Member ID reformatted ZIP+4 trimmed Placeholder values cleared
ENR-139461	ENR	Harold Watkins	1962-09-01	UHC-53948-51	8545818765	9214 Lake View Rd, San Diego, CA, 92105	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-112175	ENR	Pamela L Simpson	1987-12-16	UHC-42045-03	2748896114	8409 Ridge Rd, Glendale, AZ, 85358	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed
CLM-428126	CLM	Isabella Bell	1965-01-17	UHC-68295-82	—	8002 Cedar Ln, Eden Prairie, MN, 55383	0.80	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-405751	CLM	Keeith Long	1947-10-25	—	6159738489	7989 Maple Ave, Miami, FL, 33196	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-136790	ENR	Wei L Vega	1997-12-07	UHC-47177-97	4972338463	6344 Forest Ave, Sacramento, CA, 95827	0.80	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed
PRV-21041	PRV	Billy Weber	1989-01-02	UHC-14482-44	—	3418 Indian School Rd, Los Angeles, CA, 90086	0.80	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-411365	CLM	Elizabeth Ray	1991-01-25	—	—	7416 Oak St, Las Vegas, NV, 89186	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
TPA-55109	TPA	Santiago Miller	1951-02-23	UHC-98037-76	—	963 Mountain View Dr, Sacramento, CA, 95893	0.80	Name re-cased State code upper-cased ZIP+4 trimmed Placeholder values cleared
PRV-28445	PRV	Kathryn Wilson	1995-04-08	—	—	4396 Sage Ct, Chandler, AZ, 85243	0.80	Name re-cased City re-cased ZIP+4 trimmed Placeholder values cleared
TPA-58529	TPA	Billy Hayes	1996-02-14	—	—	2016 Forest Ave, Houston, TX, 77031	0.80	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-127548	ENR	Melissa Marshall	1998-06-13	UHC-73960-39	6002771530	4529 Grand Ave, Minneapolis, MN, 55492	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-22588	PRV	Catherine Q Marquez	2000-01-20	UHC-51377-30	3005268145	5431 Church St, Austin, TX, 78725	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-22699	PRV	Rachel Sullivan	1999-10-18	UHC-71527-15	5297174849	2625 Grand Ave, Eden Prairie, MN, 55312	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-118172	ENR	Alexis F Peterson	1971-06-13	UHC-41655-03	2862788240	7289 River Rd, Orlando, FL, 32849	0.80	Phone reformatted Member ID reformatted ZIP+4 trimmed Placeholder values cleared
ENR-120698	ENR	Kathy M Duncan	1957-06-27	UHC-88906-54	5183115046	4883 Desert Sky Blvd, Las Vegas, NV, 89149	0.80	Name re-cased City re-cased ZIP+4 trimmed Whitespace trimmed
ENR-121884	ENR	Joseph Payne	1983-10-10	UHC-48006-84	9685451234	5057 Central Ave, Tampa, FL, 33620	0.80	Phone reformatted City re-cased ZIP+4 trimmed Placeholder values cleared
PRV-29404	PRV	Diane Fowler	1962-09-21	—	6362236489	2837 Park Pl, Tampa, FL, 33665	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-414032	CLM	Alexander D Guzman	1954-02-08	UHC-51864-50	8114401953	6252 Pine Dr, Dallas, TX, 75250	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-117670	ENR	Anna M Carr	1972-11-13	UHC-48919-48	4513187275	5510 Elm St, Dallas, TX, 75282	0.80	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed
ENR-117671	ENR	Anna M Carr	1972-11-13	UHC-48919-48	4513187275	5510 Elm St, Dallas, TX, 75282	0.80	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed

8,263 rows, page 154 of 166Previous Next