MOD: Special Advisers' Gifts, Hospitality And Meetings, January To December 2019
Ministry of Defence
@ukgov.mod_special_advisers_gifts_hospitality_and_meetings_ja_bd2ba24b
Ministry of Defence
@ukgov.mod_special_advisers_gifts_hospitality_and_meetings_ja_bd2ba24b
CREATE TABLE mod_s_special_advisers_gifts_april_to_june_2019 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"gift" VARCHAR,
"given_or_received" VARCHAR,
"who_gift_was_given_to_or_received_from" VARCHAR,
"value" VARCHAR,
"outcome_received_gifts_only" VARCHAR
);
CREATE TABLE mod_s_special_advisers_gifts_january_to_march_2019 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"gift" VARCHAR,
"given_or_received" VARCHAR,
"who_gift_was_given_to_or_received_from" VARCHAR,
"value" VARCHAR,
"outcome_received_gifts_only" VARCHAR
);
CREATE TABLE mod_s_special_advisers_gifts_july_to_september_2019 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"gift" VARCHAR,
"given_or_received" VARCHAR,
"who_gift_was_given_to_or_received_from" VARCHAR,
"value" VARCHAR,
"outcome_received_gifts_only" VARCHAR
);
CREATE TABLE mod_s_special_advisers_gifts_october_to_december_2019 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"gift" VARCHAR,
"given_or_received" VARCHAR,
"who_gift_was_given_to_or_received_from" VARCHAR,
"value" VARCHAR,
"outcome_received_gifts_only" VARCHAR
);
CREATE TABLE mod_s_special_advisers_hospitality_april_to_june_2019 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE mod_s_special_advisers_hospitality_january_to_march_2019 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE mod_s_special_advisers_hospitality_july_to_september_2019 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE mod_s_special_advisers_hospitality_october_to_december_2019 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);
CREATE TABLE mod_s_special_advisers_meetings_april_to_june_2019 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"name_of_organisation_or_individual" VARCHAR,
"purpose_of_meeting" VARCHAR
);
CREATE TABLE mod_s_special_advisers_meetings_january_to_march_2019 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"name_of_organisation_or_individual" VARCHAR,
"purpose_of_meeting" VARCHAR
);
CREATE TABLE mod_s_special_advisers_meetings_july_to_september_2019 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"name_of_organisation_or_individual" VARCHAR,
"purpose_of_meeting" VARCHAR
);
CREATE TABLE mod_s_special_advisers_meetings_october_to_december_2019 (
"special_adviser" VARCHAR,
"date" VARCHAR,
"name_of_organisation_or_individual" VARCHAR,
"purpose_of_meeting" VARCHAR
);
Anyone who has the link will be able to view this.