MEPS_datasets_PharmShed

Published: 24 September 2026| Version 1 | DOI: 10.17632/wfmjbyjmk2.1
Contributors:
Vanessa Maybruck,
,
,
,
,

Description

Data downloaded from the Medical Expenditure Panel Survey for years 2014, 2016, 2018, 2020, 2021, and 2022. Data are derived from the Prescribed Medicines Files and the Full Year Consolidated Data Files. All data have been converted from .ssp or .xlsx files to .txt files. The original data source can be found here: https://meps.ahrq.gov/mepsweb/data_stats/download_data_files.jsp. Data are associated with this GitHub repository: https://github.com/UCBoulder/SewerSocial. A research article is under review for this work as well. It will be linked here upon publication.

Files

Steps to reproduce

1) Visit https://meps.ahrq.gov/mepsweb/data_stats/download_data_files.jsp 2) Download the SAS transport format data zip files for 2014 and 2016 under Household Full Year Consolidated Data Files. Under Household Event Files, download the SAS transport format data zip files for 2014 and 2016 Prescribed Medicines Files. For both the Household Full Year Consolidated Data Files and Household Event Files for 2018, 2020, 2021, and 2022, download the XLSX format zip file. 3) Use the meps_scraper.R file from https://github.com/UCBoulder/SewerSocial to convert the ssp files to txt files. Use Excel to convert the xlsx files to txt files. 4) Zip these files together into a zip file and refer to https://github.com/UCBoulder/SewerSocial and associated paper (forthcoming) for the use cases for these files for the PharmShed model.

Institutions

Categories

Municipal Wastewater Reuse, Trace Pharmaceutical, Applied Machine Learning

Funders

Licence