Expenditure On Social Benefits By Function, Type Of Benefit And Means-testing

Eurostat code: spr_exp_ftm · (1990 - 2022)

@eurostat.spr_exp_ftm

Table List

2 tables(16.42 MB)

Expenditure On Social Benefits By Function, Type Of Benefit And Means-testing - Raw

Expenditure On Social Benefits By Function, Type Of Benefit And Means-testing - Unpivoted

Expenditure On Social Benefits By Function, Type Of Benefit And Means-testing - Unpivoted

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

8.02 MB
2178750 rows
9 columns

freq Freq	spfunc Spfunc	spscheme Spscheme	spdep Spdep	spdepm Spdepm	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Disability	All schemes	Cash benefits	Means-tested	Euro per inhabitant	Austria	1990	9.24
Annual	Disability	All schemes	Cash benefits	Means-tested	Euro per inhabitant	Belgium	1990	63.07
Annual	Disability	All schemes	Cash benefits	Means-tested	Euro per inhabitant	Switzerland	1990	10.03
Annual	Disability	All schemes	Cash benefits	Means-tested	Euro per inhabitant	Denmark	1990
Annual	Disability	All schemes	Cash benefits	Means-tested	Euro per inhabitant	Greece	1990
Annual	Disability	All schemes	Cash benefits	Means-tested	Euro per inhabitant	Spain	1990	22.95
Annual	Disability	All schemes	Cash benefits	Means-tested	Euro per inhabitant	Finland	1990	104.26
Annual	Disability	All schemes	Cash benefits	Means-tested	Euro per inhabitant	France	1990	43.23
Annual	Disability	All schemes	Cash benefits	Means-tested	Euro per inhabitant	Ireland	1990	26.5
Annual	Disability	All schemes	Cash benefits	Means-tested	Euro per inhabitant	Iceland	1990


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

Share link

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