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

10.09 kB
3,045 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.3 kB
2,637 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.57 kB
8,013 rows
9 columns

CREATE TABLE on_street_parking_offences (
  "town" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "offences" BIGINT,
  "quarter" VARCHAR,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);