Severe Material Deprivation Rate By Tenure Status

Eurostat code: ilc_mddd17 · (2003 - 2020)

@eurostat.ilc_mddd17

Table List

2 tables(39.28 KB)

Severe Material Deprivation Rate By Tenure Status - Raw

Severe Material Deprivation Rate By Tenure Status - Unpivoted

Severe Material Deprivation Rate By Tenure Status - Unpivoted

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

11.43 KB
3071 rows
6 columns

freq Freq	unit Unit	tenure Tenure	geo Geo	time_period Time Period	value Value
Annual	Percentage	Owner, with mortgage or loan	Belgium	2003	1.2
Annual	Percentage	Owner, with mortgage or loan	Denmark	2003	0.2
Annual	Percentage	Owner, with mortgage or loan	Ireland	2003	1.1
Annual	Percentage	Owner, with mortgage or loan	Norway	2003	1.6
Annual	Percentage	Owner, no outstanding mortgage or housing loan	Belgium	2003	0.8
Annual	Percentage	Owner, no outstanding mortgage or housing loan	Denmark	2003	0.1
Annual	Percentage	Owner, no outstanding mortgage or housing loan	Greece	2003	14.5
Annual	Percentage	Owner, no outstanding mortgage or housing loan	Ireland	2003	2.5
Annual	Percentage	Owner, no outstanding mortgage or housing loan	Norway	2003	1.4
Annual	Percentage	Tenant, rent at reduced price or free	Belgium	2003	10


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

Share link

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