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

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

Quarter 1 - 2014/15

@ukgov.off_street_parking_fines.quarter_1_2014_15

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

Quarter 1 - 2016/17

@ukgov.off_street_parking_fines.quarter_1_2016_17

11.14 KB
3000 rows
7 columns


CREATE TABLE quarter_1_2016_17 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" DOUBLE,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

Quarter 1 - 2017/18

@ukgov.off_street_parking_fines.quarter_1_2017_18

6.5 KB
1345 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.33 KB
3589 rows
5 columns


CREATE TABLE quarter_1_2018_19 (
  "issued" VARCHAR,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" VARCHAR,
  "unnamed_4" VARCHAR
);

Quarter 1 - 2019/20

@ukgov.off_street_parking_fines.quarter_1_2019_20

28.53 KB
2776 rows
6 columns


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

Quarter 1 - 2020/21

@ukgov.off_street_parking_fines.quarter_1_2020_21

5 KB
40 rows
6 columns


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

Quarter 2 - 2013/14

@ukgov.off_street_parking_fines.quarter_2_2013_14

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

Quarter 2 - 2014/15

@ukgov.off_street_parking_fines.quarter_2_2014_15

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

Quarter 2 - 2015/16

@ukgov.off_street_parking_fines.quarter_2_2015_16

5.74 KB
2580 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.33 KB
3004 rows
7 columns


CREATE TABLE quarter_2_2016_17 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" DOUBLE,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

Quarter 2 - 2017/18

@ukgov.off_street_parking_fines.quarter_2_2017_18

10.73 KB
2698 rows
7 columns


CREATE TABLE quarter_2_2017_18 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" BIGINT,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

Quarter 2 - 2019/20

@ukgov.off_street_parking_fines.quarter_2_2019_20

29.54 KB
2931 rows
6 columns


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

Quarter 2 - 2020/21

@ukgov.off_street_parking_fines.quarter_2_2020_21

20.49 KB
1798 rows
6 columns


CREATE TABLE quarter_2_2020_21 (
  "pcn" VARCHAR,
  "issued" VARCHAR,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" VARCHAR,
  "unnamed_5" VARCHAR
);

Quarter 3 - 2013/14

@ukgov.off_street_parking_fines.quarter_3_2013_14

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

Quarter 3 - 2014/15

@ukgov.off_street_parking_fines.quarter_3_2014_15

21.98 KB
3264 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

88.32 KB
16383 rows
7 columns


CREATE TABLE quarter_3_2015_16 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" BIGINT,
  "last_pay_date" TIMESTAMP,
  "total_paid" DOUBLE,
  "balance" DOUBLE
);

Quarter 3 - 2017/18

@ukgov.off_street_parking_fines.quarter_3_2017_18

11.39 KB
3228 rows
7 columns


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

Quarter 3 - 2018/19

@ukgov.off_street_parking_fines.quarter_3_2018_19

34.01 KB
3509 rows
6 columns


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

Quarter 4 - 2013/14

@ukgov.off_street_parking_fines.quarter_4_2013_14

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

Quarter 4- 2014/15

@ukgov.off_street_parking_fines.quarter_4_2014_15

32.84 KB
7218 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

11.75 KB
3491 rows
7 columns


CREATE TABLE quarter_4_2016_17 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" DOUBLE,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

Quarter 4 - 2017/18

@ukgov.off_street_parking_fines.quarter_4_2017_18

31.39 KB
7941 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
);

Quarter 4 - 2018/19

@ukgov.off_street_parking_fines.quarter_4_2018_19

31.52 KB
3178 rows
6 columns


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