Railway Transport - National And International Railway Passengers Transport By Embarking/disembarking NUTS 2 Region

Eurostat code: tran_r_rapa · (2005 - 2020)

@eurostat.tran_r_rapa

Table List

2 tables(358.52 KB)

Railway Transport - National And International Railway Passengers Transport By Embarking/disembarking NUTS 2 Region - Raw

Railway Transport - National And International Railway Passengers Transport By Embarking/disembarking NUTS 2 Region - Unpivoted

Railway Transport - National And International Railway Passengers Transport By Embarking/disembarking NUTS 2 Region - Unpivoted

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

167.87 KB
39024 rows
7 columns

freq Freq	unit Unit	c_unload C Unload	c_load C Load	geo Geo	time_period Time Period	value Value
Annual	Passenger	Burgenland	Praha	Czechia	2005	10
Annual	Passenger	Burgenland	Jihovýchod	Czechia	2005	20
Annual	Passenger	Burgenland	Moravskoslezsko	Czechia	2005	10
Annual	Passenger	Burgenland	Stuttgart	Germany	2005	50
Annual	Passenger	Burgenland	Karlsruhe	Germany	2005	44
Annual	Passenger	Burgenland	Freiburg	Germany	2005	13
Annual	Passenger	Burgenland	Tübingen	Germany	2005	28
Annual	Passenger	Burgenland	Oberbayern	Germany	2005	112
Annual	Passenger	Burgenland	Niederbayern	Germany	2005	7
Annual	Passenger	Burgenland	Oberpfalz	Germany	2005	15


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

Share link

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