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

@eurostat.sbs_pen_7a.raw

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

85.44 KB
1669 rows
20 columns

freq Freq	nace_r1 Nace R1	indic_sb Indic Sb	geo Geo	n_1997 1997	n_1998 1998	n_1999 1999	n_2000 2000	n_2001 2001	n_2002 2002	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	Pension funding	Enterprises - number	Austria	15	17	18	19	19		20	20	21	20	19	19	19	17	17	17
Annual	Pension funding	Enterprises - number	Belgium	307	304	310		324		267	267	262							217
Annual	Pension funding	Enterprises - number	Bulgaria						8		8	8	8	9	10	11	10	10	10
Annual	Pension funding	Enterprises - number	Switzerland	11572	3806		3418		3170		2934	2770	2667		2435	2351	2265	2191	2073
Annual	Pension funding	Enterprises - number	Cyprus												1704	1704
Annual	Pension funding	Enterprises - number	Czechia					17	14	12	11	11	10	11	10	10	10	9	9
Annual	Pension funding	Enterprises - number	Germany	303	303	301	299								196	198	198	196	194
Annual	Pension funding	Enterprises - number	Denmark	63	60	56	54	49		47	44
Annual	Pension funding	Enterprises - number	Estonia						15	15	15	15	15	15	19	22	23	23	23
Annual	Pension funding	Enterprises - number	Greece											3	3	3	4	4	7


CREATE TABLE raw (
  "freq" VARCHAR,
  "nace_r1" VARCHAR,
  "indic_sb" 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.