Social Protection Receipts By Type

Eurostat code: spr_rec_sumt · (1990 - 2022)

@eurostat.spr_rec_sumt

Table List

2 tables(1.3 MB)

Social Protection Receipts By Type - Raw

Social Protection Receipts By Type - Unpivoted

Social Protection Receipts By Type - Unpivoted

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

644.51 KB
120124 rows
6 columns

freq Freq	sptype Sptype	unit Unit	geo Geo	time_period Time Period	value Value
Annual	General government contributions	Euro per inhabitant	Austria	1990	1525.46
Annual	General government contributions	Euro per inhabitant	Belgium	1990	1054.36
Annual	General government contributions	Euro per inhabitant	Switzerland	1990	1427.37
Annual	General government contributions	Euro per inhabitant	Denmark	1990	5182.87
Annual	General government contributions	Euro per inhabitant	Greece	1990	494.93
Annual	General government contributions	Euro per inhabitant	Spain	1990	535.77
Annual	General government contributions	Euro per inhabitant	Finland	1990	2579.88
Annual	General government contributions	Euro per inhabitant	France	1990	836.05
Annual	General government contributions	Euro per inhabitant	Ireland	1990	1140.44
Annual	General government contributions	Euro per inhabitant	Iceland	1990	2505.85


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

Share link

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