Baselight

Area At Risk Of Severe Soil Erosion By Water

Eurostat code: sdg_15_50 ยท (2000 - 2016)

@eurostat.sdg_15_50

Area At Risk Of Severe Soil Erosion By Water - Unpivoted
@eurostat.sdg_15_50.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.

  • 7.39 KB
  • 180 rows
  • 7 columns
freq

Freq

levels

Levels

clc18

Clc18

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualSevereAgricultural areas, forest and semi natural areas (excluding beaches, dunes, sand plains, bare rock and glaciers and perpetual snow)Square kilometreAustria200011635.2
AnnualSevereAgricultural areas, forest and semi natural areas (excluding beaches, dunes, sand plains, bare rock and glaciers and perpetual snow)Square kilometreBelgium2000168.2
AnnualSevereAgricultural areas, forest and semi natural areas (excluding beaches, dunes, sand plains, bare rock and glaciers and perpetual snow)Square kilometreBulgaria20005009.4
AnnualSevereAgricultural areas, forest and semi natural areas (excluding beaches, dunes, sand plains, bare rock and glaciers and perpetual snow)Square kilometreCyprus2000707.2
AnnualSevereAgricultural areas, forest and semi natural areas (excluding beaches, dunes, sand plains, bare rock and glaciers and perpetual snow)Square kilometreCzechia20002018.6
AnnualSevereAgricultural areas, forest and semi natural areas (excluding beaches, dunes, sand plains, bare rock and glaciers and perpetual snow)Square kilometreGermany20007895
AnnualSevereAgricultural areas, forest and semi natural areas (excluding beaches, dunes, sand plains, bare rock and glaciers and perpetual snow)Square kilometreDenmark20002.8
AnnualSevereAgricultural areas, forest and semi natural areas (excluding beaches, dunes, sand plains, bare rock and glaciers and perpetual snow)Square kilometreEstonia20003.1
AnnualSevereAgricultural areas, forest and semi natural areas (excluding beaches, dunes, sand plains, bare rock and glaciers and perpetual snow)Square kilometreGreece200013449.8
AnnualSevereAgricultural areas, forest and semi natural areas (excluding beaches, dunes, sand plains, bare rock and glaciers and perpetual snow)Square kilometreSpain200052651.8

CREATE TABLE tidy (
  "freq" VARCHAR,
  "levels" VARCHAR,
  "clc18" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);