Surface Of The Terrestrial Protected Areas

Eurostat code: sdg_15_20 · (2011 - 2022)

@eurostat.sdg_15_20

Table List

2 tables(17.78 KB)

Surface Of The Terrestrial Protected Areas - Raw

Surface Of The Terrestrial Protected Areas - Unpivoted

Surface Of The Terrestrial Protected Areas - Unpivoted

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

5.76 KB
132 rows
6 columns

freq Freq	areaprot Areaprot	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Terrestrial protected area	Square kilometre	European Union - 27 countries (from 2020)	2011	1003558
Annual	Terrestrial protected area	Percentage	European Union - 27 countries (from 2020)	2011	24.3
Annual	Terrestrial protected area	Square kilometre	European Union - 27 countries (from 2020)	2012	1020306
Annual	Terrestrial protected area	Percentage	European Union - 27 countries (from 2020)	2012	24.7
Annual	Terrestrial protected area	Square kilometre	European Union - 27 countries (from 2020)	2013	1027027
Annual	Terrestrial protected area	Percentage	European Union - 27 countries (from 2020)	2013	24.8
Annual	Terrestrial protected area	Square kilometre	European Union - 27 countries (from 2020)	2014	1032320
Annual	Terrestrial protected area	Percentage	European Union - 27 countries (from 2020)	2014	25
Annual	Terrestrial protected area	Square kilometre	European Union - 27 countries (from 2020)	2015	1037902
Annual	Terrestrial protected area	Percentage	European Union - 27 countries (from 2020)	2015	25.1


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

Share link

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