Persons Having Experienced Housing Difficulties In Their Lifetime By Sex And Type Of Temporary Solution (effect)

Eurostat code: ilc_lvhd02 · (2023 - 2023)

@eurostat.ilc_lvhd02

Table List

2 tables(13.42 KB)

Persons Having Experienced Housing Difficulties In Their Lifetime By Sex And Type Of Temporary Solution (effect) - Raw

Persons Having Experienced Housing Difficulties In Their Lifetime By Sex And Type Of Temporary Solution (effect) - Unpivoted

Persons Having Experienced Housing Difficulties In Their Lifetime By Sex And Type Of Temporary Solution (effect) - Unpivoted

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

7 KB
384 rows
7 columns

freq Freq	effect Effect	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Slept outside (public space)	Females	Percentage	Austria	2023	3.1
Annual	Slept outside (public space)	Females	Percentage	Belgium	2023	2.8
Annual	Slept outside (public space)	Females	Percentage	Bulgaria	2023	1.8
Annual	Slept outside (public space)	Females	Percentage	Switzerland	2023	1
Annual	Slept outside (public space)	Females	Percentage	Cyprus	2023	2.1
Annual	Slept outside (public space)	Females	Percentage	Czechia	2023	2.5
Annual	Slept outside (public space)	Females	Percentage	Germany	2023	2.9
Annual	Slept outside (public space)	Females	Percentage	Denmark	2023	0.9
Annual	Slept outside (public space)	Females	Percentage	Euro area – 20 countries (from 2023)	2023	3
Annual	Slept outside (public space)	Females	Percentage	Estonia	2023	2.6


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

Share link

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