Final Energy Consumption In Road Transport By Type Of Fuel

Eurostat code: ten00127 · (2012 - 2023)

@eurostat.ten00127

Table List

2 tables(73.67 KB)

Final Energy Consumption In Road Transport By Type Of Fuel - Raw

Final Energy Consumption In Road Transport By Type Of Fuel - Unpivoted

Final Energy Consumption In Road Transport By Type Of Fuel - Unpivoted

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

32.69 KB
5760 rows
7 columns

freq Freq	nrg_bal Nrg Bal	siec Siec	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Final consumption - transport sector - road - energy use	Electricity	Thousand tonnes of oil equivalent	Albania	2012
Annual	Final consumption - transport sector - road - energy use	Electricity	Thousand tonnes of oil equivalent	Austria	2012	1.283
Annual	Final consumption - transport sector - road - energy use	Electricity	Thousand tonnes of oil equivalent	Belgium	2012	0.232
Annual	Final consumption - transport sector - road - energy use	Electricity	Thousand tonnes of oil equivalent	Bulgaria	2012	3.439
Annual	Final consumption - transport sector - road - energy use	Electricity	Thousand tonnes of oil equivalent	Cyprus	2012
Annual	Final consumption - transport sector - road - energy use	Electricity	Thousand tonnes of oil equivalent	Czechia	2012	5.933
Annual	Final consumption - transport sector - road - energy use	Electricity	Thousand tonnes of oil equivalent	Germany	2012	2.494
Annual	Final consumption - transport sector - road - energy use	Electricity	Thousand tonnes of oil equivalent	Denmark	2012
Annual	Final consumption - transport sector - road - energy use	Electricity	Thousand tonnes of oil equivalent	Estonia	2012	1.892
Annual	Final consumption - transport sector - road - energy use	Electricity	Thousand tonnes of oil equivalent	Greece	2012


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.