Aid architecture

OECD converts complete 2012 and 2013 Creditor Reporting System (CRS) data into International Aid Transparency Initiative (IATI) XML format, by donor and by recipient

 

The OECD is making all its CRS 2012 and 2013 data available in IATI 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.

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.

 

-----

 

Technical Notes

What do you need to know?

  • Files were updated on 19 December 2014.
  • 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 2012-2013, 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

 

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.).

 

Specifications

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 dac.contact@oecd.org.

 

Related Documents

 

International Development Statistics (IDS) online databases

Transparency

 

Countries list

  • Afghanistan
  • Albania
  • Algeria
  • Andorra
  • Angola
  • Anguilla
  • Antigua and Barbuda
  • Argentina
  • Armenia
  • Aruba
  • Australia
  • Austria
  • Azerbaijan
  • Bahamas
  • Bahrain
  • Bangladesh
  • Barbados
  • Belarus
  • Belgium
  • Belize
  • Benin
  • Bermuda
  • Bhutan
  • Bolivia
  • Bosnia and Herzegovina
  • Botswana
  • Brazil
  • Brunei Darussalam
  • Bulgaria
  • Burkina Faso
  • Burundi
  • Cambodia
  • Cameroon
  • Canada
  • Cape Verde
  • Cayman Islands
  • Central African Republic
  • Chad
  • Chile
  • China (People’s Republic of)
  • Chinese Taipei
  • Colombia
  • Comoros
  • Congo
  • Cook Islands
  • Costa Rica
  • Croatia
  • Cuba
  • Cyprus
  • Czech Republic
  • Côte d'Ivoire
  • Democratic People's Republic of Korea
  • Democratic Republic of the Congo
  • Denmark
  • Djibouti
  • Dominica
  • Dominican Republic
  • Ecuador
  • Egypt
  • El Salvador
  • Equatorial Guinea
  • Eritrea
  • Estonia
  • Ethiopia
  • European Union
  • Faeroe Islands
  • Fiji
  • Finland
  • Former Yugoslav Republic of Macedonia (FYROM)
  • France
  • French Guiana
  • Gabon
  • Gambia
  • Georgia
  • Germany
  • Ghana
  • Gibraltar
  • Greece
  • Greenland
  • Grenada
  • Guatemala
  • Guernsey
  • Guinea
  • Guinea-Bissau
  • Guyana
  • Haiti
  • Honduras
  • Hong Kong, China
  • Hungary
  • Iceland
  • India
  • Indonesia
  • Iraq
  • Ireland
  • Islamic Republic of Iran
  • Isle of Man
  • Israel
  • Italy
  • Jamaica
  • Japan
  • Jersey
  • Jordan
  • Kazakhstan
  • Kenya
  • Kiribati
  • Korea
  • Kuwait
  • Kyrgyzstan
  • Lao People's Democratic Republic
  • Latvia
  • Lebanon
  • Lesotho
  • Liberia
  • Libya
  • Liechtenstein
  • Lithuania
  • Luxembourg
  • Macao (China)
  • Madagascar
  • Malawi
  • Malaysia
  • Maldives
  • Mali
  • Malta
  • Marshall Islands
  • Mauritania
  • Mauritius
  • Mayotte
  • Mexico
  • Micronesia (Federated States of)
  • Moldova
  • Monaco
  • Mongolia
  • Montenegro
  • Montserrat
  • Morocco
  • Mozambique
  • Myanmar
  • Namibia
  • Nauru
  • Nepal
  • Netherlands
  • Netherlands Antilles
  • New Zealand
  • Nicaragua
  • Niger
  • Nigeria
  • Niue
  • Norway
  • Oman
  • Pakistan
  • Palau
  • Palestinian Administered Areas
  • Panama
  • Papua New Guinea
  • Paraguay
  • Peru
  • Philippines
  • Poland
  • Portugal
  • Puerto Rico
  • Qatar
  • Romania
  • Russian Federation
  • Rwanda
  • Saint Helena
  • Saint Kitts and Nevis
  • Saint Lucia
  • Saint Vincent and the Grenadines
  • Samoa
  • San Marino
  • Sao Tome and Principe
  • Saudi Arabia
  • Senegal
  • Serbia
  • Serbia and Montenegro (pre-June 2006)
  • Seychelles
  • Sierra Leone
  • Singapore
  • Slovak Republic
  • Slovenia
  • Solomon Islands
  • Somalia
  • South Africa
  • South Sudan
  • Spain
  • Sri Lanka
  • Sudan
  • Suriname
  • Swaziland
  • Sweden
  • Switzerland
  • Syrian Arab Republic
  • Tajikistan
  • Tanzania
  • Thailand
  • Timor-Leste
  • Togo
  • Tokelau
  • Tonga
  • Trinidad and Tobago
  • Tunisia
  • Turkey
  • Turkmenistan
  • Turks and Caicos Islands
  • Tuvalu
  • Uganda
  • Ukraine
  • United Arab Emirates
  • United Kingdom
  • United States
  • United States Virgin Islands
  • Uruguay
  • Uzbekistan
  • Vanuatu
  • Venezuela
  • Vietnam
  • Virgin Islands (UK)
  • Wallis and Futuna Islands
  • Western Sahara
  • Yemen
  • Zambia
  • Zimbabwe