Drought Impact Area On Ecosystems

Eurostat code: sdg_15_42 · (2000 - 2023)

@eurostat.sdg_15_42

Table List

2 tables(36.09 KB)

Drought Impact Area On Ecosystems - Unpivoted

Drought Impact Area On Ecosystems - Unpivoted

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

10.39 KB
1872 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Square kilometre	Albania	2000	2266
Annual	Square kilometre	Austria	2000	4671
Annual	Square kilometre	Bosnia and Herzegovina	2000	19178
Annual	Square kilometre	Belgium	2000
Annual	Square kilometre	Bulgaria	2000	56150
Annual	Square kilometre	Switzerland	2000
Annual	Square kilometre	Cyprus	2000	56
Annual	Square kilometre	Czechia	2000	7910
Annual	Square kilometre	Germany	2000	156
Annual	Square kilometre	Denmark	2000	104


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

Share link

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