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

CREATE TABLE fcdo_special_advisers_gifts_april_to_june_2024 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "who_gift_was_received_from" VARCHAR,
  "value" VARCHAR,
  "outcome" VARCHAR
);

CREATE TABLE fcdo_special_advisers_gifts_january_to_march_2024 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "who_gift_was_received_from" VARCHAR,
  "value" VARCHAR,
  "outcome" VARCHAR
);

CREATE TABLE fcdo_special_advisers_gifts_july_to_september_2024 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "who_gift_was_received_from" VARCHAR,
  "value" VARCHAR,
  "outcome" VARCHAR
);

CREATE TABLE fcdo_special_advisers_gifts_october_to_december_2022 (
  "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_special_advisers_gifts_october_to_december_2024 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "who_gift_was_received_from" VARCHAR,
  "value" VARCHAR,
  "outcome" VARCHAR
);

CREATE TABLE fcdo_special_advisers_hospitality_april_to_june_2024 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "individual_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR
);

CREATE TABLE fcdo_special_advisers_hospitality_january_to_march_2024 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "individual_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR
);

CREATE TABLE fcdo_special_advisers_hospitality_july_to_september_2024 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "individual_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" 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
);

CREATE TABLE fcdo_special_advisers_hospitality_october_to_december_2024 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "individual_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR
);

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

CREATE TABLE fcdo_special_advisers_meetings_with_senior_media_figur_209d3b2f (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_senior_media_figure" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_special_advisers_meetings_with_senior_media_figur_9aef3e81 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_senior_media_figure" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_special_advisers_meetings_with_senior_media_figur_b56209b1 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_senior_media_figure" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_special_advisers_meetings_with_senior_media_figur_cc7c6440 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_senior_media_figure" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE fcdo_s_special_advisers_gifts_april_to_june_2021 (
  "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_gifts_april_to_june_2022 (
  "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_gifts_april_to_june_2023 (
  "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_gifts_january_to_march_2021 (
  "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_gifts_january_to_march_2022 (
  "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_gifts_january_to_march_2023 (
  "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_gifts_july_to_september_2021 (
  "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_gifts_july_to_september_2022 (
  "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_gifts_july_to_september_2023 (
  "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_gifts_october_to_december_2021 (
  "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_gifts_october_to_december_2023 (
  "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
);