Digital Frameworks

API findings of World Bank's Financial Intermediary Funds


By Jingnan Huo

API findings of World Bank’s Financial Intermediary Funds

World Bank’s Financial Intermediary Funds (FIFs) are formed from contributions of diverse state and non-states partners and are used to address development needs that are not addressed by existing funds and mechanisms. I examined its contributions from 1996-2013, as shown in its database

The Unites States is the largest FIF donor, having contributed $13.4 billion from 1996-2013, with a generally upwards trend.

The ten biggest donors are the US, the UK, France, Germany, Japan, Canada, Norway, EC/EU, IBRD, and Sweden.

Notably, Bill and Melinda Gates Foundation ranks 15 in terms of total amounts donated, before Switzerland, Belgium, Finland, and the Russia. All of its donations are in health($675million) and agriculture & food security($183.7million).

In terms of sector, the United States has donated the most amount into health, followed by climate change and agriculture & food security.

API queries:

  1. ranked amount contribution by donor https://finances.worldbank.org/resource/5b9q-2dex.json?$select=donor_name, sum(amount_in_usd)&$group=donor_name&$order=sum(amount_in_usd)

2.U.S. contributions by Year https://finances.worldbank.org/resource/5b9q-2dex.json?$select=sum(amount_in_usd), calendar_year&$where=donor_name=”United States”&$group=calendar_year&$order=calendar_year

3.U.S. contribution by sector https://finances.worldbank.org/resource/5b9q-2dex.json?$select=sum(amount_in_usd), sector_theme&$where=donor_name=”United States”&$group=sector_theme&$order=sum(amount_in_usd)

4.Contributions of the Gates Foundation https://finances.worldbank.org/resource/5b9q-2dex.json?$select=sum(amount_in_usd), sector_theme&$where=donor_name=”Gates”&$group=sector_theme&$order=sum(amount_in_usd)

Copyright © 2017, Jingnan Huo. All rights reserved.

Created by David Eads and the students of Medill Digital Frameworks. Copyright varies by page and author.