‘Once you’ve decided what information you want, you can choose how the data is presented’
What is the IATI Datastore CSV Query builder?
The CSV Query Builder was designed for users with limited technical expertise. The tool works with the older IATI Datastore and lets you obtain data directly in CSV format. It has pre-set filters for the most common data queries to help you get the information you want.
You can create IATI data queries based on who reported the information, where the activity is located, and the sector that the activity occurs in. You can also specify start and end dates to get data on activities over a specified period.
Once you have decided what information you want to query you can choose how you want the data to be presented. The options allow you to configure the way in which the data is disaggregated, making different sorts of analysis possible. You can have the data split by activities, transactions or budgets. And you can choose whether you want these further disaggregated by sectors or countries.
We are in the process of outsourcing the development of a new Datastore. The current Datastore is an alpha version, which means that it does not yet contain all the planned features and may return unexpected results.This is also true for the CSV Query Builder. The alpha version is intended for user testing and feedback and, while you are encouraged to use it, it should not be considered a stable product.
Why use the CSV Query Builder?
Unlike a number of other IATI data use tools, the CSV query builder shows you activities and data that may be invalid, that is, they do not meet all the rules of the IATI data standard. This means you can sometimes locate data that is not presented by other tools.
Activities - In IATI each activity ID should be unique. However, this is not always the case. Many tools, such as d-portal, will present only one activity result for each activity ID, whereas the query builder will display all the activities recorded for each activity ID.
Finances - You can use the query builder to see details of individual transactions, or you can look at the aggregated finances for an activity, for example total expenditure or total incoming funds. The CSV Query Builder will let you know if a currency has been specified, if the result is in a mix of currencies or if the currency is unknown.
Filters - Although the CSV query builder has limited filters to select from, you can always download a broader range of activities and transactions. Once these are in a CSV file, you can add filters to select only the data you want. For example, you could filter by the type of participating organisation, say, donor or receiver.
Users with technical expertise can work directly with the Datastore to create more complex or bespoke queries.
Who maintains the CSV Query Builder?
For queries relating to the data itself, contact the relevant publisher directly. You can find all publisher contact details in the IATI Registry.
The CSV Query Builder is the front end of the IATI Datastore. Due to current technical team commitments, the IATI Board decided in March 2018 to outsource development of a new Datastore. There is a clear need for a new product that provides a robust, timely and comprehensive data service that data use tools, such as the CSV Query Builder, can use.