Mental Health Continuity of Medication: 2014-2021

New York State is moving Medicaid behavioral health services from a fee-for-service system into Managed Care.

OMH/OASAS Medicaid Behavioral Health Measures were developed to help monitor the transition of mental health and substance use disorder services from a fee-for-service to behavioral managed care.

The MH Continuity of Medication dataset displays percentages of Medicaid discharges for members 6-64 years of age who were hospitalized in an inpatient setting with a primary diagnosis of mental illness that a prescription for a psychotropic medication was filled within 30 days of discharge.

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 \"ny-gov/mental-health-continuity-of-medication-20142021-f6xz-p4ni\".\"mental_health_continuity_of_medication_20142021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.