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

Eurostat code: rail_pa_intcmng · (2004 - 2024)

@eurostat.rail_pa_intcmng

Table List

2 tables(66.15 KB)

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

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

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

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

26.73 KB
7921 rows
7 columns

freq Freq	unit Unit	train Train	partner Partner	geo Geo	time_period Time Period	value Value
Annual	Thousand passengers	Total	Albania	Romania	2004
Annual	Thousand passengers	Total	Austria	Belgium	2004	1
Annual	Thousand passengers	Total	Austria	Czechia	2004	38
Annual	Thousand passengers	Total	Austria	Germany	2004	975
Annual	Thousand passengers	Total	Austria	Denmark	2004	3
Annual	Thousand passengers	Total	Austria	France	2004	7
Annual	Thousand passengers	Total	Austria	Croatia	2004	28
Annual	Thousand passengers	Total	Austria	Hungary	2004	174
Annual	Thousand passengers	Total	Austria	Italy	2004	195
Annual	Thousand passengers	Total	Austria	Lithuania	2004


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.