Baselight

Debt Of The EU Institutions

Eurostat code: gov_eu_debt ยท (2020 - 2023)

@eurostat.gov_eu_debt

Debt Of The EU Institutions - Unpivoted
@eurostat.gov_eu_debt.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.94 KB
  • 40 rows
  • 7 columns
freq

Freq

sector

Sector

na_item

Na Item

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEuropean institutions and bodiesCurrency and depositsMillion euroInstitutions and bodies of the European Union2020
AnnualEuropean institutions and bodiesCurrencyMillion euroInstitutions and bodies of the European Union2020
AnnualEuropean institutions and bodiesTransferable deposits; other depositsMillion euroInstitutions and bodies of the European Union2020
AnnualEuropean institutions and bodiesDebt securitiesMillion euroInstitutions and bodies of the European Union2020397779.19
AnnualEuropean institutions and bodiesShort-term debt securitiesMillion euroInstitutions and bodies of the European Union202032881.55
AnnualEuropean institutions and bodiesLong-term debt securitiesMillion euroInstitutions and bodies of the European Union2020364897.63
AnnualEuropean institutions and bodiesLoansMillion euroInstitutions and bodies of the European Union20202324.2
AnnualEuropean institutions and bodiesShort-term - loansMillion euroInstitutions and bodies of the European Union2020980.92
AnnualEuropean institutions and bodiesLong-term - loansMillion euroInstitutions and bodies of the European Union20201343.28
AnnualEuropean institutions and bodiesGovernment consolidated gross debtMillion euroInstitutions and bodies of the European Union2020400103.39

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

Share link

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