Baselight
Sign In

Expenditure On Rolling Stock And Railway Infrastructure

Eurostat code: rail_ec_expend ยท (1990 - 2023)

@eurostat.rail_ec_expend

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

AnnualMillion euroExpenditure on infrastructureSweden19902886
AnnualMillion euroInvestment in infrastructureSweden19902094
AnnualMillion euroMaintenance in infrastructureFinland1990682
AnnualMillion euroInvestment in rolling stockSweden1990584
AnnualMillion euroMaintenance in rolling stockSweden19904980
AnnualMillion euroExpenditure on infrastructureSweden19913497
AnnualMillion euroInvestment in infrastructureSweden19912186
AnnualMillion euroMaintenance in infrastructureFinland1991702
AnnualMillion euroMaintenance in infrastructureSweden19911300
AnnualMillion euroExpenditure on rolling stockFinland1991955

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