Central Government Debt

Eurostat code: gov_10dd_cgd · (2020 - 2023)

@eurostat.gov_10dd_cgd

Table List

2 tables(221.97 KB)

Central Government Debt - Unpivoted

@eurostat.gov_10dd_cgd.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.

109.83 KB
61795 rows
8 columns

freq Freq	na_item Na Item	sector Sector	maturity Maturity	unit Unit	geo Geo	time_period Time Period
Annual	Currency	Non-financial corporations	Total - all maturities	Million euro	Cyprus	2020
Annual	Currency	Non-financial corporations	Total - all maturities	Million euro	Greece	2020
Annual	Currency	Non-financial corporations	Total - all maturities	Million euro	Croatia	2020
Annual	Currency	Non-financial corporations	Total - all maturities	Million euro	Ireland	2020
Annual	Currency	Non-financial corporations	Total - all maturities	Million euro	Luxembourg	2020
Annual	Currency	Non-financial corporations	Total - all maturities	Million euro	Latvia	2020
Annual	Currency	Non-financial corporations	Total - all maturities	Million euro	Portugal	2020
Annual	Currency	Non-financial corporations	Total - all maturities	Million euro	Romania	2020
Annual	Currency	Non-financial corporations	Total - all maturities	Million euro	Sweden	2020
Annual	Currency	Non-financial corporations	Total - all maturities	Million euro	Slovakia	2020


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

Share link

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