Annual Freshwater Use, ENP-East Countries

Eurostat code: enpe_env_wat_use · (2005 - 2023)

@eurostat.enpe_env_wat_use

Table List

2 tables(19.83 KB)

Annual Freshwater Use, ENP-East Countries - Raw

Annual Freshwater Use, ENP-East Countries - Unpivoted

Annual Freshwater Use, ENP-East Countries - Raw

@eurostat.enpe_env_wat_use.raw

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

15.14 KB
6 rows
22 columns

freq Freq	unit Unit	geo Geo	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	n_2023 2023
Annual	Million cubic metres	Armenia	1905	1991	2145	1955	1518	1341	1738	2187	2089	2113	2533	2470	2040	1927	2124	2176	2257	2422	2262
Annual	Million cubic metres	Azerbaijan	8231	8658	8192	7689	7356	7120	7532	7740	7714	7584	7971	8198	8493	8524	8835	8936	9752	9714	8922
Annual	Million cubic metres	Belarus	1600	1546	1485	1410	1337	1359	1406	1442	1373	1371	1270	1302	1264	1247	1208	1180
Annual	Million cubic metres	Georgia								1772	1617	1583	1393	1118	1050	997	1275	1384	1476	1197	1262
Annual	Million cubic metres	Moldova	785	787	809	794	795	785	785	786	782	777	777	776	777	777	777	787	780	788	119
Annual	Million cubic metres	Ukraine	9360	9335	10000	9340	8691	8886	9130	9678	9352	8104	6556	6608	6284	6790	6821	6761	5649	3397	3573


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "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,
  "n_2023" DOUBLE
);

Share link

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