Research Datasets

 

In addition to providing a searchable database of more than 1 million aid activities from the 1940s to present, AidData has assembled a set of datasets specifically for researchers. Three of these datasets are derived from AidData's core database: a 'Research Release' of all project-level records as of November 2011, a dataset of aggregate financial transfers between donors and recipients (generated from the November 2011 Research Release), and a dataset of aggregate financial transfers between individual financing agencies and recipients (generated from the November 2011 Research Release).  There are also links to other useful datasets (e.g. NGO aid, military aid, Chinese aid, IMF conditionality compliance) that are not derived from AidData's core database, but may be of interest to researchers.

AidData Research Release 2.1
Source
: AidData (see release notes)
Contents: AidData's Research Release 2.1 is a snapshot of the AidData's entire project-level database from February 2013. This database includes over 1 million aid activities funded by more than 80 donors from the 1940s to present. AidData Research Releases are particularly useful for researchers because they are static versions of the data that allow for replication and comparison. AidData’s goal is to publish updated research releases on an annual basis (or more frequently if appropriate). For detailed information about this data set, see the AidData User’s Guide.
Data (.zip files, with readme): .
     AidData 2.1 Full [all fields for all data] (CSV, TXT, SQL insert and create, copy of PostgreSql) .
     AidData 2.1 "Thin" [only 6 fields] (CSV, TXT) .
     AidData 2.1 Since 1996 [short enough to open in Excel] (CSV, TXT) .
     AidData 2.1 non-OECD (CSV, XLSX, TXT) .
     AidData 2.1 Aggregate: Donor, Recipient, Year (CSV, TXT) .
     AidData 2.1 Aggregate: Donor, Recipient, Year, Purpose Name (CSV, TXT) .
Official Citation: Tierney, Michael J., Daniel L. Nielson, Darren G. Hawkins, J. Timmons Roberts, Michael G. Findley, Ryan M. Powers, Bradley Parks, Sven E. Wilson, and Robert L. Hicks. 2011. More Dollars than Sense: Refining Our Knowledge of Development Finance Using AidData. World Development 39 (11): 1891-1906.

AidData Sector Coding Scheme
As described in the AidData User's guide, the AidData sector coding scheme consists of two components:
Purpose Codes are assigned 1:1 to project records and capture the main purpose of a project, in the same style as OECD CRS purpose codes, upon which AidData purpose codes are based.
Activity Codes are assigned n:1 to project records and capture each activity within the project.
Both coding schemes are included in the spreadsheet below. Also available is a simple visualization which may help in introducing the AidData purpose codes.
Downloads
     AidData sector codes, spreadsheet (.xlsx)
     AidData sector codes, visual (.jpg, .pdf, .svg)

GDP Deflators & Exchange Rates
Source: OECD and AidData
These files contain the deflators and exchange rates used to convert all transactions in the AidData web portal to constant USD-2009. Information about sources and how to use these exchange rates and deflators is included in the PDF below.
Data
     Documentation (.pdf)
     Exchange Rates (.xlsx)
     GDP Deflators (.xlsx)

World Bank Mapping for Results
Contents: This dataset contains nearly 2,500 active World Bank projects in over 30,000 locations across 144countries. The dataset was created by AidData in partnership with the World Bank Institute and is current to September 2011. 
Data: Available Here

Official Citation: Strandow, Daniel, Michael Findley, Daniel Nielson, and Josh Powell. 2011. The UCDP-AidData codebook on Geo-referencing Foreign Aid. Version 1.1. Uppsala Conflict Data Program. Uppsala, Sweden: Uppsala University.

African Development Bank Geocoded Projects 
Contents: This dataset contains all African Development Bank activities approved in 2009-2010. In total, there are 183 projects worth over $15 billion in total funding, working in nearly 2,000 locations across 43 African countries. The work was featured in the  AfDB’s 2011 Annual Development Effectiveness Review
Data: Available here
Official Citation: Strandow, Daniel, Michael Findley, Daniel Nielson, and Josh Powell. 2011. The UCDP-AidData codebook on Geo-referencing Foreign Aid. Version 1.1. Uppsala Conflict Data Program. Uppsala, Sweden: Uppsala University.

