Pig Types By Utilised Agricultural Area, Size Classes Of Livestock And NUTS 2 Region

Eurostat code: ef_lsk_pigs · (2010 - 2020)

@eurostat.ef_lsk_pigs

Table List

2 tables(3.93 MB)

Pig Types By Utilised Agricultural Area, Size Classes Of Livestock And NUTS 2 Region - Raw

Pig Types By Utilised Agricultural Area, Size Classes Of Livestock And NUTS 2 Region - Unpivoted

Pig Types By Utilised Agricultural Area, Size Classes Of Livestock And NUTS 2 Region - Unpivoted

@eurostat.ef_lsk_pigs.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

2.12 MB
1101029 rows
8 columns

freq Freq	lsu Lsu	uaarea Uaarea	animals Animals	unit Unit	geo Geo	time_period Time Period
Annual	Zero LSU	Zero ha	Live swine, domestic species	Head (animal)	Belgium	2010
Annual	Zero LSU	Zero ha	Live swine, domestic species	Head (animal)	Prov. Antwerpen	2010
Annual	Zero LSU	Zero ha	Live swine, domestic species	Head (animal)	Prov. Limburg (BE)	2010
Annual	Zero LSU	Zero ha	Live swine, domestic species	Head (animal)	Prov. Oost-Vlaanderen	2010
Annual	Zero LSU	Zero ha	Live swine, domestic species	Head (animal)	Prov. Vlaams-Brabant	2010
Annual	Zero LSU	Zero ha	Live swine, domestic species	Head (animal)	Prov. West-Vlaanderen	2010
Annual	Zero LSU	Zero ha	Live swine, domestic species	Head (animal)	Prov. Brabant wallon	2010
Annual	Zero LSU	Zero ha	Live swine, domestic species	Head (animal)	Prov. Hainaut	2010
Annual	Zero LSU	Zero ha	Live swine, domestic species	Head (animal)	Prov. Liège	2010
Annual	Zero LSU	Zero ha	Live swine, domestic species	Head (animal)	Prov. Luxembourg (BE)	2010


CREATE TABLE tidy (
  "freq" VARCHAR,
  "lsu" VARCHAR,
  "uaarea" VARCHAR,
  "animals" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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