Skip to content

Instantly share code, notes, and snippets.

@riceissa
Last active July 1, 2017 05:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save riceissa/186b1d2e8bbb85e6204b5e06aba64018 to your computer and use it in GitHub Desktop.
Save riceissa/186b1d2e8bbb85e6204b5e06aba64018 to your computer and use it in GitHub Desktop.
hits-based giving project
-- Create database with
-- sqlite3 foundations.db < foundations.sql
-- Then use with
-- sqlite3 foundations.db
-- To get headers, use with
-- sqlite3 -header -column foundations.db
drop table if exists assets;
create table assets (
foundation text not null,
year integer not null,
assets integer not null
);
drop table if exists giving;
create table giving (
foundation text not null,
year integer not null,
giving integer not null
);
-- The following are from Waldemar A. Nielsen. The Big Foundations. 1972. p22.
insert into assets (foundation, year, assets) values
('Ford Foundation', 1968, 3661000000),
('Rockefeller Foundation', 1968, 890000000),
('Duke Endowment', 1968, 629000000),
('Lilly Endowment', 1968, 579000000),
('Pew Memorial Trust', 1968, 437000000),
('W. K. Kellogg Foundation', 1968, 435000000),
('Charles Stewart Mott Foundation', 1968, 413000000),
('Nemours Foundation', 1968, 400000000),
('Kresge Foundation', 1968, 353000000),
('John A. Hartford Foundation', 1968, 352000000),
('Carnegie Corporation of New York', 1968, 334000000),
('Alfred P. Sloan Foundation', 1968, 329000000),
('Andrew W. Mellon Foundation', 1968, 273000000),
('Longwood Foundation', 1968, 226000000),
('Rockefeller Brothers Fund', 1968, 222000000),
('Houston Endowment', 1968, 214000000),
('Moody Foundation', 1968, 191000000),
('Danforth Foundation', 1968, 173000000),
('Emily & Ernest Woodruff Foundation', 1968, 167000000),
('Richard King Mellon Foundation', 1968, 162000000),
('Sarah Mellon Scaife Foundation', 1968, 145000000),
('Commonwealth Fund', 1968, 142000000),
('James Irvine Foundation', 1968, 119000000),
('Haas Community Fund', 1968, 115000000),
('Brown Foundation', 1968, 108000000),
('Edwin H. and Helen M. Land Foundation', 1968, 107000000),
('Henry J. Kaiser Family Foundation', 1968, 106000000),
('Sid W. Richardson Foundation', 1968, 106000000),
('Surdna Foundation', 1968, 105000000),
('Vincent Astor Foundation', 1968, 103000000),
('Charles F. Kettering Foundation', 1968, 103000000),
('Max C. Fleischmann Foundation', 1968, 102000000),
('A. G. Bush Foundation', 1968, 100000000);
-- The following are from Waldemar A. Nielsen. The Golden Donors. 1985. p4-6.
insert into assets (foundation, year, assets) values
('Ford Foundation', 1984, 3400000000),
('The John D. and Catherine T. MacArthur Foundation', 1984, 1500000000),
('Robert Wood Johnson Foundation', 1984, 1250000000),
('W. K. Kellogg Foundation', 1984, 1200000000),
('Pew Memorial Trust', 1984, 1200000000),
('Andrew W. Mellon Foundation', 1984, 1100000000),
('Rockefeller Foundation', 1984, 1000000000),
('Lilly Endowment', 1984, 800000000),
('Kresge Foundation', 1984, 790000000),
('William and Flora Hewlett Foundation', 1984, 575000000),
('Charles Stewart Mott Foundation', 1984, 540000000),
('Carnegie Corporation of New York', 1984, 500000000),
('Duke Endowment', 1984, 500000000),
-- The following includes the Buck Trust
('San Francisco Foundation', 1984, 490000000),
('W. M. Keck Foundation', 1984, 490000000),
('Richard King Mellon Foundation', 1984, 490000000),
('McKnight Foundation', 1984, 450000000),
('J. E. and L. E. Mabee Foundation', 1984, 375000000),
('New York Community Trust', 1984, 370000000),
('Alfred P. Sloan Foundation', 1984, 360000000),
('Samuel Roberts Noble Foundation', 1984, 340000000),
('The Gannett Foundation, Inc.', 1984, 330000000),
('Cleveland Foundation', 1984, 310000000),
('James Irvine Foundation', 1984, 300000000),
('J. Howard Pew Freedom Trust', 1984, 300000000),
('Conrad N. Hilton Foundation', 1984, 300000000),
('Houston Endowment', 1984, 300000000),
('Edna McConnell Clark Foundation', 1984, 280000000),
('Weingart Foundation', 1984, 275000000),
('William Penn Foundation', 1984, 275000000),
('Henry J. Kaiser Family Foundation', 1984, 275000000),
('Moody Foundation', 1984, 270000000),
('Bush Foundation', 1984, 265000000),
('Surdna Foundation', 1984, 260000000),
('Brown Foundation', 1984, 250000000),
('William Randolph Hearst Foundation', 1984, 250000000);
-- The following are from Foundation Growth and Giving Estimates: 2001 Preview.
-- The Foundation Center. p8.
insert into giving (foundation, year, giving) values
('Bill & Melinda Gates Foundation', 2000, 994900000),
('Ford Foundation', 2000, 652091000),
('Lilly Endowment', 2000, 583890521),
('David and Lucile Packard Foundation', 2000, 533589987),
('Robert Wood Johnson Foundation', 2000, 351683796),
('Andrew W. Mellon Foundation', 2000, 205870150),
('California Endowment', 2000, 189663220),
('Pew Charitable Trusts', 2000, 187853822),
('W. K. Kellogg Foundation', 2000, 178739742),
('Ford Motor Company Fund', 2000, 169100475),
('John D. and Catherine T. MacArthur Foundation', 2000, 164022738),
('Rockefeller Foundation', 2000, 163391841),
-- The Foundation Yearbook 2002 Edition lists this as 192502039. This seems
-- to be the only significant (over $1 million) deviation.
('Starr Foundation', 2000, 161965876),
('Robert W. Woodruff Foundation', 2000, 149979270),
('New York Community Trust', 2000, 143950743),
('Charles Stewart Mott Foundation', 2000, 139480791),
('William and Flora Hewlett Foundation', 2000, 135748270),
('Annenberg Foundation', 2000, 132384109),
('Open Society Institute', 2000, 116342544),
('Kresge Foundation', 2000, 107956140),
('Robert R. McCormick Tribune Foundation', 2000, 106830351),
('Duke Endowment', 2000, 106030389),
('Annie E. Casey Foundation', 2000, 101012809),
('Searle Patients in Need Foundation', 2000, 95975582),
('Bristol-Meyers Squibb Patient Assistance Foundation', 2000, 94805585),
('McKnight Foundation', 2000, 93954410),
('Richard King Mellon Foundation', 2000, 91699221),
('Lilly Cares Foundation', 2000, 86650335),
('Doris Duke Charitable Foundation', 2000, 86310650),
('San Francisco Foundation', 2000, 86000000),
('Bank of America Foundation', 2000, 85737445),
('Greater Kansas City Community Foundation and Affiliated Trusts', 2000, 85426000),
('W. M. Keck Foundation', 2000, 81745562),
('Janssen Ortho Patient Assistance Foundation', 2000, 81294984),
('California Community Foundation', 2000, 78300000),
('Harry and Jeanette Weinberg Foundation', 2000, 77329311),
('John S. and James L. Knight Foundation', 2000, 70746766),
('Donald W. Reynolds Foundation', 2000, 69363245);
-- The following are from Foundation Growth and Giving Estimates: 2000 Preview.
-- The Foundation Center. p8.
insert into giving (foundation, year, giving) values
('Lilly Endowment', 1999, 558287507),
('Bill & Melinda Gates Foundation', 1999, 549432864),
('Ford Foundation', 1999, 514400551),
('David and Lucile Packard Foundation', 1999, 391568231),
('Robert Wood Johnson Foundation', 1999, 290249646),
('Pew Charitable Trusts', 1999, 211053071),
('Robert W. Woodruff Foundation', 1999, 191355356),
('W. K. Kellogg Foundation', 1999, 186605961),
('California Endowment', 1999, 178411043),
('Andrew W. Mellon Foundation', 1999, 161501133),
('John D. and Catherine T. MacArthur Foundation', 1999, 158582350),
('Open Society Institute', 1999, 152974312),
('Rockefeller Foundation', 1999, 149343068),
('Starr Foundation', 1999, 143822676),
('Annenberg Foundation', 1999, 133487973),
('New York Community Trust', 1999, 130680652),
('Charles Stewart Mott Foundation', 1999, 116137110),
('California Community Foundation', 1999, 113449501),
('Kresge Foundation', 1999, 112710216),
('Arthur S. DeMoss Foundation', 1999, 104283341),
('Robert R. McCormick Tribune Foundation', 1999, 104000582),
('Annie E. Casey Foundation', 1999, 103944570),
('Ford Motor Company Fund', 1999, 97789429),
('McKnight Foundation', 1999, 92244785),
('Bank of America Foundation', 1999, 90999532),
('William and Flora Hewlett Foundation', 1999, 87504410),
('Richard King Mellon Foundation', 1999, 87310739),
('Duke Endowment', 1999, 80230455),
("Wallace-Reader's Digest Funds", 1999, 72860231),
('W. M. Keck Foundation', 1999, 71469431),
('Harry and Jeanette Weinberg Foundation', 1999, 69520562),
('Greater Kansas City Community Foundation and Affiliated Trusts', 1999, 68089627),
('Walton Family Foundation', 1999, 66492594),
('Wal-Mart Foundation', 1999, 65533778),
('Andy Warhol Foundation for the Visual Arts', 1999, 65418614),
('Cleveland Foundation', 1999, 64106792),
('SBC Foundation', 1999, 64047020),
('San Francisco Foundation', 1999, 63977233),
('Janssen Ortho Patient Assistance Foundation', 1999, 63621898),
('William Penn Foundation', 1999, 62045928);
-- The following are from Foundation Growth and Giving Estimates: 1999 Preview.
-- The Foundation Center. p8.
insert into giving (foundation, year, giving) values
('Ford Foundation', 1998, 440400415),
('Lilly Endowment', 1998, 425188708),
('Robert Wood Johnson Foundation', 1998, 289143569),
('David and Lucile Packard Foundation', 1998, 263929118),
('W. K. Kellogg Foundation', 1998, 202919594),
('Pew Charitable Trusts', 1998, 161411658),
('New York Community Trust', 1998, 144912318),
('Andrew W. Mellon Foundation', 1998, 142216007),
('Open Society Institute', 1998, 124623703),
('John D. and Catherine T. MacArthur Foundation', 1998, 123517237),
('Annenberg Foundation', 1998, 118024650),
('Rockefeller Foundation', 1998, 113750622),
('Bill & Melinda Gates Foundation', 1998, 113409103),
('Soros Charitable Foundation', 1998, 108850000),
('California Endowment', 1998, 103551300),
('Starr Foundation', 1998, 102786430),
('Moody Foundation', 1998, 101450662),
('Annie E. Casey Foundation', 1998, 91718780),
('Robert W. Woodruff Foundation', 1998, 86658324),
('William and Flora Hewlett Foundation', 1998, 85406493),
('Robert R. McCormick Tribune Foundation', 1998, 84725417),
('Charles Stewart Mott Foundation', 1998, 84725385),
('Kresge Foundation', 1998, 82317669),
('Duke Endowment', 1998, 77377296),
('McKnight Foundation', 1998, 72337002),
("Wallace-Reader's Digest Funds", 1998, 64243554),
('Houston Endowment', 1998, 63906488),
('King Pharmaceuticals Benevolent Fund', 1998, 62808564),
('Richard King Mellon Foundation', 1998, 61820958),
('Donald W. Reynolds Foundation', 1998, 61088117),
('California Community Foundation', 1998, 59441929),
('Weingart Foundation', 1998, 57378823),
('Harry and Jeanette Weinberg Foundation', 1998, 55824037),
('J. A. & Kathryn Albertson Foundation', 1998, 55710174),
('Brown Foundation', 1998, 55349908),
('William Penn Foundation', 1998, 55084327),
('Janssen Ortho Patient Assistance Foundation', 1998, 53561111),
('Bank of America Foundation', 1998, 53200397),
('Whitaker Foundation', 1998, 52924141),
('W. M. Keck Foundation', 1998, 51447000);
-- The following are from Foundation Growth and Giving Estimates: 1999 Preview.
-- The Foundation Center. p7.
insert into giving (foundation, year, giving) values
('Ford Foundation', 1997, 390559000),
('Lilly Endowment', 1997, 254113000),
('Robert Wood Johnson Foundation', 1997, 241544000),
('David and Lucile Packard Foundation', 1997, 173074000),
('W. K. Kellogg Foundation', 1997, 260838000),
('Pew Charitable Trusts', 1997, 211880000),
('New York Community Trust', 1997, 87804000),
('Andrew W. Mellon Foundation', 1997, 118541000),
('Open Society Institute', 1997, 96843000),
('John D. and Catherine T. MacArthur Foundation', 1997, 156977000),
('Annenberg Foundation', 1997, 105218000),
('Rockefeller Foundation', 1997, 99263000),
('Bill & Melinda Gates Foundation', 1997, 18899000),
('Soros Charitable Foundation', 1997, 37842000),
('California Endowment', 1997, 68577000),
('Starr Foundation', 1997, 74932000),
('Moody Foundation', 1997, 32084000),
('Annie E. Casey Foundation', 1997, 81730000),
('Robert W. Woodruff Foundation', 1997, 45875000),
('William and Flora Hewlett Foundation', 1997, 38649000),
('Robert R. McCormick Tribune Foundation', 1997, 48345000),
('Charles Stewart Mott Foundation', 1997, 77539000),
('Kresge Foundation', 1997, 72160000),
('Duke Endowment', 1997, 52488000),
('McKnight Foundation', 1997, 76198000);
-- The following are from Foundation Yearbook 2002 Edition. The Foundation
-- Center. p21.
insert into giving (foundation, year, giving) values
('Ford Foundation', 1990, 227828000),
('J. Paul Getty Trust', 1990, 9086000),
('Lilly Endowment', 1990, 107931000),
('W. K. Kellogg Foundation', 1990, 121974000),
('John D. and Catherine T. MacArthur Foundation', 1990, 115676000),
('Pew Charitable Trusts', 1990, 155114000),
('Robert Wood Johnson Foundation', 1990, 112023000),
('Rockefeller Foundation', 1990, 74414000),
('Andrew W. Mellon Foundation', 1990, 74467000),
('Kresge Foundation', 1990, 48792000);

