Baselight
Sign In

Government Deficit/surplus And Debt

Eurostat code: enps_gov_10dd ยท (2005 - 2022)

@eurostat.enps_gov_10dd

Government Deficit/surplus And Debt - Unpivoted
@eurostat.enps_gov_10dd.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.

  • 5.89 KB
  • 150 rows
  • 6 columns
freq

Freq

unit

Unit

na_item

Na Item

geo

Geo

time_period

Time Period

value

Value

AnnualPercentage of gross domestic product (GDP)Net lending (+)/net borrowing (-)Algeria200513.6
AnnualPercentage of gross domestic product (GDP)Net lending (+)/net borrowing (-)Egypt2005-13.9
AnnualPercentage of gross domestic product (GDP)Net lending (+)/net borrowing (-)Israel2005-2.7
AnnualPercentage of gross domestic product (GDP)Net lending (+)/net borrowing (-)Morocco2005-2.6
AnnualPercentage of gross domestic product (GDP)Net lending (+)/net borrowing (-)Tunisia2005-0.9
AnnualPercentage of gross domestic product (GDP)Government consolidated gross debtIsrael200585.1
AnnualPercentage of gross domestic product (GDP)Government consolidated gross debtLebanon2005159
AnnualPercentage of gross domestic product (GDP)Government consolidated gross debtMorocco200571
AnnualPercentage of gross domestic product (GDP)Government consolidated gross debtTunisia200551.8
AnnualPercentage of gross domestic product (GDP)Net lending (+)/net borrowing (-)Algeria200614

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

Share link

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