Autonomous Pension Funds - All Indicators (1997-2012)

Eurostat code: sbs_pen_7a · (1997 - 2012)

@eurostat.sbs_pen_7a

Table List

2 tables(162.31 KB)

Autonomous Pension Funds - All Indicators (1997-2012) - Raw

Autonomous Pension Funds - All Indicators (1997-2012) - Unpivoted

Autonomous Pension Funds - All Indicators (1997-2012) - Unpivoted

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

76.87 KB
13756 rows
6 columns

freq Freq	nace_r1 Nace R1	indic_sb Indic Sb	geo Geo	time_period Time Period	value Value
Annual	Pension funding	Enterprises - number	Austria	1997	15
Annual	Pension funding	Enterprises - number	Belgium	1997	307
Annual	Pension funding	Enterprises - number	Switzerland	1997	11572
Annual	Pension funding	Enterprises - number	Germany	1997	303
Annual	Pension funding	Enterprises - number	Denmark	1997	63
Annual	Pension funding	Enterprises - number	Spain	1997	412
Annual	Pension funding	Enterprises - number	Finland	1997	130
Annual	Pension funding	Enterprises - number	Iceland	1997	65
Annual	Pension funding	Enterprises - number	Italy	1997	497
Annual	Pension funding	Enterprises - number	Luxembourg	1997	1


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

Share link

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