Foreign, Commonwealth And Development Office: Special Advisers’ Gifts, Hospitality And Meetings

CREATE TABLE fcdo_s_special_advisers_hospitality_april_to_june_2021 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_hospitality_april_to_june_2022 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_hospitality_april_to_june_2023 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_hospitality_january_to_march_2021 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_hospitality_january_to_march_2022 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_hospitality_january_to_march_2023 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_hospitality_july_to_september_2021 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_hospitality_july_to_september_2022 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_hospitality_july_to_september_2023 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_hospitality_october_to_december_2021 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_hospitality_october_to_december_2023 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_meetings_april_to_june_2023 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_meetings_with_senior_media_fig_0758c30e (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_meetings_with_senior_media_fig_1a0876d1 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_meetings_with_senior_media_fig_47876216 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_meetings_with_senior_media_fig_55d1262d (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_meetings_with_senior_media_fig_8382d61a (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "given_or_received" VARCHAR,
  "who_gift_was_given_to_or_received_from" VARCHAR,
  "value" VARCHAR,
  "outcome_received_gifts_only" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_meetings_with_senior_media_fig_9e478ceb (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_meetings_with_senior_media_fig_b6e33f90 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_meetings_with_senior_media_fig_c8f52163 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_meetings_with_senior_media_fig_e642dd2d (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_meetings_with_senior_media_fig_fc630cf5 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);