Baselight
Sign In

Area Under Organic Farming

Eurostat code: sdg_02_40 ยท (2000 - 2022)

@eurostat.sdg_02_40

Area Under Organic Farming - Unpivoted
@eurostat.sdg_02_40.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.

  • 9.49 KB
  • 688 rows
  • 7 columns
freq

Freq

unit

Unit

crops

Crops

agprdmet

Agprdmet

geo

Geo

time_period

Time Period

value

Value

AnnualPercentage of total utilised agricultural areaUtilised agricultural area excluding kitchen gardensTotal fully converted and under conversion to organic farmingAustria200013.8
AnnualPercentage of total utilised agricultural areaUtilised agricultural area excluding kitchen gardensTotal fully converted and under conversion to organic farmingBelgium20001.5
AnnualPercentage of total utilised agricultural areaUtilised agricultural area excluding kitchen gardensTotal fully converted and under conversion to organic farmingGermany20003.2
AnnualPercentage of total utilised agricultural areaUtilised agricultural area excluding kitchen gardensTotal fully converted and under conversion to organic farmingDenmark20005.9
AnnualPercentage of total utilised agricultural areaUtilised agricultural area excluding kitchen gardensTotal fully converted and under conversion to organic farmingGreece20000.7
AnnualPercentage of total utilised agricultural areaUtilised agricultural area excluding kitchen gardensTotal fully converted and under conversion to organic farmingSpain20001.5
AnnualPercentage of total utilised agricultural areaUtilised agricultural area excluding kitchen gardensTotal fully converted and under conversion to organic farmingEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)20003
AnnualPercentage of total utilised agricultural areaUtilised agricultural area excluding kitchen gardensTotal fully converted and under conversion to organic farmingFinland20006.7
AnnualPercentage of total utilised agricultural areaUtilised agricultural area excluding kitchen gardensTotal fully converted and under conversion to organic farmingFrance20001.2
AnnualPercentage of total utilised agricultural areaUtilised agricultural area excluding kitchen gardensTotal fully converted and under conversion to organic farmingIreland20000.6

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

Share link

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