Transition From The Working Balance To The Deficit/surplus

Eurostat code: gov_10dd_edpt2 · (1995 - 2023)

@eurostat.gov_10dd_edpt2

Table List

2 tables(274.3 KB)

Transition From The Working Balance To The Deficit/surplus - Raw

Transition From The Working Balance To The Deficit/surplus - Unpivoted

Transition From The Working Balance To The Deficit/surplus - Unpivoted

@eurostat.gov_10dd_edpt2.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.

121.07 KB
40910 rows
7 columns

freq Freq	unit Unit	sector Sector	na_item Na Item	geo Geo	time_period Time Period	value Value
Annual	Million euro	Central government	Net lending (+)/net borrowing (-)	Belgium	1995	-8342.1
Annual	Million euro	Central government	Net lending (+)/net borrowing (-)	Greece	1995	-12071.8
Annual	Million euro	Central government	Net lending (+)/net borrowing (-)	Spain	1995	-26203.2
Annual	Million euro	Central government	Net lending (+)/net borrowing (-)	Croatia	1995	-130.8
Annual	Million euro	Central government	Net lending (+)/net borrowing (-)	Hungary	1995	-3098.1
Annual	Million euro	Central government	Net lending (+)/net borrowing (-)	Ireland	1995	-1044.5
Annual	Million euro	Central government	Net lending (+)/net borrowing (-)	Luxembourg	1995	124.7
Annual	Million euro	Central government	Net lending (+)/net borrowing (-)	Malta	1995	-98.9
Annual	Million euro	Central government	Net lending (+)/net borrowing (-)	Netherlands	1995	-27864.1
Annual	Million euro	Central government	Net lending (+)/net borrowing (-)	Portugal	1995	-4329.5


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.