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
CREATE TABLE fcdo_s_permanent_secretary_s_meetings_january_to_march_2022 (
"name_permanent_secretary_only" VARCHAR,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"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,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"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,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"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,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"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,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"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,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"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,
"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,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
Anyone who has the link will be able to view this.