Download AidData Research Release 1.9.x Dataset

15 April 2010 — As part of our continuing efforts to provide you with the most accurate and comprehensive dataset possible, we're pleased to present the availability of our latest version of the AidData Research Release 1.9.2

Improvements in AidData Research Release 1.9.2

AidData Research Release 1.9.2 fixes a currency conversion issue related to currency conversion for a number of projects from the United Arab Emirates and Iceland. In all, 156 records were fixed.

Improvements in AidData Research Release 1.9.1

AidData Research Release 1.9.1 improves on AidData Research Release 1.9 in the following ways:

  • Adds the following donors: Rainforest Trust Fund, World Bank Carbon Offset Fund, Work Bank Special Financing, World Bank DRF, World Bank Managed Trust Funds, Montreal Protocol Fund, and World Bank Guarantees.
  • Fixes a small number of projects that were mistakenly left out of AidData Research Release 1.9.
  • Fixes a character encoding issue that led to diacritical characters in OECD CRS data being displayed improperly.
  • Adds records to IBRD and IDA that were missing as a result of an error in how we accounted for cofinanced World Bank projects.
  • Adds USD amounts for a handful of currency-year combinations that were missing.
  • Removes line breaks in project descriptions that interfered with user ability in some cases to import data into STATA, SAS, SPSS, and other statistical analysis packages.
  • Updates the 2008 CRS data. AidData Research Release 1.9's 2008 data came from the OECD's December 12, 2009 release of CRS ONLINE. AidData Research Release 1.9.1's 2008 data comes from the February 1, 2010 release of CRS ONLINE.

AidData Research Release 1.9.x Codebook

We've updated and expanded the AidData Research Release codebook. Users should consult the codebook for information on methodologies, data collection, data standardization, field names, and field descriptions.

1.9.x Codebook and User's Guide

Download in PDF format (1.03 MB). Updated Feb 23, 2010.

Custom AidData Research Release 1.9.x Download

Choose the content of your dataset below by choosing the donors, recipients, fields, and years for which you need data. Custom exports are downloaded as ZIP archives which contains a comma-separated value (CSV) file of the records in our dataset meeting your selection criteria. Additionally, the ZIP archive contains a data export receipt in a flat text file, which provides detailed information on the accompanying data file. The names of both files include a timestamp indicating when the export was produced.

IMPORTANT: Selecting the textual description fields such as "long_description" and "short_description" may increase the size of the download significantly. The quickest way to avoid problems in importing this data into the analysis package of your choice is to exclude these fields. We strongly encourage you avoid exporting description fields if they are not needed for your analysis.

Check one or more boxes, or select individual items from each list. Multiple rows may be selected by holding down control (in Windows) or command (in OS X).

Data version






If you'd like to identify a sample of projects related to specific activities, enter your search terms below. Your export will then be limited to records with those terms in the title, short_description, or long_description fields. Enter one term per line.

Please click the generate button only once.

Full AidData Research Release 1.9.x Downloads

The entire data set is available for download in either CSV or SQL format. Because of the number of large number of fields and records in AidData Research Release 1.9, we strongly advise against attempting to work with these files without the aid of a commercial grade database. Most users will be best served by exporting a small subset of data fields, donors, and recipients using the custom export tool above.

For users who wish to store the dataset locally in an SQL database, an unsupported MySQL dump of the dataset is also available to interested parties.

If you have trouble opening these files, consider making a custom cut below or contact us at info@aiddata.org.

NameDescriptionSize
PLAID192_stata.csv.zipA compressed CSV dump of AidData Research Release 1.9.2. which is suitable for import into STATA (long and short descriptions removed)69.5 MB
PLAID192.csv.zipA compressed CSV dump of AidData Research Release 1.9.2.99 MB
PLAID192.sql.zipCompressed SQL dump of AidData Research Release 1.9.2.109 MB
PLAID19_CRS_DISB.csvCSV CRS disbursement records in all Research Releases257.32 MB
PLAID191.csvCSV dump of the main AidData Research Release 1.9.1 table.799.88 MB
PLAID191.sqlFor use with MySQL database server.956.38 MB