Malawi Aid Management Platform Geocoded Projects
Contents: This dataset contains geocoded aid locations from 30 donor agencies in the Malawi Ministry of Finance’s Aid Management Platform. The data include US$5.3 billion in commitments, representing approximately 80% of all external funding reported to the Malawi Ministry of Finance since 2000.
Data: Available here
Official Citation: Peratsakis, Christian, Joshua Powell, Michael Findley, and Catherine Weaver. 2012. Geocoded Activity-Level Data from the Government of Malawi's Aid Management Platform. Washington D.C. AidData and the Robert S. Strauss Center for International Security and Law.

 

Aid Locations During Civil Wars South of the Sahara
Contents: This dataset contains geocoded aid locations for the 22 Sub-Saharan countries that experienced intra-state conflict between 1989 and 2007.
Data: Available here
Official Citation: Findley, Michael G., Josh Powell, Daniel Strandow, and Jeff Tanner. "The Localized Geography of Foreign Aid: A New Dataset and Application to Violent Armed Conflict." World Development. 39.11 (2011): 1995-2009.


 

Chinese Official Finance to Africa from 2000-2011, Version 1.0
Contents: AidData's first application of its Media-Based Data Collection methodology, this detailed project-level database covers official Chinese development finance flows (ODA and OOF) to Africa from 2000 to 2011. The static version of the dataset from April 2013 includes more than 1700 pledged, initiated, and completed projects, collectively worth over $75 billion.
Data: Available here
Official Citation:  Austin Strange, Bradley C. Parks, Michael J. Tierney, Andreas Fuchs, Axel Dreher, and Vijaya Ramachandran. 2013. "China’s Development Finance to Africa: A Media-Based Approach to Data Collection." CGD Working Paper 323. Washington DC: Center for Global Development.

 

PLAID 1.9 with Environmental Impact Codes
PLAID 1.9 was a precursor dataset to the modern AidData 2.0 research release and AidData web portal. Available here is the PLAID 1.9 dataset with environment codes used in Greening Aid? Researchers should note:
     Donor names have been harmonized, but may not match current AidData donor names.
     Recipient names not harmonized and some core contributions to multilateral institutions are included, with the  multilateral institution listed as recipient.
     Sector code coverage is not as extensive as AidData 2.0.
     Not all projects have unique AidData IDs.
     "Constant USD" is USD-2000, unlike AidData 2.0's USD-2009
See the Cover Sheet (xlsx, 12KB) for more information and details on the Environmental Impact Code field and possible values. AidData is also merging these Environmental Impact Codes with the AidData web portal. It will be announced on the First Tranche when this variable is available for download from the web portal. In the meantime, researchers can access the Environmental Impact Codes either at the project-level or as aggregate flows. These data are available here: 
Project-Level:
     Full form (CSV , SQL) (136 cols x 962005 obs)
     Short form (includes ID, donor, recipient, year, commitment, purpose, env_code) (CSV) (7 cols x 962005 obs)
Aggregate:
     By donor, recipient, year and environment code (CSV) (156611 obs)
     By donor, recipient, year, purpose and environment code (CSV) (498723 rows)
Official Citation: Hicks, Robert L., Bradley C. Parks, J. Timmons Roberts, and Michael J. Tierney. 2008. Greening Aid? Understanding the Environmental Impact of Development Assistance. Oxford, UK: Oxford University Press.

Climate Aid in Malawi
Source: Climate Change and African Political Stability (CCAPS) program
Data: Available here
Contents: The first-ever dataset tracking all climate aid activities in a single country. In the pilot study, CCAPS and AidData researchers applied their new "climate coding" methodology to all official development aid projects in Malawi's Aid Management Platform, assessing each project activity for its relevance to climate change adaptation. The resulting database reveals how much of Malawi's current aid portfolio represents funding allocated specifically for climate-oriented development. It also reveals how much of Malawi's aid is not explicitly climate-related, comprised of development projects that could have varied degrees of positive or negative impacts on climate change adaptation. This new Malawi Climate-coded and Geocoded Aid Dataset is alsomapped on the CCAPS aid dashboard.
Codebook: Available here.
Official Citation: Peratsakis, Christian, Justin Baker, and Catherine Weaver. 2012. Tracking Climate Adaptation Aid: CCAPS Climate Codebook. Austin, TX: Robert S. Strauss Center for International Security and Law.

