Financial Accounts: Counterpart Information -- Annual Data

Eurostat code: nasa_10_f_cp · (1990 - 2024)

@eurostat.nasa_10_f_cp

Table List

2 tables(14.27 MB)

Financial Accounts: Counterpart Information -- Annual Data - Raw

Financial Accounts: Counterpart Information -- Annual Data - Unpivoted

Financial Accounts: Counterpart Information -- Annual Data - Unpivoted

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

7.26 MB
4696665 rows
10 columns

freq Freq	stk_flow Stk Flow	sector2 Sector2	sector Sector	na_item Na Item	finpos Finpos	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Stock	Total economy	Total economy	Financial net worth	Liabilities	Million euro	Hungary	1990
Annual	Stock	Total economy	Total economy	Financial net worth	Liabilities	Million units of national currency	Hungary	1990
Annual	Stock	Total economy	Total economy	Total financial assets/liabilities	Assets	Million euro	Hungary	1990	112918.1
Annual	Stock	Total economy	Total economy	Total financial assets/liabilities	Assets	Million units of national currency	Hungary	1990	9459151
Annual	Stock	Total economy	Total economy	Total financial assets/liabilities	Liabilities	Million euro	Hungary	1990	112918.1
Annual	Stock	Total economy	Total economy	Total financial assets/liabilities	Liabilities	Million units of national currency	Hungary	1990	9459151
Annual	Stock	Total economy	Total economy	Monetary gold and special drawing rights (SDRs)	Assets	Million euro	Hungary	1990
Annual	Stock	Total economy	Total economy	Monetary gold and special drawing rights (SDRs)	Assets	Million units of national currency	Hungary	1990
Annual	Stock	Total economy	Total economy	Monetary gold and special drawing rights (SDRs)	Liabilities	Million euro	Hungary	1990
Annual	Stock	Total economy	Total economy	Monetary gold and special drawing rights (SDRs)	Liabilities	Million units of national currency	Hungary	1990


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

Share link

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