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 - Raw

@eurostat.road_tf_road.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

35.56 KB
463 rows
18 columns

freq Freq	tra_infr Tra Infr	unit Unit	vehicle Vehicle	geo Geo	n_2011 2011	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023
Annual	Motorways	Million vehicle-kilometres (VKM)	Other buses and motor coaches	Latvia
Annual	Motorways	Million vehicle-kilometres (VKM)	Other buses and motor coaches	Norway		18	17	16	15	15	15	14				1
Annual	Motorways	Million vehicle-kilometres (VKM)	Other buses and motor coaches	Romania
Annual	Motorways	Million vehicle-kilometres (VKM)	Other buses and motor coaches	Slovenia				5	5	4	4	4	2
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Austria			128		152.109	156.059	162.011	169.711	61.563	69.481	118	146.517
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Belgium		154	159	163	161	165
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Estonia			96.6	95.7	100.5	102.1	104.56	88.9	101.667	111.02	115.86	114.64
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Spain			845	1074
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Hungary		80.54	74	84.07	96.6	110.94	110.52	117.41	72.65	83.36	90.39	93.93
Annual	Motorways	Million vehicle-kilometres (VKM)	Buses, motor coaches, and trolley buses	Italy	18752	16945				19163	19136


CREATE TABLE raw (
  "freq" VARCHAR,
  "tra_infr" VARCHAR,
  "unit" VARCHAR,
  "vehicle" VARCHAR,
  "geo" VARCHAR,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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