Pigs: Number Of Farms And Heads By Size Of Farm (UAA) And Size Of Breeding Sow Herd

Eurostat code: ef_ls_gvsows · (1990 - 2007)

@eurostat.ef_ls_gvsows

Table List

2 tables(692.6 KB)

Pigs: Number Of Farms And Heads By Size Of Farm (UAA) And Size Of Breeding Sow Herd - Raw

Pigs: Number Of Farms And Heads By Size Of Farm (UAA) And Size Of Breeding Sow Herd - Unpivoted

Pigs: Number Of Farms And Heads By Size Of Farm (UAA) And Size Of Breeding Sow Herd - Unpivoted

@eurostat.ef_ls_gvsows.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.

329.47 KB
128862 rows
8 columns

freq Freq	agrarea Agrarea	n_head N Head	unit Unit	variable Variable	geo Geo	time_period Time Period	value Value
Annual	Zero ha	No heads	Head (animal)	Pigs - piglets under 20 kg	Belgium	1990	4190
Annual	Zero ha	No heads	Head (animal)	Pigs - piglets under 20 kg	Denmark	1990
Annual	Zero ha	No heads	Head (animal)	Pigs - piglets under 20 kg	Greece	1990	2060
Annual	Zero ha	No heads	Head (animal)	Pigs - piglets under 20 kg	Spain	1990	4440
Annual	Zero ha	No heads	Head (animal)	Pigs - piglets under 20 kg	Metropolitan France	1990	38530
Annual	Zero ha	No heads	Head (animal)	Pigs - piglets under 20 kg	Ireland	1990
Annual	Zero ha	No heads	Head (animal)	Pigs - piglets under 20 kg	Italy	1990	1960
Annual	Zero ha	No heads	Head (animal)	Pigs - piglets under 20 kg	Luxembourg	1990
Annual	Zero ha	No heads	Head (animal)	Pigs - piglets under 20 kg	Netherlands	1990	3030
Annual	Zero ha	No heads	Head (animal)	Pigs - piglets under 20 kg	Portugal	1990	780


CREATE TABLE tidy (
  "freq" VARCHAR,
  "agrarea" VARCHAR,
  "n_head" VARCHAR,
  "unit" VARCHAR,
  "variable" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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