Baselight

On-street Parking Fines

Leeds City Council

@ukgov.on_street_parking_fines

Loading...
Loading...

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

@ukgov.on_street_parking_fines.quarter_4_2015_16
  • 261.07 KB
  • 59889 rows
  • 7 columns
Loading...

CREATE TABLE quarter_4_2015_16 (
  "issued" VARCHAR,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" VARCHAR,
  "last_pay_date" VARCHAR,
  "total_paid" VARCHAR,
  "balance" VARCHAR
);

Quarter 4 - 2016/17

@ukgov.on_street_parking_fines.quarter_4_2016_17
  • 66.24 KB
  • 21924 rows
  • 4 columns
Loading...

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

Quarter 4–2017/18

@ukgov.on_street_parking_fines.quarter_4_2017_18
  • 72.35 KB
  • 23504 rows
  • 4 columns
Loading...

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

Quarter 4 - 2018/19

@ukgov.on_street_parking_fines.quarter_4_2018_19
  • 208.72 KB
  • 20895 rows
  • 12 columns
Loading...

CREATE TABLE quarter_4_2018_19 (
  "pcn" VARCHAR,
  "issued" TIMESTAMP,
  "location" VARCHAR,
  "contravention" VARCHAR,
  "fine" BIGINT,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR
);

Quarter 4 - 2019/20

@ukgov.on_street_parking_fines.quarter_4_2019_20
  • 211.21 KB
  • 21718 rows
  • 6 columns
Loading...

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

Share link

Anyone who has the link will be able to view this.