Cabinet Office Ministerial Overseas Travel Data
Cabinet Office
@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data
Cabinet Office
@ukgov.cabinet_office_ministerial_overseas_travel_transparency_data
CREATE TABLE cabinet_office_ministerial_overseas_travel_july_to_sep_137bf172 (
"minister" VARCHAR,
"date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose" VARCHAR,
"scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" DOUBLE,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_july_to_sep_dda07330 (
"minister" VARCHAR,
"date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose" VARCHAR,
"scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
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,
"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
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_october_to__b8a7e5ed (
"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,
"number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_july_to_sep_63d149f0 (
"minister" VARCHAR,
"date_s_of_trip" VARCHAR,
"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
);
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,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_october_to__bbccea62 (
"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,
"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
);
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,
"number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_october_to__5a1b1182 (
"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,
"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
);
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,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__06c2f6bf (
"minister" VARCHAR,
"date_s_of_trip" VARCHAR,
"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
);
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,
"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
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_may_to_july_2010 (
"minister" VARCHAR,
"date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose" VARCHAR,
"no_32_the_royal_squadron_or_other_raf_or_charter_or_sc_471ecf77" VARCHAR,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2017 (
"minister" VARCHAR,
"date_s_of_trip" VARCHAR,
"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
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_october_to__b9ac300a (
"minister" VARCHAR,
"date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose" VARCHAR,
"scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" DOUBLE,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_july_to_sep_76060046 (
"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,
"number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_july_to_sep_6f756201 (
"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,
"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
);
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,
"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
);
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,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_october_to__f80066c0 (
"minister" VARCHAR,
"date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose" VARCHAR,
"scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
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,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_october_to__ce82f8e0 (
"minister" VARCHAR,
"date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose" VARCHAR,
"scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
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,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
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,
"number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_october_to__15ddb319 (
"minister" VARCHAR,
"date_s_of_trip" VARCHAR,
"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
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_october_to__dfff4bdf (
"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,
"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
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_july_to_sep_153eecb4 (
"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,
"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
);
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,
"number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_july_to_sep_85d57ef3 (
"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,
"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
);
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,
"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
);
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,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_october_to__4682ee7d (
"minister" VARCHAR,
"date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose" VARCHAR,
"scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
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,
"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
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_july_to_sep_61861a64 (
"minister" VARCHAR,
"date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose" VARCHAR,
"scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_july_to_sep_81d1b482 (
"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,
"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
);
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,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
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,
"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
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_october_to__b7fab321 (
"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,
"number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_july_to_sep_705a40a4 (
"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,
"number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_july_2014_t_72613197 (
"minister" VARCHAR,
"date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose" VARCHAR,
"scheduled_no_32_the_royal_squadron_or_other_raf_or_cha_90b9b28a" VARCHAR,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_january_to__5090bfa7 (
"minister" VARCHAR,
"date_s_of_trip" VARCHAR,
"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
);
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,
"number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" DOUBLE,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);
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,
"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
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_october_to__55e20d45 (
"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,
"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
);
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,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
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,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_october_to__d9b998a8 (
"minister" VARCHAR,
"date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose" VARCHAR,
"no_32_the_royal_squadron_or_other_raf_or_charter_or_sc_471ecf77" VARCHAR,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
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,
"number_of_officials_accompanying_ministers_where_non_s_10b6c8fe" VARCHAR,
"total_cost_including_travel_and_accommodation_of_minister_only" VARCHAR
);
CREATE TABLE cabinet_office_ministerial_overseas_travel_april_to_june_2016 (
"minister" VARCHAR,
"date_s_of_trip" VARCHAR,
"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_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR
);
Anyone who has the link will be able to view this.