FCDO’s Ministerial Travel, April To June 2021

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_april_to_june_2021

13.12 KB
23 rows
10 columns


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

FCDO’s Ministerial Travel, April To June 2022

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_april_to_june_2022

14.11 KB
35 rows
10 columns


CREATE TABLE fcdo_s_ministerial_travel_april_to_june_2022 (
  "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_c3cc6878" DOUBLE
);

FCDO's Ministerial Travel, April To June 2023

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_april_to_june_2023

15.41 KB
41 rows
10 columns


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

FCDO's Ministerial Travel, April To June 2024

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_april_to_june_2024

15.21 KB
41 rows
11 columns


CREATE TABLE fcdo_s_ministerial_travel_april_to_june_2024 (
  "minister" VARCHAR,
  "start_date" VARCHAR,
  "end_date" TIMESTAMP,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_s_of_transport" VARCHAR,
  "number_of_officials_who_accompanied_the_minister_if_no_001f8f33" VARCHAR,
  "accompanied_by_spouse_partner_at_public_expense" VARCHAR,
  "subtotal_of_all_travel_costs_including_any_non_schedul_7478907f" VARCHAR,
  "subtotal_of_associated_costs_for_minister_only_includi_2ab79d48" VARCHAR,
  "total_cost" VARCHAR
);

FCDO’s Ministerial Travel, January To March 2021

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_january_to_march_2021

11.28 KB
14 rows
10 columns


CREATE TABLE fcdo_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
);

FCDO’s Ministerial Travel, January To March 2022

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_january_to_march_2022

14.24 KB
39 rows
10 columns


CREATE TABLE fcdo_s_ministerial_travel_january_to_march_2022 (
  "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_c3cc6878" VARCHAR
);

FCDO's Ministerial Travel, January To March 2023

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_january_to_march_2023

15.62 KB
45 rows
10 columns


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

FCDO's Ministerial Travel, January To March 2024

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_january_to_march_2024

16.45 KB
47 rows
11 columns


CREATE TABLE fcdo_s_ministerial_travel_january_to_march_2024 (
  "minister" VARCHAR,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_s_of_transport" VARCHAR,
  "number_of_officials_who_accompanied_the_minister_if_no_001f8f33" VARCHAR,
  "accompanied_by_spouse_partner_at_public_expense" VARCHAR,
  "subtotal_of_all_travel_costs_including_any_non_schedul_7478907f" VARCHAR,
  "subtotal_of_associated_costs_for_minister_only_includi_2ab79d48" VARCHAR,
  "total_cost" VARCHAR
);

FCDO’s Ministerial Travel, July To September 2021

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_july_to_september_2021

11.55 KB
356 rows
10 columns


CREATE TABLE fcdo_s_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
);

FCDO’s Ministerial Travel, July To September 2022

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_july_to_september_2022

12.15 KB
27 rows
10 columns


CREATE TABLE fcdo_s_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
);

FCDO's Ministerial Travel, July To September 2023

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_july_to_september_2023

13.23 KB
25 rows
10 columns


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

FCDO's Ministerial Travel, July To September 2024

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_july_to_september_2024

22.42 KB
992 rows
26 columns


CREATE TABLE fcdo_s_ministerial_travel_july_to_september_2024 (
  "minister" VARCHAR,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_s_of_transport" VARCHAR,
  "number_of_officials_who_accompanied_the_minister_if_no_001f8f33" VARCHAR,
  "accompanied_by_spouse_partner_at_public_expense" VARCHAR,
  "subtotal_of_all_travel_costs_including_any_non_schedul_7478907f" VARCHAR,
  "subtotal_of_associated_costs_for_minister_only_includi_2ab79d48" VARCHAR,
  "total_cost" 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
);

FCDO's Ministerial Travel, October To December 2020

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_october_to_december_2020

12.32 KB
18 rows
10 columns


CREATE TABLE fcdo_s_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
);

FCDO's Ministerial Travel, October To December 2021

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_october_to_december_2021

12.36 KB
23 rows
10 columns


CREATE TABLE fcdo_s_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_unless_otherwise_indicate_9ee14a6a" VARCHAR
);

FCDO's Ministerial Travel, October To December 2023

@ukgov.fcdo_ministers_gifts_hospitality_travel_and_meetings.fcdo_s_ministerial_travel_october_to_december_2023

15.5 KB
50 rows
10 columns


CREATE TABLE fcdo_s_ministerial_travel_october_to_december_2023 (
  "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" DOUBLE,
  "number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
  "n__total_cost_for_minister_only_including_all_visas_ac_cecf7bec" DOUBLE
);

Foreign, Commonwealth And Development Office: Ministers Gifts, Hospitality, Travel And Meetings

About this Dataset