Baselight
Sign In

Material Deprivation For The 'Economic Strain' And 'Durables' Dimensions, By Number Of Item Of Deprivation

Eurostat code: ilc_mddd03 ยท (2003 - 2020)

@eurostat.ilc_mddd03

Material Deprivation For The 'Economic Strain' And 'Durables' Dimensions, By Number Of Item Of Deprivation - Unpivoted
@eurostat.ilc_mddd03.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.

  • 268.11 KB
  • 194514 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 incomePercentageAustria200363.4
AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageBelgium200346.4
AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageDenmark200362.4
AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageGreece200325.9
AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageIreland200368.7
AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageLuxembourg200378.7
AnnualNo itemsSingle personAbove 60% of median equivalised incomePercentageNorway200368.2
AnnualNo itemsSingle personBelow 60% of median equivalised incomePercentageAustria200334.6
AnnualNo itemsSingle personBelow 60% of median equivalised incomePercentageBelgium200327.1
AnnualNo itemsSingle personBelow 60% of median equivalised incomePercentageDenmark200329.8

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.