Expenditure On Road Transport Vehicles And Road Infrastructure

Eurostat code: road_ec_invest · (1992 - 2023)

@eurostat.road_ec_invest

Table List

2 tables(56.37 KB)

Expenditure On Road Transport Vehicles And Road Infrastructure - Raw

Expenditure On Road Transport Vehicles And Road Infrastructure - Unpivoted

Expenditure On Road Transport Vehicles And Road Infrastructure - Unpivoted

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

18.64 KB
2045 rows
6 columns

freq Freq	unit Unit	expend Expend	geo Geo	time_period Time Period	value Value
Annual	Million euro	Expenditure on infrastructure	Denmark	1992	5083
Annual	Million euro	Expenditure on infrastructure	Finland	1992	5700
Annual	Million euro	Expenditure on infrastructure	Ireland	1992	32434
Annual	Million euro	Expenditure on infrastructure	Italy	1992	23465
Annual	Million euro	Expenditure on infrastructure	Romania	1992	461
Annual	Million euro	Investment in infrastructure	Denmark	1992	3595
Annual	Million euro	Investment in infrastructure	Finland	1992	3912
Annual	Million euro	Investment in infrastructure	Ireland	1992	1055
Annual	Million euro	Investment in infrastructure	Romania	1992	268
Annual	Million euro	Investment in infrastructure	Sweden	1992	6294


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "expend" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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