Rail Equipment: Number And Load Capacity Of Goods Transport Wagons

Eurostat code: med_ra4 · (2005 - 2019)

@eurostat.med_ra4

Table List

2 tables(18.03 KB)

Rail Equipment: Number And Load Capacity Of Goods Transport Wagons - Raw

Rail Equipment: Number And Load Capacity Of Goods Transport Wagons - Unpivoted

Rail Equipment: Number And Load Capacity Of Goods Transport Wagons - Unpivoted

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

4.99 KB
82 rows
6 columns

freq Freq	vehicle Vehicle	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Goods wagons	Number	Algeria	2005	10119
Annual	Goods wagons	Number	Jordan	2005	337
Annual	Goods wagons	Number	Morocco	2005	5845
Annual	Goods wagons	Number	Tunisia	2005	3995
Annual	Goods wagons	Number	Algeria	2006	9998
Annual	Goods wagons	Number	Egypt	2006	11651
Annual	Goods wagons	Number	Israel	2006	719
Annual	Goods wagons	Number	Jordan	2006	328
Annual	Goods wagons	Number	Morocco	2006	6026
Annual	Goods wagons	Number	Tunisia	2006	3990


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

Share link

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