Dataset: Goods And Passenger Train Traffic Performance

About this Dataset

Goods And Passenger Train Traffic Performance

This Eurostat dataset contains data on goods and passenger train traffic performance, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-06-05T23:00:00+0200

Tables

Goods And Passenger Train Traffic Performance - Raw

@eurostat.rail_tf_trainmv.raw

28.98 KB
108 rows
25 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "train" VARCHAR,
  "geo" VARCHAR,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "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,
  "n_2024" DOUBLE
);

Goods And Passenger Train Traffic Performance - Unpivoted

@eurostat.rail_tf_trainmv.tidy

16.98 KB
1807 rows
6 columns


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