About this Dataset

Bus Lane Fines

Data files that contain every fine issued for unauthorised vehicles being in bus lanes. The data contains date, time, location, fine issued, discount available, and total paid. Additional information ---------------------- * Please note, from Quarter 3 2014/15, the bus lane fines data has been divided in to a fines issued dataset and fines paid dataset. * Also, note the paid data may show fines issued outside the dated quarter but paid within the quarter. * Due to the Covid-19 pandemic there were no bus lane enforcements issued from 24/03/2020 to 24/06/2020. Definitions ----------- * Issued - Date Penalty Charge Notice (PCN) was issued * Time - Time PCN was Issued * Fine - Initial full charge (does not include surcharges) * Dates - There can often be a delay between the actual issue date of the PCN and the date thaat the PCN is uploaded to the parking system. However, the issue date remains as the date the camera captures the contravention regardless of the date the PCN is uploaded. This delay can be as much as 14 days in some cases, Christmas close down is a prime example. * Paid In (Balance) - Amount Paid, Where £30 is Shown, this indicates the Discounted Early Payment.
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:53:57Z

Tables

Quarter 1 - 2012/13

@ukgov.bus_lane_fines.quarter_1_2012_13

7.47 kB
11,212 rows
3 columns

CREATE TABLE quarter_1_2012_13 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" BIGINT
);

Quarter 1 - 2014/15

@ukgov.bus_lane_fines.quarter_1_2014_15

51.28 kB
17,550 rows
7 columns

CREATE TABLE quarter_1_2014_15 (
  "issue_date" TIMESTAMP,
  "issue_time" VARCHAR,
  "parking_location" VARCHAR,
  "description_of_offence" VARCHAR,
  "full_fine" BIGINT  -- Full Fine Ł,
  "discount" BIGINT  -- Discount Ł,
  "paid_in" BIGINT  -- Paid In Ł
);

Quarter 1 - 2015/16

@ukgov.bus_lane_fines.quarter_1_2015_16

71.25 kB
29,702 rows
6 columns

CREATE TABLE quarter_1_2015_16 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" VARCHAR,
  "last_pay_date" TIMESTAMP,
  "total_paid" VARCHAR,
  "balance" VARCHAR
);

Quarter 1 - 2016/17

@ukgov.bus_lane_fines.quarter_1_2016_17

87.45 kB
41,316 rows
6 columns

CREATE TABLE quarter_1_2016_17 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" VARCHAR,
  "last_pay_date" TIMESTAMP,
  "total_paid" VARCHAR,
  "balance" VARCHAR
);

Quarter 1 - 2017/18

@ukgov.bus_lane_fines.quarter_1_2017_18

9.79 kB
10,194 rows
3 columns

CREATE TABLE quarter_1_2017_18 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" BIGINT
);

Quarter 1 - 2019/20

@ukgov.bus_lane_fines.quarter_1_2019_20

232.31 kB
32,388 rows
8 columns

CREATE TABLE quarter_1_2019_20 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" BIGINT,
  "last_pay_date" TIMESTAMP,
  "total_paid" DOUBLE,
  "balance" DOUBLE,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

Quarter 1–2020/21

@ukgov.bus_lane_fines.quarter_1_2020_21

8.38 kB
556 rows
4 columns

CREATE TABLE quarter_1_2020_21 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" BIGINT
);

Quarter 2 - 2012/13

@ukgov.bus_lane_fines.quarter_2_2012_13

6.79 kB
9,959 rows
3 columns

CREATE TABLE quarter_2_2012_13 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" BIGINT
);

Quarter 2 - 2013/14

@ukgov.bus_lane_fines.quarter_2_2013_14

44.9 kB
14,143 rows
7 columns

CREATE TABLE quarter_2_2013_14 (
  "issue_date" TIMESTAMP,
  "issue_time" VARCHAR,
  "bus_lane_location" VARCHAR,
  "description_of_offence" VARCHAR,
  "full_fine" DOUBLE  -- Full Fine Ł,
  "discount" DOUBLE  -- Discount Ł,
  "paid_in" DOUBLE  -- Paid In Ł
);

Quarter 2 - 2014/15

@ukgov.bus_lane_fines.quarter_2_2014_15

62.05 kB
24,210 rows
6 columns

CREATE TABLE quarter_2_2014_15 (
  "issue_time" VARCHAR,
  "parking_location" VARCHAR,
  "description_of_offence" VARCHAR,
  "full_fine" BIGINT  -- Full Fine Ł,
  "discount" BIGINT  -- Discount Ł,
  "paid_in" BIGINT  -- Paid In Ł
);

