Material Deprivation For The 'Housing' Dimension, By Household Type, Poverty Status And By Number Of Items Of Deprivation

Eurostat code: ilc_mddd04a · (2003 - 2023)

@eurostat.ilc_mddd04a

Table List

2 tables(545.68 KB)

Material Deprivation For The 'Housing' Dimension, By Household Type, Poverty Status And By Number Of Items Of Deprivation - Raw

Material Deprivation For The 'Housing' Dimension, By Household Type, Poverty Status And By Number Of Items Of Deprivation - Unpivoted

Material Deprivation For The 'Housing' Dimension, By Household Type, Poverty Status And By Number Of Items Of Deprivation - Unpivoted

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

230.14 KB
170245 rows
8 columns

freq Freq	unit Unit	n_item N Item	hhtyp Hhtyp	incgrp Incgrp	geo Geo	time_period Time Period	value Value
Annual	Percentage	No items	Single person	Above 60% of median equivalised income	Austria	2003	83.1
Annual	Percentage	No items	Single person	Above 60% of median equivalised income	Belgium	2003	73.6
Annual	Percentage	No items	Single person	Above 60% of median equivalised income	Denmark	2003	88.9
Annual	Percentage	No items	Single person	Above 60% of median equivalised income	Greece	2003	74.4
Annual	Percentage	No items	Single person	Above 60% of median equivalised income	Ireland	2003	77.4
Annual	Percentage	No items	Single person	Above 60% of median equivalised income	Luxembourg	2003	77.3
Annual	Percentage	No items	Single person	Above 60% of median equivalised income	Norway	2003	83.8
Annual	Percentage	No items	Single person	Below 60% of median equivalised income	Austria	2003	74.2
Annual	Percentage	No items	Single person	Below 60% of median equivalised income	Belgium	2003	66.6
Annual	Percentage	No items	Single person	Below 60% of median equivalised income	Denmark	2003	80.3


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

Share link

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