General Government Deficit (-) And Surplus (+) - Annual Data

Eurostat code: teina200 · (2013 - 2024)

@eurostat.teina200

Table List

2 tables(25.11 KB)

General Government Deficit (-) And Surplus (+) - Annual Data - Raw

General Government Deficit (-) And Surplus (+) - Annual Data - Unpivoted

General Government Deficit (-) And Surplus (+) - Annual Data - Unpivoted

@eurostat.teina200.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.1 KB
696 rows
7 columns

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


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

Share link

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