Expenditure On Social Benefits By Function

Eurostat code: spr_exp_func · (1990 - 2023)

@eurostat.spr_exp_func

Table List

2 tables(1.86 MB)

Expenditure On Social Benefits By Function - Raw

Expenditure On Social Benefits By Function - Unpivoted

Expenditure On Social Benefits By Function - Unpivoted

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

918.14 KB
156853 rows
7 columns

freq Freq	spdeps Spdeps	spfunc Spfunc	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Social protection benefits	Disability	Euro per inhabitant	Austria	1990	335.55
Annual	Social protection benefits	Disability	Euro per inhabitant	Belgium	1990	289.14
Annual	Social protection benefits	Disability	Euro per inhabitant	Switzerland	1990	505.72
Annual	Social protection benefits	Disability	Euro per inhabitant	Denmark	1990	568.67
Annual	Social protection benefits	Disability	Euro per inhabitant	Greece	1990	96.3
Annual	Social protection benefits	Disability	Euro per inhabitant	Spain	1990	153.97
Annual	Social protection benefits	Disability	Euro per inhabitant	Finland	1990	813.38
Annual	Social protection benefits	Disability	Euro per inhabitant	France	1990	300.42
Annual	Social protection benefits	Disability	Euro per inhabitant	Ireland	1990	84.18
Annual	Social protection benefits	Disability	Euro per inhabitant	Iceland	1990	276.64


CREATE TABLE tidy (
  "freq" VARCHAR,
  "spdeps" VARCHAR,
  "spfunc" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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