2008 Election Donation Data
In preparing some data for our next round of training courses, I spent a fair amount of time today processing and cleaning the US Federal Electoral Commission (FEC) database for 2008. The FEC is extremely good about releasing their data, even though it looks like they have to dump it out of a very old database system.
I processed the three main files, and then converted the associated code tables into side tables, so the whole thing is pretty self-contained and hopefully self-explanatory. I had originally hoped to fully replicate something like the FundRace site from 2008, but since the FEC data only has zip-code as a location entity, that is not going to happen this time around. I assume the FundRace folks also had access to a nationwide telephone directory or some other way of taking name and zip-code and using that to leverage out an actual street address.
If you are interested in playing with the FEC data and don’t feel like spending a couple hours mucking about in Perl to get it into tables, I’ve placed a PostgreSQL dump file online. Candidates are linked to individuals via committees. The FEC model has a lot of complexity hiding in it, with some committees not associated with candidates, and so on, so using the data correctly will probably require a little care.
Update: The FundRace folks did in fact only use FEC data, the trick is, they used the original filings, rather than the FEC database dump. The original filings include a street address for each donation.