Baselight
Sign In

Persons Heating Their Dwelling With Other Than District Heating By Used Energy Source, Household Composition And Degree Of Urbanisation

Eurostat code: ilc_lvhe05 ยท (2023 - 2023)

@eurostat.ilc_lvhe05

Persons Heating Their Dwelling With Other Than District Heating By Used Energy Source, Household Composition And Degree Of Urbanisation - Unpivoted
@eurostat.ilc_lvhe05.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.

  • 30.35 KB
  • 15561 rows
  • 8 columns
freq

Freq

nrg_src

Nrg Src

deg_urb

Deg Urb

hhcomp

Hhcomp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualElectricityCitiesOne adultPercentageAustria202320.9
AnnualElectricityCitiesOne adultPercentageBelgium20238.5
AnnualElectricityCitiesOne adultPercentageBulgaria202374.9
AnnualElectricityCitiesOne adultPercentageSwitzerland20231.2
AnnualElectricityCitiesOne adultPercentageCyprus202375.9
AnnualElectricityCitiesOne adultPercentageCzechia202315.6
AnnualElectricityCitiesOne adultPercentageGermany20236.7
AnnualElectricityCitiesOne adultPercentageDenmark202318.9
AnnualElectricityCitiesOne adultPercentageEstonia202327.5
AnnualElectricityCitiesOne adultPercentageGreece202328.3

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