Baselight

Farmland: Number Of Farms And Areas By Economic Size Of Farm (ESU) And NUTS 2 Region

Eurostat code: ef_lu_ovcropesu · (1990 - 2007)

@eurostat.ef_lu_ovcropesu

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

  • 3.04 MB
  • 1959788 rows
  • 7 columns
freq

Freq

esu

Esu

variable

Variable

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFrom 1 to 1.9 ESUUtilised agricultural areaHectareBelgium199012500
AnnualFrom 1 to 1.9 ESUUtilised agricultural areaHectareRégion de Bruxelles-Capitale/Brussels Hoofdstedelijk Gewest and Vlaams Gewest19907770
AnnualFrom 1 to 1.9 ESUUtilised agricultural areaHectareRégion wallonne19904730
AnnualFrom 1 to 1.9 ESUUtilised agricultural areaHectareDenmark19903300
AnnualFrom 1 to 1.9 ESUUtilised agricultural areaHectareGreece1990288050
AnnualFrom 1 to 1.9 ESUUtilised agricultural areaHectareAnatoliki Makedonia, Thraki (NUTS 2010)199026900
AnnualFrom 1 to 1.9 ESUUtilised agricultural areaHectareKentriki Makedonia (NUTS 2010)199043560
AnnualFrom 1 to 1.9 ESUUtilised agricultural areaHectareDytiki Makedonia (NUTS 2010)199026230
AnnualFrom 1 to 1.9 ESUUtilised agricultural areaHectareThessalia (NUTS 2010)199025630
AnnualFrom 1 to 1.9 ESUUtilised agricultural areaHectareIpeiros (NUTS 2010)199017580

CREATE TABLE tidy (
  "freq" VARCHAR,
  "esu" VARCHAR,
  "variable" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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