Baselight
Sign In

Persons Living In A Dwelling Not Comfortably Warm During Winter By Sex, Household Composition And Degree Of Urbanisation

Eurostat code: ilc_lvhe12 ยท (2023 - 2023)

@eurostat.ilc_lvhe12

Persons Living In A Dwelling Not Comfortably Warm During Winter By Sex, Household Composition And Degree Of Urbanisation - Unpivoted
@eurostat.ilc_lvhe12.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.

  • 15.32 KB
  • 5786 rows
  • 8 columns
freq

Freq

sex

Sex

deg_urb

Deg Urb

hhcomp

Hhcomp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesCitiesOne adultPercentageAustria20237
AnnualFemalesCitiesOne adultPercentageBelgium20238.5
AnnualFemalesCitiesOne adultPercentageBulgaria202325.6
AnnualFemalesCitiesOne adultPercentageCyprus202322.8
AnnualFemalesCitiesOne adultPercentageCzechia202311.8
AnnualFemalesCitiesOne adultPercentageGermany202315.1
AnnualFemalesCitiesOne adultPercentageEstonia20233.5
AnnualFemalesCitiesOne adultPercentageGreece202333.6
AnnualFemalesCitiesOne adultPercentageSpain202332.2
AnnualFemalesCitiesOne adultPercentageEuropean Union - 27 countries (from 2020)202321.6

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

Share link

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