Pension Beneficiaries By Type Of Pension, Sex And Means-testing

Eurostat code: spr_pns_ben · (2006 - 2022)

@eurostat.spr_pns_ben

Table List

2 tables(341.67 KB)

Pension Beneficiaries By Type Of Pension, Sex And Means-testing - Raw

Pension Beneficiaries By Type Of Pension, Sex And Means-testing - Unpivoted

Pension Beneficiaries By Type Of Pension, Sex And Means-testing - Unpivoted

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

173.34 KB
33296 rows
9 columns

freq Freq	spdepm Spdepm	spscheme Spscheme	spdepb Spdepb	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Means-tested	All schemes	Anticipated old age pension	Females	Person	Austria	2006	996
Annual	Means-tested	All schemes	Anticipated old age pension	Females	Person	Switzerland	2006
Annual	Means-tested	All schemes	Anticipated old age pension	Females	Person	Cyprus	2006
Annual	Means-tested	All schemes	Anticipated old age pension	Females	Person	Denmark	2006
Annual	Means-tested	All schemes	Anticipated old age pension	Females	Person	Estonia	2006
Annual	Means-tested	All schemes	Anticipated old age pension	Females	Person	Spain	2006	30317
Annual	Means-tested	All schemes	Anticipated old age pension	Females	Person	France	2006
Annual	Means-tested	All schemes	Anticipated old age pension	Females	Person	Lithuania	2006
Annual	Means-tested	All schemes	Anticipated old age pension	Females	Person	Malta	2006
Annual	Means-tested	All schemes	Anticipated old age pension	Females	Person	Portugal	2006


CREATE TABLE tidy (
  "freq" VARCHAR,
  "spdepm" VARCHAR,
  "spscheme" VARCHAR,
  "spdepb" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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