Expenditure On Rolling Stock And Railway Infrastructure

Eurostat code: rail_ec_expend · (1990 - 2023)

@eurostat.rail_ec_expend

Table List

2 tables(66.77 KB)

Expenditure On Rolling Stock And Railway Infrastructure - Raw

Expenditure On Rolling Stock And Railway Infrastructure - Unpivoted

Expenditure On Rolling Stock And Railway Infrastructure - Unpivoted

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

22.83 KB
2760 rows
6 columns

freq Freq	unit Unit	expend Expend	geo Geo	time_period Time Period	value Value
Annual	Million euro	Expenditure on infrastructure	Sweden	1990	2886
Annual	Million euro	Investment in infrastructure	Sweden	1990	2094
Annual	Million euro	Maintenance in infrastructure	Finland	1990	682
Annual	Million euro	Investment in rolling stock	Sweden	1990	584
Annual	Million euro	Maintenance in rolling stock	Sweden	1990	4980
Annual	Million euro	Expenditure on infrastructure	Sweden	1991	3497
Annual	Million euro	Investment in infrastructure	Sweden	1991	2186
Annual	Million euro	Maintenance in infrastructure	Finland	1991	702
Annual	Million euro	Maintenance in infrastructure	Sweden	1991	1300
Annual	Million euro	Expenditure on rolling stock	Finland	1991	955


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.