Net Social Protection Benefits

Eurostat code: spr_net_ben · (2007 - 2021)

@eurostat.spr_net_ben

Table List

2 tables(690.39 KB)

Net Social Protection Benefits - Unpivoted

Net Social Protection Benefits - Unpivoted

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

309.99 KB
83450 rows
7 columns

freq Freq	indic_sp Indic Sp	spscheme Spscheme	spdeps Spdeps	geo Geo	time_period Time Period	value Value
Annual	Gross social protection - million euro	All schemes	Disability	Austria	2007	5417.95
Annual	Gross social protection - million euro	All schemes	Disability	Bosnia and Herzegovina	2007
Annual	Gross social protection - million euro	All schemes	Disability	Belgium	2007	5760.87
Annual	Gross social protection - million euro	All schemes	Disability	Bulgaria	2007	348.65
Annual	Gross social protection - million euro	All schemes	Disability	Switzerland	2007	9103.17
Annual	Gross social protection - million euro	All schemes	Disability	Cyprus	2007	105.48
Annual	Gross social protection - million euro	All schemes	Disability	Czechia	2007	1891.23
Annual	Gross social protection - million euro	All schemes	Disability	Germany	2007	45592.14
Annual	Gross social protection - million euro	All schemes	Disability	Denmark	2007	11636.42
Annual	Gross social protection - million euro	All schemes	Disability	Euro area - 12 countries (2001-2006)	2007	162739.72


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_sp" VARCHAR,
  "spscheme" VARCHAR,
  "spdeps" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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