Prescription Monitoring Program: Controlled Substance Prescriptions by Drug Schedule

This dataset shows the number of prescriptions for each drug schedule category. This only includes dispensations to CT residents reported to the CT Prescription Monitoring & Reporting System (CPMRS).

Controlled substances are classified into 5 drug schedules which are determined by the U.S. Drug Enforcement Administration (DEA) and the CT Drug Control Division. The classification is based on a drug’s medical use and potential for misuse and dependency.

Please note that in mid-2022, NDC numbers for medical marijuana changed causing the majority of these dispensations to not be categorized as schedule II drugs during that time. Although medical marijuana is a schedule II drug in CT, these dispensations will be reported out separately beginning in 2023.

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-controlled-6ynn-uiqx\".\"prescription_monitoring_program_controlled\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.