Baselight
Sign In

Department For Transport Senior Officials Business Expenses

Department for Transport

@ukgov.dft_senior_officials_business_expenses

Loading...
Loading...

About this Dataset

Department For Transport Senior Officials Business Expenses

In line with Cabinet Office guidance, the Department publishes the business expenses of and hospitality received by its most senior officials (the Permanent Secretary, Directors General and non-executive members of the Departmental Board). This is updated every quarter. Information on GOV.UK about Department for Transport senior officials business expenses.
Publisher name: Department for Transport
Last updated: 2025-02-05T04:02:35Z

Tables

January To March 2023

@ukgov.dft_senior_officials_business_expenses.january_to_march_2023
  • 18.42 KB
  • 237 rows
  • 12 columns
Loading... 

CREATE TABLE january_to_march_2023 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "n__total_cost_including_all_visas_accommodation_travel_2726ae78" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR,
  "unnamed_11" VARCHAR
);

October To December 2018

@ukgov.dft_senior_officials_business_expenses.october_to_december_2018
  • 18.27 KB
  • 125 rows
  • 12 columns
Loading... 

CREATE TABLE october_to_december_2018 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" TIMESTAMP,
  "duration_of_visit_days" BIGINT,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accomodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "cost_of_travel" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" DOUBLE,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

Department For Transport Senior Officials Business Expenses

@ukgov.dft_senior_officials_business_expenses.department_for_transport_senior_officials_business_expenses
  • 19.98 KB
  • 190 rows
  • 17 columns
Loading... 

CREATE TABLE department_for_transport_senior_officials_business_expenses (
  "name" VARCHAR,
  "position_held" VARCHAR,
  "date_of_departure" TIMESTAMP,
  "destination" VARCHAR,
  "purpose" VARCHAR,
  "travel_air" VARCHAR,
  "travel_rail_underground_bus_bike" VARCHAR,
  "n__travel_taxi_car" VARCHAR,
  "n__personal_incidental_overseas" VARCHAR,
  "n__day_subsistence" VARCHAR,
  "n__meals" VARCHAR,
  "n__miscellaneous" VARCHAR,
  "n__parking" VARCHAR,
  "n__hotel_total_cost" VARCHAR,
  "hotel_number_of_nights" DOUBLE,
  "other" VARCHAR,
  "notes" VARCHAR
);

April To June 2018

@ukgov.dft_senior_officials_business_expenses.april_to_june_2018
  • 15.12 KB
  • 133 rows
  • 12 columns
Loading... 

CREATE TABLE april_to_june_2018 (
  "name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" DOUBLE,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accomodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "cost_of_travel" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

January To March 2019

@ukgov.dft_senior_officials_business_expenses.january_to_march_2019
  • 16.26 KB
  • 94 rows
  • 12 columns
Loading... 

CREATE TABLE january_to_march_2019 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accomodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "cost_of_travel" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

April To June 2022

@ukgov.dft_senior_officials_business_expenses.april_to_june_2022
  • 22.38 KB
  • 275 rows
  • 24 columns
Loading... 

CREATE TABLE april_to_june_2022 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR
);

October To December 2022

@ukgov.dft_senior_officials_business_expenses.october_to_december_2022
  • 19.13 KB
  • 185 rows
  • 11 columns
Loading... 

CREATE TABLE october_to_december_2022 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days_please_round_this_up_to_the_no_of_days" VARCHAR,
  "destination_format_must_be_city_country" VARCHAR,
  "purpose_of_trip_please_clearly_state_the_purpose_of_ea_110bd62e" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given_any_other_costs_of_the_trip" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

April To June 2024

@ukgov.dft_senior_officials_business_expenses.april_to_june_2024
  • 24.32 KB
  • 335 rows
  • 11 columns
Loading... 

CREATE TABLE april_to_june_2024 (
  "senior_official_s_name" VARCHAR,
  "start_date_of_expense" VARCHAR,
  "end_date_of_expense" VARCHAR,
  "purpose_of_expense" VARCHAR,
  "destination" VARCHAR,
  "mode_s_of_transport" VARCHAR,
  "class_of_transport" VARCHAR,
  "sub_total_of_all_transport_used" VARCHAR,
  "sub_total_costs_of_all_accomodation_and_meals" VARCHAR,
  "sub_total_cost_of_all_other_expenses_including_hospita_da45d94f" VARCHAR,
  "total_cost_of_expenses_claimed" VARCHAR
);

October To December 2023

@ukgov.dft_senior_officials_business_expenses.october_to_december_2023
  • 20.83 KB
  • 353 rows
  • 12 columns
Loading... 

CREATE TABLE october_to_december_2023 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR,
  "unnamed_11" VARCHAR
);

April To June 2023

@ukgov.dft_senior_officials_business_expenses.april_to_june_2023
  • 20.04 KB
  • 337 rows
  • 11 columns
Loading... 

CREATE TABLE april_to_june_2023 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "n__accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

October To December 2020

@ukgov.dft_senior_officials_business_expenses.october_to_december_2020
  • 11.63 KB
  • 53 rows
  • 12 columns
