Protected Forests

Eurostat code: for_protect · (1990 - 2015)

@eurostat.for_protect

Table List

2 tables(19.62 KB)

Protected Forests - Unpivoted

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

8.77 KB
709 rows
7 columns

freq Freq	unit Unit	indic_fo Indic Fo	areaprot Areaprot	geo Geo	time_period Time Period	value Value
Annual	Thousand hectares	Forest	Protected area	Bulgaria	1990	131
Annual	Thousand hectares	Forest	Protected area	Cyprus	1990	3.06
Annual	Thousand hectares	Forest	Protected area	Denmark	1990	0.57
Annual	Thousand hectares	Forest	Protected area	Estonia	1990
Annual	Thousand hectares	Forest	Protected area	Greece	1990	139
Annual	Thousand hectares	Forest	Protected area	Spain	1990	1341.76
Annual	Thousand hectares	Forest	Protected area	European Union - 27 countries (from 2020)	1990	3025.37
Annual	Thousand hectares	Forest	Protected area	European Union - 28 countries (2013-2020)	1990	3025.37
Annual	Thousand hectares	Forest	Protected area	Croatia	1990	164
Annual	Thousand hectares	Forest	Protected area	Hungary	1990	316.21


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

Share link

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