Department For Transport Ministerial And Special Adviser Hospitality
Department for Transport
@ukgov.dft_minister_special_adviser_hospitality
Department for Transport
@ukgov.dft_minister_special_adviser_hospitality
CREATE TABLE dft_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,
"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 department_for_transport_ministerial_and_special_advis_9abb67e9 (
"minister" VARCHAR,
"date_of_hospitality" VARCHAR,
"name_of_organisation" VARCHAR,
"type_of_hospitality_received" VARCHAR
);
CREATE TABLE dft_s_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
);
CREATE TABLE dft_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 dft_special_advisers_hospitality_july_to_september_2024 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"individual_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_guest" VARCHAR
);
CREATE TABLE dft_special_advisers_hospitality_july_to_september_2023 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE dft_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 dft_special_advisers_hospitality_april_to_june_2024 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"individual_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_guest" 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 dft_s_special_advisers_hospitality_april_to_june_2018 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE dft_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 dft_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 dft_s_special_advisers_hospitality_october_to_december_2019 (
"special_adviser" 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 dft_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 dft_s_special_advisers_hospitality_july_to_september_2021 (
"special_adviser" 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 dft_special_advisers_hospitality_april_to_june_2023 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE dft_s_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 dft_s_special_advisers_hospitality_october_to_december_2018 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE dft_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,
"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 dft_ministerial_hospitality_july_to_september_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 dft_ministerial_hospitality_april_to_june_2024 (
"minister" VARCHAR,
"date" VARCHAR,
"individual_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_guest" VARCHAR
);
CREATE TABLE dft_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,
"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 dft_ministerial_hospitality_april_to_june_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 dft_special_advisers_hospitality_april_to_june_2022 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"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 dft_special_advisers_hospitality_january_to_march_2022 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE dft_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,
"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 dft_s_special_advisers_hospitality_january_to_march_2020 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"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 dft_special_advisers_hospitality_january_to_march_2024 (
"minister" VARCHAR,
"date" VARCHAR,
"individual_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_guest" VARCHAR
);
CREATE TABLE dft_ministerial_hospitality_july_to_september_2024 (
"minister" VARCHAR,
"date" VARCHAR,
"individual_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_guest" VARCHAR,
"value_of_hospitality" VARCHAR
);
CREATE TABLE dft_ministerial_hospitality_january_to_march_2022 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE dft_s_special_advisers_hospitality_april_to_june_2019 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE dft_special_advisers_hospitality_january_to_march_2023 (
"special_adviser" 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 dft_s_special_advisers_hospitality_july_to_september_2018 (
"special_adviser" 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 dft_s_special_advisers_hospitality_july_to_september_2022 (
"special_adviser" 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 dft_special_advisers_hospitality_october_to_december_2022 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"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 dft_s_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 dft_s_special_advisers_hospitality_april_to_june_2021 (
"special_adviser" 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 dft_s_special_advisers_hospitality_july_to_september_2019 (
"special_adviser" 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 dft_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 dft_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 dft_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,
"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 dft_ministerial_hospitality_october_to_december_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 dft_s_special_advisers_hospitality_january_to_march_2019 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE dft_s_special_advisers_hospitality_april_to_june_2020 (
"special_adviser" 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 dft_s_special_advisers_hospitality_october_to_december_2021 (
"special_adviser" 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 dft_s_special_advisers_hospitality_july_to_september_2020 (
"special_adviser" 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 dft_s_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 dft_s_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 dft_s_special_advisers_hospitality_october_to_december_2020 (
"special_adviser" 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 dft_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,
"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 dft_special_advisers_hospitality_october_to_december_2023 (
"special_adviser" VARCHAR,
"date" TIMESTAMP,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE dft_ministerial_hospitality_january_to_march_2024 (
"minister" VARCHAR,
"date" VARCHAR,
"individual_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_guest" VARCHAR
);
CREATE TABLE dft_s_special_advisers_hospitality_january_to_march_2021 (
"special_adviser" 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
);
Anyone who has the link will be able to view this.