Loading... 

CREATE TABLE october_to_december_2020 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accomodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "cost_of_travel" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

April To June 2019

@ukgov.dft_senior_officials_business_expenses.april_to_june_2019
  • 15.71 KB
  • 99 rows
  • 12 columns
Loading... 

CREATE TABLE april_to_june_2019 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "cost_of_travel" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

July To September 2019

@ukgov.dft_senior_officials_business_expenses.july_to_september_2019
  • 161.55 KB
  • 129 rows
  • 279 columns
Loading... 

CREATE TABLE july_to_september_2019 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" TIMESTAMP,
  "duration_of_visit_days" DOUBLE,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accomodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "cost_of_travel" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" VARCHAR,
  "unnamed_96" VARCHAR,
  "unnamed_97" VARCHAR,
  "unnamed_98" VARCHAR,
  "unnamed_99" VARCHAR
);

July To September 2021

@ukgov.dft_senior_officials_business_expenses.july_to_september_2021
  • 12.86 KB
  • 96 rows
  • 11 columns
Loading... 

CREATE TABLE july_to_september_2021 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "n__total_cost_including_all_visas_accommodation_travel_2726ae78" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

July To September 2023

@ukgov.dft_senior_officials_business_expenses.july_to_september_2023
  • 203.85 KB
  • 257 rows
  • 333 columns
Loading... 

CREATE TABLE july_to_september_2023 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "n__accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" VARCHAR,
  "unnamed_96" VARCHAR,
  "unnamed_97" VARCHAR,
  "unnamed_98" VARCHAR,
  "unnamed_99" VARCHAR
);

April To June 2021

@ukgov.dft_senior_officials_business_expenses.april_to_june_2021
  • 10.97 KB
  • 68 rows
  • 11 columns
Loading... 

CREATE TABLE april_to_june_2021 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

October To December 2021

@ukgov.dft_senior_officials_business_expenses.october_to_december_2021
  • 19.94 KB
  • 145 rows
  • 22 columns
Loading... 

CREATE TABLE october_to_december_2021 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

July To September 2024

@ukgov.dft_senior_officials_business_expenses.july_to_september_2024
  • 24.51 KB
  • 353 rows
  • 12 columns
Loading... 

CREATE TABLE july_to_september_2024 (
  "senior_official_s_name" VARCHAR,
  "start_date_of_expense" VARCHAR,
  "end_date_of_expense" VARCHAR,
  "purpose_of_expense" VARCHAR,
  "destination" VARCHAR,
  "mode_s_of_transport" VARCHAR,
  "class_of_transport" VARCHAR,
  "sub_total_of_all_transport_used" VARCHAR,
  "sub_total_costs_of_all_accommodation_and_meals" VARCHAR,
  "sub_total_cost_of_all_other_expenses_including_hospita_da45d94f" VARCHAR,
  "total_cost_of_expenses_claimed" VARCHAR,
  "unnamed_11" VARCHAR
);

July To September 2022

@ukgov.dft_senior_officials_business_expenses.july_to_september_2022
  • 15.55 KB
  • 181 rows
  • 11 columns
Loading... 

CREATE TABLE july_to_september_2022 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

July To September 2020

@ukgov.dft_senior_officials_business_expenses.july_to_september_2020
  • 5.69 KB
  • 47 rows
  • 5 columns
Loading... 

CREATE TABLE 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
);

January To March 2022

@ukgov.dft_senior_officials_business_expenses.january_to_march_2022
  • 19.75 KB
  • 283 rows
  • 22 columns
Loading... 

CREATE TABLE january_to_march_2022 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

January To March 2021

@ukgov.dft_senior_officials_business_expenses.january_to_march_2021
  • 11.03 KB
  • 57 rows
  • 13 columns
Loading... 

CREATE TABLE january_to_march_2021 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" VARCHAR,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
  "total_cost_of_use_of_official_secure_car" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR
);

January To March 2024

@ukgov.dft_senior_officials_business_expenses.january_to_march_2024
  • 26.06 KB
  • 385 rows
  • 13 columns
Loading... 

CREATE TABLE january_to_march_2024 (
  "senior_official_s_name" VARCHAR,
  "start_date_of_expense" VARCHAR,
  "end_date_of_expense" VARCHAR,
  "purpose_of_expense" VARCHAR,
  "destination" VARCHAR,
  "mode_s_of_transport" VARCHAR,
  "class_of_transport" VARCHAR,
  "sub_total_of_all_transport_used" VARCHAR,
  "sub_total_costs_of_all_accommodation_and_meals" VARCHAR,
  "sub_total_cost_of_all_other_expenses_including_hospita_da45d94f" VARCHAR,
  "total_cost_of_expenses_claimed" VARCHAR,
  "unnamed_11" VARCHAR,
  "notes" VARCHAR
);

July To September 2018

@ukgov.dft_senior_officials_business_expenses.july_to_september_2018
  • 6.21 KB
  • 46 rows
  • 5 columns
Loading... 

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

Share link

Anyone who has the link will be able to view this.