Special Advisers' Gifts And Hospitality From January 2020 To September 2023
OpenDataNI
@ukgov.special_advisers_gifts_and_hospitality_from_january_to_d2e5def1
OpenDataNI
@ukgov.special_advisers_gifts_and_hospitality_from_january_to_d2e5def1
This dataset contains details of Special Advisers' Gifts and Hospitality for the period January 2020 to September 2023
Publisher name: OpenDataNI
Last updated: 2023-11-18T04:08:25Z
CREATE TABLE special_adviser_gifts_and_hospitality_q2_1_july_to_30__56a888fd (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED *,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_april_to_june_2020 (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_april_to_june_2021 (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_april_to_june_2022 (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_january_to_march_2020 (
"register_of_special_adviser_gifts_and_hospitality_received" 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
);CREATE TABLE special_advisers_gifts_and_hospitality_january_to_march_2021 (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_january_to_march_2022 (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_january_to_march_2023 (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED *,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_july_to_september_2020 (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_july_to_september_2021 (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_july_to_september_2022 (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_october_to_december_2020 (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_october_to_december_2021 (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_october_to_december_2022 (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED,
"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
);CREATE TABLE special_advisers_gifts_and_hospitality_q1_1_april_to_3_cd487ecb (
"n__register_of_special_adviser_gifts_and_hospitality_received" VARCHAR -- REGISTER OF SPECIAL ADVISER GIFTS AND HOSPITALITY RECEIVED *,
"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
);Anyone who has the link will be able to view this.