Expenditure On Family/children Function By Type Of Benefit And Means-testing

Eurostat code: spr_exp_ffa · (1990 - 2022)

@eurostat.spr_exp_ffa

Table List

2 tables(3.59 MB)

Expenditure On Family/children Function By Type Of Benefit And Means-testing - Raw

Expenditure On Family/children Function By Type Of Benefit And Means-testing - Unpivoted

Expenditure On Family/children Function By Type Of Benefit And Means-testing - Unpivoted

@eurostat.spr_exp_ffa.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.72 MB
566220 rows
8 columns

freq Freq	spscheme Spscheme	spdep Spdep	spdepm Spdepm	unit Unit	geo Geo	time_period Time Period	value Value
Annual	All schemes	Cash benefits	Means-tested	Euro per inhabitant (at constant 2010 prices)	Denmark	1990
Annual	All schemes	Cash benefits	Means-tested	Euro per inhabitant (at constant 2010 prices)	Finland	1990	15.97
Annual	All schemes	Cash benefits	Means-tested	Euro per inhabitant (at constant 2010 prices)	France	1990	145.14
Annual	All schemes	Cash benefits	Means-tested	Euro per inhabitant (at constant 2010 prices)	Norway	1990	89.14
Annual	All schemes	Cash benefits	Means-tested	Euro per inhabitant (at constant 2015 prices)	Denmark	1990
Annual	All schemes	Cash benefits	Means-tested	Euro per inhabitant (at constant 2015 prices)	Finland	1990	17.82
Annual	All schemes	Cash benefits	Means-tested	Euro per inhabitant (at constant 2015 prices)	France	1990	150.37
Annual	All schemes	Cash benefits	Means-tested	Euro per inhabitant (at constant 2015 prices)	Norway	1990	89.67
Annual	All schemes	Cash benefits	Means-tested	Million euro (at constant 2010 prices)	Denmark	1990
Annual	All schemes	Cash benefits	Means-tested	Million euro (at constant 2010 prices)	Finland	1990	79.63


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.