Thursday, October 27


Campaign Finance Data
Election Day is near, so what better SQL practice is there than the FEC datasets, which are not only comprehensive and fairly well-documented, but large enough that knowing SQL becomes a huge advantage over the limitations of spreadsheets.


Homework: Aggregation SQL warmups with earthquakes
Due: Tuesday, Nov 1, 1:30 PM
Just some exercises covering SQL up to GROUP BY, and to familiarize you with earthquake data.
Quiz: Homicide/Art of Access Readings Part 2 and More
Due: Tuesday, Nov 1, 1:30 PM
Quiz covering chapters 3, 4, 5 of "Homicide" and "Art of Access". And some SQL.

This is the FEC data for 2012 through 2016:

Here's the official website for the headers/details.