Marine Waters Affected By Eutrophication

Eurostat code: sdg_14_60 · (2000 - 2023)

@eurostat.sdg_14_60

Table List

2 tables(30.06 KB)

Marine Waters Affected By Eutrophication - Raw

Marine Waters Affected By Eutrophication - Unpivoted

Marine Waters Affected By Eutrophication - Unpivoted

@eurostat.sdg_14_60.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.71 KB
1104 rows
6 columns

freq Freq	indic_env Indic Env	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Marine area affected by eutrophication	Square kilometre	Belgium	2000
Annual	Marine area affected by eutrophication	Square kilometre	Bulgaria	2000	21
Annual	Marine area affected by eutrophication	Square kilometre	Cyprus	2000	108
Annual	Marine area affected by eutrophication	Square kilometre	Germany	2000	130
Annual	Marine area affected by eutrophication	Square kilometre	Denmark	2000	5552
Annual	Marine area affected by eutrophication	Square kilometre	Estonia	2000	88
Annual	Marine area affected by eutrophication	Square kilometre	Greece	2000	773
Annual	Marine area affected by eutrophication	Square kilometre	Spain	2000	4846
Annual	Marine area affected by eutrophication	Square kilometre	European Union (aggregate changing according to the context)	2000	21056
Annual	Marine area affected by eutrophication	Square kilometre	Finland	2000	255


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

Share link

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