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-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-25566	PRV	Willie Walsh	1986-02-01	—	5423626204	408 Sage Ct, Scottsdale, AZ, 85249	0.80	Phone reformatted Gender normalised Whitespace trimmed 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-25538	PRV	Carl Burke	1952-04-12	—	2152580897	9767 Willow Ct, Minneapolis, MN, 55464	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-22832	PRV	Gabriel Wagner	1959-04-13	—	4998731225	—	0.80	Email lower-cased Gender normalised Whitespace trimmed Placeholder values cleared
PRV-23951	PRV	Sandra Williamson	1981-10-08	UHC-46877-79	4939425136	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
PRV-22116	PRV	Logan Lane	1953-01-13	UHC-29585-43	2334738561	9736 Sunset Blvd, Tampa, FL, 33664	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
PRV-24957	PRV	Alex Ross	1957-08-23	—	9546289856	2466 Harbor Blvd, Seattle, WA, 98176	0.80	Date of birth reformatted Gender normalised Whitespace trimmed Placeholder values cleared
PRV-20066	PRV	Austin Stone	1949-11-17	—	4625530574	4169 Jefferson Ave Apt 22, Chandler, AZ, 85252	0.80	Name re-cased Unit split from street Whitespace trimmed Placeholder values cleared
PRV-25322	PRV	Kvein Cunningham	1962-09-09	—	2608973093	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-26658	PRV	Timothy Phillips	2005-07-25	UHC-10844-40	3038615081	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
PRV-22254	PRV	Logan R Burton	—	—	3522731320	9374 Canyon Rd, Houston, TX, 77017	0.80	Date of birth missing Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-22253	PRV	Logan R Burton	—	—	3522731320	9374 Canyon Rd, Houston, TX, 77017	0.80	Date of birth missing Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-26760	PRV	Peter Johnson	1978-09-24	—	2335824895	1545 Spring St, San Diego, CA	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
PRV-25162	PRV	Robert Soto	1978-02-19	—	—	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
PRV-20098	PRV	Eric Sims	1947-06-04	UHC-69655-07	2535772240	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-26551	PRV	Sean Yang	1978-12-20	—	6989019021	7871 Desert Sky Blvd, Miami, FL, 33194	0.80	Name re-cased State name converted to code Whitespace trimmed 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-24351	PRV	Austin Wood	1985-10-06	UHC-01868-34	—	5714 Cedar Ln, Atlanta, GA, 30356	0.80	Name re-cased Phone missing area code Whitespace trimmed Placeholder values cleared
PRV-24638	PRV	Diego Jimenez	1957-09-14	—	7204520066	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
PRV-24639	PRV	Diego Jimenez	1957-09-14	—	7204520066	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
PRV-22869	PRV	Tyler Bradley	1984-12-11	—	5572847149	3905 Cedar Ln, Seattle, WA, 98178	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-27045	PRV	Betty C Rose	1945-03-03	UHC-74182-23	6003562475	8135 Central Ave, Columbus, OH, 43210	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
PRV-24833	PRV	Luis B Simmons	2003-04-13	UHC-91105-47	9167153948	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed 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-29448	PRV	Benjamin Walker	1995-12-12	UHC-70830-99	5879180816	4431 Union St, Jacksonville, FL, 32254	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-29543	PRV	Catherine L Bennett	1980-01-12	UHC-58898-70	2587124462	939 Ocean Ave, Austin, TX, 78790	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-26011	PRV	Paul Rilye	1973-02-14	—	2275951424	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
PRV-21385	PRV	Albert Griffin	1953-03-15	—	9378180044	2971 Canyon Rd, Minneapolis, MN, 55498	0.80	Phone reformatted Gender normalised Whitespace trimmed 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-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-28958	PRV	Edward A Hunt	1999-06-24	UHC-76455-82	9463364219	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
PRV-26745	PRV	Kyle V Butler	1991-11-28	UHC-96998-42	5079532266	1483 Canyon Rd, Charlotte, NC, 28268	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-25500	PRV	Ryna L Hernandez	1959-01-19	—	5727094583	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-24680	PRV	Lisa Y Gray	2004-05-26	UHC-96835-03	5925444149	1231 Hillcrest Rd, Chandler, AZ, 85212	0.80	Name re-cased State name converted to code Whitespace trimmed Placeholder values cleared
PRV-28213	PRV	Jesse Q Chapman	1968-06-27	—	6225244840	2417 Willow Ct, Denver, CO, 80227	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-21191	PRV	Marcus Little	2001-03-28	UHC-92454-63	8725841589	9687 Ridge Rd, Gilbert, AZ, 85266	0.80	City re-cased State name converted to code Whitespace trimmed Placeholder values cleared
PRV-20630	PRV	Luis Sullivan	1943-02-09	UHC-42957-58	2826340299	2265 Maple Ave, Los Angeles, CA, 90010	0.80	Two-digit birth year City re-cased Email lower-cased Whitespace trimmed
PRV-27839	PRV	Theresa Rios	2008-07-20	UHC-59751-66	—	3083 Sage Ct, Houston, TX, 77063	0.80	Name re-cased Two-digit birth year Whitespace trimmed Placeholder values cleared
PRV-24499	PRV	Sean Meyer	1949-11-03	—	4655735390	158 Mesa Dr, Tucson, AZ, 85781	0.80	Name re-cased Two-digit birth year Whitespace trimmed Placeholder values cleared
PRV-21760	PRV	Ryan Le	1979-11-28	—	2245858486	9613 Broadway, Seattle, WA, 98100	0.80	Two-digit birth year Phone reformatted Whitespace trimmed 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-23369	PRV	Grace Guzman	1982-12-19	UHC-39682-17	7566431855	3690 Central Ave Apt 11, San Diego, CA, 92192	0.80	Phone reformatted Unit split from street Whitespace trimmed Placeholder values cleared
PRV-21494	PRV	Emma O Red	1991-06-07	—	—	161 Desert Sky Blvd, Charlotte, NC, 28294	0.80	Name re-cased State name converted to code Whitespace trimmed Placeholder values cleared
PRV-28427	PRV	Virginia Bowman	1957-09-20	—	3187669881	5826 Hillcrest Rd, Atlanta, GA, 30346	0.80	Phone reformatted Gender normalised Whitespace trimmed 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-20779	PRV	Robert I Hicks	1987-12-14	UHC-88936-39	7525024330	9867 Park Pl, Houston, TX	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
PRV-28880	PRV	Sofia Bowman	1964-11-20	UHC-32544-49	—	3843 Baseline Rd, Scottsdale, AZ, 85229	0.80	Street suffix standardised Address re-cased Whitespace trimmed Placeholder values cleared

5,467 rows, page 85 of 110Previous Next