OECD Official Development Assistance (ODA) - DAC5: Aid (ODA) By Sector And Donor

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 12 Other Oda Not Assigned To The Above Categories Historical Series Net Disbursements,
  "i_a_2_bilateral_core_contributions_pooled_programmes_f_9c70ebc6" FLOAT  -- I A 2 Bilateral Core Contributions Pooled Programmes Funds Grant Equivalents,
  "i_a_2_bilateral_core_contributions_pooled_programmes_f_da39231a" FLOAT  -- I A 2 Bilateral Core Contributions Pooled Programmes Funds Net Disbursements,
  "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 Grant Equivalents,
  "i_a_5_scholarships_student_costs_donor_countries_net_d_241ba181" FLOAT  -- I A 5 Scholarships Student Costs Donor Countries Net Disbursements,
  "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 Grant Equivalents,
  "i_a_7_administrative_costs_not_included_elsewhere_net__596f313b" FLOAT  -- I A 7 Administrative Costs Not Included Elsewhere Net Disbursements,
  "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 Commitments Grant Equivalents,
  "i_a_9_recoveries_bilateral_oda_grants_negative_commitm_2a7e594d" FLOAT  -- I A 9 Recoveries Bilateral Oda Grants Negative Commitments Net Disbursements,
  "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 Net Disbursements Share Oda,
  "i_a_5_scholarships_student_costs_donor_countries_grant_b9836e86" FLOAT  -- I A 5 Scholarships Student Costs Donor Countries Grant Equivalents Share Oda,
  "i_a_7_administrative_costs_not_included_elsewhere_net__e7730f45" FLOAT  -- I A 7 Administrative Costs Not Included Elsewhere Net Disbursements Share Oda,
  "i_a_7_administrative_costs_not_included_elsewhere_gran_46b46cff" FLOAT  -- I A 7 Administrative Costs Not Included Elsewhere Grant Equivalents Share Oda,
  "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
);