ct-gov/prescription-monitoring-program-schedule-iv-drug-r6ge-6tdq
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 year ago
Indexed 11 months ago

Prescription Monitoring Program: Schedule IV Drug Prescriptions Dispensed

This dataset includes the amount of Schedule IV prescription drugs dispensed over a 3-month span, with the quarter ending March 2023. On the controlled substance Schedule II-V; Schedule IV prescription drugs have a low potential for abuse and low risk for dependence. Schedule IV drugs may be used for pain control. 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-iv-drug-r6ge-6tdq\".\"prescription_monitoring_program_schedule_iv_drug\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • prescription_monitoring_program_schedule_iv_drug
     
     
     
     
     
Upstream Metadata