Cattle: Number Of Farms And Heads By Size Of Farm (UAA) And Livestock Units (LSU) Of Farm

Eurostat code: ef_ls_gzcatllsu · (1990 - 2007)

@eurostat.ef_ls_gzcatllsu

Table List

2 tables(1.26 MB)

Cattle: Number Of Farms And Heads By Size Of Farm (UAA) And Livestock Units (LSU) Of Farm - Raw

Cattle: Number Of Farms And Heads By Size Of Farm (UAA) And Livestock Units (LSU) Of Farm - Unpivoted

Cattle: Number Of Farms And Heads By Size Of Farm (UAA) And Livestock Units (LSU) Of Farm - Unpivoted

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

616.94 KB
307346 rows
8 columns

freq Freq	agrarea Agrarea	lsu Lsu	unit Unit	variable Variable	geo Geo	time_period Time Period
Annual	Zero ha	Zero LSU	Holding	Fodder crops and grass	Belgium	1990
Annual	Zero ha	Zero LSU	Holding	Fodder crops and grass	Denmark	1990
Annual	Zero ha	Zero LSU	Holding	Fodder crops and grass	Greece	1990
Annual	Zero ha	Zero LSU	Holding	Fodder crops and grass	Metropolitan France	1990
Annual	Zero ha	Zero LSU	Holding	Fodder crops and grass	Ireland	1990
Annual	Zero ha	Zero LSU	Holding	Fodder crops and grass	Italy	1990
Annual	Zero ha	Zero LSU	Holding	Fodder crops and grass	Luxembourg	1990
Annual	Zero ha	Zero LSU	Holding	Fodder crops and grass	Netherlands	1990
Annual	Zero ha	Zero LSU	Holding	Fodder crops and grass	Portugal	1990
Annual	Zero ha	Zero LSU	Holding	Fodder crops and grass	United Kingdom	1990


CREATE TABLE tidy (
  "freq" VARCHAR,
  "agrarea" VARCHAR,
  "lsu" 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.