Phosphate In Rivers

Eurostat code: sdg_06_50 · (2000 - 2022)

@eurostat.sdg_06_50

Table List

2 tables(28.18 KB)

Phosphate In Rivers - Unpivoted

@eurostat.sdg_06_50.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.61 KB
506 rows
6 columns

freq Freq	watpol Watpol	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Phosphate in rivers	Milligrams per litre	Albania	2000	0.025
Annual	Phosphate in rivers	Milligrams per litre	Belgium	2000	0.269
Annual	Phosphate in rivers	Milligrams per litre	Bulgaria	2000	0.225
Annual	Phosphate in rivers	Milligrams per litre	Switzerland	2000	0.025
Annual	Phosphate in rivers	Milligrams per litre	Czechia	2000	0.313
Annual	Phosphate in rivers	Milligrams per litre	Denmark	2000	0.057
Annual	Phosphate in rivers	Milligrams per litre	Estonia	2000	0.036
Annual	Phosphate in rivers	Milligrams per litre	Spain	2000	0.117
Annual	Phosphate in rivers	Milligrams per litre	European Union (aggregate changing according to the context)	2000	0.091
Annual	Phosphate in rivers	Milligrams per litre	Finland	2000	0.019


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

Share link

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