Ministers' Gifts And Hospitality From January 2020 To September 2023
OpenDataNI
@ukgov.ministers_gifts_and_hospitality_for_the_period_january_93ff6f85
OpenDataNI
@ukgov.ministers_gifts_and_hospitality_for_the_period_january_93ff6f85
CREATE TABLE ministers_gifts_and_hospitality_april_to_june_2020 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_april_to_june_2021 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_april_to_june_2022 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_january_to_march_2020 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_january_to_march_2021 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_january_to_march_2022 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_january_to_march_2023 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_july_to_september_2020 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_july_to_september_2021 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_july_to_september_2022 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_october_to_december_2020 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_october_to_december_2021 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_october_to_december_2022 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE ministers_gifts_and_hospitality_q2_1_july_to_30_september_2023 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
CREATE TABLE register_of_ministers_gifts_and_hospitality_q1_1_april_afc76114 (
"register_of_ministers_gifts_and_hospitality_received" 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
);
Anyone who has the link will be able to view this.