Baselight
Sign In

Persons Having Experienced Housing Difficulties In Their Lifetime By Sex And Group Of Current Country Of Citizenship

Eurostat code: ilc_lvhd04 · (2023 - 2023)

@eurostat.ilc_lvhd04

Persons Having Experienced Housing Difficulties In Their Lifetime By Sex And Group Of Current Country Of Citizenship - Unpivoted
@eurostat.ilc_lvhd04.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.69 KB
  • 344 rows
  • 7 columns
freq

Freq

citizen

Citizen

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageAustria20235.8
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageBelgium20234.1
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageSwitzerland202313.6
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageCyprus20232.1
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageCzechia20231.5
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageGermany20235.4
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageDenmark20235
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageEuro area – 20 countries (from 2023)20237.6
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageEstonia20236.8
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageGreece20238.3

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