DoF Senior Civil Servants Gifts & Hospitality
OpenDataNI
@ukgov.dof_senior_civil_servants_gifts_hospitality
OpenDataNI
@ukgov.dof_senior_civil_servants_gifts_hospitality
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,
"offered_from" VARCHAR,
"nature_of_offer" VARCHAR,
"further_details_of_offer_including_reason" VARCHAR,
"does_your_business_area_have_a_contract_with_the_organ_6af0b086" VARCHAR,
"if_yes_please_provide_details_of_contract_current_or_potential" VARCHAR,
"est_actual_value_of_offer" VARCHAR,
"action_taken_please_select_from_drop_down" VARCHAR
);
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,
"offered_from" VARCHAR,
"nature_of_offer" VARCHAR,
"further_details_of_offer_including_reason" VARCHAR,
"does_your_business_area_have_a_contract_with_the_organ_6af0b086" VARCHAR,
"if_yes_please_provide_details_of_contract_current_or_potential" VARCHAR,
"est_actual_value_of_offer" VARCHAR,
"action_taken_please_select_from_drop_down" 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,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR
);
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,
"offered_from" VARCHAR,
"nature_of_offer" VARCHAR,
"further_details_of_offer_including_reason" VARCHAR,
"does_your_business_area_have_a_contract_with_the_organ_6af0b086" VARCHAR,
"if_yes_please_provide_details_of_contract_current_or_potential" VARCHAR,
"est_actual_value_of_offer" VARCHAR,
"action_taken_please_select_from_drop_down" VARCHAR
);
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,
"offered_from" VARCHAR,
"nature_of_offer" VARCHAR,
"further_details_of_offer_including_reason" VARCHAR,
"does_your_business_area_have_a_contract_with_the_organ_6af0b086" VARCHAR,
"if_yes_please_provide_details_of_contract_current_or_potential" VARCHAR,
"est_actual_value_of_offer" VARCHAR,
"action_taken_please_select_from_drop_down" VARCHAR
);
CREATE TABLE dof_scs_gifts_hospitality_2021_22_quarter_2 (
"register_of_gifts_and_hospitality_offered_to_scs_staff" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" 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,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR
);
CREATE TABLE dof_scs_gifts_hospitality_2021_22_quarter_3 (
"register_of_gifts_and_hospitality_offered_to_scs_staff" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" 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,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR
);
CREATE TABLE dof_scs_gifts_hospitality_2021_22_quarter_4 (
"register_of_gifts_and_hospitality_offered_to_scs_staff" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" 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,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR
);
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,
"offered_from" VARCHAR,
"nature_of_offer" VARCHAR,
"further_details_of_offer_including_reason" VARCHAR,
"does_your_business_area_have_a_contract_with_the_organ_6af0b086" VARCHAR,
"if_yes_please_provide_details_of_contract_current_or_potential" VARCHAR,
"est_actual_value_of_offer" VARCHAR,
"action_taken_please_select_from_drop_down" VARCHAR
);
Anyone who has the link will be able to view this.