Share Of Total Population Living In A Dwelling With A Leaking Roof, Damp Walls, Floors Or Foundation, Or Rot In Window Frames Of Floor - EU-SILC Survey

Eurostat code: tessi292 · (2010 - 2023)

@eurostat.tessi292

Table List

2 tables(28.08 KB)

Share Of Total Population Living In A Dwelling With A Leaking Roof, Damp Walls, Floors Or Foundation, Or Rot In Window Frames Of Floor - EU-SILC Survey - Raw

Share Of Total Population Living In A Dwelling With A Leaking Roof, Damp Walls, Floors Or Foundation, Or Rot In Window Frames Of Floor - EU-SILC Survey - Unpivoted

Share Of Total Population Living In A Dwelling With A Leaking Roof, Damp Walls, Floors Or Foundation, Or Rot In Window Frames Of Floor - EU-SILC Survey - Unpivoted

@eurostat.tessi292.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.61 KB
1362 rows
9 columns

freq Freq	hhtyp Hhtyp	incgrp Incgrp	unit Unit	age Age	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Total	Total	Percentage	Total	Females	Austria	2010	14.9
Annual	Total	Total	Percentage	Total	Females	Belgium	2010	19.2
Annual	Total	Total	Percentage	Total	Females	Bulgaria	2010	15.8
Annual	Total	Total	Percentage	Total	Females	Switzerland	2010	9
Annual	Total	Total	Percentage	Total	Females	Cyprus	2010	29.1
Annual	Total	Total	Percentage	Total	Females	Czechia	2010	11.9
Annual	Total	Total	Percentage	Total	Females	Germany	2010	13.7
Annual	Total	Total	Percentage	Total	Females	Denmark	2010	8.4
Annual	Total	Total	Percentage	Total	Females	Euro area - 19 countries (2015-2022)	2010	16.6
Annual	Total	Total	Percentage	Total	Females	Estonia	2010	18.7


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

Share link

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