Prescription Monitoring Program: CT Prescribers who Prescribed Controlled Substances II - V

This provides the number of CT prescribers who prescribed a controlled substance drug schedule II -V. In CT, only prescribers who posses an active controlled substance registration (CSP) & DEA number are allowed to prescribed a controlled substance.

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-ct-prescribers-who-h67k-89a6\".\"prescription_monitoring_program_ct_prescribers_who\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.