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-112973	ENR	Christina Flores	1983-05-23	UHC-54244-79	3995315855	7652 Maple Ave, Orlando, FL, 32821	0.78	Phone reformatted Member ID reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-105288	ENR	Robert A Wang	1951-08-03	UHC-24041-45	2386650626	167 Harbor Blvd, Sacramento, CA, 95888	0.78	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
ENR-102770	ENR	Kathryn Stone	1968-08-16	UHC-92523-76	2576336260	428 Central Ave, Eden Prairie, MN, 55304	0.78	Phone reformatted City re-cased ZIP+4 trimmed Plan code upper-cased+1 more
CLM-406412	CLM	Alexander Evans	2004-08-25	UHC-74290-44	9762337460	8764 Lincoln Way, Columbus, OH, 43272	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-416932	CLM	Stephen Stevens	1987-10-03	—	—	9133 Sage Ct, Phoenix, AZ, 85087	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-50022	TPA	Andrea Murphy	1945-01-09	—	—	3741 Spring St, Atlanta, GA, 30350	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-105642	ENR	Randy Q Snyder	1989-06-16	UHC-66632-26	4318186468	398 Broadway, San Antonio, TX, 78213	0.78	Date of birth reformatted Phone reformatted Address re-cased ZIP+4 trimmed+1 more
ENR-141291	ENR	Anna E Weaver	1965-12-26	—	6639282869	400 Forest Ave, Scottsdale, AZ, 85221	0.78	Phone reformatted ZIP+4 trimmed Email lower-cased Whitespace trimmed+1 more
ENR-124410	ENR	Ryan L Hernandez	1959-01-19	UHC-51810-13	5727094583	6988 Sage Ct, Charlotte, NC, 28205	0.78	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed+1 more
TPA-51274	TPA	Mary Wilson	1988-12-11	UHC-70575-82	—	7940 Ocean Ave, Atlanta, GA, 30390	0.78	Member ID reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-406999	CLM	Megan Williams	1939-04-10	UHC-64753-11	7909719764	8738 Washington St, Phoenix, AZ, 85049	0.78	Phone reformatted Member ID reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-127483	ENR	Joe A Perry	1966-05-21	UHC-65321-03	6253494639	867 Highland Ave, Plano, TX, 75094	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-122929	ENR	Aaron Johnston	1960-02-27	UHC-55586-83	3288759486	7211 Maple Ave, Los Angeles, CA, 90066	0.78	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
PRV-26329	PRV	Barbara Johnston	1974-09-16	UHC-72209-44	5804223914	5293 Washington St, Dallas, TX, 75254	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-123977	ENR	Edward C Peterson	1965-05-18	UHC-86064-90	—	1428 Maple Ave, Orlando, FL, 32889	0.78	Date of birth reformatted Member ID reformatted ZIP+4 trimmed Email lower-cased+1 more
PRV-29477	PRV	Nathhan Palmer	2006-09-05	UHC-74591-49	8533943585	4351 Elm St, Scottsdale, AZ, 85259	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-120931	ENR	Alan Mills	1998-02-18	UHC-85719-06	3477457703	6345 Church St, Eden Prairie, MN, 55347	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-24337	PRV	Ruth N Hicks	2006-01-27	—	—	4785 Pine Dr, Tampa, FL, 33616	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-113442	ENR	Sarah V Hansen	1991-12-08	UHC-41536-07	5992233279	8339 Bayshore Dr, Minneapolis, MN, 55496	0.78	Name re-cased Phone reformatted Member ID reformatted ZIP+4 trimmed+1 more
TPA-62042	TPA	Olivia Lynch	1991-07-18	—	—	4811 Central Ave, Dallas, TX, 75243	0.78	Name re-cased City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-418418	CLM	Henry Wells	1938-11-01	—	2087534582	539 Lincoln Way, Plano, TX, 75092	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-417974	CLM	Douglas Z Gonzales	1991-07-21	UHC-51488-52	7442195854	1017 Apache Blvd, Dallas, TX, 75218	0.78	Phone reformatted Member ID reformatted ZIP+4 trimmed Plan code upper-cased+1 more
ENR-116165	ENR	Susan D Hansen	1942-07-02	UHC-62992-80	4889442037	8129 Palm Dr, Los Angeles, CA, 90010	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-63036	TPA	Carol Turner	1988-06-04	—	8674376699	834 Highland Ave, Eden Prairie, MN, 55325	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-420654	CLM	Jlie Kelly	1984-06-24	UHC-04129-50	9223612848	6254 Broadway, Scottsdale, AZ, 85298	0.78	Name re-cased Phone reformatted Address re-cased ZIP+4 trimmed+1 more
TPA-60856	TPA	Ann O Sims	2003-11-13	UHC-16272-69	6726657957	4580 Lincoln Way, Scottsdale, AZ, 85243	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-59272	TPA	Elizabeth M Dean	1989-06-12	—	6935047284	4310 Church St, Austin, TX, 78747	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-425397	CLM	Omar Castro	1951-12-07	—	—	7219 Oak St, Miami, FL, 33180	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Plan code upper-cased+1 more
ENR-127487	ENR	Nicole Duncan	1948-03-09	UHC-80698-18	3536522952	4596 Maple Ave, Tampa, FL, 33600	0.78	Name re-cased Phone reformatted City re-cased ZIP+4 trimmed+1 more
ENR-135925	ENR	Nicholas B Park	1963-11-01	UHC-31302-45	4787258907	6548 Jefferson Ave, Los Angeles, CA, 90047	0.78	Name re-cased Phone reformatted City re-cased ZIP+4 trimmed+1 more
CLM-421902	CLM	Alexis Price	1958-09-09	UHC-80433-48	9034940566	1324 Main St, Scottsdale, AZ, 85248	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-108118	ENR	Dennis Davis	1995-02-16	UHC-45986-39	9446833114	1031 Jefferson Ave, Tucson, AZ, 85745	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Plan code upper-cased+1 more
CLM-432556	CLM	Sandra M Scott	1974-11-01	UHC-00116-94	4115808782	3389 Harbor Blvd, Las Vegas, NV, 89158	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-404983	CLM	Kaern Wells	1991-03-06	UHC-21724-15	3663926888	3117 Central Ave, Minneapolis, MN, 55407	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-404984	CLM	Kaern Wells	1991-03-06	UHC-21724-15	3663926888	3117 Central Ave, Minneapolis, MN, 55407	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
TPA-55539	TPA	Kathy Brown	1994-08-14	UHC-43169-47	7469228012	3092 Sage Ct, Orlando, FL, 32854	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Email lower-cased+1 more
ENR-142094	ENR	Shirley V Boyd	1972-08-14	UHC-95505-65	6134102978	3550 Ridge Rd, Houston, TX, 77024	0.78	Date of birth reformatted Member ID reformatted City re-cased ZIP+4 trimmed+1 more
ENR-139150	ENR	Jerry M Ortiz	1976-03-06	UHC-80208-01	4273450681	1705 Market St, Tempe, AZ, 85214	0.78	Phone reformatted ZIP+4 trimmed Email lower-cased Whitespace trimmed+1 more
TPA-63085	TPA	Dylan Fernandez	2006-08-09	—	—	467 Indian School Rd, Denver, CO, 80234	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-403137	CLM	Mei Brooks	1986-10-23	UHC-98539-12	9869731343	2240 Lake View Rd, Scottsdale, AZ, 85261	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-120029	ENR	Albert Q Johnston	1949-07-04	UHC-27021-77	3854252227	8226 Canyon Rd, Jacksonville, FL, 32292	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-116813	ENR	Christina Larson	1990-12-21	UHC-21863-98	5029381430	3967 Sage Ct, Nashville, TN, 37276	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed
ENR-129548	ENR	Diego T Richards	1963-02-06	UHC-38262-45	2263570196	2956 Mountain View Dr, Columbus, OH, 43265	0.80	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed
CLM-401720	CLM	Patricia Price	1985-05-18	UHC-93968-03	—	8942 Apache Blvd, Phoenix, AZ, 85097	0.80	State code upper-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-128580	ENR	Aisha N Hernanedz	2005-10-20	UHC-71084-37	5007762542	4692 Jefferson Ave, San Diego, CA, 92139	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-414959	CLM	Dennis Dunn	1984-08-27	—	—	8612 Central Ave, Fresno, CA, 93783	0.80	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-122036	ENR	Denis J Murphy	1953-03-18	UHC-70080-26	4807278523	9734 Bayshore Dr, Charlotte, NC, 28277	0.80	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed
CLM-409337	CLM	Joan Gilbert	1995-06-14	UHC-72248-27	2517239798	6266 Valley View Dr, Austin, TX, 78702	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
ENR-102684	ENR	Jordan Burton	1954-08-28	UHC-73034-90	9786668728	8433 Washington St, Tempe, AZ, 85288	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-408594	CLM	Steven Holmes	1938-02-13	—	6089863242	6670 Washington St, Tempe, AZ, 85245	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared

8,263 rows, page 145 of 166Previous Next