Road Traffic Performance By Category Of Vehicle Registration And Traffic, Type Of Vehicle And Motor Energy

Eurostat code: road_tf_veh · (2011 - 2023)

@eurostat.road_tf_veh

Table List

2 tables(91.5 KB)

Road Traffic Performance By Category Of Vehicle Registration And Traffic, Type Of Vehicle And Motor Energy - Raw

Road Traffic Performance By Category Of Vehicle Registration And Traffic, Type Of Vehicle And Motor Energy - Unpivoted

Road Traffic Performance By Category Of Vehicle Registration And Traffic, Type Of Vehicle And Motor Energy - Unpivoted

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

43.64 KB
6019 rows
8 columns

freq Freq	mot_nrg Mot Nrg	regisveh Regisveh	vehicle Vehicle	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Buses, motor coaches, and trolley buses	Million vehicle-kilometres (VKM)	Italy	2011	18752
Annual	Total	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Passenger cars	Million vehicle-kilometres (VKM)	Italy	2011	63605
Annual	Total	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Total	Million vehicle-kilometres (VKM)	Italy	2011	82357
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Passenger cars	Million vehicle-kilometres (VKM)	Austria	2013	38765
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Passenger cars	Million vehicle-kilometres (VKM)	Estonia	2013	3741
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Passenger cars	Million vehicle-kilometres (VKM)	Ireland	2013	14972
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Passenger cars	Million vehicle-kilometres (VKM)	Netherlands	2013	32183
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Passenger cars	Million vehicle-kilometres (VKM)	Norway	2013	18889
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Lorries from > 3.5 to <= 6 tonnes	Million vehicle-kilometres (VKM)	Estonia	2013	1113
Annual	Diesel	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Lorries from > 3.5 to <= 6 tonnes	Million vehicle-kilometres (VKM)	Norway	2013	162


CREATE TABLE tidy (
  "freq" VARCHAR,
  "mot_nrg" VARCHAR,
  "regisveh" 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.