Dataset: Parking Penalty Charge Notices (PCNs)

About this Dataset

Parking Penalty Charge Notices (PCNs)

This dataset shows the Penalty Charge Notices (PCN's) issued in on-street parking areas throughout Lincolnshire. To view our interactive maps, press the "Explore" button and then select the option "Go to Resource".

For any enquiries about this publication please contact parkingservices@lincolnshire.gov.uk .
Publisher name: Lincolnshire County Council
Last updated: 2025-06-13T04:00:26Z

Tables

Parking Penalty Charge Notices (PCNs) Current Financial Year

@ukgov.parking_penalty_charge_notices_pcns.parking_penalty_charge_notices_pcns_current_financial_year

145.59 KB
5927 rows
29 columns


CREATE TABLE parking_penalty_charge_notices_pcns_current_financial_year (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "published_date" TIMESTAMP,
  "latest_data" BOOLEAN,
  "duration_from" TIMESTAMP,
  "duration_to" TIMESTAMP,
  "reporting_period_type" VARCHAR,
  "reporting_period" VARCHAR,
  "geoentity_name" VARCHAR,
  "geo_code" VARCHAR,
  "geo_name" VARCHAR,
  "geouri" VARCHAR,
  "district_name" VARCHAR,
  "month" TIMESTAMP,
  "date_issued" TIMESTAMP,
  "day_issued" VARCHAR,
  "time_issued" VARCHAR,
  "time_band" VARCHAR,
  "contravention_code" VARCHAR,
  "status" VARCHAR,
  "area" VARCHAR,
  "street" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "appeal_outcome" VARCHAR,
  "appeal_decision" VARCHAR,
  "charge_level" VARCHAR,
  "revenue_recovered" DOUBLE,
  "address_checker" VARCHAR
);