Which countries give or receive bilateral aid donations, how transparent are aid organizations, does aid received relate to spending on health or education, does it affect the flow of information? Questions like these arise when asked to visualize world aid flow and aid transparency.
To tackle these questions I looked at data from the World Bank, Publish What You Fund, and Google's Transparency Report and created this interactive visualization. The numbers shown are from the year 2010, which is the most recent year with data available on both bilateral aid and aid transparency at the time of creation.
The aid donations data is comprised of Net bilateral aid flows from DAC donors numbers available from the World Bank. For example, the total for the United States is the sum of all donations given to ODA recipients in 2010.
Official development assistance does not include donations from individuals or private organizations. Moreover, it doesn't include military support and the like. See the description of the bilateral aid flow from the US indicator for more information.
Bilateral aid flow is shown on the choropleth map on top. Countries colored in red received aid and those in blue donated. The darker the colors the higher are the total aid amounts or aid amounts in relation to population or GDP.
Connections between countries are displayed as arcs when the mouse is moved over a country, their thickness corresponds to the aid money given or received. When you click on a country on the map a bar chart with details on aid flow between this and connected countries is displayed.
Next to the map there are two bar charts, one ranking donating countries by aid given and one showing the corresponding Aid Transparency Assessments from Publish What You Fund.
The lower part of the visualization shows more information about countries receiving aid. The scatter plot compares aid money to selected world development indicators from areas like health, education, and communication.
Then again one bar chart ranks countries by aid received and the other one shows corresponding CPIA transparency, accountability, and corruption ratings if available.
From the menu on top you can choose to display total aid amounts (default) or aid in relation to population or GDP. The plus/minus button increases or decreases the number of countries shown in bar charts and scatter plots. By default the top 20 sorted by donations are displayed. For readability reasons the number of countries in scatter plots has an upper limit of 50.
One goal of this visualization is to show which countries give and receive aid money and how givers and takers are connected. Moreover, it provides information on how much money flows between countries in terms of total amounts taken by themselves or in relation to country populations or GDP.
Regarding transparency the numbers from the 2010 Aid Transparency Assessment and the CPIA ratings are abstractions that hide the details of how they are composed. While they don't tell what concrete steps need to be taken to improve the effectiveness of aid, the figures do imply that there was a grave lack of transparency. More recent numbers suggest that organization level transparency slightly improves, but there is still a way to go.
Finally you can compare aid received to different development indicators like mortality rate, life expectancy, money spent on health, education, and military as well as prevalence of communication technologies indicated by telephone lines, Internet users, and mobile subscriptions.
Same as with aid rankings relating total amounts to population or GDP drastically changes the picture. While some indicators seem loosely correlated to aid in relation to population, e. g. spending on education, life expectancy, or number of Internet users, I cannot make out general patterns or get a better idea of how aid money is spent and what effects aid has.
One important part of world aid, i. e. multilateral aid from international organizations like the World Bank or UNICEF, is completely omitted, which limits the informative value of the presented data.
Moreover, data availability varies across countries, see missing CPIA ratings for example. Also I'd prefer to look at more recent figures, the information from Publish What You Fund is more comprehensive for 2011 and 2012, but there is no data yet on bilateral aid in the World Bank dataset for these years.
In a recent post the Guardian Data Blog asked how transparent is world aid data and together with Google started a competition open for submissions until 29 Nov 2012. The task is to visualize the world of aid.
Aid transparency was also the topic of last week's assignment in the highly recommended online course Introduction to Infographics and Data Visualization taught by Alberto Cairo.
Creating this visualization was a valuable experience for me. Regarding my initial questions I have more insights into the world of aid than before, but I also have more questions about it.
Without doubt aid is necessary and aid needs to be more transparent. People who care are interested in how aid is put into practice, how money is spent and how much of it reaches the target. The goals of more aid transparency should by to make aid more accessible, reduce objections and improve aid effectiveness.
Check out the source code used to process the data and create the visualizations.Code Repository
See a sample newsletter issue in your browser.