About this Dataset

Fixed Penalty Notice - Litter

The Fixed Penalty Notices (FPNs) issued for littering from 2005 to 2009 by local authorities.
Publisher name: Department for Environment, Food and Rural Affairs
Last updated: 2022-07-01T04:04:26Z

Tables

Fixed Penalty Notice - Litter

@ukgov.fixed_penalty_notice_litter.fixed_penalty_notice_litter

9.9 kB
369 rows
3 columns

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

FPNs 2006-2007 Street Litter Control Notices

@ukgov.fixed_penalty_notice_litter.fpns_2006_2007_street_litter_control_notices

13.58 kB
367 rows
9 columns

CREATE TABLE fpns_2006_2007_street_litter_control_notices (
  "street_litter_control_notice_fixed_penalty_notice_log__8f0c5f27" VARCHAR  -- STREET LITTER CONTROL NOTICE- 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 2007-2008 Litter

@ukgov.fixed_penalty_notice_litter.fpns_2007_2008_litter

17.41 kB
358 rows
9 columns

CREATE TABLE fpns_2007_2008_litter (
  "litter_fixed_penalty_notice_log_for_1_apr_2007_31_mar_2008" VARCHAR  -- LITTER - FIXED PENALTY NOTICE LOG FOR 1-Apr-2007 - 31-Mar-2008,
  "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 Street Litter Control Notices

@ukgov.fixed_penalty_notice_litter.fpns_2008_2009_street_litter_control_notices

13.76 kB
358 rows
9 columns

CREATE TABLE fpns_2008_2009_street_litter_control_notices (
  "street_litter_control_notice_fixed_penalty_notice_log__4883bc1d" VARCHAR  -- STREET LITTER CONTROL NOTICE - 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
);