Baselight
Sign In

Persons Having Experienced Housing Difficulties In Their Lifetime By Sex And Current Risk Of Poverty Or Social Exclusion Situation

Eurostat code: ilc_lvhd01 · (2023 - 2023)

@eurostat.ilc_lvhd01

Persons Having Experienced Housing Difficulties In Their Lifetime By Sex And Current Risk Of Poverty Or Social Exclusion Situation - Unpivoted
@eurostat.ilc_lvhd01.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.

  • 6.35 KB
  • 288 rows
  • 7 columns
freq

Freq

yn_arope

Yn Arope

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualNot at risk of poverty or social exclusionFemalesPercentageAustria20233.7
AnnualNot at risk of poverty or social exclusionFemalesPercentageBelgium20233
AnnualNot at risk of poverty or social exclusionFemalesPercentageBulgaria20230.9
AnnualNot at risk of poverty or social exclusionFemalesPercentageSwitzerland202311.3
AnnualNot at risk of poverty or social exclusionFemalesPercentageCyprus202310.6
AnnualNot at risk of poverty or social exclusionFemalesPercentageCzechia20232.9
AnnualNot at risk of poverty or social exclusionFemalesPercentageGermany20233.8
AnnualNot at risk of poverty or social exclusionFemalesPercentageDenmark20237.5
AnnualNot at risk of poverty or social exclusionFemalesPercentageEuro area – 20 countries (from 2023)20234.2
AnnualNot at risk of poverty or social exclusionFemalesPercentageEstonia20234

CREATE TABLE tidy (
  "freq" VARCHAR,
  "yn_arope" 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.