DFID Senior Executives Business Expenses, Gifts, Travel And Meetings
Department for International Development
@ukgov.dfid_senior_executives_business_expenses_gifts_travel__fa3cc546
Department for International Development
@ukgov.dfid_senior_executives_business_expenses_gifts_travel__fa3cc546
Information about DFID's senior executives business expenses, gifts received, travel and meetings with external organisations. The information and data is published quarterly.
Publisher name: Department for International Development
Last updated: 2022-07-01T04:02:38Z
CREATE TABLE dfid_senior_executives_business_expenses_gifts_travel__257f7ad1 (
"matthew_rycroft_2018_07_17_care" VARCHAR -- Matthew Rycroft ,2018-07-17,CARE,
"n__christian_aid" VARCHAR -- Christian Aid,
"n__oxfam" VARCHAR -- Oxfam,
"n__actionaid" VARCHAR -- ActionAid,
"n__save_the_children_to_discuss_dfid_cso_relationships" VARCHAR -- Save The Children,To Discuss DFID/CSO Relationships
);CREATE TABLE dfid_senior_executives_business_expenses_gifts_travel__9e732e70 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" TIMESTAMP,
"duration_of_visit_days" BIGINT -- Duration Of Visit (Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"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" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (£),
"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 -- 2018-10-13,
"n_4" DOUBLE -- 4,
"ghana" VARCHAR,
"investment_summit" VARCHAR,
"plane" VARCHAR,
"economy" VARCHAR,
"n__483_75" VARCHAR -- £483.75,
"nil_return" VARCHAR,
"n__1_270_15" VARCHAR -- £1,270.15,
"nil_return_1" VARCHAR
);CREATE TABLE dfid_senior_executives_business_expenses_gifts_travel__fa3cc546 (
"dfid_mark_lowcock_permanent_secretary" VARCHAR -- DFID – Mark Lowcock, Permanent Secretary,
"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,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" DOUBLE -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17
);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 -- Accompanied By Spouse, Family Member Or Friend
);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 -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE dfid_senior_executives_business_hospitality_july_to_se_a5f4a7fd (
"dfid_senior_executives" 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,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15
);CREATE TABLE dfid_senior_executives_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 dfid_senior_executives_business_meetings_july_to_september_2019 (
"dfid_senior_executives" 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,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17
);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 -- Duration Of Visit (Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"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" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (Ł),
"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: 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
);CREATE TABLE dfid_senior_executives_hospitality_january_to_march_2020 (
"department_for_international_development_senior_offici_6a8675f6" VARCHAR -- Department For International Development: Senior Officials’ Business Expenses And Hospitality, 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_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 -- Accompanied By Spouse, Family Member Or Friend
);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 -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE dfid_senior_executives_meetings_april_to_june_2020 (
"name_permanent_secretary_only" VARCHAR -- Name (Permanent Secretary Only),
"date" TIMESTAMP,
"n__person_or_organisation_that_meeting_was_with" VARCHAR -- (Person Or )organisation That Meeting Was With,
"purpose_of_meeting" VARCHAR
);CREATE TABLE dfid_senior_executives_meetings_january_to_march_2020 (
"department_for_international_development_senior_offici_6a8675f6" VARCHAR -- Department For International Development: Senior Officials’ Business Expenses And Hospitality, 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_senior_executives_meetings_july_to_september_2020 (
"name_permanent_secretary_only" VARCHAR -- Name (Permanent Secretary Only),
"date" TIMESTAMP,
"person_or_organisation_that_meeting_was_with" VARCHAR,
"purpose_of_meeting" VARCHAR,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6
);CREATE TABLE dfid_senior_executives_meetings_october_to_december_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 dfid_senior_executives_travel_april_to_june_2020 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR -- Duration Of Visit (Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"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" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (£),
"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 -- Department For International Development: Senior Officials’ Business Expenses And Hospitality, 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,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11
);CREATE TABLE dfid_senior_executives_travel_july_to_september_2020 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR -- Duration Of Visit (Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"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" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (£),
"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 -- Duration Of Visit (Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_meals" VARCHAR -- Accomodation/Meals (£),
"other_including_hospitality_given" VARCHAR -- Other (including Hospitality Given),
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (£),
"total_cost_of_use_of_official_secure_car" VARCHAR
);Anyone who has the link will be able to view this.