Digging into the Foundation Center’s Glasspockets grants data

As you may know, the Foundation Center has been collecting detailed grants data from some of the largest U.S. foundations for the last few years through its Glasspockets initiative. What you may not know is that Glasspockets has developed a simple programmatic way to access its data through an open API (a way for programmers to easily access information).

For those technically inclined, I developed and published an R wrapper for accessing and loading Glasspockets queries on Github. For those less technical, R is a popular open soure statistical software package that I use for data analysis.

The Glasspockets API plus the R library allows me to easily search Glasspockets grants, which I’m planning on mining for future blog posts. For my initial pass with the data I started looking at the Gates Foundation’s giving, specifically looking at the seasonality in their grant making.

Gates giving by month

I’ve long lamented how our tax policy drives seasonal giving, creating peaks and valleys in donations. Next week’s Giving Tuesday is a clever way to try to capitalize on this unfortunate reality.

While the typical donor might not think about giving until year end, I would think that large foundations would be less seasonal in their giving. In the case of the Gates Foundation, I would also be wrong.

Using data from Glasspockets, I constructed the following chart which shows the sum of giving by month from 2011–2014 (up to November 2014 that is). A quick glance shows that November, the 11th month, dwarfs grants made in any other month. Indeed, the Gates Foundation made grants totalling $3,204,224,816 in the Novembers from 2011–2014.


I’m not necessarily arguing that it’s a bad thing that Gates giving isn’t more spread out. I did however assume that it would not so closely match the regular donor public’s patterns of giving.

I’m interested to explore whether this same seasonality, especially dominance of giving in November, holds true for other foundations or not. More importantly, I’m looking forward to digging deeper into the Glasspockets data. If you are a fellow R user, feel free to grab the library and jump in as well.