Drought Impact Area On Ecosystems

Eurostat code: sdg_15_42 · (2000 - 2023)

@eurostat.sdg_15_42

Table List

2 tables(36.09 KB)

Drought Impact Area On Ecosystems - Raw

Drought Impact Area On Ecosystems - Unpivoted

Drought Impact Area On Ecosystems - Raw

@eurostat.sdg_15_42.raw

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

25.7 KB
78 rows
27 columns

freq Freq	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	n_2023 2023
Annual	Square kilometre	Albania	2266	512	34	2814				2063	792			313	670			585	1	4757	32	396	662	4006	5417	45
Annual	Square kilometre	Austria	4671	6203	2850	23665	1183	420	579	2880	25	75	1045	1133	2352	4	25	4521	125	2400	5785	1920	214	2203	7919	59
Annual	Square kilometre	Bosnia and Herzegovina	19178	110	281	20418				276	1	18		564	8291	640		625		2189		18	886	6338	24979	590
Annual	Square kilometre	Belgium				199							3	2263		79	3			2574	3530	1427	11740	2	17350
Annual	Square kilometre	Bulgaria	56150	48896	9231	13737	280			10138	383	2406	1	253	1844	164	2	7	9	3309	20	141	10265	886	3919	2741
Annual	Square kilometre	Switzerland		2	3	1481	37	62	228	15	3	443	321	2312	308	51	2	498	66	1763	4796	2201	1954	457	6317	1451
Annual	Square kilometre	Cyprus	56						50	5	3712			7			4437		4214	488	593		2	573	251	63
Annual	Square kilometre	Czechia	7910	2080	2400	17145	2265	9	35	3575	7	5	2	28	4356		168	4806	15	3893	20717	7975	1366	24	4587	212
Annual	Square kilometre	Germany	156	41		48367	1820	33	125	137	6	236	4	10347	1384	6	795	5454	325	1774	70421	62550	54655	345	64136	813
Annual	Square kilometre	Denmark	104	3		164	291	185	156		577	615	11	85	28	621	42		8	4	19698	1347	337	513	3657	733


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

Share link

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