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.3 KB
11212 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

50.08 KB
17550 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,
  "discount" BIGINT,
  "paid_in" BIGINT
);

Quarter 1 - 2015/16

@ukgov.bus_lane_fines.quarter_1_2015_16

69.58 KB
29702 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

85.4 KB
41316 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.56 KB
10194 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

226.87 KB
32388 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
);

Quarter 1–2020/21

@ukgov.bus_lane_fines.quarter_1_2020_21

8.18 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.63 KB
9959 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

43.84 KB
14143 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,
  "discount" DOUBLE,
  "paid_in" DOUBLE
);

Quarter 2 - 2014/15

@ukgov.bus_lane_fines.quarter_2_2014_15

60.59 KB
24210 rows
6 columns


CREATE TABLE quarter_2_2014_15 (
  "issue_time" VARCHAR,
  "parking_location" VARCHAR,
  "description_of_offence" VARCHAR,
  "full_fine" BIGINT,
  "discount" BIGINT,
  "paid_in" BIGINT
);

Quarter 2 - 2015/16

@ukgov.bus_lane_fines.quarter_2_2015_16

12.53 KB
17136 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.11 KB
12280 rows
4 columns


CREATE TABLE quarter_2_2016_17 (
  "issue_date" TIMESTAMP,
  "issue_time" VARCHAR,
  "parking_location" VARCHAR,
  "full_fine" BIGINT
);

Quarter 2 - 2017/18

@ukgov.bus_lane_fines.quarter_2_2017_18

31.73 KB
26999 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

72.41 KB
8890 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

216.35 KB
30184 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
);

Quarter 2 - 2020/21

@ukgov.bus_lane_fines.quarter_2_2020_21

57.31 KB
6857 rows
5 columns


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

Quarter 3 - 2012/13

@ukgov.bus_lane_fines.quarter_3_2012_13

24.7 KB
31514 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

56.9 KB
22912 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

474.23 KB
195544 rows
4 columns


CREATE TABLE quarter_3_2016_17 (
  "issue_date" TIMESTAMP,
  "issue_time" VARCHAR,
  "parking_location" VARCHAR,
  "paid_in" DOUBLE
);

Quarter 3 - 2017/18

@ukgov.bus_lane_fines.quarter_3_2017_18

9.47 KB
6266 rows
5 columns


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

Quarter 3–2018/19

@ukgov.bus_lane_fines.quarter_3_2018_19

69.41 KB
8490 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

210.02 KB
29803 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
);

Quarter 4 - 2012/13

@ukgov.bus_lane_fines.quarter_4_2012_13

6.89 KB
11128 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

27.89 KB
7647 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,
  "discount" BIGINT,
  "paid_in" DOUBLE
);

Quarter 4 - 2014/15

@ukgov.bus_lane_fines.quarter_4_2014_15

60.77 KB
27189 rows
6 columns


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