Baselight
Sign In

Main Farm Land Use By NUTS 2 Region

Eurostat code: ef_lus_main ยท (2005 - 2020)

@eurostat.ef_lus_main

Main Farm Land Use By NUTS 2 Region - Unpivoted
@eurostat.ef_lus_main.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.

  • 45.67 MB
  • 26564866 rows
  • 9 columns
freq

Freq

crops

Crops

farmtype

Farmtype

so_eur

So Eur

unit

Unit

agrarea

Agrarea

geo

Geo

time_period

Time Period

value

Value

AnnualArable landSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosHectareFrom 20 to 29.9 haEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)200530
AnnualArable landSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosHectareFrom 20 to 29.9 haEuropean Union - 27 countries (2007-2013)200530
AnnualArable landSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosHectareFrom 20 to 29.9 haEuropean Union - 28 countries (2013-2020)200530
AnnualArable landSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosHectareFrom 30 to 49.9 haGermany20053770
AnnualArable landSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosHectareFrom 30 to 49.9 haKoblenz20053130
AnnualArable landSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosHectareFrom 30 to 49.9 haEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)20053770
AnnualArable landSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosHectareFrom 30 to 49.9 haEuropean Union - 27 countries (2007-2013)20053770
AnnualArable landSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosHectareFrom 30 to 49.9 haEuropean Union - 28 countries (2013-2020)20053770
AnnualArable landSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosHectareFrom 50 to 99.9 haGermany200535180
AnnualArable landSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosHectareFrom 50 to 99.9 haBrandenburg - Nordost (NUTS 2006)20052920

CREATE TABLE tidy (
  "freq" VARCHAR,
  "crops" VARCHAR,
  "farmtype" VARCHAR,
  "so_eur" VARCHAR,
  "unit" VARCHAR,
  "agrarea" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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