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

113.57 kB
20,944 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.on_street_parking_fines.quarter_1_2014_15

113.52 kB
19,271 rows
11 columns

CREATE TABLE quarter_1_2014_15 (
  "issue_date" VARCHAR,
  "issue_time" VARCHAR,
  "parking_location" VARCHAR,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "description_of_offence" VARCHAR,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "full_fine" VARCHAR  -- Full Fine Ś,
  "discount" VARCHAR  -- Discount Ś,
  "paid_in" VARCHAR  -- Paid In Ś
);

Quarter 1 - 2015/16

@ukgov.on_street_parking_fines.quarter_1_2015_16

45.52 kB
18,638 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

64.58 kB
20,138 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

63.56 kB
19,751 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

202.08 kB
52,938 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  -- Unnamed: 7
);

Quarter 1 - 2019/20

@ukgov.on_street_parking_fines.quarter_1_2019_20

205.5 kB
20,459 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.on_street_parking_fines.quarter_1_2020_21

21.97 kB
1,682 rows
6 columns

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

Quarter 2 - 2013/14

@ukgov.on_street_parking_fines.quarter_2_2013_14

112.64 kB
20,714 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.on_street_parking_fines.quarter_2_2014_15

105.73 kB
20,037 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.on_street_parking_fines.quarter_2_2015_16

75.73 kB
21,558 rows
7 columns

CREATE TABLE quarter_2_2015_16 (
  "issued" VARCHAR,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "charge_level" VARCHAR,
  "fine" VARCHAR
);

Quarter 2 - 2016/17

@ukgov.on_street_parking_fines.quarter_2_2016_17

71.54 kB
20,779 rows
14 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,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13
);

Quarter 2 - 2017/18

@ukgov.on_street_parking_fines.quarter_2_2017_18

131.69 kB
40,795 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

490.45 kB
52,901 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  -- Unnamed: 8
);

Quarter 2 - 2019/20

@ukgov.on_street_parking_fines.quarter_2_2019_20

218.71 kB
22,060 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.on_street_parking_fines.quarter_2_2020_21

132.53 kB
13,477 rows
6 columns

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

Quarter 3 - 2013/14

@ukgov.on_street_parking_fines.quarter_3_2013_14

126.67 kB
24,436 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.on_street_parking_fines.quarter_3_2014_15

124.33 kB
25,485 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

53.2 kB
16,383 rows
4 columns

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

Quarter 3 - 2016/17

@ukgov.on_street_parking_fines.quarter_3_2016_17

11.04 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

219.06 kB
54,989 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

508.03 kB
54,963 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  -- Unnamed: 8
);

Quarter 3 - 2019/20

@ukgov.on_street_parking_fines.quarter_3_2019_20

513.98 kB
57,463 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  -- Unnamed: 8
);

Quarter 4 - 2013/14

@ukgov.on_street_parking_fines.quarter_4_2013_14

114.08 kB
20,949 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.on_street_parking_fines.quarter_4_2014_15

66.53 kB
20,485 rows
5 columns

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