About this Dataset

Leeds Annual Traffic Growth

A dataset to show the traffic count from 29 recorders located around Leeds. Please note ----------- * Sdate - indicates the date and time the count was taken. * Cosit - Site ID number which indicates the recorder location (see Recorder 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 vehicles 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:10:41Z

Tables

2012

@ukgov.leeds_annual_traffic_growth.n_2012

2.48 MB
528,573 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_traffic_growth.n_2013

2.51 MB
534,776 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_traffic_growth.n_2014

1.11 MB
544,216 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_traffic_growth.n_2015

1.09 MB
490,630 rows
21 columns

CREATE TABLE n_2015 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedescription" VARCHAR,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR,
  "unnamed_9" DOUBLE  -- Unnamed: 9,
  "unnamed_10" DOUBLE  -- Unnamed: 10,
  "unnamed_11" DOUBLE  -- Unnamed: 11,
  "unnamed_12" DOUBLE  -- Unnamed: 12,
  "unnamed_13" DOUBLE  -- Unnamed: 13,
  "unnamed_14" DOUBLE  -- Unnamed: 14,
  "unnamed_15" DOUBLE  -- Unnamed: 15,
  "unnamed_16" DOUBLE  -- Unnamed: 16,
  "unnamed_17" DOUBLE  -- Unnamed: 17,
  "unnamed_18" DOUBLE  -- Unnamed: 18,
  "unnamed_19" DOUBLE  -- Unnamed: 19,
  "unnamed_20" DOUBLE  -- Unnamed: 20
);

2016

@ukgov.leeds_annual_traffic_growth.n_2016

2.6 MB
547,749 rows
22 columns

CREATE TABLE n_2016 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedescription" VARCHAR,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR,
  "unnamed_9" DOUBLE  -- Unnamed: 9,
  "unnamed_10" DOUBLE  -- Unnamed: 10,
  "unnamed_11" DOUBLE  -- Unnamed: 11,
  "unnamed_12" DOUBLE  -- Unnamed: 12,
  "unnamed_13" DOUBLE  -- Unnamed: 13,
  "unnamed_14" DOUBLE  -- Unnamed: 14,
  "unnamed_15" DOUBLE  -- Unnamed: 15,
  "unnamed_16" DOUBLE  -- Unnamed: 16,
  "unnamed_17" DOUBLE  -- Unnamed: 17,
  "unnamed_18" DOUBLE  -- Unnamed: 18,
  "unnamed_19" DOUBLE  -- Unnamed: 19,
  "unnamed_20" DOUBLE  -- Unnamed: 20,
  "unnamed_21" DOUBLE  -- Unnamed: 21
);

2017

@ukgov.leeds_annual_traffic_growth.n_2017

2.74 MB
573,384 rows
9 columns

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

2018

@ukgov.leeds_annual_traffic_growth.n_2018

2.78 MB
584,003 rows
15 columns

CREATE TABLE n_2018 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedescription" VARCHAR,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR,
  "unnamed_9" DOUBLE  -- Unnamed: 9,
  "unnamed_10" DOUBLE  -- Unnamed: 10,
  "unnamed_11" DOUBLE  -- Unnamed: 11,
  "unnamed_12" DOUBLE  -- Unnamed: 12,
  "unnamed_13" DOUBLE  -- Unnamed: 13,
  "unnamed_14" DOUBLE  -- Unnamed: 14
);

2019

@ukgov.leeds_annual_traffic_growth.n_2019

2.74 MB
583,499 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
);

November 2020

@ukgov.leeds_annual_traffic_growth.november_2020

140.58 kB
44,832 rows
9 columns

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

October 2020

@ukgov.leeds_annual_traffic_growth.october_2020

147.24 kB
47,184 rows
9 columns

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

Recorder Locations

@ukgov.leeds_annual_traffic_growth.recorder_locations

7 kB
29 rows
7 columns

CREATE TABLE recorder_locations (
  "site_name" VARCHAR,
  "site_id" BIGINT,
  "description" VARCHAR,
  "grid" DOUBLE,
  "x" BIGINT,
  "y" BIGINT,
  "orientation" VARCHAR
);

September 2020

@ukgov.leeds_annual_traffic_growth.september_2020

137.91 kB
43,944 rows
9 columns

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