About this Dataset

Penalty Charge Notice Data

This data presents the number of Penalty Charge Notices (PCNs), more commonly known as parking tickets, issued for vehicles found to be in contravention of parking restrictions or bus lane restrictions.
Publisher name: OpenDataNI
Last updated: 2025-06-18T04:00:39Z

Tables

Moving Traffic Offences

@ukgov.penalty_charge_notice_data.moving_traffic_offences

9.85 KB
3045 rows
6 columns


CREATE TABLE moving_traffic_offences (
  "town" VARCHAR,
  "street" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "offences" BIGINT,
  "quarter" VARCHAR
);

Off-street Parking Offences

@ukgov.penalty_charge_notice_data.off_street_parking_offences

10.06 KB
2637 rows
6 columns


CREATE TABLE off_street_parking_offences (
  "council" VARCHAR,
  "town" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "offences" VARCHAR,
  "quarter" VARCHAR
);

On-street Parking Offences

@ukgov.penalty_charge_notice_data.on_street_parking_offences

19.11 KB
8013 rows
9 columns


CREATE TABLE on_street_parking_offences (
  "town" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "offences" BIGINT,
  "quarter" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);