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  -- Value (£),
  "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  -- Value (£),
  "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  -- Value (£),
  "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  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (£),
  "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: 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,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25
);

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  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (Ł),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (ś),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (Ł),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (Ł),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (Ł),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);