Vehicle Traffic Performance By Type Of Tractive Vehicle And Source Of Energy (until 2012)

Eurostat code: rail_tf_vehimov · (1979 - 2012)

@eurostat.rail_tf_vehimov

Table List

2 tables(77.89 KB)

Vehicle Traffic Performance By Type Of Tractive Vehicle And Source Of Energy (until 2012) - Raw

Vehicle Traffic Performance By Type Of Tractive Vehicle And Source Of Energy (until 2012) - Unpivoted

Vehicle Traffic Performance By Type Of Tractive Vehicle And Source Of Energy (until 2012) - Unpivoted

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

29.09 KB
3701 rows
7 columns

freq Freq	vehicle Vehicle	mot_nrg Mot Nrg	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Locomotives	Diesel	Thousand vehicle-kilometres (VKM)	Belgium	1979	53867
Annual	Locomotives	Diesel	Thousand vehicle-kilometres (VKM)	Germany	1979	210431
Annual	Locomotives	Diesel	Thousand vehicle-kilometres (VKM)	Denmark	1979	31376
Annual	Locomotives	Diesel	Thousand vehicle-kilometres (VKM)	Greece	1979	10689
Annual	Locomotives	Diesel	Thousand vehicle-kilometres (VKM)	Spain	1979	56911
Annual	Locomotives	Diesel	Thousand vehicle-kilometres (VKM)	France	1979	165462
Annual	Locomotives	Diesel	Thousand vehicle-kilometres (VKM)	Italy	1979	42982
Annual	Locomotives	Diesel	Thousand vehicle-kilometres (VKM)	Luxembourg	1979	2481
Annual	Locomotives	Diesel	Thousand vehicle-kilometres (VKM)	Netherlands	1979	10895
Annual	Locomotives	Diesel	Thousand vehicle-kilometres (VKM)	Portugal	1979	15606


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.