Cabinet Office Special Advisers Gifts
Cabinet Office
@ukgov.cabinet_office_special_advisers_gifts
Cabinet Office
@ukgov.cabinet_office_special_advisers_gifts
CREATE TABLE cabinet_office_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 cabinet_office_special_advisers_gifts_october_to_december_2017 (
"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,
"unnamed_7" VARCHAR
);
CREATE TABLE cabinet_office_special_advisers_gifts_july_to_september_2019 (
"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 cabinet_office_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 cabinet_office_special_advisers_gifts_january_to_march_2018 (
"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,
"unnamed_7" VARCHAR
);
CREATE TABLE cabinet_office_special_advisers_gifts_january_to_march_2016 (
"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 cabinet_office_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 cabinet_office_special_advisers_gifts_april_to_june_2019 (
"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 cabinet_office_special_advisers_gifts_october_to_december_2020 (
"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 cabinet_office_special_advisers_gifts_april_to_june_2016 (
"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,
"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 cabinet_office_special_advisers_gifts_july_to_september_2020 (
"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 cabinet_office_special_advisers_gifts_october_to_december_2016 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"gift" VARCHAR,
"who_gift_was_received_from" VARCHAR,
"value" VARCHAR,
"outcome" VARCHAR
);
CREATE TABLE cabinet_office_special_advisers_gifts_july_to_september_2018 (
"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,
"unnamed_7" VARCHAR
);
CREATE TABLE cabinet_office_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 cabinet_office_special_advisers_gifts_january_to_march_2019 (
"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 cabinet_office_special_advisers_gifts_october_to_december_2019 (
"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 cabinet_office_special_advisers_gifts_july_to_september_2016 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"gift" VARCHAR,
"who_gift_was_received_from" VARCHAR,
"value" VARCHAR,
"outcome" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE cabinet_office_special_advisers_gifts_april_to_june_2018 (
"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,
"unnamed_7" VARCHAR
);
CREATE TABLE cabinet_office_special_advisers_gifts_january_to_march_2020 (
"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 cabinet_office_special_advisers_gifts_july_to_september_2017 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"gift" VARCHAR,
"who_gift_was_received_from" VARCHAR,
"value" VARCHAR,
"outcome" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE cabinet_office_special_advisers_gifts_october_to_december_2018 (
"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 cabinet_office_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 cabinet_office_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 cabinet_office_special_advisers_gifts_april_to_june_2020 (
"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 cabinet_office_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 cabinet_office_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 cabinet_office_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
);
Anyone who has the link will be able to view this.