OECD Official Development Assistance (ODA) - DAC5: Aid (ODA) By Sector And Donor
@owid.official_development_assistance
@owid.official_development_assistance
CREATE TABLE owid_dac2a_1 (
"country" VARCHAR,
"year" INTEGER,
"donor" VARCHAR,
"capital_subscriptions_deposits" FLOAT,
"development_food_aid" FLOAT,
"grants" FLOAT,
"humanitarian_aid" FLOAT,
"loans" FLOAT,
"oda" FLOAT,
"oda_share_gni" FLOAT,
"recoveries" FLOAT,
"technical_cooperation" FLOAT
);
CREATE TABLE owid_dac2a_2 (
"country" VARCHAR,
"year" INTEGER,
"donor" VARCHAR,
"capital_subscriptions_deposits" FLOAT,
"development_food_aid" FLOAT,
"grants" FLOAT,
"humanitarian_aid" FLOAT,
"loans" FLOAT,
"oda" FLOAT,
"oda_share_gni" FLOAT,
"recoveries" FLOAT,
"technical_cooperation" FLOAT
);
CREATE TABLE owid_official_development_assistance_1 (
"country" VARCHAR,
"year" INTEGER,
"donor" VARCHAR,
"sector" VARCHAR,
"i_oda_net_disbursements" FLOAT,
"oda_bilateral_2_net_disbursements" FLOAT,
"oda_multilateral_2_net_disbursements" FLOAT,
"ii_oof_net_disbursements" FLOAT,
"iii_officially_supported_export_credits_net_disbursements" FLOAT,
"iv_private_flows_market_terms_net_disbursements" FLOAT,
"oda_bilateral_grant_equivalents" FLOAT,
"oda_multilateral_grant_equivalents" FLOAT,
"oda_grant_equivalents" FLOAT,
"flows_share_gni_net_disbursements" FLOAT,
"flows_net_disbursements" FLOAT,
"v_net_private_grants_net_disbursements" FLOAT,
"flows_share_gni_grant_equivalents" FLOAT,
"i_oda_net_disbursements_per_capita" FLOAT,
"oda_grant_equivalents_per_capita" FLOAT,
"i_oda_net_disbursements_share_gni" FLOAT,
"oda_grant_equivalents_share_gni" FLOAT,
"oda_official_estimate_share_gni" FLOAT,
"grants" FLOAT,
"loans" FLOAT,
"capital_subscriptions_deposits" FLOAT,
"recoveries" FLOAT,
"i_oda_net_disbursements_multilaterals_private_grants" FLOAT,
"capital_subscriptions_deposits_recipient" FLOAT,
"development_food_aid_recipient" FLOAT,
"grants_recipient" FLOAT,
"humanitarian_aid_recipient" FLOAT,
"loans_recipient" FLOAT,
"oda_recipient" FLOAT,
"oda_share_gni_recipient" FLOAT,
"recoveries_recipient" FLOAT,
"technical_cooperation_recipient" FLOAT,
"oda_by_sector" FLOAT,
"oda_recipient_per_capita" FLOAT,
"grants_recipient_per_capita" FLOAT,
"loans_recipient_per_capita" FLOAT,
"technical_cooperation_recipient_per_capita" FLOAT,
"development_food_aid_recipient_per_capita" FLOAT,
"humanitarian_aid_recipient_per_capita" FLOAT,
"oda_by_sector_per_capita" FLOAT
);
CREATE TABLE owid_official_development_assistance_2 (
"country" VARCHAR,
"year" INTEGER,
"donor" VARCHAR,
"sector" VARCHAR,
"i_oda_net_disbursements" FLOAT,
"oda_bilateral_2_net_disbursements" FLOAT,
"i_a_1_budget_support_grant_equivalents" FLOAT,
"i_a_1_budget_support_net_disbursements" FLOAT,
"i_a_11_private_sector_instruments_grant_equivalents" FLOAT,
"i_a_12_other_oda_not_assigned_to_the_above_categories__83faf889" FLOAT,
"i_a_2_bilateral_core_contributions_pooled_programmes_f_9c70ebc6" FLOAT,
"i_a_2_bilateral_core_contributions_pooled_programmes_f_da39231a" FLOAT,
"i_a_3_project_type_interventions_grant_equivalents" FLOAT,
"i_a_3_project_type_interventions_net_disbursements" FLOAT,
"i_a_4_experts_other_technical_assistance_grant_equivalents" FLOAT,
"i_a_4_experts_other_technical_assistance_net_disbursements" FLOAT,
"i_a_5_scholarships_student_costs_donor_countries_grant_f130eacd" FLOAT,
"i_a_5_scholarships_student_costs_donor_countries_net_d_241ba181" FLOAT,
"i_a_6_debt_relief_net_disbursements" FLOAT,
"i_a_7_administrative_costs_not_included_elsewhere_gran_eae2d699" FLOAT,
"i_a_7_administrative_costs_not_included_elsewhere_net__596f313b" FLOAT,
"i_a_8_other_in_donor_expenditures_grant_equivalents" FLOAT,
"i_a_8_other_in_donor_expenditures_net_disbursements" FLOAT,
"i_a_8_1_development_awareness_grant_equivalents" FLOAT,
"i_a_8_1_development_awareness_net_disbursements" FLOAT,
"i_a_8_2_refugees_in_donor_countries_net_disbursements" FLOAT,
"i_a_9_recoveries_bilateral_oda_grants_negative_commitm_b3309b5a" FLOAT,
"i_a_9_recoveries_bilateral_oda_grants_negative_commitm_2a7e594d" FLOAT,
"oda_multilateral_2_net_disbursements" FLOAT,
"ii_oof_net_disbursements" FLOAT,
"iii_officially_supported_export_credits_net_disbursements" FLOAT,
"iv_private_flows_market_terms_net_disbursements" FLOAT,
"oda_bilateral_grant_equivalents" FLOAT,
"oda_multilateral_grant_equivalents" FLOAT,
"oda_grant_equivalents" FLOAT,
"flows_share_gni_net_disbursements" FLOAT,
"flows_net_disbursements" FLOAT,
"v_net_private_grants_net_disbursements" FLOAT,
"i_a_6_debt_relief_grant_equivalents" FLOAT,
"i_a_8_2_refugees_in_donor_countries_grant_equivalents" FLOAT,
"flows_share_gni_grant_equivalents" FLOAT,
"i_a_8_2_refugees_other_provider_countries_net_disbursements" FLOAT,
"i_a_10_other_loans_repayments_net_disbursements" FLOAT,
"i_oda_net_disbursements_per_capita" FLOAT,
"oda_grant_equivalents_per_capita" FLOAT,
"i_oda_net_disbursements_share_gni" FLOAT,
"oda_grant_equivalents_share_gni" FLOAT,
"oda_official_estimate_share_gni" FLOAT,
"i_a_5_scholarships_student_costs_donor_countries_net_d_ed9cd5d3" FLOAT,
"i_a_5_scholarships_student_costs_donor_countries_grant_b9836e86" FLOAT,
"i_a_7_administrative_costs_not_included_elsewhere_net__e7730f45" FLOAT,
"i_a_7_administrative_costs_not_included_elsewhere_gran_46b46cff" FLOAT,
"i_a_8_1_development_awareness_net_disbursements_share_oda" FLOAT,
"i_a_8_1_development_awareness_grant_equivalents_share_oda" FLOAT,
"i_a_8_2_refugees_in_donor_countries_net_disbursements_share_oda" FLOAT,
"i_a_8_2_refugees_in_donor_countries_grant_equivalents_share_oda" FLOAT,
"oda_indonor_net_disbursements" FLOAT,
"oda_indonor_net_disbursements_share_oda" FLOAT,
"oda_indonor_grant_equivalents" FLOAT,
"oda_indonor_grant_equivalents_share_oda" FLOAT,
"oda_overseas_net_disbursements" FLOAT,
"oda_overseas_grant_equivalents" FLOAT,
"oda_overseas_net_disbursements_share_oda" FLOAT,
"oda_overseas_grant_equivalents_share_oda" FLOAT,
"grants" FLOAT,
"loans" FLOAT,
"capital_subscriptions_deposits" FLOAT,
"recoveries" FLOAT,
"i_oda_net_disbursements_multilaterals_private_grants" FLOAT,
"capital_subscriptions_deposits_recipient" FLOAT,
"development_food_aid_recipient" FLOAT,
"grants_recipient" FLOAT,
"humanitarian_aid_recipient" FLOAT,
"loans_recipient" FLOAT,
"oda_recipient" FLOAT,
"oda_share_gni_recipient" FLOAT,
"recoveries_recipient" FLOAT,
"technical_cooperation_recipient" FLOAT,
"oda_by_sector" FLOAT,
"oda_recipient_per_capita" FLOAT,
"grants_recipient_per_capita" FLOAT,
"loans_recipient_per_capita" FLOAT,
"technical_cooperation_recipient_per_capita" FLOAT,
"development_food_aid_recipient_per_capita" FLOAT,
"humanitarian_aid_recipient_per_capita" FLOAT,
"oda_by_sector_per_capita" FLOAT
);
Anyone who has the link will be able to view this.