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.
Due: Tuesday, Nov 1, 1:30 PMJust some exercises covering SQL up to GROUP BY, and to familiarize you with earthquake data.
Due: Tuesday, Nov 1, 1:30 PMQuiz 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