Nitrate In Groundwater

Eurostat code: sdg_06_40 · (2000 - 2022)

@eurostat.sdg_06_40

Table List

2 tables(29.15 KB)

Nitrate In Groundwater - Unpivoted

@eurostat.sdg_06_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.

7.73 KB
483 rows
6 columns

freq Freq	watpol Watpol	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Nitrate in groundwater	Milligrams per litre	Austria	2000	26.01
Annual	Nitrate in groundwater	Milligrams per litre	Belgium	2000	27.91
Annual	Nitrate in groundwater	Milligrams per litre	Bulgaria	2000	29.52
Annual	Nitrate in groundwater	Milligrams per litre	Switzerland	2000	15.72
Annual	Nitrate in groundwater	Milligrams per litre	Cyprus	2000	14.65
Annual	Nitrate in groundwater	Milligrams per litre	Czechia	2000	23.34
Annual	Nitrate in groundwater	Milligrams per litre	Germany	2000	24.92
Annual	Nitrate in groundwater	Milligrams per litre	Denmark	2000	51.52
Annual	Nitrate in groundwater	Milligrams per litre	Estonia	2000	7.08
Annual	Nitrate in groundwater	Milligrams per litre	Spain	2000	54.25


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.