Baselight
Sign In

Farm Indicators By Legal Status Of The Holding, Utilised Agricultural Area, Type And Economic Size Of The Farm And NUTS 2 Region

Eurostat code: ef_m_farmleg ยท (2010 - 2020)

@eurostat.ef_m_farmleg

Farm Indicators By Legal Status Of The Holding, Utilised Agricultural Area, Type And Economic Size Of The Farm And NUTS 2 Region - Unpivoted
@eurostat.ef_m_farmleg.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.

  • 26.11 MB
  • 7737078 rows
  • 10 columns
freq

Freq

leg_form

Leg Form

farmtype

Farmtype

so_eur

So Eur

crops

Crops

uaarea

Uaarea

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualGroup holdingSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosUtilised agricultural areaFrom 50 to 99.9 haAnnual working unit (AWU)Germany201030
AnnualGroup holdingSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosUtilised agricultural areaFrom 50 to 99.9 haAnnual working unit (AWU)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)201070
AnnualGroup holdingSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosUtilised agricultural areaFrom 50 to 99.9 haAnnual working unit (AWU)European Union - 27 countries (2007-2013)201070
AnnualGroup holdingSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosUtilised agricultural areaFrom 50 to 99.9 haAnnual working unit (AWU)European Union - 27 countries (from 2020)201070
AnnualGroup holdingSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosUtilised agricultural areaFrom 50 to 99.9 haAnnual working unit (AWU)European Union - 28 countries (2013-2020)201070
AnnualGroup holdingSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosUtilised agricultural areaFrom 50 to 99.9 haAnnual working unit (AWU)France201030
AnnualGroup holdingSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosUtilised agricultural areaFrom 50 to 99.9 haEuroGermany20102134960
AnnualGroup holdingSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosUtilised agricultural areaFrom 50 to 99.9 haEuroEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)20103801930
AnnualGroup holdingSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosUtilised agricultural areaFrom 50 to 99.9 haEuroEuropean Union - 27 countries (2007-2013)20103801930
AnnualGroup holdingSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosUtilised agricultural areaFrom 50 to 99.9 haEuroEuropean Union - 27 countries (from 2020)20103801930

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

Share link

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