Baselight

Persons Having Experienced Renting Difficulties In The Last 12 Months By Income Quintile, Household Composition And Degree Of Urbanization

Eurostat code: ilc_lvhd13 · (2023 - 2023)

@eurostat.ilc_lvhd13

Persons Having Experienced Renting Difficulties In The Last 12 Months By Income Quintile, Household Composition And Degree Of Urbanization - Unpivoted
@eurostat.ilc_lvhd13.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.

  • 14.52 KB
  • 3951 rows
  • 8 columns
freq

Freq

deg_urb

Deg Urb

hhcomp

Hhcomp

quant_inc

Quant Inc

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualCitiesOne adultFirst quintilePercentageAustria202324.6
AnnualCitiesOne adultFirst quintilePercentageBelgium20234
AnnualCitiesOne adultFirst quintilePercentageCyprus20236.7
AnnualCitiesOne adultFirst quintilePercentageCzechia202313.8
AnnualCitiesOne adultFirst quintilePercentageGermany20237.9
AnnualCitiesOne adultFirst quintilePercentageDenmark202324.7
AnnualCitiesOne adultFirst quintilePercentageEuro area – 20 countries (from 2023)202315.1
AnnualCitiesOne adultFirst quintilePercentageEstonia202311.1
AnnualCitiesOne adultFirst quintilePercentageGreece202339.2
AnnualCitiesOne adultFirst quintilePercentageSpain202332.9

CREATE TABLE tidy (
  "freq" VARCHAR,
  "deg_urb" VARCHAR,
  "hhcomp" VARCHAR,
  "quant_inc" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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