Thursday, October 27

Agenda

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.

Assignments

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: ca-fecdata.zip

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