Material Deprivation For The 'Housing' Dimension, By Age, Sex And By Number Of Item Of Deprivation

Eurostat code: ilc_mddd04b$dv_2721

@eurostat.ilc_mddd04b_dv_2721

Table List

2 tables(21.13 KB)

Material Deprivation For The 'Housing' Dimension, By Age, Sex And By Number Of Item Of Deprivation - Raw

Material Deprivation For The 'Housing' Dimension, By Age, Sex And By Number Of Item Of Deprivation - Unpivoted

Material Deprivation For The 'Housing' Dimension, By Age, Sex And By Number Of Item Of Deprivation - Unpivoted

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

7.78 KB
407 rows
8 columns

freq Freq	unit Unit	n_item N Item	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Percentage	No items	Total	Less than 18 years	Austria	2012	80.9
Annual	Percentage	No items	Total	Less than 18 years	Belgium	2012	73.6
Annual	Percentage	No items	Total	Less than 18 years	Bulgaria	2012	62.9
Annual	Percentage	No items	Total	Less than 18 years	Switzerland	2012	77.7
Annual	Percentage	No items	Total	Less than 18 years	Cyprus	2012	70.1
Annual	Percentage	No items	Total	Less than 18 years	Czechia	2012	86.5
Annual	Percentage	No items	Total	Less than 18 years	Germany	2012	80.8
Annual	Percentage	No items	Total	Less than 18 years	Denmark	2012	75.2
Annual	Percentage	No items	Total	Less than 18 years	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2012	79.6
Annual	Percentage	No items	Total	Less than 18 years	Euro area - 18 countries (2014)	2012	79.5


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

Share link

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