Baselight

Financial Transactions - Annual Data

Eurostat code: nasa_10_f_tr ยท (1990 - 2024)

@eurostat.nasa_10_f_tr

Financial Transactions - Annual Data - Unpivoted
@eurostat.nasa_10_f_tr.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.97 MB
  • 8366122 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 economyAssetsMonetary gold and special drawing rights (SDRs)Hungary1990-172
AnnualMillion euroConsolidatedTotal economyAssetsMonetary goldHungary1990-172
AnnualMillion euroConsolidatedTotal economyAssetsSpecial drawing rights (SDRs)Hungary1990
AnnualMillion euroConsolidatedTotal economyAssetsCurrency and depositsHungary1990297.6
AnnualMillion euroConsolidatedTotal economyAssetsCurrencyHungary19900.3
AnnualMillion euroConsolidatedTotal economyAssetsTransferable depositsHungary1990382.3
AnnualMillion euroConsolidatedTotal economyAssetsInterbank positionsHungary1990305.7
AnnualMillion euroConsolidatedTotal economyAssetsOther transferable depositsHungary199076.6
AnnualMillion euroConsolidatedTotal economyAssetsOther depositsHungary1990-85.1
AnnualMillion euroConsolidatedTotal economyAssetsDebt securitiesHungary1990-222.2

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.