DoF Senior Civil Servants Gifts & Hospitality
OpenDataNI
@ukgov.dof_senior_civil_servants_gifts_hospitality
OpenDataNI
@ukgov.dof_senior_civil_servants_gifts_hospitality
The data held is that of gifts and hospitality offered to Senior Civil Servants within Department of Finance. The files show a full list of gifts and hospitality for each financial year and if they were accepted or declined.
Publisher name: OpenDataNI
Last updated: 2025-05-06T04:01:23Z
CREATE TABLE dof_scs_gifts_hospitality_2019_20_quarter_4 (
"business_area" VARCHAR,
"date_of_offer" TIMESTAMP,
"offered_to" VARCHAR,
"grade" VARCHAR,
"ulitimate_recipient_if_different" VARCHAR -- Ulitimate Recipient (if Different),
"offered_from" VARCHAR,
"nature_of_offer" VARCHAR,
"further_details_of_offer_including_reason" VARCHAR -- Further Details Of Offer (including Reason),
"does_your_business_area_have_a_contract_with_the_organ_6af0b086" VARCHAR -- Does Your Business Area Have A Contract With The Organisation Offering The Hospitality?,
"if_yes_please_provide_details_of_contract_current_or_potential" VARCHAR -- If 'Yes' Please Provide Details Of Contract (current Or Potential),
"est_actual_value_of_offer" VARCHAR -- Est. / Actual Value Of Offer £,
"action_taken_please_select_from_drop_down" VARCHAR -- Action Taken (Please Select From Drop Down)
);CREATE TABLE dof_scs_gifts_hospitality_2020_21_quarter_1 (
"business_area" VARCHAR,
"date_of_offer" TIMESTAMP,
"offered_to" VARCHAR,
"grade" VARCHAR,
"ulitimate_recipient_if_different" VARCHAR -- Ulitimate Recipient (if Different),
"offered_from" VARCHAR,
"nature_of_offer" VARCHAR,
"further_details_of_offer_including_reason" VARCHAR -- Further Details Of Offer (including Reason),
"does_your_business_area_have_a_contract_with_the_organ_6af0b086" VARCHAR -- Does Your Business Area Have A Contract With The Organisation Offering The Hospitality?,
"if_yes_please_provide_details_of_contract_current_or_potential" VARCHAR -- If 'Yes' Please Provide Details Of Contract (current Or Potential),
"est_actual_value_of_offer" VARCHAR -- Est. / Actual Value Of Offer £,
"action_taken_please_select_from_drop_down" VARCHAR -- Action Taken (Please Select From Drop Down),
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30
);CREATE TABLE dof_scs_gifts_hospitality_2020_21_quarter_2 (
"business_area" VARCHAR,
"date_of_offer" TIMESTAMP,
"offered_to" VARCHAR,
"grade" VARCHAR,
"ulitimate_recipient_if_different" VARCHAR -- Ulitimate Recipient (if Different),
"offered_from" VARCHAR,
"nature_of_offer" VARCHAR,
"further_details_of_offer_including_reason" VARCHAR -- Further Details Of Offer (including Reason),
"does_your_business_area_have_a_contract_with_the_organ_6af0b086" VARCHAR -- Does Your Business Area Have A Contract With The Organisation Offering The Hospitality?,
"if_yes_please_provide_details_of_contract_current_or_potential" VARCHAR -- If 'Yes' Please Provide Details Of Contract (current Or Potential),
"est_actual_value_of_offer" VARCHAR -- Est. / Actual Value Of Offer £,
"action_taken_please_select_from_drop_down" VARCHAR -- Action Taken (Please Select From Drop Down)
);CREATE TABLE dof_scs_gifts_hospitality_2020_21_quarter_3 (
"business_area" VARCHAR,
"date_of_offer" VARCHAR,
"offered_to" VARCHAR,
"grade" VARCHAR,
"ulitimate_recipient_if_different" VARCHAR -- Ulitimate Recipient (if Different),
"offered_from" VARCHAR,
"nature_of_offer" VARCHAR,
"further_details_of_offer_including_reason" VARCHAR -- Further Details Of Offer (including Reason),
"does_your_business_area_have_a_contract_with_the_organ_6af0b086" VARCHAR -- Does Your Business Area Have A Contract With The Organisation Offering The Hospitality?,
"if_yes_please_provide_details_of_contract_current_or_potential" VARCHAR -- If 'Yes' Please Provide Details Of Contract (current Or Potential),
"est_actual_value_of_offer" VARCHAR -- Est. / Actual Value Of Offer Ł,
"action_taken_please_select_from_drop_down" VARCHAR -- Action Taken (Please Select From Drop Down)
);CREATE TABLE dof_scs_gifts_hospitality_2021_22_quarter_2 (
"register_of_gifts_and_hospitality_offered_to_scs_staff" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30
);CREATE TABLE dof_scs_gifts_hospitality_2021_22_quarter_3 (
"register_of_gifts_and_hospitality_offered_to_scs_staff" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30
);CREATE TABLE dof_scs_gifts_hospitality_2021_22_quarter_4 (
"register_of_gifts_and_hospitality_offered_to_scs_staff" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30
);CREATE TABLE dof_scs_gifts_hospitality_2024_25_quarter_4 (
"business_area" VARCHAR,
"date_of_offer" TIMESTAMP,
"offered_to" VARCHAR,
"grade" VARCHAR,
"ulitimate_recipient_if_different" VARCHAR -- Ulitimate Recipient (if Different),
"offered_from" VARCHAR,
"nature_of_offer" VARCHAR,
"further_details_of_offer_including_reason" VARCHAR -- Further Details Of Offer (including Reason),
"does_your_business_area_have_a_contract_with_the_organ_6af0b086" VARCHAR -- Does Your Business Area Have A Contract With The Organisation Offering The Hospitality?,
"if_yes_please_provide_details_of_contract_current_or_potential" VARCHAR -- If 'Yes' Please Provide Details Of Contract (current Or Potential),
"est_actual_value_of_offer" VARCHAR -- Est. / Actual Value Of Offer £,
"action_taken_please_select_from_drop_down" VARCHAR -- Action Taken (Please Select From Drop Down)
);Anyone who has the link will be able to view this.