sf-crime-viz

Choosing the Location

Our data set includes crime for all of San Francisco, so choosing an area to focus on was essential. Numerous news reports about the World Series finale cited episodes of violance near the Mission District, Market Street, and the area around AT&T Park. We sampled the crime for the entire day in order to visualize the progression of crime before, during, and after each game.

All over the city bonfires were being lit. One was downtown on Market street. Another was on 19th and Mission. Another on 23rd and Mission. Still another was near the police station on 16th and Valencia which was the scene of raucous Occupy protest a few weeks ago.

One person was shot in the arm near 21st and Valencia streets, and second person walked into San Francisco General Hospital with a gunshot wound that he said occurred near 16th and Bryant streets.

An argument led to a stabbing near 21st and Valencia Streets, police said, with the victim suffering three wounds and being hospitalized in serious condition.

We have marked the map with various points of interest, including the ballpark, the sites of multiple fires, and the geographic area we confined our analysis to.

Click any of the markers to learn more.

Visualizing Crime Types

Our first exploration focused on the types of crimes incidents. Most news reports described the mayhem during Game 7, after the Giants won the World Series. To provide additional context, we looked at comparisons between each game.

The number of distinct crime types made it difficult to draw meaningful comparisons. Some crimes occurred rarely (e.g. arson), while others were relatively common (e.g. burglary). We log-normalized the total number of instances in order to visualize relative differences in the magnitude. Hover over values in the legend or shape to highlight the data.

Hovering over Game 7 reveals significantly more crimes for most crime types, except for drug/narcotic, arson, and robbery. This could be the result of diverting police resources to controlling rowdy crowds over traditional police work. We can see significantly higher numbers of vandalism, assaults, and vehicle thefts.

All games took place in Kansas City, MO ("away") or San Francisco, CA ("home").

Eventually a bus was lit on fire around 3rd and Market in the heart of downtown.

Crimes per hour the day of the games

After exploring the locations and crime types, we wanted to understand the progression of crimes over the course of each game day. We weren't sure if people were excited before, during or after the games. We visualized the the number of crimes by hour using a small multiples approach.

You can rearrange the order of the small multiples by game or by the total number of crimes by day. Hover over any point to see the number of crimes by hour.

Game Date Start Time (Pacific Time) End Time (Pacific Time)
Game 1 (SF Win) in KC Tue, Oct 21, 2014 5:07 PM 8:39 PM
Game 2 (KC Win) in KC Wed, Oct 22, 2014 5:07 PM 8:32 PM
Game 3 (KC Win) in SF Fri, Oct 24, 2014 5:07 PM 8:22 PM
Game 4 (SF Win) in SF Sat, Oct 25, 2014 5:07 PM 9:07 PM
Game 5 (SF Win) in SF Sun, Oct 26, 2014 5:07 PM 8:18 PM
Game 6 (KC Win) in KC Tue, Oct 28, 2014 5:07 PM 8:28 PM
Game 7 (SF Win) in KC Wed, Oct 29, 2014 5:07 PM 8:17 PM

Conduct Your Own Exploratory Analysis!

selected out of crime incidents
Click any value(s) on each graph(s) to filter the points on the map and all other graphs.

Filter By Hour in the Day

Filter By Game Number

Filter by Win or Loss

Filter By Home or Away Game

Filter By Crime Type