Severe Material And Social Deprivation By Tenure Status

Eurostat code: ilc_mdsd17 · (2015 - 2024)

@eurostat.ilc_mdsd17

Table List

2 tables(26.07 KB)

Severe Material And Social Deprivation By Tenure Status - Raw

Severe Material And Social Deprivation By Tenure Status - Unpivoted

Severe Material And Social Deprivation By Tenure Status - Unpivoted

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

9.02 KB
1661 rows
6 columns

freq Freq	tenure Tenure	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Owner, with mortgage or loan	Percentage	Austria	2015	0.7
Annual	Owner, with mortgage or loan	Percentage	Belgium	2015	2.1
Annual	Owner, with mortgage or loan	Percentage	Bulgaria	2015	28.4
Annual	Owner, with mortgage or loan	Percentage	Switzerland	2015	0.1
Annual	Owner, with mortgage or loan	Percentage	Cyprus	2015	8.4
Annual	Owner, with mortgage or loan	Percentage	Czechia	2015	1.6
Annual	Owner, with mortgage or loan	Percentage	Germany	2015	1.9
Annual	Owner, with mortgage or loan	Percentage	Denmark	2015	0.9
Annual	Owner, with mortgage or loan	Percentage	Euro area – 20 countries (from 2023)	2015	3.8
Annual	Owner, with mortgage or loan	Percentage	Estonia	2015	0.6


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

Share link

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