Cabinet Office Ministerial Hospitality Data
Cabinet Office
@ukgov.cabinet_office_ministerial_hospitality_transparency_data
Cabinet Office
@ukgov.cabinet_office_ministerial_hospitality_transparency_data
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-07T02:13:35Z
CREATE TABLE cabinet_office_ministerial_hospitality_april_to_june_2011 (
"minister" VARCHAR,
"date_of_hospitality" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_april_to_june_2012 (
"minister" VARCHAR,
"date_of_hospitality" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_april_to_june_2013 (
"minister" VARCHAR,
"date_of_hospitality" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_april_to_june_2014 (
"minister" VARCHAR,
"date_of_hospitality" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_april_to_june_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?,
"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 cabinet_office_ministerial_hospitality_april_to_june_2017 (
"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_hospitality_april_to_june_2018 (
"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?,
"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 cabinet_office_ministerial_hospitality_april_to_june_2019 (
"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_hospitality_april_to_june_2020 (
"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_hospitality_april_to_june_2021 (
"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_hospitality_april_to_june_2022 (
"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_hospitality_april_to_september_2015 (
"ministers" VARCHAR,
"date" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"unnamed_4" VARCHAR -- Unnamed: 4
);CREATE TABLE cabinet_office_ministerial_hospitality_august_to_september_2010 (
"minister" VARCHAR,
"date_of_hospitality" TIMESTAMP,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_january_to_march_2011 (
"minister" VARCHAR,
"date_of_hospitality" TIMESTAMP,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_january_to_march_2012 (
"minister" VARCHAR,
"date_of_hospitality" TIMESTAMP,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_january_to_march_2013 (
"minister" VARCHAR,
"date_of_hospitality" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_january_to_march_2014 (
"minister" VARCHAR,
"date_of_hospitality" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_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_hospitality_january_to_march_2017 (
"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_hospitality_january_to_march_2018 (
"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_hospitality_january_to_march_2019 (
"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_hospitality_january_to_march_2020 (
"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_hospitality_january_to_march_2021 (
"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_hospitality_january_to_march_2022 (
"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_hospitality_january_to_march_2023 (
"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?
);Anyone who has the link will be able to view this.