Annual Travel To Work Survey

Leeds City Council

@ukgov.annual_travel_to_work_survey

Table List

1 table(220.2 KB)

2020

@ukgov.annual_travel_to_work_survey.n_2020

220.2 KB
8999 rows
50 columns

workplace_post_code Workplace Post Code	survey_date Survey Date	q1_what_was_the_main_mode_of_transport_you_used_to_get_ab3d2d6a Q1. What Was The Main Mode Of Transport You Used To Get To Work Today (e.g. The Mode Of Transport That Covered The Longest Distance)?	q2_we_are_interested_in_how_you_are_travelling_from_ho_d492ff02 Q2. We Are Interested In How You Are Travelling From Home To Work Since The End Of Lockdown. Please Tell Us How You Are Currently Travelling At Each Stage Of Your Journey (i.e. Your Usual Mode Of Transport, The Time It Takes And Your Destination). Use As Many Stages As You Need. The First Mode Cannot Be Public Transport (i.e. Please Describe How You Travel To The Bus Stop Or Train Station).	q3_before_lockdown_what_was_your_main_mode_of_travel_on_monday Q3. Before Lockdown, What Was Your Main Mode Of Travel On Monday?	q4_before_lockdown_what_was_your_main_mode_of_travel_o_bf28efeb Q4. Before Lockdown, What Was Your Main Mode Of Travel On Tuesday?	q5_before_lockdown_what_was_your_main_mode_of_travel_o_adce2c12 Q5.Before Lockdown, What Was Your Main Mode Of Travel On Wednesday?	q6_before_lockdown_what_was_your_main_mode_of_travel_o_2446dbcf Q6.Before Lockdown, What Was Your Main Mode Of Travel On Thursday?	q7_before_lockdown_what_was_your_main_mode_of_travel_on_friday Q7.Before Lockdown, What Was Your Main Mode Of Travel On Friday?	q8_before_lockdown_what_was_your_main_mode_of_travel_o_5f08e12f Q8.Before Lockdown, What Was Your Main Mode Of Travel On Saturday?	q9_before_lockdown_what_was_your_main_mode_of_travel_on_sunday Q9.Before Lockdown, What Was Your Main Mode Of Travel On Sunday?	q10_what_is_your_main_mode_of_travel_on_monday_now Q10.What Is Your Main Mode Of Travel On Monday Now?	q11_what_is_your_main_mode_of_travel_on_tuesday_now Q11.What Is Your Main Mode Of Travel On Tuesday Now?	q12what_is_your_main_mode_of_travel_on_wednesday_now Q12What Is Your Main Mode Of Travel On Wednesday Now?	q13_what_is_your_main_mode_of_travel_on_thursday_now Q13. What Is Your Main Mode Of Travel On Thursday Now?	q14_what_is_your_main_mode_of_travel_on_friday_now Q14. What Is Your Main Mode Of Travel On Friday Now?	q15_what_is_your_main_mode_of_travel_on_saturday_now Q15.What Is Your Main Mode Of Travel On Saturday Now?	q16_what_is_your_main_mode_of_travel_on_sunday_now Q16. What Is Your Main Mode Of Travel On Sunday Now?	q17_before_lockdown_did_you_use_your_car_for_work_purp_170d7b38 Q17.Before Lockdown Did You Use Your Car For Work Purposes During The Day?	q18_before_lockdown_where_did_you_usually_park Q18.Before Lockdown Where Did You Usually Park?	q19_do_you_use_your_car_for_work_purposes_during_the_day_now Q19. Do You Use Your Car For Work Purposes During The Day Now?	q20_where_do_you_usually_park_now Q20. Where Do You Usually Park Now?	q21_how_much_does_it_cost_you_to_park_per_day Q21. How Much Does It Cost You To Park Per Day?	q22_what_type_of_fuel_does_your_vehicle_use Q22. What Type Of Fuel Does Your Vehicle Use?
BD10 0	23/10/2020 08:49	Foot	Foot	Foot	Foot	Foot	Foot	Foot	Foot	Non-working day	Foot	Foot	Foot	Foot	Foot	Foot	Non-working day	Never		Never		Parking is free	Diesel
BD10 0	23/10/2020 08:54	Car (Single Occupant)	Car (Single Occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Non-working day	Non-working day	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Non-working day	Non-working day	Never	A car park where I work provided by my employer	Never	A car park where I work provided by my employer	Parking is free	Diesel
BD10 0	23/10/2020 09:00	Car (Single Occupant)	Car (Single Occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Non-working day	Non-working day	Non-working day	Non-working day	Car (single occupant)	Car (single occupant)	Car (single occupant)	Non-working day	Non-working day	Non-working day	Non-working day	Never	A car park where I work provided by my employer	Never	A car park where I work provided by my employer	Parking is free	Petrol
BD10 0	23/10/2020 09:06	Car Share (Driver)	Car Share (Driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Non-working day	Non-working day	Car Share (driver)	Car Share (driver)	Car Share (driver)	Working from home	Working from home	Non-working day	Non-working day	4 or more days per week	A car park where I work provided by my employer	1 - 3 days per week	A car park where I work provided by my employer	Parking is free	Petrol
BD10 0	23/10/2020 09:06	Car (Single Occupant)	Car (Single Occupant)	Non-working day	Car (single occupant)	Non-working day	Car (single occupant)	Car (single occupant)	Non-working day	Non-working day	Non-working day	Car (single occupant)	Non-working day	Car (single occupant)	Car (single occupant)	Non-working day	Non-working day	Once or twice a year	A car park where I work provided by my employer	Never	A car park where I work provided by my employer	Parking is free	Diesel
BD10 0	23/10/2020 09:09	Car (Single Occupant)	Car (Single Occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Non-working day	Non-working day	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Non-working day	Non-working day	Once or twice a year	A car park where I work provided by my employer	Once or twice a year	A car park where I work provided by my employer	Parking is free	Petrol
BD10 0	23/10/2020 09:11	Car Share (Driver)	Car Share (Driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Other - please specify	Other - please specify	Car Share (driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Other - please specify	Other - please specify	Never	A car park where I work provided by my employer	Never	A car park where I work provided by my employer	Parking is free	Diesel
BD10 0	23/10/2020 09:15	Car Share (Passenger)	Car Share (Driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Non-working day	Non-working day	Car Share (driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Car Share (driver)	Non-working day	Non-working day	4 or more days per week	A car park where I work provided by my employer	4 or more days per week	A car park where I work provided by my employer	Parking is free	Diesel
BD10 0	23/10/2020 09:30	Car (Single Occupant)	Car (Single Occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Non-working day	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Non-working day	Never	A car park where I work provided by my employer	Never	A car park where I work provided by my employer	Parking is free	Diesel
BD10 0	23/10/2020 09:31	Car (Single Occupant)	Car (Single Occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Non-working day	Non-working day	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Car (single occupant)	Non-working day	Non-working day	Never	A car park where I work provided by my employer	Never	A car park where I work provided by my employer	Parking is free	Hybrid


CREATE TABLE n_2020 (
  "workplace_post_code" VARCHAR,
  "survey_date" VARCHAR,
  "q1_what_was_the_main_mode_of_transport_you_used_to_get_ab3d2d6a" VARCHAR,
  "q2_we_are_interested_in_how_you_are_travelling_from_ho_d492ff02" VARCHAR,
  "have_your_daily_work_and_travel_patterns_changed_as_a__2a2317ce" VARCHAR,
  "q3_before_lockdown_what_was_your_main_mode_of_travel_on_monday" VARCHAR,
  "q4_before_lockdown_what_was_your_main_mode_of_travel_o_bf28efeb" VARCHAR,
  "q5_before_lockdown_what_was_your_main_mode_of_travel_o_adce2c12" VARCHAR,
  "q6_before_lockdown_what_was_your_main_mode_of_travel_o_2446dbcf" VARCHAR,
  "q7_before_lockdown_what_was_your_main_mode_of_travel_on_friday" VARCHAR,
  "q8_before_lockdown_what_was_your_main_mode_of_travel_o_5f08e12f" VARCHAR,
  "q9_before_lockdown_what_was_your_main_mode_of_travel_on_sunday" VARCHAR,
  "q10_what_is_your_main_mode_of_travel_on_monday_now" VARCHAR,
  "q11_what_is_your_main_mode_of_travel_on_tuesday_now" VARCHAR,
  "q12what_is_your_main_mode_of_travel_on_wednesday_now" VARCHAR,
  "q13_what_is_your_main_mode_of_travel_on_thursday_now" VARCHAR,
  "q14_what_is_your_main_mode_of_travel_on_friday_now" VARCHAR,
  "q15_what_is_your_main_mode_of_travel_on_saturday_now" VARCHAR,
  "q16_what_is_your_main_mode_of_travel_on_sunday_now" VARCHAR,
  "has_your_car_use_changed_please_tell_us_about_using_yo_3d81239c" VARCHAR,
  "q17_before_lockdown_did_you_use_your_car_for_work_purp_170d7b38" VARCHAR,
  "answer_to_q17_other_please_specify_before_lockdown_did_7ca88323" VARCHAR,
  "q18_before_lockdown_where_did_you_usually_park" VARCHAR,
  "before_lockdown_where_did_you_usually_park" VARCHAR,
  "q19_do_you_use_your_car_for_work_purposes_during_the_day_now" VARCHAR,
  "do_you_use_your_car_for_work_purposes_during_the_day_now" VARCHAR,
  "q20_where_do_you_usually_park_now" VARCHAR,
  "where_do_you_usually_park_now" VARCHAR,
  "q21_how_much_does_it_cost_you_to_park_per_day" VARCHAR,
  "q22_what_type_of_fuel_does_your_vehicle_use" VARCHAR,
  "n__what_type_of_fuel_does_your_vehicle_use" 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
);