Baselight

Number Of Combined Heat And Power (CHP) Units By Type Of Plant, Generation Technologies And Primary Energy Savings Levels

Eurostat code: nrg_chp_n ยท (2017 - 2023)

@eurostat.nrg_chp_n

Number Of Combined Heat And Power (CHP) Units By Type Of Plant, Generation Technologies And Primary Energy Savings Levels - Unpivoted
@eurostat.nrg_chp_n.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.59 KB
  • 3781 rows
  • 8 columns
freq

Freq

unit

Unit

plants

Plants

gen_tech

Gen Tech

lev_efcy

Lev Efcy

geo

Geo

time_period

Time Period

value

Value

AnnualNumberCombined heat and power unitsTotalHighAustria2017243
AnnualNumberCombined heat and power unitsTotalHighBelgium2017915
AnnualNumberCombined heat and power unitsTotalHighBulgaria201768
AnnualNumberCombined heat and power unitsTotalHighCyprus201723
AnnualNumberCombined heat and power unitsTotalHighCzechia2017889
AnnualNumberCombined heat and power unitsTotalHighGermany20172669
AnnualNumberCombined heat and power unitsTotalHighDenmark2017696
AnnualNumberCombined heat and power unitsTotalHighEstonia201717
AnnualNumberCombined heat and power unitsTotalHighGreece201727
AnnualNumberCombined heat and power unitsTotalHighSpain2017511

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

Share link

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