About this Dataset

Enforcement Data - Enforcement Reports

Volumes of formal enforcement undertaken by the Food Standards Agency. This is shown as the number of breaches against each piece of legislation by Month.
Publisher name: Food Standards Agency
Last updated: 2022-07-01T04:04:27Z

Tables

Enforcement Data - 2018

@ukgov.enforcement_data_enforcement_reports.enforcement_data_2018

13.09 kB
12 rows
17 columns

CREATE TABLE enforcement_data_2018 (
  "dateserved" TIMESTAMP,
  "id852_2004" BIGINT,
  "id1099_2009" BIGINT,
  "id853_2004" BIGINT,
  "id2996_2013" BIGINT,
  "id1069_2009" BIGINT,
  "id999_2001" BIGINT,
  "id2952_2013" BIGINT,
  "id142_2011" BIGINT,
  "id178_2002" BIGINT,
  "id1724_2003" BIGINT,
  "id2073_2005" BIGINT,
  "id854_2004" BIGINT,
  "id931_2011" BIGINT,
  "id1774_2002" BIGINT,
  "id882_2004" BIGINT,
  "id2075_2005" BIGINT
);

Enforcement Data - Enforcement Reports

@ukgov.enforcement_data_enforcement_reports.enforcement_data_enforcement_reports

13.1 kB
12 rows
17 columns

CREATE TABLE enforcement_data_enforcement_reports (
  "dateserved" TIMESTAMP,
  "n_852_2004" BIGINT  -- 852-2004,
  "n_1099_2009" BIGINT  -- 1099-2009,
  "n_853_2004" BIGINT  -- 853-2004,
  "n_2996_2013" BIGINT  -- 2996-2013,
  "n_1069_2009" BIGINT  -- 1069-2009,
  "n_999_2001" BIGINT  -- 999-2001,
  "n_2952_2013" BIGINT  -- 2952-2013,
  "n_142_2011" BIGINT  -- 142-2011,
  "n_178_2002" BIGINT  -- 178-2002,
  "n_1724_2003" BIGINT  -- 1724-2003,
  "n_2073_2005" BIGINT  -- 2073-2005,
  "n_854_2004" BIGINT  -- 854-2004,
  "n_931_2011" BIGINT  -- 931-2011,
  "n_1774_2002" BIGINT  -- 1774-2002,
  "n_882_2004" BIGINT  -- 882-2004,
  "n_2075_2005" BIGINT  -- 2075-2005
);