Insys Authorized Prescriptions Data

Introduction

These data represent 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.

The data are compiled from an OIDA search for spreadsheets in the Insys Litigation Collection (.xls, .xlsx, .csv, and .xslm files). After deduplicating the spreadsheets, an R Markdown file was used to select 13,857 spreadsheets related to authorized prescriptions and compile a single table of data from these documents. Columns from the source spreadsheets were combined only in cases where they were clearly equivalent (e.g., "TERR" and "TERR #" were combined and represent "Territory").

For additional information regarding how Insys used the REMS program, see the Insys Litigation Documents and the Relying on Whales and Repurposing REMS research guide.

How to use this data

Browse and query the complete dataset

Filter, facet, and query the full dataset (19,025,536 rows) in a table format. Download selected data as JSON or CSV. See the Dataset field descriptions for more information on how each field is used, and the Exploring a Database tutorial from Datasette for examples of how to browse tables and structure queries.

Explore with custom SQL queries

Create a subset of data using the example SQL query below, or write your own using the Dataset field descriptions. Generates a table of the first 1,000 rows in a new page. Download the subset in JSON or CSV.

Download the data files

Download Zipped CSV (693 MB): insys_authorized_rx.csv.zip

Download raw CSV (4.6 GB): insys_authorized_rx.csv

Download SQLite DB: insys_authorized_rx.db

Data at a glance

Dates of Service over plotted over time as a bar chart

Dataset field descriptions

Data Element Sample Data Description
ASD Joseph Rowan The name of the area sales director.
Class A Unknown.
Date_of_Service 2014-05-19 The date in which medical services were provided.
Days_Supply 30 How many days the supply of dispensed medication will last.
Decile D10-8 Unknown.
DM Jeff Pearlman The name of the district sales manager.
Field_Sales 5192.88 Unknown.
Flag F895D267082CC8D541666.71478009 Unknown.
Flag Count 1 Unknown.
FSD Jonathan Roper The name of the field sales director.
IC C Whether the prescription is an initial or continuation of a TIRF product.
Month 2012/10 Month of prescription
NDC 20482-0012-30 The National Drug Code, a universal product identifier for human drugs.
New_Repeat New Whether the prescription is new or a repeat.
Patient_ID 8768475 The unique anonymous identification number for the patient.
Pharmacy_Name LINDEN CARE The name of the dispensing pharmacy.
Pharmacy_REMS_ID 6924766 The REMS identification number for the dispensing pharmacy.
Prescriber_Last_Name Freedman The last name of the prescriber.
Prescriber_REMS_ID 6813851 The REMS identification number for the prescriber.
Proc_Rel 1551096 The internal universal identification number for prescribers, used to replace Prescriber ID system.
Processing_Date 2/11/2014 3:27:39 PM The date and time the prescription was processed.
Q_Rxer_Count 0.25 Unknown
Quantity_Dispensed 360 The number of units of medication dispensed.
Quarter 2013/Q2 Quarter of prescription
RD Sunrise Lee The name of the regional sales director.
Region_Name MID ATLANTIC Region of prescription.
RM Joseph Rowan The name of the regional manager.
RSM Brian Richmond The name of the regional sales manager.
RSM_Email [email protected] The email address of the regional sales manager.
Rx_Code 278330CF15249E63 The unique number for a medical prescription.
SSP Fernando Serrano The name of the specialty sales professional (sales representative).
SSP_Email [email protected] The email address of the special sales professional.
Status Paid The status of the prescription being paid or reversed.
Strength 800 Unknown.
Territory_Code NYC-104C The sales territory code.
Territory_Name Phoenix, AZ The sales territory name.
Times_on_Subsys 3 How many times Subsys has been prescribed to the patient, with “1” indicating a new prescription.
Total_Rejected_Transactions 41618 Unknown.
Unique_Rxer 0.25 Unknown.
Unique_Rxer_by_WK 1 Unknown.
Units 240 Units dispensed with prescription.
WAC_Revenue 15 Unknown.
Week_Code 5500285012 The unique identification number based on the prescriber’s American Osteopathic Association (AOA) or American Medical Assocation (AMA) number, or raw Drug Enforcement Agency (DEA) number with “X” prefix. Also known as “Prescriber ID.”