Baselight
Sign In

Persons Living In Dwellings Whose Energy Efficiency Had Been Improved In The Last 5 Years By Current Household Composition And Degree Of Urbanisation

Eurostat code: ilc_lvhe09 ยท (2023 - 2023)

@eurostat.ilc_lvhe09

Persons Living In Dwellings Whose Energy Efficiency Had Been Improved In The Last 5 Years By Current Household Composition And Degree Of Urbanisation - Unpivoted
@eurostat.ilc_lvhe09.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.

  • 17.8 KB
  • 6033 rows
  • 8 columns
freq

Freq

yes_no

Yes No

deg_urb

Deg Urb

hhcomp

Hhcomp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualNoCitiesOne adultPercentageAustria202382.8
AnnualNoCitiesOne adultPercentageBelgium202378.9
AnnualNoCitiesOne adultPercentageBulgaria202377.1
AnnualNoCitiesOne adultPercentageCyprus202390.3
AnnualNoCitiesOne adultPercentageCzechia202389.1
AnnualNoCitiesOne adultPercentageGermany202360.8
AnnualNoCitiesOne adultPercentageEstonia202357.5
AnnualNoCitiesOne adultPercentageGreece202390.3
AnnualNoCitiesOne adultPercentageSpain202385.3
AnnualNoCitiesOne adultPercentageEuropean Union - 27 countries (from 2020)202371.8

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