Disaggregated Final Energy Consumption In Transport By Mode Of Transport - Quantities

Eurostat code: nrg_d_traq · (2020 - 2022)

@eurostat.nrg_d_traq

Table List

2 tables(111.29 KB)

Disaggregated Final Energy Consumption In Transport By Mode Of Transport - Quantities - Raw

Disaggregated Final Energy Consumption In Transport By Mode Of Transport - Quantities - Unpivoted

Disaggregated Final Energy Consumption In Transport By Mode Of Transport - Quantities - Unpivoted

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

52.02 KB
54323 rows
8 columns

freq Freq	tra_mode Tra Mode	siec Siec	nrg_bal Nrg Bal	unit Unit	geo Geo	time_period Time Period
Annual	Freight	Solid fossil fuels	Final consumption - transport sector - domestic aviation - energy use	Thousand tonnes	Austria	2020
Annual	Freight	Solid fossil fuels	Final consumption - transport sector - domestic aviation - energy use	Thousand tonnes	Bulgaria	2020
Annual	Freight	Solid fossil fuels	Final consumption - transport sector - domestic aviation - energy use	Thousand tonnes	Denmark	2020
Annual	Freight	Solid fossil fuels	Final consumption - transport sector - domestic aviation - energy use	Thousand tonnes	Ireland	2020
Annual	Freight	Solid fossil fuels	Final consumption - transport sector - domestic aviation - energy use	Thousand tonnes	Montenegro	2020
Annual	Freight	Solid fossil fuels	Final consumption - transport sector - domestic aviation - energy use	Thousand tonnes	Norway	2020
Annual	Freight	Solid fossil fuels	Final consumption - transport sector - domestic aviation - energy use	Terajoule	Austria	2020
Annual	Freight	Solid fossil fuels	Final consumption - transport sector - domestic aviation - energy use	Terajoule	Bulgaria	2020
Annual	Freight	Solid fossil fuels	Final consumption - transport sector - domestic aviation - energy use	Terajoule	Denmark	2020
Annual	Freight	Solid fossil fuels	Final consumption - transport sector - domestic aviation - energy use	Terajoule	Ireland	2020


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

Share link

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