Ministerial Gifts, Hospitality, Travel And Meetings With External Organisations
Department for Business, Energy and Industrial Strategy
@ukgov.disclosure_ministerial_gifts_hospitality_travel_and_me_08ad5eac
Department for Business, Energy and Industrial Strategy
@ukgov.disclosure_ministerial_gifts_hospitality_travel_and_me_08ad5eac
CREATE TABLE beis_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,
"outcome_received_gifts_only" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE beis_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,
"outcome_received_gifts_only" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE beis_ministerial_gifts_october_to_december_2018 (
"minister" VARCHAR,
"date" VARCHAR,
"gift" VARCHAR,
"given_or_received" VARCHAR,
"who_gift_was_given_to_or_received_from" VARCHAR,
"value" VARCHAR,
"outcome_received_gifts_only" VARCHAR
);
CREATE TABLE beis_ministerial_hospitality_january_to_march_2019 (
"minister" 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 beis_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 beis_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 beis_ministerial_meetings_january_to_march_2019 (
"minister" VARCHAR,
"date" VARCHAR,
"name_of_organisation_or_individual" VARCHAR,
"purpose_of_meeting" VARCHAR
);
CREATE TABLE beis_ministerial_meetings_july_to_september_2019 (
"minister" VARCHAR,
"date" VARCHAR,
"name_of_organisation_or_individual" VARCHAR,
"purpose_of_meeting" VARCHAR
);
CREATE TABLE beis_ministerial_meetings_october_to_december_2018 (
"minister" VARCHAR,
"date" VARCHAR,
"name_of_organisation_or_individual" VARCHAR,
"purpose_of_meeting" VARCHAR
);
CREATE TABLE beis_ministerial_travel_january_to_march_2019 (
"minister" VARCHAR,
"start_date_of_trip" VARCHAR,
"end_date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"cost_of_private_jet_or_raf_plane_hire_if_relevant" VARCHAR,
"number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);
CREATE TABLE beis_ministerial_travel_july_to_september_2019 (
"minister" VARCHAR,
"start_date_of_trip" VARCHAR,
"end_date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"cost_of_private_jet_or_raf_plane_hire_if_relevant" VARCHAR,
"number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);
CREATE TABLE beis_ministerial_travel_october_to_december_2018 (
"minister" VARCHAR,
"start_date_of_trip" VARCHAR,
"end_date_of_trip" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"cost_of_private_jet_or_raf_plane_hire_if_relevant" VARCHAR,
"number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);
CREATE TABLE ministerial_gifts_hospitality_travel_and_meetings_with_b654c6d1 (
"minister" VARCHAR,
"start_date_of_trip" TIMESTAMP,
"end_date_of_trip" TIMESTAMP,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"cost_of_private_jet_or_raf_plane_hire_if_relevant" VARCHAR,
"number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" DOUBLE
);
Anyone who has the link will be able to view this.