Pigs: Number Of Farms And Heads By Agricultural Size Of Farm (UAA) And Size Of Pig Herd

Eurostat code: ef_lspigaa · (2005 - 2013)

@eurostat.ef_lspigaa

Table List

2 tables(558.02 KB)

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

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

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

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

263.21 KB
118718 rows
7 columns

freq Freq	n_head N Head	agrarea Agrarea	indic_ef Indic Ef	geo Geo	time_period Time Period
Annual	No heads	Zero ha	head: Pigs - piglets under 20 kg	Austria	2005
Annual	No heads	Zero ha	head: Pigs - piglets under 20 kg	Belgium	2005
Annual	No heads	Zero ha	head: Pigs - piglets under 20 kg	Bulgaria	2005
Annual	No heads	Zero ha	head: Pigs - piglets under 20 kg	Switzerland	2005
Annual	No heads	Zero ha	head: Pigs - piglets under 20 kg	Cyprus	2005
Annual	No heads	Zero ha	head: Pigs - piglets under 20 kg	Czechia	2005
Annual	No heads	Zero ha	head: Pigs - piglets under 20 kg	Germany	2005
Annual	No heads	Zero ha	head: Pigs - piglets under 20 kg	Denmark	2005
Annual	No heads	Zero ha	head: Pigs - piglets under 20 kg	Estonia	2005
Annual	No heads	Zero ha	head: Pigs - piglets under 20 kg	Greece	2005


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

Share link

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