Baselight
Sign In

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

Eurostat code: ilc_lvhd03 · (2023 - 2023)

@eurostat.ilc_lvhd03

Persons Having Experienced Housing Difficulties In Their Lifetime By Sex And Group Of Country Of Birth - Unpivoted
@eurostat.ilc_lvhd03.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.76 KB
  • 370 rows
  • 7 columns
freq

Freq

c_birth

C Birth

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageAustria20237.1
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageBelgium20234.9
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageSwitzerland202311.8
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageCyprus20231.7
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageCzechia20233
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageGermany20235.7
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageDenmark20238.9
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageEuro area – 20 countries (from 2023)20237.5
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageEstonia20234.7
AnnualEU27 countries (from 2020) except reporting countryFemalesPercentageGreece20233.8

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