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 - Raw

@eurostat.sdg_14_40.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

21.91 KB
186 rows
16 columns

freq Freq	aquaenv Aquaenv	geo Geo	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023
Annual	Coastal water excellent - number	Albania			37	26	25	34	56	67	67	88	80	79	47
Annual	Coastal water excellent - number	Austria
Annual	Coastal water excellent - number	Belgium	17	22	20	29	32	38	40	41	41	39	38	35	27
Annual	Coastal water excellent - number	Bulgaria	45	55	59	65	63	57	41	49	61	58	82	85	87
Annual	Coastal water excellent - number	Switzerland
Annual	Coastal water excellent - number	Cyprus	111	112	112	112	112	112	110	112	112	112	112	119	120
Annual	Coastal water excellent - number	Czechia
Annual	Coastal water excellent - number	Germany	280	291	290	286	280	295	303	313	318	303	307	313	317
Annual	Coastal water excellent - number	Denmark	657	692	694	709	776	785	786	790	793	819	830	861	864
Annual	Coastal water excellent - number	Estonia	13	11	11	10	11	14	14	15	14	14	16	13	14


CREATE TABLE raw (
  "freq" VARCHAR,
  "aquaenv" VARCHAR,
  "geo" VARCHAR,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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