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
Data on gifts that ministers gave and received, their external meetings and any overseas travel. Northern Ireland Office (NIO) publishes details of ministers’ meetings with external organisations, gifts (given and received), hospitality and overseas travel on a quarterly basis. Prior to 2021, spend data was published on GOV.UK at: transparency-and-freedom-of-information-releases-northern-ireland-office The published data is validated and released in CSV format and OGL-licensed for reuse. For more information about this series, see: how-to-publish-ministerial-gifts-hospitality-travel-and-meetings
Publisher name: Northern Ireland Office
Last updated: 2025-03-27T04:01:38Z
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 -- Value (£),
"outcome_received_gifts_only" VARCHAR -- Outcome (received Gifts Only)
);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 -- Value (£),
"outcome_received_gifts_only" VARCHAR -- Outcome (received Gifts Only)
);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 -- Accompanied By Spouse, Family Member(s) Or Friend?
);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 -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (£),
"number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR -- Number Of Officials Who Accompanied Minister If Non-scheduled Travel Was Used,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR -- Accompanied By Spouse, Family Member(s) Or Friend At Public Expense?,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" DOUBLE -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (£)
);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 -- Value (£),
"outcome_received_gifts_only" VARCHAR -- Outcome (received Gifts Only)
);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 -- Value (£),
"outcome_received_gifts_only" VARCHAR -- Outcome (received Gifts Only)
);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 -- Value (£),
"outcome_received_gifts_only" VARCHAR -- Outcome (received Gifts Only)
);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 -- Value (£),
"outcome_received_gifts_only" VARCHAR -- Outcome (received Gifts Only)
);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 -- Accompanied By Spouse, Family Member(s) Or Friend?
);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 -- Value (£),
"outcome_received_gifts_only" VARCHAR -- Outcome (received Gifts Only)
);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 -- Mode(s) Of Transport,
"number_of_officials_who_accompanied_the_minister_if_no_001f8f33" VARCHAR -- Number Of Officials Who Accompanied The Minister If Non-scheduled Flight Was Taken,
"accompanied_by_spouse_partner_at_public_expense" VARCHAR -- Accompanied By Spouse/ Partner At Public Expense,
"subtotal_of_all_travel_costs_including_any_non_schedul_7478907f" VARCHAR -- Subtotal Of All Travel Costs Including Any Non-scheduled/ RAF Flights (£),
"subtotal_of_associated_costs_for_minister_only_includi_2ab79d48" VARCHAR -- Subtotal Of Associated Costs (for Minister Only) Including All Visas, Accommodation, Meals Etc. (£),
"total_cost" VARCHAR -- Total Cost (£)
);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 -- Value (£),
"outcome_received_gifts_only" VARCHAR -- Outcome (received Gifts Only)
);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 -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (£),
"number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR -- Number Of Officials Who Accompanied Minister If Non-scheduled Travel Was Used,
"accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR -- Accompanied By Spouse, Family Member(s) Or Friend At Public Expense?,
"total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (£)
);Anyone who has the link will be able to view this.