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 “Street suffix standardised”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagStreet suffix standardisedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-29297	PRV	Samuel Richards	1984-02-14	—	2645453770	2173 Mountain View Dr, Phoenix, AZ, 85006	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-21744	PRV	Ethan Li	1947-07-13	UHC-48504-34	3232050702	2446 Mountain View Dr, Phoenix, AZ, 85064	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-21745	PRV	Ethan Li	1947-07-13	UHC-48504-34	3232050702	2446 Mountain View Dr, Phoenix, AZ, 85064	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-24874	PRV	Virginia Morgan	1998-09-03	UHC-03695-08	9238712495	337 Elm St, Mesa, AZ, 85252	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
PRV-20931	PRV	Tyler F Carroll	1955-07-23	—	4672936962	4135 Ocean Ave, Austin, TX, 78721	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared
PRV-24512	PRV	Peter Vasquez	1972-12-16	—	—	9389 Main St, Nashville, TN, 37200	0.80	Date of birth reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-21507	PRV	Marilyn Aguilar	1977-06-02	—	2763483797	3638 Bayshore Dr, Dallas, TX, 75200	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
PRV-26250	PRV	Jessica Guerrero	1953-09-21	UHC-43793-55	4625519389	747 Canyon Rd, Gilbert, AZ, 85223	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared
PRV-26219	PRV	Karen Nichols	1944-07-15	UHC-16586-71	9594802672	8450 Indian School Rd, Los Angeles, CA, 90035	0.80	Date of birth reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-21821	PRV	Camila Jimanez	1975-10-02	UHC-71123-92	3483648738	9655 Meadow Ln, Plano, TX, 75028	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
PRV-24312	PRV	Emily Matthews	1969-03-01	UHC-29986-98	—	7506 Indian School Rd, Houston, TX, 77060	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared
PRV-26702	PRV	Eric G Perkins	1999-11-21	—	5103145653	7227 Sunset Blvd, Tampa, FL, 33639	0.80	Date of birth reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-23344	PRV	Kimberly Webb	2001-10-11	UHC-74710-86	—	1437 Grand Ave, Nashville, TN, 37292	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
PRV-21916	PRV	Bobby Matthews	1973-05-04	UHC-97499-90	—	5402 Grand Ave, Tempe, AZ, 85253	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared
PRV-22751	PRV	Wayne W Bryant	1958-12-15	—	6444598544	7704 Jefferson Ave, Eden Prairie, MN, 55341	0.80	Date of birth reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-28920	PRV	Linda D Ross	1956-08-11	—	4494993190	3198 Sunset Blvd, San Antonio, TX, 78280	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-28921	PRV	Linda D Ross	1956-08-11	—	4494993190	3198 Sunset Blvd, San Antonio, TX, 78280	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-27931	PRV	Martha P Jenkins	1987-01-15	UHC-38108-73	—	8650 Apache Blvd, Sacramento, CA, 95821	0.80	Date of birth reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-26138	PRV	Daniel V Mendez	2000-12-08	—	—	7151 Highland Ave, Scottsdale, AZ, 85269	0.80	Date of birth reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-28386	PRV	Keith O Tran	1998-05-08	—	8122763352	8577 Highland Ave, Fresno, CA, 93722	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-28385	PRV	Keith O Tran	1998-05-08	—	8122763352	8577 Highland Ave, Fresno, CA, 93722	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-25179	PRV	Brittany M Kennedy	1981-03-19	UHC-32345-17	6388178975	7007 River Rd, Nashville, TN, 37259	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
PRV-28649	PRV	Gloria Lopez	1942-12-10	UHC-27080-04	6634113864	1893 Central Ave, Tempe, AZ, 85223	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-23176	PRV	Gabriel Ferguson	1942-03-27	UHC-41111-77	—	8354 River Rd, Plano, TX, 75087	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
PRV-22837	PRV	Deborah Berry	1940-01-16	—	5867850565	5487 Maple Ave, Houston, TX, 77008	0.80	Date of birth reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-28607	PRV	Jose Day	2004-10-04	UHC-65678-01	3284162887	3940 Desert Sky Blvd, Plano, TX, 75035	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-20996	PRV	Pamela Fuller	1946-11-06	UHC-53055-98	7728959546	3164 Hillcrest Rd, Gilbert, AZ, 85248	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-23283	PRV	Susan N Howard	1994-01-09	—	3035682945	9163 Willow Ct, Plano, TX, 75089	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared
PRV-27005	PRV	Benjamin Stephens	2000-09-03	UHC-97938-47	5797937196	7552 Sunset Blvd, Scottsdale, AZ, 85263	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared
PRV-24713	PRV	Timothy Robertson	1952-01-06	UHC-04478-97	4249515029	2331 Valley View Dr, Orlando, FL, 32820	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-22014	PRV	Arjun Martinez	1971-11-27	—	8075108929	1250 Union St, Scottsdale, AZ, 85272	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-26280	PRV	Maria Fissher	1979-01-17	UHC-18891-77	7403681565	5536 Washington St, Charlotte, NC, 28228	0.80	Member ID reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-23652	PRV	Justin Rodriguez	1981-01-25	—	2034768363	5750 Desert Sky Blvd, Dallas, TX, 75286	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-26075	PRV	Samantha I Torres	1954-08-20	UHC-71644-84	—	5874 Sunset Blvd, Austin, TX, 78717	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
PRV-29281	PRV	Denise Robertson	1947-09-05	UHC-42523-92	8068744904	6834 Market St, Tucson, AZ, 85763	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-23136	PRV	Ann Rios	2003-07-20	—	—	6732 Valley View Dr, Eden Prairie, MN, 55331	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared
PRV-22980	PRV	Kelley Samuel	1960-10-20	UHC-79157-57	5766972179	3674 Meadow Ln, Tempe, AZ, 85209	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-23452	PRV	Megna S Herrera	1991-02-23	—	—	4453 Indian School Rd, Denver, CO, 80228	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
PRV-28829	PRV	Joe Rojas	1982-01-06	—	8514202582	7841 Sage Ct, Phoenix, AZ, 85047	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared
PRV-25631	PRV	Kathy C Salazar	1961-02-05	UHC-01997-43	4529954335	9016 Ocean Ave, Fresno, CA, 93733	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-29039	PRV	Jessica Alvarez	1905-03-27	UHC-19484-62	—	976 Sunset Blvd, Gilbert, AZ, 85218	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared
PRV-24117	PRV	Raymond Banks	1966-04-28	—	—	3219 Grand Ave, Eden Prairie, MN, 55344	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
PRV-26369	PRV	Peter Furd	1991-10-23	—	—	9835 Pine Dr, Dallas, TX, 75263	0.80	Date of birth reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-23929	PRV	Richard R Boyd	2001-08-07	UHC-29020-28	9136960693	1939 Willow Ct, Austin, TX, 78742	0.80	Date of birth reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-26567	PRV	Juan Medina	1967-05-10	UHC-12396-73	3984514614	1799 Bayshore Dr, Los Angeles, CA, 90075	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
PRV-21531	PRV	Camila T Snyder	1993-06-09	—	—	3515 Willow Ct, Miami, FL, 33192	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared
PRV-20827	PRV	Dennis Gutierrez	1984-04-08	UHC-41524-39	9526327283	9635 Mountain View Dr, Seattle, WA, 98132	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
PRV-23766	PRV	Gabriel Perry	1957-04-25	UHC-42198-20	6486338621	2064 Baseline Rd, Denver, CO, 80297	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared
PRV-22760	PRV	Gerge Lawson	1998-11-03	UHC-33442-55	—	4710 Palm Dr, Mesa, AZ, 85293	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared
PRV-27421	PRV	Catherine V Day	1943-07-04	UHC-08875-72	—	5538 Grand Ave, Plano, TX, 75047	0.80	Date of birth reformatted Street suffix standardised Address re-cased Placeholder values cleared

5,405 rows, page 106 of 109Previous Next