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

Eurostat code: rail_pa_intgong · (2004 - 2024)

@eurostat.rail_pa_intgong

Table List

2 tables(63.9 KB)

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

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

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

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

25.8 KB
7586 rows
7 columns

freq Freq	unit Unit	train Train	partner Partner	geo Geo	time_period Time Period	value Value
Annual	Thousand passengers	Total	Albania	Czechia	2004
Annual	Thousand passengers	Total	Albania	Romania	2004
Annual	Thousand passengers	Total	Austria	Belgium	2004	4
Annual	Thousand passengers	Total	Austria	Czechia	2004	101
Annual	Thousand passengers	Total	Austria	Germany	2004	1160
Annual	Thousand passengers	Total	Austria	Denmark	2004	22
Annual	Thousand passengers	Total	Austria	France	2004	17
Annual	Thousand passengers	Total	Austria	Croatia	2004	37
Annual	Thousand passengers	Total	Austria	Hungary	2004	237
Annual	Thousand passengers	Total	Austria	Italy	2004	244


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

Share link

Anyone who has the link will be able to view this.