About this Dataset

Off-street Parking Fines

Data files that contain every fine issued for vehicles not having a valid parking ticket whilst in car parks. The data contains date, time, location, fine issued, discount available, and total paid. Local Government Transparency Code 2015 --------------------------------------- * This is a key dataset which the government wants local authorities to publish. * https://www.gov.uk/government/publications/local-government-transparency-code-2015 Additional Info --------------- * Due to the Covid-19 pandemic there were no enforcements issued from 24/03/2020 to 17/06/2020. * Please note, from Quarter 3 2014/15, data on off street fines (car park fines) 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. Definitions ----------- * Issued - Date PCN was issued * Fine - Initial full charge (does not include surcharges) * Surcharges - If full payment not made within 56 days from the date the notice is issued the charge is further increased by 50% of the Initial charge. If the payment is still not made, within a further 14 days then a further charge may be applied if the case is registered at court. * Charge level - H = High at £70.00/£35.00 discount. L = Low at £50.00/£25.00 discount. * Discount - the charge if payment made within 14 days. * Balance Amount outstanding at date of sample. A negative balance means an overpayment.
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:52:08Z

Tables

Quarter 1 - 2013/14

@ukgov.off_street_parking_fines.quarter_1_2013_14

24.52 kB
4,245 rows
7 columns

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

Quarter 1 - 2014/15

@ukgov.off_street_parking_fines.quarter_1_2014_15

19.35 kB
2,587 rows
7 columns

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

Quarter 1 - 2016/17

@ukgov.off_street_parking_fines.quarter_1_2016_17

11.41 kB
3,000 rows
7 columns

CREATE TABLE quarter_1_2016_17 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" DOUBLE,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

Quarter 1 - 2017/18

@ukgov.off_street_parking_fines.quarter_1_2017_18

6.65 kB
1,345 rows
3 columns

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

Quarter 1–2018/19

@ukgov.off_street_parking_fines.quarter_1_2018_19

11.6 kB
3,589 rows
5 columns

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

Quarter 1 - 2019/20

@ukgov.off_street_parking_fines.quarter_1_2019_20

29.22 kB
2,776 rows
6 columns

CREATE TABLE quarter_1_2019_20 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" BIGINT,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Quarter 1 - 2020/21

@ukgov.off_street_parking_fines.quarter_1_2020_21

5.12 kB
40 rows
6 columns

CREATE TABLE quarter_1_2020_21 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" DOUBLE,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Quarter 2 - 2013/14

@ukgov.off_street_parking_fines.quarter_2_2013_14

24.96 kB
4,339 rows
7 columns

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

Quarter 2 - 2014/15

@ukgov.off_street_parking_fines.quarter_2_2014_15

20.25 kB
2,847 rows
7 columns

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

Quarter 2 - 2015/16

@ukgov.off_street_parking_fines.quarter_2_2015_16

5.88 kB
2,580 rows
3 columns

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

Quarter 2 - 2016/17

@ukgov.off_street_parking_fines.quarter_2_2016_17

11.61 kB
3,004 rows
7 columns

CREATE TABLE quarter_2_2016_17 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" DOUBLE,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

Quarter 2 - 2017/18

@ukgov.off_street_parking_fines.quarter_2_2017_18

10.98 kB
2,698 rows
7 columns

CREATE TABLE quarter_2_2017_18 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" BIGINT,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

Quarter 2 - 2019/20

@ukgov.off_street_parking_fines.quarter_2_2019_20

30.25 kB
2,931 rows
6 columns

CREATE TABLE quarter_2_2019_20 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" BIGINT,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Quarter 2 - 2020/21

@ukgov.off_street_parking_fines.quarter_2_2020_21

20.98 kB
1,798 rows
6 columns

CREATE TABLE quarter_2_2020_21 (
  "pcn" VARCHAR,
  "issued" VARCHAR,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" VARCHAR,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Quarter 3 - 2013/14

@ukgov.off_street_parking_fines.quarter_3_2013_14

25.17 kB
4,337 rows
7 columns

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

Quarter 3 - 2014/15

@ukgov.off_street_parking_fines.quarter_3_2014_15

22.51 kB
3,264 rows
8 columns

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

Quarter 3 - 2015/16

@ukgov.off_street_parking_fines.quarter_3_2015_16

90.44 kB
16,383 rows
7 columns

CREATE TABLE quarter_3_2015_16 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" BIGINT  -- FINE (Ł),
  "last_pay_date" TIMESTAMP,
  "total_paid" DOUBLE  -- Total Paid (Ł),
  "balance" DOUBLE  -- Balance (Ł)
);

Quarter 3 - 2017/18

@ukgov.off_street_parking_fines.quarter_3_2017_18

11.66 kB
3,228 rows
7 columns

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

Quarter 3 - 2018/19

@ukgov.off_street_parking_fines.quarter_3_2018_19

34.83 kB
3,509 rows
6 columns

CREATE TABLE quarter_3_2018_19 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" BIGINT,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Quarter 4 - 2013/14

@ukgov.off_street_parking_fines.quarter_4_2013_14

23.2 kB
3,769 rows
7 columns

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

Quarter 4- 2014/15

@ukgov.off_street_parking_fines.quarter_4_2014_15

33.62 kB
7,218 rows
8 columns

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

Quarter 4 - 2016/17

@ukgov.off_street_parking_fines.quarter_4_2016_17

12.04 kB
3,491 rows
7 columns

CREATE TABLE quarter_4_2016_17 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" DOUBLE,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

Quarter 4 - 2017/18

@ukgov.off_street_parking_fines.quarter_4_2017_18

32.15 kB
7,941 rows
8 columns

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

Quarter 4 - 2018/19

@ukgov.off_street_parking_fines.quarter_4_2018_19

32.28 kB
3,178 rows
6 columns

CREATE TABLE quarter_4_2018_19 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" BIGINT,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);