Baselight

Livestock: Number Of Farms And Heads By Economic Size Of Farm (ESU) And NUTS 2 Region

Eurostat code: ef_ls_ovesu · (1990 - 2007)

@eurostat.ef_ls_ovesu

Livestock: Number Of Farms And Heads By Economic Size Of Farm (ESU) And NUTS 2 Region - Unpivoted
@eurostat.ef_ls_ovesu.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.

  • 1.63 MB
  • 757142 rows
  • 7 columns
freq

Freq

esu

Esu

unit

Unit

variable

Variable

geo

Geo

time_period

Time Period

value

Value

AnnualFrom 1 to 1.9 ESUHoldingNo. of holdingsBelgium19905730
AnnualFrom 1 to 1.9 ESUHoldingNo. of holdingsRégion de Bruxelles-Capitale/Brussels Hoofdstedelijk Gewest and Vlaams Gewest19903990
AnnualFrom 1 to 1.9 ESUHoldingNo. of holdingsRégion wallonne19901750
AnnualFrom 1 to 1.9 ESUHoldingNo. of holdingsDenmark1990480
AnnualFrom 1 to 1.9 ESUHoldingNo. of holdingsGreece1990150170
AnnualFrom 1 to 1.9 ESUHoldingNo. of holdingsAnatoliki Makedonia, Thraki (NUTS 2010)199010990
AnnualFrom 1 to 1.9 ESUHoldingNo. of holdingsKentriki Makedonia (NUTS 2010)199018730
AnnualFrom 1 to 1.9 ESUHoldingNo. of holdingsDytiki Makedonia (NUTS 2010)19907030
AnnualFrom 1 to 1.9 ESUHoldingNo. of holdingsThessalia (NUTS 2010)199013830
AnnualFrom 1 to 1.9 ESUHoldingNo. of holdingsIpeiros (NUTS 2010)199011010

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