ct-gov/prescription-monitoring-program-schedule-iii-drug-9atc-gz9i
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 year ago
Indexed 11 months ago

Prescription Monitoring Program: Schedule III Drug Prescriptions Dispensed

This dataset includes the amount of Schedule III prescription drugs dispensed over a 3-month span. On the controlled substance Schedule II-V; Schedule III prescription drugs have a potential for abuse less than Schedule II prescription drugs and have a moderate to low physical dependence or high psychological dependence (DEA). Schedule III prescriptions include narcotics and non-narcotics. It only includes dispensations to CT residents reported to the CT Prescription Monitoring & Reporting System (CPMRS).

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-iii-drug-9atc-gz9i\".\"prescription_monitoring_program_schedule_iii_drug\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • prescription_monitoring_program_schedule_iii_drug
     
     
     
     
     
Upstream Metadata