Ministerial Gifts, Hospitality, Travel And Meetings With External Organisations In The Department For International Development
Department for International Development
@ukgov.dfid_sos_gifts_travel_hospitality_meetings_may_july_2010
Department for International Development
@ukgov.dfid_sos_gifts_travel_hospitality_meetings_may_july_2010
The following lists the ministerial gifts (both received and given), hospitality, travel and meetings with external organisations for ministers within the Department for International Development.
Publisher name: Department for International Development
Last updated: 2022-07-01T04:02:33Z
CREATE TABLE dfid_ministers_travel_july_to_september_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_october_to_december_2018 (
"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_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" DOUBLE -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc (Ł)
);CREATE TABLE dfid_ministers_travel_october_to_december_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 (£),
"unnamed_10" VARCHAR -- Unnamed: 10
);CREATE TABLE ministerial_gifts_hospitality_travel_and_meetings_with_5302998b (
"gifts_received_over_140" VARCHAR -- GIFTS RECEIVED OVER Ģ140,
"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
);Anyone who has the link will be able to view this.