Quarter 2 - 2015/16

@ukgov.bus_lane_fines.quarter_2_2015_16

12.83 kB
17,136 rows
3 columns

CREATE TABLE quarter_2_2015_16 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" VARCHAR
);

Quarter 2 - 2016/17

@ukgov.bus_lane_fines.quarter_2_2016_17

33.91 kB
12,280 rows
4 columns

CREATE TABLE quarter_2_2016_17 (
  "issue_date" TIMESTAMP,
  "issue_time" VARCHAR,
  "parking_location" VARCHAR,
  "full_fine" BIGINT  -- Full Fine Ł
);

Quarter 2 - 2017/18

@ukgov.bus_lane_fines.quarter_2_2017_18

32.49 kB
26,999 rows
3 columns

CREATE TABLE quarter_2_2017_18 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "total_paid" DOUBLE
);

Quarter 2–2018/19

@ukgov.bus_lane_fines.quarter_2_2018_19

74.15 kB
8,890 rows
4 columns

CREATE TABLE quarter_2_2018_19 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" BIGINT
);

Quarter 2 - 2019/20

@ukgov.bus_lane_fines.quarter_2_2019_20

221.54 kB
30,184 rows
8 columns

CREATE TABLE quarter_2_2019_20 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" BIGINT,
  "last_pay_date" TIMESTAMP,
  "total_paid" DOUBLE,
  "balance" DOUBLE,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

Quarter 2 - 2020/21

@ukgov.bus_lane_fines.quarter_2_2020_21

58.68 kB
6,857 rows
5 columns

CREATE TABLE quarter_2_2020_21 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" BIGINT,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Quarter 3 - 2012/13

@ukgov.bus_lane_fines.quarter_3_2012_13

25.29 kB
31,514 rows
3 columns

CREATE TABLE quarter_3_2012_13 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "total_paid" DOUBLE
);

Quarter 3 - 2014/15

@ukgov.bus_lane_fines.quarter_3_2014_15

58.26 kB
22,912 rows
6 columns

CREATE TABLE quarter_3_2014_15 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" VARCHAR,
  "last_pay_date" TIMESTAMP,
  "total_paid" VARCHAR,
  "balance" VARCHAR
);

Quarter 3 - 2016/17

@ukgov.bus_lane_fines.quarter_3_2016_17

485.62 kB
195,544 rows
4 columns

CREATE TABLE quarter_3_2016_17 (
  "issue_date" TIMESTAMP,
  "issue_time" VARCHAR,
  "parking_location" VARCHAR,
  "paid_in" DOUBLE  -- Paid In Ł
);

Quarter 3 - 2017/18

@ukgov.bus_lane_fines.quarter_3_2017_18

9.7 kB
6,266 rows
5 columns

CREATE TABLE quarter_3_2017_18 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" DOUBLE,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Quarter 3–2018/19

@ukgov.bus_lane_fines.quarter_3_2018_19

71.08 kB
8,490 rows
4 columns

CREATE TABLE quarter_3_2018_19 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" BIGINT
);

Quarter 3 - 2019/20

@ukgov.bus_lane_fines.quarter_3_2019_20

215.06 kB
29,803 rows
8 columns

CREATE TABLE quarter_3_2019_20 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" BIGINT,
  "last_pay_date" TIMESTAMP,
  "total_paid" DOUBLE,
  "balance" DOUBLE,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

Quarter 4 - 2012/13

@ukgov.bus_lane_fines.quarter_4_2012_13

7.05 kB
11,128 rows
3 columns

CREATE TABLE quarter_4_2012_13 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" BIGINT
);

Quarter 4 - 2013/14

@ukgov.bus_lane_fines.quarter_4_2013_14

28.56 kB
7,647 rows
7 columns

CREATE TABLE quarter_4_2013_14 (
  "issue_date" TIMESTAMP,
  "issue_time" VARCHAR,
  "parking_location" VARCHAR,
  "description_of_offence" VARCHAR,
  "full_fine" BIGINT  -- Full Fine Ł,
  "discount" BIGINT  -- Discount Ł,
  "paid_in" DOUBLE  -- Paid In Ł
);

Quarter 4 - 2014/15

@ukgov.bus_lane_fines.quarter_4_2014_15

62.23 kB
27,189 rows
6 columns

CREATE TABLE quarter_4_2014_15 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" VARCHAR,
  "last_pay_date" TIMESTAMP,
  "total_paid" VARCHAR,
  "balance" VARCHAR
);