Autonomous Pension Funds - Number Of Enterprises By Size Class Of Members (1997-2012)

Eurostat code: sbs_pen_7b2 · (1997 - 2012)

@eurostat.sbs_pen_7b2

Table List

2 tables(28.57 KB)

Autonomous Pension Funds - Number Of Enterprises By Size Class Of Members (1997-2012) - Raw

Autonomous Pension Funds - Number Of Enterprises By Size Class Of Members (1997-2012) - Unpivoted

Autonomous Pension Funds - Number Of Enterprises By Size Class Of Members (1997-2012) - Unpivoted

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

9.26 KB
1664 rows
6 columns

freq Freq	size_mbr Size Mbr	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	From 10 001 to 100 000 members	Pension funding	Austria	1997	4
Annual	From 10 001 to 100 000 members	Pension funding	Belgium	1997	9
Annual	From 10 001 to 100 000 members	Pension funding	Switzerland	1997	47
Annual	From 10 001 to 100 000 members	Pension funding	Denmark	1997
Annual	From 10 001 to 100 000 members	Pension funding	Spain	1997	45
Annual	From 10 001 to 100 000 members	Pension funding	Ireland	1997
Annual	From 10 001 to 100 000 members	Pension funding	Iceland	1997	3
Annual	From 10 001 to 100 000 members	Pension funding	Italy	1997	19
Annual	From 10 001 to 100 000 members	Pension funding	Norway	1997	8
Annual	From 10 001 to 100 000 members	Pension funding	Portugal	1997	6


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

Share link

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