This repository contains data and code supporting a BuzzFeed News article examining donors on campaign finance. Published October 16, 2019. See below for details.
All data in this repository comes from the campaigns' committee filings to the Federal Election Commission (FEC), with assistance from ProPublica's Campaign Finance API.
-
data/candidates.csv
contains a list of high and medium-profile presidential candidates (and primary campaign committees) for whom an "October Quarterly" filing was available on the FEC's website by 12:30pm Eastern on October 16, 2019. (The filing deadline was October 16 at midnight.) -
fetched/filings.csv
contains a list of basic metadata for the aforementioned filings. -
The
fetched/filings/
directory is created automatically when running theMakefile
. See the Reproducibility section below. When created, it contains the raw filing data for each of those filings, in the FEC's.fec
format.
The Federal Election Commission filings do not contain any truly-unique identifiers for campaign contributors. So, in order to identify unique donors per day, BuzzFeed News constructed a donor_id
, created from the following fields:
- First name
- Last name
- 5-digit ZIP code
There are some limitations to this approach:
- If a donor changes their name, or misspells it occasionally, this approach will not cluster all of their contributions together
- If a donor moves to a new ZIP code, this approach will not cluster all of their contributions together
- If two or more donors in the same ZIP code share both a first and last name, this approach will assume (incorrectly) that they are the same person
For these reasons, the results of the analysis should be interpreted as approximations.
The Federal Election Commission does not require campaigns to itemize contributions from donors who have given $200 or less during a given campaign cycle. In a small number of cases, however, campaigns have included such donors — often, it seems, because they gave a large amount of money and then were refunded. For the sake of equal comparison, BuzzFeed News excluded contributions from donors whose aggregate was listed as $200 or less.
The FEC prohibits individual donors from giving more than $2,800 to any single committee. Even so, the data in the filings appear to indicate that some donors have given more than that amount. In some cases, this may be because the refunds have not yet been processed, or are declared elsewhere. Above-legal contributions have no effect on the analyses, which focus on the act of giving rather than how much money the campaigns have raised.
The notebooks/analyze-contributions.ipynb
notebook contains the analysis, written in Python. Relevant outputs can be found there.
The code running the analysis is written in Python 3, and requires the following Python libraries:
- pandas for data loading and analysis
- fecfile for parsing the raw FEC filings
- jupyter to run the notebook infrastructure
- requests to download the FEC files
If you use Pipenv, you can install all required libraries with pipenv install
.
The raw FEC files are too large to store in GitHub and must be downloaded from http://www.fec.gov. To do this automatically, run make filings
to execute the download script.
Executing the notebook in the notebooks/
directory should reproduce the findings.
All code in this repository is available under the MIT License. Files in the data/
directory are released into the public domain.
Contact Scott Pham at [email protected].
Looking for more from BuzzFeed News? Click here for a list of our open-sourced projects, data, and code.