Soil Cover By NUTS 2 Region

Eurostat code: ef_mp_soil · (2010 - 2016)

@eurostat.ef_mp_soil

Table List

2 tables(8.27 MB)

Soil Cover By NUTS 2 Region - Unpivoted

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

3.94 MB
2403627 rows
9 columns

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


CREATE TABLE tidy (
  "freq" VARCHAR,
  "crop_rot" VARCHAR,
  "soil_cov" 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.