Gunfire on School Grounds Dashboard

Overview

This Streamlit dashboard provides a detailed, real-time view of gunfire incidents on school grounds in the United States. By automatically fetching and processing data from Everytown Research, the dashboard uncovers key trends, geographic hotspots, and incident outcomes, aiming to inform policymakers, researchers, educators, and the public—and ultimately drive awareness and action on this critical issue.

Key Features

• Real-Time Data Automatically pulls and processes updated incident reports from Everytown Research upon each dashboard load.

• Flexible Filters Filter by State, Date Range, Intent, or even Minimum Casualties to tailor the data exploration to your interests.

• Visual Analytics

  • Yearly & Monthly Trends: Spot long-term changes and potential seasonal variations.

  • Day-of-Week Analysis: Discover weekday vs. weekend patterns.

  • Distribution & Heatmap: Understand how intents align with outcomes, revealing possible risk factors or intervention points.

  • Top 5 Most Tragic Incidents: Quickly identify the events with the highest casualties for deeper reflection.

• Geographic Insights

  • Interactive State-wise Map: See which states have the highest number of incidents, complete with a dual-axis bar chart for cumulative impact.

  • Top 10 Cities: A bar chart highlights the urban areas most affected by these events, offering clues for localized policy or interventions.

• Latest Incident An at-a-glance pane on the sidebar shows you the most recent gunfire incident, including location, casualties, and a short narrative.

• About Page A dedicated “About” section provides context about the data sources, methodology, project motivation, and future directions.

  
  

Technologies

• Python & Pandas – For real-time data cleaning, transformations, and analysis.

• Streamlit – Powers the interactive dashboard and user-friendly filter widgets.

• Plotly – Delivers interactive charts, maps, and heatmaps.

  
  

Use Cases

• Policymakers & Educators Identify trends, motives, and risk factors to inform preventative policies, resource allocation, and safety protocols.

• Journalists & Researchers Leverage a reliable, up-to-date dataset for studies, investigative reporting, or broader analyses on gun violence in schools.

• General Public Gain a clearer understanding of when, where, and how these incidents happen, and see how community-focused efforts can address them.

  
  

Project Workflow

1. Data Collection The dashboard automatically retrieves the latest CSV file from Everytown Research whenever it’s accessed.

2. ETL Process

   • Cleaning: Handling missing values or invalid coordinates.

   • Feature Engineering: Creating time-based columns (Year, Month, Day-of-Week) and calculating total casualties.

   • Dynamic Filtering: All charts and maps update instantly based on the user’s filter choices.

3. Visualization

   • Plotly ensures interactive charts (bar plots, line charts, geospatial maps, and heatmaps).

   • Side-by-side & Multi-section Layout helps users quickly compare different analyses.

4. Deployment

   • Can be run locally or hosted on Streamlit Cloud (or other services) for easy, public-facing access.

     
     

Thank You

By highlighting the patterns, scale, and severity of gunfire on school grounds, we hope to spur conversations and concrete steps toward safer learning environments. We welcome feedback, suggestions, and collaboration to enhance this project further.

• Live Dashboard: Explore Here

• GitHub: View Source Code