Data Visualization Contest
All the data from UNDG Transparency Portal are made available in XML dump. CSV format could be generated from datastore as explained below. XML data are directly sourced from IATI Registry for each of the listed UN agencies.
The data from the following UN agencies and observers are available in the dump file.
- The World Bank
- United Nations Children's Fund
- United Nations World Food Programme
- [United Nations Development Programme] (https://iatiregistry.org/publisher/undp)
- United Nations Central Emergency Response Fund
- United Nations Population Fund
- United Nations Educational, Scientific and Cultural Organization
- United Nations Office for Project Services
- UN Women
- United Nations Office for the Coordination of Humanitarian Affairs
- UN-Habitat
- International Fund for Agricultural Development
- UNITAID
- United Nations Capital Development Fund
- International Labour Organization
- Joint United Nations Programme on HIV/AIDS
It is recommended that you use XML file for your visualisations as XML contains all the elements, maintaining the structure of the standard. However you will need to be aware of the standard and its elements. There are two major versions of IATI Standard - versions 1.05 and V2.02.
API is available from datastore. You need to make sure that you use the right organisation identifier to get the UN data.
You may find the organisation identifier from IATI Registry.
- Go to Publishers' list and search for the UN agency
- Go to publisher's page. For example, see UNDP page
- You will see that UNDP has identifier "XM-DAC-41114"
- Use this identifier to get the UNDP IATI data
http://datastore.iatistandard.org/api/1/access/activity.xml?reporting-org=XM-DAC-41114 gives the 50 activities information of UNDP. Follow API documentation to get further results.
If you want to get the UNDP activities for a country say Nepal, then you need to know the code for Nepal. You may see the country codes here.
http://datastore.iatistandard.org/api/1/access/activity.xml?reporting-org=XM-DAC-41114&recipient-country=NP gives 50 activities for which recipient-country is Nepal.
- Download XML dump in gz format
- Use gunzip (in linux, mac) or 7-zip (in windows) to unzip the dump
- You need to parse the XML by yourself to get the data. Note there are 2 major version - V1.05 and V2.02 and you will need to write two different parsers for different versions as they are different significantly.
There are 3 different tyoes of CSV - activities, transactions and budgets. Follow the process below to get the CSV data.
- Go to Datastore CSV Query Builder
- Select the appropriate options (activities/transactions/budgets) and UN agency/agencies you are interested in
- Click download to get the data in CSV format.
If you have any query regarding the data, please create an issue in the github. One of us will get back to you in the github itself.