curtmerrill/cnn-fec

campaign finance app for FEC reports, forked from newsdev/nyt-fec

fec

Note!

VERSION 1.1 INCLUDES BREAKING CHANGES THAT COULD LEAD TO DATA LOSS! The previous working version is tagged working If you would like to update to the current version, which supports multiple cycles, and you have data in your donors table, please update to v1.0, run the sql updates described here, and then go up to v1.1. Also strongly recommended to backup your whole database before doing any of this.

App is still kind of in the scratchpad phase, absolutely no promises that it works or I won't make breaking changes.

About

This app allows for importing and searching expenditures, independent expenditures and contributions from electronic FEC filings. It relies on the NYT's fec2json library.

Why not just use the FEC website?

The FEC website has been substantially improved recently, but it still lacks several main features we desire.

1. It takes several days for itemizations to be processed, so it is impossible to search transactions right away
2. There are some search fields that are important to me that do not exist in the FEC
3. We want to be able to do more with independent expenditure summing and categorizing
4. We want to be able to add additional data, such as our own donor ids

If you don't really need to deploy and maintain your own standalone campaign finance infrastructure, however, I recommend using tools developped by the FEC including their site, their api or their bulk data. Or use ProPublica's site or api.

Setup instructions (updated for CNN fork)

1. pull this repo
2. mkvirtualenv fec --python $(which python3)
3. get a FEC API key here
4. email [email protected] and ask them to upgrade you to 120 api calls per minute
5. add the following to your $VIRTUAL_ENV/bin/postactivate:

   export DJANGO_SETTINGS_MODULE=config.dev.settings
   export fec_DB_NAME=cnn_digital_fec
   export fec_DB_USER=cnn_digital_fec
   export FEC_API_KEY=your-api-key

6. pip install -r requirements.txt
7. createuser -s cnn_digital_fec
8. createdb -U cnn_digital_fec cnn_digital_fec
9. add2virtualenv . && add2virtualenv config && add2virtualenv fec
10. django-admin migrate