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.64 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

10.74 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.66 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.71 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.72 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.65 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

10.91 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.57 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

10.75 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

10.75 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
);