THE BULLET CALENDAR


In the United States, there have been more than 400 school shootings since 1999. Exposing over 357,000 students to gun violence. The federal government does not track school shootings, so The Washington Post has spent years tracking how many children in the US have been exposed to gun violence during school hours. To demonstrate how data can help us save our kids’ lives we used AI and analysed the database to predict when and how the mass shootings may potentially happen in 2024 by creating The Bullet Calendar. This way we wanted to raise awareness about this issue to the authorities by showing them how the data they ignore can help us stop this shootings and save lives.

 
 
 
 

While it remains highly unlikely that any student will experience a school shooting, the number of incidents has risen rapidly in recent years. Through 2017, the country averaged about 11 school shootings a year, never eclipsing 16 in a single year. But starting in 2018, violent incidents started climbing. To make the predictions we used different methods, like Linear Regression and Exponential Moving Average. Revealing 30 events estimated for 2024 and 22.952 kids exposed to gun violence.

 

  • 0
  • 0
School shootings by year.
 
 

Once we had the 30 events and number of kids exposed estimated we started to distribute them across the calendar and the country, according to the repetition frequency of events. This heatmap helped us find some patterns and opportunities to take action. For instance, the most repeated dates were August 30th and February 14th, but January has the most historical amount of events and starts to decrease when it gets near the holidays.

 
 

Thanks to the data gathered, there were more variables we were able to crunch the numbers with. We tracked the states and cities with the most amount of events in history and led us to find the average shooter’s age and sex, school type and how many people will be at school during a specific event. Then we asigned them for each one of the events throughout the year.

 
 

  • Enrollment
  • Enrollment
 
 

  • Public
  • Private
  • Public
  • Private
School_Type

  • 14 y/o
  • 15 y/o
  • 16 y/o
  • 17 y/o
  • 18 y/o
  • 14 y/o
  • 15 y/o
  • 16 y/o
  • 17 y/o
  • 18 y/o
Shooter_Age

  • California
  • Texas
  • Florida
  • North Carolina
  • Pennsylvania
  • Illinois
  • Michigan
  • Alabama
  • Tennesse
  • Ohio
  • Louisiana
  • Georgia
  • New York
  • Maryland
  • Virginia
  • Colorado
  • Washington
  • South Carolina
  • Indiana
  • Minnesota
  • Mississippi
  • New Mexico
  • Wisconsin
  • Oregon
  • District of Columbia
  • California
  • Texas
  • Florida
  • North Carolina
  • Pennsylvania
  • Illinois
  • Michigan
  • Alabama
  • Tennesse
  • Ohio
  • Louisiana
  • Georgia
  • New York
  • Maryland
  • Virginia
  • Colorado
  • Washington
  • South Carolina
  • Indiana
  • Minnesota
  • Mississippi
  • New Mexico
  • Wisconsin
  • Oregon
  • District of Columbia
State_Event

  • Male
  • Female
  • Male
  • Female
Shooter_Sex

  • 12:00 PM
  • 14:00 PM
  • 09:00 AM
  • 13:00 PM
  • 08:00 AM
  • 12:00 PM
  • 14:00 PM
  • 09:00 AM
  • 13:00 PM
  • 08:00 AM
Time_Event
 
 

Finally, this whole project needs to get the authorities. 30 envelopes from The White House to City Councils and Governors to use it as a tool to take action into this matter. Because the data they ignore has the power to stop this once and for all. Meanwhile, users will be able to download the digital version of the calendar to sync it to their phones and share this initiative with their communities. Because at the end of the day, this is not about how many events we can predict, it is about how many we can stop and save the future of the country by saving the day.

 
 

Q1 Results: 15 events occurred vs. 13 predicted.
Q2 Results: 8 events occurred vs. 6 predicted.
Q3 Results: 6 events occurred vs. 4 predicted.
Q4 Results: 5 events occurred vs. 7 predicted.
Total: 34 events occurred vs. 30 predicted.

 
 
 
 

CREDITS


The Bullet Calendar
Creative Team: Josefina Mateo Burton & Ezequiel Scarpini

Washington Post Research Team
Enterprise Reporter: John Woodrow Cox
Database Editor: Steven Rich
Editorial Assistant: Linda Chong
Copy Aide: Lucas Trevor
Graphics Reporter: John Muyskens
Visual Enterprise Editor: Monica Ulmanu

AI Agents: OpenAI+Google Colab, ChatCSV, Google Bard, Microsoft Excel
Database used: https://github.com/washingtonpost/data-school-shootings
Original article for more info: https://www.washingtonpost.com/education/interactive/school-shootings-database/

 
 

THE BULLET CALENDAR

WHAT IF AI MADE IT? NEWCASTLE’S FOOTBALL GAME AD

BON IS BACK IN BLACK - AC/DC (BON SCOTT A.I VERSION)

INSTAGRAM FILTERS A.R DEVELOPMENT

RAMONOS - MONO LIVE!

E-MMORTALITY / METAHUMAN SELF GPT

THE FILTERLESS FILTER - CAMPAIGN FOR LEGAL ABORTION LATAM

THE NEXT BOB ROSS

JOHNNY CASH AI VOICE + UE AVATAR

LOCKED PROJECT