OIDA Data Products

Mallinckrodt Prescriber Records

Introduction

This database consolidates 28,270 deduplicated spreadsheets from the Mallinckrodt Litigation Documents collection. The data contains provider-level information regarding the prescription volume of specific Mallinckrodt opioid products generated by each provider between 2012 and 2014. Spreadsheets were collected from "push reports" created internally by Mallinckrodt and sent to sales representatives for their quarterly provider targets for various products. The content from these spreadsheets was extracted and combined into:

• a provider summary table that includes details on the prescribers (corresponding to 82,554 unique prescriber codes)
• product-specific tables with details on sales volume by date for Duexis, Exalgo, Pennsaid, Sumavel, and Xartemis

Some providers appeared in multiple source spreadsheets and some only appear in one. Providers are listed more than once in the summary table if their prescriber number code, letter code, address, territory identifier, and/or PDRP code varied across source spreadsheets.

The data are compiled from an OIDA search for spreadsheets in the Mallinckrodt Collection (.xls, .xlsx, .csv, and .xslm files). After deduplicating the spreadsheets, a series of R program files was used to combine data from the 28,270 spreadsheets of a common form. A final R Markdown file was used to clean up the data for this dataset and generate the summary table and the first 100 rows of each product-specific tables. (To generate a full product-specific table, simply remove the slice() function in the code to generate that product’s table.)

The data could be used independently or combined with other data sources to examine questions such as:

• How did opioid prescribing vary across these providers?
• To what degree did prescribing change over time and among subgroups of providers?
• To what degree did individual prescribers interact with the pharmaceutical industry?
• How is such interaction related to antecedent and subsequent opioid prescribing?
• What is the association between local, state and federal opioid policies and the prescribing of these providers?

How to use this data

Filter, facet, and query the tables below. 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.

Browse and query the provider summary table (343,544 rows) Browse and query the Duexis table (246,585 rows) Browse and query the Exalgo table (1,381,365 rows) Browse and query the Pennsaid table (1,849,651 rows) Browse and query the Sumavel table (152,670 rows) Browse and query the Xartemis table (543,996 rows)

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.

SELECT substr(territory, -2) as state, COUNT(*) as count FROM prescribers WHERE territory NOT LIKE '%[0-9][0-9][0-9][0-9][0-9]' AND territory NOT LIKE '%redacted%PII%' AND length(territory) >= 2 GROUP BY state ORDER BY count DESC

Download the data files

Download zipped CSVs for all tables (301 MB): mnk_prescriber_records.zip

Download raw CSV for provider summary table (29 MB): prescribers.csv

Download raw CSV for Duexis table (100 MB): duexis_bydates.csv

Download raw CSV for Exalgo table (1.2 GB): exalgo_bydates.csv

Download raw CSV for Pennsaid table (1.8 GB): pennsaid_bydates.csv

Download raw CSV for Sumavel table (83 MB): sumavel_bydates.csv

Download raw CSV for Xartemis table (161 MB): xartemis_bydates.csv

Download SQLite DB containing all tables: mnk_prescriber_records.db

Dataset field descriptions

Provider Summary Table

This table summarizes where to find targeted providers across the product-specific tables.

Data Element	Data Type	Description	Sample Data
prescriber_number_code	Numeric	Numeric code identifying prescriber	"0000230"; "NA"
prescriber_name	Free Text	Last, First name of prescriber	"OVERSTREET, DONALD"; "*Redacted – PII"; "NA"
prescriber_letter_code	Controlled List	Unknown letter code associated with prescriber	"D"; "E"; "ED"; "EN"; "EP"; "EPX"; "ES"; "ESD"; "ESN"; "ESP"; "EX"; "N"; "NA"*; "P"; "PE"; "PX"; "S"; "SN"; "SP"; "X"; "XE"; "XP"; "XPE"
address	Free Text	Address for prescriber including street, city, and state	"7169 AL HIGHWAY 22 N, VALLEY GRANDE AL"; "NA"; "*Redacted – PII"
territory	Controlled List	Numeric code for territory with description	"20604 – TUSCALOOSA, AL"; "NA"; "*Redacted – PII"
PDRP	Free Text	Likely American Medical Association Physician Data Restriction Program statuses or addresses	"Opt Out"; "NA"; "*Redacted – PII"; "Validation Issue"; "WUNK (Whereabouts UNKnown)"; "Inactive"; "Prior Wunk"; "DIRJ"; "Questionable Account"; "Inappropriate Specialty"; "Retired"; "Pill Mill Physician"; "Special Case";
duexis	Controlled List	Identifies whether prescriber appears in this product-specific table	"n" or "y"
exalgo	Controlled List	Identifies whether prescriber appears in this product-specific table	"n" or "y"
pennsaid	Controlled List	Identifies whether prescriber appears in this product-specific table	"n" or "y"
sumavel	Controlled List	Identifies whether prescriber appears in this product-specific table	"n" or "y"
xartemis	Controlled List	Identifies whether prescriber appears in this product-specific table	"n" or "y"

Duexis, Exalgo, Pennsaid, Sumavel, and Xartemis Tables

For each product, there is a table containing one row per unique prescriber of the product. Each table includes columns that identify the providers with their name, address, and territory:

Data Type	Variable Name	Description	Examples
Free Text	prescriber	Prescriber last name, first name with associated unknown codes in parentheses and/or brackets	"AARON, CAREN (1958509)[PX]"
Free Text	address	Address for prescriber including street, city, and state	"319 HOSPITAL DRIVE, MARTINSVILLE VA"
Free Text	territory	Prescriber territory in "Code - City, State" format	"30201 - SALEM, VA"
Free Text	PDRP	Likely American Medical Association Physician Data Restriction Program statuses or addresses	Statuses include values such as: "NA", "Opt out", "Pill Mill Physician", "WUNK (Whereabouts UNKnown)", "Retired", "Questionable Account", "Inactive", "Special Case", and "DIRJ".

In addition, each product table also include columns with numeric values by date:

Data Type	Variable Name Format	Name Examples	Value Examples
Numeric	YYYY-MM-DD-[product]	"2013-03-29-sumavel", "2013-06-07-duexis", "2014-02-21-xartemis-xr"	"3.33", "1", "1.14"

"null" values were generated during spreadsheet synthesis to replace blank values.

Please Note: This table was created by the UCSF-JHU Opioid Industry Documents Archive (OIDA) as a public resource to aid in navigating the collections. While we have endeavored to provide accurate information based on the original data, this table may contain inadvertent errors. Users assume all risk of reliance on the information included on this site and we encourage users to examine the data in context with the documents available in the collection. We reserve the right to make changes and corrections to the table at any time, without notice. Please contact us at [email protected] with any questions.