Social Protection Receipts By Institutional Sector

Eurostat code: spr_rec_sums · (1990 - 2022)

@eurostat.spr_rec_sums

Table List

2 tables(1.04 MB)

Social Protection Receipts By Institutional Sector - Raw

Social Protection Receipts By Institutional Sector - Unpivoted

Social Protection Receipts By Institutional Sector - Unpivoted

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

499.05 KB
96004 rows
6 columns

freq Freq	sector Sector	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Corporations	Euro per inhabitant	Austria	1990	1546
Annual	Corporations	Euro per inhabitant	Belgium	1990	1551.71
Annual	Corporations	Euro per inhabitant	Switzerland	1990	3584.16
Annual	Corporations	Euro per inhabitant	Denmark	1990	279.11
Annual	Corporations	Euro per inhabitant	Greece	1990	431.3
Annual	Corporations	Euro per inhabitant	Spain	1990	883.65
Annual	Corporations	Euro per inhabitant	Finland	1990
Annual	Corporations	Euro per inhabitant	France	1990	1795.06
Annual	Corporations	Euro per inhabitant	Ireland	1990	290.19
Annual	Corporations	Euro per inhabitant	Iceland	1990	572.21


CREATE TABLE tidy (
  "freq" 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.