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.74 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  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (£),
  "number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR  -- Number Of Officials Who Accompanied Minister If Non-scheduled Travel Was Used,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend At Public Expense?,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (£),
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

FCO Ministers Overseas Travel January - March 2019

@ukgov.overseas_travel_undertaken_by_ministers_in_fco.fco_ministers_overseas_travel_january_march_2019

13.29 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  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (Ł),
  "number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR  -- Number Of Officials Who Accompanied Minister If Non-scheduled Travel Was Used,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend At Public Expense?,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" BIGINT  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (Ł)
);

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.45 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  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (£),
  "number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR  -- Number Of Officials Who Accompanied Minister If Non-scheduled Travel Was Used,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend At Public Expense?,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (£),
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

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

12.23 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  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (Ł),
  "number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" DOUBLE  -- Number Of Officials Who Accompanied Minister If Non-shceduled Travel Was Used,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend At Public Expense?,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" DOUBLE  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (Ł)
);