Autonomous Pension Funds - Total Investments By Currencies (2003-2012)

Eurostat code: sbs_pen_7c · (2003 - 2012)

@eurostat.sbs_pen_7c

Table List

2 tables(19.85 KB)

Autonomous Pension Funds - Total Investments By Currencies (2003-2012) - Raw

Autonomous Pension Funds - Total Investments By Currencies (2003-2012) - Unpivoted

Autonomous Pension Funds - Total Investments By Currencies (2003-2012) - Unpivoted

@eurostat.sbs_pen_7c.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.45 KB
455 rows
6 columns

freq Freq	currency Currency	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Euro	Pension funding	Austria	2003	7812
Annual	Euro	Pension funding	Belgium	2003	8730
Annual	Euro	Pension funding	Czechia	2003	106
Annual	Euro	Pension funding	Denmark	2003	43
Annual	Euro	Pension funding	Estonia	2003	38
Annual	Euro	Pension funding	Spain	2003	48506
Annual	Euro	Pension funding	Finland	2003	5198
Annual	Euro	Pension funding	Netherlands	2003	278159
Annual	Euro	Pension funding	Portugal	2003	15024
Annual	Other currencies	Pension funding	Austria	2003	1219


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

Share link

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