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_july_2014_to_march_2015 (
"ministers" VARCHAR,
"date" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_july_to_august_2011 (
"minister" VARCHAR,
"date_of_hospitality" TIMESTAMP,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_july_to_september_2012 (
"minister" VARCHAR,
"date_of_hospitality" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_july_to_september_2013 (
"minister" VARCHAR,
"date_of_hospitality" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_july_to_september_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_july_to_september_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_july_to_september_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_july_to_september_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_july_to_september_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_july_to_september_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_july_to_september_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_may_to_july_2010 (
"minister" VARCHAR,
"date_of_hospitality" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_october_to_december_2010 (
"minister" VARCHAR,
"date_of_hospitality" TIMESTAMP,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_october_to_december_2011 (
"minister" VARCHAR,
"date_of_hospitality" TIMESTAMP,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_october_to_december_2012 (
"minister" VARCHAR,
"date_of_hospitality" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_october_to_december_2013 (
"minister" VARCHAR,
"date_of_hospitality" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);CREATE TABLE cabinet_office_ministerial_hospitality_october_to_december_2015 (
"ministers" VARCHAR,
"date" VARCHAR,
"name_of_organisation" 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_october_to_december_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_october_to_december_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_october_to_december_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_october_to_december_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_october_to_december_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_october_to_december_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_october_to_december_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?
);Anyone who has the link will be able to view this.