Icon for Socrata external plugin
Open repository in Console
Updated 24 days ago
Indexed 3 hours ago

Prescription Monitoring Program: Average Days Supply and Daily Morphine Milligram Equivalent (MME)

This dataset shows the average days supply and daily morphine milligram equivalent (MME) of opioid prescription dispensed. The morphine milligram equivalent is an opioid dosage equivalent to morphine. This measurement is used to determine the abuse and overdose potential, and to set thresholds for prescribing and dispensing opioid pain relievers. The lowest effective dosage is set at less than 50 MME and the highest is greater than 90 MME.

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" \
{"sql": "
    SELECT *
    FROM \"ct-gov/prescription-monitoring-program-average-days-izkh-zk6p\".\"prescription_monitoring_program_average_days\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • prescription_monitoring_program_average_days
Upstream Metadata