Baselight

Financial Balance Sheets - Annual Data

Eurostat code: nasa_10_f_bs ยท (1990 - 2024)

@eurostat.nasa_10_f_bs

Financial Balance Sheets - Annual Data - Unpivoted
@eurostat.nasa_10_f_bs.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.

  • 23.76 MB
  • 9346166 rows
  • 9 columns
freq

Freq

unit

Unit

co_nco

Co Nco

sector

Sector

finpos

Finpos

na_item

Na Item

geo

Geo

time_period

Time Period

value

Value

AnnualMillion euroConsolidatedTotal economyAssetsTotal financial assets/liabilitiesHungary19907025.4
AnnualMillion euroConsolidatedTotal economyAssetsMonetary gold and special drawing rights (SDRs)Hungary199083.6
AnnualMillion euroConsolidatedTotal economyAssetsMonetary goldHungary199083.6
AnnualMillion euroConsolidatedTotal economyAssetsSpecial drawing rights (SDRs)Hungary1990
AnnualMillion euroConsolidatedTotal economyAssetsCurrency and depositsHungary19902267.9
AnnualMillion euroConsolidatedTotal economyAssetsCurrencyHungary1990410.8
AnnualMillion euroConsolidatedTotal economyAssetsTransferable depositsHungary19901265.8
AnnualMillion euroConsolidatedTotal economyAssetsInterbank positionsHungary19901146.4
AnnualMillion euroConsolidatedTotal economyAssetsOther transferable depositsHungary1990119.4
AnnualMillion euroConsolidatedTotal economyAssetsOther depositsHungary1990591.3

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

Share link

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