Notes on hits-based giving project

Figuring out the "top twenty foreign aid foundations", 1975–2000

The Foundation Center has a sorted table by both total giving and by assets, but their data is yearly and begins in 2002. See e.g. top 50 by total giving. It also has some older reports (starts in 1997). It looks like the Foundation Center used to publish (1972–2001) an annual report called The Foundation Grants Index. Google Books has a list but no preview. UW seems to have at least one.

It looks like there used to be (or still is) an annual report called the Foundation Reporter (maybe officially the "Taft Foundation Reporter", as it seems to be published by the Taft Group). Self-description taken from a purchase page:

Known throughout the fundraising community for its depth of content, Foundation Reporter gives you all the important contact, financial, and grant information you'll need. This comprehensive resource covers the top 1,000 private foundations in the U. S. that have at least $10 million in assets or whose annual giving totals $500,000 or more.

41st edition in 2009, so the first one began in 1969?

See also the "Related books" section here.

Who Gets Grants/who Gives Grants.

The Library of Congress has a list of "Foundation and Grant Resources". The list includes both the Foundation Reporter and the Foundation Grants Index, as well as around 20 other publications (most of annual frequency). These all look like print publications though.

The Foundation Center also has something called the Foundation Yearbook, which sounds promising, but it is unclear if it is online. Description:

