About this Dataset

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.
Organization: State of Connecticut
Last updated: 2023-12-09T04:27:31.637202
Tags: connecticut-prescription-monitoring-program, drug-schedule, pmp, prescription-monitoring-program

Tables

Table 1

@usgov.state_of_connecticut_controlled_substance_prescription_a9d9d3c7.table_1

6.17 kB
39 rows
6 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "month" VARCHAR,
  "schedule_ii" BIGINT,
  "schedule_iii" BIGINT,
  "schedule_iv" BIGINT,
  "schedule_v" BIGINT
);