How to Find, Analyze, and Apply Aid Data

November 4, 2015
Dustin Homer, Paige Kirby, Josh Powell
Aid Effectiveness & Management, News/Events, Open Data

The global community, as represented at the Open Government Partnership (OGP) Summit and beyond, has made strides toward producing a variety of open data, including open aid data. Aid transparency was among the first open data ‘pushes’ in the global development space – leading to a wide range of government, civil society, and donor-sponsored portals. As the open data movement has expanded to include budgetary, contracting, and other sources of information, we felt it was fitting to reflect about how to access and understand where to locate and how to interact with aid data resources.

Opening up aid data requires both political and technical support. The Open Aid Partnership has been working to ensure that open aid commitments are included in country National Action Plans, and the Government of Liberia has included two such commitments in their second action plan. On the technical side, initiatives such as the International Aid Transparency Initiative are working to make these data portals more interoperable and useful, whether for interaction with national budget or other datasets.

So how can we leverage these portals for better analysis and decision making? One of the first steps is understanding how these resources can complement, enrich, and sometimes correct each other.

Let’s take the example of government-validated data from Malawi’s Aid Management Platform (AMP), and donor-reported data from the IATI datastore. Both are included in this Excel download, if you’d like to follow along (note: some data processing, including currency standardization and XML to Excel conversion, has already been performed on the datasets).

<p>AMP and IATI</p>

Figure 1: Examples of data about African Development Bank (AfDB) activities in Malawi from Malawi’s AMP (top) and the IATI Datastore (bottom).

As you can see, AMP (total commitments and disbursements by year) and IATI (transactions) data here are represented a bit differently — this pre-processing was done to save time, as our data exercise focuses on comparing annual figures by funder.

<p>Field Completeness</p>

Figure 2: Analysis of key field completeness.

Over DG’s years of partnership with country government aid data users, we have identified several common key fields critical for ministries of finance and planning. The good news is, for the sub-set of IATI publishers included in this dataset, almost all of those key fields are populated — meaning that IATI data gaps don’t necessarily preclude its inclusion for a more complete picture of aid flows in country, where more funding is available through IATI than AMP.

<p>Comparison by funder</p>

Figure 3: Comparison of AMP and IATI data for selected funders.

In the case of Malawi, not all funding data match well between the IATI and AMP sets; in fact, when we run a comparison between commitment and disbursement numbers, we can find significant differences in reported figures. Some of these discrepancies relate to the timeliness issues highlighted before; other times, differences can be traced to how headquarters may classify funds (i.e., by including overhead or administrative expenses) versus how country offices report funds (i.e., actual amount disbursed in country); based on DG experience, completeness of AMP reporting also tends to correlate with whether or not the donor has official representation in-country. This means that, on the basis of the figures above, IATI data would be a boon to government and development partner users to provide more information about activities by, for example, Canada and UNICEF.

This AMP-IATI exercise aimed to simply scratch the surface of how we as the open data community can interact with aid data. However, better understanding the resources available – as well as the benefits, pitfalls, and nuances of each – can help us improve the way in which open aid data is collected, compared, and ultimately used to make development finance more efficient and effective.

This post is based on Development Gateway’s OGP Summit 2015 workshop session on “How to Find, Analyze, and Apply Aid Data”.

Share This Post

Related from our library

Three Key Takeaways From Discussions on Digital Transformation in Agriculture

Development Gateway: An IREX Venture (DG) hosted a discussion titled "Transforming Food Systems: The Power of Interoperability and Partnerships" at both Africa Food Systems Forum (AGRF) 2023 and the recently concluded ICT4Ag conference. Discussions from these critical events revolved around key themes crucial to DG’s ongoing work, including connecting people, institutions, partners, and systems when we think about technology working at scale to transform agriculture. In this blog, we explore three key takeaways from these conversations.

November 16, 2023 Agriculture
Democratizing Digital or Digitizing Democracy?

The 2023 OGP Summit in Tallinn, Estonia featured a number of discussions centered on open government in the digital age. While the use of digital tools in government is far from a new idea, the COVID-19 pandemic spurred a rapid expansion of this practice, with leaders quickly adapting to remote environments through digitizing government processes

September 19, 2023 Global Data Policy
Two Recommendations for Accelerating Digital Agriculture and Data Use

With the aim of improving the efficiency of agriculture data use, Development Gateway: An IREX Venture (DG), Jengalab, and TechChange—with a grant from the International Fund for Agricultural Development (IFAD)—recently held a learning event, titled “Digital Agriculture: Building the Agricultural Systems of Tomorrow,” in Nairobi, Kenya. Participants identified two key recommendations for advancing digital agriculture in order to increase food security.

August 29, 2023 Agriculture