Foundation Yearbook, 2002 Edition, documents the growth in actual number, giving, and assets of all active U.S. foundations from 1975 through 2000 and provides estimates of foundation giving through 2001.

(Update: it turned out that the 1975–2000 data was all aggregated. For individual foundations, only the data around 1999/2000 was included.)

The Foundation Center's Foundation Growth and Giving Estimates (2000 Preview) has a list of top 100 foundations by total giving in 1999 along with the total giving numbers. For our purposes the ones for 2001 and 1999 are also useful. Since these publications cover giving for the year prior, this gives us top foundation giving data for years 1998–2000. I think this is just for United States foundations.

Some information about time-limited foundations and their giving amounts by Center for Strategic Philanthropy and Civil Society.

Waldemar A. Nielsen's book The Big Foundations (1972) seems to be quite well-known. Apparently it covers the 33 biggest foundations of its time. The following list, taken from the table of contents given in a book review, gives 24:

  • Carnegie
  • Rockefeller
  • Ford
  • Danforth
  • Kellog
  • Surdna
  • Bush
  • Pew
  • Irvine
  • Du Pont
  • Lilly
  • Hartford
  • Duke
  • Sloan
  • Kettering
  • Mott
  • Mellon
  • Astor
  • Woodruff
  • Kresge
  • Waterman
  • Kaiser
  • Fleischmann
  • Commonwealth

