Rail Infrastructure: Length Of Network

Eurostat code: med_ra1 · (2005 - 2019)

@eurostat.med_ra1

Table List

2 tables(16.79 KB)

Rail Infrastructure: Length Of Network - Raw

Rail Infrastructure: Length Of Network - Unpivoted

Rail Infrastructure: Length Of Network - Unpivoted

@eurostat.med_ra1.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.28 KB
97 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Kilometre	Algeria	2005	3572
Annual	Kilometre	Egypt	2005	5128
Annual	Kilometre	Israel	2005	896
Annual	Kilometre	Jordan	2005	622
Annual	Kilometre	Lebanon	2005
Annual	Kilometre	Morocco	2005	1907
Annual	Kilometre	Palestine*	2005
Annual	Kilometre	Tunisia	2005	1963
Annual	Kilometre	Algeria	2006	3572
Annual	Kilometre	Egypt	2006	5128


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

Share link

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