Transit Transport Of Goods By Loading And Unloading Countries

Eurostat code: rail_go_trsorde · (2003 - 2024)

@eurostat.rail_go_trsorde

Table List

2 tables(285.93 KB)

Transit Transport Of Goods By Loading And Unloading Countries - Raw

Transit Transport Of Goods By Loading And Unloading Countries - Unpivoted

Transit Transport Of Goods By Loading And Unloading Countries - Unpivoted

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

146.61 KB
52762 rows
7 columns

freq Freq	unit Unit	c_load C Load	c_unload C Unload	geo Geo	time_period Time Period	value Value
Annual	Million tonne-kilometre (TKM)	United Arab Emirates	Kazakhstan	Finland	2003
Annual	Million tonne-kilometre (TKM)	Armenia	Austria	Slovakia	2003
Annual	Million tonne-kilometre (TKM)	Austria	Austria	Czechia	2003
Annual	Million tonne-kilometre (TKM)	Austria	Austria	Germany	2003
Annual	Million tonne-kilometre (TKM)	Austria	Austria	Slovakia	2003
Annual	Million tonne-kilometre (TKM)	Austria	Bosnia and Herzegovina	Hungary	2003
Annual	Million tonne-kilometre (TKM)	Austria	Bosnia and Herzegovina	Slovenia	2003	5
Annual	Million tonne-kilometre (TKM)	Austria	Belgium	Germany	2003	214
Annual	Million tonne-kilometre (TKM)	Austria	Bulgaria	Hungary	2003
Annual	Million tonne-kilometre (TKM)	Austria	Bulgaria	Slovenia	2003	4


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

Share link

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