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

Provider network, 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
PRV-26184	PRV	Alexander F Ellis	1979-08-14	—	7955709797	219 Lincoln Way, Denver, CO, 80234	0.78	Date of birth reformatted City re-cased ZIP+4 trimmed Email lower-cased+1 more
PRV-23620	PRV	Lauren A Sims	2007-05-19	UHC-90640-63	8537240105	8513 Lincoln Way, Atlanta, GA, 30306	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-27646	PRV	Karen E Romero	1986-03-19	—	6014145517	6696 Spring St, Denver, CO, 80276	0.78	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
PRV-20735	PRV	Douglas Morgan	1974-01-02	UHC-20227-50	7783900003	4328 Grand Ave, Chandler, AZ, 85207	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-21449	PRV	Billy Mendez	1959-05-15	—	7938147936	1872 Willow Ct, Miami, FL, 33100	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-28842	PRV	Bradley Hunt	1952-02-13	UHC-08493-41	4684525828	3232 Lake View Rd, Nashville, TN, 37206	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Email lower-cased+1 more
PRV-22041	PRV	Diane Gibson	1978-01-07	—	7289213628	8641 Highland Ave, Austin, TX, 78720	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Email lower-cased+1 more
PRV-20811	PRV	Li Gerald	1954-12-24	UHC-76640-91	7913213625	2913 Apache Blvd, Gilbert, AZ, 85201	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-28522	PRV	Martha Herrera	1956-06-01	UHC-70389-89	3229670616	1696 Park Pl, Los Angeles, CA, 90054	0.78	Name re-cased Phone reformatted City re-cased ZIP+4 trimmed+1 more
PRV-23829	PRV	Jacqueline Little	1987-12-24	—	4069434164	8051 Camelback Rd, Eden Prairie, MN, 55303	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-24511	PRV	Lawrence S Nichols	1941-03-26	UHC-23434-16	5985970939	2895 Canyon Rd, Las Vegas, NV, 89183	0.78	Name re-cased Phone reformatted State code upper-cased ZIP+4 trimmed+1 more
PRV-23226	PRV	Brittany F Munoz	1948-04-17	—	7228508677	1220 Desert Sky Blvd, Houston, TX, 77015	0.78	Date of birth reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
PRV-26672	PRV	Arthur Ryan	1964-06-17	—	6007025020	2777 Oak St, Tampa, FL, 33672	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-21352	PRV	Olivia F Mendoza	1950-08-20	—	3092677353	5633 Willow Ct, Mesa, AZ, 85279	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-23747	PRV	Melissa Gonzalez	1975-01-07	UHC-79439-98	4406958139	4070 Union St, Jacksonville, FL, 32256	0.78	Phone reformatted Member ID reformatted City re-cased ZIP+4 trimmed+1 more
PRV-25841	PRV	Olivia Arnold	1940-05-23	—	8006046003	824 Forest Ave, Plano, TX, 75049	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-20090	PRV	Philip Le	1980-02-05	—	4016238117	6510 Pine Dr, Glendale, AZ, 85331	0.78	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed+1 more
PRV-25774	PRV	Wei Woods	2003-02-07	—	6022887750	4294 Valley View Dr, San Diego, CA, 92162	0.78	Name re-cased Phone reformatted City re-cased ZIP+4 trimmed+1 more
PRV-25373	PRV	Logan Richardson	1981-11-11	UHC-44547-13	3566552589	2481 Apache Blvd, Las Vegas, NV, 89167	0.78	Name re-cased Date of birth reformatted State code upper-cased ZIP+4 trimmed+1 more
PRV-25431	PRV	Pamela Bryant	1960-03-17	—	6159289513	609 Lake View Rd, Los Angeles, CA, 90019	0.78	Phone reformatted ZIP+4 trimmed Email lower-cased Whitespace trimmed+1 more
PRV-29509	PRV	Michael Z Baker	1986-06-09	UHC-59475-73	6973352647	9543 Ocean Ave, Tempe, AZ, 85202	0.78	Date of birth reformatted State code upper-cased ZIP+4 trimmed Whitespace trimmed+1 more
PRV-22495	PRV	Ralph Carpenter	1967-06-11	—	7894909266	9818 Baseline Rd, Jacksonville, FL, 32236	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-26443	PRV	Jose Weber	1983-03-07	—	5296399108	7632 Mesa Dr, Tempe, AZ, 85255	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-28953	PRV	Mateo K Patel	1961-03-05	UHC-36080-99	5076092351	8109 Canyon Rd, San Antonio, TX, 78253	0.78	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
PRV-26343	PRV	Joe G Stewart	1953-02-11	UHC-21317-80	5262346068	286 Sage Ct, Los Angeles, CA, 90063	0.78	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
PRV-20918	PRV	Nancy N Brooks	2002-03-20	—	8553099739	4433 Ocean Ave, San Diego, CA, 92148	0.78	Date of birth reformatted Phone reformatted State code upper-cased ZIP+4 trimmed+1 more
PRV-27575	PRV	Brenda Wells	1961-07-12	UHC-70706-56	6507345717	5623 Maple Ave, Mesa, AZ, 85251	0.78	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
PRV-23618	PRV	Adam Gibson	1991-01-08	—	9115456638	7686 Sunset Blvd, Sacramento, CA, 95867	0.78	Name re-cased Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
PRV-25890	PRV	Adam Hughes	1974-04-05	—	7572253575	4667 Sunset Blvd, Sacramento, CA, 95821	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-22956	PRV	Kyle Dominguez	1954-02-12	UHC-43293-68	7332068412	2026 Elm St, Minneapolis, MN, 55438	0.78	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
PRV-20275	PRV	Wayne Diaz	1974-08-03	—	8103819715	7786 Highland Ave, Minneapolis, MN, 55484	0.78	Name re-cased Phone reformatted ZIP+4 trimmed Whitespace 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
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
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
PRV-29112	PRV	Brian Montgomery	1997-04-14	UHC-99370-99	2522811562	1387 Hillcrest Rd, Miami, FL, 33116	0.80	Phone reformatted City re-cased ZIP+4 trimmed Placeholder values cleared
PRV-26757	PRV	Rachel Daniels	1951-07-18	—	2017855360	6715 Cedar Ln, Glendale, AZ, 85312	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
PRV-25857	PRV	Joshua Walker	1948-12-24	—	7144119642	1765 Lincoln Way, Orlando, FL, 32806	0.80	City re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-25794	PRV	Victoria Howard	1961-09-20	UHC-87606-64	5888107099	9758 Oak St, San Diego, CA, 92142	0.80	City re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-27405	PRV	Denise Yang	1961-03-26	—	3574291332	1201 River Rd, Tucson, AZ, 85732	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
PRV-29042	PRV	Katherine Ellis	1945-08-02	—	3428365735	1385 Jefferson Ave, Eden Prairie, MN, 55322	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
PRV-26696	PRV	Edward Duncan	1961-06-25	UHC-59797-84	—	619 Market St, Denver, CO, 80280	0.80	Name re-cased Member ID reformatted ZIP+4 trimmed Placeholder values cleared
PRV-28608	PRV	Janet B Myers	1976-03-26	UHC-34234-73	3436329039	1433 Jefferson Ave, Jacksonville, FL, 32206	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-28609	PRV	Janet B Myers	1976-03-26	UHC-34234-73	3436329039	1433 Jefferson Ave, Jacksonville, FL, 32206	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-22080	PRV	Donna Garza	1997-09-22	—	3375663352	8852 Maple Ave, Columbus, OH, 43299	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-20238	PRV	Kenneth Stewart	1995-03-25	—	2322345091	2211 Mesa Dr, Denver, CO, 80273	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
PRV-22583	PRV	Ronald U Alvarez	1994-03-19	UHC-65432-23	7483421406	1061 Spring St, Fresno, CA, 93709	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
PRV-28473	PRV	Nicholas O King	1992-05-02	UHC-48082-65	—	2780 Oak St, San Antonio, TX, 78231	0.80	Date of birth reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-26888	PRV	Ana Foster	1989-09-08	—	3276168309	4119 Union St, Tempe, AZ, 85288	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-29171	PRV	Kyle Cook	2001-09-07	UHC-25023-44	—	9327 Broadway, Scottsdale, AZ, 85241	0.80	Address re-cased ZIP+4 trimmed Email lower-cased Placeholder values cleared
PRV-25683	PRV	Austin Murray	1944-07-18	—	—	6579 Washington St, Austin, TX, 78760	0.80	City re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared

815 rows, page 15 of 17Previous Next