Civic Event Tracker

Contributed to the 50501 Project supporting Harvard's Crowd Counting Consortium by preparing and delivering structured datasets meeting strict research specifications.

Contributions:

• Data Engineering: Built SQL queries to generate custom reports and datasets for researcher requests.
  Frontend Visualization: Developed a public dashboard with filtering by state, date, and event type for journalists.
  Quality Assurance: Implemented validation rules ensuring consistency across thousands of event records.