About this Dataset

Leeds Annual Cycle Growth

A dataset to show the cycle counts from 41 recorders located around the West Yorkshire district. 10 of these have no data prior to 2016, 2 no data prior to 2017 and 12 no data prior to 2019. Additionally 4 new locations were monitored for the first time in 2020 and 2 locations were added in spring 2021. Please Note ----------- * Sdate - indicates the date and time the count was taken. * Cosit - site ID number which indicates the recorder location (see Counter Locations document below). * Period - length of time count was taken. * LaneNumber - Lane ID number which indicates the number of lanes. * LaneDirection - the number of directions the lane or lanes go. * Direction - the direction of the lane. * Volume - the number of bicycles counted, if the number is negative the count has been discarded. * Flag Text - Additional information e.g. roadworks, holiday, etc
Publisher name: Leeds City Council
Last updated: 2024-09-14T10:08:18Z

Tables

Cycle Counter Locations

@ukgov.leeds_annual_cycle_growth1.cycle_counter_locations

7.77 KB
43 rows
7 columns


CREATE TABLE cycle_counter_locations (
  "city_connect_sites" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

2010

@ukgov.leeds_annual_cycle_growth1.n_2010

78.56 KB
23612 rows
8 columns


CREATE TABLE n_2010 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR
);

2011

@ukgov.leeds_annual_cycle_growth1.n_2011

134.97 KB
48332 rows
8 columns


CREATE TABLE n_2011 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR
);

2012

@ukgov.leeds_annual_cycle_growth1.n_2012

327.81 KB
130890 rows
8 columns


CREATE TABLE n_2012 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR
);

2013

@ukgov.leeds_annual_cycle_growth1.n_2013

454.56 KB
167084 rows
8 columns


CREATE TABLE n_2013 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR
);

2014

@ukgov.leeds_annual_cycle_growth1.n_2014

458.18 KB
170910 rows
8 columns


CREATE TABLE n_2014 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR
);

2015

@ukgov.leeds_annual_cycle_growth1.n_2015

535.82 KB
197726 rows
9 columns


CREATE TABLE n_2015 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedescription" VARCHAR,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR
);

2016

@ukgov.leeds_annual_cycle_growth1.n_2016

952.83 KB
332350 rows
9 columns


CREATE TABLE n_2016 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedescription" VARCHAR,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR
);

2017

@ukgov.leeds_annual_cycle_growth1.n_2017

1.27 MB
453448 rows
9 columns


CREATE TABLE n_2017 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedescription" VARCHAR,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR
);

2018

@ukgov.leeds_annual_cycle_growth1.n_2018

1.29 MB
456754 rows
9 columns


CREATE TABLE n_2018 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedescription" VARCHAR,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR
);

2019

@ukgov.leeds_annual_cycle_growth1.n_2019

1.56 MB
555545 rows
9 columns


CREATE TABLE n_2019 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedescription" VARCHAR,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR
);

2020

@ukgov.leeds_annual_cycle_growth1.n_2020

461.06 KB
272230 rows
9 columns


CREATE TABLE n_2020 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedescription" VARCHAR,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR
);

2021

@ukgov.leeds_annual_cycle_growth1.n_2021

53.19 KB
56182 rows
9 columns


CREATE TABLE n_2021 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedescription" VARCHAR,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR
);