CRUD Enabled Database system for Constitutional Amendment Tracking

💻Live App 👈 🐙GitHub Repo👈

Together with Nancy Miller (University of Dayton), Keith Hamm (Rice University), and the late Ron Hedlund (Northeastern), we built a dataset of 111 state constitutions from 40 US states and all of their amendments adopted between 1776 and 2020, with the purpose of understanding the similarity across these documents and tracking their evolution over time. 

An important challenge is to be able to track every single amendment to these documents, section by section, to be able to retrieve the state of each constitution at any given point in time. For this I created a Database application that allowed us to perform CRUD operations on the original documents to keep track of any constitutional change.

Previous
Previous

Evolution and Diffusion of U.S. State Constitutional Text

Next
Next

Capturing Political Narratives of Colombian Politician Tweets