Holden has a spreadsheet of some philanthropic success stories.

Reading more broadly in the history of philanthropy

Some interesting quotes from "Looking Back at 50 Years of U.S. Philanthropy", commissioned by the Hewlett Foundation:

The share of total assets held by the 50 largest foundations has dropped since the establishment of the Hewlett Foundation—as of 2014, that group held "only" nearly 30 percent of total assets—but this is largely the case because the class of "mega-foundations" has expanded, as discussed below. The concentration is still pronounced.

If the top-heavy nature of the sector has remained relatively constant, the identities of those foundations at the top have not; the upper reaches of the sector have been especially prone to flux. When Waldemar Nielsen examined the largest foundations (those with more than $100 million in assets) in 1968, he noted that only five were on a comparable list from three decades before. When he examined the largest group again in 1984 (now defined as those with more than $250 million in assets), he found that more than a third of his group from 1968 had fallen off the rankings.

Today, an equivalent ranking of the top 36 foundations contains 21 names that did not appear on the 1985 list. The churning continues, accelerated by the introduction of a large cohort of newly established foundations. More than half of the top 30 largest foundations in 2014 were established or received the bulk of their funds since the establishment of the Hewlett Foundation; a third were established or received the bulk of their funds in the last two decades.

Speaking of the Ford Foundation's grants to support the civil rights movement:

