Expenditure On Social Protection By Type Of Expenditure

Eurostat code: spr_exp_type · (1990 - 2022)

@eurostat.spr_exp_type

Table List

2 tables(621.77 KB)

Expenditure On Social Protection By Type Of Expenditure - Raw

Expenditure On Social Protection By Type Of Expenditure - Unpivoted

Expenditure On Social Protection By Type Of Expenditure - Unpivoted

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

298.1 KB
51440 rows
6 columns

freq Freq	spdeps Spdeps	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Administration costs	Euro per inhabitant	Austria	1990	94.46
Annual	Administration costs	Euro per inhabitant	Belgium	1990	132.25
Annual	Administration costs	Euro per inhabitant	Switzerland	1990	248.38
Annual	Administration costs	Euro per inhabitant	Denmark	1990	169.22
Annual	Administration costs	Euro per inhabitant	Greece	1990	75.49
Annual	Administration costs	Euro per inhabitant	Spain	1990	50.88
Annual	Administration costs	Euro per inhabitant	Finland	1990	187.95
Annual	Administration costs	Euro per inhabitant	France	1990	207.53
Annual	Administration costs	Euro per inhabitant	Ireland	1990	85.58
Annual	Administration costs	Euro per inhabitant	Iceland	1990	64.3


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

Share link

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