You can search, display and export DAC Aid Statistics from OECD.Stat. Aid related data sets can be found under Themes/Development. The screen shot below shows which tables can be found under the different Development headings and their main parameters. For more detail on the data in each table, see the abstract which can be accessed by clicking on the (i) symbol.
OECD.Stat - screen functions overview
Hints and tips
Table descriptions (abstracts)
Tables on aid statistics can be found in stats.oecd.org by searching under themes and selecting development. Here you will find a menu of headings. Click on the + symbol to see the tables under a heading. Select a table by clicking on it. To see an abstract of the table parameters, click on the “i” symbol.
Refining a search once a table is selected
Once a table has been selected, a specific set of menus with various table dimensions will appear on top of the data table allowing you to refine your search by donor, recipient, type of aid, sector etc.
Creating a chart
As with many charting functions, care needs to be taken with selecting a data set of reasonable size. Click on the chart tab then follow on-screen prompts if the selection is too large. Further refine your selection by using the functions under the customise tab. Alternatively, export the data and create a chart using any other suitable software you may have.
Finding project data
Select the CRS data table and refine your search using the menus at the top of the datatable. Once your answer is displayed, click on the magnifying glass icon to see the list of projects.
Click on the export tab and select the file format you require for your selected data. You can also download the entire data table selected by clicking on Related Files under the export tab then clicking on Full Dataset in the dialogue box.
All .csv files can be opened in the Excel 2007 or later (use a vertical bar | as delimiter and ” (double-quotes) as text qualifier) or any other software (for example Access, STATA, etc.) that allow more than 65,000 rows.
Negative figures in the data displayed
When viewing net ODA figures, a negative figure would relate to a year when repayments by a recipient country on loans were larger than ODA received or they could indicate recoveries on grants.
When ‘..’ or ‘-‘ is displayed
These characters are displayed when no data are recorded.
How to view project level micro-data
Project-level microdata is available in the Creditor Reporting System dataset which can be found under the Individual aid projects (CRS) tab under the Development theme. Once you have opened this dataset and refined your search, the data displayed has a magnifying glass icon for each cell. Click on the magnifying glass to view the first 1000 lines of project-level microdata. You can view more than 1000 lines of microdata in this dataset using QWIDS; first check the box: Show project-level data and/or detailed sector level data (CRS), complete your search terms, display the data then click on underlined data to see microdata.