Initiative for Open Ag Funding : Resources

Initiative for Open Ag Funding

Open Ag Funding Resources 

Recommendations for Improving Agriculture Funding Data: Based on conversations with donors, foundations and NGOs working in the sector, the Initiative for Open Ag Funding has identified the need for action in several areas. This overview outlines those actions in addition to 20 priority fields for which data needs to be provided to make agricultural funding data useful.

Full Report: Proposals for Standard Developments: With an emphasis on the IATI standard, this report details actions for data publishers and data standard providers to improve the agricultural data landscape. The report also outlines a complementary data quality framework for agriculture, which can be layered on top of the IATI standard to ensure that data produced is fit to meet user needs.

Overview: Priority Fields and Proposed Changes to IATI Standard: This report provides an overview of recommendations from the Initiative for Open Ag Funding related to which fields organizations should prioritize when publishing data to IATI, as well as proposed changes to the IATI Standard to make it more relevant to those working in the agricultural and food security sector.

Overview: Agriculture-Specific Vocabularies: Based on our consultations on user data needs, we have concluded that it may be helpful for data publishers to code their activities (and transactions) using an agriculture-specific vocabulary in addition to the OECD DAC’s purpose codes. This would enable users to more easily identify which agriculture-related activities are relevant to their work, facilitating coordination and collaboration. This document provides an overview to two agriculture-specific vocabularies that could be used for this purpose: AGROVOC and ANT.

Agriculture Investment Data Needs: Synthesis Report: This report presents the consolidated findings from the Initiative for Open Ag Funding’s consultations with NGOs, donor, and foundations to understand their investment data needs. The consultations suggest that better investment data could have real and positive impacts on efforts to fight hunger and poverty. 

Agriculture Investment Data Needs: NGOs: Based on consultations with multiple International NGOs, this report details the investment data needs of NGOs working in agriculture and food security. To get a wide perspective of data needs, InterAction interviewed a variety of staff, including senior leadership, resource development staff, program staff, and technical specialists.

Agriculture Investment Data Needs: Donors: This report details the investment data needs of bilateral and multilateral donors working in agriculture and food security. To identify these needs, Development Gateway interviewed individuals from the U.S. Agency for International Development, the African Development Bank, the World Bank, the Millennium Challenge Corporation, the U.K. Department for International Development, and the World Health Organization.

Agriculture Investment Data Needs: Foundations: This report outlines the investment data needs of philanthropic foundations currently funding agriculture and food security programs. This study is based on multiple interviews Foundation Center had with various foundations to discuss the capacity for, and use of, data in their work. 

Agricultural Investment Data - Landscape Analysis: This study provides an in-depth analysis of the current landscape of data on agricultural investments. In doing so, it identifies key opportunities and challenges for the Initiative for Open Ag Funding to address in working for a clearer and more reliable picture of agricultural investments worldwide.

  • IATI appendices 1-4: These appendices provide an overview of the International Aid Transparency Initiative (IATI) and explore in detail the agricultural investment data published using IATI.
  • Landscape Analysis Presentation: This presentation summarizes the findings of the landscape analysis.  

Webinar -Supply and demand: improving the open ag funding data landscape: This webinar from the Initiative for Open Ag Funding provides an overview of the Initiative and our initial findings regarding the data needs of donors, NGOs and agricultural practitioners. The webinar also features a presentation on the Initiative’s analysis of the current agricultural investment data landscape and an open discussion on what can be done to improve it.

  • Webinar Presentation: This short presentation summarizes the Initiative and the data needs of various stakeholders.  

Open Ag Funding Newsletters 

November 2016 Edition

September 2016 Edition 

July 2016 Edition 

May 2016 Edition 

IATI Data Tool Inventory


Tools for publishing IATI data

AidStream – AidStream is the publishing tool of choice for organizations with less than 20 projects. It allows users to upload data to the IATI registry by manually entering all of the relevant activity information through drop-down menus and text boxes. 

CSV Converter – This tool converts CSV data into IATI XML data and enables users to pull relevant activity information from across the organization into a single CSV file.  

SQL-To-IATI – The SQL-to-IATI tool generates IATI XML data from activity data stored in a SQL database. It supports enterprise-grade IATI data (DFID uses this tool to publish their full set of 13,000 activities each month).


Please click here for an in-depth description of each publishing tool and a comparison between them.

Tools on the validity and quality of data

IATI Public Validator –The IATI Public Validator allows people to check their IATI XML files by performing basic checks around the XML as well as compliance checks against the IATI Standard (an agreed set of political desires that are not enforced by the IATI schema).

IATI Dashboard – The IATI Dashboard provides a variety of statistics, updates, charts and metrics on IATI data accessed via the IATI Registry. The publishing statistics are meant to help: publishers better understand how to improve their data; users to assess which data is likely to meet their particular needs; and the IATI technical team prioritize its commitments to data quality. The dashboard is generated nightly. For more information on the dashboard, click here.  

Transparency tracker  – Developed by Publish What You Fund, the Transparency Tracker monitors organizations’ progress in making their aid information more transparent.  The tracker allows users to view what information organizations have published in the IATI standard and what the rest of their IATI roadmap holds.

Data error API – The error API allows users to retrieve metadata on the datasets known to the data store and to retrieve detailed data on the errors encountered by the parser.

Tools to view/use IATI data

IATI Datastore CSV Query Builder – This online platform is available to assist users that just want to access the data in CSV format with queries.

d-portal – The d-portal enables data users to view all IATI data by country or by publisher.

Tools to access IATI data (technical users)

IATI Registry  - The IATI Registry provides links to all raw data published using the IATI XML standard.

IATI Datastore – The IATI Data Store is an online service that gathers all data published to the IATI standard into a single queryable source. This can deliver selections of IATI data in JSON or XML formats, or CSV (spreadsheet) for less-technical users. The Datastore can be accessed via an API.

Other helpful references on publishing and using IATI data

IATI Data Store User Guide – This guide features more information on publishing, accessing and using IATI data.

School of Data’s Guide to IATI Data  -This resource provides a comprehensive overview of IATI and how to start using its data.

Open Development Toolkit - This project catalogues development related tools (although not all are for IATI data).