Ministerial Gifts, Hospitality, Travel And Meetings With External Organisations In The Department For International Development

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

CREATE TABLE dfid_minister_meetings_october_to_december_2019 (
  "elizabeth_sugg_2019_10_30_preventable_deaths_roundtable_unfpa" VARCHAR,
  "n__uk_srhr_network" VARCHAR,
  "n__sarian_karim" VARCHAR,
  "n__frcm_royal_college_of_midwives" VARCHAR,
  "n__white_ribbon_alliance" VARCHAR,
  "n__london_school_of_hygiene_and_tropical_medicine" VARCHAR,
  "n__international_planned_parenthood_federation" VARCHAR,
  "n__save_the_children" VARCHAR,
  "n__clinton_health_access_initiative" VARCHAR,
  "n__marie_stopes_international" VARCHAR,
  "n__restless_development" VARCHAR,
  "n__youth_stop_aids_campaigner" VARCHAR,
  "n__youth_for_change" VARCHAR,
  "n__life_for_african_mothers_roundtable_meeting_to_disc_cf82b871" VARCHAR
);

CREATE TABLE dfid_ministers_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 dfid_ministers_gifts_april_to_june_2020 (
  "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,
  "unnamed_7" VARCHAR
);

CREATE TABLE dfid_ministers_gifts_january_to_march_2020 (
  "ministers_meetings_travel_gifts_etc_january_to_march_2020" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

CREATE TABLE dfid_ministers_gifts_july_to_september_2019 (
  "gifts_july_to_september_2019" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

CREATE TABLE dfid_ministers_gifts_july_to_september_2020 (
  "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 dfid_ministers_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 dfid_ministers_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 dfid_ministers_hospitality_april_to_june_2020 (
  "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 dfid_ministers_hospitality_january_to_march_2020 (
  "ministers_meetings_travel_gifts_etc_january_to_march_2020" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR
);

CREATE TABLE dfid_ministers_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,
  "unnamed_5" VARCHAR
);

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

CREATE TABLE dfid_ministers_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,
  "unnamed_5" VARCHAR
);

CREATE TABLE dfid_ministers_meetings_april_to_june_2019 (
  "action_aid" VARCHAR,
  "n__bond" VARCHAR,
  "n__cafod" VARCHAR,
  "n__care_international" VARCHAR,
  "n__christian_aid" VARCHAR,
  "n__flora_fauna_international" VARCHAR,
  "n__hub_cymru" VARCHAR,
  "n__international_rescue_committee" VARCHAR,
  "n__islamic_relief_worldwide" VARCHAR,
  "n__one" VARCHAR,
  "n__oxfam" VARCHAR,
  "n__plan" VARCHAR,
  "n__save_the_children_uk" VARCHAR,
  "n__south_west_international_development_network" VARCHAR,
  "n__wwf" VARCHAR,
  "n__zoologial_society_of_london_discussion_on_internati_897dd02a" VARCHAR
);

CREATE TABLE dfid_ministers_meetings_april_to_june_2020 (
  "liz_sugg_2020_04_03_roundtable_bond" VARCHAR,
  "n__save_the_children" VARCHAR,
  "n__red_cross" VARCHAR,
  "n__plan_international_uk" VARCHAR,
  "n__cbm_uk" VARCHAR,
  "n__oxfam_uk" VARCHAR,
  "n__woman_kind" VARCHAR,
  "n__christian_aid" VARCHAR,
  "n__rescue_uk" VARCHAR,
  "n__sightsavers" VARCHAR,
  "n__mercy_corps" VARCHAR,
  "n__islamic_relief_worldwide" VARCHAR,
  "n__water_aid" VARCHAR,
  "n__child_hope" VARCHAR,
  "n__cafod" VARCHAR,
  "n__restless_development" VARCHAR,
  "n__gender_and_development_network" VARCHAR,
  "n__start_network" VARCHAR,
  "n__age_international" VARCHAR,
  "n__care_international_uk" VARCHAR,
  "n__actionaid" VARCHAR,
  "n__world_vision_uk" VARCHAR,
  "n__action_for_global_health_to_discuss_civil_society_s_9c07fc25" VARCHAR
);

CREATE TABLE dfid_ministers_meetings_january_to_march_2020 (
  "liz_sugg_18_03_2020_university_of_cambridge" VARCHAR,
  "n__campaign_for_female_education" VARCHAR,
  "n__center_for_global_development" VARCHAR,
  "n__university_of_oxford" VARCHAR,
  "n__bill_and_melinda_gates_foundation" VARCHAR,
  "n__save_the_children" VARCHAR,
  "n__institute_of_education" VARCHAR,
  "n__girls_not_brides_roundtable_discussion_on_global_ed_dc0f0904" VARCHAR
);

CREATE TABLE dfid_ministers_meetings_july_to_september_2019 (
  "gifts_july_to_september_2019" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

CREATE TABLE dfid_ministers_meetings_july_to_september_2021 (
  "liz_sugg_2020_07_24_roundtable_bond" VARCHAR,
  "n__mercy_corps" VARCHAR,
  "n__stopaids" VARCHAR,
  "n__save_the_children" VARCHAR,
  "n__leonard_cheshire" VARCHAR,
  "n__age_international_uk" VARCHAR,
  "n__gender_and_development_network" VARCHAR,
  "n__railway_children" VARCHAR,
  "n__brac_uk" VARCHAR,
  "n__fairtrade" VARCHAR,
  "n__care_international" VARCHAR,
  "n__humentum" VARCHAR,
  "n__christian_aid" VARCHAR,
  "n__oxfam" VARCHAR,
  "n__actionaid" VARCHAR,
  "n__humanity_inclusion_uk_to_discuss_civil_society_orga_38476947" VARCHAR
);

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

CREATE TABLE dfid_ministers_overseas_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 dfid_ministers_travel_april_to_june_2020 (
  "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 dfid_ministers_travel_january_to_march_2020 (
  "ministers_meetings_travel_gifts_etc_january_to_march_2020" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

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