Baselight

Phosphate In Rivers

Eurostat code: sdg_06_50 ยท (2000 - 2022)

@eurostat.sdg_06_50

Phosphate In Rivers - Raw
@eurostat.sdg_06_50.raw

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

  • 21.57 KB
  • 22 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

AnnualPhosphate in riversMilligrams per litreAlbania0.0250.0240.0260.0270.0180.0610.0960.0870.2850.140.2590.1180.0510.0480.0450.0420.2850.1350.0910.0580.0820.0510.234
AnnualPhosphate in riversMilligrams per litreBelgium0.2690.2430.2470.3170.30.2820.2280.1920.160.2270.2150.2170.160.1660.1730.1880.1690.2150.1920.220.1970.1480.206
AnnualPhosphate in riversMilligrams per litreBulgaria0.2250.310.2640.2410.2350.1310.3140.4250.3210.290.3280.1350.1520.1420.1130.0960.10.1320.1060.1480.1930.1690.145
AnnualPhosphate in riversMilligrams per litreSwitzerland0.0250.0250.0220.020.0210.020.0240.020.0190.0190.0190.0210.0190.0150.0160.0210.0190.0160.0130.0150.0160.0160.018
AnnualPhosphate in riversMilligrams per litreCzechia0.3130.2610.250.3330.2630.1820.1460.1380.1440.0920.0770.1250.140.1190.1440.1470.1460.1440.1560.1250.0880.0960.096
AnnualPhosphate in riversMilligrams per litreDenmark0.0570.0550.0560.0530.0540.0480.0530.0490.0480.0450.0490.0510.0510.0460.0470.0510.0470.050.0490.050.0550.0530.049
AnnualPhosphate in riversMilligrams per litreEstonia0.0360.0390.0370.0450.0330.0310.0310.0270.0310.0330.0270.0290.0250.0240.0220.0230.0270.0260.0270.0230.0250.0220.023
AnnualPhosphate in riversMilligrams per litreSpain0.1170.0930.1070.0960.1050.1260.1320.1110.0770.0470.0450.0520.2290.1280.1470.1610.1840.1980.1930.1880.1890.2020.205
AnnualPhosphate in riversMilligrams per litreEuropean Union (aggregate changing according to the context)0.0910.0940.0920.0950.0840.0760.0890.0940.0810.0790.0740.0580.0710.0610.0620.0640.0620.0670.0660.0710.0820.0720.074
AnnualPhosphate in riversMilligrams per litreFinland0.0190.020.0140.0170.0170.0180.0160.0150.0170.0180.0150.0160.0170.0120.0110.0160.0160.0160.0110.0130.0160.0150.015

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.