Baselight

Nitrate In Groundwater

Eurostat code: sdg_06_40 ยท (2000 - 2022)

@eurostat.sdg_06_40

Nitrate In Groundwater - Raw
@eurostat.sdg_06_40.raw

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

  • 21.42 KB
  • 21 rows
  • 27 columns
freq

Freq

watpol

Watpol

unit

Unit

geo

Geo

n_2000

2000

n_2001

2001

n_2002

2002

n_2003

2003

n_2004

2004

n_2005

2005

n_2006

2006

n_2007

2007

n_2008

2008

n_2009

2009

n_2010

2010

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

AnnualNitrate in groundwaterMilligrams per litreAustria26.0125.6127.2626.8426.825.926.2525.4624.7725.5226.3526.2425.7724.6624.52423.2322.8921.9321.892122.2821.36
AnnualNitrate in groundwaterMilligrams per litreBelgium27.9126.7926.9627.927.6530.2532.3731.3632.7331.0130.1929.6529.8728.528.2227.930.3429.3828.6328.2527.928.6428.64
AnnualNitrate in groundwaterMilligrams per litreBulgaria29.5226.7324.126.1123.5724.3425.792625.8227.1825.1325.0928.0528.3126.2331.2632.7629.6829.7929.5630.5631.3634.89
AnnualNitrate in groundwaterMilligrams per litreSwitzerland15.7215.7215.7115.516.6916.3717.0916.515.8615.815.6915.2615.1316.1415.2314.7614.713.9213.9114.2714.6515.2714.53
AnnualNitrate in groundwaterMilligrams per litreCyprus14.6516.0812.7918.9122.1827.6830.1438.2537.0541.5847.3839.1441.1643.5762.570.4897.6451.8555.2748.847.847.847.84
AnnualNitrate in groundwaterMilligrams per litreCzechia23.3421.0719.7720.0619.6420.2220.4520.6519.1318.4819.518.991918.4818.4417.9518.8418.4217.9917.6818.6918.4418.61
AnnualNitrate in groundwaterMilligrams per litreGermany24.9225.224.8524.4124.6824.8323.6822.8524.9223.9624.9223.7923.8424.8225.8126.827.7827.0726.926.1724.8724.0323.74
AnnualNitrate in groundwaterMilligrams per litreDenmark51.5253.3547.6143.5241.6939.9236.2938.7640.5936.9540.3838.9546.4340.7641.3231.5714.6515.4528.0215.9528.1115.0626.73
AnnualNitrate in groundwaterMilligrams per litreEstonia7.085.394.455.922.564.745.925.989.668.076.527.599.537.817.028.388.518.028.048.396.367.287.28
AnnualNitrate in groundwaterMilligrams per litreSpain54.2554.7755.355.8257.0956.1652.8561.7348.5648.9748.8956.8855.5154.8354.1553.4752.7957.2652.8949.8844.142.4649.76

CREATE TABLE raw (
  "freq" VARCHAR,
  "watpol" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "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
);

Share link

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