I believe this is from the socrata site. But this set from Cincinnati Open Data project, has incident fire department response of EMS. The text field is open, but includes drug-related descriptions.
Cincinnati Fire Department Incident Data w/ EMS Type (ALS/BLS) | Open Data | Socrata
Numerous data sets and survey data are available from: https://datashare.nida.nih.gov/divisions/ctn
The main site for NIDA also includes numerous drug-related resources, including common data set elements from many departments
I discovered the following on the CDC website and am thinking that we could leverage some of the work and data sources already identified. It sounds like the goals are similar and I will do some digging and see what turns up.
Data-Driven Prevention Initiative (DDPI)
The newly created Prescription Drug Overdose: Data-Driven Prevention Initiative (DDPI) is awarding $18 million over a three-year project period to 13 states and the District of Columbia to support efforts to end the opioid overdose epidemic in the United States. This program will help states advance and evaluate their actions to address opioid misuse, abuse, and overdose. That includes increasing their ability to:
- Improve data collection and analysis around opioid misuse, abuse, and overdose;
- Develop strategies that impact behaviors driving prescription opioid dependence and abuse; and
- Work with communities to develop more comprehensive opioid overdose prevention programs.
Washington D.C. and 13 states—Alabama, Alaska, Arkansas, Georgia, Hawaii, Idaho, Kansas, Louisiana, Michigan, Minnesota, Montana, New Jersey, and South Dakota—were selected to receive the funds through a competitive application process.
These new investments are made possible with the over $70 million that Congress appropriated to CDC in fiscal year 2016. Overall in fiscal year 2016, CDC is investing over $50 million in state health departments in support of the agency’s overarching Overdose Prevention in States effort to address this public health crisis. As the opioid overdose epidemic evolves, CDC will continue to provide scientific expertise, enhance surveillance activities, and tailor resources to address states’ growing and changing needs.
Fairfield County, located southeast of Columbus, received a DOJ grant in 2013 to monitor prescription drug trends: Harold Rogers Prescription Drug Monitoring Grant - Fairfield County ADAMH
It appears that the county partnered with Brandeis University to develop a data driven approach to reducing drug abuse: Data Driven Multi-Disciplinary Approaches to Reducing Rx Drug Abuse Grants | The PDMP Training and Technical Assistance …
The results of the effort are published on the Fairfield County "Behavioral Health Indicator" website, which lists 81 factors in six categories related to drug abuse. Using embeded Tableau worksheets, anyone can look at data related to the 81 factors: Fairfield County ADAMH
In addition, the worksheets are published to the Tableau Public server, and can be viewed/downloaded: Tableau Public
It would be difficult to replicate the entire effort here, because some of the data are based on interviews with jail inmates and surveys. But it's interesting to see how they organized the data into categories for analysis and presentation, and it could be a roadmap for the TUG project.
CMS.gov makes public use files available on their website, including Part D (prescription drug coverage) data described as follows:
"The “Part D Prescriber Summary Table” (i.e., one record per NPI) has been updated to include distinct beneficiary counts, total claim counts and total drug costs for opioids, antibiotics, antipsychotics, and high-risk medications among the elderly. In addition, a prescriber enrollment status field has been added to indicate whether the prescriber is enrolled, not enrolled or opted out of the Medicare program."
This and other data sets are available at: Part D Prescriber Data CY 2014 - Centers for Medicare & Medicaid Services
Using this data set, it is possible to derive % of opioid scripts, cost, and per/patient statistics by prescriber/specialty/geography.
National Survey on Drug Use and Health 2015 (NSDUH-2015-DS0001)
Study Series details:
The National Survey on Drug Use and Health (NSDUH) series, formerly titled National Household Survey on Drug Abuse, is a major source of statistical information on the use of illicit drugs, alcohol, and tobacco and on mental health issues among members of the U.S. civilian, non-institutional population aged 12 or older. The survey tracks trends in specific substance use and mental illness measures and assesses the consequences of these conditions by examining mental and/or substance use disorders and treatment for these disorders.
Examples of uses of NSDUH data include the identification of groups at high risk for initiation of substance use and issues among those with co-occurring substance use disorders and mental illness.
NSDUH public-use data files are available for download in SAS, SPSS, STATA and ASCII formats, and online analysis with SDA. NSDUH restricted-use data files are available for online analysis with the R-DAS.
The NSDUH is sponsored by the Center for Behavioral Health Statistics and Quality (formerly Office of Applied Studies), Substance Abuse and Mental Health Services Administration. For more information, visit the NSDUH website.
National Governors Association has a list of data sources on page 30 of this PDF: https://www.nga.org/files/live/sites/NGA/files/pdf/2016/1607NGAOpioidRoadMap.pdf
Tableau Foundation is interested in potentially supporting a data-based opioid project in partnership with a state. We're thinking some of the lessons learned from our malaria project (Visualize No Malaria | A partnership with PATH, the Tableau Foundation, and you to make malaria history ) could help provide ideas for how to use data to fight the opioid epidemic in more active ways (versus simply analyzing historical data).
Let me know if you'd like to talk about how we might be able to partner with the TUG and the State of Ohio to pilot some ideas.
You can reach me at email@example.com.