Baselight

Main Farm Indicators By Organic Farming, Utilised Agricultural Area, Economic Size, Farm Type Of Agricultural Holding And NUTS 2

Eurostat code: ef_m_org ยท (2010 - 2020)

@eurostat.ef_m_org

Main Farm Indicators By Organic Farming, Utilised Agricultural Area, Economic Size, Farm Type Of Agricultural Holding And NUTS 2 - Unpivoted
@eurostat.ef_m_org.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.

  • 25.32 MB
  • 7990539 rows
  • 9 columns
freq

Freq

farmtype

Farmtype

so_eur

So Eur

uaarea

Uaarea

organic

Organic

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosFrom 30 to 49.9 haNon-organic farmingAnnual working unit (AWU)Spain201020
AnnualSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosFrom 30 to 49.9 haNon-organic farmingAnnual working unit (AWU)Comunitat Valenciana201010
AnnualSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosFrom 30 to 49.9 haNon-organic farmingAnnual working unit (AWU)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)2010180
AnnualSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosFrom 30 to 49.9 haNon-organic farmingAnnual working unit (AWU)European Union - 27 countries (2007-2013)2010180
AnnualSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosFrom 30 to 49.9 haNon-organic farmingAnnual working unit (AWU)European Union - 27 countries (from 2020)2010180
AnnualSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosFrom 30 to 49.9 haNon-organic farmingAnnual working unit (AWU)European Union - 28 countries (2013-2020)2010180
AnnualSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosFrom 30 to 49.9 haNon-organic farmingAnnual working unit (AWU)Italy2010160
AnnualSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosFrom 30 to 49.9 haNon-organic farmingAnnual working unit (AWU)Piemonte2010110
AnnualSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosFrom 30 to 49.9 haNon-organic farmingAnnual working unit (AWU)Lombardia201040
AnnualSpecialist cereals, oilseed and protein crops (calculated with Standard Output)From 100 000 to 249 999 eurosFrom 30 to 49.9 haNon-organic farmingEuroSpain2010846970

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

Share link

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