Prescription Monitoring Program: Schedule II Drug Prescriptions Dispensed
This dataset includes the amount of Schedule II prescription drugs dispensed over a 3-month span. On the controlled substance Schedule II-V; Schedule II prescription drugs have a high potential for abuse, potentially leading to severe psychological or physical dependence. Schedule II drugs are narcotic pain medications and stimulants. This only includes dispensations to CT residents reported to the CT Prescription Monitoring & Reporting System (CPMRS).
Please note that although medical marijuana is a schedule II drug in CT, these dispensations will be reported out separately.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"ct-gov/prescription-monitoring-program-schedule-ii-drug-9bmy-iafh\".\"prescription_monitoring_program_schedule_ii_drug\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
