Due: Tuesday, October 6
Points: 5


Create a Google spreadsheet in your PADJO2015 folder named: PADJO2015-MORECRIME-PIVOTS

It should include 2 different histograms and/or pivot tables:

  • Using the SF crime incident dataset that contains August 2014 and August 2015, create a chart, or even just a table, showing me something specific and interesting about how incident reports changed from 2014 to 2015. An easy one would be: “Crimes categorized as Assault fell x% from 2014 to 2015” But the Category column is too broad, so find me something more interesting.
  • Repeat the same thing for another city (see the Requirements for the links), but get the data yourself.


  • You don’t have to make a visualization if you don’t want to. If you can filter/reduce the data to a few rows and columns that make your point, then great.

  • Download the CSV data and import into Google spreadsheets

  • For the second chart/table, pick a city: Chicago, Los Angeles, or Dallas. Use their respective web site tools to filter by date and export.

  • As you’ll see very quickly, every other city does not categorize crimes the same way that San Francisco does.

Obviously, the tutorial on pivot tables and earthquakes will be very handy.

Download the SF 2014-2015 August data for this exercise here.

The data originally came from the SF data portal

The other city datasets:

Filtering and exporting from Socrata

Look for the Filter and Export buttons:




A walkthrough of managing earthquake data and doing basic visualizations with spreadsheets (Part 2 of 3)

A walkthrough of using Pivot Tables to summarize earthquake data across two dimensions, allowing for even more insightful histograms (Part 3 of 3)

Pivot tables are an effective tool for quickly summarizing the facts from a mass of records