National Road Traffic Performance By Type Of Vehicle And Type Of Road

Eurostat code: road_tf_road · (2011 - 2023)

@eurostat.road_tf_road

Table List

2 tables(64.5 KB)

National Road Traffic Performance By Type Of Vehicle And Type Of Road - Raw

National Road Traffic Performance By Type Of Vehicle And Type Of Road - Unpivoted

National Road Traffic Performance By Type Of Vehicle And Type Of Road - Unpivoted

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

28.93 KB
3557 rows
7 columns

freq Freq	tra_infr Tra Infr	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Italy	2011	18752
Annual	Motorways	Million vehicle-kilometres (VKM)	Passenger cars	Italy	2011	63605
Annual	Motorways	Million vehicle-kilometres (VKM)	Total	Italy	2011	82357
Annual	Motorways	Million vehicle-kilometres (VKM)	Passenger cars	Italy	2012	59078
Annual	Motorways	Million vehicle-kilometres (VKM)	Total	Italy	2012	76425
Annual	Motorways	Million vehicle-kilometres (VKM)	Other buses and motor coaches	Norway	2013	18
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Belgium	2013	154
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Hungary	2013	80.54
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Italy	2013	16945
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Norway	2013	68


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