Cabinet Office Ministerial Gifts Data
Cabinet Office
@ukgov.cabinet_office_ministerial_gift_transparency
Cabinet Office
@ukgov.cabinet_office_ministerial_gift_transparency
This is a collection and collation page for an element of Cabinet Office Ministerial Transparency publications [published here: https://www.gov.uk/government/collections/ministers-transparency-publications].
Publisher name: Cabinet Office
Last updated: 2024-06-14T04:01:29Z
CREATE TABLE cabinet_office_ministerial_gifts_april_to_june_2013 (
"minister" VARCHAR,
"date_received" VARCHAR,
"from" VARCHAR,
"gift" VARCHAR,
"value" VARCHAR -- Value (£),
"n__outcome" VARCHAR -- Outcome
);CREATE TABLE cabinet_office_ministerial_gifts_april_to_june_2016 (
"minister" 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),
"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 cabinet_office_ministerial_gifts_april_to_june_2017 (
"minister" 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 cabinet_office_ministerial_gifts_april_to_june_2018 (
"minister" 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),
"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 cabinet_office_ministerial_gifts_april_to_june_2019 (
"minister" 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 cabinet_office_ministerial_gifts_april_to_june_2020 (
"minister" 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 cabinet_office_ministerial_gifts_april_to_june_2021 (
"minister" 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 cabinet_office_ministerial_gifts_april_to_june_2022 (
"minister" 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 cabinet_office_ministerial_gifts_april_to_september_2015 (
"minister" 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 cabinet_office_ministerial_gifts_august_to_september_2010 (
"minister" VARCHAR,
"date_of_hospitality" TIMESTAMP,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_gifts_given_july_2014_to_march_2015 (
"ministers" VARCHAR,
"from" VARCHAR,
"gift" VARCHAR,
"value" VARCHAR,
"outcome" VARCHAR
);CREATE TABLE cabinet_office_ministerial_gifts_january_to_march_2014 (
"minister" VARCHAR,
"date_gift_received" VARCHAR,
"from" VARCHAR,
"gift" VARCHAR,
"value" VARCHAR,
"outcome" VARCHAR
);CREATE TABLE cabinet_office_ministerial_gifts_january_to_march_2016 (
"minister" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR -- Accompanied By Spouse, Family Member(s) Or Friend?
);CREATE TABLE cabinet_office_ministerial_gifts_january_to_march_2017 (
"minister" 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 cabinet_office_ministerial_gifts_january_to_march_2018 (
"minister" 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),
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE cabinet_office_ministerial_gifts_january_to_march_2019 (
"minister" 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 cabinet_office_ministerial_gifts_january_to_march_2020 (
"minister" 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 cabinet_office_ministerial_gifts_january_to_march_2021 (
"minister" 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 cabinet_office_ministerial_gifts_january_to_march_2022 (
"minister" 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 cabinet_office_ministerial_gifts_january_to_march_2023 (
"minister" 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 cabinet_office_ministerial_gifts_july_to_september_2011 (
"minister" VARCHAR,
"date_received" TIMESTAMP,
"from" VARCHAR,
"gift" VARCHAR,
"value" VARCHAR -- Value (Ł),
"n__outcome" VARCHAR -- Outcome
);CREATE TABLE cabinet_office_ministerial_gifts_july_to_september_2017 (
"minister" 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),
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE cabinet_office_ministerial_gifts_july_to_september_2018 (
"minister" 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 cabinet_office_ministerial_gifts_july_to_september_2019 (
"minister" 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 cabinet_office_ministerial_gifts_july_to_september_2020 (
"minister" 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)
);Anyone who has the link will be able to view this.