NICAR16: Tackling federal election campaign finance data

In an election year, NICAR was bound to feature plenty of election-themed sessions.One of the more interesting that I caught was “Election: Reverse-engineering campaign finance stories,” in which Aaron Bycoffe, Carrie Levine, and Derek Willis walked the audience through the steps they took to break various campaign finance stories.

Using an open-source parser to find small donations

In quarterly filings with the Federal Election Commission, candidates must declare how much they’ve raised and spent, among other things, during the previous three months. The filings generate plenty of news stories, most of which run the next day and summarize the data.

For FiveThirtyEight’s “Four Ways to Fund a Presidential Campaign,” however, Bycoffe wanted to go beyond summarization and show readers how much each candidate had raised from small donors.

He used the FEC’s electronic-filing search to find each candidate’s most recent filing and then Fech, a Ruby parser campaign filings from the FEC, to find identify small donors and compare those contributions to the total.

For those of us wanting to work with campaign data Boycoffe had two suggestions:

  1. Check out the FEC’s Committee Master file and Operating Expenditures file, which will help you find stories to localize.
  2. Do as much work as possible in a programmatic way so that you have a lighter workload when new filings are submitted.

Following up on traditional reporting with data

Levine found that pre-reporting was key for the Center for Public Integrity’s “Presidential campaign donors hedge bets,” which looked at how donors were distributing contributions widely among multiple candidates.

Through conversations with donors beforehand, she and her team developed a theory about campaign contributions that was then backed up by the data. This pre-reporting allowed Center for Public Integrity to run the story the night FEC filings came in and to beat major news outlets on the story.

Despite the success of the story, Levine stressed the importance of having a backup plan in place for when things inevitably fail. In fact, the hedging story ran into problems because some of the files were so big that the servers couldn’t process them. Instead of running SQL queries as planned, the data was put into Excel to conduct the analysis.

An alternative the campaigns’ filings

Though he’s now at ProPublica Willis was able to tap a unique data source for the New York Times’ “Bernie Sanders’ Early Online Haul: $8.3 million”: ActBlue.

ActBlue is a fundraising group for Democratic candidates and files with the FEC. Through ActBlue filings, Willis was able to see how much Sanders had raised online before his campaign had submitted files. In addition, ActBlue has to report donations of every size — even a dollar — so the New York Times was able to obtain details that normally wouldn’t be in Sanders’ campaign filings.

Willis noted that hundred of candidates use ActBlue, which makes its filings useful even in local races. The downside, Willis said, is that there isn’t a similar platform for Republican campaign contributions. A note of caution: The ActBlue filings are usually extremely large, which means you might want to split the data up before you approach it, he said.

About the author

Benjamin Din

Student Fellow

Latest Posts

  • A Google Spreadsheets change affecting TimelineJS users

    Google recently changed something about their Sheets service which is causing many people to run into an error when they are making a new timeline. Note: there should be no impact on existing timelines! After this change, many of you click on the "preview" and get this message: An unexpected error occurred trying to read your spreadsheet data [SyntaxError] Timeline configuration has no events. There is a straightforward work-around, but it requires those of you who have...

    Continue Reading

  • How Americans think and feel about gun violence

    A man killed his wife, then himself. I want you to see his face and learn that he enjoyed fishing with his grandchildren. A small-time drug dealer is shot by two men in a parking lot. I find his Facebook profile and a photo shows him striking a playfully irreverent pose, giving the camera the middle finger. The photo’s comments take a mournful turn after a certain date. “Rest easy bro ???” Gun Memorial runs...

    Continue Reading

  • Software developers interested in journalism: Northwestern and The Washington Post want you!

    Northwestern University and The Washington Post are offering a unique opportunity for two talented software developers interested in applying their programming skills in media and journalism. Here’s the proposition: (1) a full-tuition scholarship to earn a master’s degree in journalism at Northwestern University, followed by (2) a six-month paid internship with The Post’s world-class engineering team, with the possibility of subsequent full-time employment. These opportunities are made possible by the John S. and James L....

    Continue Reading

  • What happened when Gun Memorial let anyone contribute directly to victim profiles

    If you’re reporting local or niche news, there’s a good chance that your audience collectively knows more about the story than you do. That’s especially true for us at Gun Memorial, a small publication with a nationwide mission of covering every American who is shot dead. In our latest, mostly successful, experiment, we let readers add to our stories without editor intervention. This article shares some lessons from that experience. Asking for reader contributions A...

    Continue Reading

  • How conversational interfaces make the internet more accessible for everyone

    This story is part of a series on bringing the journalism we produce to as many people as possible, regardless of language, access to technology, or physical capability. Find the series introduction, as well as a list of published stories here. In 2004, human-computer interaction professor Alan Dix published the third edition of Human-Computer Interaction along with his colleagues, Janet Finley, Gregory Abowd, and Russell Beale. In a chapter called “The Interaction,” the authors wrote...

    Continue Reading

  • Three tools to help you make colorblind-friendly graphics

    This story is part of a series on bringing the journalism we produce to as many people as possible, regardless of language, access to technology, or physical capability. Find the series introduction, as well as a list of published stories here. I am one of the 8% of men of Northern European descent who suffers from red-green colorblindness. Specifically, I have a mild case of protanopia (also called protanomaly), which means that my eyes lack...

    Continue Reading

Storytelling Tools

We build easy-to-use tools that can help you tell better stories.

View More