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.37 MB
528573 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.4 MB
534776 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.06 MB
544216 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.04 MB
490630 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_10" DOUBLE,
  "unnamed_11" DOUBLE,
  "unnamed_12" DOUBLE,
  "unnamed_13" DOUBLE,
  "unnamed_14" DOUBLE,
  "unnamed_15" DOUBLE,
  "unnamed_16" DOUBLE,
  "unnamed_17" DOUBLE,
  "unnamed_18" DOUBLE,
  "unnamed_19" DOUBLE,
  "unnamed_20" DOUBLE
);

2016

@ukgov.leeds_annual_traffic_growth.n_2016

2.48 MB
547749 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_10" DOUBLE,
  "unnamed_11" DOUBLE,
  "unnamed_12" DOUBLE,
  "unnamed_13" DOUBLE,
  "unnamed_14" DOUBLE,
  "unnamed_15" DOUBLE,
  "unnamed_16" DOUBLE,
  "unnamed_17" DOUBLE,
  "unnamed_18" DOUBLE,
  "unnamed_19" DOUBLE,
  "unnamed_20" DOUBLE,
  "unnamed_21" DOUBLE
);

2017

@ukgov.leeds_annual_traffic_growth.n_2017

2.62 MB
573384 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.65 MB
584003 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_10" DOUBLE,
  "unnamed_11" DOUBLE,
  "unnamed_12" DOUBLE,
  "unnamed_13" DOUBLE,
  "unnamed_14" DOUBLE
);

2019

@ukgov.leeds_annual_traffic_growth.n_2019

2.62 MB
583499 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

137.29 KB
44832 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

143.79 KB
47184 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

6.83 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

134.68 KB
43944 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
);