Cattle Conditions

Food Standards Agency

@ukgov.cattle_conditions

Table List

10 tables(123.41 KB)

Cattle Conditions

Cattle Conditions Jan 20 - Mar 20

Cattle Conditions Oct 18 - Dec 18

Cattle Conditions Jul 20 - Sep 20

Cattle Conditions Oct 20 - Dec 20

Cattle Conditions Oct 19 - Dec 19

Cattle Conditions Jan 19 -Mar 19

Cattle Conditions Apr 20 - Jun 20

Cattle Conditions Jul 19 - Sep 19

Cattle Conditions Apr 19 - Jun 19

Cattle Conditions

@ukgov.cattle_conditions.cattle_conditions

Cattle Conditions Apr17-Jun17

12.36 KB
450 rows
9 columns

species Species	inspectiontype InspectionType	condition Condition	yearmonth YearMonth	country Country	numberofconditions NumberOfConditions	throughput Throughput	numberofthroughputplants NumberOfThroughputPlants	percentageofthroughput PercentageOfThroughput
Bison	AM	Emergency Slaughter on Farm	Thu Jun 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	England	1	1	1	100
Bison	Offal	Hepatic Scarring	Thu Jun 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	England	1	1	1	100
Buffalo	Carcases	Abscesses ? Forequarters	Mon May 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	England	1	31	4	3.226
Buffalo	Offal	Contamination	Sat Apr 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	England	4	34	3	11.765
Buffalo	Offal	Contamination	Mon May 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	England	6	31	4	19.355
Buffalo	Offal	Contamination	Thu Jun 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	England	4	30	3	13.333
Buffalo	Offal	Fluke Mature	Mon May 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	England	2	31	4	6.452
Buffalo	Offal	Fluke Mature	Mon May 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wales	1	1	1	100
Buffalo	Offal	Hepatic Scarring	Sat Apr 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	England	1	34	3	2.941
Buffalo	Offal	Hepatic Scarring	Thu Jun 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wales	1	1	1	100


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

Share link

Anyone who has the link will be able to view this.