A catalog and interface for exploring data from opioid industry documents
Explore datasets derived from the Opioid Industry Documents Archive (OIDA), a digital archive co-created by the University of California, San Francisco and Johns Hopkins University containing millions of documents from the opioid industry that shed light on the root causes of the opioid crisis.
We created these datasets to provide access points for data analysis of OIDA documents. Researchers get a running start on exploring data, benefiting from our work to curate and deduplicate documents, provide a glossary of spreadsheet column names, and more. Users can craft queries online or select a subset of the data for download, allowing them to interact with OIDA data before dedicating time and resources to a full analysis.
Insys Authorized Prescriptions Data
A searchable table that represents 19,025,536 authorized prescriptions submitted through the FDA-required Transmucosal Immediate Release Fentanyl (TIRF) Risk Evaluation and Mitigation Strategy (REMS) program from 2012 to 2016 as recorded in documents found in the Insys Litigation Collection.
Authorized Prescriptions (insys_authorized_rx)
19,025,536 rows in 1 table
Purdue Sales Visit Data
A searchable table that represents over 150,000 visits by Purdue Pharma sales representatives to Massachusetts prescribers and pharmacists between 2007 and 2018.
Mallinckrodt Sales Visit Data
A searchable table that represents over 1,000,000 visits by Mallinckrodt sales representatives to prescribers, distributors, and pharmacists around the United States in 2009-2015.
Deduplicated Spreadsheets
OIDA contains hundreds of thousands of spreadsheets in native file formats. These spreadsheets cover a wide array of topics around the development, marketing, and sales of prescription opioids. The OIDA team has deduplicated spreadsheets from the hundreds of thousands of native format spreadsheet files across its three largest collections (Insys, Mallinckrodt and McKinsey) to save time for users who wish to work with these files.
Metadata and Images from the OIDA Image Collection
The OIDA Image Collection highlights images extracted from documents created by the opioid industry. Many of these documents were designed for internal company audiences and board members, while others were targeted to prescribers and consumers. The images provide insight into corporate practices that shaped the opioid crisis.