Poultry: Number Of Farms And Heads By Size Of Farm (UAA) And Size Of Laying Hen Flock

Eurostat code: ef_ls_gvlayhen · (1990 - 2007)

@eurostat.ef_ls_gvlayhen

Table List

2 tables(372.22 KB)

Poultry: Number Of Farms And Heads By Size Of Farm (UAA) And Size Of Laying Hen Flock - Raw

Poultry: Number Of Farms And Heads By Size Of Farm (UAA) And Size Of Laying Hen Flock - Unpivoted

Poultry: Number Of Farms And Heads By Size Of Farm (UAA) And Size Of Laying Hen Flock - Unpivoted

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

176.97 KB
106661 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	Holding	Livestock	Belgium	1990	1160
Annual	Zero ha	No heads	Holding	Livestock	Denmark	1990	110
Annual	Zero ha	No heads	Holding	Livestock	Greece	1990	5030
Annual	Zero ha	No heads	Holding	Livestock	Spain	1990	17090
Annual	Zero ha	No heads	Holding	Livestock	Metropolitan France	1990	2670
Annual	Zero ha	No heads	Holding	Livestock	Ireland	1990	210
Annual	Zero ha	No heads	Holding	Livestock	Italy	1990	4610
Annual	Zero ha	No heads	Holding	Livestock	Luxembourg	1990
Annual	Zero ha	No heads	Holding	Livestock	Netherlands	1990	1830
Annual	Zero ha	No heads	Holding	Livestock	Portugal	1990	2570


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.