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 missing”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP missingClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-26502	PRV	Sean U Tucker	1942-02-27	—	6769874210	4803 Canyon Rd, Minneapolis, MN	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-23441	PRV	Samantha T Welch	1970-08-20	UHC-81164-04	4308865183	3081 Jefferson Ave, San Antonio, TX	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-26325	PRV	Priya Stewart	1976-08-09	UHC-29329-49	4672770248	6977 Hillcrest Rd, Jacksonville, FL	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-27505	PRV	Andrew A Harper	1980-05-08	UHC-99041-25	9468199420	5722 Lincoln Way, Tempe, AZ	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-20654	PRV	Jamse Marshall	2006-09-03	UHC-35247-81	3546443991	2554 Willow Ct, San Antonio, TX	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
PRV-25720	PRV	Wei Hamilton	1938-05-27	—	—	4558 Cedar Ln, Plano, TX	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+2 more
PRV-26630	PRV	Larry Riley	1938-04-13	UHC-29158-66	3113969988	4797 Mountain View Dr, Orlando, FL	0.64	Name re-cased City re-cased ZIP missing Gender normalised+2 more
PRV-23789	PRV	Mary Robinson	2006-01-16	—	7643267621	7941 Valley View Dr, Mesa, AZ	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-23546	PRV	Nancy Gray	1941-07-06	—	3363845937	5749 Ridge Rd, Mesa, AZ	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP missing+2 more
PRV-23545	PRV	Nancy Gray	1941-07-06	—	3363845937	5749 Ridge Rd, Mesa, AZ	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP missing+2 more
PRV-21424	PRV	Austin Wong	1961-03-19	UHC-52819-86	7579956047	7229 Cedar Ln, Los Angeles, CA	0.64	Name re-cased Date of birth reformatted Phone reformatted State name converted to code+2 more
PRV-28745	PRV	Catherine R Larson	1971-12-20	—	6422852095	2721 Sunset Blvd, San Diego, CA	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+2 more
PRV-25109	PRV	Angela Watkins	1959-11-08	UHC-59656-73	3539147433	3595 Mountain View Dr, Jacksonville, FL	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-23328	PRV	Barbara Pena	2005-02-23	—	4433485397	2978 Church St, Atlanta, GA	0.64	Street suffix standardised Address re-cased State code upper-cased ZIP missing+2 more
PRV-23660	PRV	Olivia Dominguez	1977-08-09	—	4399614950	7574 Bayshore Dr, Scottsdale, AZ	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-26196	PRV	Nicole Snyder	1988-07-06	—	3302417673	6336 Spring St, San Antonio, TX	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-28813	PRV	Carol Warren	1952-07-21	—	7727283716	7040 Hillcrest Rd, Gilbert, AZ	0.64	Name re-cased Phone reformatted ZIP missing Gender normalised+2 more
PRV-25219	PRV	Arthur Gibson	1982-09-25	—	2933056159	6998 Cedar Ln, Austin, TX	0.64	Phone reformatted Street suffix standardised Address re-cased City 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-23481	PRV	Frances Y Carter	1961-01-06	UHC-52031-78	2495772154	2331 Lincoln Way, Charlotte, NC	0.64	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
PRV-22378	PRV	Logan Walsh	1984-05-12	UHC-23715-26	—	1129 Lake View Rd, Tucson, AZ	0.64	Name re-cased Date of birth reformatted ZIP missing Gender normalised+2 more
PRV-21989	PRV	Maria Robinson	1962-12-03	UHC-39058-94	2829200240	717 Grand Ave, Columbus, OH	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-20980	PRV	Armstrong Ryen	1961-12-15	UHC-91572-43	6582708039	608 Spring St, Tampa, FL	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-26893	PRV	Eugene C Padilla	2007-06-27	UHC-02340-28	5378633073	1804 Ridge Rd, Chandler, AZ	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP missing+2 more
PRV-22396	PRV	Helen Austin	2003-09-10	UHC-03615-98	5828197153	9204 Ridge Rd, Glendale, AZ	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+2 more
PRV-24445	PRV	Jacob Banks	1988-07-10	UHC-77320-90	4548488407	5849 Cedar Ln, Mesa, AZ	0.64	Street suffix standardised Address re-cased City re-cased ZIP missing+2 more
PRV-28352	PRV	Alexander Kennedy	1962-10-17	UHC-46150-15	2818668900	5630 Forest Ave, Miami, FL	0.64	Name split from “Last, First”Phone reformatted Member ID reformatted ZIP missing+2 more
PRV-20831	PRV	Tyler Crawford	1968-08-07	UHC-49693-64	7255015011	9252 Ridge Rd, Plano, TX	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP missing+2 more
PRV-24839	PRV	Samantha Graham	1950-02-18	—	3842804243	6339 Mountain View Dr, Glendale, AZ	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-27658	PRV	Lucia Alvarado	2005-01-16	—	6465784325	1364 Palm Dr, Jacksonville, FL	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP missing+2 more
PRV-25535	PRV	Gary Brown	1950-01-24	—	4588476731	5247 Jefferson Ave, Tucson, AZ	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-22959	PRV	Bobby Hart	1941-11-19	UHC-50494-13	9763259365	9401 Camelback Rd, Las Vegas, NV	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP missing+2 more
PRV-28390	PRV	Jnet L Howell	2005-03-11	—	—	9379 Willow Ct, Austin, TX	0.64	Street suffix standardised Address re-cased City re-cased ZIP missing+2 more
PRV-21804	PRV	Camila Webb	1977-10-18	UHC-57634-72	8864779404	4854 Bayshore Dr, Scottsdale, AZ	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
PRV-23516	PRV	Hiroshi Martinez	1946-08-27	—	3742149810	5606 Meadow Ln, Minneapolis, MN	0.66	Street suffix standardised Address re-cased City re-cased ZIP missing+1 more
PRV-29437	PRV	Diane P Perkins	1983-03-17	UHC-00538-27	5653158527	4580 Hillcrest Rd, Glendale, AZ	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
PRV-25280	PRV	Cheryl C Buutler	1972-02-27	—	8107993504	7407 Ocean Ave, Atlanta, GA	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
PRV-22693	PRV	Maria Y McDonald	1978-04-27	UHC-46308-89	2336136170	266 Mountain View Dr, San Antonio, TX	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
PRV-25669	PRV	Karen S Rivera	1984-05-22	—	6439595537	9144 Ridge Rd Apt 34, Fresno, CA	0.66	Date of birth reformatted Phone reformatted Unit split from street ZIP missing+1 more
PRV-27967	PRV	Marilyn Sullivn	1952-05-20	—	2748519508	5246 Desert Sky Blvd, Miami, FL	0.66	Name split from “Last, First”Date of birth reformatted ZIP missing Whitespace trimmed+1 more
PRV-29136	PRV	Ashley Diaz	1976-12-18	UHC-49500-48	7967096069	6737 Oak St, Minneapolis, MN	0.66	Name re-cased ZIP missing Gender normalised Whitespace trimmed+1 more
PRV-20505	PRV	Amy Castillo	1959-02-15	UHC-48609-92	—	3513 Lincoln Way, Scottsdale, AZ	0.66	Date of birth reformatted State name converted to code ZIP missing Whitespace trimmed+1 more
PRV-23571	PRV	Deborah Gilbert	1966-05-12	—	—	5353 Church St, Minneapolis, MN	0.66	Date of birth reformatted ZIP missing Gender normalised Whitespace trimmed+1 more
PRV-24207	PRV	Anna D Park	1983-12-27	UHC-82241-54	2906267195	68 Broadway, San Diego, CA	0.66	Middle initial moved out of first name Phone reformatted Member ID reformatted ZIP missing+1 more
PRV-20287	PRV	Kelly Carlson	1957-04-27	—	4959956984	2153 Canyon Rd, Nashville, TN	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
PRV-27003	PRV	Amy Warren	1940-12-08	—	7503852602	8408 Palm Dr # 631, Columbus, OH	0.66	Date of birth reformatted Unit split from street ZIP missing Whitespace trimmed+1 more
PRV-28402	PRV	Adam Z Baker	—	UHC-26096-08	7005334140	1209 Park Pl, Eden Prairie, MN	0.66	Date of birth unreadable Phone reformatted City re-cased ZIP missing+1 more
PRV-27844	PRV	Beth Rodriguez	1963-12-06	UHC-01963-18	2787150921	7374 Sage Ct, Tampa, FL	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
PRV-24253	PRV	Perry Nicole	1952-01-17	—	5883150375	7253 Ocean Ave, Tampa, FL	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
PRV-26372	PRV	Victoria Fields	1943-08-20	UHC-70359-74	6194885016	4522 Mesa Dr, Minneapolis, MN	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more

722 rows, page 10 of 15Previous Next