OIDA Data Products

19,025,536 rows

Filter Results

Learn more about filtering (with SQL WHERE clauses, opens in new tab)"

Field name - column - rowid Date_of_Service Processing_Date NDC Quantity_Dispensed Days_Supply Pharmacy_REMS_ID Pharmacy_Name Prescriber_REMS_ID Prescriber_Last_Name New_Repeat Times_on_Subsys Proc_Rel SSP DM FSD Class ASD RM RD PDRP WAC_Revenue Field_Sales Unique_Rxer Unique_Rxer_by_WK Decile Month Strength Units Quarter Q_Rxer_Count Territory_Name Region_Name RSM SSP_Email RSM_Email Total_Rejected_Transactions Flag Flag_Count Patient_ID Region_Code IC Territory_Code Rx_Code Week_Code Status

Comparison operator - select - = != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

Value

Sort by Sort... Sort by rowid Sort by Date_of_Service Sort by Processing_Date Sort by NDC Sort by Quantity_Dispensed Sort by Days_Supply Sort by Pharmacy_REMS_ID Sort by Pharmacy_Name Sort by Prescriber_REMS_ID Sort by Prescriber_Last_Name Sort by New_Repeat Sort by Times_on_Subsys Sort by Proc_Rel Sort by SSP Sort by DM Sort by FSD Sort by Class Sort by ASD Sort by RM Sort by RD Sort by PDRP Sort by WAC_Revenue Sort by Field_Sales Sort by Unique_Rxer Sort by Unique_Rxer_by_WK Sort by Decile Sort by Month Sort by Strength Sort by Units Sort by Quarter Sort by Q_Rxer_Count Sort by Territory_Name Sort by Region_Name Sort by RSM Sort by SSP_Email Sort by RSM_Email Sort by Total_Rejected_Transactions Sort by Flag Sort by Flag_Count Sort by Patient_ID Sort by Region_Code Sort by IC Sort by Territory_Code Sort by Rx_Code Sort by Week_Code Sort by Status

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE "insys_authorized_rx" (
"Date_of_Service" TEXT,
  "Processing_Date" TEXT,
  "NDC" TEXT,
  "Quantity_Dispensed" INTEGER,
  "Days_Supply" INTEGER,
  "Pharmacy_REMS_ID" TEXT,
  "Pharmacy_Name" TEXT,
  "Prescriber_REMS_ID" TEXT,
  "Prescriber_Last_Name" TEXT,
  "New_Repeat" TEXT,
  "Times_on_Subsys" INTEGER,
  "Proc_Rel" TEXT,
  "SSP" TEXT,
  "DM" TEXT,
  "FSD" TEXT,
  "Class" TEXT,
  "ASD" TEXT,
  "RM" TEXT,
  "RD" TEXT,
  "PDRP" TEXT,
  "WAC_Revenue" REAL,
  "Field_Sales" REAL,
  "Unique_Rxer" REAL,
  "Unique_Rxer_by_WK" REAL,
  "Decile" TEXT,
  "Month" TEXT,
  "Strength" INTEGER,
  "Units" REAL,
  "Quarter" TEXT,
  "Q_Rxer_Count" REAL,
  "Territory_Name" TEXT,
  "Region_Name" TEXT,
  "RSM" TEXT,
  "SSP_Email" TEXT,
  "RSM_Email" TEXT,
  "Total_Rejected_Transactions" TEXT,
  "Flag" TEXT,
  "Flag_Count" INTEGER,
  "Patient_ID" INTEGER,
  "Region_Code" TEXT,
  "IC" TEXT,
  "Territory_Code" TEXT,
  "Rx_Code" TEXT,
  "Week_Code" TEXT,
  "Status" TEXT
);
CREATE INDEX ["insys_authorized_rx_Date_of_Service"] ON [insys_authorized_rx]("Date_of_Service");
CREATE INDEX ["insys_authorized_rx_Processing_Date"] ON [insys_authorized_rx]("Processing_Date");
CREATE INDEX ["insys_authorized_rx_Status"] ON [insys_authorized_rx]("Status");
CREATE INDEX ["insys_authorized_rx_Pharmacy_Name"] ON [insys_authorized_rx]("Pharmacy_Name");
CREATE INDEX ["insys_authorized_rx_SSP"] ON [insys_authorized_rx]("SSP");
CREATE INDEX ["insys_authorized_rx_RSM"] ON [insys_authorized_rx]("RSM");