Official Development Assistance British Council

CREATE TABLE official_development_assistance_british_council (
  "iati_number" VARCHAR,
  "project_number" VARCHAR,
  "project_name" VARCHAR,
  "project_description" VARCHAR,
  "benefiting_country" VARCHAR,
  "country_code" VARCHAR,
  "input_sector_code" BIGINT,
  "input_sector_text" VARCHAR,
  "delivery_channel" BIGINT,
  "delivery_channel_text" VARCHAR,
  "aid_type" VARCHAR,
  "nature_of_submission" BIGINT,
  "activity_start_date" TIMESTAMP,
  "commitment_date" TIMESTAMP,
  "activity_end_date" TIMESTAMP,
  "activity_status" BIGINT,
  "activity_scope" BIGINT,
  "climate_change_adaptation" BIGINT,
  "climate_change_mitigation" BIGINT,
  "climate_change_biodiversity" BIGINT,
  "climate_change_desertification" BIGINT,
  "gender_equality" BIGINT,
  "aid_to_environment" BIGINT,
  "good_governance" BIGINT,
  "trade_development" BIGINT,
  "rmnch" BIGINT,
  "document_1_type" VARCHAR,
  "n__2015_q_4" DOUBLE,
  "full_year_actuals" DOUBLE
);