Baselight

Transition From The Deficit/surplus To The Change In Debt

Eurostat code: gov_10dd_edpt3 ยท (1995 - 2023)

@eurostat.gov_10dd_edpt3

Transition From The Deficit/surplus To The Change In Debt - Unpivoted
@eurostat.gov_10dd_edpt3.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.

  • 423.4 KB
  • 177474 rows
  • 7 columns
freq

Freq

unit

Unit

sector

Sector

na_item

Na Item

geo

Geo

time_period

Time Period

value

Value

AnnualMillion euroGeneral governmentDiscrepancy with the financial net lending/net borrowing (B9F-B9)Belgium1995-434
AnnualMillion euroGeneral governmentDiscrepancy with the financial net lending/net borrowing (B9F-B9)Czechia1995
AnnualMillion euroGeneral governmentDiscrepancy with the financial net lending/net borrowing (B9F-B9)Greece1995-3222.1
AnnualMillion euroGeneral governmentDiscrepancy with the financial net lending/net borrowing (B9F-B9)Spain1995-435.9
AnnualMillion euroGeneral governmentDiscrepancy with the financial net lending/net borrowing (B9F-B9)Hungary1995299.8
AnnualMillion euroGeneral governmentDiscrepancy with the financial net lending/net borrowing (B9F-B9)Lithuania19959.2
AnnualMillion euroGeneral governmentDiscrepancy with the financial net lending/net borrowing (B9F-B9)Luxembourg1995-1360.1
AnnualMillion euroGeneral governmentDiscrepancy with the financial net lending/net borrowing (B9F-B9)Latvia1995-11.7
AnnualMillion euroGeneral governmentDiscrepancy with the financial net lending/net borrowing (B9F-B9)Netherlands1995693
AnnualMillion euroGeneral governmentDiscrepancy with the financial net lending/net borrowing (B9F-B9)Portugal1995

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.