MOD: Senior Officials' Business Expenses, Hospitality And Meetings, January To December 2019

CREATE TABLE mod_permanent_secretaries_business_meetings_2_star_and_5b2c8114 (
  "senior_official_name" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member Or Friend
);

CREATE TABLE mod_permanent_secretaries_business_meetings_april_to_june_2019 (
  "name_permanent_secretary_only" VARCHAR  -- Name (Permanent Secretary Only),
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE mod_permanent_secretaries_business_meetings_october_to_5edb5c8c (
  "senior_official_name" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member Or Friend
);

CREATE TABLE mod_s_senior_officials_expenses_2_star_and_above_april_64d14643 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" DOUBLE  -- Duration Of Visit (Days),
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "expense_type_mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accomodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR  -- Other (including Hospitality Given),
  "total_cost_including_all_visas_accommodation_travel_meals_etc" DOUBLE  -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (Ł),
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

CREATE TABLE mod_s_senior_officials_expenses_2_star_and_above_janua_9fc7e326 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" TIMESTAMP,
  "duration_of_visit_days" DOUBLE  -- Duration Of Visit (Days),
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "expense_type_mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accomodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR  -- Other (including Hospitality Given),
  "n__total_cost_including_all_visas_accommodation_travel_2726ae78" DOUBLE  -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (Ł),
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

CREATE TABLE mod_s_senior_officials_expenses_2_star_and_above_july__0763ee4b (
  "senior_official_name" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member Or Friend
);

CREATE TABLE mod_s_senior_officials_hospitality_2_star_and_above_ap_e7df700e (
  "senior_official_name" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member Or Friend
);

CREATE TABLE mod_s_senior_officials_hospitality_2_star_and_above_ja_e55f172a (
  "senior_official_name" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member Or Friend
);

CREATE TABLE mod_s_senior_officials_hospitality_2_star_and_above_ju_c9e0a820 (
  "senior_official_name" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member Or Friend
);