This project explores the rise of mental health challenges in the state of Massachusetts using public data sources and API automation. It aims to analyze trends in depression, suicide rates, behavioral health ER visits, and therapy access gaps β with a focus on delivering actionable insights for healthcare organizations, community leaders, and policy makers.
- Pull mental health data from public health APIs (CDC, Mass.gov, SAMHSA)
- Track trends over time: suicide rates, ER visits, behavioral diagnoses
- Visualize insights via Power BI or Python dashboards
- Create a weekly data pull and alert automation process
- Provide healthcare stakeholders with digestible summaries
| Tool | Purpose |
|---|---|
Python |
API data fetch, transformation, alert scripts |
Postman |
API testing and endpoint documentation |
Pandas |
Data cleaning and aggregation |
Matplotlib / Seaborn |
Exploratory visualizations |
Power BI |
Final interactive dashboard |
Mass.gov, CDC, SAMHSA APIs |
Public data sources |
- Connect to public health API(s) with Python or Postman
- Fetch & clean mental health statistics (e.g., ER visits, suicide data)
- Analyze and extract insights using Python
- Visualize patterns with Jupyter Notebook or Power BI
- [Optional] Trigger weekly digest alert (email, Slack, or report)
mental-health-insights/
βββ README.md
βββ data/
β βββ raw/ # Raw files (CSV, JSON, etc.)
β βββ cleaned/ # Pre-processed or filtered data
βββ scripts/
β βββ fetch_data.py # Grabs latest mental health data from API
β βββ summarize_trends.py # Extracts trends from the dataset
β βββ alert_trigger.py # Sends weekly summary (Slack/email)
βββ postman/
β βββ mass-public-health-api.postman_collection.json
βββ visuals/
β βββ screenshots/ # Static charts or dashboard snippets
βββ dashboard/
β βββ MA-MentalHealth.pbix # Power BI dashboard file (optional)
---
## π Sample Insights Tracked
- Suicide rates by age group and Massachusetts county
- Behavioral health emergency room visits
- Depression diagnosis trends in youth (ages 12β17) and adults
- Therapy provider shortages and wait time averages
- Year-over-year trend comparison (2020β2024)
---
## π Why This Matters
Mental health needs in Massachusetts β and across the U.S. β have spiked post-pandemic. Communities need tools that highlight vulnerable populations, overwhelmed systems, and where to allocate resources. This dashboard helps support that mission using data and automation.
---
## π Status
- β
Project initialized
- π‘ Public API research and data pipeline in development
- π Dashboard + alert automation under construction
---
## π« Contact
**Created by:** Wilfredo Rodriguez
[LinkedIn](https://www.linkedin.com/in/wil-rodriguez) | [Email](mailto:wilrod38@gmail.com)
> βBuild with purpose. Lead with clarity. Secure and automate what matters.β