Cabinet Office - Ministerial Overseas Travel - April To June 2011

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_april_to_june_2011

7.7 kB
1 row
7 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2011 (
  "minister" VARCHAR,
  "date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose" VARCHAR,
  "scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR  -- Scheduled','No.32 (The Royal Squadron)' Or 'other RAF' Or 'Charter' Or 'Scheduled' Or 'Eurostar',
  "number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR  -- Number Of Officials Accompanying Ministers (where Non-scheduled Travel Is Used),
  "total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);

Cabinet Office - Ministerial Overseas Travel - April To June 2012

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_april_to_june_2012

7.84 kB
5 rows
7 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2012 (
  "minister" VARCHAR,
  "date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose" VARCHAR,
  "scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR  -- Scheduled','No.32 (The Royal Squadron)' Or 'other RAF' Or 'Charter' Or 'Scheduled' Or 'Eurostar',
  "number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR  -- Number Of Officials Accompanying Ministers (where Non-scheduled Travel Is Used),
  "total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);

Cabinet Office - Ministerial Overseas Travel - April To June 2013

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_april_to_june_2013

8.46 kB
11 rows
7 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2013 (
  "minister" VARCHAR,
  "date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose" VARCHAR,
  "scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR  -- Scheduled','No.32 (The Royal Squadron)' Or 'other RAF' Or 'Charter' Or 'Scheduled' Or 'Eurostar',
  "number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR  -- Number Of Officials Accompanying Ministers (where Non-scheduled Travel Is Used),
  "total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);

Cabinet Office - Ministerial Overseas Travel - April To June 2014

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_april_to_june_2014

8.48 kB
12 rows
7 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2014 (
  "minister" VARCHAR,
  "date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose" VARCHAR,
  "scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR  -- Scheduled','No.32 (The Royal Squadron)' Or 'other RAF' Or 'Charter' Or 'Scheduled' Or 'Eurostar',
  "number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR  -- Number Of Officials Accompanying Ministers (where Non-scheduled Travel Is Used),
  "total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);

Cabinet Office - Ministerial Overseas Travel - April To June 2016

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_april_to_june_2016

18.44 kB
990 rows
26 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2016 (
  "minister" VARCHAR,
  "date_s_of_trip" VARCHAR  -- Date(s) Of Trip,
  "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_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25
);

Cabinet Office - Ministerial Overseas Travel - April To June 2017

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_april_to_june_2017

8.36 kB
10 rows
9 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2017 (
  "minister" VARCHAR,
  "date_s_of_trip" VARCHAR  -- Date(s) Of Trip,
  "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 (Ł)
);

Cabinet Office - Ministerial Overseas Travel - April To June 2018

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_april_to_june_2018

9.24 kB
21 rows
9 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2018 (
  "minister" VARCHAR,
  "dates_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" DOUBLE  -- 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 (Ł)
);

Cabinet Office - Ministerial Overseas Travel - April To June 2019

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_april_to_june_2019

9.79 kB
6 rows
10 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2019 (
  "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" VARCHAR  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (£),
  "number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR  -- 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" VARCHAR  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (£)
);

Cabinet Office - Ministerial Overseas Travel - April To June 2020

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_april_to_june_2020

9.49 kB
8 rows
10 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2020 (
  "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" 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 (£)
);

Cabinet Office - Ministerial Overseas Travel - April To June 2021

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_april_to_june_2021

9.65 kB
19 rows
10 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2021 (
  "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" 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 (£)
);

Cabinet Office - Ministerial Overseas Travel - April To June 2022

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_april_to_june_2022

11.96 kB
22 rows
10 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2022 (
  "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" 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 (£)
);

Cabinet Office - Ministerial Overseas Travel - April To September 2015

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_april_to_se_36167e7f

7.77 kB
8 rows
7 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_se_36167e7f (
  "minister" VARCHAR,
  "date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose" VARCHAR,
  "scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR  -- Scheduled','No.32 (The Royal Squadron)' Or 'other RAF' Or 'Charter' Or 'Scheduled' Or 'Eurostar',
  "number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR  -- Number Of Officials Accompanying Ministers (where Non-scheduled Travel Is Used),
  "total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);

Cabinet Office - Ministerial Overseas Travel - August To September 2010

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_august_to_s_ff1c3413

7.26 kB
1 row
7 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_august_to_s_ff1c3413 (
  "minister" VARCHAR,
  "date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose" VARCHAR,
  "no_32_the_royal_squadron_or_other_raf_or_charter_or_sc_471ecf77" VARCHAR  -- No.32 (The Royal Squadron)' Or 'other RAF' Or 'Charter' Or 'Scheduled' Or 'Eurostar',
  "number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR  -- Number Of Officials Accompanying Ministers (where Non-scheduled Travel Is Used),
  "total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);

Cabinet Office - Ministerial Overseas Travel - January To March 2017

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_january_to__06c2f6bf

8.35 kB
7 rows
9 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__06c2f6bf (
  "minister" VARCHAR,
  "date_s_of_trip" VARCHAR  -- Date(s) Of Trip,
  "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 (Œ£)
);

Cabinet Office - Ministerial Overseas Travel - January To March 2020

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_january_to__20d9689b

9.3 kB
11 rows
10 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__20d9689b (
  "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" 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 (£)
);

Cabinet Office - Ministerial Overseas Travel - January To March 2018

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_january_to__236a0ac8

9.72 kB
27 rows
10 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__236a0ac8 (
  "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" VARCHAR  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (£),
  "number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR  -- 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" VARCHAR  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (£)
);

Cabinet Office - Ministerial Overseas Travel - January To March 2013

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_january_to__5058f547

8.15 kB
9 rows
7 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__5058f547 (
  "minister" VARCHAR,
  "date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose" VARCHAR,
  "scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR  -- Scheduled','No.32 (The Royal Squadron)' Or 'other RAF' Or 'Charter' Or 'Scheduled' Or 'Eurostar',
  "number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR  -- Number Of Officials Accompanying Ministers (where Non-scheduled Travel Is Used),
  "total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);

Cabinet Office - Ministerial Overseas Travel - January To March 2016

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_january_to__5090bfa7

9.07 kB
27 rows
9 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__5090bfa7 (
  "minister" VARCHAR,
  "date_s_of_trip" VARCHAR  -- Date(s) Of Trip,
  "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 (£)
);

Cabinet Office - Ministerial Overseas Travel - January To March 2011

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_january_to__5f526618

7.81 kB
1 row
7 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__5f526618 (
  "minister" VARCHAR,
  "date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose" VARCHAR,
  "scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR  -- Scheduled','No.32 (The Royal Squadron)' Or 'other RAF' Or 'Charter' Or 'Scheduled' Or 'Eurostar',
  "number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR  -- Number Of Officials Accompanying Ministers (where Non-scheduled Travel Is Used),
  "total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);

Cabinet Office - Ministerial Overseas Travel - January To March 2021

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_january_to__7ba325af

10.78 kB
20 rows
10 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__7ba325af (
  "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" 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 (£)
);

Cabinet Office - Ministerial Overseas Travel - January To March 2022

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_january_to__ab818af3

12.44 kB
20 rows
10 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__ab818af3 (
  "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" 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 (£)
);

Cabinet Office - Ministerial Overseas Travel - January To March 2023

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_january_to__ba6740d4

9.61 kB
7 rows
10 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__ba6740d4 (
  "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" 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 (£)
);

Cabinet Office - Ministerial Overseas Travel - January To March 2019

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_january_to__bf9c61cb

9.92 kB
6 rows
10 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__bf9c61cb (
  "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" VARCHAR  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (£),
  "number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR  -- 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" VARCHAR  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (£)
);

Cabinet Office - Ministerial Overseas Travel - January To March 2014

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_january_to__e4c52530

8.69 kB
13 rows
7 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__e4c52530 (
  "minister" VARCHAR,
  "date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose" VARCHAR,
  "scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR  -- Scheduled','No.32 (The Royal Squadron)' Or 'other RAF' Or 'Charter' Or 'Scheduled' Or 'Eurostar',
  "number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR  -- Number Of Officials Accompanying Ministers (where Non-scheduled Travel Is Used),
  "total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);

Cabinet Office - Ministerial Overseas Travel - January To March 2012

@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data.cabinet_office_ministerial_overseas_travel_january_to__f704672e

8.6 kB
5 rows
7 columns

CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__f704672e (
  "minister" VARCHAR,
  "date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose" VARCHAR,
  "scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR  -- Scheduled','No.32 (The Royal Squadron)' Or 'other RAF' Or 'Charter' Or 'Scheduled' Or 'Eurostar',
  "number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR  -- Number Of Officials Accompanying Ministers (where Non-scheduled Travel Is Used),
  "total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);

Cabinet Office Ministerial Overseas Travel Data

About this Dataset