Agricultural Practices

Eurostat code: ef_mp_prac · (2010 - 2016)

@eurostat.ef_mp_prac

Table List

2 tables(5.93 MB)

Agricultural Practices - Unpivoted

@eurostat.ef_mp_prac.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.

2.84 MB
1700976 rows
9 columns

freq Freq	crop_rot Crop Rot	tillage Tillage	farmtype Farmtype	agrarea Agrarea	unit Unit	geo Geo	time_period Time Period
Annual	Not applicable	Conservational tillage	General field cropping (calculated with Standard Output)	From 10 to 19.9 ha	Hectare	Belgium	2010
Annual	Not applicable	Conservational tillage	General field cropping (calculated with Standard Output)	From 10 to 19.9 ha	Hectare	Prov. Limburg (BE)	2010
Annual	Not applicable	Conservational tillage	General field cropping (calculated with Standard Output)	From 10 to 19.9 ha	Hectare	Stuttgart	2010
Annual	Not applicable	Conservational tillage	General field cropping (calculated with Standard Output)	From 10 to 19.9 ha	Hectare	Freiburg	2010
Annual	Not applicable	Conservational tillage	General field cropping (calculated with Standard Output)	From 10 to 19.9 ha	Hectare	Tübingen	2010
Annual	Not applicable	Conservational tillage	General field cropping (calculated with Standard Output)	From 10 to 19.9 ha	Hectare	Oberbayern	2010
Annual	Not applicable	Conservational tillage	General field cropping (calculated with Standard Output)	From 10 to 19.9 ha	Hectare	Niederbayern	2010
Annual	Not applicable	Conservational tillage	General field cropping (calculated with Standard Output)	From 10 to 19.9 ha	Hectare	Oberpfalz	2010
Annual	Not applicable	Conservational tillage	General field cropping (calculated with Standard Output)	From 10 to 19.9 ha	Hectare	Mittelfranken	2010
Annual	Not applicable	Conservational tillage	General field cropping (calculated with Standard Output)	From 10 to 19.9 ha	Hectare	Unterfranken	2010


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

Share link

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