Net Social Protection Benefits

Eurostat code: spr_net_ben$dv_1622

@eurostat.spr_net_ben_dv_1622

Table List

2 tables(25.13 KB)

Net Social Protection Benefits - Unpivoted

Net Social Protection Benefits - Unpivoted

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

9.67 KB
710 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 - percentage of GDP	All schemes	Total expenditure	Austria	2012	29.1
Annual	Gross social protection - percentage of GDP	All schemes	Total expenditure	Bosnia and Herzegovina	2012
Annual	Gross social protection - percentage of GDP	All schemes	Total expenditure	Belgium	2012	29.69
Annual	Gross social protection - percentage of GDP	All schemes	Total expenditure	Bulgaria	2012	16.46
Annual	Gross social protection - percentage of GDP	All schemes	Total expenditure	Switzerland	2012	24.94
Annual	Gross social protection - percentage of GDP	All schemes	Total expenditure	Cyprus	2012	20.83
Annual	Gross social protection - percentage of GDP	All schemes	Total expenditure	Czechia	2012	20.33
Annual	Gross social protection - percentage of GDP	All schemes	Total expenditure	Germany	2012	28.88
Annual	Gross social protection - percentage of GDP	All schemes	Total expenditure	Denmark	2012	33.65
Annual	Gross social protection - percentage of GDP	All schemes	Total expenditure	Estonia	2012	15.02


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.