Accrued-to-date Pension Entitlements In Social Insurance - Annual Data

Eurostat code: nasa_10_pens1 · (2012 - 2023)

@eurostat.nasa_10_pens1

Table List

2 tables(212.88 KB)

Accrued-to-date Pension Entitlements In Social Insurance - Annual Data - Raw

Accrued-to-date Pension Entitlements In Social Insurance - Annual Data - Unpivoted

Accrued-to-date Pension Entitlements In Social Insurance - Annual Data - Unpivoted

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

97.59 KB
25298 rows
7 columns

freq Freq	unit Unit	penscheme Penscheme	na_item Na Item	geo Geo	time_period Time Period	value Value
Annual	Million euro	Private pension schemes	Employers' actual pension contributions	Switzerland	2012	18095
Annual	Million euro	Private pension schemes	Employers' actual pension contributions	Germany	2012	33500
Annual	Million euro	Private pension schemes	Employers' actual pension contributions	Netherlands	2012	18860
Annual	Million euro	Private pension schemes	Employers' actual pension contributions	Sweden	2012	18348
Annual	Million euro	Private pension schemes	Employers' imputed pension contributions	Germany	2012	1270
Annual	Million euro	Private pension schemes	Employers' imputed pension contributions	Netherlands	2012	-684
Annual	Million euro	Private pension schemes	Employers' imputed pension contributions	Sweden	2012
Annual	Million euro	Private pension schemes	Households' actual pension contributions	Switzerland	2012	14791
Annual	Million euro	Private pension schemes	Households' actual pension contributions	Germany	2012	51260
Annual	Million euro	Private pension schemes	Households' actual pension contributions	Netherlands	2012	11231


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "penscheme" VARCHAR,
  "na_item" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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