Financial Balance Sheets - International Data Cooperation

Eurostat code: naidsa_10_f_bs · (1950 - 2023)

@eurostat.naidsa_10_f_bs

Table List

2 tables(30.87 MB)

Financial Balance Sheets - International Data Cooperation - Raw

Financial Balance Sheets - International Data Cooperation - Unpivoted

Financial Balance Sheets - International Data Cooperation - Unpivoted

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

15.26 MB
5039843 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	53092
Annual	Million units of national currency	Consolidated	General government	Assets	Monetary gold and special drawing rights (SDRs)	United States	1950	114
Annual	Million units of national currency	Consolidated	General government	Assets	Monetary gold	United States	1950	114
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	14948
Annual	Million units of national currency	Consolidated	General government	Assets	Currency	United States	1950	11887
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	3061
Annual	Million units of national currency	Consolidated	General government	Assets	Debt securities	United States	1950	2266
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.