Baselight
Sign In

Annual Financial Accounts For General Government

Eurostat code: gov_10a_ggfa ยท (1995 - 2023)

@eurostat.gov_10a_ggfa

Annual Financial Accounts For General Government - Unpivoted
@eurostat.gov_10a_ggfa.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.

  • 2.95 MB
  • 1576301 rows
  • 11 columns
freq

Freq

na_item

Na Item

sector2

Sector2

finpos

Finpos

stk_flow

Stk Flow

sector

Sector

co_nco

Co Nco

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualNet financial transactionsTotal economy and rest of the worldLiabilitiesTransactionsGeneral governmentConsolidatedMillion euroBelgium1995-9495.9
AnnualNet financial transactionsTotal economy and rest of the worldLiabilitiesTransactionsGeneral governmentConsolidatedMillion euroDenmark1995-4952.5
AnnualNet financial transactionsTotal economy and rest of the worldLiabilitiesTransactionsGeneral governmentConsolidatedMillion euroSpain1995-31480.6
AnnualNet financial transactionsTotal economy and rest of the worldLiabilitiesTransactionsGeneral governmentConsolidatedMillion euroHungary1995-3349.8
AnnualNet financial transactionsTotal economy and rest of the worldLiabilitiesTransactionsGeneral governmentConsolidatedMillion euroItaly1995-71279
AnnualNet financial transactionsTotal economy and rest of the worldLiabilitiesTransactionsGeneral governmentConsolidatedMillion units of national currencyBelgium1995-9075
AnnualNet financial transactionsTotal economy and rest of the worldLiabilitiesTransactionsGeneral governmentConsolidatedMillion units of national currencyDenmark1995-36292
AnnualNet financial transactionsTotal economy and rest of the worldLiabilitiesTransactionsGeneral governmentConsolidatedMillion units of national currencySpain1995-30840
AnnualNet financial transactionsTotal economy and rest of the worldLiabilitiesTransactionsGeneral governmentConsolidatedMillion units of national currencyHungary1995-551213
AnnualNet financial transactionsTotal economy and rest of the worldLiabilitiesTransactionsGeneral governmentConsolidatedMillion units of national currencyItaly1995-78416

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

Share link

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