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) - Raw

@eurostat.sbs_pen_7b2.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

19.3 KB
189 rows
20 columns

freq Freq	size_mbr Size Mbr	nace_r1 Nace R1	geo Geo	n_1997 1997	n_1998 1998	n_1999 1999	n_2000 2000	n_2001 2001	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012
Annual	From 10 001 to 100 000 members	Pension funding	Austria	4	6	6	8	8	9	7	7	7	7	7	6	6	6	5
Annual	From 10 001 to 100 000 members	Pension funding	Belgium	9	9	9		8	7	6	7
Annual	From 10 001 to 100 000 members	Pension funding	Bulgaria						5	5	5	5	5		6	5	5
Annual	From 10 001 to 100 000 members	Pension funding	Switzerland	47	48		51			64	65	75		258	253	232	236	209
Annual	From 10 001 to 100 000 members	Pension funding	Czechia					4	4	4	4	2	2
Annual	From 10 001 to 100 000 members	Pension funding	Germany											2	4	14
Annual	From 10 001 to 100 000 members	Pension funding	Denmark
Annual	From 10 001 to 100 000 members	Pension funding	Estonia						6	5	5	6	6	6	6		11	11
Annual	From 10 001 to 100 000 members	Pension funding	Greece										1
Annual	From 10 001 to 100 000 members	Pension funding	Spain	45	56	72	94	112	139	149	170	170	181	186	195	200	200	201


CREATE TABLE raw (
  "freq" VARCHAR,
  "size_mbr" VARCHAR,
  "nace_r1" VARCHAR,
  "geo" VARCHAR,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE
);

Share link

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