Cincinnati Money in Politics

This document will analyze the shifting political climate in the Cincinnati region from 2015 through August of 2019. We will use a subset of data from the Federal Election Committee (FEC) which includes only contributions from Cincinnati residents where a political party is affiliated with the committee receiving the contribution. The FEC is one of many federal organizations responsible for collecting and reporting information regarding money in politics. For this analysis, we will focus specifically on contributions made by individuals, not corporations or other legal entities.

Required packages

To perform this analysis we will use the following packages:

Package Summary
tidyverse The tidyverse collection of packages
DT Javascript enabled data tables
lubridate Easy date formatting

Data Preparation

To get started, we need to download the FEC data to our working directory and then import the file from our working directory. We will simply call our data set “cincy.”

After importing the FEC data for Cincinnati individuals who contributed to a committee affiliated with a political party, we need to clean the data to get rid of any obviously incorrect entries. We know that contributions can be positive or negative (refunds) but cannot be zero. So we will filter those entries out.

Next, we need to take a look at the dates of the contributions. We are only interested in contributions made between January 1st, 2015 and August 31st, 2019.

We can use the lubridate package to format the date in a way that will be easier for us to use. Then we can filter out any dates outside of our range of interest, which is January, 2015 through the end of August, 2019.

We also want to unify the different variations of missing data in the employer and occupation columns. First, we will address missing data by changing “N/A” and variations of “Information Requested” to “MISSING”. We will also change instances of when no response was given to “MISSING” for both of these variables.

We will also consolidate the various ways contributors listed themselves as retired by changing these values to “RETIRED”.

We also want to clean up the committee type column so that each entry corresponds to one of the following values:

  • House
  • Senate
  • Presidential
  • Party
  • PAC

We can then create a new variable indicating whether the contribution was to a qualified or unqualified committee. There are many different ways to do this but a quick look at the data suggests using the separate command and then tidying up our results a bit is a viable path to get where we want to go. We know that every House, Presidential, and Senate committees are qualified, so we can assume those are all qualified even if it is not specifically listed.

Summary of the variables

Variable Definition
contributor_last_name Last name of contributor
contributor_first_name First name of contributor
contributor_street_1 Address of contributor
contrbiutor_employer Employer of contributor
contributor_occupation Occupation of employer
contribution_receipt_date Date the contribution was made
contribution_receipt_amount Dollar amount of the contribution
contributor_aggregate_ytd The total amount contributed by individual that year to date
committee_name Name of the political committee
comittee_type Type of committee
qualified Qualification status of committee
committee_party_affiliation Political party affiliation of committee

Sortable Table

In the table below, we can see every contribution made by a local resident to a committee with an affiliation to a political party from January of 2015 through the end of August, 2019.

Summary Table

We can group the donations by year and party to get a bigger picture view of the average contribution amount, the total number of contributors (by household), and the total amount raised by each political party. In the table below, we can see the total number of individuals who contributed to entities each year and the average donation broken down by party.

Unsurprisingly, the vast majority of donations went to the two major parties (Democratic and Republican). The Republican party attracted a signficantly higher average donation each year than the Democratic Party.

Focused Analysis

We can group donations by the names of individuals to get an idea of who some of the biggest local contributors are. The table below shows those top contributors and the amount of their contributions.

While the above table provides some insight, it may actually be more beneficial to figure out which households make the most donations. Grouping contributions by address actually provides a more accurate indication of which families donate the most money and exert the most political power.

We can break down these huge household donations by party. When doing so, we can see that the biggest Cincinnati donors give primarily to committees supporting the Republican Party.

Most frequent contributors

While we can have determined which local individuals contributed the most money, we may also want to investigate which have given the most often. The following table shows the total number of contributions over the time period between 2015 and late 2019.

Ann Ruchoft made an astounding number of contributions over this time period. We can take a closer look at just her contributions:

We see the number was even higher than previously indicated because 15 of her 1,305 contributions were recorded under the first name Anna instead of Ann.

It is unclear exactly why so many donations were made and nothing in the above table sheds a lot of light on the mystery. Given how many of the small donations were repeated soon after, it may be that the committees requested that Ms. Ruchoft split her donations up. In politics, it is often viewed as beneficial for politicians to show as much of their total fundraising haul as coming from small donations (often defined as $25 or less) as possible. The reasoning for this is twofold. First, having many small fundraisers in sometimes touted in the media and by the candidates themselves as an indication of grassroots support and enthusiasm. Second, there is a school of thought that candidates raking in a lot of big donations and fewer small donations will be more beholden to their deep-pocketed donors than would candidates whose fundraising is coming in the form of smaller dcontributions.

Ms. Ruchoft and the others with a high number of contributions may be deep pocketed donors masquerading as smaller donors to juice the number of donations and decrease the average amount of their preferred committees donations for the sake of perception. Or it could be a much more mundane explanation. Perhaps these donors just fire off a small donation every time they see something frustrating about the opposing party (or inspiring from their preferred candidates).

Most Heavily Represented Employers

By grouping contributions amounts by the employer of the individual contributing, we can gain some insight into which local companies potentially wield the most political influence. American Financial Group tops the list but we see that two related entities, Castellini Company and Castellini Management Company, when grouped together have actually contributed the most money.

The Castellini name is familiar for Cincinnati sports fans because the chairman of the Castellini Company is Bob Castellini, who leads a group that owns a majority share of the Cincinnati Reds. Castellini has served as the CEO of the franchise for 14 years.

For those worried about the influence of money in politics, this is a clear example of a situation where we should have some concern. Castellini’s ownership group receives a significant amount of public money due to a 1996 agreement with Hamilton County that funded a portion of the construction for the Reds new stadium. From that agreement (which included a half-cent rise increase in sales tax), the Reds receive an annual payment from the County to pay for debt on the stadiums and repair costs. Elected officials have a great deal of influence over how much of this money the local pro sports team receive each year compared to how much is “rolled back” to taxpayers. There is a clear conflict of interest for politicians receiving big donations from Castellini and his associates when it comes to deciding how much public money to dole out.

Xavier University Employee Contributions

Xavier University employees contributed a total of $11,224 to committees affiliated with a political party over this time frame. This pales in comparison to the amount contributed by University of Cincinnati employees ($162,019, as seen above in the table showing the local employers whose employees gave the most). This is likely mostly due to the large difference in the number of employees between the two universities but may also reflect the fact that the public university is more reliant on public funding.

Below, we can see the total amount donated by individual Xavier University employee, led by Ann Tracey, who contributed $1,750 over this time period.

Self-Directed Analysis

Refunds

Refunds of political contributions are an interesting phenomenon worth exploring to see if there are any trends as to which entities were most likely to give refunds. We can see in the bar chart below that committees tied to the parties themselves were least likely to give refunds. This would make sense from the standpoint that the parties are not going anywhere, whereas the candidates might. We see an especially high number of refunds from Senatorial fundraising committees.

Contributions by Month in 2018

Viewing donations by month in an election year would be interesting, both in terms of the totals and whether either party does comparatively better at a particular time of year. We will look at monthly donations, by party, in the year 2018 to see if any trends stand out. We can see in the bar chart below that it took a while for fundraising to kick into gear, with the totals peaking for both parties in the months immediately prior to the November election. After the election, contributions fell to almost zero in December.

Committees affiliated with Democratic Party brought in more money in every month prior to the election in 2018, though committees affiliated with the Republican Party did close the gap somewhat in the immediate runup to the election.