Supply, Transformation And Consumption Of Solid Fossil Fuels

Eurostat code: nrg_cb_sff · (1990 - 2023)

@eurostat.nrg_cb_sff

Table List

2 tables(2.04 MB)

Supply, Transformation And Consumption Of Solid Fossil Fuels - Raw

Supply, Transformation And Consumption Of Solid Fossil Fuels - Unpivoted

Supply, Transformation And Consumption Of Solid Fossil Fuels - Unpivoted

@eurostat.nrg_cb_sff.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.

978.08 KB
1451273 rows
7 columns

freq Freq	nrg_bal Nrg Bal	siec Siec	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Distribution losses	Solid fossil fuels	Thousand tonnes	Albania	1990
Annual	Distribution losses	Solid fossil fuels	Thousand tonnes	Austria	1990
Annual	Distribution losses	Solid fossil fuels	Thousand tonnes	Belgium	1990
Annual	Distribution losses	Solid fossil fuels	Thousand tonnes	Bulgaria	1990
Annual	Distribution losses	Solid fossil fuels	Thousand tonnes	Cyprus	1990
Annual	Distribution losses	Solid fossil fuels	Thousand tonnes	Czechia	1990
Annual	Distribution losses	Solid fossil fuels	Thousand tonnes	Germany	1990
Annual	Distribution losses	Solid fossil fuels	Thousand tonnes	Denmark	1990
Annual	Distribution losses	Solid fossil fuels	Thousand tonnes	Euro area – 20 countries (from 2023)	1990	33
Annual	Distribution losses	Solid fossil fuels	Thousand tonnes	Estonia	1990


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