Baselight
Sign In

Material Deprivation For The 'Durables' Dimension, By Number Of Item Of Deprivation

Eurostat code: ilc_mddd02 ยท (2003 - 2020)

@eurostat.ilc_mddd02

Material Deprivation For The 'Durables' Dimension, By Number Of Item Of Deprivation - Unpivoted
@eurostat.ilc_mddd02.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.

  • 229.35 KB
  • 194820 rows
  • 8 columns
freq

Freq

n_item

N Item

hhtyp

Hhtyp

incgrp

Incgrp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageAustria200382.5
AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageBelgium200375.5
AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageDenmark200383.7
AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageGreece200368
AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageIreland200381.6
AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageLuxembourg200394.3
AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageNorway200383.2
AnnualNo itemsSingle personBelow 60% of median equivalised incomePercentageAustria200368.1
AnnualNo itemsSingle personBelow 60% of median equivalised incomePercentageBelgium200362
AnnualNo itemsSingle personBelow 60% of median equivalised incomePercentageDenmark200354.2

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

Share link

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