Social Protection Receipts By Type And Institutional Sector

Eurostat code: spr_rec_suts · (1990 - 2022)

@eurostat.spr_rec_suts

Table List

2 tables(2.74 MB)

Social Protection Receipts By Type And Institutional Sector - Raw

Social Protection Receipts By Type And Institutional Sector - Unpivoted

Social Protection Receipts By Type And Institutional Sector - Unpivoted

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

1.31 MB
322970 rows
8 columns

freq Freq	sptype Sptype	spscheme Spscheme	sector Sector	unit Unit	geo Geo	time_period Time Period	value Value
Annual	General government contributions	All schemes	Central government	Euro per inhabitant	Austria	1990	932.8
Annual	General government contributions	All schemes	Central government	Euro per inhabitant	Belgium	1990	149.22
Annual	General government contributions	All schemes	Central government	Euro per inhabitant	Switzerland	1990	598.6
Annual	General government contributions	All schemes	Central government	Euro per inhabitant	Denmark	1990	2937.3
Annual	General government contributions	All schemes	Central government	Euro per inhabitant	Greece	1990	482.95
Annual	General government contributions	All schemes	Central government	Euro per inhabitant	Spain	1990	500.77
Annual	General government contributions	All schemes	Central government	Euro per inhabitant	Finland	1990
Annual	General government contributions	All schemes	Central government	Euro per inhabitant	France	1990	687.99
Annual	General government contributions	All schemes	Central government	Euro per inhabitant	Ireland	1990	1074.45
Annual	General government contributions	All schemes	Central government	Euro per inhabitant	Iceland	1990	2259.24


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

Share link

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