Financial Transactions - International Data Cooperation

Eurostat code: naidsa_10_f_tr · (1950 - 2023)

@eurostat.naidsa_10_f_tr

Table List

2 tables(25.45 MB)

Financial Transactions - International Data Cooperation - Raw

Financial Transactions - International Data Cooperation - Unpivoted

Financial Transactions - International Data Cooperation - Unpivoted

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

12.61 MB
5033733 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
Annual	Million units of national currency	Consolidated	General government	Assets	Total financial assets/liabilities	United States	1950	17400
Annual	Million units of national currency	Consolidated	General government	Assets	Monetary gold and special drawing rights (SDRs)	United States	1950	-22
Annual	Million units of national currency	Consolidated	General government	Assets	Monetary gold	United States	1950	-22
Annual	Million units of national currency	Consolidated	General government	Assets	Special drawing rights (SDRs)	United States	1950
Annual	Million units of national currency	Consolidated	General government	Assets	Currency and deposits	United States	1950	95
Annual	Million units of national currency	Consolidated	General government	Assets	Currency	United States	1950	248
Annual	Million units of national currency	Consolidated	General government	Assets	Transferable deposits	United States	1950
Annual	Million units of national currency	Consolidated	General government	Assets	Other deposits	United States	1950	-153
Annual	Million units of national currency	Consolidated	General government	Assets	Debt securities	United States	1950	184
Annual	Million units of national currency	Consolidated	General government	Assets	Short-term debt securities	United States	1950


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.