GFDRR Disaster Aid Tracking (DAT) Dashboard
Source: GFRDRR Disaster Aid Tracking (DAT) Dashboard
Data: Available here
Contents: The Disaster Aid Tracking (DAT) dashboard is a collaborative effort between the Global Facility for Disaster  Reduction and Recovery (GFDRR) and AidData. GFDRR is a partnership of 41 countries and 8 international organizations committed to helping developing countries reduce their vulnerability to natural hazards and adapt to climate change. The DAT dashboard tracks the allocation of development finance addressing natural hazards (both risk management and risk reduction). 

Global Humanitarian Aid Flows, 2000-2012
Source: Financial Tracking Service
Data: Available here.
Contents: The Financial Tracking Service (FTS) is a global, real-time database which records all reported international humanitarian aid since 2000. FTS is managed by the United Nations Office for the Coordination of Humanitarian Affairs (UN OCHA).

Global Philanthropy and Remittances
Contents: Figures from the 2011 Index of Global Philanthropy and Remittances. The dataset includes Total Official and Total Private Flows--including Philanthropy, Remittances, and Investment—from OECD Donor Countries to Developing Countries, 1991-2009. These data are disaggregated into Total Flows by Type from All Donor Countries, and Total Flows by Type from Individual Donor Countries (2009), including as a percent of GNI and per capita. Private philanthropy figures from 2009 are broken into OECD official figures and expanded CGP estimates. All remittance data are provided by the World Bank’s Bilateral Remittance Matrix.   
 
Net Aid Transfers data set (1960-2009) - Updated January 28, 2011
Source: Center for Global Development 
Data: Available here
Contents:  Net Aid Transfers (NAT) are calculated as (Net Official Development Assistance) – (Other Official Flow loan cancellation) – (interest actually received).  This dataset includes NAT rankings by bilateral donor (including ODA to multilaterals) and by recipient, both in Current(2009)USD and ConstantUSD. 
 
US disbursements of military aid, 1946-2009
Source: US Overseas Loans and Grants: Obligations and Loan Authorizations Greenbook
Data: Available here
Contents: All US Economic Aid (ODA) and Military Assistance obligations, by country, sector, and implementing agency, from 1946-2009. 
 
Quality of ODA Assessment (QuODA)
Source: Center for Global Development and the Brookings Institution
Data: Available here
Contents: An assessment of the Quality of Official Development Assistance (ODA) provided by 23 donor countries and more than 150 aid agencies. Aid quality is assessed using 30 indicators grouped in four dimensions (maximizing efficiency, fostering institutions, reducing burden, transparency and learning) that reflect the international consensus of what constitutes high-quality aid. 
 
Publish What You Fund Transparency Assessment
Source: Publish What You Fund
Data: Available here
Contents: Transparency scores and rankings of 30 major donors across three categories: high level commitment to transparency; transparency to recipient government; and transparency to civil society.
 
CGD's Commitment to Development Index -- Aid Component
Source: Center for Global Development 
Data: Available here
Contents: Donor nation scores and rankings for foreign aid (in relation to other development policy areas such as trade and security). A donor’s aid score starts with gross disbursements as a percentage of GDP, and is then “quality-adjusted”--discounting tied aid, low selectivity, and high project proliferation, while rewarding a bonus for government policies which encourage private charitable giving for development.   
 
Dummy Variables for IMF Programs and World Bank Projects
Source: Axel Dreher. “IMF and Economic Growth: The Effects of Programs, Loans, and Compliance with Conditionality”. World Development 34 (5): 769-788, 2006
Data: Available here
Contents: This dataset contains yearly dummies for the existence of IMF programs and World Bank projects in 160 countries, as used and described in Boockmann and Dreher (2003) and Dreher (2006).
 
NGO Aid: 2005
Source: Koch, Dirk-Jan; Axel Dreher; Rainer Thiele and Peter Nunnenkamp. “Keeping a Low Profile: What Determines the Allocation of Aid by Non-Governmental Organizations?” World Development, 37 (5): 902-918, 2008.
Data: Available here
Contents: This dataset contains information on aid expenditures (in Euros) allocated by 61 NGOs in 2005.
 
