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 “Two-digit birth year”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagTwo-digit birth yearClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-29512	PRV	Amanda Bennett	2004-01-08	UHC-35446-77	4827629839	6065 Union St, Columbus, OH, 43251	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-21050	PRV	Diane Y Robinson	1940-05-24	—	4563358471	6707 Spring St, Orlando, FL, 32806	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
PRV-20433	PRV	Andrea Russell	1985-03-04	—	—	9061 Ocean Ave, Houston, TX, 77080	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
PRV-27487	PRV	Riick Jenkins	1953-09-25	—	4009793863	1374 Forest Ave, Austin, TX, 78715	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-22386	PRV	Kimberly Young	1974-07-18	—	3612186867	5824 Washington St, Mesa, AZ, 85291	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
PRV-21223	PRV	Camila Delgado	1975-06-05	UHC-77210-26	8896251986	4527 Desert Sky Blvd, Glendale, AZ, 85301	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
PRV-28176	PRV	Randy R Vazqquez	1960-06-15	UHC-86837-23	6365778967	9686 Lake View Rd, Austin, TX, 78792	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-24656	PRV	Kathryn Ortega	2002-07-27	—	9828990969	1848 Main St, Atlanta, GA, 30307	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
PRV-21505	PRV	Barbara Silva	1965-04-05	—	3364136039	7394 Valley View Dr, Austin, TX, 78781	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-27116	PRV	George Estrada	1998-05-24	—	2219716731	958 Church St, Tempe, AZ	0.64	Two-digit birth year Phone reformatted City re-cased ZIP missing+2 more
PRV-27454	PRV	Timothy Hicks	1997-03-13	UHC-44481-21	7662384445	—	0.64	Name split from “Last, First”Two-digit birth year Phone reformatted Email lower-cased+2 more
PRV-24404	PRV	Laura Stone	1995-02-17	—	8614098541	9078 Canyon Rd, Tampa, FL, 33658	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
PRV-23250	PRV	Mark Powell	1998-09-12	UHC-33325-83	2834216239	9187 Ocean Ave, Plano, TX, 75022	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-26172	PRV	Brenda Jenkins	1998-06-28	—	4452347436	8124 Ridge Rd, Las Vegas, NV, 89173	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-26128	PRV	Andrew Bradley	1951-04-22	UHC-41862-45	8902605677	9405 Washington St, Tempe, AZ, 85205	0.64	Two-digit birth year Street suffix standardised Address re-cased City re-cased+2 more
PRV-25121	PRV	Brittany Aguilar	2000-11-16	UHC-06610-34	7482644177	4574 Willow Ct, Gilbert, AZ, 85208	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
PRV-23533	PRV	Katherine U Howell	2006-04-08	UHC-24751-04	7366408835	6115 Indian School Rd, Los Angeles, CA, 90004	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-21988	PRV	Maria Robinson	1962-12-03	—	—	717 Grand Ave, Columbus, OH, 43281	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-26639	PRV	Christian Peterson	1969-06-14	—	—	2683 Indian School Rd, Eden Prairie, MN, 55358	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-27880	PRV	Samantha Marshall	2002-11-04	UHC-35254-25	5387852236	1627 Broadway, Minneapolis, MN, 55490	0.66	Name split from “Last, First”Two-digit birth year Phone reformatted Address re-cased+1 more
PRV-26255	PRV	Martha Sullivan	2007-02-09	UHC-67909-78	9766875087	4612 Valley View Dr, Denver, CO, 80254	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-23471	PRV	Josh Sanders	1952-06-07	—	4738258178	9202 Hillcrest Rd, Tempe, AZ, 85217	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
PRV-21306	PRV	Sofia Luna	1995-01-17	UHC-09907-30	5195937770	4207 Cedar Ln, Dallas, TX, 75249	0.66	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+1 more
PRV-27825	PRV	Adam T Singh	1948-02-03	—	—	—	0.66	Middle initial moved out of first name Two-digit birth year Email lower-cased Whitespace trimmed+1 more
PRV-26079	PRV	Terry Ford	1994-10-01	—	7027235915	—	0.66	Two-digit birth year Phone reformatted Gender normalised Whitespace trimmed+1 more
PRV-23046	PRV	Jsesica Y Matthews	1962-01-06	—	7459959603	938 Park Pl, Chandler, AZ, 85206	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-22178	PRV	Jordan Harris	1951-12-25	UHC-98759-35	—	1233 Forest Ave, Las Vegas, NV, 89120	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
PRV-24280	PRV	Joshua Ford	1972-09-26	UHC-98156-24	4774364619	7167 Camelback Rd, Tampa, FL, 33641	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-22512	PRV	Madison Patel	2000-01-10	UHC-54352-44	8457345964	4495 Union St, Glendale, AZ, 85390	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-26743	PRV	Tyler Davis	1980-07-28	—	3612890257	3924 Bayshore Dr, Nashville, TN, 37267	0.66	Two-digit birth year Phone reformatted Gender normalised Whitespace trimmed+1 more
PRV-21892	PRV	Albert Q Kennedy	1945-12-05	UHC-89191-01	2908392311	—	0.66	Middle initial moved out of first name Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-24252	PRV	Dorothy Taylor	1989-04-01	—	2773667436	3562 Meadow Ln, Gilbert, AZ, 85248	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-22107	PRV	Dylan Watkins	2007-10-27	UHC-44967-83	—	343 Bayshore Dr, Seattle, WA, 98191	0.66	Two-digit birth year Street suffix standardised Address re-cased Email lower-cased+1 more
PRV-21068	PRV	Michelle Richards	1944-03-15	—	3858035714	7612 Union St, San Diego, CA, 92188	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-24988	PRV	Jeffrey Q Mendzoa	1965-08-12	UHC-92808-15	6374715196	3159 Canyon Rd, Dallas, TX, 75221	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
PRV-22140	PRV	Lauren Howard	2002-10-01	UHC-36100-80	9186796560	5084 River Rd, Gilbert, AZ, 85251	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-27800	PRV	Gerald K Robertson	1945-09-20	UHC-52253-14	—	2789 Palm Dr, Phoenix, AZ	0.66	Two-digit birth year Member ID reformatted ZIP missing Whitespace trimmed+1 more
PRV-22055	PRV	Donna B Padilla	1951-10-28	—	—	6322 Bayshore Dr, Sacramento, CA, 95875	0.66	Two-digit birth year Street suffix standardised Address re-cased Email lower-cased+1 more
PRV-24217	PRV	Jordan Warren	1997-06-16	UHC-42873-90	2835405830	6339 Harbor Blvd, Fresno, CA, 93779	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-24855	PRV	Denise E Hamilton	1988-06-25	—	7014016989	9833 Sage Ct, Minneapolis, MN, 55441	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-22719	PRV	Scott B Johnston	1991-06-01	—	—	8261 Pine Dr, San Diego, CA, 92181	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
PRV-27372	PRV	Paul G Luna	1974-05-11	UHC-71549-96	9529945118	9143 Union St, Glendale, AZ, 85333	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-24689	PRV	Jacob George	1957-06-02	—	—	1133 Lincoln Way, Eden Prairie, MN, 55383	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
PRV-22043	PRV	Emma Santiago	1995-03-17	UHC-20832-61	9627945315	—	0.66	Two-digit birth year Phone reformatted Gender normalised Whitespace trimmed+1 more
PRV-27562	PRV	Betty Lucas	1958-05-20	—	2923740103	—	0.66	Two-digit birth year Phone reformatted Gender normalised Whitespace trimmed+1 more
PRV-24972	PRV	Adam Li	1945-01-18	UHC-03793-43	—	51 Oak St, Houston, TX, 77050	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-27478	PRV	Christopher B Stephens	1988-09-21	UHC-69472-98	9219983447	5720 Valley View Dr, Gilbert, AZ, 85227	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-23436	PRV	Zachay Knight	1959-07-23	UHC-03561-97	—	6436 Grand Ave, Charlotte, NC, 28290	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-27016	PRV	Calros Jenzen	1988-06-19	—	—	5801 Canyon Rd Apt 38, Tucson, AZ, 85700	0.66	Name re-cased Two-digit birth year Unit split from street Whitespace trimmed+1 more
PRV-24090	PRV	Roy Chavez	1939-11-04	UHC-19953-03	2785855716	1429 Apache Blvd, Chandler, AZ, 85295	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more

690 rows, page 8 of 14Previous Next