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.96 kB
43 rows
7 columns

CREATE TABLE cycle_counter_locations (
  "city_connect_sites" VARCHAR  -- City Connect : Sites,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

2010

@ukgov.leeds_annual_cycle_growth1.n_2010

80.45 kB
23,612 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

138.21 kB
48,332 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

335.68 kB
130,890 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

465.47 kB
167,084 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

469.18 kB
170,910 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

548.68 kB
197,726 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

975.7 kB
332,350 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.33 MB
453,448 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.35 MB
456,754 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.64 MB
555,545 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

472.12 kB
272,230 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

54.47 kB
56,182 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
);