Financial Accounts: Counterpart Information - Quarterly Data

Eurostat code: nasq_10_f_cp · (1999-Q1 - 2024-Q4)

@eurostat.nasq_10_f_cp

Table List

2 tables(78.42 MB)

Financial Accounts: Counterpart Information - Quarterly Data - Raw

Financial Accounts: Counterpart Information - Quarterly Data - Unpivoted

Financial Accounts: Counterpart Information - Quarterly Data - Unpivoted

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

39.08 MB
25385441 rows
10 columns

freq Freq	unit Unit	sector2 Sector2	sector Sector	stk_flow Stk Flow	finpos Finpos	na_item Na Item	geo Geo	time_period Time Period	value Value
Quarterly	Million euro	Total economy	Total economy	Other changes in volume	Assets	Debt securities	Austria	1999-Q1	-959
Quarterly	Million euro	Total economy	Total economy	Other changes in volume	Assets	Debt securities	Spain	1999-Q1	-9.6
Quarterly	Million euro	Total economy	Total economy	Other changes in volume	Assets	Debt securities	France	1999-Q1	460
Quarterly	Million euro	Total economy	Total economy	Other changes in volume	Assets	Debt securities	Hungary	1999-Q1
Quarterly	Million euro	Total economy	Total economy	Other changes in volume	Assets	Debt securities	Lithuania	1999-Q1
Quarterly	Million euro	Total economy	Total economy	Other changes in volume	Assets	Debt securities	Luxembourg	1999-Q1	-3.1
Quarterly	Million euro	Total economy	Total economy	Other changes in volume	Assets	Debt securities	Sweden	1999-Q1	1358.2
Quarterly	Million euro	Total economy	Total economy	Other changes in volume	Assets	Short-term debt securities	Austria	1999-Q1	-1391
Quarterly	Million euro	Total economy	Total economy	Other changes in volume	Assets	Short-term debt securities	Spain	1999-Q1
Quarterly	Million euro	Total economy	Total economy	Other changes in volume	Assets	Short-term debt securities	France	1999-Q1	94


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "sector2" VARCHAR,
  "sector" VARCHAR,
  "stk_flow" 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.