Baselight
Sign In

Social Contributions By Type Of Contributors

Eurostat code: spr_rec_scon ยท (1990 - 2022)

@eurostat.spr_rec_scon

Social Contributions By Type Of Contributors - Unpivoted
@eurostat.spr_rec_scon.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.

  • 538.56 KB
  • 96300 rows
  • 6 columns
freq

Freq

contrib

Contrib

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEmployerEuro per inhabitantAustria19901732.12
AnnualEmployerEuro per inhabitantBelgium19901842.26
AnnualEmployerEuro per inhabitantSwitzerland19902496.38
AnnualEmployerEuro per inhabitantDenmark1990508
AnnualEmployerEuro per inhabitantGreece1990591.3
AnnualEmployerEuro per inhabitantSpain19901113.6
AnnualEmployerEuro per inhabitantFinland19902803.76
AnnualEmployerEuro per inhabitantFrance19902437.39
AnnualEmployerEuro per inhabitantIreland1990473.39
AnnualEmployerEuro per inhabitantIceland1990921.52

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