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

Letting the Sunshine in: Building Inclusive, Accountable, and Equitable Climate Finance Ecosystems

In April, DG, HackCorruption, and the Thai Youth Anti-Corruption Network hosted a roundtable in Bangkok to discuss climate financing. This blog explores the main takeaway: a multi-disciplinary and multi-stakeholder approach that prioritizes local contexts, inclusive governance, transparency, accountability, and equitable distribution of resources is essential to impactful climate financing.

May 13, 2024 Strategic Advisory Services
Developing Data Systems: Five Issues IREX and DG Explored at Festival de Datos

IREX and Development Gateway: An IREX Venture participated in Festival de Datos from November 7-9, 2023. In this blog, Philip Davidovich, Annie Kilroy, Josh Powell, and Tom Orrell explore five key issues discussed at Festival de Datos on advancing data systems and how IREX and DG are meeting these challenges.

January 17, 2024 Data Management Systems and MEL
Unlocking the potential of digital public infrastructure for climate data and agriculture: Malawi

DG’s DAS Program recently attended an event on creating a national digital public infrastructure (DPI) in Malawi in order to increase the impact of climate data to combat current and future agricultural issues caused by climate change. In this blog, we reflect on three insights on DPIs that were revealed during the event discussion.

December 21, 2023 Agriculture