About this Dataset

Overseas Travel Undertaken By Ministers In The Foreign And Commonwealth Office

A quarterly-updated list of all overseas travel undertaken by ministers
Publisher name: Foreign and Commonwealth Office
Last updated: 2022-07-01T04:04:06Z

Tables

FCO Minister's Overseas Travel April - June 2019

@ukgov.overseas_travel_undertaken_by_ministers_in_fco.fco_minister_s_overseas_travel_april_june_2019

13.42 KB
26 rows
11 columns


CREATE TABLE fco_minister_s_overseas_travel_april_june_2019 (
  "minister" VARCHAR,
  "start_date_of_trip" TIMESTAMP,
  "end_date_of_trip" TIMESTAMP,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "cost_of_private_jet_or_raf_plane_hire_if_relevant" VARCHAR,
  "number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR,
  "unnamed_10" VARCHAR
);

FCO Ministers Overseas Travel January - March 2019

@ukgov.overseas_travel_undertaken_by_ministers_in_fco.fco_ministers_overseas_travel_january_march_2019

12.98 KB
33 rows
10 columns


CREATE TABLE fco_ministers_overseas_travel_january_march_2019 (
  "minister" VARCHAR,
  "start_date_of_trip" TIMESTAMP,
  "end_date_of_trip" TIMESTAMP,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "cost_of_private_jet_or_raf_plane_hire_if_relevant" VARCHAR,
  "number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" BIGINT
);

Official Overseas Travel Undertaken By FCO Ministers October - December 2018

@ukgov.overseas_travel_undertaken_by_ministers_in_fco.official_overseas_travel_undertaken_by_fco_ministers_o_11c68f59

13.14 KB
34 rows
11 columns


CREATE TABLE official_overseas_travel_undertaken_by_fco_ministers_o_11c68f59 (
  "minister" VARCHAR,
  "start_date_of_trip" TIMESTAMP,
  "end_date_of_trip" TIMESTAMP,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "cost_of_private_jet_or_raf_plane_hire_if_relevant" VARCHAR,
  "number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR,
  "unnamed_10" VARCHAR
);

Overseas Travel Undertaken By Ministers In The Foreign And Commonwealth Office

@ukgov.overseas_travel_undertaken_by_ministers_in_fco.overseas_travel_undertaken_by_ministers_in_the_foreign_4faf3122

11.95 KB
52 rows
10 columns


CREATE TABLE overseas_travel_undertaken_by_ministers_in_the_foreign_4faf3122 (
  "minister" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "end_date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "cost_of_private_jet_or_raf_plane_hire_if_relevant" DOUBLE,
  "number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" DOUBLE,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" DOUBLE
);