Cabinet Office Ministerial Hospitality Data
Cabinet Office
@ukgov.cabinet_office_ministerial_hospitality_transparency_data
Cabinet Office
@ukgov.cabinet_office_ministerial_hospitality_transparency_data
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
);
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
);
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
);
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
);
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
);
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_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
);
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
);
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
);
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
);
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
);
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
);
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_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_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
);
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_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
);
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
);
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
);
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
);
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_april_to_september_2015 (
"ministers" VARCHAR,
"date" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"unnamed_4" 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_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
);
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
);
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
);
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
);
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,
"unnamed_5" VARCHAR,
"unnamed_6" 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_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
);
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
);
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_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_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_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
);
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,
"unnamed_5" VARCHAR,
"unnamed_6" 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_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
);
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
);
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
);
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_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_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_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_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_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
);
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
);
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
);
Anyone who has the link will be able to view this.