Bathing Sites With Excellent Water Quality By Location

Eurostat code: sdg_14_40 · (2011 - 2023)

@eurostat.sdg_14_40

Table List

2 tables(32.9 KB)

Bathing Sites With Excellent Water Quality By Location - Raw

Bathing Sites With Excellent Water Quality By Location - Unpivoted

Bathing Sites With Excellent Water Quality By Location - Unpivoted

@eurostat.sdg_14_40.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.99 KB
1998 rows
5 columns

freq Freq	aquaenv Aquaenv	geo Geo	time_period Time Period	value Value
Annual	Coastal water excellent - number	Belgium	2011	17
Annual	Coastal water excellent - number	Bulgaria	2011	45
Annual	Coastal water excellent - number	Cyprus	2011	111
Annual	Coastal water excellent - number	Germany	2011	280
Annual	Coastal water excellent - number	Denmark	2011	657
Annual	Coastal water excellent - number	Estonia	2011	13
Annual	Coastal water excellent - number	Greece	2011	2035
Annual	Coastal water excellent - number	Spain	2011	1633
Annual	Coastal water excellent - number	European Union - 27 countries (from 2020)	2011	12042
Annual	Coastal water excellent - number	Finland	2011	59


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

Share link

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