About this Dataset

Travel Data - Transparency Agenda And FOI Request

The Government Procurement Service (GPS) is in receipt of a request under the Freedom of Information Act to release the following data: Flight bookings made by GPS customers through the various frameworks offered by the Government Procurement Service in 2011: The date of flights The number and class of seats The departure and destination airport The cost of booking The airline The agency, department or sub department
Publisher name: Department for Environment, Food and Rural Affairs
Last updated: 2024-09-15T15:29:33Z

Tables

Travel Data - Transparency Agenda And FOI Request

@ukgov.travel_data_transparency_agenda_and_foi_request.travel_data_transparency_agenda_and_foi_request

52.35 KB
20 rows
90 columns


CREATE TABLE travel_data_transparency_agenda_and_foi_request (
  "framework" VARCHAR,
  "supplier" VARCHAR,
  "customer" VARCHAR,
  "parent_department" VARCHAR,
  "customer_invoice_number" VARCHAR,
  "date_booked" VARCHAR,
  "booking_method" VARCHAR,
  "ticket_price_ex_tax" DOUBLE,
  "number_of_travellers" DOUBLE,
  "total_cost_ex_tax" DOUBLE,
  "ticket_type" VARCHAR,
  "ticket_single_or_return" VARCHAR,
  "ticket_class" VARCHAR,
  "travel_date" VARCHAR,
  "miles_travelled" DOUBLE,
  "journey_start_point" VARCHAR,
  "journey_finish_point" VARCHAR,
  "destination_country" VARCHAR,
  "air_carrier" VARCHAR,
  "comment_taken_direct_from_iexpenses" 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
);