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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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
);

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
);

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
);

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
);

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,
  "n__bae_systems" VARCHAR,
  "n__babcock" VARCHAR,
  "n__leonardo" VARCHAR,
  "n__gkn" VARCHAR,
  "n__inmarsat" VARCHAR,
  "n__lockheed_martin" VARCHAR,
  "n__mbda" VARCHAR,
  "n__qinetiq" VARCHAR,
  "n__saab_uk" VARCHAR,
  "n__thales" VARCHAR,
  "n__reaction_engines" VARCHAR,
  "n__jj_churchill_speak_at_industry_round_table" VARCHAR
);

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,
  "number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" DOUBLE,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);

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,
  "number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);

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,
  "number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);

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,
  "number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" DOUBLE,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);