The OECD is making all its CRS 2011 and 2012 data available in IATI XML format, by donor and by recipient. Data now cover all donors that report to the CRS: 26 of the 29 DAC members (the newest Members Poland, the Slovak Republic and Slovenia will start reporting to the CRS from this year), and 21 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.
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.
In a next step, the OECD will make the annual DAC forward spending survey available in XML format.
What do you need to know?
- We have used the latest version of the IATI standard (version 1.02).
- Each CRS record has its own IATI unique identifier (see method below).
- Data presented are for years 2011-2012, for DAC Members (DAC Countries + EC), non-DAC members and multilateral organisations.
- All amounts are in US dollars, without decimals.
- Field contents are expressed in English (except for descriptive fields which may contain national language/descriptive texts).
Please see below the additional general and technical notes in relation to the implementation of the CRS-IATI XML file.
The CRS-IATI XML files have been compressed and loaded on the FTP site http://vs-web-fs-1.oecd.org/crs-iati-xml
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.).
Current version of IATI standard is version 1.02 (http://wiki.iatistandard.org/standard/documentation/1.02/start).
Format for reporting organization and participating organizations (as advised by IATI) :
<reporting-org ref="OECD">Organisation for Economic Co-operation and Development</reporting-org> OECD
<participating-org role="funding" type="10" ref="GB">United Kingdom</participating-org> Country name
<participating-org role="extending" ref="GB-1">Department for International Development</participating-org> agency
<participating-org role="implementing" ref="51000">University, college or other teaching institution, research institute or think-tank</participating-org> channel
The IATI identifier is the concatenation of the unique organisation identifier (donor and agency code), the reporting year and the crsid.
IATI_id = ISO2 Donor code - agencycode - reportingyear – crsid
ex : AT-1-2010-1990006002
Management of tied aid:
If a commitment exists and if this commitment is equal to amountuntied then Tied status = 5 (Untied)
If a commitment exists and if this commitment is equal to amountpartialtied then Tied status = 3 (Partially Tied)
If a commitment exists and if this commitment is equal to amounttied then Tied status = 4 (Tied)
Otherwise, tying status is NULL
For more information please contact us at firstname.lastname@example.org.
International Development Statistics (IDS) online databases