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 “Whitespace trimmed”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagWhitespace trimmedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-21638	PRV	Laura Wong	1951-08-09	UHC-97344-52	4932447322	—	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-24392	PRV	Lori Elliott	1987-11-02	—	—	6009 Jefferson Ave, Denver, CO, 80248	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
PRV-29390	PRV	Adam Schmidt	1973-02-12	—	2649415444	3416 Palm Dr, Orlando, FL, 32827	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-20437	PRV	Joyce M Oliver	1983-05-10	—	6146840237	—	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-22220	PRV	Dennis Santos	1998-09-18	UHC-61268-54	7949523340	2748 Sage Ct, Tucson, AZ, 85743	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
PRV-25325	PRV	Roger F Arnold	2005-06-25	—	2925753939	—	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
PRV-25510	PRV	Ruth Palmer	1979-02-26	—	4838600196	—	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-23130	PRV	Samuel Marshall	2008-01-11	UHC-42128-45	—	—	0.94	Member ID reformatted Whitespace trimmed Placeholder values cleared
PRV-23277	PRV	Diana L Grant	1941-09-26	—	5215756151	—	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-20009	PRV	Vincent Oliver	1973-05-14	UHC-16577-40	7476422564	—	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
PRV-21324	PRV	Karen M Campbell	1967-07-12	—	3704473086	3013 Market St, San Antonio, TX, 78271	0.94	Email lower-cased Whitespace trimmed Placeholder values cleared
PRV-24956	PRV	Logan Green	1972-01-18	—	5134467856	32 Willow Ct, Chandler, AZ, 85266	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-23848	PRV	Joan Hamitlon	2005-09-16	—	—	9063 Central Ave, Columbus, OH, 43210	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
PRV-26136	PRV	Donna Sullivan	1998-01-01	UHC-84309-27	5786888092	7269 Broadway, Atlanta, GA, 30393	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
PRV-24842	PRV	Willie Moreno	1965-07-25	—	2845322100	—	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-20718	PRV	Christian Gomez	1984-11-27	—	4393874184	7865 Bayshore Dr, Austin, TX, 78733	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-22237	PRV	Daniel Wong	1981-07-10	UHC-33833-96	9673669916	4430 Meadow Ln, Jacksonville, FL, 32235	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-22726	PRV	Cynthia Elliott	2007-09-02	—	5113382771	9248 Sage Ct, San Antonio, TX, 78200	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-20255	PRV	Danielle Soto	1989-11-01	—	7109818547	8873 Sunset Blvd, Austin, TX, 78719	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
PRV-29530	PRV	Jacob Espinoza	1943-03-01	—	2186631113	9827 Lake View Rd, San Diego, CA, 92130	0.94	State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-24272	PRV	Ethan Robertson	2000-07-21	—	—	7669 Maple Ave, San Antonio, TX, 78202	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
PRV-20524	PRV	Dylan Kim	2007-06-24	UHC-93308-26	8946694364	7800 Elm St, Dallas, TX, 75249	0.94	State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-25545	PRV	Doris F Contreras	1982-06-15	UHC-33127-95	—	—	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
PRV-23095	PRV	Arjun Gutierrez	2005-12-12	UHC-35844-53	4976030816	1284 Canyon Rd, San Antonio, TX, 78238	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-22486	PRV	Kathryn Z Sandoval	1956-09-11	—	—	2498 Meadow Ln, Fresno, CA, 93760	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
PRV-20172	PRV	William Contreras	1988-08-12	UHC-82947-39	7972873843	—	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-22994	PRV	Patricia Hayes	1993-05-27	—	6194100159	6331 Hillcrest Rd, Sacramento, CA, 95813	0.94	State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-27896	PRV	Theresa P Gonzales	1981-09-04	UHC-23093-68	6407373218	4832 Lake View Rd, Gilbert, AZ, 85258	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-29580	PRV	Julie Ross	1939-11-28	UHC-35911-86	3829562824	—	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-22513	PRV	Samuel Payne	1976-12-25	UHC-26523-27	2856540118	3658 Highland Ave, Plano, TX, 75059	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
PRV-22235	PRV	Tom Mendoza	1964-11-16	UHC-87035-55	9103901758	—	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-22865	PRV	Ralph Johnson	1939-11-02	—	—	—	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
PRV-24763	PRV	Sean Allen	1967-11-11	—	6972892673	9243 Union St, Seattle, WA, 98183	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-24169	PRV	Adam Chapman	1985-07-19	—	5739619826	8709 Sage Ct, Eden Prairie, MN, 55360	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-28408	PRV	Diana B Mills	1972-11-19	UHC-74388-14	8517641826	7835 Broadway, Atlanta, GA, 30342	0.94	Address re-cased Whitespace trimmed Placeholder values cleared
PRV-25508	PRV	Danielle P Day	2005-07-09	UHC-21529-84	5927859778	—	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-29322	PRV	Mateo Simpson	1994-10-16	UHC-34741-79	2039855055	2939 Broadway, Las Vegas, NV, 89108	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
PRV-21423	PRV	Bruce P Ferguson	1978-04-10	UHC-65891-58	3388534845	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
PRV-27956	PRV	George I West	1993-12-28	—	4487562851	1635 Mountain View Dr, Mesa, AZ, 85219	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-24634	PRV	Lisa R Warren	1987-03-08	—	6814286068	1800 Lincoln Way, Austin, TX, 78786	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-29542	PRV	Carolyn Arnold	1961-01-28	UHC-76261-12	9093511403	5629 Broadway, Dallas, TX, 75254	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-26827	PRV	Jonathan V Santiago	1966-04-23	UHC-29521-60	4828510911	—	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-20784	PRV	Nick Q Simpson	1952-11-28	UHC-41916-76	4854792555	—	0.94	Date of birth reformatted Whitespace trimmed Placeholder values cleared
PRV-24440	PRV	Doris Ramirez	1991-07-19	—	4274431939	—	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-21650	PRV	Linda Garrett	1940-12-15	—	—	2449 Broadway, Gilbert, AZ, 85229	0.94	City re-cased Whitespace trimmed Placeholder values cleared
PRV-24651	PRV	Lucia W Russell	2001-11-13	—	6595649114	3497 Oak St, Tampa, FL, 33652	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-24080	PRV	Mei Q Lane	1963-07-23	—	2832281350	6232 Hillcrest Rd, Las Vegas, NV, 89186	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-24515	PRV	Brandon G Rivera	1991-04-07	—	7735521965	5041 Jefferson Ave, Glendale, AZ, 85328	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-26612	PRV	Kyle Q Castillo	1959-12-21	—	6406022389	4313 Grand Ave, Tempe, AZ, 85299	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-22126	PRV	Janet Boyd	1976-01-03	—	7848160075	711 Desert Sky Blvd, Nashville, TN, 37271	0.94	Phone reformatted Whitespace trimmed Placeholder values cleared

5,467 rows, page 106 of 110Previous Next