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.
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.
| Name | Description | Size |
| PLAID192_stata.csv.zip | A 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.zip | A compressed CSV dump of AidData Research Release 1.9.2. | 99 MB |
| PLAID192.sql.zip | Compressed SQL dump of AidData Research Release 1.9.2. | 109 MB |
| PLAID19_CRS_DISB.csv | CSV CRS disbursement records in all Research Releases | 257.32 MB |
| PLAID191.csv | CSV dump of the main AidData Research Release 1.9.1 table. | 799.88 MB |
| PLAID191.sql | For 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 Name | Description | |
| temp_plaid19_id | Temporary row ID for AidData Research Release 1.9 | |
| perm_aiddata_id | Permanent ID of a given record in the new PLAID system. | |
| Dates | ||
| AidData Research Release 1.9 Field Name | Description | |
| year | Reported year in YYYY format | |
| commitment_date | Reported commitment date | |
| start_date | Start date | |
| end_date | End date | |
| Donor Information | ||
| AidData Research Release 1.9 Field Name | Description | |
| donor | Donor name | |
| donorcode | ISO3 code of Donor Country | |
| umbrella | Reported umbrella agency | |
| donor_project_id | Donor assigned project ID | |
| crsid | CRS ID provided by donor | |
| financing_agency | Reported financing agency | |
| contact | Donor contacts | |
| role_of_contact | Role of Donor Contact | |
| donor_type | Indicates whether donor is bilateral or multilateral | |
| bi_multi | Indicates nature of flow | |
| Recipient Information | ||
| AidData Research Release 1.9 Field Name | Description | |
| recipient | Recipient name in standard QWIDS spelling | |
| recipientcode | ISO3 code of Recipient Country | |
| private_recipient | Private Recipient | |
| implementing_agency | Reported implementing agency | |
| channelcode | OECD semi-standarized channel name | |
| channelname | OECD semi-standardized channel name | |
| borrower | Reported borrowing party | |
| beneficiary | Reported beneficiary party | |
| guarantor | Reported guarantor | |
| other_involved_institutions | Other involved agencies and institutions | |
| Amounts | ||
| AidData Research Release 1.9 Field Name | Description | |
| commitment_amount | Commitment amount in reported currency | |
| commitment_amount_currency | Currency of reported commitment amount | |
| commitment_amount_usd_constant | Commitment amount in USD2000 | |
| commitment_amount_usd_nominal | Commitment amount in nominal USD | |
| total_project_cost | Cost in reported currency | |
| total_project_cost_currency | Currency of reported cost | |
| total_project_cost_usd_constant | Cost in USD2000 | |
| total_project_cost_usd_nominal | Cost amount in nominal USD | |
| disbursement_amount | Disbursement amount in reported currency | |
| disbursement_amount_currency | Currency of reported disbursement amount | |
| disbursement_amount_usd_constant | Disbursement amount in USD2000 | |
| disbursement_amount_usd_nominal | Disbursement amount in nominal USD | |
| Cofinancing Information and Amounts | ||
| AidData Research Release 1.9 Field Name | Description | |
| cofinancer1_name | Reported cofinancer name | |
| cofinancer1_amount | Cofinancer amount in reported currency | |
| cofinancer1_amount_currency | Currency of reported cofinancer amount | |
| cofinancer1_amount_usd_constant | Cofinancer amount in USD2000 | |
| cofinancer1_amount_usd_nominal | Cofinancer amount in nominal USD | |
| cofinancer2_name | Reported cofinancer name | |
| cofinancer2_amount | Cofinancer amount in reported currency | |
| cofinancer2_amount_currency | Currency of reported cofinancer amount | |
| cofinancer2_amount_usd_constant | Cofinancer amount in USD2000 | |
| cofinancer2_amount_usd_nominal | Cofinancer amount in nominal USD | |
| cofinancer3_name | Reported cofinancer name | |
| cofinancer3_amount | Cofinancer amount in reported currency | |
| cofinancer3_amount_currency | Currency of reported cofinancer amount | |
| cofinancer3_amount_usd_constant | Cofinancer amount in USD2000 | |
| cofinancer3_amount_usd_nominal | Cofinancer amount in nominal USD | |
| cofinancer4_name | Reported cofinancer name | |
| cofinancer4_amount | Cofinancer amount in reported currency | |
| cofinancer4_amount_currency | Currency of reported cofinancer amount | |
| cofinancer4_amount_usd_constant | Cofinancer amount in USD2000 | |
| cofinancer4_amount_usd_nominal | Cofinancer amount in nominal USD | |
| Fund Information and Amounts | ||
| AidData Research Release 1.9 Field Name | Description | |
| 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 Name | Description | |
| title | Title in English (some CRS records are non-english) | |
| title_original_language | Title in reported language | |
| short_description | CRS short description | |
| long_description | Long description in English | |
| long_description_original_language | Long description in original language | |
| additional_info | Additional information | |
| additional_info_original_language | Additional information in original language | |
| Flow Details | ||
| PLAID 1.9 Field Name | Description | |
| AidData Research Release_flow_type | Indicates type of flow | |
| flow_name | CRS flow type | |
| flow_code | CRS flow code | |
| number_repayments_per_year | Number of repayments per year | |
| repay_type | Repayment type | |
| loan_term | Loan term | |
| grace_period | Grace period | |
| interest_rate | Interest Rate | |
| second_interest_rate | Second Interest Rate | |
| grant_element | Grant Element | |
| cancelled | Indicates if flow was cancelled | |
| repay_date_first | First repayment date | |
| repay_date_last | Last repayment date | |
| untied_amount_usd_nominal | Untied amount in nominal USD | |
| partial_tied_amount_usd_nominal | Partially tied amount in nominal USD | |
| tied_amount_usd_nominal | Tied amount in nominal USD | |
| received_amount_usd_nominal | Amount received in nominal USD | |
| irtc_amount_usd_nominal | Amount of investment related technical cooperation in nominal USD | |
| expert_commitment_amount_usd_nominal | Expert commitment amount in nominal USD. | |
| export_extended_amount_usd_nominal | Amount of export credit extended in nominal USD | |
| export_credit_amount_usd_nominal | Amount of export credit in nominal USD | |
| outstanding_amount_usd_nominal | Amount outstanding in nominal USD | |
| arrears_principal_amount_usd_nominal | Arrears of principal (incuding outstanding_amount_usd_nominal) | |
| arrears_interest_amount_usd_nominal | Arrears of interest | |
| future_ds_principal_amount_usd_nominal | Future debt service; first year principal | |
| future_ds_interest_amount_usd_nominal | Furture debt service; first year interest | |
| interest_amount_usd_nominal | Interest Amount in nominal USD | |
| Location | ||
| AidData Research Release 1.9 Field Name | Description | |
| region | Region of recipient | |
| location | Reported targeted geographic area | |
| Source Information | ||
| AidData Research Release 1.9 Field Name | Description | |
| source_detail | URL of record's webpage | |
| source | Source of data | |
| source_type | Source Type | |
| language | Original reporting language | |
| Rio Markers | ||
| AidData Research Release 1.9 Field Name | Description | |
| biodiversity | Indicates if flow is intended to promote biodiversity | |
| climate | Indicates if flow is intended to address climate change | |
| desertification | Indicates if flow is intended to address desrtification | |
| CRS Codes and Markers | ||
| AidData Research Release 1.9 Field Name | Description | |
| crs_purpose_code | Five-digit numerical code placing each project in an OECD defined aid sector or subsector | |
| crs_purpose_name | Name of the CRS sector code | |
| gender | Gender equality incorporation Women in Development (WID) marker | |
| trade | Trade Development | |
| pdgg | Identifies projects which are intended to enhance elements of participatory development, democratization, good governance and the respect of human rights | |
| ftc | Indicates if project is free-standing technical cooperation | |
| sector_programme | Dichotomous variable where 1 indicates the project is sector programme aid. | |
| sector | Name of the donor-assigned sector | |
| sector_code | CRS sector code | |
| associated_financing | Indicates if record has associated financing | |
| initial_report | Indicates if record is an initial report of flow | |
| finance_t | CRS financing type | |
| environmental_impact_assessment | Environmental impact assessment was performed | |
| environment | Project intended to benefit the environment | |
| investment_project | Investment project | |
| AidData Research Release Codes | ||
| AidData Research Release 1.9 Field Name | Description | |
| plaid_sector_code | AidData Research Release sector code from final code round | |
| plaid_sector_name | PLAID sector description | |
| plaid_activity_code | Pipe seperated PLAID activity codes from final code round | |
| plaid_activity_description | PLAID activity code description | |
| plaid_feasibility_study | Has feasability study? From final code round | |
| plaid_technical_assistance | Has TA? From final code round | |
| plaid_generated_crs_purpose_code | PLAID Generated Purpose Code | |
| plaid_generated_crs_purpose_name | PLAID Generated Purpose Name | |