authorized_rx
Data at a glance
Download Zipped CSV (241 MB): auth_rx_combined.csv.zip
Download raw CSV (2.3 GB): auth_rx_combined.csv
Download SQLite DB: authorized_rx.db
auth_rx_combined
11,827,050 rows
How was it created?
The R Markdown file used to compile the table is available at [external link].
Columns from the source spreadsheets were combined only in cases where they were clearly equivalent (such as "TERR" and "TERR #").
Dataset field descriptions
|
Data
Element |
Sample Data |
Description |
|
# Times on Subsys |
3 |
How
many times Subsys has been prescribed to the
patient, with “1” indicating a new prescription. |
|
ASD |
Joseph
Rowan |
The name of the
area sales director. |
|
Class |
A |
Unknown. |
|
Date of
Service |
May 05, 2016 |
The date in which
medical services were provided. |
|
Days
Supplied |
30 |
How many days the
supply of dispensed medication will last. |
|
DM |
Jeff
Pearlman |
The name of the district
sales manager. |
|
FLAG |
F895D267082CC8D541666.71478009 |
Unknown.
|
|
FLAG COUNTIF |
1 |
Unknown.
|
|
FSD |
Jonathan
Roper |
The name of the field
sales director. |
|
I/C |
C |
Whether
the prescription is an initial or continuation of a TIRF product. |
|
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 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. |
|
Quantity
Dispensed |
360 |
The number of units
of medication dispensed. |
|
RD |
Sunrise Lee |
The name of the regional
sales director. |
|
RM |
Joseph
Rowan |
The name of the regional
manager. |
|
RSM |
Brian
Richmond |
The name of the regional
sales manager. |
|
RSM Email |
The email address
of the regional sales manager. |
|
|
Rx # |
278330CF15249E63 |
The
unique number for a medical prescription. |
|
SSP |
Fernando
Serrano |
The name
of the specialty sales professional (sales representative). |
|
SSP Email |
The
email address of the special sales professional. |
|
|
Status |
Paid |
The status
of the prescription being paid or reversed. |
|
TERR # |
NYC-104C |
The
sales territory code. |
|
WK ID |
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.” |
For additional information
and documents on how Insys used
REMS data, see Relying on Whales and Repurposing REMS research guide.