Surface Of The Marine Protected Areas

Eurostat code: sdg_14_10 · (2012 - 2022)

@eurostat.sdg_14_10

Table List

2 tables(14.23 KB)

Surface Of The Marine Protected Areas - Raw

Surface Of The Marine Protected Areas - Unpivoted

Surface Of The Marine Protected Areas - Unpivoted

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

6.05 KB
230 rows
6 columns

freq Freq	areaprot Areaprot	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Marine protected area	Square kilometre	Belgium	2012	1273
Annual	Marine protected area	Square kilometre	Bulgaria	2012	995
Annual	Marine protected area	Square kilometre	Cyprus	2012	131
Annual	Marine protected area	Square kilometre	Germany	2012	25641
Annual	Marine protected area	Square kilometre	Denmark	2012	19087
Annual	Marine protected area	Square kilometre	Estonia	2012	6759
Annual	Marine protected area	Square kilometre	Greece	2012	7414
Annual	Marine protected area	Square kilometre	Spain	2012	11489
Annual	Marine protected area	Square kilometre	European Union - 27 countries (from 2020)	2012	216972
Annual	Marine protected area	Square kilometre	Finland	2012	8153


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.