Tractive Power Of Locomotives And Railcars By Source Of Energy

Eurostat code: rail_eq_locop · (1990 - 2023)

@eurostat.rail_eq_locop

Table List

2 tables(67.45 KB)

Tractive Power Of Locomotives And Railcars By Source Of Energy - Raw

Tractive Power Of Locomotives And Railcars By Source Of Energy - Unpivoted

Tractive Power Of Locomotives And Railcars By Source Of Energy - Unpivoted

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

20.4 KB
3850 rows
7 columns

freq Freq	mot_nrg Mot Nrg	vehicle Vehicle	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Diesel	Locomotives	Megawatt	Austria	1990	268
Annual	Diesel	Locomotives	Megawatt	Belgium	1990	446
Annual	Diesel	Locomotives	Megawatt	Bulgaria	1990	721.6
Annual	Diesel	Locomotives	Megawatt	Switzerland	1990	95
Annual	Diesel	Locomotives	Megawatt	Germany	1990	1677
Annual	Diesel	Locomotives	Megawatt	Denmark	1990	327
Annual	Diesel	Locomotives	Megawatt	Greece	1990	340
Annual	Diesel	Locomotives	Megawatt	Spain	1990	1
Annual	Diesel	Locomotives	Megawatt	Finland	1990	415
Annual	Diesel	Locomotives	Megawatt	France	1990	1965


CREATE TABLE tidy (
  "freq" VARCHAR,
  "mot_nrg" VARCHAR,
  "vehicle" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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