Housing Deprivation Rate By Number Of Item - EU-SILC Survey

Eurostat code: tessi291 · (2010 - 2023)

@eurostat.tessi291

Table List

2 tables(31.72 KB)

Housing Deprivation Rate By Number Of Item - EU-SILC Survey - Raw

Housing Deprivation Rate By Number Of Item - EU-SILC Survey - Unpivoted

Housing Deprivation Rate By Number Of Item - EU-SILC Survey - Unpivoted

@eurostat.tessi291.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.08 KB
2265 rows
8 columns

freq Freq	unit Unit	incgrp Incgrp	hhtyp Hhtyp	n_item N Item	geo Geo	time_period Time Period	value Value
Annual	Percentage	Total	Total	No items	Austria	2010	80.3
Annual	Percentage	Total	Total	No items	Belgium	2010	75.8
Annual	Percentage	Total	Total	No items	Bulgaria	2010	66.1
Annual	Percentage	Total	Total	No items	Switzerland	2010	87.2
Annual	Percentage	Total	Total	No items	Cyprus	2010	67.5
Annual	Percentage	Total	Total	No items	Czechia	2010	85.8
Annual	Percentage	Total	Total	No items	Germany	2010	82.9
Annual	Percentage	Total	Total	No items	Denmark	2010	88.4
Annual	Percentage	Total	Total	No items	Euro area - 19 countries (2015-2022)	2010	79.4
Annual	Percentage	Total	Total	No items	Estonia	2010	71.7


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

Share link

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