Baselight
Sign In

International Transport Of Passengers From The Reporting Country To The Country Of Disembarkation

Eurostat code: rail_pa_intgong · (2004 - 2024)

@eurostat.rail_pa_intgong

About this Dataset

International Transport Of Passengers From The Reporting Country To The Country Of Disembarkation

This Eurostat dataset contains data on international transport of passengers from the reporting country to the country of disembarkation, 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-17T23:00:00+0200

Tables

International Transport Of Passengers From The Reporting Country To The Country Of Disembarkation - Raw

@eurostat.rail_pa_intgong.raw
  • 38.36 KB
  • 774 rows
  • 26 columns
Loading...
 

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

International Transport Of Passengers From The Reporting Country To The Country Of Disembarkation - Unpivoted

@eurostat.rail_pa_intgong.tidy
  • 25.97 KB
  • 7653 rows
  • 7 columns
Loading...
 

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