Dataset: Parking Services Penalty Charge Notices Current Financial Year

About this Dataset

Parking Services Penalty Charge Notices Current Financial Year

This dataset contains transactional penalty charge notice data held in the London Borough of Camden's parking management system; inclusive of penalty charge notices issued by Civil Enforcement Officers on street and those issued by Civil Enforcement Officers via CCTV. Attribution includes contravention code, ticket type, street, parking restriction, vehicle category and status of case.

Where possible, the approximate location of the PCN has been captured. The 'Spatial Accuracy' column can be used to determine what level of location has been captured:

Civil Enforcement Officer GPS Location = the GPS location reported by the CEO's handheld device
Fixed CCTV Camera = the location of the CCTV camera, this could be many metres from the vehicle in contravention
Unknown = No location has been captured
Publisher name: London Borough of Camden
Last updated: 2025-06-02T04:06:14Z

Tables

Table 1

@ukgov.parking_services_penalty_charge_notices_current_financ_9681fa2a.table_1

15.34 MB
376679 rows
33 columns


CREATE TABLE table_1 (
  "contravention_date" VARCHAR,
  "contravention_in_last_7_days" VARCHAR,
  "ticket_type" VARCHAR,
  "ticket_description" VARCHAR,
  "contravention_code" VARCHAR,
  "contravention_code_suffix" VARCHAR,
  "contravention_code_description" VARCHAR,
  "ticket_issued_via_cctv_camera" VARCHAR,
  "controlled_parking_zone_area" VARCHAR,
  "street" VARCHAR,
  "vehicle_category" VARCHAR,
  "vehicle_removed" VARCHAR,
  "status_of_case" VARCHAR,
  "charging_band_description" VARCHAR,
  "civil_enforcement_officer_error" VARCHAR,
  "penalty_charge_notice_cancelled" VARCHAR,
  "penalty_charge_notice_written_off" VARCHAR,
  "cancellation_reason" VARCHAR,
  "cancellation_reason_description" VARCHAR,
  "foreign_vehicle" VARCHAR,
  "country_vehicle_registered_to" VARCHAR,
  "has_appeal" VARCHAR,
  "formal_representation" VARCHAR,
  "ward_code" VARCHAR,
  "ward_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" VARCHAR,
  "socrata_id" BIGINT
);