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  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

CREATE TABLE dfid_minister_meetings_october_to_december_2019 (
  "elizabeth_sugg_2019_10_30_preventable_deaths_roundtable_unfpa" VARCHAR  -- Elizabeth Sugg,2019-10-30,Preventable Deaths Roundtable: UNFPA,
  "n__uk_srhr_network" VARCHAR  -- UK SRHR Network,
  "n__sarian_karim" VARCHAR  -- Sarian Karim,
  "n__frcm_royal_college_of_midwives" VARCHAR  -- FRCM Royal College Of Midwives,
  "n__white_ribbon_alliance" VARCHAR  -- White Ribbon Alliance,
  "n__london_school_of_hygiene_and_tropical_medicine" VARCHAR  -- London School Of Hygiene And Tropical Medicine,
  "n__international_planned_parenthood_federation" VARCHAR  -- International Planned Parenthood Federation,
  "n__save_the_children" VARCHAR  -- Save The Children,
  "n__clinton_health_access_initiative" VARCHAR  -- Clinton Health Access Initiative,
  "n__marie_stopes_international" VARCHAR  -- Marie Stopes International,
  "n__restless_development" VARCHAR  -- Restless Development,
  "n__youth_stop_aids_campaigner" VARCHAR  -- Youth Stop AIDS Campaigner,
  "n__youth_for_change" VARCHAR  -- Youth For Change,
  "n__life_for_african_mothers_roundtable_meeting_to_disc_cf82b871" VARCHAR  -- Life For African Mothers,"Roundtable Meeting To Discuss How Governments And NGOs Can Work Together To End Preventable Deaths Of Mothers, Newborns And Children By 2030",,,,,
);

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  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only),
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

