Autonomous Pension Funds - Geographical Breakdown (1997-2012)

Eurostat code: sbs_pen_7d · (1997 - 2012)

@eurostat.sbs_pen_7d

Table List

2 tables(42.57 KB)

Autonomous Pension Funds - Geographical Breakdown (1997-2012) - Raw

Autonomous Pension Funds - Geographical Breakdown (1997-2012) - Unpivoted

Autonomous Pension Funds - Geographical Breakdown (1997-2012) - Unpivoted

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

17.09 KB
2896 rows
7 columns

freq Freq	nace_r1 Nace R1	partner Partner	indic_sb Indic Sb	geo Geo	time_period Time Period	value Value
Annual	Pension funding	Canada and United States	Geographical breakdown of turnover - million euro	Switzerland	1997
Annual	Pension funding	Canada and United States	Geographical breakdown of turnover - million euro	Iceland	1997
Annual	Pension funding	Canada and United States	Geographical breakdown of turnover - million euro	Norway	1997
Annual	Pension funding	Canada and United States	Shares and other variable-yield securities broken down by location - million euro	Norway	1997	64.101
Annual	Pension funding	Canada and United States	Total investments broken down by location - million euro	Spain	1997	145.967
Annual	Pension funding	Canada and United States	Total investments broken down by location - million euro	Ireland	1997	3532.045
Annual	Pension funding	Canada and United States	Total investments broken down by location - million euro	Norway	1997
Annual	Pension funding	EEA-countries except the EU-countries	Geographical breakdown of turnover - million euro	Switzerland	1997
Annual	Pension funding	EEA-countries except the EU-countries	Geographical breakdown of turnover - million euro	Iceland	1997
Annual	Pension funding	EEA-countries except the EU-countries	Geographical breakdown of turnover - million euro	Norway	1997


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r1" VARCHAR,
  "partner" VARCHAR,
  "indic_sb" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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