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 based on OIDA documents. Researchers get a running start on exploring data, benefiting from our work to deduplicate and synthesize similar spreadsheets, provide a glossary of spreadsheet column names, and more. For tabular datasets, users can craft queries online and in some cases select a subset of the data for download, allowing them to interact with OIDA data before dedicating time and resources to a full analysis.
Drug Representative Visits
-
Sales Visits by Purdue in Massachusetts
A searchable table that represents over 150,000 visits by Purdue Pharma sales representatives to Massachusetts prescribers and pharmacists between 2007 and 2018.
-
Sales Visits by Mallinckrodt
A searchable table that represents over 1,000,000 visits by Mallinckrodt sales representatives to prescribers, distributors, and pharmacists around the United States from 2009 to 2015.
Prescription Claims
-
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.
Prescriber Activity
-
Mallinckrodt Prescriber Records
A summary table and product-specific tables of prescriptions of Mallinckrodt products stratified by targeted provider in the United States from 2012 to 2014.
Prescription Drug Shipments
-
Mallinckrodt Customer Orders
A searchable table of 92,918 customer orders for Mallinckrodt products arising from organizations such as wholesalers, distributors, and addiction treatment centers around the United States from early 2012 to 2017.
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 three large 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.