Financial Balance Sheets - International Data Cooperation - Quarterly Data

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

@eurostat.naidsq_10_f_bs

Table List

2 tables(75.88 MB)

Financial Balance Sheets - International Data Cooperation - Quarterly Data - Raw

Financial Balance Sheets - International Data Cooperation - Quarterly Data - Unpivoted

Financial Balance Sheets - International Data Cooperation - Quarterly Data - Unpivoted

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

36.4 MB
8902176 rows
9 columns

freq Freq	unit Unit	sector Sector	finpos Finpos	na_item Na Item	co_nco Co Nco	geo Geo	time_period Time Period	value Value
Quarterly	Million units of national currency	Total economy	Assets	Total financial assets/liabilities	Non-consolidated	United States	1952-Q1	1658533
Quarterly	Million units of national currency	Total economy	Assets	Monetary gold and special drawing rights (SDRs)	Non-consolidated	United States	1952-Q1	23428
Quarterly	Million units of national currency	Total economy	Assets	Monetary gold	Non-consolidated	United States	1952-Q1	23428
Quarterly	Million units of national currency	Total economy	Assets	Special drawing rights (SDRs)	Non-consolidated	United States	1952-Q1
Quarterly	Million units of national currency	Total economy	Assets	Currency and deposits	Non-consolidated	United States	1952-Q1	231719
Quarterly	Million units of national currency	Total economy	Assets	Currency	Non-consolidated	United States	1952-Q1	31125
Quarterly	Million units of national currency	Total economy	Assets	Transferable deposits	Non-consolidated	United States	1952-Q1	118531
Quarterly	Million units of national currency	Total economy	Assets	Interbank positions	Non-consolidated	United States	1952-Q1	22476
Quarterly	Million units of national currency	Total economy	Assets	Other transferable deposits	Non-consolidated	United States	1952-Q1	96055
Quarterly	Million units of national currency	Total economy	Assets	Other deposits	Non-consolidated	United States	1952-Q1	82063


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

Share link

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