A Better St. Louis. Powered by Journalism.
  • Twitter
  • Facebook
  • Print
  • Email

Glimpse of biggest donors found within mountain of searches and spreadsheets

In Elections

1:56 am on Mon, 07.09.12

What do you get when you lock a reporter in a proverbial box and let him run wild with Excel spreadsheets?

Jason Rosenbaum
Jason Rosenbaum

The answer: Power Players, a collaboration among the St. Louis Beacon, the Investigative News Network and the Center for Investigative Reporting.

Or, perhaps, hair-tugging insanity.

To be fair, my editors didn’t literally lock me in a box over the last few weeks. They gave me enough space from the daily grind to research the biggest campaign contributors in Missouri politics. The data for this project came from the Missouri Ethics Commission and followthemoney.org, which track donations to state candidates and causes, the Federal Election Commission, which tracks contributions to federal candidates and committees, and OpenSecrets.org.  

I sorted out and tabulated state and federal donations from 2008, 2009 and 2010 to find out who the big contributors in those election years. As the 2012 election moves forward, information on that donor pool will be updated and expanded.

ASIDE

Political reporters in Missouri know the Missouri Ethics Commission quite well; it’s the go-to place for information about campaign contributions or lobbyists' gifts. The current site features plenty of useful features, especially a section showcasing donations of $5,000 or more.

But the commission was a different animal in 2008, 2009 and 2010. As I went through the data, I noticed that a single contribution could show up multiple times mainly because it was featured in amended reports. Weeding those out took up a lot of time and double and triple checking.

