Baselight

Persons Living In Private Households By Heating System Used In The Dwelling, Household Composition And Degree Of Urbanisation

Eurostat code: ilc_lvhe02 ยท (2023 - 2023)

@eurostat.ilc_lvhe02

Persons Living In Private Households By Heating System Used In The Dwelling, Household Composition And Degree Of Urbanisation - Unpivoted
@eurostat.ilc_lvhe02.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.

  • 26.55 KB
  • 12498 rows
  • 8 columns
freq

Freq

amenity

Amenity

deg_urb

Deg Urb

hhcomp

Hhcomp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualDistrict heating network/teleheatingCitiesOne adultPercentageAustria202352.8
AnnualDistrict heating network/teleheatingCitiesOne adultPercentageBelgium20230.7
AnnualDistrict heating network/teleheatingCitiesOne adultPercentageBulgaria202340.5
AnnualDistrict heating network/teleheatingCitiesOne adultPercentageCyprus2023
AnnualDistrict heating network/teleheatingCitiesOne adultPercentageCzechia202375.1
AnnualDistrict heating network/teleheatingCitiesOne adultPercentageGermany202326.3
AnnualDistrict heating network/teleheatingCitiesOne adultPercentageDenmark202392.9
AnnualDistrict heating network/teleheatingCitiesOne adultPercentageEstonia202380.1
AnnualDistrict heating network/teleheatingCitiesOne adultPercentageGreece20230.1
AnnualDistrict heating network/teleheatingCitiesOne adultPercentageSpain20230.7

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