About this Dataset

FCO Senior Staff Travel Overseas

Details of travel expenses for the Foreign and Commonwealth Office's senior London-based staff.
Publisher name: Foreign and Commonwealth Office
Last updated: 2022-07-01T04:04:06Z

Tables

FCO Senior Staff Travel Expenses April - June 2019

@ukgov.travel_undertaken_by_fco_senior_staff.fco_senior_staff_travel_expenses_april_june_2019

6.19 kB
47 rows
5 columns

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

FCO Senior Staff Travel Expenses January - March 2018

@ukgov.travel_undertaken_by_fco_senior_staff.fco_senior_staff_travel_expenses_january_march_2018

18.7 kB
147 rows
11 columns

CREATE TABLE fco_senior_staff_travel_expenses_january_march_2018 (
  "name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit" VARCHAR,
  "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
);

FCO Senior Staff Travel Expenses January - March 2019

@ukgov.travel_undertaken_by_fco_senior_staff.fco_senior_staff_travel_expenses_january_march_2019

17.53 kB
99 rows
11 columns

CREATE TABLE fco_senior_staff_travel_expenses_january_march_2019 (
  "name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_in_days" VARCHAR  -- Duration Of Visit (in 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
);

FCO Senior Staff Travel Overseas

@ukgov.travel_undertaken_by_fco_senior_staff.fco_senior_staff_travel_overseas

13.45 kB
47 rows
13 columns

CREATE TABLE fco_senior_staff_travel_overseas (
  "department" VARCHAR,
  "name" VARCHAR,
  "role" VARCHAR,
  "date" VARCHAR,
  "destination" VARCHAR,
  "purpose" VARCHAR,
  "travel_air" VARCHAR,
  "travel_rail" VARCHAR,
  "taxi_car" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR  -- Other (including Hospitality Given),
  "hospitality_received" VARCHAR,
  "total_cost" DOUBLE  -- Total Cost (£)
);