Baselight
Sign In

Electricity Production And Self-consumption By Sector And Fuel

Eurostat code: nrg_ind_epsc ยท (1990 - 2023)

@eurostat.nrg_ind_epsc

Electricity Production And Self-consumption By Sector And Fuel - Unpivoted
@eurostat.nrg_ind_epsc.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.43 KB
  • 22495 rows
  • 8 columns
freq

Freq

customer

Customer

nrg_bal

Nrg Bal

siec

Siec

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualHouseholdAutoconsumptionNatural gasGigawatt-hourDenmark1990
AnnualHouseholdAutoconsumptionNatural gasGigawatt-hourSpain1990
AnnualHouseholdAutoconsumptionNatural gasGigawatt-hourIreland1990
AnnualHouseholdAutoconsumptionBiofuelsGigawatt-hourDenmark1990
AnnualHouseholdAutoconsumptionBiofuelsGigawatt-hourSpain1990
AnnualHouseholdAutoconsumptionBiofuelsGigawatt-hourIreland1990
AnnualHouseholdAutoconsumptionWindGigawatt-hourDenmark1990
AnnualHouseholdAutoconsumptionWindGigawatt-hourSpain1990
AnnualHouseholdAutoconsumptionWindGigawatt-hourIreland1990
AnnualHouseholdAutoconsumptionSolarGigawatt-hourDenmark1990

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