Foreign, Commonwealth And Development Office: Senior Officials’ Business Expenses And Hospitality

CREATE TABLE fcdo_permanent_under_secretaries_directors_general_and_0478df06 (
  "senior_official_s_name" VARCHAR,
  "date" VARCHAR,
  "name_of_individual_or_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_permanent_under_secretaries_directors_general_and_130b66df (
  "senior_official_s_name" VARCHAR,
  "date" VARCHAR,
  "name_of_individual_or_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_permanent_under_secretaries_directors_general_and_3b939db2 (
  "senior_official_s_name" VARCHAR,
  "date" VARCHAR,
  "name_of_individual_or_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_permanent_under_secretaries_directors_general_and_ccf0cd6c (
  "senior_official_s_name" VARCHAR,
  "date" VARCHAR,
  "name_of_individual_or_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_permanent_under_secretaries_meetings_july_to_sept_bc83ed7a (
  "name_permanent_secretary_only_d5c17a1_d16" VARCHAR  -- Name (Permanent Secretary Only)+D5C17A1:D16,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

CREATE TABLE fcdo_permanent_under_secretaries_meetings_october_to_d_70b8ea37 (
  "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_permanent_under_secretary_s_meetings_with_externa_0a3a018d (
  "name_permanent_secretary_only" VARCHAR  -- Name (Permanent Secretary Only),
  "date" VARCHAR,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_senior_officials_business_expenses_april_to_june_2024 (
  "senior_official_s_name" VARCHAR,
  "start_date_of_expense" VARCHAR,
  "end_date_of_expense" VARCHAR,
  "purpose_of_expense" VARCHAR,
  "destination" VARCHAR,
  "mode_s_of_transport" VARCHAR  -- Mode(s) Of Transport,
  "class_of_transport" VARCHAR,
  "sub_total_of_all_transport_used" VARCHAR  -- Sub- Total Of All Transport Used (£),
  "sub_total_costs_of_all_accommodation_and_meals" VARCHAR  -- Sub - Total Costs Of All Accommodation And Meals (£),
  "sub_total_cost_of_all_other_expenses_including_hospita_da45d94f" VARCHAR  -- Sub- Total Cost Of All Other Expenses, Including Hospitality Given (£),
  "total_cost_of_expenses_claimed" VARCHAR  -- Total Cost Of Expenses Claimed (£)
);

CREATE TABLE fcdo_senior_officials_business_expenses_january_to_march_2024 (
  "senior_official_s_name" VARCHAR,
  "start_date_of_expense" VARCHAR,
  "end_date_of_expense" VARCHAR,
  "purpose_of_expense" VARCHAR,
  "destination" VARCHAR,
  "mode_s_of_transport" VARCHAR  -- Mode(s) Of Transport,
  "class_of_transport" VARCHAR,
  "sub_total_of_all_transport_used" VARCHAR  -- Sub- Total Of All Transport Used (£),
  "sub_total_costs_of_all_accommodation_and_meals" VARCHAR  -- Sub - Total Costs Of All Accommodation And Meals (£),
  "sub_total_cost_of_all_other_expenses_including_hospita_da45d94f" VARCHAR  -- Sub- Total Cost Of All Other Expenses, Including Hospitality Given (£),
  "total_cost_of_expenses_claimed" VARCHAR  -- Total Cost Of Expenses Claimed (£)
);

CREATE TABLE fcdo_senior_officials_business_expenses_july_to_september_2024 (
  "senior_official_s_name" VARCHAR,
  "start_date_of_expense" VARCHAR,
  "end_date_of_expense" VARCHAR,
  "purpose_pf_expense" VARCHAR,
  "destination" VARCHAR,
  "mode_s_of_transport" VARCHAR  -- Mode(s) Of Transport,
  "class_of_transport" VARCHAR,
  "sub_total_of_all_transport_used" VARCHAR  -- Sub- Total Of All Transport Used (£),
  "sub_total_costs_of_all_accommodation_and_meals" VARCHAR  -- Sub - Total Costs Of All Accommodation And Meals (£),
  "sub_total_cost_of_all_other_expenses_including_hospita_da45d94f" VARCHAR  -- Sub- Total Cost Of All Other Expenses, Including Hospitality Given (£),
  "total_cost_of_expenses_claimed" VARCHAR  -- Total Cost Of Expenses Claimed (£)
);

CREATE TABLE fcdo_senior_officials_business_expenses_october_to_dec_8f3e86de (
  "senior_official_s_name" VARCHAR,
  "start_date_of_expense" VARCHAR,
  "end_date_of_expense" VARCHAR,
  "purpose_of_expense" VARCHAR,
  "destination" VARCHAR,
  "mode_s_of_transport" VARCHAR  -- Mode(s) Of Transport,
  "class_of_transport" VARCHAR,
  "sub_total_of_all_transport_used" VARCHAR  -- Sub- Total Of All Transport Used (£),
  "sub_total_costs_of_all_accommodation_and_meals" VARCHAR  -- Sub - Total Costs Of All Accommodation And Meals (£),
  "sub_total_cost_of_all_other_expenses_including_hospita_da45d94f" VARCHAR  -- Sub- Total Cost Of All Other Expenses, Including Hospitality Given (£),
  "total_cost_of_expenses_claimed" VARCHAR  -- Total Cost Of Expenses Claimed (£)
);

CREATE TABLE fcdo_senior_officials_business_expenses_october_to_dec_da4cf0fe (
  "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_senior_officials_hospitality_april_to_june_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_senior_officials_hospitality_april_to_june_2024 (
  "senior_official_s_name" VARCHAR,
  "date" VARCHAR,
  "individual_or_organisation_that_provided_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR
);

CREATE TABLE fcdo_senior_officials_hospitality_january_to_march_2024 (
  "senior_official_s_name" VARCHAR,
  "date" VARCHAR,
  "individual_or_organisation_that_provided_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR
);

CREATE TABLE fcdo_senior_officials_hospitality_july_to_september_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_senior_officials_hospitality_july_to_september_2024 (
  "senior_official_s_name" VARCHAR,
  "date" VARCHAR,
  "individual_or_organisation_that_provided_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

CREATE TABLE fcdo_senior_officials_hospitality_october_to_december_2020 (
  "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_senior_officials_hospitality_october_to_december_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_senior_officials_hospitality_october_to_december_2024 (
  "senior_official_s_name" VARCHAR,
  "date" VARCHAR,
  "individual_or_organisation_that_provided_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR
);

CREATE TABLE fcdo_senior_officials_travel_expenses_july_to_september_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  -- Accommodation/Meals £,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR  -- Total Cost; Including All Visas; Accommodation; Travel; Meals Etc. £,
  "n__total_cost_of_use_of_official_secure_car" VARCHAR  -- Total Cost Of Use Of Official Secure Car
);

CREATE TABLE fcdo_senior_officials_travel_expenses_october_to_december_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  -- Accommodation/Meals £,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR  -- Total Cost; Including All Visas; Accommodation; Travel; Meals Etc. £,
  "n__total_cost_of_use_of_official_secure_car" VARCHAR  -- Total Cost Of Use Of Official Secure Car
);

CREATE TABLE fcdo_s_permanent_secretary_s_meetings_april_to_june_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_april_to_june_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_2021 (
  "name_permanent_secretary_only" VARCHAR  -- Name (Permanent Secretary Only),
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);