Prescription Monitoring Program: Most Common Prescriptions Dispensed to CT Residents

This dataset shows the most common prescriptions dispensed to CT residents. 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-most-common-77qx-u5bb\".\"prescription_monitoring_program_most_common\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.