National Road Traffic Performance By Type Of Vehicle And Type Of Road (until 2012)

Eurostat code: road_tf_road_h · (2005 - 2012)

@eurostat.road_tf_road_h

Table List

2 tables(42.38 KB)

National Road Traffic Performance By Type Of Vehicle And Type Of Road (until 2012) - Raw

National Road Traffic Performance By Type Of Vehicle And Type Of Road (until 2012) - Unpivoted

National Road Traffic Performance By Type Of Vehicle And Type Of Road (until 2012) - Unpivoted

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

19.41 KB
2139 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 and motor coaches	Czechia	2005	40
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses and motor coaches	Türkiye	2005	584
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses and motor coaches	United Kingdom	2005	471
Annual	Motorways	Million vehicle-kilometres (VKM)	Passenger cars	Czechia	2005	3694
Annual	Motorways	Million vehicle-kilometres (VKM)	Passenger cars	Ireland	2005	5311
Annual	Motorways	Million vehicle-kilometres (VKM)	Passenger cars	Türkiye	2005	6029
Annual	Motorways	Million vehicle-kilometres (VKM)	Passenger cars	United Kingdom	2005	72822
Annual	Motorways	Million vehicle-kilometres (VKM)	Motorcycles and mopeds	Czechia	2005	15
Annual	Motorways	Million vehicle-kilometres (VKM)	Motorcycles and mopeds	United Kingdom	2005	403
Annual	Motorways	Million vehicle-kilometres (VKM)	Total	Czechia	2005	5285


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.