On-street Parking Fines
Leeds City Council
@ukgov.on_street_parking_fines
Leeds City Council
@ukgov.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
CREATE TABLE quarter_4_2015_16 (
"issued" VARCHAR,
"location" VARCHAR,
"contravention" VARCHAR,
"fine" VARCHAR,
"last_pay_date" VARCHAR,
"total_paid" VARCHAR,
"balance" VARCHAR
);CREATE TABLE quarter_4_2016_17 (
"issued" VARCHAR,
"location" VARCHAR,
"contravention" VARCHAR,
"fine" BIGINT
);CREATE TABLE quarter_4_2017_18 (
"issued" VARCHAR,
"location" VARCHAR,
"contravention" VARCHAR,
"fine" VARCHAR
);CREATE TABLE quarter_4_2018_19 (
"pcn" VARCHAR,
"issued" TIMESTAMP,
"location" VARCHAR,
"contravention" VARCHAR,
"fine" BIGINT,
"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
);CREATE TABLE quarter_4_2019_20 (
"pcn" VARCHAR,
"issued" TIMESTAMP,
"location" VARCHAR,
"contravention" VARCHAR,
"fine" BIGINT,
"unnamed_5" VARCHAR -- Unnamed: 5
);Anyone who has the link will be able to view this.