AidData Research Release 1.9.x Variable Quick Reference

Row Identifiers
AidData Research Release 1.9 Field NameDescription
temp_plaid19_idTemporary row ID for AidData Research Release 1.9
perm_aiddata_idPermanent ID of a given record in the new PLAID system.
Dates
AidData Research Release 1.9 Field NameDescription
yearReported year in YYYY format
commitment_dateReported commitment date
start_dateStart date
end_dateEnd date
Donor Information
AidData Research Release 1.9 Field NameDescription
donorDonor name
donorcodeISO3 code of Donor Country
umbrellaReported umbrella agency
donor_project_idDonor assigned project ID
crsidCRS ID provided by donor
financing_agencyReported financing agency
contactDonor contacts
role_of_contactRole of Donor Contact
donor_typeIndicates whether donor is bilateral or multilateral
bi_multiIndicates nature of flow
Recipient Information
AidData Research Release 1.9 Field NameDescription
recipientRecipient name in standard QWIDS spelling
recipientcodeISO3 code of Recipient Country
private_recipientPrivate Recipient
implementing_agencyReported implementing agency
channelcodeOECD semi-standarized channel name
channelnameOECD semi-standardized channel name
borrowerReported borrowing party
beneficiaryReported beneficiary party
guarantorReported guarantor
other_involved_institutionsOther involved agencies and institutions
Amounts
AidData Research Release 1.9 Field NameDescription
commitment_amountCommitment amount in reported currency
commitment_amount_currencyCurrency of reported commitment amount
commitment_amount_usd_constantCommitment amount in USD2000
commitment_amount_usd_nominalCommitment amount in nominal USD
total_project_costCost in reported currency
total_project_cost_currencyCurrency of reported cost
total_project_cost_usd_constantCost in USD2000
total_project_cost_usd_nominalCost amount in nominal USD
disbursement_amountDisbursement amount in reported currency
disbursement_amount_currencyCurrency of reported disbursement amount
disbursement_amount_usd_constantDisbursement amount in USD2000
disbursement_amount_usd_nominalDisbursement amount in nominal USD
Cofinancing Information and Amounts
AidData Research Release 1.9 Field NameDescription
cofinancer1_nameReported cofinancer name
cofinancer1_amountCofinancer amount in reported currency
cofinancer1_amount_currencyCurrency of reported cofinancer amount
cofinancer1_amount_usd_constantCofinancer amount in USD2000
cofinancer1_amount_usd_nominalCofinancer amount in nominal USD
cofinancer2_nameReported cofinancer name
cofinancer2_amountCofinancer amount in reported currency
cofinancer2_amount_currencyCurrency of reported cofinancer amount
cofinancer2_amount_usd_constantCofinancer amount in USD2000
cofinancer2_amount_usd_nominalCofinancer amount in nominal USD
cofinancer3_nameReported cofinancer name
cofinancer3_amountCofinancer amount in reported currency
cofinancer3_amount_currencyCurrency of reported cofinancer amount
cofinancer3_amount_usd_constantCofinancer amount in USD2000
cofinancer3_amount_usd_nominalCofinancer amount in nominal USD
cofinancer4_nameReported cofinancer name
cofinancer4_amountCofinancer amount in reported currency
cofinancer4_amount_currencyCurrency of reported cofinancer amount
cofinancer4_amount_usd_constantCofinancer amount in USD2000
cofinancer4_amount_usd_nominalCofinancer amount in nominal USD
Fund Information and Amounts
AidData Research Release 1.9 Field NameDescription
fund1_name
fund1_amount
fund1_amount_currency
fund1_amount_usd_constant
fund1_amount_usd_nominal
fund2_name
fund2_amount
fund2_amount_currency
fund2_amount_usd_constant
fund2_amount_usd_nominal
Descriptive Information
AidData Research Release 1.9 Field NameDescription
titleTitle in English (some CRS records are non-english)
title_original_languageTitle in reported language
short_descriptionCRS short description
long_descriptionLong description in English
long_description_original_languageLong description in original language
additional_infoAdditional information
additional_info_original_languageAdditional information in original language
Flow Details
PLAID 1.9 Field NameDescription
AidData Research Release_flow_typeIndicates type of flow
flow_nameCRS flow type
flow_codeCRS flow code
number_repayments_per_yearNumber of repayments per year
repay_typeRepayment type
loan_termLoan term
grace_periodGrace period
interest_rateInterest Rate
second_interest_rateSecond Interest Rate
grant_elementGrant Element
cancelledIndicates if flow was cancelled
repay_date_firstFirst repayment date
repay_date_lastLast repayment date
untied_amount_usd_nominalUntied amount in nominal USD
partial_tied_amount_usd_nominalPartially tied amount in nominal USD
tied_amount_usd_nominalTied amount in nominal USD
received_amount_usd_nominalAmount received in nominal USD
irtc_amount_usd_nominalAmount of investment related technical cooperation in nominal USD
expert_commitment_amount_usd_nominalExpert commitment amount in nominal USD.
export_extended_amount_usd_nominalAmount of export credit extended in nominal USD
export_credit_amount_usd_nominalAmount of export credit in nominal USD
outstanding_amount_usd_nominalAmount outstanding in nominal USD
arrears_principal_amount_usd_nominalArrears of principal (incuding outstanding_amount_usd_nominal)
arrears_interest_amount_usd_nominalArrears of interest
future_ds_principal_amount_usd_nominalFuture debt service; first year principal
future_ds_interest_amount_usd_nominalFurture debt service; first year interest
interest_amount_usd_nominalInterest Amount in nominal USD
Location
AidData Research Release 1.9 Field NameDescription
regionRegion of recipient
locationReported targeted geographic area
Source Information
AidData Research Release 1.9 Field NameDescription
source_detailURL of record's webpage
sourceSource of data
source_typeSource Type
languageOriginal reporting language
Rio Markers
AidData Research Release 1.9 Field NameDescription
biodiversityIndicates if flow is intended to promote biodiversity
climateIndicates if flow is intended to address climate change
desertificationIndicates if flow is intended to address desrtification
CRS Codes and Markers
AidData Research Release 1.9 Field NameDescription
crs_purpose_codeFive-digit numerical code placing each project in an OECD defined aid sector or subsector
crs_purpose_nameName of the CRS sector code
genderGender equality incorporation Women in Development (WID) marker
tradeTrade Development
pdggIdentifies projects which are intended to enhance elements of participatory development, democratization, good governance and the respect of human rights
ftcIndicates if project is free-standing technical cooperation
sector_programmeDichotomous variable where 1 indicates the project is sector programme aid.
sectorName of the donor-assigned sector
sector_codeCRS sector code
associated_financingIndicates if record has associated financing
initial_reportIndicates if record is an initial report of flow
finance_tCRS financing type
environmental_impact_assessmentEnvironmental impact assessment was performed
environmentProject intended to benefit the environment
investment_projectInvestment project
AidData Research Release Codes
AidData Research Release 1.9 Field NameDescription
plaid_sector_codeAidData Research Release sector code from final code round
plaid_sector_namePLAID sector description
plaid_activity_codePipe seperated PLAID activity codes from final code round
plaid_activity_descriptionPLAID activity code description
plaid_feasibility_studyHas feasability study? From final code round
plaid_technical_assistanceHas TA? From final code round
plaid_generated_crs_purpose_codePLAID Generated Purpose Code
plaid_generated_crs_purpose_namePLAID Generated Purpose Name

Copyright © 2009 AidData - Contact Us