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.67 KB
369 rows
3 columns


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

FPNs 2006-2007 Street Litter Control Notices

@ukgov.fixed_penalty_notice_litter.fpns_2006_2007_street_litter_control_notices

13.26 KB
367 rows
9 columns


CREATE TABLE fpns_2006_2007_street_litter_control_notices (
  "street_litter_control_notice_fixed_penalty_notice_log__8f0c5f27" 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 2007-2008 Litter

@ukgov.fixed_penalty_notice_litter.fpns_2007_2008_litter

17 KB
358 rows
9 columns


CREATE TABLE fpns_2007_2008_litter (
  "litter_fixed_penalty_notice_log_for_1_apr_2007_31_mar_2008" 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 Street Litter Control Notices

@ukgov.fixed_penalty_notice_litter.fpns_2008_2009_street_litter_control_notices

13.44 KB
358 rows
9 columns


CREATE TABLE fpns_2008_2009_street_litter_control_notices (
  "street_litter_control_notice_fixed_penalty_notice_log__4883bc1d" 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
);