Aid architecture

OECD converts complete 2013 and final 2014 Creditor Reporting System (CRS) data into XML format, by donor and by recipient

 

The OECD is making all its CRS 2013 and final 2014 data available in XML format, by donor and by recipient. Data now cover all donors that report to the CRS including non-DAC countries and multilateral agencies. In addition, separate files are now provided for each donor and each recipient, in order to facilitate the data processing.

These data on development finance can be downloaded in four different formats: Excel, TXT/CSV, PC-axis, and XML. Different formats (such as software development, research, etc.) serve the diverse needs of numerous audiences; therefore, a variety of formats ensures that the data can be used widely and for a multitude of purposes.

This is an important step in making information about development finance easier to extract, locate, and compare. The DAC's CRS is the only international standard able to produce robust activity-level data and reliable statistics on total development finance flows (ODA, OOF, ODF, etc.). The objective of converting CRS data is to ensure that this information has greater visibility and usability.

We are also providing the DAC codelist in XML format (CLv3) in version 2.01 of the IATI Standard. 

XML format is the computer-readable “mark-up” language used by programmers to extract and present data in a comparable and accessible way. Data will now also be comparable to the standard process put in place by the International Aid Transparency Initiative (IATI), with whom the OECD has worked closely together in this exercise.

 

-----

 

Technical Notes

What do you need to know?

  • Files were updated on 8 January 2016 with final and complete 2014 data.
  • We have used the 2.01 version of the IATI standard (http://iatistandard.org/202/upgrades/integer-upgrade-to-2-01/)
  • Each CRS record has its own IATI unique identifier.
  • Data presented are for years 2013-2014, for DAC Members (DAC Countries + EC), non-DAC members and multilateral organisations.
  • All amounts are in local currency as reported by members. They are presented with two decimals.
  • Field contents are expressed in English (except for descriptive fields which may contain national language/descriptive texts).

The CRS-IATI XML files have been compressed and loaded on the FTP site http://vs-web-fs-1.oecd.org/crs-iati-xml

 

General Notes

We have been advised by the IATI Technical Advisory Group on presentation/format of reporting and participating organisations (see code format below). Complete CRS transaction history is not presented as this is technically difficult to retrieve from our database and link the associated transactions. Therefore, each XML record is a separate CRS transaction. In order to reduce the CRS-IATI files size and in accordance with IATI standard 1.02, some of the standard column labels have been omitted (recipient name, etc.).

 

For more information please contact us at dac.contact@oecd.org.