Waldemar Nielsen estimated that only 10 percent of Ford's outlays could be considered experimental or activist in any respect; the figure for most other large foundations he put at closer to 1 percent. Mary Anna Colwell, a political scientist who reviewed the "public policy grants" of the largest foundations between 1972 and 1975 has documented that Ford accounted for more than half of them.

Indeed, when the Peterson Commission inquired of foundations whether they had made any controversial grants in the years between 1966 and 1968—and this would include nearly all grants meant to influence public policy—only 1 percent of the foundations that responded did so in the affirmative, and the grants they specified made up only 0.1 percent of their total outlays. At the time of the Hewlett Foundation's founding, most foundations simply had little inclination to challenge the status quo.

The paper goes on to note that foundations became more business-oriented in the 1970s and 1980s, and that it was not until the 1990s that the philanthropic sector would be called "strategic philanthropy".

"Venture philanthropy" apparently began in the 1990s; "Virtuous Capital: What Foundations Can Learn from Venture Capitalists" – the paper that supposedly helped to develop the idea – was published in 1997. Another quote (page 33):

Perhaps [venture philanthropy's] most striking element, and one that has attracted funders who do not explicitly align themselves with the movement (such as a new corps of "hacker philanthropists"), is its propensity for risk-taking. Like venture capitalists themselves, who might fund scores of start-ups in search of one "unicorn," venture philanthropists were not afraid of failure. They would take "big bets" on grantees whose programs might have low probabilities of success but enormous social impact if successful. This talk of riskiness would have mystified funders from a half century ago. First, they would have feared it would threaten to topple the bulwarks of legitimacy that they had constructed in light of public censure and philanthropy's declining status relative to the corporate and public sectors. Also, because their conception of philanthropic support was frequently so open-ended, long-term, and fluid, they would have found it difficult to arrive at definitive judgments of success or failure over a few grant cycles. The comfort many funders now have with the incorporation of failure into the grantmaking process is another sign of how entrenched an entrepreneurial mindset has become in the sector over the last few decades.

So the whole idea of "hits-based giving" might be nonexistent before the 1990s.

From Bishop and Green, Philanthrocapitalism (one of the books cited by "Looking Back at 50 Years of U.S. Philanthropy"):

Turner is one of a group of philanthrocapitalists whose skill in business is taking big bets based on big ideas, an approach that also characterizes their giving. The contrast with the data-obsessed hedge fund philanthropists could hardly be greater. Whilst some of them won't give away a penny without months of due diligence and clear, readily monitorable goals, Turner picked a cause that is certainly of huge importance to humanity but whose progress he will never be able to prove with hard evidence. Pushed on whether he is really sure his gift was worth making, he laughs and says, "I don't know. You want to think you made a positive difference," in a way that makes it clear he thinks the question itself is silly. It is hard enough to demonstrate success of any sort in the big-picture things that the U.N. is involved in, much less the impact of a particular financial contribution to the organization's work.

"Very Large Foundations" (author unknown) discusses Nielsen's Golden Donors, and notes that large foundations have little interest in philanthropy as they start out, but are forced to become more "professional" over time, due to embarrassment if they are found to be "strikingly inept". This "professionalizing" force apparently acts less on smaller foundations, as these attract less attention from the public. It quotes Nielsen's book: "Far from being wise, farsighted, public-spirited, purposeful benefactors, many of the big donors set up their foundations if not in a fit of absent-mindedness then simply as part of tidying up their affairs."

There are several articles I have found that discuss concepts similar to "hits-based giving" but that do not use that phrase:

Upward and downward biases in estimates of the value of hits-based giving

  • Skill. If hits-based giving only became developed in the 1990s, then what might look like "hits-based giving" from before that period might be more like "random giving". So looking at the period 1975–2000 might bias us against hits-based giving if the skill with which foundations select "risky bets" has improved faster than the skill with which foundations select "proven, evidence-based" programs.

  • Low-hanging fruit. Holden found the impressive accomplishments of philanthropy to be earlier: "Though the Casebook focuses on more recent philanthropy (78 of its 100 cases are post-1950), 9 of the 14 cases I found most impressive are pre-1950 (and a 10th is from 1952)." Looking at past "hits" might bias us toward hits-based giving unless we adjust for this (but how much do we adjust?).

Looking at foundations' websites

Some foundations seem to have detailed databases going back to at least 1975, e.g. Andrew W. Mellon Foundation (~$2 billion from 1969–1999).

The Packard Foundation was founded in 1964, but their grants database only goes back to 2012.

Similarly, Hewlett Foundation was founded in 1966, but their grants database only goes back to 2000. The IATI data that I compiled in September 2016 only goes back to 2006.

Rockefeller Foundation has a grants table but fixing the "end date" to 01/01/2005 reveals that there are no grants recorded in our period of interest. Rockefeller does seem to have some annual reports scattered, e.g. one for 1969 (but no clear listing of total grant amounts).

Ford Foundation grants table goes back to 2006.

W. K. Kellogg Foundation has a grants table that goes back to 2008.

Atlantic Philanthropies has data before 2000 according to Vipul.

AidData has some datasets, but they seem pretty spotty in coverage.

Open Aid Data starts in 2000.

Looking at the big foundations

Naive top foundations list (using current US dollars), derived from foundations.sql.

The Bill & Melinda Gates Foundation is good. There is detailed IATI info but there are few grants before 2009. Founded in 2000, but there were two predecessor organizations.

The Ford Foundation seems to have annual report PDFs online, e.g. 1999. They also have an online grants database, but that only covers 2006–present.

Robert Wood Johnson Foundation: 'The foundation's goal, through the use of grants, is "to improve the health and health care of all Americans."[3]' (from Wikipedia page)

Lilly Endowment is focused on the US. (Wikipedia page)

David and Lucile Packard Foundation: grants database goes back to 2012, and Google search makes me think they don't even publish annual reports.

W. K. Kellogg Foundation has foreign aid grants; example, but their grants database goes back only to 2008. Kellogg also seems to have annual reports, example. Looking at Kellogg's list of grants from the 1999 annual report, I can't say they're hits-based or "proven, evidence-based"; it seems to me like a random mix of feel-good programs.

Pew Charitable Trusts ... can't find good information on activity.

Andrew W. Mellon Foundation does not seem to give in foreign aid.

Robert W. Woodruff Foundation seems to be limited to funding in Atlanta.

The California Endowment seems to fund only in California.

The Ford Motor Company Fund seems focused on the US.

John D. and Catherine T. MacArthur Foundation has a section of their work that they describe as "Big Bets". One of these "big bets" is a series of grants in Nigeria. However all the grants to this program are from 2015 or later. The foundation also has pages on human rights and international peace and security that could count as foreign aid.

The Rockefeller Foundation seems to have some foreign aid grants.

The Starr Foundation: based on the list of grants on Wikipedia, the Wikipedia page for the foundation, and the foundation's press released page, it looks like almost all of the grants are outside of foreign aid.

Open Society Institute (now the Open Society Foundations) seems to have grants in the relevant areas.

The New York Community Trust gives around New York.

The Charles Stewart Mott Foundation seems to mainly operate in Flint, Michigan, but also has some grants, e.g. in South Africa and their "global philanthropy" grants that might count as "foreign aid".

The William and Flora Hewlett Foundation has a lot of international aid grants. (Disclosure: I made the grants tables.)

Annenberg Foundation: "Recipients starting in year(s) 2010 to present" in their interactive map. Sorting by country shows that they do have some grants that would count as foreign aid.

California Community Foundation looks pretty California-focused.

Kresge Foundation describes their grants page as "A database of grants awarded since 2009, updated quarterly." Looking at the list of locations, it looks like they operate only in the US.

Soros Charitable Foundation seems to be related to Open Society Institute because they're both related to Soros, but I'm not sure. There doesn't seem to be a separate website for Soros Charitable Foundation. Foundation Center's description makes it seem like it doesn't do much foreign aid stuff.

Robert R. McCormick Tribune Foundation has grants info that starts in 2010. It's Wikipedia page seems to show it only operates in the US.

Duke Endowment grants map seems to show they only operate in the US. The Wikipedia page says it serves "the people of North Carolina and South Carolina".

Arthur S. DeMoss Foundation seems to be focused on religious stuff, and I haven't seen a lot of information about their grantmaking.

Annie E. Casey Foundation seems focused on the US. The foundation's site map doesn't indicate anything outside the US either.

Moody Foundation seems focused on Texas, looking at the Wikipedia page and its recent grants.

Searle Patients in Need Foundation doesn't seem to have a website or Wikipedia page. Going by the name, it looks like it doesn't seem to do foreign aid.

Bristol-Meyers Squibb Patient Assistance Foundation seems to only serve the US.

McKnight Foundation Wikipedia page reveals that the foundation's "primary geographic focus is the state of Minnesota, with significant support also directed to strategies throughout the U.S. and in Africa, Southeast Asia, and Latin America"

Richard King Mellon Foundation has a "recent grants" page that begins in 2011. It looks like grantmaking is focused in Pennsylvania.

Bank of America Foundation: there is a "Philanthropic Solutions" grant search tool that lists grants in the US, but it's not clear if this is part of the foundation.

Lilly Cares Foundation seems to operated in the US.

Doris Duke Charitable Foundation has grants info going back to 1997, and has an "African Health Initiative" that lists some foreign aid-ish grants.

San Francisco Foundation is a community foundation, so I think it operates mainly in California or the Bay Area, but its investment page does mention "Global Equity" under asset allocation; it's hard to find more details on the website though.

Greater Kansas City Community Foundation and Affiliated Trusts is another community foundation and says on its website: "The mission of the Greater Kansas City Community Foundation is to improve the quality of life in Greater Kansas City".

W. M. Keck Foundation: Wikipedia page indicates it mostly focuses on basic science research. The foundation website doesn't really indicate anything different.

Janssen Ortho Patient Assistance Foundation seems to operate in the US.

Harry and Jeanette Weinberg Foundation seems to focus on the US. The Wikipedia section doesn't say much, the listed program areas don't look like foreign aid, and even its "basic human needs and health" shows that the geographic focus is the US.

Wallace-Reader's Digest Funds or the Wallace Foundation Wikipedia page indicates they seem to do education stuff but only in the US?

-- Use with foundations.db
select foundation, sum(case when year=1968 then assets else 0 end) as assets_1968, sum(case when year=1984 then assets else 0 end) as assets_1984 from assets group by foundation limit 5;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment