FCO Senior Staff Travel Overseas
Foreign and Commonwealth Office
@ukgov.travel_undertaken_by_fco_senior_staff
Foreign and Commonwealth Office
@ukgov.travel_undertaken_by_fco_senior_staff
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,
"hospitality_received" VARCHAR,
"total_cost" DOUBLE
);
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
);
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,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE fco_senior_staff_travel_expenses_january_march_2019 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_in_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_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
);
Anyone who has the link will be able to view this.