Dataset: Passenger Transport By Type Of Transport (detailed Reporting Only)

About this Dataset

Passenger Transport By Type Of Transport (detailed Reporting Only)

This Eurostat dataset contains data on passenger transport by type of transport (detailed reporting only), 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

Passenger Transport By Type Of Transport (detailed Reporting Only) - Raw

@eurostat.rail_pa_typepas.raw

43.38 KB
258 rows
25 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "tra_cov" 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
);

Passenger Transport By Type Of Transport (detailed Reporting Only) - Unpivoted

@eurostat.rail_pa_typepas.tidy

28.4 KB
4440 rows
6 columns


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