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.88 kB
369 rows
3 columns

CREATE TABLE fixed_penalty_notice_dogs (
  "n__window_datalayer_window_datalayer" VARCHAR  -- Window.dataLayer = Window.dataLayer,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "n" VARCHAR  -- [];
);

FPNs 2006-2007 Dog Control Orders

@ukgov.fixed_penalty_notice_dogs.fpns_2006_2007_dog_control_orders

13.79 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  -- DOG CONTROL ORDER - FIXED PENALTY NOTICE LOG FOR APRIL 06 - MARCH 07,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

FPNs 2008-2009 Dog Fouling

@ukgov.fixed_penalty_notice_dogs.fpns_2008_2009_dog_fouling

15.09 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  -- DOG FOULING - FIXED PENALTY NOTICE LOG FOR 1-Apr-2008 - 31-Mar-2009,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);