Severe Housing Deprivation Rate By Tenure Status

Eurostat code: tepsr_lm440 · (2005 - 2023)

@eurostat.tepsr_lm440

Table List

2 tables(28.29 KB)

Severe Housing Deprivation Rate By Tenure Status - Raw

Severe Housing Deprivation Rate By Tenure Status - Unpivoted

Severe Housing Deprivation Rate By Tenure Status - Unpivoted

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

8.22 KB
1108 rows
7 columns

freq Freq	unit Unit	deg_urb Deg Urb	tenure Tenure	geo Geo	time_period Time Period	value Value
Annual	Percentage	Total	Owner, with mortgage or loan	Belgium	2005	0.5
Annual	Percentage	Total	Owner, with mortgage or loan	Czechia	2005	7.2
Annual	Percentage	Total	Owner, with mortgage or loan	Germany	2005	0.6
Annual	Percentage	Total	Owner, with mortgage or loan	Denmark	2005	0.4
Annual	Percentage	Total	Owner, with mortgage or loan	Euro area - 19 countries (2015-2022)	2005	1.4
Annual	Percentage	Total	Owner, with mortgage or loan	Finland	2005	0.1
Annual	Percentage	Total	Owner, with mortgage or loan	France	2005	0.9
Annual	Percentage	Total	Owner, with mortgage or loan	Hungary	2005	17.1
Annual	Percentage	Total	Owner, with mortgage or loan	Ireland	2005	0.6
Annual	Percentage	Total	Owner, with mortgage or loan	Iceland	2005	0.7


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

Share link

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