About this Dataset

Official Development Assistance (ODA) International Programme

FCO International Programme superceeded the previous programme fund, the FCO Bilateral and Strategic programme fund. These datasets are cumulative and are added to quarterly.
Publisher name: Foreign and Commonwealth Office
Last updated: 2022-07-01T04:02:42Z

Tables

Official Development Assistance (ODA) International Programme

@ukgov.official_development_assistance_oda_fco_programme_spend.official_development_assistance_oda_international_programme

100.71 kB
616 rows
27 columns

CREATE TABLE official_development_assistance_oda_international_programme (
  "reporting_organisation" VARCHAR,
  "iati_identifier" VARCHAR,
  "activity_date_start" TIMESTAMP,
  "activity_date_end" TIMESTAMP,
  "other_identifier" VARCHAR,
  "title" VARCHAR,
  "description" VARCHAR,
  "activity_status" DOUBLE,
  "recipient_country" VARCHAR,
  "n__sector" VARCHAR  -- Sector,
  "channel_of_delivery_code" BIGINT,
  "default_flow_type" BIGINT,
  "default_finance_type" BIGINT,
  "n__default_aid_type" VARCHAR  -- Default Aid Type,
  "climate_change_adaptation" DOUBLE,
  "climate_change_mitigation" DOUBLE,
  "climate_change_biodiversity" DOUBLE,
  "climate_change_desertification" DOUBLE,
  "ftc" DOUBLE,
  "activity_date" TIMESTAMP,
  "calendar_year" BIGINT,
  "transaction" DOUBLE,
  "budget" DOUBLE,
  "amount_untied" DOUBLE,
  "partially_tied" DOUBLE,
  "document_link" VARCHAR,
  "activity_scope" BIGINT
);