Prescription Monitoring Program: Submission to Pharmacy

This dataset provides information on how schedule II - V prescriptions were sent to the pharmacy. It 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 are not included.

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-submission-to-n2ue-42bf\".\"prescription_monitoring_program_submission_to\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.