Countdown ODA+ Dataset - Codebook

Persistent identifier

10.17037/DATA.127

Description

Dataset containing 2.1 million records used to generate estimates of official development assistance (ODA) to reproductive, maternal, newborn and child health (RMNCH) based upon donor, recipient country and activity type between 2003–2013.

Disbursement information on donor-reported ODA and private grants were obtained from the Organisation for Economic Co-operation and Development (OECD) Creditor Reporting System in January 2015 and coded based on donor name, project title, short and long descriptions, and CRS code describing the disbursement purpose. The coding scheme classifies records according to the degree to which they would promote attainment of Millennium Development Goals 4 and 5 (reproductive and sexual health, maternal and newborn health, and child health, RMNCH). We also classified records according to whether they supported prenatal and newborn health (PNH).

The dataset includes project funding as well as allocating shares of general budget support, health sector support and basket funding based on recipient country characteristics. The data can be used for analysis of resource flows to RMNCH or to other purposes or beneficiaries.

Data Codebook

ODAplus_dataset_small

The small Countdown ODA+ dataset contains a limited number of variables found in the full dataset. Most values are the same as the full dataset, except for the following:

Variable Name Variable Label Answer Label Answer Code Variable Type
year Year of disbursement Open ended   Numeric
donorcode Donor code Open ended   Numeric
donorname Donor name     String
recipientcode Recipient country code Open ended   Numeric
recipientname Recipient country name     String
RMNCH_code RMNCH code indicating the area of RMNCH the disbursement benefits Open ended   Numeric
purposecode Purpose reported by donor - Code Open ended   Numeric
purposename Purpose reported by donor - Description Open ended   String
CH_Exp Disbursement supporting child health, constant 2013 USD Open ended   Numeric
MNH_Ex Disbursement supporting maternal and newborn health, constant 2013 USD Open ended   Numeric
RH_Exp Disbursement supporting reproductive and sexual or maternal and newborn health, constant 2013 USD Open ended   Numeric
channelcode Channel of disbursement in recipient country - code Open ended   Numeric
channelname Channel of disbursement in recipient country - name Open ended   String
Count of records Count of records Open ended   Numeric

ODAplus_dataset_full

Dataset containing 2.1 million records used to generate estimates of official development assistance (ODA) to reproductive, maternal, newborn and child health (RMNCH) based upon donor, recipient country and activity type between 2003– 2013.

