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 “Member ID reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagMember ID reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-418127	CLM	Shirley Le	2002-03-28	UHC-24005-09	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-140100	ENR	James Rodriguez	1966-11-02	UHC-72572-86	3212877700	—	0.96	Phone reformatted Member ID reformatted
ENR-133222	ENR	Wayne Bennett	1948-01-25	UHC-55267-20	—	—	0.96	Name re-cased Member ID reformatted
CLM-417468	CLM	Bobby Mendez	1987-11-04	UHC-62846-21	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-104313	ENR	Teresa Tran	1997-11-01	UHC-44901-09	8853851323	9048 Grand Ave, Charlotte, NC, 28221	0.96	Member ID reformatted Placeholder values cleared
TPA-58045	TPA	Virginia Gilbert	1993-01-02	UHC-53698-80	—	1426 Broadway, Fresno, CA, 93706	0.96	Member ID reformatted Placeholder values cleared
CLM-415261	CLM	Keith Vazquez	1987-09-27	UHC-45575-16	—	6693 Union St, Las Vegas, NV, 89126	0.96	Member ID reformatted Placeholder values cleared
TPA-52276	TPA	Joe Cook	1938-06-26	UHC-94709-46	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-135851	ENR	Peter S Austin	1976-01-23	UHC-85220-86	4504836905	6884 Maple Ave, Gilbert, AZ, 85265	0.96	Member ID reformatted Whitespace trimmed
ENR-133094	ENR	Roger Carroll	1989-12-15	UHC-02528-79	4793085509	7101 Broadway, Phoenix, AZ, 85039	0.96	Phone reformatted Member ID reformatted
ENR-128401	ENR	Eric Morgan	1994-05-07	UHC-37404-89	7144826159	798 Ocean Ave, Miami, FL, 33186	0.96	Member ID reformatted Placeholder values cleared
ENR-110936	ENR	Amber R Burton	1949-09-08	UHC-62880-17	6229473047	9798 Canyon Rd, Minneapolis, MN, 55419	0.96	Phone reformatted Member ID reformatted
CLM-412208	CLM	Jason Holmes	1944-04-09	UHC-86982-57	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-117907	ENR	Carlos W Myers	1970-08-28	UHC-00053-31	7755456376	4213 Palm Dr, Denver, CO, 80249	0.96	Name re-cased Member ID reformatted
TPA-61794	TPA	Jessica Burns	1957-03-03	UHC-46307-71	—	7840 Desert Sky Blvd, Scottsdale, AZ, 85211	0.96	Member ID reformatted Placeholder values cleared
CLM-418970	CLM	Keith Robinson	1981-11-05	UHC-40022-20	—	7321 Baseline Rd, Los Angeles, CA, 90066	0.96	Member ID reformatted Placeholder values cleared
ENR-127437	ENR	Mike O Price	1980-05-02	UHC-04060-41	3905933093	4655 Apache Blvd, San Antonio, TX, 78252	0.96	Name re-cased Member ID reformatted
CLM-408015	CLM	Cheryl Daniels	1966-01-28	UHC-21002-42	2489555445	1820 Jefferson Ave, Phoenix, AZ, 85091	0.96	Phone reformatted Member ID reformatted
ENR-128234	ENR	Pmela V Scott	2003-06-02	UHC-72353-94	—	5921 Harbor Blvd, Tucson, AZ, 85761	0.96	Name re-cased Member ID reformatted
TPA-57623	TPA	Carolyn Gutierrez	1948-06-25	UHC-61047-79	8753951746	4424 Church St, Seattle, WA, 98189	0.96	Member ID reformatted Placeholder values cleared
CLM-415705	CLM	Juan O Williams	1950-11-24	UHC-25722-63	2572871449	8198 Lincoln Way, Scottsdale, AZ, 85279	0.96	Member ID reformatted Placeholder values cleared
ENR-125421	ENR	Jordan H Watson	1999-10-05	UHC-22725-60	8255465233	—	0.96	Member ID reformatted Placeholder values cleared
ENR-120630	ENR	Daniielle B Delgado	1947-03-07	UHC-41868-86	2748984952	1357 Elm St, Tucson, AZ, 85737	0.96	Phone reformatted Member ID reformatted
CLM-431763	CLM	Dylan Alexander	2003-08-15	UHC-29580-17	5559234313	—	0.96	Member ID reformatted Placeholder values cleared
ENR-125682	ENR	Mason Bowman	1979-05-22	UHC-07066-33	4417486036	5011 Spring St, Fresno, CA, 93724	0.96	Phone reformatted Member ID reformatted
CLM-401557	CLM	Santiago Rivera	1951-02-05	UHC-93168-85	—	—	0.96	Member ID reformatted Placeholder values cleared
CLM-402852	CLM	Santiago M Nunez	1954-08-27	UHC-42554-30	6593579338	8018 Union St, Chandler, AZ, 85236	0.96	Member ID reformatted Whitespace trimmed
ENR-126912	ENR	Fatima Harrison	1998-11-28	UHC-85147-33	2735493502	4478 Mountain View Dr, Denver, CO, 80207	0.96	Phone reformatted Member ID reformatted
PRV-23589	PRV	Harold Smith	1964-12-25	UHC-54412-91	4263676235	6838 Camelback Rd, Denver, CO, 80214	0.96	Phone reformatted Member ID reformatted
ENR-103925	ENR	Devid Hanson	2005-11-08	UHC-84368-97	7137453767	6176 Pine Dr, Jacksonville, FL, 32228	0.96	Phone reformatted Member ID reformatted
ENR-131974	ENR	Angela Coleman	1928-06-02	UHC-49296-52	—	38 Lincoln Way, Sacramento, CA, 95830	0.96	Member ID reformatted Whitespace trimmed
ENR-110365	ENR	Emma Richards	1964-03-20	UHC-83085-09	—	7118 Indian School Rd, Jacksonville, FL, 32253	0.96	Member ID reformatted Placeholder values cleared
ENR-133173	ENR	Lucia M Guerrero	2007-03-10	UHC-27035-87	7722482192	9173 Lake View Rd, Tempe, AZ, 85259	0.96	Phone reformatted Member ID reformatted
CLM-418026	CLM	Mariana Henderson	1975-11-21	UHC-66782-51	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-125473	ENR	Frank N Bradley	1967-04-11	UHC-83035-86	5223348332	789 Church St, Plano, TX, 75015	0.96	Phone reformatted Member ID reformatted
ENR-108990	ENR	Jeffrey Morgan	1998-07-01	UHC-90958-26	2125844488	3900 Bayshore Dr, Charlotte, NC, 28244	0.96	Phone reformatted Member ID reformatted
ENR-120814	ENR	Maria Rogers	1942-03-21	UHC-43979-59	—	9359 Main St, Los Angeles, CA, 90035	0.96	Member ID reformatted Email lower-cased
TPA-58792	TPA	Valentina Matthews	1997-01-27	UHC-48680-26	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-110282	ENR	Virginia Hll	1943-10-02	UHC-71744-83	6052389235	—	0.96	Phone reformatted Member ID reformatted
ENR-142454	ENR	Larry Y Fields	1966-04-23	UHC-55456-32	6448566042	7205 Broadway, Miami, FL, 33100	0.96	Phone reformatted Member ID reformatted
ENR-102772	ENR	Sraa Hamliton	1977-01-11	UHC-62889-75	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-133329	ENR	Diane P Stephens	2008-09-28	UHC-70379-01	3739888509	4615 Desert Sky Blvd, Scottsdale, AZ, 85244	0.96	Member ID reformatted Placeholder values cleared
ENR-142345	ENR	Emma M Hunt	1947-01-07	UHC-62884-86	5319379276	1551 Jefferson Ave, Sacramento, CA, 95846	0.96	Phone reformatted Member ID reformatted
ENR-126588	ENR	Maria E Wells	1945-03-19	UHC-02332-78	7306534530	7304 Mountain View Dr, Phoenix, AZ, 85099	0.96	Member ID reformatted City re-cased
CLM-422451	CLM	Roger Lawson	1955-03-01	UHC-72270-43	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-139700	ENR	Russell Matthews	2002-06-26	UHC-10245-84	3513975523	6159 Canyon Rd, Plano, TX, 75028	0.96	Date of birth reformatted Member ID reformatted
ENR-108719	ENR	Raymond Rodriguez	1980-09-11	UHC-81501-18	—	6125 Meadow Ln, Denver, CO, 80288	0.96	Name re-cased Member ID reformatted
CLM-405018	CLM	Richard Washington	1988-08-26	UHC-88068-66	—	—	0.96	Member ID reformatted Placeholder values cleared
TPA-63861	TPA	Rachel Gordon	1973-01-27	UHC-47143-30	—	—	0.96	Member ID reformatted Placeholder values cleared
ENR-120282	ENR	Jean Young	1940-05-22	UHC-88826-06	3784374877	8587 Hillcrest Rd, Las Vegas, NV, 89110	0.96	Member ID reformatted Placeholder values cleared

7,723 rows, page 154 of 155Previous Next