Baselight

Government Deficit/surplus, Debt And Associated Data

Eurostat code: gov_10dd_edpt1 · (1995 - 2023)

@eurostat.gov_10dd_edpt1

Government Deficit/surplus, Debt And Associated Data - Unpivoted
@eurostat.gov_10dd_edpt1.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.

  • 209.69 KB
  • 49542 rows
  • 7 columns
freq

Freq

unit

Unit

sector

Sector

na_item

Na Item

geo

Geo

time_period

Time Period

value

Value

AnnualMillion euroTotal economyGross domestic product at market pricesAustria1995183629.2
AnnualMillion euroTotal economyGross domestic product at market pricesBelgium1995220251.5
AnnualMillion euroTotal economyGross domestic product at market pricesBulgaria199514512.8
AnnualMillion euroTotal economyGross domestic product at market pricesCyprus19957596
AnnualMillion euroTotal economyGross domestic product at market pricesCzechia199546333.6
AnnualMillion euroTotal economyGross domestic product at market pricesGermany19951983157.1
AnnualMillion euroTotal economyGross domestic product at market pricesDenmark1995141320.3
AnnualMillion euroTotal economyGross domestic product at market pricesEuro area - 19 countries (2015-2022)19955744017.7
AnnualMillion euroTotal economyGross domestic product at market pricesEuro area – 20 countries (from 2023)19955761537.8
AnnualMillion euroTotal economyGross domestic product at market pricesEstonia19952988.1

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.