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-25093	PRV	Austin Hayes	1955-04-20	UHC-88677-05	7272455654	—	0.96	Phone reformatted Whitespace trimmed
PRV-24649	PRV	Ahmed Meyer	1981-10-19	UHC-94500-92	2555211062	5017 Canyon Rd, Miami, FL, 33130	0.96	Whitespace trimmed Placeholder values cleared
PRV-23429	PRV	Keith Mills	1969-12-07	UHC-47029-94	8646607825	278 Hillcrest Rd, Seattle, WA, 98106	0.96	Whitespace trimmed Placeholder values cleared
PRV-23184	PRV	Gloria Gordon	1952-09-04	—	3825752341	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-28078	PRV	Sofia L Mitchell	1969-05-08	UHC-25956-67	—	1194 Ridge Rd, Miami, FL, 33130	0.96	Whitespace trimmed Placeholder values cleared
PRV-26777	PRV	Jennifer Burton	1969-06-02	UHC-57790-33	9013974607	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-21231	PRV	Madison L Armstrong	1973-10-11	UHC-95183-75	9595884632	6205 Grand Ave, Plano, TX, 75071	0.96	Whitespace trimmed Placeholder values cleared
PRV-27659	PRV	Donna Q Raamirez	1978-07-06	—	3333590613	7362 Valley View Dr, Nashville, TN, 37254	0.96	Whitespace trimmed Placeholder values cleared
PRV-27294	PRV	Micelle Gutierrez	1998-01-28	—	—	6253 Grand Ave, Orlando, FL, 32870	0.96	Whitespace trimmed Placeholder values cleared
PRV-27411	PRV	Jose Matthews	1956-05-12	—	—	2912 Hillcrest Rd, Nashville, TN, 37210	0.96	Whitespace trimmed Placeholder values cleared
PRV-28236	PRV	Melissa Hawikns	1975-06-26	UHC-87638-87	—	9255 Harbor Blvd, Chandler, AZ, 85225	0.96	Whitespace trimmed Placeholder values cleared
PRV-24777	PRV	Allan Marquez	2020-02-16	UHC-88620-29	—	2304 Central Ave, Fresno, CA, 93742	0.96	Whitespace trimmed Placeholder values cleared
PRV-21770	PRV	Nicole Sullivan	2005-09-21	—	5616350718	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-20585	PRV	Jesse Payne	1945-07-15	—	8417245022	8235 Grand Ave, Nashville, TN, 37226	0.96	Whitespace trimmed Placeholder values cleared
PRV-25296	PRV	Roger Moreno	2005-01-25	—	—	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-23759	PRV	Ruth A Olson	1998-12-15	—	—	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-27777	PRV	Judy Delgado	2005-03-05	UHC-10925-71	—	9895 Jefferson Ave, Los Angeles, CA, 90053	0.96	Whitespace trimmed Placeholder values cleared
PRV-26081	PRV	Martha D Gardner	1944-05-13	—	2579837123	3192 Sunset Blvd, Gilbert, AZ, 85215	0.96	Whitespace trimmed Placeholder values cleared
PRV-23947	PRV	Carlos Le	1944-10-15	UHC-07359-80	5644707042	7655 Lake View Rd, Charlotte, NC, 28252	0.96	Whitespace trimmed Placeholder values cleared
PRV-22212	PRV	Steven Ellis	1944-12-28	—	—	6255 Park Pl, Jacksonville, FL, 32272	0.96	Whitespace trimmed Placeholder values cleared
PRV-28891	PRV	Santiago Palmer	2008-12-05	—	—	9709 Ridge Rd, Nashville, TN, 37258	0.96	Whitespace trimmed Placeholder values cleared
PRV-29399	PRV	Frank Owens	1979-11-28	UHC-66842-15	—	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-22441	PRV	Nathan I Olson	1977-08-18	—	8935064456	7553 Central Ave, Houston, TX, 77034	0.96	Whitespace trimmed Placeholder values cleared
PRV-28341	PRV	Tyler Washington	1941-08-11	UHC-77864-45	—	4828 Harbor Blvd, Sacramento, CA, 95892	0.96	Whitespace trimmed Placeholder values cleared
PRV-24062	PRV	Mariana Dixon	1975-06-01	—	—	9177 Main St, Scottsdale, AZ, 85289	0.96	Whitespace trimmed Placeholder values cleared
PRV-26683	PRV	Carlos Williamson	1977-07-01	UHC-61358-72	7075107974	5335 Highland Ave, Tempe, AZ, 85242	0.96	Whitespace trimmed Placeholder values cleared
PRV-27961	PRV	Shirley Powell	1949-02-22	—	—	7038 Main St, Sacramento, CA, 95859	0.96	Whitespace trimmed Placeholder values cleared
PRV-25085	PRV	Matt Williamson	1955-12-05	—	—	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-27456	PRV	Arthur P Carter	1953-09-20	—	—	7582 Washington St, Chandler, AZ, 85272	0.96	Whitespace trimmed Placeholder values cleared
PRV-23380	PRV	Laura Jensen	2003-06-19	—	7623889708	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-26914	PRV	Kevin Franklin	1971-02-24	UHC-60980-69	3168431466	4629 Willow Ct, Nashville, TN, 37284	0.96	Whitespace trimmed Placeholder values cleared
PRV-20804	PRV	Mark Ray	1947-03-25	UHC-24246-62	—	7803 Valley View Dr, Chandler, AZ, 85272	0.96	Whitespace trimmed Placeholder values cleared
PRV-28441	PRV	Heather Gardner	1996-07-12	UHC-30555-67	9399547647	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-23858	PRV	Carl Park	1963-01-14	—	6372563393	9297 Ocean Ave, Fresno, CA, 93741	0.96	Whitespace trimmed Placeholder values cleared
PRV-20488	PRV	Arjun Brown	1998-12-18	—	5637054767	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-22182	PRV	Bobby B Lee	1939-06-16	—	—	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-21666	PRV	Danyel Herrera	1975-02-05	UHC-83545-49	—	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-29140	PRV	Raymond C Freeman	1953-10-23	UHC-96816-88	4823648363	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-26783	PRV	Carlos Wilson	1996-10-09	UHC-72208-43	8044135074	4898 Lincoln Way, Eden Prairie, MN, 55339	0.96	Whitespace trimmed Placeholder values cleared
PRV-25188	PRV	Michelle Green	1975-07-07	—	—	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-25780	PRV	Matthw Kelley	1954-01-02	—	—	3283 Camelback Rd, Gilbert, AZ, 85261	0.96	Whitespace trimmed Placeholder values cleared
PRV-27117	PRV	Butler Willie	1978-04-20	—	7027638949	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-25975	PRV	Chritine Jimenez	2000-08-25	UHC-90658-11	4772797465	7936 Mountain View Dr, Eden Prairie, MN, 55324	0.96	Phone reformatted Whitespace trimmed
PRV-29419	PRV	Alan S Lynch	1959-07-02	—	—	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-22193	PRV	Shirley K Guerrero	1944-06-02	UHC-91027-43	9087148433	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-29559	PRV	Joe L Fields	1938-04-04	—	4577211227	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-26110	PRV	Michael Pierce	1992-03-04	—	3454479000	—	0.96	Whitespace trimmed Placeholder values cleared
PRV-22395	PRV	Andrea Coleman	1998-03-17	—	5059686150	7471 Washington St, Tempe, AZ, 85232	0.96	Whitespace trimmed Placeholder values cleared
PRV-27922	PRV	John Henry	2007-09-06	—	2535758250	5444 Union St, Mesa, AZ, 85214	0.96	Whitespace trimmed Placeholder values cleared
PRV-28625	PRV	Amber C Bishop	1950-04-19	UHC-03362-75	2052293003	5736 Sage Ct, Dallas, TX, 75236	0.96	Whitespace trimmed Placeholder values cleared

5,467 rows, page 109 of 110Previous Next