Baselight

Expenditure On Survivors Function By Type Of Benefit And Means-testing

Eurostat code: spr_exp_fsu ยท (1990 - 2022)

@eurostat.spr_exp_fsu

Expenditure On Survivors Function By Type Of Benefit And Means-testing - Unpivoted
@eurostat.spr_exp_fsu.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.

  • 964.76 KB
  • 387345 rows
  • 8 columns
freq

Freq

spscheme

Spscheme

spdep

Spdep

spdepm

Spdepm

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2010 prices)Denmark19900.02
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2010 prices)Finland19906.15
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2010 prices)France199098.29
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2010 prices)Norway1990137.57
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2015 prices)Denmark19900.02
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2015 prices)Finland19906.86
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2015 prices)France1990101.83
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2015 prices)Norway1990138.38
AnnualAll schemesCash benefitsMeans-testedMillion euro (at constant 2010 prices)Denmark19900.12
AnnualAll schemesCash benefitsMeans-testedMillion euro (at constant 2010 prices)Finland199030.65

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

Share link

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