Pigs: Number Of Farms And Heads By Economic Size Of Farm (SO In Euro) And Size Of Pig Herd

Eurostat code: ef_lspigecs · (2005 - 2013)

@eurostat.ef_lspigecs

Table List

2 tables(484.07 KB)

Pigs: Number Of Farms And Heads By Economic Size Of Farm (SO In Euro) And Size Of Pig Herd - Raw

Pigs: Number Of Farms And Heads By Economic Size Of Farm (SO In Euro) And Size Of Pig Herd - Unpivoted

Pigs: Number Of Farms And Heads By Economic Size Of Farm (SO In Euro) And Size Of Pig Herd - Unpivoted

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

228.61 KB
108380 rows
7 columns

freq Freq	n_head N Head	so_eur So Eur	indic_ef Indic Ef	geo Geo	time_period Time Period
Annual	No heads	Zero euros	head: Pigs - piglets under 20 kg	Austria	2005
Annual	No heads	Zero euros	head: Pigs - piglets under 20 kg	Belgium	2005
Annual	No heads	Zero euros	head: Pigs - piglets under 20 kg	Bulgaria	2005
Annual	No heads	Zero euros	head: Pigs - piglets under 20 kg	Cyprus	2005
Annual	No heads	Zero euros	head: Pigs - piglets under 20 kg	Czechia	2005
Annual	No heads	Zero euros	head: Pigs - piglets under 20 kg	Germany	2005
Annual	No heads	Zero euros	head: Pigs - piglets under 20 kg	Denmark	2005
Annual	No heads	Zero euros	head: Pigs - piglets under 20 kg	Estonia	2005
Annual	No heads	Zero euros	head: Pigs - piglets under 20 kg	Greece	2005
Annual	No heads	Zero euros	head: Pigs - piglets under 20 kg	Spain	2005


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

Share link

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