Baselight
Sign In

Energy Removed From District Networks By Customers, Type Of Networks And Efficiency Of Network

Eurostat code: nrg_dhdc_e ยท (2019 - 2022)

@eurostat.nrg_dhdc_e

Energy Removed From District Networks By Customers, Type Of Networks And Efficiency Of Network - Unpivoted
@eurostat.nrg_dhdc_e.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.

  • 11.32 KB
  • 875 rows
  • 8 columns
freq

Freq

unit

Unit

customer

Customer

lev_efcy

Lev Efcy

network

Network

geo

Geo

time_period

Time Period

value

Value

AnnualTerajouleIndustrialHighDistrict coolingEstonia2019
AnnualTerajouleIndustrialHighDistrict coolingItaly20190.72
AnnualTerajouleIndustrialHighDistrict heatingAustria2019904.748
AnnualTerajouleIndustrialHighDistrict heatingBulgaria20192724
AnnualTerajouleIndustrialHighDistrict heatingDenmark20193960.814
AnnualTerajouleIndustrialHighDistrict heatingFinland201910707
AnnualTerajouleIndustrialHighDistrict heatingFrance20192561.776
AnnualTerajouleIndustrialHighDistrict heatingItaly2019693.099
AnnualTerajouleIndustrialHighDistrict heatingRomania20197477.498
AnnualTerajouleIndustrialHighDistrict heating - hot waterAustria2019904.748

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "customer" VARCHAR,
  "lev_efcy" VARCHAR,
  "network" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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