Data Reporting

Course materials for MPJO-722-01, Georgetown University

This project is maintained by dwillis

MPJO-722-01: Data Reporting
Database Skills – Importing and querying; Campaign Finance data
Links
Assignments for Feb. 12
Read: Political Funds Remain an Asset for Many Ex-Lawmakers

SQL: Complete Part 2 of the SQLite tutorial. It’s long; start early.

SQL: Create a new database called fec (the .sqlite gets added on when you create it). Download this CSV file of contributors to Wisconsin Rep. Tammy Baldwin during the second quarter of 2011. Import it into the fec database, creating a table called baldwin. Look at the CSV file in Excel before you define the fields in SQLite – be sure to define the zip field as VARCHAR, not INTEGER. Just define the date field as VARCHAR for now.

Once you’ve done that, write queries to do the following:

  1. Show the contributors from Hawaii
  2. Show contributors from Philadelphia who gave at least $1,000
  3. Show contributors who listed their occupation as CEO, with the largest amount first

Email me both the fec.sqlite file as an attachment (don't export the data) and the SQL from your queries (I can check the results) by 5:20 p.m. on Feb. 12.