Department For Transport Ministerial Overseas Travel
Department for Transport
@ukgov.dft_minister_overseas_travel
Department for Transport
@ukgov.dft_minister_overseas_travel
CREATE TABLE department_for_transport_ministerial_overseas_travel (
"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,
"unnamed_7" VARCHAR
);
CREATE TABLE dft_s_ministerial_travel_april_to_june_2018 (
"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 dft_ministerial_travel_july_to_september_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,
"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
);
CREATE TABLE dft_ministerial_travel_october_to_december_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,
"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
);
CREATE TABLE dft_s_ministerial_travel_october_to_december_2018 (
"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 dft_overseas_ministerial_travel_january_to_march_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 dft_s_ministerial_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 dft_ministerial_travel_july_to_september_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 dft_overseas_ministerial_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,
"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
);
CREATE TABLE dft_s_ministerial_travel_july_to_september_2018 (
"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 dft_s_ministerial_travel_april_to_june_2019 (
"minister" VARCHAR,
"date" TIMESTAMP,
"name_of_organisation_or_individual" VARCHAR,
"purpose_of_meeting" VARCHAR
);
CREATE TABLE dft_overseas_ministerial_travel_october_to_december_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,
"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
);
CREATE TABLE dft_ministerial_travel_october_to_december_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 dft_s_ministerial_travel_january_to_march_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 dft_s_ministerial_travel_january_to_march_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
);
Anyone who has the link will be able to view this.