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 4 - 2015/16

@ukgov.bus_lane_fines.quarter_4_2015_16

8.97 KB
9546 rows
3 columns


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

Quarter 4 - 2016/17

@ukgov.bus_lane_fines.quarter_4_2016_17

494.85 KB
202642 rows
4 columns


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

Quarter 4–2017/18

@ukgov.bus_lane_fines.quarter_4_2017_18

55.03 KB
6616 rows
4 columns


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

Quarter 4–2018/19

@ukgov.bus_lane_fines.quarter_4_2018_19

82.22 KB
10221 rows
4 columns


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

Quarter 4 - 2019/20

@ukgov.bus_lane_fines.quarter_4_2019_20

169.44 KB
23891 rows
8 columns


CREATE TABLE quarter_4_2019_20 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "fine" BIGINT,
  "last_pay_date" TIMESTAMP,
  "total_paid" DOUBLE,
  "balance" DOUBLE,
  "unnamed_7" VARCHAR
);