London Assembly Cycle Survey Responses
Greater London Authority
@ukgov.london_assembly_cycle_survey_responses
Greater London Authority
@ukgov.london_assembly_cycle_survey_responses
CREATE TABLE assembly_bike_survey_data (
"respondentid" BIGINT,
"q1_location" VARCHAR,
"q2_age" VARCHAR,
"q3_gender" VARCHAR,
"q4_bikeowner" VARCHAR,
"q5_startedcycling" VARCHAR,
"q6_whenstarted" VARCHAR,
"q8_superhighwayused" VARCHAR,
"q9_superhighwayfrequency" VARCHAR,
"q10_width" VARCHAR,
"q10_surface" VARCHAR,
"q10_signs" VARCHAR,
"q10_parking" VARCHAR,
"q11_superhighwaycomments" VARCHAR,
"q12_superhighwayrespect" VARCHAR,
"q13_superhighwaysafety" VARCHAR,
"q14_superhighwaysuggestions" VARCHAR,
"q15_superhighwayreason" VARCHAR,
"q16_hireregistration" VARCHAR,
"q17_hireregistration" VARCHAR,
"q17_findingstation" VARCHAR,
"q17_bikeavailability" VARCHAR,
"q17_unlocking" VARCHAR,
"q17_bike" VARCHAR,
"q17_returning" VARCHAR,
"q17_payment" VARCHAR,
"q17_value" VARCHAR,
"q18_hirecomments" VARCHAR,
"q19_frequency" VARCHAR,
"q20_reason" VARCHAR,
"q20_reasonother" VARCHAR,
"q21_duration" VARCHAR,
"q22_supportcentre" VARCHAR,
"q23_problem" VARCHAR,
"q24_supportexperience" VARCHAR,
"q25_supportcomments" VARCHAR,
"q26_improvements" VARCHAR,
"q27_reason" VARCHAR
);
Anyone who has the link will be able to view this.