Home

What is IATI Datastore?

The Datastore 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.

What is IATI Datastore Classic?

The IATI Datastore was originally built in 2013 by the Open Knowledge Foundation. Code for IATI has updated the software to use Python3 and modern dependencies. Over time, we will include other bugfixes and feature improvements. Our fork of the software is called IATI Datastore Classic.

How does it work?

Data that is recorded on the IATI Registry, and is valid against the standard, is pulled into the Datastore on a nightly basis. This enables people to query for IATI activities across several facets (eg: country, publisher, sector). Activities that satisfy the criteria can then be access in XML, JSON or CSV (spreadsheet) format.

Who is it for?

The Datastore is a service for analysts, data journalists, infomediaries and developers. It is a ‘back-end’ service to streamline the work of those who wish to build applications that can deliver accessible and usable information to a wide range of users.

Why a Datastore?

This repository is called a Datastore, not a database, because it cannot be used as a single dataset. IATI is a publishing standard, not an integral information system. One activity can be reported through IATI by a donor, an implementing organisation and a third-party (secondary-source publisher): in other words you cannot simply add everything together.

How to access the Datastore

  • An API is available that enables people to construct queries.

  • For those wishing to just access the data in CSV format, an online form is available to assist with queries

Are there any limitations on the Datastore?

In its current format the Datastore allows you to filter IATI activities by publisher, organisation type, sector, or country as well as by the date of the most recent update. In future all fields will be queryable.

Query

XML

JSON

CSV

iati-identifier

yes

yes

yes

reporting-org

yes

yes

yes

title

yes

yes

yes

description

yes

yes

yes

participating-org

yes

yes

yes

other-identifier

yes

yes

no

activity-status

yes

yes

yes

activity-date

yes

yes

yes

contact-info

yes

yes

no

activity-scope

yes

yes

no

recipient-country

yes

yes

yes

recipient-region

yes

yes

yes

location

yes

yes

no

sector

yes

yes

yes

country-budget-items

yes

yes

no

humanitarian-scope

yes

yes

no

policy-marker

yes

yes

no

collaboration-type

yes

yes

yes

default-flow-type

yes

yes

yes

default-finance-type

yes

yes

yes

default-aid-type

yes

yes

yes

default-tied-status

yes

yes

yes

budget

yes

yes

no

planned-disbursement

yes

yes

no

capital-spend

yes

yes

no

transaction

yes

yes

no

document-link

yes

yes

no

related-activity

yes

yes

no

legacy-data

yes

yes

no

conditions

yes

yes

no

result

yes

yes

no

crs-add

yes

yes

no

fss

no

no

no

In its current CSV format the Datastore allows three different row outputs: where each row represents an activity, transaction or budget item. In future sub-national geographic information and results reporting will also be available.