Trainsets And Capacity By Type Of Speed

Eurostat code: rail_eq_trset · (2008 - 2023)

@eurostat.rail_eq_trset

Table List

2 tables(26.12 KB)

Trainsets And Capacity By Type Of Speed - Raw

Trainsets And Capacity By Type Of Speed - Unpivoted

Trainsets And Capacity By Type Of Speed - Unpivoted

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

8.44 KB
1374 rows
6 columns

freq Freq	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Denmark	2008	514
Annual	Number	Total	Greece	2008	727
Annual	Number	Total	Finland	2008	148
Annual	Number	Total	Croatia	2008	146
Annual	Number	Total	Italy	2008	395
Annual	Number	Total	Latvia	2008
Annual	Number	Total	Serbia	2008	78
Annual	Number	Total	Sweden	2008	541
Annual	Number	Total	Slovenia	2008	271
Annual	Number	Conventional trainsets	Denmark	2008	514


CREATE TABLE tidy (
  "freq" 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.