The cost and utilization data reported by Michigan’s Community Mental Health Service Providers (also known as the Section 904/404 report) has potential to be a beneficial tool in improving services for the populations served by the CMHs. Currently, this data is reported to the Michigan legislature and collected by the Michigan Department of Health and Human Services (MDHHS) via reporting by the CMHs. Given the ongoing changes to Michigan’s public health system, there is increasing utility in using data to understand current service use, cost trends and inconsistencies across the state for vulnerable populations.
The code provided here does the following:
- Compilation of individual .csv files into one master dataset
- Creation of new variables for grouping and sorting: Fiscal Year, PIHP
- Grouping of CPT/HCPCS codes into broader Service Groups to allow for filtering, sorting and aggregation.
- Standardization of unit variable to hours where possible, such that 1.00 = 1 hour
- Calculation of the following variables related to each distinct service code for analysis: Service cost as % of CMH Total Cost, Cost per 1,000 persons served, Percent of beneficiaries receiving service
For details on the data elements in this dataset, please refer to the data dictionary.
You can read the code into R with a simple:
read.csv("https://raw.githubusercontent.com/j-hagedorn/open404/master/data/clean/df_404.csv")
...or import it into Excel using the same URL.
A file ready for analysis in either R or Python which preserves column classes and data types is available using the Apache 'feather' format:
feather::read_feather("https://raw.githubusercontent.com/j-hagedorn/open404/master/data/clean/df_404.feather")
This code is made available under a MIT License
The data is drawn from source tables collected by MDHHS, provided by the Behavioral Health and Developmental Disabilities Administration (BHDDA). Thanks to Kathleen Haines and Kasi Hunzinger for their ongoing help in obtaining data.