Goods Transported By Type Of Consignment

Eurostat code: rail_go_consgmt · (2003 - 2024)

@eurostat.rail_go_consgmt

Table List

2 tables(40.14 KB)

Goods Transported By Type Of Consignment - Raw

Goods Transported By Type Of Consignment - Unpivoted

Goods Transported By Type Of Consignment - Unpivoted

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

13.91 KB
2424 rows
6 columns

freq Freq	consign Consign	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Other	Million tonne-kilometre (TKM)	Sweden	2003
Annual	Other	Thousand tonnes	Sweden	2003
Annual	Total	Million tonne-kilometre (TKM)	Sweden	2003	20170
Annual	Total	Thousand tonnes	Sweden	2003	57874
Annual	Full train load	Million tonne-kilometre (TKM)	Sweden	2003	9767
Annual	Full train load	Thousand tonnes	Sweden	2003	38238
Annual	Unknown	Million tonne-kilometre (TKM)	Sweden	2003
Annual	Unknown	Thousand tonnes	Sweden	2003
Annual	Full wagon load	Million tonne-kilometre (TKM)	Sweden	2003	10403
Annual	Full wagon load	Thousand tonnes	Sweden	2003	19636


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

Share link

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