About this Dataset

On-street Parking Fines

Data files that contain fines issued for unauthorised parked vehicles in on-street locations. 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 --------------- * Please note, from Quarter 3 2014/15, on street parking 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. 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:58:04Z

Tables

Quarter 1 - 2013/14

@ukgov.on_street_parking_fines.quarter_1_2013_14

110.9 KB
20944 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.on_street_parking_fines.quarter_1_2014_15

110.86 KB
19271 rows
11 columns


CREATE TABLE quarter_1_2014_15 (
  "issue_date" VARCHAR,
  "issue_time" VARCHAR,
  "parking_location" VARCHAR,
  "unnamed_3" VARCHAR,
  "description_of_offence" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "full_fine" VARCHAR,
  "discount" VARCHAR,
  "paid_in" VARCHAR
);

Quarter 1 - 2015/16

@ukgov.on_street_parking_fines.quarter_1_2015_16

44.45 KB
18638 rows
3 columns


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

Quarter 1 - 2016/17

@ukgov.on_street_parking_fines.quarter_1_2016_17

63.07 KB
20138 rows
4 columns


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

Quarter 1 - 2017/18

@ukgov.on_street_parking_fines.quarter_1_2017_18

62.07 KB
19751 rows
4 columns


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

Quarter 1–2018/19

@ukgov.on_street_parking_fines.quarter_1_2018_19

197.34 KB
52938 rows
8 columns


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

Quarter 1 - 2019/20

@ukgov.on_street_parking_fines.quarter_1_2019_20

200.68 KB
20459 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.on_street_parking_fines.quarter_1_2020_21

21.46 KB
1682 rows
6 columns


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

Quarter 2 - 2013/14

@ukgov.on_street_parking_fines.quarter_2_2013_14

110 KB
20714 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.on_street_parking_fines.quarter_2_2014_15

103.25 KB
20037 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.on_street_parking_fines.quarter_2_2015_16

73.96 KB
21558 rows
7 columns


CREATE TABLE quarter_2_2015_16 (
  "issued" VARCHAR,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "charge_level" VARCHAR,
  "fine" VARCHAR
);

Quarter 2 - 2016/17

@ukgov.on_street_parking_fines.quarter_2_2016_17

69.86 KB
20779 rows
14 columns


CREATE TABLE quarter_2_2016_17 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" DOUBLE,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR
);

Quarter 2 - 2017/18

@ukgov.on_street_parking_fines.quarter_2_2017_18

128.6 KB
40795 rows
5 columns


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

Quarter 2 - 2018/19

@ukgov.on_street_parking_fines.quarter_2_2018_19

478.96 KB
52901 rows
9 columns


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

Quarter 2 - 2019/20

@ukgov.on_street_parking_fines.quarter_2_2019_20

213.58 KB
22060 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.on_street_parking_fines.quarter_2_2020_21

129.43 KB
13477 rows
6 columns


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

Quarter 3 - 2013/14

@ukgov.on_street_parking_fines.quarter_3_2013_14

123.7 KB
24436 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.on_street_parking_fines.quarter_3_2014_15

121.42 KB
25485 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.on_street_parking_fines.quarter_3_2015_16

51.96 KB
16383 rows
4 columns


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

Quarter 3 - 2016/17

@ukgov.on_street_parking_fines.quarter_3_2016_17

10.78 KB
404 rows
5 columns


CREATE TABLE quarter_3_2016_17 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "last_pay_date" TIMESTAMP,
  "total_paid" DOUBLE
);

Quarter 3 - 2017/18

@ukgov.on_street_parking_fines.quarter_3_2017_18

213.93 KB
54989 rows
5 columns


CREATE TABLE quarter_3_2017_18 (
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "last_pay_date" TIMESTAMP,
  "total_paid" DOUBLE
);

Quarter 3 - 2018/19

@ukgov.on_street_parking_fines.quarter_3_2018_19

496.13 KB
54963 rows
9 columns


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

Quarter 3 - 2019/20

@ukgov.on_street_parking_fines.quarter_3_2019_20

501.93 KB
57463 rows
9 columns


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

Quarter 4 - 2013/14

@ukgov.on_street_parking_fines.quarter_4_2013_14

111.4 KB
20949 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.on_street_parking_fines.quarter_4_2014_15

64.97 KB
20485 rows
5 columns


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