Biochemical Oxygen Demand In Rivers

Eurostat code: sdg_06_30 · (2000 - 2022)

@eurostat.sdg_06_30

Table List

2 tables(26.58 KB)

Biochemical Oxygen Demand In Rivers - Raw

Biochemical Oxygen Demand In Rivers - Unpivoted

Biochemical Oxygen Demand In Rivers - Unpivoted

@eurostat.sdg_06_30.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.1 KB
483 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Milligrams per litre	Albania	2000	2.77
Annual	Milligrams per litre	Austria	2000	2.31
Annual	Milligrams per litre	Belgium	2000	2.75
Annual	Milligrams per litre	Bulgaria	2000	4.9
Annual	Milligrams per litre	Cyprus	2000	2.13
Annual	Milligrams per litre	Czechia	2000	3.7
Annual	Milligrams per litre	Estonia	2000	1.58
Annual	Milligrams per litre	Spain	2000	2.8
Annual	Milligrams per litre	European Union (aggregate changing according to the context)	2000	3.48
Annual	Milligrams per litre	Finland	2000	2.49


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

Share link

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