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

133.11 kB
42,756 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  -- Unnamed: 9
);

August 2020

@ukgov.leeds_annual_traffic_growth.august_2020

167.69 kB
54,890 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

114.55 kB
35,088 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

97.81 kB
42,318 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

121.06 kB
37,690 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  -- Unnamed: 9
);

January - May 2020

@ukgov.leeds_annual_traffic_growth.january_may_2020

961.04 kB
256,548 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

118.55 kB
42,988 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

172.19 kB
57,810 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

150.19 kB
48,760 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

142.25 kB
50,662 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

336.42 kB
73,294 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

249.71 kB
64,840 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

253.26 kB
59,420 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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12
);

2000

@ukgov.leeds_annual_traffic_growth.n_2000

249.62 kB
54,158 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

181.76 kB
44,434 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

410.54 kB
103,288 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

337.81 kB
84,662 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

381.51 kB
96,278 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

366.8 kB
100,214 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

432.22 kB
106,400 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

882.58 kB
206,774 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

1.05 MB
228,310 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.1 MB
234,204 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.4 MB
303,992 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.79 MB
602,392 rows
8 columns

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