BEIS: Senior Officials Business Expenses, Hospitality And Meetings
Department for Business, Energy and Industrial Strategy
@ukgov.beis_senior_officials_business_expenses_hospitality_an_64179ac4
Department for Business, Energy and Industrial Strategy
@ukgov.beis_senior_officials_business_expenses_hospitality_an_64179ac4
The Department for Business, Energy and Industrial Strategy (BEIS) publishes details of senior officials’ business expenses and hospitality and the permanent secretary’s meetings on a quarterly basis. The data includes permanent secretary's meetings with external organisations. The external meetings data also covers the Government Chief Scientific Adviser as this post is graded at permanent secretary level. Prior to the establishment of the Business, Energy and Industrial Strategy Department in July 2016, policy activities were delivered by Business, Innovation and Skills and the Department of Energy and Climate Change.
Publisher name: Department for Business, Energy and Industrial Strategy
Last updated: 2023-10-21T04:15:37Z
CREATE TABLE beis_permanent_secretary_s_meetings_january_to_march_2019 (
"permanent_secretary" VARCHAR,
"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,
"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,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25
);CREATE TABLE beis_permanent_secretary_s_meetings_july_to_september_2019 (
"permanent_secretary" VARCHAR,
"date" TIMESTAMP,
"person_or_organisation_that_meeting_was_with" VARCHAR,
"purpose_of_meeting" VARCHAR
);CREATE TABLE beis_permanent_secretary_s_meetings_october_to_december_2018 (
"permanent_secretary" VARCHAR,
"date" TIMESTAMP,
"person_or_organisation_that_meeting_was_with" VARCHAR,
"purpose_of_meeting" VARCHAR
);CREATE TABLE beis_senior_officials_business_expenses_hospitality_an_64179ac4 (
"permanent_secretary" VARCHAR,
"date" VARCHAR,
"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,
"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,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25
);CREATE TABLE beis_senior_officials_expenses_january_to_march_2019 (
"senior_official_scs2_and_above" VARCHAR -- Senior Official (SCS2 And Above),
"start_date_of_trip" VARCHAR,
"duration_of_visit" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_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,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);CREATE TABLE beis_senior_officials_expenses_july_to_september_2019 (
"senior_official_scs2_and_above" VARCHAR -- Senior Official (SCS2 And Above),
"start_date_of_trip" VARCHAR,
"duration_of_visit" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_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,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);CREATE TABLE beis_senior_officials_expenses_october_to_december_2018 (
"senior_official_scs2_and_above" VARCHAR -- Senior Official (SCS2 And Above),
"start_date_of_trip" VARCHAR,
"duration_of_visit" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_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,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12
);CREATE TABLE beis_senior_officials_hospitality_january_to_march_2019 (
"senior_official_scs2_and_above" VARCHAR -- Senior Official (SCS2 And Above),
"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,
"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 beis_senior_officials_hospitality_july_to_september_2019 (
"senior_official_scs2_and_above" VARCHAR -- Senior Official (SCS2 And Above),
"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 beis_senior_officials_hospitality_october_to_december_2018 (
"senior_official_scs2_and_above" VARCHAR -- Senior Official (SCS2 And Above),
"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
);Anyone who has the link will be able to view this.