Baselight

Production Of Electricity And Heat By Autoproducers, By Type Of Plant

Eurostat code: nrg_ind_pehap · (1990 - 2023)

@eurostat.nrg_ind_pehap

Production Of Electricity And Heat By Autoproducers, By Type Of Plant - Unpivoted
@eurostat.nrg_ind_pehap.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.

  • 419.23 KB
  • 329653 rows
  • 9 columns
freq

Freq

plants

Plants

operator

Operator

nrg_bal

Nrg Bal

siec

Siec

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualCombined heat and power (CHP)AutoproducersFinal consumption - industry sector - construction - energy useElectricityGigawatt-hourAlbania1990
AnnualCombined heat and power (CHP)AutoproducersFinal consumption - industry sector - construction - energy useElectricityGigawatt-hourAustria1990
AnnualCombined heat and power (CHP)AutoproducersFinal consumption - industry sector - construction - energy useElectricityGigawatt-hourBelgium1990
AnnualCombined heat and power (CHP)AutoproducersFinal consumption - industry sector - construction - energy useElectricityGigawatt-hourBulgaria1990
AnnualCombined heat and power (CHP)AutoproducersFinal consumption - industry sector - construction - energy useElectricityGigawatt-hourSwitzerland1990
AnnualCombined heat and power (CHP)AutoproducersFinal consumption - industry sector - construction - energy useElectricityGigawatt-hourCyprus1990
AnnualCombined heat and power (CHP)AutoproducersFinal consumption - industry sector - construction - energy useElectricityGigawatt-hourCzechia1990
AnnualCombined heat and power (CHP)AutoproducersFinal consumption - industry sector - construction - energy useElectricityGigawatt-hourGermany1990
AnnualCombined heat and power (CHP)AutoproducersFinal consumption - industry sector - construction - energy useElectricityGigawatt-hourDenmark1990
AnnualCombined heat and power (CHP)AutoproducersFinal consumption - industry sector - construction - energy useElectricityGigawatt-hourEuro area – 20 countries (from 2023)1990

CREATE TABLE tidy (
  "freq" VARCHAR,
  "plants" VARCHAR,
  "operator" VARCHAR,
  "nrg_bal" VARCHAR,
  "siec" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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