DFID Senior Executives Business Expenses, Gifts, Travel And Meetings

CREATE TABLE dfid_senior_executives_business_expenses_gifts_travel__257f7ad1 (
  "matthew_rycroft_2018_07_17_care" VARCHAR,
  "n__christian_aid" VARCHAR,
  "n__oxfam" VARCHAR,
  "n__actionaid" VARCHAR,
  "n__save_the_children_to_discuss_dfid_cso_relationships" VARCHAR
);

CREATE TABLE dfid_senior_executives_business_expenses_gifts_travel__9e732e70 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" TIMESTAMP,
  "duration_of_visit_days" BIGINT,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accomodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

CREATE TABLE dfid_senior_executives_business_expenses_gifts_travel__da4655b3 (
  "rachel_turner" VARCHAR,
  "n_2018_10_13" TIMESTAMP,
  "n_4" DOUBLE,
  "ghana" VARCHAR,
  "investment_summit" VARCHAR,
  "plane" VARCHAR,
  "economy" VARCHAR,
  "n__483_75" VARCHAR,
  "nil_return" VARCHAR,
  "n__1_270_15" VARCHAR,
  "nil_return_1" VARCHAR
);

CREATE TABLE dfid_senior_executives_business_expenses_gifts_travel__fa3cc546 (
  "dfid_mark_lowcock_permanent_secretary" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" DOUBLE,
  "unnamed_17" VARCHAR
);

CREATE TABLE dfid_senior_executives_business_hospitality_april_to_june_2019 (
  "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
);

CREATE TABLE dfid_senior_executives_business_hospitality_april_to_june_2020 (
  "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
);

CREATE TABLE dfid_senior_executives_business_hospitality_july_to_se_a5f4a7fd (
  "dfid_senior_executives" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR
);

CREATE TABLE dfid_senior_executives_business_meetings_april_to_june_2019 (
  "name_permanent_secretary_only" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE dfid_senior_executives_business_meetings_july_to_september_2019 (
  "dfid_senior_executives" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR
);

CREATE TABLE dfid_senior_executives_business_travel_april_to_june_2019 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" BIGINT,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accomodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

CREATE TABLE dfid_senior_executives_business_travel_july_to_september_2019 (
  "dfid_senior_executives" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR
);

CREATE TABLE dfid_senior_executives_hospitality_january_to_march_2020 (
  "department_for_international_development_senior_offici_6a8675f6" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR
);

CREATE TABLE dfid_senior_executives_hospitality_july_to_september_2020 (
  "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
);

CREATE TABLE dfid_senior_executives_hospitality_october_to_december_2019 (
  "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
);

CREATE TABLE dfid_senior_executives_meetings_april_to_june_2020 (
  "name_permanent_secretary_only" VARCHAR,
  "date" TIMESTAMP,
  "n__person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE dfid_senior_executives_meetings_january_to_march_2020 (
  "department_for_international_development_senior_offici_6a8675f6" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR
);

CREATE TABLE dfid_senior_executives_meetings_july_to_september_2020 (
  "name_permanent_secretary_only" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

CREATE TABLE dfid_senior_executives_meetings_october_to_december_2019 (
  "name_permanent_secretary_only" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE dfid_senior_executives_travel_april_to_june_2020 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accomodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

CREATE TABLE dfid_senior_executives_travel_january_to_march_2020 (
  "department_for_international_development_senior_offici_6a8675f6" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR
);

CREATE TABLE dfid_senior_executives_travel_july_to_september_2020 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accomodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

CREATE TABLE dfid_senior_executives_travel_october_to_december_2019 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" TIMESTAMP,
  "duration_of_visit_days" BIGINT,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accomodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);