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

April 2021

@ukgov.leeds_annual_traffic_growth.april_2021

129.99 KB
42756 rows
10 columns


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

August 2020

@ukgov.leeds_annual_traffic_growth.august_2020

163.76 KB
54890 rows
9 columns


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

December 2020

@ukgov.leeds_annual_traffic_growth.december_2020

111.86 KB
35088 rows
9 columns


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

February 2021

@ukgov.leeds_annual_traffic_growth.february_2021

95.51 KB
42318 rows
9 columns


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

January 2021

@ukgov.leeds_annual_traffic_growth.january_2021

118.22 KB
37690 rows
10 columns


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

January - May 2020

@ukgov.leeds_annual_traffic_growth.january_may_2020

938.52 KB
256548 rows
9 columns


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

July 2020

@ukgov.leeds_annual_traffic_growth.july_2020

115.78 KB
42988 rows
9 columns


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

June 2020

@ukgov.leeds_annual_traffic_growth.june_2020

168.16 KB
57810 rows
9 columns


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

March 2021

@ukgov.leeds_annual_traffic_growth.march_2021

146.67 KB
48760 rows
9 columns


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

May 2021

@ukgov.leeds_annual_traffic_growth.may_2021

138.92 KB
50662 rows
9 columns


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

1997

@ukgov.leeds_annual_traffic_growth.n_1997

328.53 KB
73294 rows
8 columns


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

1998

@ukgov.leeds_annual_traffic_growth.n_1998

243.86 KB
64840 rows
8 columns


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

1999

@ukgov.leeds_annual_traffic_growth.n_1999

247.32 KB
59420 rows
13 columns


CREATE TABLE n_1999 (
  "sdate" VARCHAR,
  "cosit" BIGINT,
  "period" BIGINT,
  "lanenumber" BIGINT,
  "lanedirection" BIGINT,
  "directiondescription" VARCHAR,
  "volume" BIGINT,
  "flag_text" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR
);

2000

@ukgov.leeds_annual_traffic_growth.n_2000

243.77 KB
54158 rows
8 columns


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

2001

@ukgov.leeds_annual_traffic_growth.n_2001

177.5 KB
44434 rows
8 columns


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

2002

@ukgov.leeds_annual_traffic_growth.n_2002

400.92 KB
103288 rows
8 columns


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

2003

@ukgov.leeds_annual_traffic_growth.n_2003

329.89 KB
84662 rows
8 columns


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

2004

@ukgov.leeds_annual_traffic_growth.n_2004

372.57 KB
96278 rows
8 columns


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

2005

@ukgov.leeds_annual_traffic_growth.n_2005

358.2 KB
100214 rows
8 columns


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

2006

@ukgov.leeds_annual_traffic_growth.n_2006

422.09 KB
106400 rows
8 columns


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

2007

@ukgov.leeds_annual_traffic_growth.n_2007

861.9 KB
206774 rows
8 columns


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

2008

@ukgov.leeds_annual_traffic_growth.n_2008

1023.11 KB
228310 rows
8 columns


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

2009

@ukgov.leeds_annual_traffic_growth.n_2009

1.05 MB
234204 rows
8 columns


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

2010

@ukgov.leeds_annual_traffic_growth.n_2010

1.34 MB
303992 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_traffic_growth.n_2011

2.66 MB
602392 rows
8 columns


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