(To the commission's credit, this quirk has generally been ironed out with contributions after 2011, which should make updating the data much easier.)

Another challenge: I wanted to make sure the totals reflected the realities of Missouri's campaign finance system. Prominent donors regularly give not only to candidates but also to political party committees, ballot initiatives and third-party political action committees. Even after campaign finance limits were removed, third-party PACs have continued to play a big role in how political campaigns are funded. So it was important but time consuming to incorporate all this information.

If that weren't enough of a complication, there's also the federal campaign finance system, which couldn't be more different from Missouri's. For one thing, Missouri is one of four states without campaign finance limits. Donors to federal candidates must adhere to donation limits to candidates and party committees, although those regulations aren't necessarily in place to third-party PACs. The results were predictable: Donations to state candidates and causes were much, much bigger than contributions to federal candidates and committees. 

Because of the innumerable quirks in this seemingy endless sea of contributions, the data in individual profiles were checked -- and rechecked -- multiple times. I also tabulated and organized contribution data for donors who didn’t crack the top 10, just to make sure somebody wasn’t inadvertently left off the list. So I believe that the numbers are as accurate as possible, but if any donation turns out to be inaccurate or missing, I will make changes.

Of course, it’s one thing for a reporter to embark on this type of project. It’s another to expect the average citizen to be familiar with these at-times complicated databases and the intricacies of Microsoft Excel -- as well as the distinctions within the campaign finance system. Even though the system is supposed to be transparent, piecing together a big picture of the power players is not for the faint of heart.

But if there’s one exciting aspect of this project besides mastering Excel's AutoSum feature, it’s how the available data are presented. The data's presentation was made possible through the work of Chase Davis of the Center for Investigative Reporting. (Full disclosure: Davis and I were at the University of Missouri-Columbia around the same time, and I have long admired his work.)

A similar content management system was used to track California's biggest contributors for California Watch. I wouldn't be surprised if this type of technology became more widespread. 

Why? For one thing, the application plots every donation on a timeline. A user can also search through individual donations easily and, yes, export the data into Excel. Best of all, the infrastructure is in place to update and expand the donation pool for future election cycles.

In retrospect, the first line of this piece may be a misnomer. This project isn't the result of isolation. Rather, it's a collaboration among journalists eager to shine a light on the power players in the political system.

No Comments

Join The Beacon

When you register with the Beacon, you can save your searches as news alerts, rsvp for events, manage your donations and receive news and updates from the Beacon team.

Register Now

Already a Member

Getting around the new site

Take a look at our tutorials to help you get the hang of the new site.

Most Discussed Articles By Beacon Members

Conference of American nuns will mull response to Vatican charges

In Nation

7:55 am on Fri, 08.03.12

Meeting in St. Louis next week, the Leadership Conference of Women Religious will have its first opportunity as an assembled group to consider what to do after the Vatican issued a mandate for change this spring. It calls on the conference to reorganize and more strictly observe church teachings.

The 'free' Zoo

In Commentary

7:51 am on Tue, 05.22.12

When a family of four goes to the St. Louis Zoo, they can be forgiven for not knowing it will cost them $60, $72 if they park. If they can't pay, the alternative is to tell the kids they can't do what kids do at the zoo.

Featured Articles

Teacher-prep programs get poor grades in new survey

In Education

4:30 pm on Tue, 06.18.13

Some in Missouri and Illinois were singled out for excellence; others were branded with a consumer alert, that would-be teachers should be wary. The national group that did the survey said it will be repeated annually, said the evaluating group's president Kate Walsh.

At Brandenburg Gate, Obama follows in predecessors' footsteps

In World

3:55 pm on Tue, 06.18.13

Fifty years ago this week, President John F. Kennedy confronted Cold War tensions in Wall-divided Berlin and bolstered the confidence of its beleaguered residents by telling them, "Ich bin ein Berliner." On Wednesday, President Barack Obama will face eastward from the Brandenburg Gate for the latest address of an American president in the city that has been a flashpoint of East-West relations.

Featured Articles

Farewell to Duff's from one who knew it well

In Out & About

12:42 am on Tue, 06.18.13

Duff's, a mainstay of the Central West End since Karen Duffy opened it in 1972, is closing its doors this month. Over the years, Duff's developed a reputation for reasonably priced, imaginative menus and a good selection of wines. But what made Duff's invaluable were the poetry readings on Monday evenings.

Featured Articles

Recent Articles

More Articles

Innovation and entrepreneurial activity are on the rise in St. Louis, especially in bioscience, technology and alternative energy. The Beacon's InnovationSTL section focuses on the people who are part of this wave, what they're doing and how this is shaping our future. To many St. Louisans, this wave is not yet visible. InnovationSTL aims to change that. We welcome you to share your knowledge, learn more about this vibrant trend and discuss its impact.

Featured Articles

Can Facebook and romance mix? Study suggests hazards

In Education

6:10 am on Mon, 06.17.13

Recent research out of Mizzou suggests that excessive use of Facebook can have negative effects on romantic relationships, including cheating, breaking up and divorce. The negative impact tends to be on newer relations, under three years duration. Doctoral student Russell Clayton advocates more moderate Facebook use to prevent its threats.

Featured Articles

Bosley right to put child first - but not to ask others to pay

In Commentary

12:39 am on Tue, 06.18.13

Asking for contributions for a child’s college education is legal in Missouri. But not right. Because a parent should help his or her children in almost any way they can,  such obligations must be kept far away from a politician’s public responsibilities — it is not hard to figure out which one would lose if they conflicted.

One solution for potential caregivers

In Commentary

6:07 am on Mon, 06.17.13

The twins are 89 years old. Health issues signal the end to each living in her own two-bedroom, two-bath condominium. Here's the story of one family's solution: The sisters now live in one unit and home-health services come in. How did they get to this resolution?

Blind fear: Combating terror with eyes wide shut

In Commentary

7:00 am on Thu, 06.13.13

It turns out that the Obama administration has been conducting its own variation of electronic surveillance that the Bush administrated. The problem is not the need to combat terrorism, but the blanket invasion of privacy and the revelation of who the people are who have access to our secrets.

Featured Events:

More About The Beacon Home