MOD: Ministerial Gifts, Hospitality, Travel And Meetings, January To December 2019

CREATE TABLE mod_s_ministerial_gifts_april_to_june_2019 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "given_or_received" VARCHAR,
  "who_gift_was_given_to_or_received_from" VARCHAR,
  "value" VARCHAR  -- Value (Ł),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

CREATE TABLE mod_s_ministerial_gifts_january_to_march_2019 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "given_or_received" VARCHAR,
  "who_gift_was_given_to_or_received_from" VARCHAR,
  "value" VARCHAR  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

CREATE TABLE mod_s_ministerial_gifts_july_to_september_2019 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "given_or_received" VARCHAR,
  "who_gift_was_given_to_or_received_from" VARCHAR,
  "value" VARCHAR  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

CREATE TABLE mod_s_ministerial_gifts_october_to_december_2019 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "given_or_received" VARCHAR,
  "who_gift_was_given_to_or_received_from" VARCHAR,
  "value" VARCHAR  -- Value (Ł),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

CREATE TABLE mod_s_ministerial_hospitality_april_to_june_2019 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE mod_s_ministerial_hospitality_january_to_march_2019 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE mod_s_ministerial_hospitality_july_to_september_2019 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE mod_s_ministerial_hospitality_october_to_december_2019 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE mod_s_ministerial_meetings_april_to_june_2019 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE mod_s_ministerial_meetings_january_to_march_2019 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE mod_s_ministerial_meetings_july_to_september_2019 (
  "anne_marie_trevelyan_29_09_2019_ads" VARCHAR,
  "n__airbus" VARCHAR  -- Airbus,
  "n__bae_systems" VARCHAR  -- BAE Systems,
  "n__babcock" VARCHAR  -- Babcock,
  "n__leonardo" VARCHAR  -- Leonardo,
  "n__gkn" VARCHAR  -- GKN,
  "n__inmarsat" VARCHAR  -- Inmarsat,
  "n__lockheed_martin" VARCHAR  -- Lockheed Martin,
  "n__mbda" VARCHAR  -- MBDA,
  "n__qinetiq" VARCHAR  -- QinetiQ,
  "n__saab_uk" VARCHAR  -- Saab UK,
  "n__thales" VARCHAR  -- Thales,
  "n__reaction_engines" VARCHAR  -- Reaction Engines,
  "n__jj_churchill_speak_at_industry_round_table" VARCHAR  -- JJ Churchill,Speak At Industry Round Table
);

CREATE TABLE mod_s_ministerial_meetings_october_to_december_2019 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE mod_s_ministerial_overseas_travel_july_to_september_2019 (
  "minister" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "end_date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "cost_of_private_jet_or_raf_plane_hire_if_relevant" VARCHAR  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (Ł),
  "number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" DOUBLE  -- Number Of Officials Who Accompanied Minister If Non-shceduled Travel Was Used,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend At Public Expense?,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (Ł)
);

CREATE TABLE mod_s_ministerial_overseas_travel_october_to_december_2019 (
  "minister" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "end_date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "cost_of_private_jet_or_raf_plane_hire_if_relevant" VARCHAR  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (£),
  "number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR  -- Number Of Officials Who Accompanied Minister If Non-scheduled Travel Was Used,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend At Public Expense?,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc. (£)
);

CREATE TABLE mod_s_ministerial_travel_april_to_june_2019 (
  "minister" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "end_date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "cost_of_private_jet_or_raf_plane_hire_if_relevant" VARCHAR  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (Ł),
  "number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR  -- Number Of Officials Who Accompanied Minister If Non-shceduled Travel Was Used,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend At Public Expense?,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (Ł)
);

CREATE TABLE mod_s_ministerial_travel_january_to_march_2019 (
  "minister" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "end_date_of_trip" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "cost_of_private_jet_or_raf_plane_hire_if_relevant" VARCHAR  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (Ł),
  "number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" DOUBLE  -- Number Of Officials Who Accompanied Minister If Non-shceduled Travel Was Used,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend At Public Expense?,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (Ł)
);