Dummy Variables for IMF Non-Compliance
Source: Axel Dreher and Stefanie Walter. “Does the IMF Help or Hurt? The Effect of IMF Programs on the Likelihood and Outcome of Currency Crises”. World Development 38 (1): 1-18, 2010.
Data: Available here
Contents: This database contains a dummy indicating that a country was non-compliant with its IMF program over the 1975-2003 period. As coded in Dreher and Walter (2010), a country is non-compliant when at least 25 percent of the amount agreed under an IMF arrangement remained undrawn at program expiration.
 
History of U.S. Aid and Reimbursements to Pakistan
Source: Center for Global Development 
Data: Available here
Contents:  This data set describes budgeted levels of U.S. military and economic assistance to Pakistan for the period from 1948 to 2010. Most of the data is drawn from the U.S. Overseas Grants and Loans database (the U.S. Greenbook). That is complemented by Congressional Research Service estimates of military reimbursements for the period since 2002 and by information on the fiscal year 2010 budget compiled by CRS. All figures are adjusted for inflation and are presented in constant 2009 dollars.
 
Effective Development Assistance (EDA)
Source:  Charles C. Chang, Eduardo Fernandez-Arias and Luis Serven. "Measuring Aid Flows: A New Approach". Policy Research Working Paper #2050, World Bank, 1998
Data: Available here
Contents:  The files included in this database contain the conventional and the adjusted measures of official development assistance to a set of 133 countries between 1975 and 1995. The principal component of the data set is Effective Development Assistance (EDA), an aggregate measure of aid flows combining total grants and the grant equivalents of all official loans. EDA is computed on a loan-by-loan basis to reflect the financial cost the creditor incurs in making loans on concessional terms. Zip file includes aggregate bilateral annual flows; annual multilateral annual flows; aggregate annual flows from all official sources; and a readme file for detailed description of variables. 
 
USAID Democracy Assistance, 1990-2004
Source: Deepening Our Understanding of the Effects of US Foreign Assistance on Democracy Building. Final Report: Democracy Assistance Project Phase II
Data: Available here
Contents:  USAID funding disaggregated into eight categories: Democracy and Governance (DG), Agriculture and Economic Growth, Education, Environment, Health, Humanitarian Assistance, Human Rights (the non-DG components, such as anti-trafficking and assistance to victims of torture), and Conflict Management and Mitigation. USAID Democracy and Governance Assistance is divided into four sub-sectors (Elections, Rule of Law, Civil Society, and Governance); and two subsub-sectors (Human Rights, which is part of Rule of Law, and Mass Media, which is part of Civil Society). Full codebook is available here.

Financing Global Health 2011: Continued Growth as MDG Deadline Approaches (DAH Funding 1990-2008)
Source: Institute for Health Metrics and Evaluation
Data: Available here
Contents:  A comprehensive view of trends in public and private financing of health assistance with preliminary estimates for health financing in the most recent years. The 2011 dataset updates previous efforts by including: preliminary estimates for 2010 and 2011 using models and preliminary financial statements obtained directly from channels of assistance; improved estimates of DAH flowing through US-based non-governmental organizations by collecting additional health expenditure data; more accurate DAH estimates by incorporating more detailed World Bank data regarding projects’ intended purposes .

Chinese Aid, Ministry of Commerce Projects, 1990-2005
Source: AidData 
Data: Available here
Contents: Chinese foreign aid project-level data reported by China’s Ministry of Commerce, excluding 2002 (for which the ministry reported no project-level data). Supplemented with project monetary amounts from media outlets.
 
An Index of the Quality of Official Development Assistance in Health
Source: Center for Global Development
Data: Available here
Contents: The Quality of Official Development Assistance (QuODA) methodology is used to rank 30 donors across 23 indicators of aid effectiveness in health, and tracks donors’ progress from 2008-2009. Indicators rely on the premise that health aid effectiveness would increase through increased donor efficiency, reduced burden on recipients, support to local institutions, and transparent reporting practices.