Datastore Query Builder

This tool allows you to build common queries to obtain data from the new IATI Datastore in various formats.

You may create queries based on who is reporting the information, where the activity is happening, and the sector that the activity occurs in. This may then be configured to show individual activities, transactions or budgets.

What information are you looking for?

These options let you filter the information you are looking for. Additional filters are available by querying the datastore directly.

1

Select the data source

WARNING: the datastore contains activities reported by both primary and secondary sources. A secondary source, such as the UNOCHA Financial Tracking Service (FTS), reports data it holds about other agencies’ activities. An agency may well report activities to both IATI and FTS, who in turn reports the same activities to IATI.

2

Select the sector

For more detail of what the sectors are, see the DAC 5 Digit Sector codelist.

3

Select recipient location

Select EITHER a country OR a region

Choosing a Region AND a Country will not return data as most publishers report to either a Country or a Region.

WARNING: Regions do not automatically contain the countries they are made up of.

4

Select additional fields

After
Before
After
Before
5

How would you like to view this information?

These options allow you to configure the way in which your data is disaggregated, making different sorts of analysis possible.


Based on original Datastore Query Builder, which is free software licenced under the GNU General Public License.