DWP Flight Expenses 2011

Department for Work and Pensions

@ukgov.air_travel_2011_data

Table List

1 table(11.6 KB)

DWP Flight Expenses 2011

@ukgov.air_travel_2011_data.dwp_flight_expenses_2011

DWP flight expenses 2011

11.6 KB
485 rows
7 columns

customer Customer	number_of_travellers Number Of Travellers	spend_less_tax Spend Less Tax	ticket_class_description Ticket Class Description	ticket_departure_date Ticket Departure Date	bileteral_city_pairs Bileteral City Pairs	supplier_name Supplier Name
Department For Work & Pensions	1	Ł148.00	Economy	Wed Jun 08 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	BELFAST/LONDON	BMI
Department For Work & Pensions	1	Ł166.28	Economy	Wed May 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	LEEDS BRADFORD/SOUTHAMPTON	FLYBE BRITISH EUROPEAN
Department For Work & Pensions	1	Ł165.53	Economy	Tue May 24 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	BRISTOL/NEWCASTLE	EASYJET
Department For Work & Pensions	1	Ł125.97	Economy	Mon Jun 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	BELFAST/NEWCASTLE	FLYBE BRITISH EUROPEAN
Department For Work & Pensions	1	Ł115.97	Economy	Mon Jun 13 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	BELFAST/NEWCASTLE	FLYBE BRITISH EUROPEAN
Department For Work & Pensions	1	Ł196.00	Economy	Mon May 23 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	GLASGOW/MANCHESTER	FLYBE BRITISH EUROPEAN
Department For Work & Pensions	1	Ł207.78	Economy	Tue May 31 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	GLASGOW/MANCHESTER	FLYBE BRITISH EUROPEAN
Department For Work & Pensions	1	Ł73.00	Business Class	Wed Jun 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	GLASGOW/LONDON	BRITISH AIRWAYS
Department For Work & Pensions	1	Ł158.26	Economy	Mon May 23 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	CARDIFF/GLASGOW	FLYBE BRITISH EUROPEAN
Department For Work & Pensions	1	Ł110.98	Economy	Wed May 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	LONDON/NEWQUAY	FLYBE BRITISH EUROPEAN


CREATE TABLE dwp_flight_expenses_2011 (
  "customer" VARCHAR,
  "number_of_travellers" DOUBLE,
  "spend_less_tax" VARCHAR,
  "ticket_class_description" VARCHAR,
  "ticket_departure_date" TIMESTAMP,
  "bileteral_city_pairs" VARCHAR,
  "supplier_name" VARCHAR
);

Share link

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