Baselight

Expenditure On Sickness And Health Care Function By Type Of Benefit And Means-testing

Eurostat code: spr_exp_fsi ยท (1990 - 2022)

@eurostat.spr_exp_fsi

Expenditure On Sickness And Health Care Function By Type Of Benefit And Means-testing - Unpivoted
@eurostat.spr_exp_fsi.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.61 MB
  • 598938 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)Denmark1990
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2010 prices)Finland1990
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2010 prices)France19904.54
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2010 prices)Norway1990
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2015 prices)Denmark1990
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2015 prices)Finland1990
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2015 prices)France19904.7
AnnualAll schemesCash benefitsMeans-testedEuro per inhabitant (at constant 2015 prices)Norway1990
AnnualAll schemesCash benefitsMeans-testedMillion euro (at constant 2010 prices)Denmark1990
AnnualAll schemesCash benefitsMeans-testedMillion euro (at constant 2010 prices)Finland1990

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.