Northern Ireland Office (NIO): Ministerial Gifts, Hospitality, Travel And Meetings
Northern Ireland Office
@ukgov.northern_ireland_office_nio_ministerial_gifts_hospital_0d68effb
Northern Ireland Office
@ukgov.northern_ireland_office_nio_ministerial_gifts_hospital_0d68effb
CREATE TABLE nio_ministerial_gifts_hospitality_travel_and_meetings__76b1dff3 (
"minister" VARCHAR,
"date" TIMESTAMP,
"name_of_individual_or_organisation" VARCHAR,
"purpose_of_meeting" VARCHAR
);
CREATE TABLE nio_ministerial_gifts_hospitality_travel_and_meetings__9bf76154 (
"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 nio_ministerial_gifts_january_march_2022 (
"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 nio_ministerial_hospitality_january_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 nio_ministerial_overseas_travel_january_march_2022 (
"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" DOUBLE
);
CREATE TABLE nio_s_ministerial_gifts_january_to_march_2024 (
"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 nio_s_ministerial_gifts_july_to_september_2023 (
"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 nio_s_ministerial_gifts_october_december_2023 (
"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 nio_s_ministerial_hospitality_january_to_march_2024 (
"minister" VARCHAR,
"date" TIMESTAMP,
"individual_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_guest" VARCHAR
);
CREATE TABLE nio_s_ministerial_hospitality_july_to_september_2023 (
"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 nio_s_ministerial_hospitality_october_december_2023 (
"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 nio_s_ministerial_meetings_january_to_march_2024 (
"minister" VARCHAR,
"date" TIMESTAMP,
"name_of_individual_or_organisation" VARCHAR,
"purpose_of_meeting" VARCHAR
);
CREATE TABLE nio_s_ministerial_meetings_july_to_september_2023 (
"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 nio_s_ministerial_meetings_october_december_2023 (
"minister" VARCHAR,
"date" TIMESTAMP,
"name_of_organisation_or_individual" VARCHAR,
"purpose_of_meeting" VARCHAR
);
CREATE TABLE nio_s_ministerial_overseas_travel_january_to_march_2024 (
"minister" VARCHAR,
"start_date" VARCHAR,
"end_date" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_s_of_transport" VARCHAR,
"number_of_officials_who_accompanied_the_minister_if_no_001f8f33" VARCHAR,
"accompanied_by_spouse_partner_at_public_expense" VARCHAR,
"subtotal_of_all_travel_costs_including_any_non_schedul_7478907f" VARCHAR,
"subtotal_of_associated_costs_for_minister_only_includi_2ab79d48" VARCHAR,
"total_cost" VARCHAR
);
CREATE TABLE nio_s_ministerial_overseas_travel_july_to_september_2023 (
"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 nio_s_ministerial_overseas_travel_october_december_2023 (
"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" VARCHAR
);
Anyone who has the link will be able to view this.