Severe Material Deprivation Rate By Income Quintile And Household Type

Eurostat code: ilc_mddd13 · (2003 - 2020)

@eurostat.ilc_mddd13

Table List

2 tables(263.11 KB)

Severe Material Deprivation Rate By Income Quintile And Household Type - Raw

Severe Material Deprivation Rate By Income Quintile And Household Type - Unpivoted

Severe Material Deprivation Rate By Income Quintile And Household Type - Unpivoted

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

106.91 KB
73715 rows
7 columns

freq Freq	unit Unit	hhtyp Hhtyp	quantile Quantile	geo Geo	time_period Time Period	value Value
Annual	Percentage	Single person	First quintile	Austria	2003	12.9
Annual	Percentage	Single person	First quintile	Belgium	2003	19.1
Annual	Percentage	Single person	First quintile	Denmark	2003	5.2
Annual	Percentage	Single person	First quintile	Greece	2003	55.3
Annual	Percentage	Single person	First quintile	Ireland	2003	11.3
Annual	Percentage	Single person	First quintile	Luxembourg	2003	6.8
Annual	Percentage	Single person	First quintile	Norway	2003	10.5
Annual	Percentage	Single person	Second quintile	Austria	2003	2.8
Annual	Percentage	Single person	Second quintile	Belgium	2003	11.1
Annual	Percentage	Single person	Second quintile	Denmark	2003	2.4


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

Share link

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