Locomotives And Railcars By Source Of Energy

Eurostat code: rail_eq_locon · (1990 - 2023)

@eurostat.rail_eq_locon

Table List

2 tables(73.15 KB)

Locomotives And Railcars By Source Of Energy - Raw

Locomotives And Railcars By Source Of Energy - Unpivoted

Locomotives And Railcars By Source Of Energy - Unpivoted

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

21.53 KB
5213 rows
7 columns

freq Freq	vehicle Vehicle	mot_nrg Mot Nrg	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Locomotives	Diesel	Number	Austria	1990	489
Annual	Locomotives	Diesel	Number	Belgium	1990	659
Annual	Locomotives	Diesel	Number	Bulgaria	1990	637
Annual	Locomotives	Diesel	Number	Switzerland	1990	277
Annual	Locomotives	Diesel	Number	Germany	1990	3417
Annual	Locomotives	Diesel	Number	Denmark	1990	366
Annual	Locomotives	Diesel	Number	Greece	1990	233
Annual	Locomotives	Diesel	Number	Spain	1990	694
Annual	Locomotives	Diesel	Number	Finland	1990	594
Annual	Locomotives	Diesel	Number	France	1990	3356


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

Share link

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