Foreign, Commonwealth And Development Office: Senior Officials’ Business Expenses And Hospitality
Foreign, Commonwealth and Development Office (FCDO)
@ukgov.fcdo_senior_officials_business_expenses_and_hospitality
Foreign, Commonwealth and Development Office (FCDO)
@ukgov.fcdo_senior_officials_business_expenses_and_hospitality
Data on senior officials’ business expenses and hospitality, and the permanent secretary’s meetings with external organisations.
Publisher name: Foreign, Commonwealth and Development Office (FCDO)
Last updated: 2025-03-29T04:00:15Z
CREATE TABLE fcdo_s_permanent_secretary_s_meetings_january_to_march_2022 (
"name_permanent_secretary_only" VARCHAR -- Name (Permanent Secretary Only),
"date" TIMESTAMP,
"person_or_organisation_that_meeting_was_with" VARCHAR,
"purpose_of_meeting" VARCHAR
);CREATE TABLE fcdo_s_permanent_secretary_s_meetings_january_to_march_2023 (
"name_permanent_secretary_only" VARCHAR -- Name (Permanent Secretary Only),
"date" TIMESTAMP,
"person_or_organisation_that_meeting_was_with" VARCHAR,
"purpose_of_meeting" VARCHAR
);CREATE TABLE fcdo_s_permanent_secretary_s_meetings_july_to_september_2021 (
"name_permanent_secretary_only" VARCHAR -- Name (Permanent Secretary Only),
"date" TIMESTAMP,
"person_or_organisation_that_meeting_was_with" VARCHAR,
"purpose_of_meeting" VARCHAR
);CREATE TABLE fcdo_s_permanent_secretary_s_meetings_july_to_september_2022 (
"name_permanent_secretary_only" VARCHAR -- Name (Permanent Secretary Only),
"date" TIMESTAMP,
"person_or_organisation_that_meeting_was_with" VARCHAR,
"purpose_of_meeting" VARCHAR
);CREATE TABLE fcdo_s_permanent_secretary_s_meetings_october_to_december_2021 (
"name_permanent_secretary_only" VARCHAR -- Name (Permanent Secretary Only),
"date" TIMESTAMP,
"person_or_organisation_that_meeting_was_with" VARCHAR,
"purpose_of_meeting" VARCHAR
);CREATE TABLE fcdo_s_permanent_secretary_s_meetings_october_to_december_2022 (
"name_permanent_secretary_only" VARCHAR -- Name (Permanent Secretary Only),
"date" TIMESTAMP,
"person_or_organisation_that_meeting_was_with" VARCHAR,
"purpose_of_meeting" VARCHAR
);CREATE TABLE fcdo_s_permanent_under_secretary_s_meetings_april_to_june_2023 (
"name_permanent_secretary_only" VARCHAR -- Name (Permanent Secretary Only),
"date" TIMESTAMP,
"person_or_organisation_that_meeting_was_with" VARCHAR,
"purpose_of_meeting" VARCHAR
);CREATE TABLE fcdo_s_senior_officials_expenses_april_to_june_2021 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR -- Duration Of Visit (Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR -- Accommodation/Meals (Ł),
"other_including_hospitality_given" VARCHAR -- Other (including Hospitality Given),
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (Ł),
"total_cost_of_use_of_official_secure_car" VARCHAR
);CREATE TABLE fcdo_s_senior_officials_expenses_january_to_march_2021 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_in_days" VARCHAR -- Duration Of Visit (in Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR -- Other (including Hospitality Given),
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (Ł),
"total_cost_of_use_of_official_secure_car" VARCHAR
);CREATE TABLE fcdo_s_senior_officials_expenses_july_to_september_2021 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR -- Duration Of Visit (Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR -- Accommodation/Meals (£),
"other_including_hospitality_given" VARCHAR -- Other (including Hospitality Given),
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (£),
"total_cost_of_use_of_official_secure_car" VARCHAR
);CREATE TABLE fcdo_s_senior_officials_expenses_october_to_december_2021 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR -- Duration Of Visit (Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR -- Accommodation/Meals (£),
"other_including_hospitality_given" VARCHAR -- Other (including Hospitality Given),
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (£),
"total_cost_of_use_of_official_secure_car" VARCHAR
);CREATE TABLE fcdo_s_senior_officials_hospitality_april_to_june_2021 (
"senior_official_name" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_or_friend" VARCHAR -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE fcdo_s_senior_officials_hospitality_april_to_june_2022 (
"senior_official_name" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_or_friend" VARCHAR -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE fcdo_s_senior_officials_hospitality_january_to_march_2021 (
"name" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_or_friend" VARCHAR -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE fcdo_s_senior_officials_hospitality_january_to_march_2022 (
"senior_official_name" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_or_friend" VARCHAR -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE fcdo_s_senior_officials_hospitality_january_to_march_2023 (
"senior_official_name" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_or_friend" VARCHAR -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE fcdo_s_senior_officials_hospitality_july_to_september_2021 (
"senior_official_name" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_or_friend" VARCHAR -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE fcdo_s_senior_officials_hospitality_july_to_september_2022 (
"senior_official_name" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_or_friend" VARCHAR -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE fcdo_s_senior_officials_hospitality_october_to_december_2021 (
"senior_official_name" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_or_friend" VARCHAR -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE fcdo_s_senior_officials_hospitality_october_to_december_2022 (
"senior_official_name" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_or_friend" VARCHAR -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE fcdo_s_senior_officials_travel_expenses_april_to_june_2022 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR -- Duration Of Visit (Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR -- Accommodation/Meals (Ł),
"other_including_hospitality_given" VARCHAR -- Other (including Hospitality Given),
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (Ł),
"total_cost_of_use_of_official_secure_car" VARCHAR
);CREATE TABLE fcdo_s_senior_officials_travel_expenses_april_to_june_2023 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR -- Duration Of Visit (Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR -- Accommodation/Meals (£),
"other_including_hospitality_given" VARCHAR -- Other (including Hospitality Given),
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (£),
"total_cost_of_use_of_official_secure_car" VARCHAR
);CREATE TABLE fcdo_s_senior_officials_travel_expenses_january_to_march_2022 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR -- Duration Of Visit (Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR -- Accommodation/Meals (Ł),
"other_including_hospitality_given" VARCHAR -- Other (including Hospitality Given),
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (Ł),
"total_cost_of_use_of_official_secure_car" VARCHAR
);CREATE TABLE fcdo_s_senior_officials_travel_expenses_january_to_march_2023 (
"name_permanent_secretary_only" VARCHAR -- Name (Permanent Secretary Only),
"date" TIMESTAMP,
"person_or_organisation_that_meeting_was_with" VARCHAR,
"purpose_of_meeting" VARCHAR
);CREATE TABLE fcdo_s_senior_officials_travel_expenses_july_to_september_2022 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR -- Duration Of Visit (Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR -- Accommodation/Meals (Ł),
"other_including_hospitality_given" VARCHAR -- Other (including Hospitality Given),
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (Ł),
"total_cost_of_use_of_official_secure_car" VARCHAR
);Anyone who has the link will be able to view this.