Length Of Rail Lines, ENP-East Countries

Eurostat code: enpe_rail_if · (2005 - 2023)

@eurostat.enpe_rail_if

Table List

2 tables(18.9 KB)

Length Of Rail Lines, ENP-East Countries - Raw

Length Of Rail Lines, ENP-East Countries - Unpivoted

Length Of Rail Lines, ENP-East Countries - Unpivoted

@eurostat.enpe_rail_if.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.14 KB
54 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Kilometre	Armenia	2005	730
Annual	Kilometre	Azerbaijan	2005	2122
Annual	Kilometre	Belarus	2005	5518
Annual	Kilometre	Armenia	2006	730
Annual	Kilometre	Azerbaijan	2006	2122
Annual	Kilometre	Belarus	2006	5515
Annual	Kilometre	Armenia	2007	730
Annual	Kilometre	Azerbaijan	2007	2099
Annual	Kilometre	Belarus	2007	5514
Annual	Kilometre	Armenia	2008	732


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.