Financial Transactions - International Data Cooperation - Quarterly Data

Eurostat code: naidsq_10_f_tr · (1952-Q1 - 2024-Q4)

@eurostat.naidsq_10_f_tr

Table List

2 tables(56.06 MB)

Financial Transactions - International Data Cooperation - Quarterly Data - Raw

Financial Transactions - International Data Cooperation - Quarterly Data - Unpivoted

Financial Transactions - International Data Cooperation - Quarterly Data - Unpivoted

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

26.61 MB
8221714 rows
9 columns

freq Freq	unit Unit	sector Sector	finpos Finpos	co_nco Co Nco	na_item Na Item	geo Geo	time_period Time Period	value Value
Quarterly	Million units of national currency	Total economy	Assets	Non-consolidated	Monetary gold and special drawing rights (SDRs)	United States	1952-Q1	2224
Quarterly	Million units of national currency	Total economy	Assets	Non-consolidated	Monetary gold	United States	1952-Q1	2224
Quarterly	Million units of national currency	Total economy	Assets	Non-consolidated	Special drawing rights (SDRs)	United States	1952-Q1
Quarterly	Million units of national currency	Total economy	Assets	Non-consolidated	Currency and deposits	United States	1952-Q1	22648
Quarterly	Million units of national currency	Total economy	Assets	Non-consolidated	Currency	United States	1952-Q1	3660
Quarterly	Million units of national currency	Total economy	Assets	Non-consolidated	Transferable deposits	United States	1952-Q1	11136
Quarterly	Million units of national currency	Total economy	Assets	Non-consolidated	Interbank positions	United States	1952-Q1	772
Quarterly	Million units of national currency	Total economy	Assets	Non-consolidated	Other transferable deposits	United States	1952-Q1	10364
Quarterly	Million units of national currency	Total economy	Assets	Non-consolidated	Other deposits	United States	1952-Q1	7852
Quarterly	Million units of national currency	Total economy	Assets	Non-consolidated	Debt securities	United States	1952-Q1	23944


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

Share link

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