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

Eurostat code: ef_lssowsaa · (2005 - 2013)

@eurostat.ef_lssowsaa

Table List

2 tables(563.97 KB)

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

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

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

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

261.34 KB
114933 rows
7 columns

freq Freq	n_head N Head	agrarea Agrarea	indic_ef Indic Ef	geo Geo	time_period Time Period	value Value
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	17280
Annual	No heads	Zero ha	head: Pigs - piglets under 20 kg	Bulgaria	2005	5400
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	1450
Annual	No heads	Zero ha	head: Pigs - piglets under 20 kg	Germany	2005	72580
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	1560


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.