Fields in the CRS dataset downloaded on January 7th 2015. Full descriptions of these fields are available in the Converged Statistical Reporting Directives For The Creditor Reporting System (CRS) and the Annual DAC Questionnaire (https://web.archive.org/web/20150901000000*/https://www.oecd.org/dac/stats/documentupload/DCD-DAC(2013)15-FINAL-ENG.pdf). This table was constructed with some reference to the Userʼs Guide to the Project-level Aid Database (now AidData), at https://aiddata.s3.amazonaws.com/codebook/AidData_CodeBook_Current.pdf (last accessed May 12th 2016).

Fields added in the Countdown analysis are: ID, CD_status, RMNCH_code, Allocation_factor, CH_Exp, MNH_Exp, RH_Exp, disb_const_2013, PNH_research, PNH_ex_in, Any_PNH_term, MD5_hash.

Variable Name Variable Label Answer Label Answer Code Variable Type
ID Unique record identifier Open ended   Exact numeric
Year Year of disbursement Open ended   Exact numeric
donorcode Donor, code Open ended   Exact numeric
donorname Donor, name Open ended   String (255 characters max)
agencycode Agency receiving funds, code Open ended   Exact numeric
agencyname Agency receiving funds, name Open ended   String (255 characters max)
crsid CRS identifier Open ended   String (255 characters max)
projectnumber Project number Open ended   String (255 characters max)
initialreport Initial report Open ended   Approximate numeric
recipientcode Recipient country, code Open ended   Approximate numeric
recipientname Recipient country, name Open ended   String (255 characters max)
regioncode Recipient country region, code Open ended   Approximate numeric
regionname Recipient country region, name Open ended   String (255 characters max)
incomegroupcode Income group of recipient country, code Open ended   Approximate numeric
incomegroupname Income group of recipient country, name Open ended   String (255 characters max)
flowcode Type of flow (ODA, private grant, other official flow etc.), code Open ended   Approximate numeric
flowname Type of flow, name Open ended   String (255 characters max)
bi_multi Bilateral or multilateral funds Open ended   Approximate numeric
category Category Open ended   Approximate numeric
finance_t Finance type (grant, loan etc.) Open ended   Approximate numeric
aid_t Aid type (budget support, project etc.) Open ended   String (255 characters max)
usd_commitment Commitment value (current USD) Open ended   Approximate numeric
usd_disbursement Disbursement value (current USD) Open ended   Approximate numeric
usd_received USD received (current USD) Open ended   String (255 characters max)
usd_commitment_defl Commitment value (constant USD) Open ended   Approximate numeric
usd_disbursement_defl Disbursement value (constant USD) Open ended   Approximate numeric
usd_received_defl USD received (constant USD) Open ended   String (255 characters max)
usd_adjustment Adjustment value (current USD) Open ended   String (255 characters max)
usd_adjustment_defl Adjustment value (constant USD) Open ended   String (255 characters max)
usd_amountuntied Amount untied (current USD) Open ended   Approximate numeric
usd_amountpartialtied Amount partially tied (current USD) Open ended   String (255 characters max)
usd_amounttied Amount tied (current USD) Open ended   Approximate numeric
usd_amountuntied_defl Amount untied (constant USD) Open ended   Approximate numeric
usd_amountpartialtied_defl Amount partially tied (constant USD) Open ended   String (255 characters max)
usd_amounttied_defl Amount tied (constant USD) Open ended   Approximate numeric
usd_IRTC Investment related technical cooperation value (current USD) Open ended   String (255 characters max)
usd_expert_commitment Export commitment value (current USD) Open ended   String (255 characters max)
usd_expert_extended Value of export credit extended (current USD) Open ended   String (255 characters max)
usd_export_credit Value of export credit (current USD) Open ended   Approximate numeric
currencycode Currency code of donor Open ended   Approximate numeric
commitment_national National commitment Open ended   Approximate numeric
disbursement_national National disbursement Open ended   Approximate numeric
shortdescription Short description of project Open ended   String (255 characters max)
projecttitle Title of project Open ended   String (255 characters max)
purposecode Purpose reported by donor, code Open ended   Approximate numeric
purposename Purpose reported by donor, name Open ended   String (255 characters max)
sectorcode Sector reported by donor, code Open ended   Approximate numeric
sectorname Sector reported by donor, name Open ended   String (255 characters max)
channelcode Channel of disbursement in recipient country, code Open ended   Approximate numeric
channelname Channel of disbursement in recipient country, name Open ended   String (255 characters max)
channelreportedname Channel of disbursement in recipient country, reported name Open ended   String (255 characters max)
geography Reported targeted geographic area Open ended   String (255 characters max)
expectedstartdate Expected start date of disbursement project Open ended   Date and time
completiondate Expected completion date of disbursement project Open ended   Date and time
longdescription Long description of project Open ended   String (4000 characters max)
gender Policy objective marker: Gender equality Open ended   Approximate numeric
environment Policy objective marker: Aid to environment Open ended   Approximate numeric
trade Policy objective marker: Trade development Open ended   String (255 characters max)
pdgg Policy objective marker: Participatory development/Good governance Open ended   Approximate numeric
FTC Whether free-standing technical cooperation Open ended   String (255 characters max)
PBA Whether programme-based approach Open ended   String (255 characters max)
investmentproject Whether investment project Open ended   Approximate numeric
assocfinance Whether record has associated financing Open ended   Approximate numeric
biodiversity Rio marker: Biodiversity Open ended   String (255 characters max)
climateMitigation Rio marker: Climate change - mitigation Open ended   String (255 characters max)
climateAdaptation Rio marker: Climate change - adaptation Open ended   String (255 characters max)
desertification Rio marker: Desertfication Open ended   String (255 characters max)
commitmentdate Reported commitment date Open ended   Date and time
typerepayment Repayment type Open ended   String (255 characters max)
numberrepayment Number of repayments per year Open ended   String (255 characters max)
interest1 Interest rate Open ended   String (255 characters max)
interest2 Second interest rate Open ended   String (255 characters max)
repaydate1 First repayment date Open ended   String (255 characters max)
repaydate2 Last repayment date Open ended   String (255 characters max)
grantelement Grant element Open ended   Approximate numeric
usd_interest Interest amount in current USD Open ended   String (255 characters max)
usd_outstanding Amount outstanding in current USD Open ended   String (255 characters max)
usd_arrears_principal Arrears of principal (incuding usd_outstanding) Open ended   String (255 characters max)
usd_arrears_interest Arrears of interest Open ended   String (255 characters max)
usd_future_DS_principal Future debt service; first year principal Open ended   String (255 characters max)
usd_future_DS_interest Future debt service; first year interest Open ended   String (255 characters max)
cd_status Recipient country status Open ended   Exact numeric
    Non-priority recipient country 0  
    Recipient country is among the 75 priority recipients in the Countdown to 2015 classification 1  
RMNCH_code RMNCH code detailing which area of RMNCH the disbursement benefits Open ended   Exact numeric
Allocation_factor Allocation factor: estimated proportion of disbursement benefitting RMNCH Open ended   Approximate numeric
CH_exp Disbursement supporting child health, constant 2013 USD Open ended   Approximate numeric
MNH_exp Disbursement supporting maternal and newborn health, constant 2013 USD Open ended   Approximate numeric
RH_Exp Disbursement supporting reproductive and sexual or maternal and newborn health, constant 2013 USD Open ended   Approximate numeric
disb_const_2013 Disbursement in constant 2013 USD Open ended   Approximate numeric
PNH_exin Among records that contain a key term for prenatal and neonatal health, categorises that record as either exclusively benefitting PNH, or also benefiting other population groups, such as mothers or children older than one month; misclassified = record wholly unrelated to newborn health; zero = disbursement value is zero Open ended   String (255 characters max)
PNH_research Among records that contain a key term for prenatal and neonatal health, categorises that record as supporting either research or non-research activities; misclassified = record wholly unrelated to newborn health; zero = disbursement value is zero Open ended   String (255 characters max)
Any_PNH_term Does it contains any key term relating to prenatal and neonatal health? Open ended   Exact numeric
    No - no key term relating to prenatal and neonatal health present 0  
    Yes, key term relating to prenatal and neonatal health present 1  
MD5_Hash Contains a hash value over all columns in the set using the MD5 algorithm. Useful to check whether data correctly imported. Open ended   Exact numeric