About this Dataset

Pig Conditions

Pig condition data collected by Food Standards Agency staff at approved meat establishments as a percentage of pig throughput. The data is aggregated to country level and is shown by month. Pig throughput data currently represents 50% of total throughput and will be updated as throughput data from remaining approved establishments becomes available.
Publisher name: Food Standards Agency
Last updated: 2022-07-01T04:02:41Z

Tables

Pig Conditions

@ukgov.pig_conditions.pig_conditions

10.89 kB
244 rows
9 columns

CREATE TABLE pig_conditions (
  "species" VARCHAR,
  "inspectiontype" VARCHAR,
  "condition" VARCHAR,
  "yearmonth" TIMESTAMP,
  "country" VARCHAR,
  "numberofconditions" BIGINT,
  "throughput" BIGINT,
  "numberofthroughputplants" BIGINT,
  "percentageofthroughput" DOUBLE
);

Pig Conditions Apr19-Jun19

@ukgov.pig_conditions.pig_conditions_apr19_jun19

11 kB
252 rows
9 columns

CREATE TABLE pig_conditions_apr19_jun19 (
  "species" VARCHAR,
  "inspectiontype" VARCHAR,
  "condition" VARCHAR,
  "yearmonth" TIMESTAMP,
  "country" VARCHAR,
  "numberofconditions" BIGINT,
  "throughput" BIGINT,
  "numberofthroughputplants" BIGINT,
  "percentageofthroughput" DOUBLE
);

Pig Conditions Apr 20 - Jun 20

@ukgov.pig_conditions.pig_conditions_apr_20_jun_20

10.92 kB
259 rows
9 columns

CREATE TABLE pig_conditions_apr_20_jun_20 (
  "species" VARCHAR,
  "inspectiontype" VARCHAR,
  "condition" VARCHAR,
  "yearmonth" TIMESTAMP,
  "country" VARCHAR,
  "numberofconditions" BIGINT,
  "throughput" BIGINT,
  "numberofthroughputplants" BIGINT,
  "percentageofthroughput" DOUBLE
);

Pig Conditions Jan 19 - Mar 19

@ukgov.pig_conditions.pig_conditions_jan_19_mar_19

10.97 kB
245 rows
9 columns

CREATE TABLE pig_conditions_jan_19_mar_19 (
  "species" VARCHAR,
  "inspectiontype" VARCHAR,
  "condition" VARCHAR,
  "yearmonth" TIMESTAMP,
  "country" VARCHAR,
  "numberofconditions" BIGINT,
  "throughput" BIGINT,
  "numberofthroughputplants" BIGINT,
  "percentageofthroughput" DOUBLE
);

Pig Conditions Jan 20 - Mar 20

@ukgov.pig_conditions.pig_conditions_jan_20_mar_20

10.97 kB
263 rows
9 columns

CREATE TABLE pig_conditions_jan_20_mar_20 (
  "species" VARCHAR,
  "inspectiontype" VARCHAR,
  "condition" VARCHAR,
  "yearmonth" TIMESTAMP,
  "country" VARCHAR,
  "numberofconditions" BIGINT,
  "throughput" BIGINT,
  "numberofthroughputplants" BIGINT,
  "percentageofthroughput" DOUBLE
);

Pig Conditions Jul19-Sep19

@ukgov.pig_conditions.pig_conditions_jul19_sep19

10.91 kB
238 rows
9 columns

CREATE TABLE pig_conditions_jul19_sep19 (
  "species" VARCHAR,
  "inspectiontype" VARCHAR,
  "condition" VARCHAR,
  "yearmonth" TIMESTAMP,
  "country" VARCHAR,
  "numberofconditions" BIGINT,
  "throughput" BIGINT,
  "numberofthroughputplants" BIGINT,
  "percentageofthroughput" DOUBLE
);

Pig Conditions Jul 20 - Sep 20

@ukgov.pig_conditions.pig_conditions_jul_20_sep_20

11.17 kB
277 rows
9 columns

CREATE TABLE pig_conditions_jul_20_sep_20 (
  "species" VARCHAR,
  "inspectiontype" VARCHAR,
  "condition" VARCHAR,
  "yearmonth" TIMESTAMP,
  "country" VARCHAR,
  "numberofconditions" BIGINT,
  "throughput" BIGINT,
  "numberofthroughputplants" BIGINT,
  "percentageofthroughput" DOUBLE
);

Pig Conditions Oct18-Dec18

@ukgov.pig_conditions.pig_conditions_oct18_dec18

10.82 kB
241 rows
9 columns

CREATE TABLE pig_conditions_oct18_dec18 (
  "species" VARCHAR,
  "inspectiontype" VARCHAR,
  "condition" VARCHAR,
  "yearmonth" TIMESTAMP,
  "country" VARCHAR,
  "numberofconditions" BIGINT,
  "throughput" BIGINT,
  "numberofthroughputplants" BIGINT,
  "percentageofthroughput" DOUBLE
);

Pig Conditions Oct 19 - Dec 19

@ukgov.pig_conditions.pig_conditions_oct_19_dec_19

11.01 kB
267 rows
9 columns

CREATE TABLE pig_conditions_oct_19_dec_19 (
  "species" VARCHAR,
  "inspectiontype" VARCHAR,
  "condition" VARCHAR,
  "yearmonth" TIMESTAMP,
  "country" VARCHAR,
  "numberofconditions" BIGINT,
  "throughput" BIGINT,
  "numberofthroughputplants" BIGINT,
  "percentageofthroughput" DOUBLE
);

Pig Conditions Oct 20 - Dec 20

@ukgov.pig_conditions.pig_conditions_oct_20_dec_20

11.01 kB
261 rows
9 columns

CREATE TABLE pig_conditions_oct_20_dec_20 (
  "species" VARCHAR,
  "inspectiontype" VARCHAR,
  "condition" VARCHAR,
  "yearmonth" TIMESTAMP,
  "country" VARCHAR,
  "numberofconditions" BIGINT,
  "throughput" BIGINT,
  "numberofthroughputplants" BIGINT,
  "percentageofthroughput" DOUBLE
);