Road Motor Vehicle Traffic Performance By Traffic And Registration Location And Type Of Vehicle

Eurostat code: road_tf_vehmov · (2008 - 2023)

@eurostat.road_tf_vehmov

Table List

2 tables(44.12 KB)

Road Motor Vehicle Traffic Performance By Traffic And Registration Location And Type Of Vehicle - Raw

Road Motor Vehicle Traffic Performance By Traffic And Registration Location And Type Of Vehicle - Unpivoted

Road Motor Vehicle Traffic Performance By Traffic And Registration Location And Type Of Vehicle - Unpivoted

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

17.73 KB
1711 rows
7 columns

freq Freq	regisveh Regisveh	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Croatia	2008	306
Annual	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Lithuania	2008	518.3
Annual	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Passenger cars	Croatia	2008	19456
Annual	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Passenger cars	Lithuania	2008	8477.7
Annual	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Lorries and road trains	Croatia	2008	1946
Annual	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Lorries and road trains	Lithuania	2008	1971.3
Annual	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Motorcycles and mopeds	Croatia	2008	153
Annual	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Motorcycles and mopeds	Lithuania	2008	15.7
Annual	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Total	Croatia	2008	21861
Annual	Traffic performed on the national territory by vehicles registered in the reporting country or in foreign countries	Million vehicle-kilometres (VKM)	Total	Lithuania	2008	11034.8


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