Baselight

Debt By Currency Of Issue

Eurostat code: gov_10dd_dcur ยท (2020 - 2023)

@eurostat.gov_10dd_dcur

Debt By Currency Of Issue - Unpivoted
@eurostat.gov_10dd_dcur.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.

  • 18.17 KB
  • 5760 rows
  • 7 columns
freq

Freq

sector

Sector

currency

Currency

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualGeneral governmentSwiss francMillion euroCyprus2020
AnnualGeneral governmentSwiss francMillion euroCzechia2020
AnnualGeneral governmentSwiss francMillion euroCroatia20209.3
AnnualGeneral governmentSwiss francMillion euroHungary2020
AnnualGeneral governmentSwiss francMillion euroIreland2020
AnnualGeneral governmentSwiss francMillion euroItaly202047.1
AnnualGeneral governmentSwiss francMillion euroLithuania2020
AnnualGeneral governmentSwiss francMillion euroLuxembourg2020
AnnualGeneral governmentSwiss francMillion euroLatvia2020
AnnualGeneral governmentSwiss francMillion euroMalta2020

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

Share link

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