About this Dataset

Defra ODA Spend In Line With IATI Standard

As part of the Government’s Transparency Agenda, all Departments with Official Development Assistance (ODA) allocations are committed to publishing details of how they spend ODA in compliance with the International Aid Transparency Initiative (IATI) standard. The IATI standard involves listing specific details of the aid spend, such as recipient country, recipient sector and aid type. This data is then linked to the IATI registry which provides details of all aid data globally.
Publisher name: Department for Environment, Food and Rural Affairs
Last updated: 2022-07-01T04:07:35Z

Tables

Defra ODA Spend In Line With IATI Standard

@ukgov.defra_oda_spend_in_line_with_iati_standard.defra_oda_spend_in_line_with_iati_standard

24.67 kB
52 rows
17 columns

CREATE TABLE defra_oda_spend_in_line_with_iati_standard (
  "reporting_organisation" VARCHAR,
  "iati_identifer" VARCHAR,
  "activity_title" VARCHAR,
  "activity_description" VARCHAR,
  "project_status" BIGINT,
  "recipient_country_code" VARCHAR,
  "recipient_country_name" VARCHAR,
  "recipient_region_code" DOUBLE,
  "recipient_region_name" VARCHAR,
  "sector_code" BIGINT,
  "default_flow_type" BIGINT,
  "default_finance_type" BIGINT,
  "default_aid_type" VARCHAR,
  "transaction_value_date" TIMESTAMP,
  "transaction_value_gbp" DOUBLE  -- Transaction Value (GBP),
  "transaction_type" VARCHAR,
  "transaction_description" BIGINT
);