Road Traffic Performance By Traffic And Registration Location, Type Of Vehicle And Motor Energy (until 2012)

Eurostat code: road_tf_veh_h · (2005 - 2012)

@eurostat.road_tf_veh_h

Table List

2 tables(54.14 KB)

Road Traffic Performance By Traffic And Registration Location, Type Of Vehicle And Motor Energy (until 2012) - Raw

Road Traffic Performance By Traffic And Registration Location, Type Of Vehicle And Motor Energy (until 2012) - Unpivoted

Road Traffic Performance By Traffic And Registration Location, Type Of Vehicle And Motor Energy (until 2012) - Unpivoted

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

25.7 KB
3299 rows
8 columns

freq Freq	mot_nrg Mot Nrg	regisveh Regisveh	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Diesel	Traffic performed on the foreign territory by vehicles registered in the reporting country	Million vehicle-kilometres (VKM)	Passenger cars	Netherlands	2005	3928
Annual	Diesel	Traffic performed on the foreign territory by vehicles registered in the reporting country	Million vehicle-kilometres (VKM)	Goods road motor vehicles <= 3.5 tonnes	Netherlands	2005	690
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Passenger cars	Ireland	2005	6702
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Passenger cars	Latvia	2005	21773
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Passenger cars	Netherlands	2005	31886
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Passenger cars	Norway	2005	6211
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Passenger cars	Sweden	2005	6121
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Goods road motor vehicles > 3.5 tonnes	Latvia	2005	10902
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Goods road motor vehicles from > 3.5 to <= 6 tonnes	Ireland	2005	762
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Goods road motor vehicles from > 3.5 to <= 6 tonnes	Netherlands	2005	91


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

Share link

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