Total Economy Deficit/surplus

Eurostat code: enps_gov_10dde · (2005 - 2022)

@eurostat.enps_gov_10dde

Table List

2 tables(18.95 KB)

Total Economy Deficit/surplus - Raw

Total Economy Deficit/surplus - Unpivoted

Total Economy Deficit/surplus - Raw

@eurostat.enps_gov_10dde.raw

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

14.41 KB
4 rows
21 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
Annual	Percentage of gross domestic product (GDP)	Algeria	22.8	26.5	24.1	22	2.9	10.3	11.9	10	3.3	-1.3	-14.1	-11.8	-8.4	-6	-5.9	-9.6
Annual	Percentage of gross domestic product (GDP)	Israel	3.7	4.9	3.4	1.8	4.1	4	2.3	0.8	3.6	5.1	6.1	4.7	4.2	3.4	4.1	5.9	4.8	4.5
Annual	Percentage of gross domestic product (GDP)	Morocco	2.2	2.7	-0.1	-5	-5.3	-4.4	-7.9	-9.5	-7.7	-5.5	-2	-3.8	-3.2	-4.9	-3.4	-1.2	-2.3	-3.5
Annual	Percentage of gross domestic product (GDP)	Tunisia	-0.5	-1.4	-1.9	-3.6	-2.5	-4.6	-7	-7.3	-8.1	-8.4


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
);

Share link

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