About this Dataset

Fixed Penalty Notice - Dogs

The Fixed Penalty Notices (FPNs) issued for dog fouling and other offences under Dog Control Orders from 2005 to 2009 by local authorities.
Publisher name: Department for Environment, Food and Rural Affairs
Last updated: 2022-07-01T04:04:25Z

Tables

Fixed Penalty Notice - Dogs

@ukgov.fixed_penalty_notice_dogs.fixed_penalty_notice_dogs

9.65 KB
369 rows
3 columns


CREATE TABLE fixed_penalty_notice_dogs (
  "n__window_datalayer_window_datalayer" VARCHAR,
  "unnamed_1" VARCHAR,
  "n" VARCHAR
);

FPNs 2006-2007 Dog Control Orders

@ukgov.fixed_penalty_notice_dogs.fpns_2006_2007_dog_control_orders

13.46 KB
362 rows
9 columns


CREATE TABLE fpns_2006_2007_dog_control_orders (
  "dog_control_order_fixed_penalty_notice_log_for_april_0_6d0cf4be" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);

FPNs 2008-2009 Dog Fouling

@ukgov.fixed_penalty_notice_dogs.fpns_2008_2009_dog_fouling

14.74 KB
358 rows
9 columns


CREATE TABLE fpns_2008_2009_dog_fouling (
  "dog_fouling_fixed_penalty_notice_log_for_1_apr_2008_31_mar_2009" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);