How villegasjv55/medicaid-access-monitor works
Medicaid Access Monitor turns public CMS data into validated monthly tables, analytical views, and operational recommendations. The principal user workflow is opening the Streamlit dashboard to explore national access, state rankings, Florida, and state comparisons. Separate deliverables include Excel reporting, a DuckDB query pack, a findings memo, and an explicitly simulated rollout plan. The README documents these capabilities; source excerpts confirm the cleaning outputs, dashboard data reads, and SQL runner inputs and outputs. Other workbook and document internals were not sampled.
Main entry points: clean Clean Monthly Tables · clean_data.py Cleaning Pipeline · app.py Interactive Dashboard · run_sql.py SQL Runner
Components 15
CMS Data
- CAA Metrics
data/raw/medicaid-chip-caa-reporting-metrics-long-table-october-2024-release.csv - PI Dataset
data/raw/pi-dataset-march-2026release.csv
Data Processing
- Cleaning Pipeline
python/clean_data.py - Clean Monthly Tables
data/clean - Quality and Reconciliation
python/clean_data.py - State Lookup
data/lookup/lookup_states.csv
Access Reporting
- Interactive Dashboard
dashboard/app.py - Excel Reporting
excel/Medicaid_Access_Reporting.xlsx - SQL Runner
python/run_sql.py - DuckDB Query Pack
sql/queries.sql - Query Results
sql/results
Operational Planning
- Findings Memo
docs/findings_memo.md - Rollout Simulation
simulation/rollout_plan.md - Executive Briefing
presentation/executive_briefing.pdf
Other components
- Analyst
Connections 18
- Analyst → Interactive Dashboard: explores access
README.md - CAA Metrics → Cleaning Pipeline: reads source
README.md - PI Dataset → Cleaning Pipeline: reads source
README.md - Cleaning Pipeline → Clean Monthly Tables: writes tables
python/clean_data.py - Cleaning Pipeline → Quality and Reconciliation: checks and reconciles
README.md - Clean Monthly Tables → Interactive Dashboard: loads and joins
dashboard/app.py - State Lookup → Interactive Dashboard: joins state details
dashboard/app.py - Clean Monthly Tables → SQL Runner: loads CSV views
python/run_sql.py - State Lookup → SQL Runner: loads CSV view
python/run_sql.py - DuckDB Query Pack → SQL Runner: runs queries
python/run_sql.py - SQL Runner → Query Results: writes results
python/run_sql.py - Clean Monthly Tables → Excel Reporting: reports on data
README.md - Interactive Dashboard → Analyst: shows comparisons
README.md - Excel Reporting → Analyst: presents reporting
README.md - Query Results → Analyst: provides query results
README.md - Findings Memo → Analyst: communicates findings
README.md - Rollout Simulation → Analyst: plans pilot
README.md - Executive Briefing → Analyst: summarizes results
README.md