Prescription Monitoring Program (PMP) Public Use Data

Washington’s PMP was created (RCW 70.225 (2007)) to improve patient care and to stop prescription drug misuse by collecting dispensing records for Schedule II, III, IV and V drugs, and by making the information available to medical providers and pharmacists as a patient care tool. Program rules, WAC 246-470, took effect August 27, 2011. The program started data collection from all dispensers October 7, 2011.

Data available here are de-identified, and exclude patient, prescriber, and dispenser related information.

Prescriptions excluded from PMP include those dispensed outside of WA State, those prescribed for less than or equal to 24 hours, those administered or given to a patient in the hospital, and those dispensed from a Department of Corrections pharmacy (unless an offender is released with a prescription), an Opioid Treatment Program, and some federally operated pharmacies (Indian Health Services and Veterans Affairs report voluntarily).

Further information on collection and management of PMP data at DOH can be found at www.doh.wa.gov/pmp/data.

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 \"wa-gov/prescription-monitoring-program-pmp-public-use-8y5c-ekcc\".\"prescription_monitoring_program_pmp_public_use\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.