International Transport Of Goods From The Loading Country To The Reporting Country (Monthly Data) (1982-2002)

Eurostat code: rail_go_intld · (1982 - 2002-10)

@eurostat.rail_go_intld

Table List

2 tables(487.53 KB)

International Transport Of Goods From The Loading Country To The Reporting Country (Monthly Data) (1982-2002) - Raw

International Transport Of Goods From The Loading Country To The Reporting Country (Monthly Data) (1982-2002) - Unpivoted

International Transport Of Goods From The Loading Country To The Reporting Country (Monthly Data) (1982-2002) - Unpivoted

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

121.78 KB
56250 rows
6 columns

freq Freq	unit Unit	c_load C Load	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes	Austria	Belgium	1982	41
Annual	Thousand tonnes	Austria	Germany	1982	1873
Annual	Thousand tonnes	Austria	Denmark	1982	28
Annual	Thousand tonnes	Austria	Greece	1982	24
Annual	Thousand tonnes	Austria	France	1982	110
Annual	Thousand tonnes	Austria	Italy	1982	1537
Annual	Thousand tonnes	Austria	Luxembourg	1982
Annual	Thousand tonnes	Austria	Netherlands	1982	82
Annual	Thousand tonnes	Belgium	Germany	1982	1975
Annual	Thousand tonnes	Belgium	Denmark	1982	39


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

Share link

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