General Government Deficit/surplus

Eurostat code: tec00127 · (2013 - 2024)

@eurostat.tec00127

Table List

2 tables(25.27 KB)

General Government Deficit/surplus - Raw

General Government Deficit/surplus - Unpivoted

General Government Deficit/surplus - Unpivoted

@eurostat.tec00127.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

9.15 KB
720 rows
7 columns

freq Freq	unit Unit	sector Sector	na_item Na Item	geo Geo	time_period Time Period	value Value
Annual	Million euro	General government	Net lending (+)/net borrowing (-)	Austria	2013	-6399.7
Annual	Million euro	General government	Net lending (+)/net borrowing (-)	Belgium	2013	-12483.8
Annual	Million euro	General government	Net lending (+)/net borrowing (-)	Bulgaria	2013	-305.8
Annual	Million euro	General government	Net lending (+)/net borrowing (-)	Cyprus	2013	-1009.3
Annual	Million euro	General government	Net lending (+)/net borrowing (-)	Czechia	2013	-2083.7
Annual	Million euro	General government	Net lending (+)/net borrowing (-)	Germany	2013	3512
Annual	Million euro	General government	Net lending (+)/net borrowing (-)	Denmark	2013	-2449.1
Annual	Million euro	General government	Net lending (+)/net borrowing (-)	Euro area - 19 countries (2015-2022)	2013	-320475.6
Annual	Million euro	General government	Net lending (+)/net borrowing (-)	Euro area – 20 countries (from 2023)	2013	-322937.7
Annual	Million euro	General government	Net lending (+)/net borrowing (-)	Estonia	2013	-41.7


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "sector" VARCHAR,
  "na_item" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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