Ministerial Gifts, Hospitality, Travel And Meetings With External Organisations

CREATE TABLE beis_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),
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

CREATE TABLE beis_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),
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

CREATE TABLE beis_ministerial_gifts_october_to_december_2018 (
  "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 beis_ministerial_hospitality_january_to_march_2019 (
  "minister" VARCHAR,
  "date" TIMESTAMP,
  "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 beis_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 beis_ministerial_hospitality_october_to_december_2018 (
  "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 beis_ministerial_meetings_january_to_march_2019 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

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

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

CREATE TABLE beis_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_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 beis_ministerial_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_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 beis_ministerial_travel_october_to_december_2018 (
  "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 ministerial_gifts_hospitality_travel_and_meetings_with_b654c6d1 (
  "minister" VARCHAR,
  "start_date_of_trip" TIMESTAMP,
  "end_date_of_trip" TIMESTAMP,
  "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" DOUBLE  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (Ł)
);