CREATE TABLE dfid_ministers_gifts_january_to_march_2020 (
  "ministers_meetings_travel_gifts_etc_january_to_march_2020" VARCHAR  -- Ministers Meetings, Travel, Gifts, Etc (January To March 2020),
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

CREATE TABLE dfid_ministers_gifts_july_to_september_2019 (
  "gifts_july_to_september_2019" VARCHAR  -- Gifts - July To September 2019,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

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  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Value (Ł),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

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  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

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  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE dfid_ministers_hospitality_january_to_march_2020 (
  "ministers_meetings_travel_gifts_etc_january_to_march_2020" VARCHAR  -- Ministers Meetings, Travel, Gifts, Etc (January To March 2020),
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

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  -- Accompanied By Spouse, Family Member(s) Or Friend?,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

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  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

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  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

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  -- Accompanied By Spouse, Family Member(s) Or Friend?,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

CREATE TABLE dfid_ministers_meetings_april_to_june_2019 (
  "action_aid" VARCHAR,
  "n__bond" VARCHAR  -- Bond,
  "n__cafod" VARCHAR  -- Cafod,
  "n__care_international" VARCHAR  -- Care International,
  "n__christian_aid" VARCHAR  -- Christian Aid,
  "n__flora_fauna_international" VARCHAR  -- Flora & Fauna International,
  "n__hub_cymru" VARCHAR  -- Hub Cymru,
  "n__international_rescue_committee" VARCHAR  -- International Rescue Committee,
  "n__islamic_relief_worldwide" VARCHAR  -- Islamic Relief Worldwide,
  "n__one" VARCHAR  -- ONE,
  "n__oxfam" VARCHAR  -- Oxfam,
  "n__plan" VARCHAR  -- Plan,
  "n__save_the_children_uk" VARCHAR  -- Save The Children UK,
  "n__south_west_international_development_network" VARCHAR  -- South West International Development Network,
  "n__wwf" VARCHAR  -- WWF,
  "n__zoologial_society_of_london_discussion_on_internati_897dd02a" VARCHAR  -- Zoologial Society Of London","Discussion On International Development Policy Priorities, Including Climate And Biodiversity "
);

CREATE TABLE dfid_ministers_meetings_april_to_june_2020 (
  "liz_sugg_2020_04_03_roundtable_bond" VARCHAR  -- Liz Sugg,2020-04-03,Roundtable: Bond,
  "n__save_the_children" VARCHAR  -- Save The Children,
  "n__red_cross" VARCHAR  -- Red Cross,
  "n__plan_international_uk" VARCHAR  -- Plan International UK,
  "n__cbm_uk" VARCHAR  -- CBM UK,
  "n__oxfam_uk" VARCHAR  -- Oxfam UK,
  "n__woman_kind" VARCHAR  -- Woman Kind,
  "n__christian_aid" VARCHAR  -- Christian Aid,
  "n__rescue_uk" VARCHAR  -- Rescue UK,
  "n__sightsavers" VARCHAR  -- Sightsavers,
  "n__mercy_corps" VARCHAR  -- Mercy Corps,
  "n__islamic_relief_worldwide" VARCHAR  -- Islamic Relief Worldwide,
  "n__water_aid" VARCHAR  -- Water Aid,
  "n__child_hope" VARCHAR  -- Child Hope,
  "n__cafod" VARCHAR  -- CAFOD,
  "n__restless_development" VARCHAR  -- Restless Development,
  "n__gender_and_development_network" VARCHAR  -- Gender And Development Network,
  "n__start_network" VARCHAR  -- Start Network,
  "n__age_international" VARCHAR  -- Age International,
  "n__care_international_uk" VARCHAR  -- Care International UK,
  "n__actionaid" VARCHAR  -- ActionAid,
  "n__world_vision_uk" VARCHAR  -- World Vision UK,
  "n__action_for_global_health_to_discuss_civil_society_s_9c07fc25" VARCHAR  -- Action For Global Health,To Discuss Civil Society's Response To COVID-19,
);

CREATE TABLE dfid_ministers_meetings_january_to_march_2020 (
  "liz_sugg_18_03_2020_university_of_cambridge" VARCHAR,
  "n__campaign_for_female_education" VARCHAR  -- Campaign For Female Education,
  "n__center_for_global_development" VARCHAR  -- Center For Global Development,
  "n__university_of_oxford" VARCHAR  -- University Of Oxford,
  "n__bill_and_melinda_gates_foundation" VARCHAR  -- Bill And Melinda Gates Foundation,
  "n__save_the_children" VARCHAR  -- Save The Children,
  "n__institute_of_education" VARCHAR  -- Institute Of Education,
  "n__girls_not_brides_roundtable_discussion_on_global_ed_dc0f0904" VARCHAR  -- Girls Not Brides,Roundtable Discussion On Global Education And Girls' Education
);

CREATE TABLE dfid_ministers_meetings_july_to_september_2019 (
  "gifts_july_to_september_2019" VARCHAR  -- Gifts - July To September 2019,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

CREATE TABLE dfid_ministers_meetings_july_to_september_2021 (
  "liz_sugg_2020_07_24_roundtable_bond" VARCHAR  -- Liz Sugg,2020-07-24,Roundtable: Bond,
  "n__mercy_corps" VARCHAR  -- Mercy Corps,
  "n__stopaids" VARCHAR  -- STOPAIDS,
  "n__save_the_children" VARCHAR  -- Save The Children,
  "n__leonard_cheshire" VARCHAR  -- Leonard Cheshire,
  "n__age_international_uk" VARCHAR  -- Age International UK,
  "n__gender_and_development_network" VARCHAR  -- Gender And Development Network,
  "n__railway_children" VARCHAR  -- Railway Children,
  "n__brac_uk" VARCHAR  -- BRAC UK,
  "n__fairtrade" VARCHAR  -- Fairtrade,
  "n__care_international" VARCHAR  -- Care International,
  "n__humentum" VARCHAR  -- Humentum,
  "n__christian_aid" VARCHAR  -- Christian Aid,
  "n__oxfam" VARCHAR  -- Oxfam,
  "n__actionaid" VARCHAR  -- ActionAid,
  "n__humanity_inclusion_uk_to_discuss_civil_society_orga_38476947" VARCHAR  -- Humanity & Inclusion UK,To Discuss Civil Society Organisation Response To COVID-19
);

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  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant (£),
  "number_of_officials_who_accompanied_minister_if_non_sh_06c7d651" VARCHAR  -- Number Of Officials Who Accompanied Minister If Non-shceduled 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 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  -- 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 dfid_ministers_travel_january_to_march_2020 (
  "ministers_meetings_travel_gifts_etc_january_to_march_2020" VARCHAR  -- Ministers Meetings, Travel, Gifts, Etc (January To March 2020),
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

CREATE TABLE dfid_ministers_travel_july_to_september_2019 (
  "dfid_ministers_overseas_travel_july_to_september_2019" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);