Number Of Railway Vehicles Per Type

Eurostat code: enps_rail_eq · (2005 - 2023)

@eurostat.enps_rail_eq

Table List

2 tables(22.56 KB)

Number Of Railway Vehicles Per Type - Raw

Number Of Railway Vehicles Per Type - Unpivoted

Number Of Railway Vehicles Per Type - Unpivoted

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

5.88 KB
285 rows
6 columns

freq Freq	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Number	Locomotives	Algeria	2005	245
Annual	Number	Locomotives	Israel	2005	74
Annual	Number	Locomotives	Jordan	2005	29
Annual	Number	Locomotives	Morocco	2005	209
Annual	Number	Locomotives	Tunisia	2005	174
Annual	Number	Passenger railway vehicles	Algeria	2005	454
Annual	Number	Passenger railway vehicles	Israel	2005	315
Annual	Number	Passenger railway vehicles	Jordan	2005	16
Annual	Number	Passenger railway vehicles	Morocco	2005	330
Annual	Number	Passenger railway vehicles	Tunisia	2005	274


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

Share link

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