← All projects
Progressive Mass: Home Rule Petition
Sep 2025 – Dec 2025
PythonSQLData PipelineAPI
Built an end-to-end data pipeline using the Massachusetts Legislature Public API to collect and structure over 10 years of Home Rule Petition data. The pipeline ingests raw legislative records, normalizes them into a structured SQL schema, and surfaces patterns across petition cycles.
Developed a refiling fatigue analysis dashboard to quantify how repeatedly filing the same petition correlates with long-term success or failure rates. The analysis revealed meaningful trends in legislative persistence and outcome probability over time.
Due to data closure restrictions, the linked page shows only the project poster and a summary of key outcomes.